[mythtv-users] mysql not starting on boot

Douglas Peale Douglas_Peale at comcast.net
Tue Jul 27 18:15:57 UTC 2010


On 07/27/2010 09:46 AM, paul wrote:
> On 26/07/10 20:20, paul wrote:
>> On 26/07/10 19:51, Douglas Peale wrote:
>>> On 07/25/2010 03:59 AM, paul wrote:
>>>> On 25/07/10 03:08, Douglas Peale wrote:
>>>>> On 07/24/2010 12:38 AM, paul wrote:
>>>>>
>>>>>> After the last update mysql is now not starting on boot, it has to be
>>>>>> started manually, does anyone know how to fix this?
>>>>>>
>>>>>>
>>>>> I'm suffering the same issue. What command are you using to start
>>>>> mysql?
>>>>>
>>>>> I'm using "sudo dpkg-reconfigure mythtv-database" but I'm sure that is
>>>>> not what I should be using.
>>>>>
>>>>> I tried "sudo mysqld start" but that did not work.
>>>>> _______________________________________________
>>>>> mythtv-users mailing list
>>>>> mythtv-users at mythtv.org
>>>>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>>>>
>>>>>
>>>> As it is now an upstart service you use:
>>>>
>>>> sudo service mysql start
>>>>
>>>> Thanks for reporting it as a bug, I wasn't sure if you was specific to
>>>> my set up or not.
>>>>
>>>> Paul
>>>>
>>> My bug report has been marked as a duplicate of Bug #608423
>>> This bug claims to have a fix, but I do not understand how one would
>>> apply it.
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>>
>>
>> The fix appears to be to get mythtv-backed to wait until mysql has
>> started.... as mysql will never start neither will myth-backend.  This
>> bug does not look the same to me.
>>
>> I have tried  "net-device-up IFACE=lo" and "net-device-up IFACE=ath0" 
>> in the /etc/init/mysql.conf file and neither works for my setup.
>>
>> diff -uNr mythtv-0.23.0+fixes25396.old/debian/mythtv-backend.upstart
>> mythtv-0.23.0+fixes25396/debian/mythtv-backend.upstart
>> --- mythtv-0.23.0+fixes25396.old/debian/mythtv-backend.upstart   
>> 2010-07-20 19:02:49.000000000 -0400
>> +++ mythtv-0.23.0+fixes25396/debian/mythtv-backend.upstart   
>> 2010-07-24 02:23:02.836117249 -0400
>> @@ -3,8 +3,10 @@
>>  description     "MythTV Backend"
>>  author          "Mario Limonciello<superm1 at ubuntu.com>"
>>
>> -start on (local-filesystems and net-device-up IFACE=lo and started
>> udev-finish)
>> -stop on starting shutdown
>> +start on (local-filesystems and net-device-up IFACE=lo and started
>> udev-finish
>> +          and started mysql)
>> +stop on (starting shutdown
>> +         or stopping mysql)
>>
>>  #expect fork
>>  respawn
>>
>>
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
> As suggested by Douglas Peale the solution is at the bottom of this bug
> https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/608423,
> 
> The amended /etc/init/mysql.conf is as follows (in full), obviously back
> up the original before trying this version but it has successfully
> started mysql for me bear in mind that I applied the modifications
> suggested in the diff in the 608423 bug report to my existing file:
> 
> Paul
> 
> # MySQL Service
> 
> description     "MySQL Server"
> author          "Mario Limonciello <superm1 at ubuntu.com>"
> 
> start on (net-device-up
>           and local-filesystems
>       and runlevel [2345])
> stop on runlevel [016]
> 
> respawn
> 
> env HOME=/etc/mysql
> umask 007
> 
> pre-start script
>     #Sanity checks
>     [ -r $HOME/my.cnf ]
>     [ -d /var/run/mysqld ] || install -m 755 -o mysql -g root -d
> /var/run/mysqld
>     # Load AppArmor profile
>     if aa-status --enabled 2>/dev/null; then
>         apparmor_parser -r /etc/apparmor.d/usr.sbin.mysqld || true
>     fi
>     LC_ALL=C BLOCKSIZE= df --portability /var/lib/mysql/. | tail -n 1 |
> awk '{ exit ($4<4096) }'
> end script
> 
> exec /usr/sbin/mysqld
> 
> post-start script
>     for i in `seq 1 30` ; do
>         /usr/bin/mysqladmin --defaults-file="$HOME"/debian.cnf ping && {
>             exec "$HOME"/debian-start
>             #Should not reach this line
>             exit 2
>         }
>         sleep 1
>     done
>     echo "timeout waiting for mysqld" >&2
>     exit 1
> end script
> 
> 
> 

Thank you for including the entire file. I was unable to figure out how to implement the fix via the bug report page. This I was
able to implement, and yes it does work.


More information about the mythtv-users mailing list