[debian-mysql] Bug#663000: mysql-server: MySQL fails to start after 5.1.61 upgrade, incorrect permissions

[Alex Cartwright]

Package: mysql-server
Version: 5.1.61-0+squeeze1
Severity: important

After the recent security upgrade to MySQL 5.1.61, MySQL failed to start
during the "apt-get update && apt-get upgrade" process due to incorrect
permissions being set on the /var/lib/mysql/mysql-bin.* files.

Instead of being mysql:mysql they were set to root:root, causing MySQL
to fail starting with errors such as:

Mar  7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Failed
to open log (file './mysql-bin.000397', errno 13)
Mar  7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Could
not open log file
Mar  7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Can't
init tc log
Mar  7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR]
Aborting

Changing the owner/group to mysql:mysql manually and starting the
"mysql" service got things working, however running update && upgrade
again causes the issue again.


-- System Information:
Debian Release: 6.0.4
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.0.18-x86_64-linode24 (SMP w/4 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-server depends on:
pn  mysql-server-5.1              <none>     (no description available)

mysql-server recommends no packages.

mysql-server suggests no packages.

-- no debconf information