mariadb.service doesnt start, here are the log:
[root@h2769420 etc]# systemctl status mariadb.service ● mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Mi 2020-04-15 15:29:20 EEST; 2s ago Process: 1732 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE) Process: 1731 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS) Process: 1695 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS) Main PID: 1731 (code=exited, status=0/SUCCESS)
Apr 15 15:29:19 h2769420.stratoserver.net mariadb-prepare-db-dir[1695]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. Apr 15 15:29:19 h2769420.stratoserver.net mysqld_safe[1731]: 200415 15:29:19 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. Apr 15 15:29:19 h2769420.stratoserver.net mysqld_safe[1731]: 200415 15:29:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[root@h2769420 etc]# journalctl -xe Apr 15 15:31:55 h2769420.stratoserver.net sw-engine-pleskrun[7984]: 6: /usr/local/psa/admin/plib/sdk.php:12 Apr 15 15:31:55 h2769420.stratoserver.net sw-engine-pleskrun[7984]: require_once(string '/usr/local/psa/admin/plib/sdk.php') Apr 15 15:31:55 h2769420.stratoserver.net sw-engine-pleskrun[7984]: 7: /usr/local/psa/admin/plib/WebSocket/bin/ws-server.php:3 Apr 15 15:31:55 h2769420.stratoserver.net sw-engine-pleskrun[7984]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:60) Apr 15 15:31:56 h2769420.stratoserver.net sshd[7486]: Connection closed by 106.12.185.84 port 46548 [preauth] Apr 15 15:32:00 h2769420.stratoserver.net mariadb-prepare-db-dir[7989]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. Apr 15 15:32:00 h2769420.stratoserver.net mariadb-prepare-db-dir[7989]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir. Apr 15 15:32:00 h2769420.stratoserver.net mysqld_safe[8025]: 200415 15:32:00 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. Apr 15 15:32:01 h2769420.stratoserver.net mysqld_safe[8025]: 200415 15:32:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Apr 15 15:32:01 h2769420.stratoserver.net CROND[8231]: (psaadm) CMD (/usr/local/psa/admin/bin/php -dauto_prepend_file=sdk.php '/usr/local/psa/admin/plib/modules/wp-toolkit/scripts/maintenance.php') Apr 15 15:32:01 h2769420.stratoserver.net grafana-server[1525]: t=2020-04-15T15:32:01+0300 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=8 name="Apache & PHP-FPM memory usage" error="tsdb.HandleRequest() error Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: [2020-04-15 15:32:02.215] ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused: Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:60 Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''') Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 1: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:103 Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: CommonPanel_Application_Abstract::initDbAdapter() Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 2: /usr/local/psa/admin/plib/Session/Helper.php:176 Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: Plesk\Session\Helper::initStorage() Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 3: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:52 Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: CommonPanel_Application_Abstract->run() Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 4: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:34 Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: CommonPanel_Application_Abstract::init() Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 5: /usr/local/psa/admin/plib/pm/Bootstrap.php:16 Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: pm_Bootstrap::init() Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 6: /usr/local/psa/admin/plib/sdk.php:12 Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: require_once(string '/usr/local/psa/admin/plib/sdk.php') Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 7: /usr/local/psa/admin/plib/WebSocket/bin/ws-server.php:3 Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:60) Apr 15 15:32:04 h2769420.stratoserver.net plesk_saslauthd[6987]: No such user '[email protected]' in mail authorization database Apr 15 15:32:04 h2769420.stratoserver.net plesk_saslauthd[6987]: failed mail authentication attempt for user '[email protected]' (password len=9) Apr 15 15:32:04 h2769420.stratoserver.net postfix/smtpd[2607]: warning: unknown[92.118.38.83]: SASL LOGIN authentication failed: authentication failure Apr 15 15:32:04 h2769420.stratoserver.net sshd[7987]: Invalid user irc from 94.191.52.53 port 40440 Apr 15 15:32:04 h2769420.stratoserver.net sshd[7987]: input_userauth_request: invalid user irc [preauth] Apr 15 15:32:04 h2769420.stratoserver.net sshd[7987]: pam_unix(sshd:auth): check pass; user unknown Apr 15 15:32:04 h2769420.stratoserver.net sshd[7987]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=94.191.52.53 Apr 15 15:32:04 h2769420.stratoserver.net sshd[7987]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Apr 15 15:32:04 h2769420.stratoserver.net grafana-server[1525]: t=2020-04-15T15:32:04+0300 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=9 name="nginx memory usage" error="tsdb.HandleRequest() error rpc error: Apr 15 15:32:05 h2769420.stratoserver.net grafana-server[1525]: t=2020-04-15T15:32:05+0300 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=14 name="Real memory usage" error="tsdb.HandleRequest() error rpc error: Apr 15 15:32:06 h2769420.stratoserver.net postfix/smtpd[2607]: disconnect from unknown[92.118.38.83] ehlo=1 auth=0/1 rset=1 quit=1 commands=3/4 Apr 15 15:32:07 h2769420.stratoserver.net mariadb-prepare-db-dir[8241]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. Apr 15 15:32:07 h2769420.stratoserver.net mariadb-prepare-db-dir[8241]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir. Apr 15 15:32:07 h2769420.stratoserver.net sshd[7987]: Failed password for invalid user irc from 94.191.52.53 port 40440 ssh2 Apr 15 15:32:07 h2769420.stratoserver.net mysqld_safe[8277]: 200415 15:32:07 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. Apr 15 15:32:07 h2769420.stratoserver.net mysqld_safe[8277]: 200415 15:32:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Apr 15 15:32:07 h2769420.stratoserver.net sshd[7987]: Received disconnect from 94.191.52.53 port 40440:11: Bye Bye [preauth] Apr 15 15:32:07 h2769420.stratoserver.net sshd[7987]: Disconnected from 94.191.52.53 port 40440 [preauth] Apr 15 15:32:07 h2769420.stratoserver.net grafana-server[1525]: t=2020-04-15T15:32:07+0300 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=12 name="Plesk memory usage" error="tsdb.HandleRequest() error rpc error: Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: [2020-04-15 15:32:08.609] ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused: Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:60 Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''') Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 1: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:103 Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: CommonPanel_Application_Abstract::initDbAdapter() Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 2: /usr/local/psa/admin/plib/Session/Helper.php:176 Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: Plesk\Session\Helper::initStorage() Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 3: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:52 Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: CommonPanel_Application_Abstract->run() Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 4: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:34 Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: CommonPanel_Application_Abstract::init() Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 5: /usr/local/psa/admin/plib/pm/Bootstrap.php:16 Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: pm_Bootstrap::init() Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 6: /usr/local/psa/admin/plib/sdk.php:12 Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: require_once(string '/usr/local/psa/admin/plib/sdk.php') Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 7: /usr/local/psa/admin/plib/WebSocket/bin/ws-server.php:3 Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:60) Apr 15 15:32:08 h2769420.stratoserver.net grafana-server[1525]: t=2020-04-15T15:32:08+0300 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=10 name="Mail server memory usage" error="tsdb.HandleRequest() error rpc lines 937-1001/1001 (END)
Can someone help me fix this error without loosing the databases i already had on this system?