Centos

添加訂閱時出現 Plesk 錯誤:ODBC 錯誤 #08S01 無法連接到本地 MySQL

  • May 4, 2014

在添加新訂閱後立即使用官方 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

我非常感謝任何幫助。

哇。昨天剛剛討論https://stackoverflow.com/questions/23428301/correct-way-of-updating-php-mysql-on-a-running-plesk-11-5-server

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

引用自:https://serverfault.com/questions/592749