• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

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

C
Resolved Mariadb not working - DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
7
Views
3K
Crash79797
C
S
Resolved Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
10
Views
3K
Shasam
S
E
Resolved DB query failed: SQLSTATE[HY000] [2002] No such file or directory mariadb cant start
Replies
1
Views
3K
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
2K
IgorG
IgorG
Back
Top