Scheduled Maintenance: We are aware of an issue with Google, AOL, and Yahoo services as email providers which are blocking new registrations. We are trying to fix the issue and we have several internal and external support tickets in process to resolve the issue. Please see: viewtopic.php?t=158230

 

 

 

server - mysql not starting [SOLVED]

Linux Kernel, Network, and Services configuration.
Post Reply
Message
Author
User avatar
ingo
Posts: 195
Joined: 2007-04-15 14:15
Location: http://www.hi-motorbiketours.com

server - mysql not starting [SOLVED]

#1 Post by ingo »

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

Post Reply