server - mysql not starting [SOLVED]

Kernels & Hardware, configuring network, installing services

server - mysql not starting [SOLVED]

Postby ingo » 2017-03-17 09:59

Was it a bird? Was it a plane? No, it was a super bug!

Having restarted my server last night I wanted to check something on my website this morning and was greeted by a database error.

The error log in /var/lib/mysql/ spat out
Code: Select all
/usr/sbin/mysqld: Can't read dir of '/etc/mysql/mariadb.conf.d/' (Errcode: 2 - No such file or directory)
Fatal error in defaults handling. Program aborted

So I checked
Code: Select all
root@178:/etc/mysql# lla
total 48
drwxr-xr-x   5 root root  4096 Mar 17 11:25 .
drwxr-xr-x 127 root root 12288 Mar 17 03:01 ..
drwxr-xr-x   2 root root  4096 Mar 17 03:01 conf.d
-rw-------   1 root root   333 Dec  9  2012 debian.cnf
-rwxr-xr-x   1 root root  1193 Apr 20  2016 debian-start
-rw-r--r--   1 root root   869 Oct  2 00:11 mariadb.cnf
drwxr-xr-x   2 root root  4096 Mar 17 11:25 mariad.conf.d
lrwxrwxrwx   1 root root    24 Dec 10 16:35 my.cnf -> /etc/alternatives/my.cnf
-rw-r--r--   1 root root   839 Jul  9  2016 my.cnf.fallback
-rw-r--r--   1 root root   682 Apr 20  2016 mysql.cnf
drwxr-xr-x   2 root root  4096 Dec 10 16:42 mysql.conf.d
No /etc/mysql/mariadb.conf.d/ at all but a /etc/mysql/mariad.conf.d/

A quick
Code: Select all
mkdir -p /etc/mysql/mariadb.conf.d
and mysql started without probs.

Still, a very odd thing to happen...
User avatar
ingo
 
Posts: 197
Joined: 2007-04-15 14:15
Location: http://www.hi-motorbiketours.com

Return to System configuration

Who is online

Users browsing this forum: No registered users and 9 guests

fashionable