> how can i check its not a connection timeout problem?
If your query takes longer than
# Timeout: The number of seconds before receives and sends time out.
Timeout 300
in the httpd.conf file the connection is closed by the server. But this is
rather inprobable I think; you could run the db query from the mysql command
line to see how long it takes.
Or (while the browser seems to hang)
$ mysqladmin -u root -p processlist;
to see the status of all mysql processes
or
$ mysqladmin -u root -p status;
$ mysqladmin -u root -p extended-status;
to get status information about mysql.
> is there a very basic example online of DBI under mod perl?
I think so... and the man page contains examples (perldoc DBI).
I'm not a mysql or DBI guru, but I never had problems with it.
If you check all DBI actions for errors (as recommended by others), and your
query is ok from the mysql command line, then maybe something is wrong with
some installation.
An easy quick and dirty way to find out where your code stucks is by putting
warns (go to the error log) or prints (go to browser) after every statement
in the code.
I don't think that I can provide more help (if at all I provided any)
hth,
joe
> At 04:31 a.m. 6/02/2006, John Doe wrote:
> >Jonathan Vanasco am Sonntag, 5. Februar 2006 00.27:
> > > Try:
> > >
> > > my $dbArgs = { RaiseError => 1, AutoCommit => 0 , TraceLevel => 3 };
> > > my $dbh = DBI->connect( $db, $dbUser, $dbPass , $dbArgs );
> > >
> > > while you `tail -f` the errorlog ( /usr/local/apache2/log/error_log
> > > on my system )
> > >
> > > the tracelevel will show you exactly what's going on within DBI.
> > >
> > > On Feb 4, 2006, at 5:40 PM, Derek Robson wrote:
> > > > that did not help, still no errors, still not good output.
> >
> >Derek,
> >
> >if the source of the erroneous behaviour is not detected, you could try
> > (as a workaround only...) to store the query result in a variale and
> > print all at ounce at the end... but this surely would not be "the
> > solution".
> >
> >You don' hit the connection timeout during the db query, do you?
> >
> >hth,
> >joe
> >
> >
> >
> >--
> >No virus found in this incoming message.
> >Checked by AVG Free Edition.
> >Version: 7.1.375 / Virus Database: 267.15.2/251 - Release Date: 4/02/2006
