apparmor blocks starting of mariadb in ubuntu ocelot (11.10)

[Carl Leitner]

Apparently in Ubuntu 11.10 /var/run has been moved to /run. This causes apparmor to prevent mariadb from running.

See the following related bug reports:
 https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/810580
 https://bugs.launchpad.net/ubuntu/+source/apparmor/+bug/810270

To fix it manually, in the file:
 /etc/apparmor.d/usr.sbin.mysql
I changed the lines:
  /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,

I _think_ that this needs to be fixed on mariadb's end and that this is what was done for the mysql package. In any case, it works and matches the changes made for other profiles under /etc/apparmor.d

[Kristian Nielsen (knielsen)]

The default AppArmor profile in MariaDB for Ubuntu has been removed. This wil eliminate this problem.
The fix will be in 5.1.56, 5.2.9, 5.3.3, and 5.5.x.