Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Dave on August 15, 2001, 07:36:40 PM

Title: MySQL.SOCK problems
Post by: Dave on August 15, 2001, 07:36:40 PM

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

Title: Re: MySQL.SOCK problems
Post by: Dan Brown on August 16, 2001, 02:56:28 AM

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

Title: Re: MySQL.SOCK problems
Post by: Dave on August 16, 2001, 04:53:38 PM

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...

Title: Re: MySQL.SOCK problems
Post by: Dan Brown on August 17, 2001, 05:53:09 AM

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...

Title: Re: MySQL.SOCK problems
Post by: Dave on August 20, 2001, 06:48:01 PM

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.