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
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