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?
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.
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!!!