Topic: MySQL errors on WebMail access

[brad]

Any idea what could be causing this?
________________________________________
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
______________________________________
Everything else seems to be working fine. It's 4.1b3.

brad

[Dan Brown]

Perhaps MySQL isn't running?  Try logging in as root and doing "service mysqld status".

OBTW, discussion of beta releases should be only on the devinfo mailing list.

[CharlieS]

I needed to create a MySQL configuration file /etc/my.cnf with the following contents:

[client]
socket=/tmp/mysql.sock

[mysqld]
socket=/tmp/mysql.sock

This seemed to correct the problem (most of the time anyway). This information was taken from the following documentation concerning KMySql found at http://www.ksql.org/doc/index.html#6.

[CharlieS]

Something that I missed in my previous post. The file php.ini also needs to be changed to point to /tmp/mysql.sock rather than the default /var/lib/mysql/mysql.sock. Note that this should be changed in the templates directory not directly in /etc.