#1  
Old 3rd July 2012, 20:03
Disassembler Disassembler is offline
Junior Member
 
Join Date: Jul 2012
Posts: 19
Thanks: 2
Thanked 7 Times in 5 Posts
Default MySQL is down

Howdy,

I'm still fiddling with the install of my two-server cluster. There's supposed to be one mail and one web server, the former has the ISPConfig control panel installed and is working fine as far as I can see. However, in trying to debug why the other one won't join properly, I found the mail server's /var/log/ispconfig/ispconfig.log is filling up with "03.07.2012-17:40 - ERROR - MySQL is down! Rescue will not help!" messages. from the cron job The web interface works and I can log on to MySQL using the mysql client and the credentials from /usr/local/ispconfig/interface/lib/config.inc.php, so I'm at a loss why any part of ISPConfig would not be able to connect.
It would be interesting to get a backtrace for this, so unless someone can can tell me already what I'm doing wrong, maybe PHP can be coaxed to produce an execution log or something?
Reply With Quote
Sponsored Links
  #2  
Old 4th July 2012, 10:41
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
Default

Pleasee nsure that mysql is listening on localhost and accepting connections from localhost.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 4th July 2012, 20:56
Disassembler Disassembler is offline
Junior Member
 
Join Date: Jul 2012
Posts: 19
Thanks: 2
Thanked 7 Times in 5 Posts
 
Default

Quote:
Originally Posted by till View Post
Pleasee nsure that mysql is listening on localhost and accepting connections from localhost.
Aargh, I found it! This was my first thought too but thanks for making me check again.
Just for the archives:
As MySQL doesn't support listening on more than one socket it's either one interface or all of them. But especially in the light of recent DB-root exploits I didn't want to open it to the wild wild web, only to the internal management network that connects the vservers. So I put in an iptables rule:
Code:
iptables -A INPUT --protocol tcp --dport 3306 '!' --in-interface eth1 -j REJECT
And forgot about the lo interface. But when ispconfig didn't work, I tested with the mysql client:
Code:
mysql -hlocalhost -Ddbispconfig -uispconfig -pXXXXX
That worked fine.
Turns out mysql silently falls back to unix domain sockets if a connection to localhost fails---which is only visible if you use "prompt \p" to show the currently used port or socket or with netstat. m(
MySQL, I hate you!
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
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
Squirrelmail login failure Cracklefish Installation/Configuration 9 30th June 2010 20:38
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


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


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