Page 1 of 1

Database errors

Posted: Mon Feb 14, 2005 4:42 pm
by karlovac
Hi all

I'm running s9y on a shared host (although I actually own the box itself, so I have root access), and the mysql server keeps going down.

Symptoms are that when I visit any page under the s9y directory, I see:
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/blog/serendipity_db_mysql.inc.php on line 96

Warning: mysql_select_db(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/blog/serendipity_db_mysql.inc.php on line 97

Warning: mysql_select_db(): A link to the server could not be established in /var/www/html/blog/serendipity_db_mysql.inc.php on line 97
DATABASE_ERROR
Logging into the host and restarting the mysqld server solves the problem.

mysqld appears to continue to work for *other* user accounts.

There's nothing (at all) in /var/log/mysqld.log

-Antun

Re: Database errors

Posted: Mon Feb 14, 2005 6:06 pm
by garvinhicking
Try to let Serendipity connect via TCP/IP to 127.0.0.1 instead of localhost. Looks like you're having socket problems.

Regards,
Garvin

Posted: Wed Feb 16, 2005 7:22 am
by karlovac
I've changed the config file to use 127.0.0.1. It's working OK, and no errors so far.

Thanks!

-Antun