添加订阅时出现Plesk错误:ODBC错误#08S01无法连接到本地MySQL

在将MySQL更新到5.6(Plesk 11.5,全新安装)后,在添加新的订阅之后,使用官方的MySQL存储库 ,出现这个错误。

Internal error: ODBC error #08S01: [unixODBC][MySQL][ODBC 5.3(w) Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Message ODBC error #08S01: [unixODBC][MySQL][ODBC 5.3(w) Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) File aps_php.php Line 11933 Type Exception 

但数据库似乎工作正常,我可以访问phpMyAdmin没有问题下设置 – >数据库服务器。 使用Remi存储库的PHP 5.5。

 # yum list installed | grep -i mysql mysql-community-client.x86_64 5.6.17-4.el6 @mysql56-community mysql-community-common.x86_64 5.6.17-4.el6 @mysql56-community mysql-community-libs.x86_64 5.6.17-4.el6 @mysql56-community mysql-community-libs-compat.x86_64 5.6.17-4.el6 @mysql56-community mysql-community-release.noarch el6-5 installed mysql-community-server.x86_64 5.6.17-4.el6 @mysql56-community mysql-connector-odbc.x86_64 5.3.2-1.el6 @mysql-connectors-community perl-DBD-MySQL.x86_64 4.013-3.el6 @base php-mysqlnd.x86_64 5.5.11-1.el6.remi @remi-php55 

安装库(注意:我手动创build了符号链接/usr/lib64/libmyodbc5.so因为缺席):

 # ls -l /usr/lib64/ | grep -i myodbc -rwxr-xr-x. 1 root root 4294072 Mar 27 15:41 libmyodbc5a.so lrwxrwxrwx. 1 root root 25 May 2 14:43 libmyodbc5.so -> /usr/lib64/libmyodbc5w.so -rwxr-xr-x. 1 root root 4292472 Mar 27 15:41 libmyodbc5w.so 

/etc/odbcinst.ini内容:

 [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/psqlodbc.so Setup = /usr/lib/libodbcpsqlS.so Driver64 = /usr/lib64/psqlodbc.so Setup64 = /usr/lib64/libodbcpsqlS.so FileUsage = 1 [MySQL] Description = MySQL driver for Plesk Driver = /usr/lib64/libmyodbc5.so Setup = FileUsage = 1 Driver64 = /usr/lib64/libmyodbc5.so Setup64 = UsageCount = 1 [MySQL ODBC 5.3 Unicode Driver] Driver = /usr/lib64/libmyodbc5w.so UsageCount = 1 [MySQL ODBC 5.3 ANSI Driver] Driver = /usr/lib64/libmyodbc5a.so UsageCount = 1 

任何帮助,我非常感谢。

哇。 刚刚讨论昨天https://stackoverflow.com/questions/23428301/correct-way-of-updating-php-mysql-on-a-running-plesks- 5-5server :

 ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock