am i lost..... what's this.... why....

[DevilsMania.com]

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./admin/db_mysql.php on line 40

at
http://forum.devilsmania.com


:( i am so sad it's 3 days it's out and nobody helps me...

it's an error of some php codes ? or of the Server config...

[shri]

Bring the server down ... delete the file and reboot. Does that work?

[DevilsMania.com]

argh the problem is that who updates the server comes online 1-2 x week.... and so... have to wait and wait...

but what file should be that ? the database ? and if deleted what am i gonna lose ? [i don't wanna lose any users or message posted]

..
thnx

[shri]

It is the socket through which communications are established with the server.

If you know how to check attributes make sure that the directory (and the ones above it are chmod'ed to 755) so that apache (which runs under a different user than mysql) can read / execute through the socket.

[DevilsMania.com]

which directory should be that exactly ?
..
tnx

[DevilsMania.com]

if u mean that
/var/lib/mysql
socket thing..
i checked it and seems setted on 755 chmod...

[shri]

Sorry .. should be 777

Check two things.

a) Your phpinfo(); page should show the following variable

MYSQL_SOCKET /var/lib/mysql/mysql.sock

b) The /var/lib/mysql directory is 777 and so is the mysql.sock file.

[DevilsMania.com]

hey ... this is what my phpinfo contains:

<?php

phpinfo();

?>



***
about the other things they are all at 755

...
?
...
tnx

[shri]

Ok. That should be read .. the output of PHPInfo. That should have the same path for mysql.sock as your server.

Try them at 777 (mysql processes need to be written to).

[DevilsMania.com]

HEY .. we reinstalled everything now....

http://forum.devilsmania.com

thanks for your great info :)