• 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
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

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
542
Shasam
S
E
Resolved DB query failed: SQLSTATE[HY000] [2002] No such file or directory mariadb cant start
Replies
1
Views
810
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