#1  
Old 25th February 2009, 17:26
zucco zucco is offline
Junior Member
 
Join Date: Feb 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?
Reply With Quote
Sponsored Links
  #2  
Old 25th February 2009, 19:10
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 27th February 2009, 11:50
zucco zucco is offline
Junior Member
 
Join Date: Feb 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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!!!
Reply With Quote
Reply

Bookmarks

Tags
mysql connections

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 11:49
Problem on editing data on MySQL table satimis Server Operation 6 12th December 2008 01:52
Virtual Users And Domains With Postfix, Courier And MySQL - SASLauthd problem qtx HOWTO-Related Questions 7 22nd May 2007 19:19
postfix - MySQL connection problem epo Installation/Configuration 7 4th August 2006 21:49
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 03:53


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


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