• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Resolved Server Error 500 Zend_Db_Adapter_Exception SQLSTATE[HY000] [2002] No such file or directory

Mike23

Mike23

New Pleskian
I went through all the threads with the same type of issue but could not solve my problem.

When try to access Plesk I get : "Server Error 500 Zend_Db_Adapter_Exception SQLSTATE[HY000] [2002] No such file or directory Abstract.php line 144"

Here are the different outputs:
service mysql start
Click to expand...
Code: 
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

systemctl status mysql.service
Click to expand...
Code: 
mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (start-post) (Result: exit-code) since lun. 2021-01-18 10:37:45 CET; 15s ago
  Process: 17176 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 17168 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 17176 (code=exited, status=1/FAILURE);         : 17177 (mysql-systemd-s)
   CGroup: /system.slice/mysql.service
           └─control
             ├─17177 /bin/bash /usr/share/mysql/mysql-systemd-start post
             └─17234 sleep 1

janv. 18 10:37:45 ns3021026.ip-151-80-24.eu systemd[1]: Starting MySQL Community Server...
janv. 18 10:37:48 ns3021026.ip-151-80-24.eu systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

journalctl -xe
Click to expand...
Code: 
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- L'unité (unit) mysql.service a commencé à démarrer.
janv. 18 10:45:56 ns3021026.ip-151-80-24.eu systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
janv. 18 10:46:01 ns3021026.ip-151-80-24.eu CRON[19308]: pam_unix(cron:session): session opened for user root by (uid=0)
janv. 18 10:46:01 ns3021026.ip-151-80-24.eu CRON[19310]: (root) CMD (/opt/plesk/php/7.3/bin/php -f '/var/www/vhosts/xxxxxxxxxx.org/httpdocs/wp-content/themes/csud/includes/remote/cron-two-minutes.php')
janv. 18 10:46:01 ns3021026.ip-151-80-24.eu CRON[19309]: pam_unix(cron:session): session opened for user root by (uid=0)
janv. 18 10:46:01 ns3021026.ip-151-80-24.eu CRON[19307]: pam_unix(cron:session): session opened for user root by (uid=0)
janv. 18 10:46:01 ns3021026.ip-151-80-24.eu CRON[19311]: (root) CMD (/opt/plesk/php/7.0/bin/php -f '/var/www/vhosts/xxxxxxxxx.org/httpdocs/wp-content/themes/csud/includes/remote/cron-one-minute.php')
janv. 18 10:46:01 ns3021026.ip-151-80-24.eu CRON[19312]: (root) CMD (/usr/local/rtm/bin/rtm 52 > /dev/null 2> /dev/null)
janv. 18 10:46:01 ns3021026.ip-151-80-24.eu CRON[19308]: pam_unix(cron:session): session closed for user root
janv. 18 10:46:01 ns3021026.ip-151-80-24.eu CRON[19307]: pam_unix(cron:session): session closed for user root
janv. 18 10:46:01 ns3021026.ip-151-80-24.eu CRON[19309]: pam_unix(cron:session): session closed for user root
janv. 18 10:46:05 ns3021026.ip-151-80-24.eu postfix/smtp[18711]: connect to yahoo.co[124.108.115.100]:25: Connection timed out
janv. 18 10:46:05 ns3021026.ip-151-80-24.eu postfix/smtp[18711]: 2314B3DC0170: to=<[email protected]>, relay=none, delay=294230, delays=294080/0.13/150/0, dsn=4.4.1, status=deferred (connect to yahoo.co[124.108.115.100]:25: Connection timed out)
janv. 18 10:46:23 ns3021026.ip-151-80-24.eu systemd[1]: Failed to start MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a échoué
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- L'unité (unit) mysql.service a échoué, avec le résultat failed.
janv. 18 10:46:23 ns3021026.ip-151-80-24.eu systemd[1]: mysql.service: Unit entered failed state.
janv. 18 10:46:23 ns3021026.ip-151-80-24.eu systemd[1]: mysql.service: Failed with result 'exit-code'.
janv. 18 10:46:24 ns3021026.ip-151-80-24.eu systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
janv. 18 10:46:24 ns3021026.ip-151-80-24.eu systemd[1]: Stopped MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a terminé son arrêt
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- L'unité (unit) mysql.service a terminé son arrêt.
janv. 18 10:46:24 ns3021026.ip-151-80-24.eu systemd[1]: Starting MySQL Community Server...
-- Subject: L'unité (unit) mysql.service a commencé à démarrer
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- L'unité (unit) mysql.service a commencé à démarrer.
janv. 18 10:46:25 ns3021026.ip-151-80-24.eu sshd[19392]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=112.85.42.185  user=root
janv. 18 10:46:25 ns3021026.ip-151-80-24.eu sshd[19392]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
janv. 18 10:46:26 ns3021026.ip-151-80-24.eu systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
janv. 18 10:46:27 ns3021026.ip-151-80-24.eu sshd[19392]: Failed password for root from 112.85.42.185 port 27282 ssh2
janv. 18 10:46:27 ns3021026.ip-151-80-24.eu sshd[19392]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
janv. 18 10:46:29 ns3021026.ip-151-80-24.eu sshd[19392]: Failed password for root from 112.85.42.185 port 27282 ssh2
janv. 18 10:46:30 ns3021026.ip-151-80-24.eu sshd[19392]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
janv. 18 10:46:32 ns3021026.ip-151-80-24.eu sshd[19392]: Failed password for root from 112.85.42.185 port 27282 ssh2
janv. 18 10:46:33 ns3021026.ip-151-80-24.eu sshd[19392]: Received disconnect from 112.85.42.185 port 27282:11:  [preauth]
janv. 18 10:46:33 ns3021026.ip-151-80-24.eu sshd[19392]: Disconnected from 112.85.42.185 port 27282 [preauth]
janv. 18 10:46:33 ns3021026.ip-151-80-24.eu sshd[19392]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=112.85.42.185  user=root
janv. 18 10:46:54 ns3021026.ip-151-80-24.eu systemd[1]: Failed to start MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a échoué
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- L'unité (unit) mysql.service a échoué, avec le résultat failed.
janv. 18 10:46:54 ns3021026.ip-151-80-24.eu systemd[1]: mysql.service: Unit entered failed state.
janv. 18 10:46:54 ns3021026.ip-151-80-24.eu systemd[1]: mysql.service: Failed with result 'exit-code'.
janv. 18 10:46:54 ns3021026.ip-151-80-24.eu systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
janv. 18 10:46:54 ns3021026.ip-151-80-24.eu systemd[1]: Stopped MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a terminé son arrêt
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- L'unité (unit) mysql.service a terminé son arrêt.
janv. 18 10:46:54 ns3021026.ip-151-80-24.eu systemd[1]: Starting MySQL Community Server...
-- Subject: L'unité (unit) mysql.service a commencé à démarrer
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- L'unité (unit) mysql.service a commencé à démarrer.
janv. 18 10:46:57 ns3021026.ip-151-80-24.eu systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
janv. 18 10:47:01 ns3021026.ip-151-80-24.eu CRON[19556]: pam_unix(cron:session): session opened for user root by (uid=0)
janv. 18 10:47:01 ns3021026.ip-151-80-24.eu CRON[19557]: pam_unix(cron:session): session opened for user root by (uid=0)
janv. 18 10:47:01 ns3021026.ip-151-80-24.eu CRON[19558]: (root) CMD (/usr/local/rtm/bin/rtm 52 > /dev/null 2> /dev/null)
janv. 18 10:47:01 ns3021026.ip-151-80-24.eu CRON[19559]: (root) CMD (/opt/plesk/php/7.0/bin/php -f '/var/www/vhosts/coordinationsud.org/httpdocs/wp-content/themes/csud/includes/remote/cron-one-minute.php')
janv. 18 10:47:01 ns3021026.ip-151-80-24.eu CRON[19556]: pam_unix(cron:session): session closed for user root
janv. 18 10:47:01 ns3021026.ip-151-80-24.eu CRON[19557]: pam_unix(cron:session): session closed for user root
janv. 18 10:47:11 ns3021026.ip-151-80-24.eu repaird[15736]: INFO 2021/01/18 10:47:11 Shutdown server by timeout.

Any help is appreciated.
 
Last edited:
I could solve the issue, the problem was that in my.cnf I had a variable that was not named properly. I had "table_cache" instead of "table_open_cache".
 
You must log in or register to reply here.

Similar threads

S
Resolved Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
10
Views
354
Shasam
S
E
Resolved DB query failed: SQLSTATE[HY000] [2002] No such file or directory mariadb cant start
Replies
1
Views
619
emreboy
E
S
Resolved Server Error500 Plesk\Exception\DatabaseDB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
3
Views
2K
signguy007
S
A
Issue DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
1
Views
1K
IgorG
IgorG
J
Resolved Updated Maria, my server is now broken - DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
12
Views
3K
pleskpanel
P
Back
Top