mysql max connections problem

Discussion in 'Installation/Configuration' started by zucco, Feb 25, 2009.

  1. zucco

    zucco New Member

    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?
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
  3. zucco

    zucco New Member

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

Share This Page