On Mon, 16 Dec 2013 10:51:54 +0100 Luigi Rosa lists@luigirosa.com wrote:
I have a server with a faulty power supply that resets the server every 4/5 hours.
While I wait for the supplier to change the PS, I am facing an issue with MySQL.
When the system comes back on, mysqld script starts the daemon, but the connections via /var/lib/mysql/mysql.sock don't work because MySQL doesn't delete and recreate the stale socket.
Apart from editing /etc/init.d/mysqld to force the deletion of a stale socket are there any other way to solve this issue?
Thank you un advance.
Ciao, luigi
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Hi,
As a *temporary* solution you could do the following:
# chkconfig mysqld off # nano /etc/rc.local Add at bottom: rm /var/lib/mysql/mysql.sock service mysqld start Now Save.
Next time the machine boots it should remove the sock file, and then start mysqld.
Once your PSU is fixed, remove those lines and run:
# chkconfig mysqld on
Job done! :-D
Hope this helps.
Kind Regards, Jake Shipton (JakeMS) GPG Key: 0xE3C31D8F GPG Fingerprint: 7515 CC63 19BD 06F9 400A DE8A 1D0B A5CF E3C3 1D8F