ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/*mysqld/mysqld.sock' (2)
Hi I have a problem while installing koha on a machine (i install with debian package) I have this message "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/*mysqld/mysqld.sock' (2)" What i don't understand is
mysql well running
$ service mysql status /usr/bin/mysqladmin Ver 8.42 Distrib 5.1.49, for debian-linux-gnu on x86_64 Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.1.49-3 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 2 min 12 sec Threads: 2 Questions: 842 Slow queries: 0 Opens: 135 Flush tables: 1 Open tables: 32 Queries per second avg: 6.378.
no problem when i restart
$ service mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables.. But, the problem could come from that $locate libmysqlclient.so /usr/lib/libmysqlclient.so.16 /usr/lib/libmysqlclient.so.16.0.0 As the debian package include mysql-server5.1, there may be a conflict. How can i fix this problem? best regards samuel
Samuel Desseaux schreef op ma 24-09-2012 om 17:19 [+0200]:
I have this message "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/*mysqld/mysqld.sock' (2)"
is that '*' really there? Because it seems like a strange thing to have. Also, does the file '/var/run/mysqld/mysqld.sock' exist?
$locate libmysqlclient.so /usr/lib/libmysqlclient.so.16 /usr/lib/libmysqlclient.so.16.0.0
This is normal, my servers say the same thing. Can you try 'sudo koha-mysql instancename' to see if that works? Also try it manually: mysql -ukoha_instancename -p koha_instancename (replacing instancename above with the name of your instance.)
-- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
Le 25/09/2012 01:59, Robin Sheat a écrit :
Samuel Desseaux schreef op ma 24-09-2012 om 17:19 [+0200]:
I have this message "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/*mysqld/mysqld.sock' (2)" is that '*' really there? Because it seems like a strange thing to have.
yes, it was, i've found this and delete. Now, all is ok.
many thanks
participants (2)
-
Robin Sheat -
Samuel Desseaux