SQL Service won't start

[RyanSett]

Hello,

Plask Management inferace error is:
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Connection refused (Abstract.php:144)

First, the datacenter lost power so the server shut off. I assume there is some DB corruption and why the SQL Service won't start.

failed
Trying to start service mariadb... Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.

WARNING!
Some problems are found during start(see log file: /var/log/plesk/psa_service.log)

Continue...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

I ran the systemctl status mariadb.service command and this is below.

   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
   Active: failed (Result: exit-code) since Wed 2015-04-29 05:57:21 CEST; 5min ago
  Process: 21210 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
  Process: 21208 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 21180 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 21208 (code=exited, status=0/SUCCESS)

Apr 29 05:57:20 HOST mysqld_safe[21208]: 150429 05:57:20 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Apr 29 05:57:20 HOST mysqld_safe[21208]: 150429 05:57:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 29 05:57:20 HOST mysqld_safe[21208]: 150429 05:57:20 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Apr 29 05:57:21 HOST systemd[1]: mariadb.service: control process exited, code=exited status=1
Apr 29 05:57:21 HOST systemd[1]: Failed to start MariaDB database server.
Apr 29 05:57:21 HOST systemd[1]: Unit mariadb.service entered failed state.
Apr 29 05:57:20 HOST mysqld_safe[21208]: 150429 05:57:20 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Apr 29 05:57:20 HOST mysqld_safe[21208]: 150429 05:57:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 29 05:57:20 HOST mysqld_safe[21208]: 150429 05:57:20 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Apr 29 05:57:21 HOST systemd[1]: mariadb.service: control process exited, code=exited status=1
Apr 29 05:57:21 HOST systemd[1]: Failed to start MariaDB database server.
Apr 29 05:57:21 HOST systemd[1]: Unit mariadb.service entered failed state.

 

[RyanSett]

[root@host mysql]# systemctl status mariadb.service
mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
   Active: failed (Result: exit-code) since Wed 2015-04-29 07:50:06 CEST; 11s ago
  Process: 3053 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
  Process: 3052 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 3024 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 3052 (code=exited, status=0/SUCCESS)

Apr 29 07:50:05 HOST mysqld_safe[3052]: 150429 07:50:05 mysqld_safe unknown option '--cludedir'
Apr 29 07:50:05 HOST mysqld_safe[3052]: sed: -e expression #1, char 10: unknown option to `s'
Apr 29 07:50:05 HOST mysqld_safe[3052]: 150429 07:50:05 mysqld_safe unknown option ''
Apr 29 07:50:05 HOST mysqld_safe[3052]: 150429 07:50:05 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Apr 29 07:50:05 HOST mysqld_safe[3052]: 150429 07:50:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 29 07:50:05 HOST mysqld_safe[3052]: 150429 07:50:05 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Apr 29 07:50:06 HOST systemd[1]: mariadb.service: control process exited, code=exited status=1
Apr 29 07:50:06 HOST systemd[1]: Failed to start MariaDB database server.
Apr 29 07:50:06 HOST systemd[1]: Unit mariadb.service entered failed state.
[root@host mysql]# journalctl -xn
-- Logs begin at Wed 2015-04-29 07:47:49 CEST, end at Wed 2015-04-29 07:50:36 CEST. --
Apr 29 07:50:31 HOST sshd[3294]: Failed password for root from 219.153.12.140 port 60690 ssh2
Apr 29 07:50:31 HOST sshd[3294]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Apr 29 07:50:31 HOST sshd[3294]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Apr 29 07:50:34 HOST sshd[3294]: Failed password for root from 219.153.12.140 port 60690 ssh2
Apr 29 07:50:34 HOST sshd[3294]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Apr 29 07:50:34 HOST sshd[3294]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Apr 29 07:50:36 HOST sshd[3294]: Failed password for root from 219.153.12.140 port 60690 ssh2
Apr 29 07:50:36 HOST sshd[3294]: fatal: Read from socket failed: Connection reset by peer [preauth]
Apr 29 07:50:36 HOST sshd[3294]: PAM 4 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=219.153.12.140  user=root
Apr 29 07:50:36 HOST sshd[3294]: PAM service(sshd) ignoring max retries; 5 > 3

 

[RyanSett]

Apr 29 19:23:56 MYHOST systemd[1]: Starting MariaDB database server...
Apr 29 19:23:56 MYHOST mysqld_safe[9478]: 150429 19:23:56 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Apr 29 19:23:56 MYHOST mysqld_safe[9478]: 150429 19:23:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 29 19:23:56 MYHOST mysqld_safe[9478]: 150429 19:23:56 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Apr 29 19:23:57 MYHOST systemd[1]: mariadb.service: control process exited, code=exited status=1
Apr 29 19:23:57 MYHOST systemd[1]: Failed to start MariaDB database server.
Apr 29 19:23:57 MYHOST systemd[1]: Unit mariadb.service entered failed state.
[root@host /]# journalctl -xn
-- Logs begin at Wed 2015-04-29 18:39:18 CEST, end at Wed 2015-04-29 19:24:14 CEST. --
Apr 29 19:24:08 MYHOST sshd[9685]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=43.255.190.190 user=root
Apr 29 19:24:09 MYHOST sshd[9688]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=43.255.190.190 user=root
Apr 29 19:24:09 MYHOST sshd[9688]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
Apr 29 19:24:09 MYHOST sshd[9688]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Apr 29 19:24:12 MYHOST sshd[9688]: Failed password for root from 43.255.190.190 port 59298 ssh2
Apr 29 19:24:12 MYHOST sshd[9688]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
Apr 29 19:24:12 MYHOST sshd[9688]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Apr 29 19:24:14 MYHOST sshd[9688]: Failed password for root from 43.255.190.190 port 59298 ssh2
Apr 29 19:24:14 MYHOST sshd[9688]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
Apr 29 19:24:14 MYHOST sshd[9688]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"