Our host :angry: (unnamed to protect their reputation) secured our /tmp & /var/tmp for us but broke mysql in the process.

Now, I have no idea what method they used to secure these dirs but nothing can connect to mysql.sock now. Here's the error:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/tmp/mysql.sock'

They need to create and link the sock file. They are going to have to go back in as root and fix it, without root you can do nothing. I sure hope they are able to secure some stuff better and not break it...

Well I'm root as well, and I've attempted to recreate the mysql.sock symlink - I'm just not having any success with it.

from /tmp, I tried ln -s /var/lib/mysql.sock

Should that not have done the trick?

check the permissions of /tmp it should be 1777

cd /
chmod 1777 tmp
cd /var
chmod 1777 tmp
/scripts/restartsrv_mysql
/scripts/restartsrv_mysql --check

That should set you straight.

Thanks for the help guys. I followed your steps exactly Zach, but no change. :(

What does
service mysql start

show ?

That's the weird part, mysql is running. So of course that shows nothing.

Okay.. lets do this. :D

cd /tmp
rm -f mysql.sock
cd /
chmod 1777 tmp
cd /var/tmp
rm -f mysql.sock
cd /var
chmod 1777 tmp
/scripts/restartsrv_mysql
/scripts/restartsrv_mysql --check

Try that. ;)

Look at the process name and/or the my.cnf to see where the sock file is stored. It is probably storing it as something wierd and the file is not linked to the generic sock file.

Thanks again Zach, but still nothing after trying those steps. :(

eth00, it's at /var/lib/mysql/mysql.sock

I appreciate the assistance guys - I'll keep trying as long as you have ideas for me. I'm so upset at our host right now I could spit bullets I think - and to think this is what they call Gold Managed Services!

If it will help I can post the steps the host's tech used to secure tmp & var/tmp - I have them logged (just in case something like this happened).

It won't help to paste them, they probably nuked /tmp but forgot save the files...

ln -s /var/lib/mysql/mysql.sock /var/tmp/mysql.sock

Argg... Linux gets me again. :bawling:

Originally posted by eth00
It won't help to paste them, they probably nuked /tmp but forgot save the files...

ln -s /var/lib/mysql/mysql.sock /var/tmp/mysql.sock

actually i prefer


ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
ln -s /tmp/mysql.sock /var/tmp/mysql.sock

Originally posted by LP-Trel
Argg... Linux gets me again. :bawling:

You and your bsd ;)

Originally posted by thelinuxguy
actually i prefer

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
ln -s /tmp/mysql.sock /var/tmp/mysql.sock

Awesome - that did it. I suspected it was symlink-related but I couldn't quite get it right when I tried.

Btw, when I tried your 2nd line it came back with 'ln: `/var/tmp/mysql.sock': File exists' . I assume that's because the first line did the right thing?

Thanks to all of you guys! I appreciate your time!

Originally posted by IIIBradIII
Awesome - that did it. I suspected it was symlink-related but I couldn't quite get it right when I tried.

Btw, when I tried your 2nd line it came back with 'ln: `/var/tmp/mysql.sock': File exists' . I assume that's because the first line did the right thing?

Thanks to all of you guys! I appreciate your time!

Yeah you can ignore the second line. Glad to see it works :)

when I reboot the server the mysql.sock file is distroy and get the coennection error ..

Please help with this issue