-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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
- --
/
+--[Luigi Rosa]--
\
Microsoft may issue tablets by Christmas. No word yet on whether
they'll contain potassium cyanide or saxitoxin.
--fark.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iEYEARECAAYFAlKuzTMACgkQ3kWu7Tfl6ZRW6gCfaU56Jcayg7TfZU9b0vTkTJXs
m7EAoM7ROhaRk+x+3C0+ygi/Xk+2PKke
=BWy2
-----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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
- --
/
+--[Luigi Rosa]--
\
Microsoft may issue tablets by Christmas. No word yet on whether
they'll contain potassium cyanide or saxitoxin.
--fark.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iEYEARECAAYFAlKuzTUACgkQ3kWu7Tfl6ZTV8wCfdFrw937bBokoy3MPcIRy3Qd+
fWMAn1/fEyC6LBZp/0kHHzByqg8nFRP3
=jV5r
-----END PGP SIGNATURE-----
On Mon, 16 Dec 2013 10:51:54 +0100 Luigi Rosa <lists at 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 at centos.org > http://lists.centos.org/mailman/listinfo/centosHi, 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