在将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