[SOLVED] MariaDB server refuses to start

UltrasonicMadness · 06-02-2014, 05:26 PM

Hi LinuxQuestions.

I have been trying to set up a local server and I have been having problems starting mariadb. I have followed some tutorials and, as a result, seem to have created an error. When I try to start the mariadb service (service mariadb start), I get this.

Code:

Redirecting to /bin/systemctl start  mariadb.service
Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.

When I type 'systemctl status mariadb.service', I get this:

Code:

mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled)
   Active: failed (Result: exit-code) since Mon 2014-06-02 22:48:58 BST; 33min ago
  Process: 10042 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
  Process: 10041 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 10013 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 10041 (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/mariadb.service

Jun 02 22:48:56 ultrasonicfortress mysqld_safe[10041]: 140602 22:48:56 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Jun 02 22:48:56 ultrasonicfortress mysqld_safe[10041]: 140602 22:48:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jun 02 22:48:58 ultrasonicfortress mysqld_safe[10041]: 140602 22:48:58 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Jun 02 22:48:58 ultrasonicfortress systemd[1]: mariadb.service: control process exited, code=exited status=1
Jun 02 22:48:58 ultrasonicfortress systemd[1]: Failed to start MariaDB database server.
Jun 02 22:48:58 ultrasonicfortress systemd[1]: Unit mariadb.service entered failed state.

There were permission errors around /var/log/mariadb/mariadb.log, which I fixed by changing the 'owner' of mariadb.log from root to mysql.

The result of 'journalctl -xn' is:

Code:

-- Logs begin at Mon 2014-05-05 14:27:12 BST, end at Mon 2014-06-02 23:18:13 BST. --
Jun 02 23:01:01 ultrasonicfortress run-parts[10324]: (/etc/cron.hourly) starting mcelog.cron
Jun 02 23:01:01 ultrasonicfortress run-parts[10329]: (/etc/cron.hourly) finished mcelog.cron
Jun 02 23:18:12 ultrasonicfortress systemd[1]: Starting dnf makecache...
-- Subject: Unit dnf-makecache.service has begun with start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit dnf-makecache.service has begun starting up.
Jun 02 23:18:13 ultrasonicfortress dnf[10445]: Config time: 0.019
Jun 02 23:18:13 ultrasonicfortress dnf[10445]: cachedir: /var/cache/dnf/i386/20
Jun 02 23:18:13 ultrasonicfortress dnf[10445]: dnf version: 0.5.2
Jun 02 23:18:13 ultrasonicfortress dnf[10445]: Making cache files for all metadata files.
Jun 02 23:18:13 ultrasonicfortress dnf[10445]: Metadata cache refreshed recently.
Jun 02 23:18:13 ultrasonicfortress dnf[10445]: Cleaning up.
Jun 02 23:18:13 ultrasonicfortress systemd[1]: Started dnf makecache.
-- Subject: Unit dnf-makecache.service has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit dnf-makecache.service has finished starting up.
-- 
-- The start-up result is done.

I would ultimately like to try out web applications like Simple Machines Forum on this server.

Best regards, and thank you in advance
UltrasonicMadness

UltrasonicMadness · 06-03-2014, 05:36 AM

Forgot to ask a coherent question.

How do I reset the database settings to default or fix this problem? I ask because I don't know of any equivalent to 'apt-get purge' with yum.

Thanks again
UltrasonicMadness

potato_farmer · 06-03-2014, 10:14 AM

If you do not have any databases you need to back up, you can simply run the following as root:

service mariadb stop
yum remove mariadb-server
cd /var/lib && rm -rfv mysql
yum -y install mariadb-server

This should give you a clean copy of mariadb-server.

Edit: As UltrasonicMadness correctly pointed out, he was using mariadb, not mysql. Renamed "mysql" to "mariadb".

UltrasonicMadness · 06-03-2014, 10:33 AM

Thank you. I had to amend some of the steps because of the nature of the problem (service wouldn't start, therefore stopping wasn't needed) and the fact that I was using MariaDB, which is a fork of MySQL.

I ran this as root:

yum remove mariadb-server
cd /var/lib && rm -rfv mysql
yum install mariadb-server

This may come off as overly pedantic but I would like this thread to assist others and not just waste space on the LQ servers. Removing the -y from yum install was just a personal preference.

Thanks again
UltrasonicMadness

remymuhire250 · 09-29-2015, 12:39 PM

Please can you help with the linux command for changing the 'owner' of mariadb.log from root to mysql.

chrism01 · 09-29-2015, 07:49 PM

@remymuhire250: please start a new thread; this one is over a year old and has been marked as SOLVED already...