HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   mysql max connections problem (http://www.howtoforge.com/forums/showthread.php?t=31779)

zucco 25th February 2009 17:26

mysql max connections problem
 
Hi,
I have a big problem with mysql and ispconfig:
Yesterday I created a new virtual machine with vmware server 2 and installed
debian lenny with ispconfig.
I left the server active with only one or two virtual mail users and no connection to internet.
This morning the server was down and I couldn't log in with ispconfig because of a mysql error. I restart the vm and the server came back to life...
I watched the connections to mysql and I noticed that every minute a new "ispconfig user" starts a new connection to the db without stopping it, never!
So after a couple of hours mysql reaches the max connection limit and the server stops to work.
What can I do?

till 25th February 2009 19:10

I run a production server with ispconfig as mail server and I dont got a max connection problem. Take a look in the mysql log to see which sql queries are assosiated with this. I'am sure that these connections are not from ispconfig itself, they might be from postfix which also connects with the database user named ispconfig.

zucco 27th February 2009 11:50

Hi,
I tried to rebuild the virtual machine following the tutorial but keep having the same problem.
How can I stop this? I suppose is postfix the cause of the connections but I don't now how to stop it!!!


All times are GMT +2. The time now is 03:35.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.