Topic: MySQL.SOCK problems

[Dave]

Attempting to access webmail returns the following:

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in
/home/httpd/horde-phplib/db_mysql.inc on line 73

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in
/home/httpd/horde-phplib/db_mysql.inc on line 73

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in
/home/httpd/horde-phplib/db_mysql.inc on line 73


Attempting to start MySQL using 'mysql start' at the console returns the following:

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)


Any advice greatly appreciated.

Dave

[Dan Brown]

Instead of "mysql start", try "service mysql start".  Sounds like, for some reason, MySQL isn't running.

[Dave]

Thanks for the thought, Dan.

You're right, I am sure MySQL is not running - for whatever reason.

Console entry of "mysql" returns:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Console entry of "service mysql start" returns:
mysql: unrecognized service

Console entry of "service mysqld status" returns:
mysqld (pid 5290 5289 5281) is running...

Time to get schooled up on MySQL, I guess.  Still, I'm getting schooled up on Linux, e-smith and a truckload of other things, so why not one more?

Cheers,
Dave

P.S.  Anybody who can provide some help for my "schooling" would still be greatly appreciated...

[Dan Brown]

Actually, that should have been "service mysqld start"--my mistake.  Sounds like it's running, though.  Try "service mysqld restart"; maybe something wierd happened to the socket file.  I'm just guessing here, though...

[Dave]

Thanks again, Dan

Still no joy, I'm afraid.

"service mysqld restart" at the console produced:
Stopping MySQL:                                            [ FAILED ]
Starting MySQL:                                            [   OK   ]

Then the same problems when trying to access webmail.

Just as a curiousity, I tried to find the mentioned file:
'/var/lib/mysql/mysql.sock'
to no avail!  Nowhere on the system.

So now I have a better idea (I think) about WHY it is failing, but I have no idea at all why the mysql.sock file should be missing.  If I can ever connect to the mysql.com site (I think they've been having problems...) I will get hold of some doco and see what I can see.

Cheers,
Dave.