• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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