Centos
添加訂閱時出現 Plesk 錯誤:ODBC 錯誤 #08S01 無法連接到本地 MySQL
在添加新訂閱後立即使用官方 MySQL 儲存庫將 MySQL更新到 5.6(Plesk 11.5,全新安裝)後,我收到此錯誤。
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
但是數據庫似乎工作正常,我可以在 Settings -> Database Servers 下毫無問題地訪問 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
安裝的庫(注意:我手動創建了符號連結
/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
我非常感謝任何幫助。
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock