Articles in this section

The error in Plesk: ERR [panel] SQLSTATE[HY000] [2002] No such file or directory, Can't connect to local MySQL server through socket

Taras Ermoshin

Updated January 04, 2024 09:34

Plesk for Linux kb: technical ABT: Group B

Applicable to:

Plesk for Linux

Symptoms

The following error is shown instead of the Plesk login page:

CONFIG_TEXT: ERR [panel] SQLSTATE[HY000] [2002] No such file or directory
Generation of the login link fails:

# plesk login
ERR [panel] SQLSTATE[HY000] [2002] No such file or directory:
0: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:144
..........
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)
It is possible to login to the Plesk configuration database (psa) using the command:

# plesk db
No errors can be found in the MySQL/MariaDB error log (can be located at /var/log/mysqld.log, /var/log/mariadb/mariadb.log or /var/log/mysql/error.log) even during the restart of the service.
Manual running of the backupmng utility fails with the following error:

# plesk sbin backupmng
backupmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
System error 13: Permission denied
backupmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
System error 13: Permission denied
backupmng: Unable to connect to the mysql database
When deleting a domain or a subscription from Plesk, the following error can be found in the file /var/log/plesk/panel.log:

CONFIG_TEXT: PHP Fatal error: Uncaught exception 'PleskMultipleException' with message 'Error during example.com removeZone: dnsmng failed: dnsmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
System error 2: No such file or directory
dnsmng: Unable to connect to the mysql database
System error 2: No such file or directory
in /opt/psa/admin/plib/Service/Dns/Connector/Plesk.php:14
Stack trace:
..........
thrown in /opt/psa/admin/plib/Service/Dns/Connector/Plesk.php on line 14

Cause

The sockets specified in the files /etc/psa/psa.conf and /usr/local/psa/admin/conf/php.ini differ from the actual MySQL/MariaDB socket defined in the file /etc/my.cnf (/etc/mysql/my.cnf on Debian and Ubuntu).

Resolution

Connect to the server using SSH.
Make sure that the sockets to connect to the MySQL/MariaDB server specified in the files /etc/psa/psa.conf and /usr/local/psa/admin/conf/php.ini are the same as the socket defined in the file /etc/my.cnf (/etc/mysql/my.cnf on Debian and Ubuntu):

# grep mysql.sock /etc/my.cnf
socket=/var/lib/mysql/mysql.sock

# grep mysql.sock /etc/psa/psa.conf
MYSQL_SOCKET /var/lib/mysql/mysql.sock

# grep mysql.sock /usr/local/psa/admin/conf/php.ini
pdo_mysql.default_socket="/var/lib/mysql/mysql.sock"

Comments

1 comment

Ehud Ziegelman

April 23, 2023 11:25

Hi Taras Ermoshin,

After manually setting the above, and testing they are in place:

root@:/var/lib/psa/dumps# grep mysql.sock /etc/mysql/my.cnf
socket=/var/lib/mysql/mysql.sock
root@:/var/lib/psa/dumps# grep mysql.sock /etc/psa/psa.conf
MYSQL_SOCKET /var/lib/mysql/mysql.sock
root@:/var/lib/psa/dumps# grep mysql.sock /usr/local/psa/admin/conf/php.ini
pdo_mysql.default_socket="/var/lib/mysql/mysql.sock"

I have tried to run CLI:

# zcat mysql.daily.dump.0.gz | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | plesk db
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Thus, I have searched for that OTHER path to the socket, and found the below:

# grep -r "/var/run/mysqld/mysqld.sock" /var/*
/var/lib/dpkg/info/plesk-fail2ban-configurator.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-dovecot.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-core.preinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-ui-library.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-dovecot.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-vhost.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-firewall.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-firewall.postinst:       local mysql_socket="/var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/psa-firewall.postinst:       local MYSQL_SOCKETS="/var/lib/mysql/mysql.sock /tmp/mysql.sock /var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/libapache2-mod-fcgid-psa.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/libpam-plesk.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-fail2ban-configurator.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-awstats-configurator.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-service-node-utilities.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-dovecot-imap-driver.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-proftpd.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-mail-pc-driver.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-mail-pc-driver.preinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-web-hosting.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-mail-driver-common.preinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-dns-bind-driver.postrm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-task-manager.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-mail-driver-common.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-modsecurity-crs.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-phpmyadmin.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-phpmyadmin.postinst:     local mysql_socket="/var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/psa-phpmyadmin.postinst:     local MYSQL_SOCKETS="/var/lib/mysql/mysql.sock /tmp/mysql.sock /var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-dovecot-imap-driver.postrm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-repair-kit.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-fail2ban-configurator.preinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-proftpd.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-task-manager.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa.preinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-web-socket.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-phpmyadmin.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-phpmyadmin.prerm:        local mysql_socket="/var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/psa-phpmyadmin.prerm:        local MYSQL_SOCKETS="/var/lib/mysql/mysql.sock /tmp/mysql.sock /var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-service-node-utilities.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/sw-collectd.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-firewall.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-firewall.prerm:  local mysql_socket="/var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/psa-firewall.prerm:  local MYSQL_SOCKETS="/var/lib/mysql/mysql.sock /tmp/mysql.sock /var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-mail-pc-driver.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-resctrl.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-dovecot-imap-driver.preinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-proftpd.postrm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-mail-driver-common.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-control-panel.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/libpam-plesk.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-modsecurity-configurator.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-phpmyadmin.preinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-phpmyadmin.preinst:      local mysql_socket="/var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/psa-phpmyadmin.preinst:      local MYSQL_SOCKETS="/var/lib/mysql/mysql.sock /tmp/mysql.sock /var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-dovecot-pigeonhole.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-dovecot.postrm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-php-configurator.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-web-socket.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-dovecot-imap-driver.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-core.postrm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa-proftpd.preinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-config-troubleshooter.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-config-troubleshooter.prerm:   local mysql_socket="/var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-config-troubleshooter.prerm:   local MYSQL_SOCKETS="/var/lib/mysql/mysql.sock /tmp/mysql.sock /var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-l10n.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-core.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-core.postinst: local mysql_socket="/var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-core.postinst: local MYSQL_SOCKETS="/var/lib/mysql/mysql.sock /tmp/mysql.sock /var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-modsecurity-configurator.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-dovecot.preinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-config-troubleshooter.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-config-troubleshooter.postinst:        local mysql_socket="/var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-config-troubleshooter.postinst:        local MYSQL_SOCKETS="/var/lib/mysql/mysql.sock /tmp/mysql.sock /var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-l10n.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/psa.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-backup-utilities.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-dns-bind-driver.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-dns-bind-driver.postinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-core.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-core.prerm:    local mysql_socket="/var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-core.prerm:    local MYSQL_SOCKETS="/var/lib/mysql/mysql.sock /tmp/mysql.sock /var/run/mysqld/mysqld.sock"
/var/lib/dpkg/info/plesk-mail-pc-driver.postrm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/libapache2-modsecurity-plesk.prerm:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/lib/dpkg/info/plesk-l10n.preinst:MYSQL_SOCKET=/var/run/mysqld/mysqld.sock
/var/log/mysql/error.log:2023-04-23T08:11:32.713768Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32-0ubuntu0.22.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
/var/log/mysql/error.log:2023-04-23T08:17:55.163246Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32-0ubuntu0.22.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
grep: /var/run/snapd/ns/lxd.mnt: Invalid argument

Can you please guide me?

Please sign in to leave a comment.