Bug #810270 https://bugs.launchpad.net/ubuntu/+source/apparmor/+bug/810270 told me to report a new bug, so here it is.
I'm affraid the apparmor bug is not fixed yet for mysql Ver 14.14 Distrib 5.1.58, for debian-linux-gnu (x86_64). http://penguindroppings.wordpress.com/2009/07/07/should-i-disable-apparmor/ was my help to temporary disable the profile for mysql to get things working again:
sudo apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld
sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/usr.sbin.mysqld
sudo service mysql start
mysql start/running, process 3024
Before doing this, I got this from dmesg:
type=1400 audit(1319135491.751:5641): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=2704 comm="apparmor_parser"
[84848.322283] type=1400 audit(1319135491.915:5642): apparmor="DENIED" operation="mknod" parent=1 profile="/usr/sbin/mysqld" name="/run/mysqld/mysqld.sock" pid=2708 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=116 ouid=116
[84853.637467] init: mysql main process (2708) terminated with status 1
[84853.637505] init: mysql main process ended, respawning
Hi Jurgen,
Thank you for taking the time to report bugs and trying to make Ubuntu Server better.
Unfortunately, I have been unable to reproduce this bug report in oneiric. I have installed mysql-server in a clean ubuntu installation and I have not received the apparmor errors and mysql server is working as expected.
Logs of apparmor show:
Nov 10 13:12:04 ***** kernel: [11190.491403] type=1400 audit(132094872 4.601:31) : apparmor="STATUS" operation= "profile_ replace" name="/ usr/sbin/ mysqld" pid=1056 comm="apparmor_ parser" 4.629:32) : apparmor="STATUS" operation= "profile_ replace" name="/ usr/sbin/ mysqld" pid=1087 comm="apparmor_ parser"
Nov 10 13:12:04 ***** kernel: [11190.518857] type=1400 audit(132094872
Are you still experiencing this issue?
For now, I'll mark this bug as incomplete until further confirmation of the bug report is received.