MySQL, FTP, BIND Services won't start

bmcclure

Well-Known Member
Apr 12, 2003
191
0
241
Racine, WI
All of a sudden today MySQL crashed. When I found out, i went to WHM and tried to restart, all I get is:

mysql has failed, please contact the sysadmin (result was "/usr/bin/mysqlshow: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"). Sep 8 09:46:35 three mysql: Killing mysqld with pid 1071 Sep 8 09:46:36 three mysql: Wait for mysqld to exit\c Sep 8 09:46:37 three mysql: .\c Sep 8 09:46:38 three mysql: .\c Sep 8 09:46:39 three mysql: done Sep 8 09:46:39 three rc: Stopping mysql: succeeded Sep 9 11:39:29 three mysql: safe_mysqld Sep 9 11:39:29 three mysql: mysqld Sep 9 11:39:29 three mysql: mysqld_safe Sep 9 11:39:29 three mysql: mysqld Sep 9 11:39:29 three rc: Stopping mysql: failed Sep 9 11:42:06 three rc: Starting mysql: succeeded Sep 9 12:04:35 three rc: Starting mysql: succeeded
So I checked out the /tmp/mysql.sock file and it was a sym link to a non-existant mysql.sock file in the /var/lib/mysql directory. I don't know where this file went...

I ran the fixeverything and fixmysql scripts to no avail, I tried command line options for restartign mysql to no avail. I ended up rebooting the computer.

Ever since my reboot, now proftpd and named won't start.


Something odd I noticed was I used to restart named from the command line with "service named restart" but now restart isn't an option, only stop and start. Why would that be?

Thank you in advance, this is affecting tons of customers and has been going on since this morning.

cPanel.net Support Ticket Number:
 

mind-field

Active Member
Sep 28, 2002
42
0
156
Hello,

Have you received a resolution for this? If so, what was it?

Thanks and God Bless!

David Garza
 

bmcclure

Well-Known Member
Apr 12, 2003
191
0
241
Racine, WI
The resolution for the MySQL problem was to use the Change Root Password for MySQL feature in WebHost manager, as odd as that may seem...

I never found a resolution for the BIND issue, but we ended up using external nameservers anyway.