[imp] database connection problems
Steve Hideg
hideg@saintmarys.edu
Mon, 15 Apr 2002 17:11:34 -0500
Hello,
Forgive me if this has already been discussed. I searched FAQs and
list archives to no avail.
Our IMP installation is exhibiting some strange behavior. This just
started yesterday:
* Users have been seeing an error message stating "Warning: Too many
connections in /usr/local/apache-ssl/php/db_mysql.inc on line 73
Database error: pconnect(localhost, hordemgr, $Password) failed.
MySQL Error: ()
Session halted."
I did a SHOW PROCESSLIST; command in mysql and the number of
processes was maxed out at 100. I restarted mysqld with
--max_connections=200 and 500, and in both cases, the number of
connections maxed out again.
* Now, whenever I try to connect to our IMP client, the browser just
sits there, waiting for a response from the server.
Though I don't know PHP, I did manage to trace the problem to a line
in index.php3 with following code: page_open(array('sess'=>
'HordeSession'));
Now, we do have the HordeSession class apparently properly defined in
local.inc.
I pointed my browser to our test.php3 page, and that came up fine,
until I clicked on the "Click here to test PHPLIB for Horde" link.
Then the browser again just spins its wheels, waiting for a response
from the server. That link also invokes a page_open call.
If you'd like to see for yourself, go to:
<https://www.saintmarys.edu:8888/horde/test.php3>
Any insight anybody can offer would be greatly appreciated. The
students are getting restless...
Thanks.
++Steve
--
_________________________________________________________________________
Steve Hideg
Technical Support Specialist, Saint Mary's College, Notre Dame IN
<hideg@saintmarys.edu>
_________________________________________________________________________
It's never too late to panic.