Database errors

[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

[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

[karlovac]

I've changed the config file to use 127.0.0.1. It's working OK, and no errors so far.

Thanks!

-Antun