Hello,
Thanks for your comments, Tom
On Apache error_log appers the same error that is showed on the Web front
end:
DBD::mysql::db selectrow_arrayref failed: MySQL server has gone away at
/usr/lib/perl5/site_perl/5.8.5/handlers/ticket.pm line 2
This is my auth module and I see this error when it try to enter to the Web
front end
My application has two parts : One part collects stats and make reads/writes
on MySQL database and this procedure neves fails; so mysql is running. The
other part of the application is the one using a Web front end, therefore
the need for the connection from Apache to MySQL, but then apache says:
"MySQL server has gone away"
I'm using Apache::DBI but I'm not sure if it is working fine. First when I
compile and install this module, it shows that everything is fine including
tests (I'm using modperl2), but when I put Apache::DBI on startup.pl to init
my virtualhost with modperl it says :
"Apache.pm is not loaded."
I create Apache.pm like this:
package Apache;
1;
And then this error disappear, but I'm not sure if this horrible patch is
the reason of this failure. By the way, I don't have a clue on how to detect
if Apache::DBI is working or not ...
Now, because of this error I have tried removing Apache::DBI for my Web
front end, and from yesterday afternoon until now it works (I'm totally sure
that I'm closing each session explicity, so that shouldn't be the problem
...
Is Apache::DBI really helpful (if it's running in the same machine I'm
running MySQL) ?
How can I correctly configure Apache::DBI for Fedora Core 3 apache/modperl
rpm distribution ?
How can I configure debug mode for DBI in modperl applications and where can
I see the messages log ? Any suggestions ?
Thanks,
___________________________________
Ing. Alejandro Galue.
SYNC Consultores C.A.
[EMAIL PROTECTED]
http://www.sync.com.ve
Telf. : +58 (212) 762-85-55
762-30-12
762-86-93
Cel. : +58 (414) 134-47-23
Fax. : +58 (212) 762-66-71
Skype : agalue
MSN : [EMAIL PROTECTED]
___________________________________
-----Original Message-----
From: Tom Schindl [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 09, 2005 6:01 PM
To: Alejandro Galue
Cc: modperl@perl.apache.org; Arturo Martín
Subject: Re: Problem with apache and mysql
Are there any messages in the Apache-Errorlog or in the one of MySQL.
Maybe you are opening connections and don't close them, ... . You could also
run the DBI in Debugging mode. Do you use Apache::DBI?
Tom
Alejandro Galue wrote:
>
>
>Hello All,
>
>I'm using Fedora Core 3 with this packages version (RPM):
>
>httpd-2.0.52-3.1
>mod_perl-1.99_16-3
>perl-DBI-1.40'5
>perl-DBD-MySQL-2.9004-4
>libdbi-0.6.5-10
>libdbi-dbd-mysql-0.6.5-10
>mysql-4.1.9-1
>mysql-server-4.1.9-1
>mysqlclient10-3.23.58-4
>
>I downloaded source rpm for Mysql from fedora-development and rebuild
>on a updated fedora core 3.
>
>I have an application that run a script to read and modify mysql (this
>part works great), and the web interface for this application. This web
>interface
>
>was created totally with mod_perl.
>
>After a certain amount of time, it cannot be possible to use the
>database frontend via web becase it cannot connect to database. This
>problem appears when we run the application in a limited RAM machine -
>128 - 256MB; before that we have never experience the problem. It has
>been working ok in HW with RAM between 386MB and 512MB RAM.
>
>I can enter to database manually and check status and mysql is up; but
>I need to restart apache to have the Web front-end working properly again.
>
>After some hours the failure shows up again.
>
>Anyone have any idea of what is happening here ?
>
>My guest is : the problem should be related to perl-DBI or mod_perl or
>maybe the configuracion of modperl or mysql. My questions in this case:
>
>- Does it sound like the place to look for the problem ?
>- Any tips on how to turn on the debugging on this components ? How to
>figure out which one is responsible for the failure and why ?
>
>Thanks in advance,
>Alejandro Galue.
>
>
>
>
>
>
