[mythtv-users] mysql not starting on boot
paul
paul.bubbles at yahoo.co.uk
Tue Jul 27 16:46:22 UTC 2010
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
More information about the mythtv-users
mailing list