[Solved] MariaDB MariaDB failed to restart at first install

Please fill in any relevant information that applies to you:

• CentOS Version: CentOS 7 64bit
  
• Centmin Mod Version Installed: 123.09beta01

Hello

Just got a test server from Hetzner a simple vps and i install Centminmod using:

---

Code:

yum -y update; curl -O https://centminmod.com/betainstaller73.sh && chmod 0700 betainstaller73.sh && bash betainstaller73.sh

At the end of installation i got this:

Code:

**********************************************************************
* Starting Services...
**********************************************************************
Starting nginx (via systemctl):  [  OK  ]
Starting mysql (via systemctl):  Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.servic                                                                                     e" and "journalctl -xe" for details.
[FAILED]

MariaDB failed to start...

So i run:

Code:

journalctl -xe

and i got this:

Code:

Dec 03 13:25:54 server.mydomain.com systemd[1]: mariadb.service start operation timed out. Terminating.
Dec 03 13:25:54 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:56 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:56 server.mydomain.com systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:58 server.mydomain.com kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=96:00:00:38:3f:73:d2:74:7f:6e:37:e3:08:00 SRC=191.37.229.70 DST=78.46.239.163 LEN=44 TOS=0x00 PREC=0x00 TTL=42 ID=41593 PROTO=TCP SPT=36149
Dec 03 13:25:58 server.mydomain.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Dec 03 13:25:58 server.mydomain.com systemd[1]: Failed to start MariaDB 10.3.20 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Dec 03 13:25:58 server.mydomain.com systemd[1]: Unit mariadb.service entered failed state.
Dec 03 13:25:58 server.mydomain.com systemd[1]: mariadb.service failed.
Dec 03 13:25:58 server.mydomain.com polkitd[572]: Unregistered Authentication Agent for unix-process:16981:303831 (system bus name :1.191, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconn
Dec 03 13:25:58 server.mydomain.com polkitd[572]: Registered Authentication Agent for unix-process:17309:313272 (system bus name :1.196 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/freedesktop/PolicyKit1/Auth
Dec 03 13:25:58 server.mydomain.com systemd[1]: Starting ConfigServer Firewall & Security - csf...

And then i run this:

Code:

systemctl status mariadb.service

and i got this:

Code:

mariadb.service - MariaDB 10.3.20 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf, openfileslimit.conf, protecthome.conf
   Active: failed (Result: exit-code) since Tue 2019-12-03 13:25:58 UTC; 10min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 17258 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Dec 03 13:25:55 server.supereventforall.info systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.supereventforall.info systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.supereventforall.info systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:55 server.supereventforall.info systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:56 server.supereventforall.info systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:56 server.supereventforall.info systemd[1]: Got notification message from PID 31311, but reception only permitted for main PID 17258
Dec 03 13:25:58 server.supereventforall.info systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Dec 03 13:25:58 server.supereventforall.info systemd[1]: Failed to start MariaDB 10.3.20 database server.
Dec 03 13:25:58 server.supereventforall.info systemd[1]: Unit mariadb.service entered failed state.
Dec 03 13:25:58 server.supereventforall.info systemd[1]: mariadb.service failed.

Something seems to be wrong related to PID of it ....

After that starting it using mysqlstart was ok.

Thanks

 

I am uploading the file here as it is a bit big...

Thanks

 

No problem

Don't remember to be honest as it is a test server and i format it every x hours

You know...