Thanks a lot Gokul !!
I created a handler to create a connection to database, process data (using
other modules that this main modle load) and then I close each connection
created (I'm sure each connection is closed)
I'm using Apache::DBI but I'm not sure if I correctly configure it.
Considering that both (Apache & MySQL) are on the same machine, yesterday I
removed Apache::DBI and it has not fail until now ... it is maybe a matter
of time to see the error again ...
Do you know how to debug Apache::DBI in this situations ?
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: Gokul P. Nair [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 09, 2005 6:51 PM
To: Alejandro Galue; modperl@perl.apache.org
Cc: Arturo Martmn
Subject: Re: Problem with apache and mysql
My suggestion would be to use Apache::DBI too if ur not already doing so. my
guess is that the database handles open by DBI (not to be mistaken for
Apache::DBI) might remain open eventually leading to inability to access
mysql anymore.
hope that helps.
Gokul
--- Alejandro Galue <[EMAIL PROTECTED]> 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.
>
>
>
>
__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/
