• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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