@Clint: You suggested that the comment on http://tanghus.net/2012/03/yet-another-mysql-vs-apparmor-barf/#comment-298 is related, which seems to be the case. What I experienced wasn't a missing /etc/apparmor.d/local/usr.sbin.mysqld, but rather that the update would have changed the paths back to the not-working /var/run/* paths after I had manually corrected them to use /run prior to upgrading to Precise.
I didn't have an image earlier than 12.04, but tried to install mysql-server in a VM (it wasn't available in proposed anymore?). I'm not sure what conditional logic to look for in /var/lib/dpkg/info/mysql-server-5.5.postrm. /var/lib/dpkg/info/mysql-server-5.1.postrm does get removed on purge, but I assume that is intended behaviour?
/etc/apparmor.d/local/usr.sbin.mysqld is empty except for:
# Site-specific additions and overrides for usr.sbin.mysqld.
# For more details, please see /etc/apparmor.d/local/README.
Aug 14 14:34:30 NemID-VirtualBox kernel: [ 1530.635603] type=1400 audit(1344947670.136:27): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=6072 comm="apparmor_parser"
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/debian-start[6116]: Upgrading MySQL tables if necessary.
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/debian-start[6119]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/debian-start[6119]: Looking for 'mysql' as: /usr/bin/mysql
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/debian-start[6119]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/debian-start[6119]: This installation of MySQL is already upgraded to 5.5.24, use --force if you still need to run mysql_upgrade
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/debian-start[6130]: Checking for insecure root accounts.
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/debian-start[6135]: Triggering myisam-recover for all MyISAM tables
@Clint: You suggested that the comment on http:// tanghus. net/2012/ 03/yet- another- mysql-vs- apparmor- barf/#comment- 298 is related, which seems to be the case. What I experienced wasn't a missing /etc/apparmor. d/local/ usr.sbin. mysqld, but rather that the update would have changed the paths back to the not-working /var/run/* paths after I had manually corrected them to use /run prior to upgrading to Precise. dpkg/info/ mysql-server- 5.5.postrm. /var/lib/ dpkg/info/ mysql-server- 5.1.postrm does get removed on purge, but I assume that is intended behaviour?
I didn't have an image earlier than 12.04, but tried to install mysql-server in a VM (it wasn't available in proposed anymore?). I'm not sure what conditional logic to look for in /var/lib/
/etc/apparmor. d/local/ usr.sbin. mysqld is empty except for:
# Site-specific additions and overrides for usr.sbin.mysqld. d/local/ README.
# For more details, please see /etc/apparmor.
/etc/apparmor. d/usr.sbin. mysqld otoh contains both:
/var/ run/mysqld/ mysqld. pid w, run/mysqld/ mysqld. sock w, mysqld/ mysqld. pid w, mysqld/ mysqld. sock w,
/var/
/run/
/run/
But mysql runs fine:
Aug 14 14:34:30 NemID-VirtualBox kernel: [ 1530.635603] type=1400 audit(134494767 0.136:27) : apparmor="STATUS" operation= "profile_ replace" name="/ usr/sbin/ mysqld" pid=6072 comm="apparmor_ parser" debian- start[6116] : Upgrading MySQL tables if necessary. debian- start[6119] : /usr/bin/ mysql_upgrade: the '--basedir' option is always ignored debian- start[6119] : Looking for 'mysql' as: /usr/bin/mysql debian- start[6119] : Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck debian- start[6119] : This installation of MySQL is already upgraded to 5.5.24, use --force if you still need to run mysql_upgrade debian- start[6130] : Checking for insecure root accounts. debian- start[6135] : Triggering myisam-recover for all MyISAM tables
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/
Aug 14 14:34:32 NemID-VirtualBox /etc/mysql/