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/
