• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Resolved Plesk - MariaDB Remote Access - Not starting anymore

inseljohn

New Pleskian
Hi all,

i've a big problem and need help to fix this. I wanted to remotely access the database and ran the script from this page:

How to enable remote access to MySQL database server in Plesk

When I try to start MariaDB, the following message appears:

service mariadb start
Redirecting to / bin / systemctl start mariadb.service Job for mariadb.service failed because a timeout was exceeded. See "systemctl status mariadb.service" and "journalctl -xe" for details.

systemctl status mariadb.service

mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: failed (Result: timeout) since Do 2018-05-10 14:18:36 CEST; 14s ago
Process: 23973 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=killed, signal=TERM)
Main PID: 9333 (code=exited, status=0/SUCCESS)
CGroup: /system.slice/mariadb.service
└─control
├─16185 fuser /var/lib/mysql/mysql.sock
├─16569 fuser /var/lib/mysql/mysql.sock
├─17405 fuser /var/lib/mysql/mysql.sock
├─18379 fuser /var/lib/mysql/mysql.sock
├─18818 fuser /var/lib/mysql/mysql.sock
├─19234 fuser /var/lib/mysql/mysql.sock
├─19867 fuser /var/lib/mysql/mysql.sock
├─20281 fuser /var/lib/mysql/mysql.sock
├─20869 fuser /var/lib/mysql/mysql.sock
├─21852 fuser /var/lib/mysql/mysql.sock
├─23099 fuser /var/lib/mysql/mysql.sock
└─23997 fuser /var/lib/mysql/mysql.sock

Mai 10 14:13:36 h2369385.stratoserver.net systemd[1]: Starting MariaDB database server...
Mai 10 14:18:36 h2369385.stratoserver.net systemd[1]: mariadb.service start-pre operation timed out. Terminating.
Mai 10 14:18:36 h2369385.stratoserver.net systemd[1]: Failed to start MariaDB database server.
Mai 10 14:18:36 h2369385.stratoserver.net systemd[1]: Unit mariadb.service entered failed state.
Mai 10 14:18:36 h2369385.stratoserver.net systemd[1]: mariadb.service failed.

In the logfiles / var / log / mariadb the following is written

180510 12:06:56 [Note] / usr / libexec / mysqld: Normal shutdown

180510 12:06:56 [Rating] Event Scheduler: Purging the queue. 0 events
180510 12:06:57 InnoDB: Starting shutdown ...
180510 12:07:01 InnoDB: Shutdown completed; log sequence number 65622124849
180510 12:07:01 [Note] / usr / libexec / mysqld: Shutdown complete

180510 12:07:01 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended

I really hope somebody can help me. That would be great. Of course, against payment. Many thanks in advance greetings
 
Can you start mariadb service if you comment line

bind-address = 0.0.0.0

in my.cnf?
 
Back
Top