[mythtv-users] mysql does not start as service after reboot

[Bill Meek]

On 10/21/2012 03:50 PM, R KANNAN wrote:
>> On Thu, Oct 18, 2012 at 3:34 PM, R KANNAN <rk111810 at gmail.com> wrote:
>>> pre-start script
>>>      #Sanity checks
>>>      [ -r $HOME/my.cnf ]
>>>      [ -d /var/run/mysqld ] || install -m 755 -o mysql -g root -d /var/run/mysqld
>>>      /lib/init/apparmor-profile-load usr.sbin.mysqld
>>>      LC_ALL=C BLOCKSIZE= df --portability /var/lib/mysql/. | tail -n 1
>>> | awk '{ exit ($4<4096) }'
>>> end script
> Oct 21 16:38:00 DVR kernel: [  216.952263] init: mysql pre-start
> process (2541) terminated with status 1

Hi;

By any chance did you delete /var/lib/mysql after copying your MySQL files
to some other directory (spindle?) If so, fix the df command above, otherwise:

Since the mysql.conf pre-start script is failing, run each command
in that script to see which line is returning a 1.

For example:

   sudo [ -r /etc/mysql/my.cnf ];echo $?

If /etc/mysql/my.cnf is readable, echo $? should return a 0. Then
do each of the following *one at a time* and check the response.

   sudo [ -d /var/run/mysqld ] || install -m 755 -o mysql -g root -d /var/run/mysqld;echo $?

   sudo /lib/init/apparmor-profile-load usr.sbin.mysqld;echo $?

   LC_ALL=C BLOCKSIZE= sudo df --portability /var/lib/mysql/. | tail -n 1 | awk '{ exit ($4<4096) }';echo $?

Complete all of the above (just in case more that 1 is failing.) The mysql logs aren't
likely to have anything in them because mysqld isn't starting.

I did the above on my 12.04 system and all 4 lines returned 0.

-- 
Bill