• The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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