mysql fails to start due to error in /etc/apparmor.d/usr.sbin.mysqld

[heynnema]

I just upgraded from 32-bit Oneiric to 64-bit Oneirc with a fresh install. After manually reinstalling my desired apps, I find that mysql (which is being used by MythTV 0.24, in my case) won't start. I know that I reported this exact same error years ago, but only to find that it's still hanging around.

The file /etc/apparmor.d/usr.sbin.mysqld has two errors in it.

Lines 36 and 37 are wrong, and,

need to change from:
  /{,var/run/mysqld/mysqld.pid w,
  /{,var/run/mysqld/mysqld.sock w,

to:
  /{,var/}run/mysqld/mysqld.pid w,
  /{,var/}run/mysqld/mysqld.sock w,

Cheers, Al

ProblemType: Bug
DistroRelease: Ubuntu 11.10
Package: mysql-server-core-5.1 5.1.61-0ubuntu0.11.10.1
ProcVersionSignature: Ubuntu 3.0.0-16.29-generic 3.0.20
Uname: Linux 3.0.0-16-generic x86_64
ApportVersion: 1.23-0ubuntu4
Architecture: amd64
Date: Thu Mar 22 13:22:55 2012
ExecutablePath: /usr/sbin/mysqld
InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64 (20111012)
ProcAttrCurrent: /usr/sbin/mysqld (enforce)
ProcEnviron: PATH=(custom, no user)
SourcePackage: mysql-5.1
UpgradeStatus: No upgrade log present (probably fresh install)

[James Page (james-page)]

Thank you for taking the time to report this bug and helping to make Ubuntu better.

I double checked this package in Oneiric and it should install the correct apparmor profile:

http://bazaar.launchpad.net/~ubuntu-branches/ubuntu/oneiric/mysql-5.1/oneiric-updates/view/head:/debian/apparmor-profile

So I'm a little confused as to why your profile is broken.

I tried to reproduce your issue with a fresh mysql install - but no luck.... I get the correct profile.

Is it possible something else is modifying this profile? I can't find anything in the archive that might.

[heynnema (heynnema)]

James,

In reviewing the code that you refer to, you're correct. It's got the correct stuff for lines 36/37. Interestingly enough, it still indicates a last mod date in 2007 (as does my copy).

I've tried to locate any other app install that may have replaced this file with an older copy, and I can't seem to find any. MythTV would have been my first guess, but it's not there. Is there any way to easily identify other apps, that I might have installed, that might have replaced it with the broken copy?

Cheers, Al

[Jamie Strandboge (jdstrand)]

mysql-5.1 has been removed from the archive (LP: #894377).