• 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.

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

markbro

New Pleskian
Hello Community

I recently decided to give Plesk my support and moved a single business website over.

Some things to know.
1. I used VULTR to get a plesk server on Ubuntu 18.04
2. I upgraded the plan from 2gb to 4GB of RAM - this also increased the disk image size.
3. I may have restarted the server when I shouldn't have
4. I have a snapshot thats 4 days old, but a bunch of info/orders inside woo commerce I need to get back.
5. I kept the server updated and secure as a priority.

I need to work out why I cant get mySQL/MariaDB to start, I've tried every solution I could find, and if it didn't work.
I'm not a server admin, but I can normally figure my own issues out through reading forums.

Ive tried to
1. manually start the sql service with
2. use the repair kit at www.domain.com/repair
3. restart the server
4.

This one has me stumped, I've considered rolling back to the snapshot from 4 days ago, and then restoring from backup I have of Wordpress on Google Drive, but before I do that, I think it would be worth a shot here. So please throw in your 2 cents.

Ive been logging in via console via VULTR and SFTP to check files match with what they should.
Finally Im willing to pay a little bit for some support, but not too much because its a new small business, and I recently lost my life savings.. yep!
Ive been awake 8 hours past my bedtime already trying to fix it.

Im tempted to go down the path of pulling the last data out of wordpress and the databases which I have a copy of via SFTP.
But the problem is Ive never tried to do that, and I need to get the website back up for the public asap.
 
Some info you may want to see

root@webz4biz:~# systemctl status mariadb

● mariadb.service - MariaDB 10.1.48 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2021-09-30 05:13:17 AEST; 1s ago
Docs: man:mysqld(8)
systemd
Process: 28892 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status
Process: 28810 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/ga
Process: 28802 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCES
Process: 28790 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS
Main PID: 28892 (code=exited, status=1/FAILURE)
Status: "Starting Innodb crash recovery"

Sep 30 05:13:16 webz4biz.com systemd[1]: Starting MariaDB 10.1.48 database server...
Sep 30 05:13:17 webz4biz.com mysqld[28892]: 2021-09-30 5:13:17 139644199738496 [Note] /usr/sbin/mysqld (mysqld 10.1.48-
Sep 30 05:13:17 webz4biz.com systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 30 05:13:17 webz4biz.com systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 30 05:13:17 webz4biz.com systemd[1]: Failed to start MariaDB 10.1.48 database server.
lines 1-17/17 (END)


root@webz4biz:~# journalctl -xe
-- Unit drwebd.service has finished shutting down.
Sep 30 05:16:38 webz4biz.com systemd[1]: Started Plesk Premium Antivirus.
-- Subject: Unit drwebd.service has finished start-up
-- Defined-By: systemd
-- Support: Enterprise open source support | Ubuntu
--
-- Unit drwebd.service has finished starting up.
--
-- The start-up result is RESULT.
Sep 30 05:16:38 webz4biz.com drwebd[7673]: Dr.Web (R) daemon for Linux/Plesk Edition v6.0.2.1
Sep 30 05:16:38 webz4biz.com drwebd[7673]: Copyright (c) Igor Daniloff, 1992-2021
Sep 30 05:16:38 webz4biz.com drwebd[7673]: Doctor Web, Moscow, Russia
Sep 30 05:16:38 webz4biz.com drwebd[7673]: Support service: Dr.Web — innovative anti-virus technologies. Comprehensive protection from Internet threats.
Sep 30 05:16:38 webz4biz.com drwebd[7673]: To purchase: Dr.Web — innovative anti-virus technologies. Comprehensive protection from Internet threats.
Sep 30 05:16:38 webz4biz.com drwebd.real[7673]: Dr.Web (R) daemon for Linux/Plesk Edition v6.0.2.1
Sep 30 05:16:38 webz4biz.com drwebd.real[7673]: Copyright (c) Igor Daniloff, 1992-2021
Sep 30 05:16:38 webz4biz.com drwebd.real[7673]: Doctor Web, Moscow, Russia
Sep 30 05:16:38 webz4biz.com drwebd.real[7673]: Support service: Dr.Web — innovative anti-virus technologies. Comprehensive protection from Internet threats.
Sep 30 05:16:38 webz4biz.com drwebd.real[7673]: To purchase: Dr.Web — innovative anti-virus technologies. Comprehensive protection from Internet threats.
Sep 30 05:16:39 webz4biz.com drwebd[7673]: Key file: /opt/drweb/drweb32.key - Key file was not found! (No such file or d
Sep 30 05:16:39 webz4biz.com drwebd[7673]: A path to a valid license key file was not specified.
Sep 30 05:16:39 webz4biz.com drwebd.real[7673]: Key file: /opt/drweb/drweb32.key - Key file was not found! (No such file
Sep 30 05:16:39 webz4biz.com drwebd.real[7673]: A path to a valid license key file was not specified.
Sep 30 05:16:39 webz4biz.com drwebd[7673]: Plesk authorization failed: malformed response (no 'response=' field).
Sep 30 05:16:39 webz4biz.com drwebd.real[7673]: Plesk authorization failed: malformed response (no 'response=' field).
Sep 30 05:16:39 webz4biz.com drwebd[7673]: Error: Plesk Software not running.
Sep 30 05:16:39 webz4biz.com drwebd.real[7673]: Error: Plesk Software not running.
Sep 30 05:16:39 webz4biz.com systemd[1]: drwebd.service: Main process exited, code=exited, status=255/n/a
Sep 30 05:16:39 webz4biz.com systemd[1]: drwebd.service: Failed with result 'exit-code'.
lines 1989-2017/2017 (END)
 
Back
Top