MariabDB won't start - Help!

Hi Guys,
Could do with some urgent help if possible.
Overnight on a server that beens running for years (I haven’t changed anything), MariaDB stopped, and now start!

I’m running CentOS7 and the MariaDB version is 10.1.29.

When I first go to Servers->MySQL Databases, I get this message:

The full MySQL error message was : DBI connect failed : Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)

If I then press the Start button, I get this:

Failed to start database :

Redirecting to /bin/systemctl start rh-mariadb101-mariadb.service Job for rh-mariadb101-mariadb.service failed because the control process exited with error code. See “systemctl status rh-mariadb101-mariadb.service” and “journalctl -xe” for details.

In log files, all I can see is:

Mar 29 09:17:21 systemd: Starting MariaDB 10.1 database server…
Mar 29 09:17:21 scl: Socket file /var/lib/mysql/mysql.sock exists.
Mar 29 09:17:21 scl: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically.
Mar 29 09:17:21 scl: Database MariaDB is probably initialized in /var/opt/rh/rh-mariadb101/lib/mysql already, nothing is done.
Mar 29 09:17:21 scl: If this is not the case, make sure the /var/opt/rh/rh-mariadb101/lib/mysql is empty before running mysql-prepare-db-dir.
Mar 29 09:17:21 mysqld_safe-scl-helper: 2020-03-29 9:17:21 140085864892608 [Note] /opt/rh/rh-mariadb101/root/usr/libexec/mysqld (mysqld 10.1.29-MariaDB) starting as process 3108 …
Mar 29 09:17:29 systemd: rh-mariadb101-mariadb.service: main process exited, code=exited, status=1/FAILURE
Mar 29 09:17:29 systemd: Failed to start MariaDB 10.1 database server.
Mar 29 09:17:29 systemd: Unit rh-mariadb101-mariadb.service entered failed state.
Mar 29 09:17:29 systemd: rh-mariadb101-mariadb.service failed.

Can anyone please help? I’ve not had this before :frowning: so really don’t know what to do.

I’ve just checked the ‘Re-check Config page’, and it says this:

MySQL does not appear to be installed and running on your system, or has not yet been set up properly in Webmin’s MySQL Database module. If your system does not use MySQL, it should be disabled in Virtualmin’s module configuration page.

And finally, if I check the status in SSH, I get this

systemctl status rh-mariadb101-mariadb.service
● rh-mariadb101-mariadb.service - MariaDB 10.1 database server
Loaded: loaded (/usr/lib/systemd/system/rh-mariadb101-mariadb.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Sun 2020-03-29 09:24:53 BST; 1min 30s ago
Process: 5239 ExecStopPost=/usr/bin/scl enable $RH_MARIADB101_SCLS_ENABLED – /opt/rh/rh-mariadb101/root/usr/libexec/mysql-wait-stop (code=exited, status=0/SUCCESS)
Process: 5219 ExecStart=/opt/rh/rh-mariadb101/root/usr/libexec/mysqld_safe-scl-helper enable $RH_MARIADB101_SCLS_ENABLED – /opt/rh/rh-mariadb101/root/usr/libexec/mysqld --basedir=/opt/rh/rh-mariadb101/root/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
Process: 5177 ExecStartPre=/usr/bin/scl enable $RH_MARIADB101_SCLS_ENABLED – /opt/rh/rh-mariadb101/root/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Process: 5145 ExecStartPre=/usr/bin/scl enable $RH_MARIADB101_SCLS_ENABLED – /opt/rh/rh-mariadb101/root/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
Process: 5138 ExecStartPre=/usr/bin/scl enable $RH_MARIADB101_SCLS_ENABLED – /usr/bin/scl_enabled rh-mariadb101 (code=exited, status=0/SUCCESS)
Main PID: 5219 (code=exited, status=1/FAILURE)
Status: “MariaDB server is down”

Just a quick update to what I have done as I have made a bit of progress.
I ended up removing mariadb101 with the following command:

sudo yum remove mariadb101*

I then installed the latest from softwarecollections by running the following command:

sudo yum install rh-mariadb103
and then:
scl enable rh-mariadb103 bash

In VirtualMin, I went to the Configuration for the MySQL Database and updated all references of rh-mariadb101 to rh-mariadb103

The MySQL Server now starts! Great!

No databases were displayed though so I think they have all gone, so I am currently uploading last nights database backup (i do this daily thankfully).

I do have a query though, why are no databases showing. Did they get removed with the yum remove command I ran? Could I have done something different to keep the databases?

Thanks
Craig