[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.