#1  
Old 29th October 2013, 11:10
chief chief is offline
Member
 
Join Date: Nov 2008
Location: Barry. UK
Posts: 58
Thanks: 3
Thanked 2 Times in 2 Posts
Default ispconfig locks

Hi,

the last few months occasionally my ispconfig 3 system 3.0.5.3 has been locking up.
I have checked /var/log/messages

It happened again this morning, i have narrowed it down to 05.55.32am this is the excerpt:
Quote:
Oct 29 05:55:31 thor3 pure-ftpd: (?@125.118.220.142) [INFO] New connection from 125.118.220.142
Oct 29 05:55:32 thor3 pure-ftpd: (?@125.118.220.142) [ERROR] The SQL server seems to be down [Too many connections]
Oct 29 05:55:37 thor3 pure-ftpd: (?@125.118.220.142) [WARNING] Authentication failed for user [co.uk]
Oct 29 05:55:38 thor3 pure-ftpd: (?@125.118.220.142) [INFO] Logout.
Oct 29 05:55:38 thor3 pure-ftpd: (?@125.118.220.142) [INFO] New connection from 125.118.220.142
Oct 29 05:55:39 thor3 pure-ftpd: (?@125.118.220.142) [ERROR] The SQL server seems to be down [Too many connections]
Oct 29 05:55:43 thor3 pure-ftpd: (?@125.118.220.142) [WARNING] Authentication failed for user [co.uk]
Oct 29 05:55:44 thor3 pure-ftpd: (?@125.118.220.142) [INFO] Logout.
Oct 29 05:55:48 thor3 pure-ftpd: (?@125.118.220.142) [INFO] New connection from 125.118.220.142
Oct 29 05:55:49 thor3 pure-ftpd: (?@125.118.220.142) [ERROR] The SQL server seems to be down [Too many connections]
Oct 29 05:55:54 thor3 pure-ftpd: (?@125.118.220.142) [WARNING] Authentication failed for user [co.uk]
Oct 29 05:55:54 thor3 pure-ftpd: (?@125.118.220.142) [INFO] Logout.
Oct 29 05:55:55 thor3 pure-ftpd: (?@125.118.220.142) [INFO] New connection from 125.118.220.142
Oct 29 05:55:56 thor3 pure-ftpd: (?@125.118.220.142) [ERROR] The SQL server seems to be down [Too many connections]
Oct 29 05:55:59 thor3 pure-ftpd: (?@125.118.220.142) [WARNING] Authentication failed for user [co.uk]
Oct 29 05:55:59 thor3 pure-ftpd: (?@125.118.220.142) [INFO] Logout.
Oct 29 05:56:03 thor3 pure-ftpd: (?@125.118.220.142) [INFO] New connection from 125.118.220.142
Oct 29 05:56:03 thor3 pure-ftpd: (?@125.118.220.142) [ERROR] The SQL server seems to be down [Too many connections]
Oct 29 05:56:07 thor3 pure-ftpd: (?@125.118.220.142) [WARNING] Authentication failed for user [co.uk]
Oct 29 05:56:08 thor3 pure-ftpd: (?@125.118.220.142) [INFO] Logout.
The logs carry on, but the sites with databases wouldnt load as not sql server running.
i have traced the ip to china and its not the first time this has happened, is there anything i can do to stop this from happening


dave
Reply With Quote
Sponsored Links
  #2  
Old 29th October 2013, 13:11
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,446
Thanks: 813
Thanked 5,213 Times in 4,088 Posts
Default

The mysql connection limit has been reached. Edit the mysql my.cnf file and set:

max_user_connections = 500
max_connections = 500

in the [mysqld] section and restart mysql.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 29th October 2013, 17:24
chief chief is offline
Member
 
Join Date: Nov 2008
Location: Barry. UK
Posts: 58
Thanks: 3
Thanked 2 Times in 2 Posts
 
Default

thanks till,

thanks

have done and restarted mysqld

dave
Reply With Quote
Reply

Bookmarks

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
ISPConfig 3 - MultiServer Setup - With Dedicated Control Panel - How? SuperJC Installation/Configuration 4 16th October 2012 20:03
around 80 sleeping connections created by ISPConfig bkilinc General 2 1st October 2012 16:12
Control Panel - E-mail Tab is empty domi-nik General 15 14th April 2011 18:17
chroot SSH IspConfig2 kextra1 General 4 20th January 2011 18:41
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16


All times are GMT +2. The time now is 18:38.


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