Mysql my.cnf as simbolic link in Ubuntu 12.04
- by Juan Cruz
I am not able to use symlink for my.cnf file (Ubuntu 12.04 server).
I added the alias to /etc/apparmor.d/tunables/alias file (as I did for 10.04 and worked) but I get:
May 30 16:00:01 ip-10-242-209-203 kernel: [176926.213403] type=1400 audit(1338393601.350:244): apparmor="DENIED" operation="open" parent=1 profile="/usr/sbin/mysqld" name="/opt/data/my.cnf" pid=18128 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
May 30 16:00:01 ip-10-242-209-203 kernel: [176926.222016] init: mysql main process (18128) terminated with status 1
May 30 16:00:01 ip-10-242-209-203 kernel: [176926.222084] init: mysql respawning too fast, stopped
As a workaround I added the following line
/etc/mysql/my.cnf r,
to the /etc/apparmor.d/local/usr.sbin.mysqld file.
The default configuration is
/etc/mysql/*.cnf r,
Is this a bug? is an apparmor bug or a mysql bug? It seems that that configuration has changed since MySql 5.1 (https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/619172) but now worked for me.
Thanks!