Public bug reported:
Apparmor's mysql configuration prevents initialization (and maybe use)
of mysqld with data in non-standard directories. This problem is easy to
reproduce:
$ /usr/bin/mysql_install_db --no-defaults --user=murrayc
--datadir=/home/murrayc/testmysql_data
Installing MySQL system tables...
130102 17:48:52 [Warning] Can't create test file
/home/murrayc/testmysql_data/murrayc-ThinkPad-X220.lower-test
130102 17:48:52 [Warning] Can't create test file
/home/murrayc/testmysql_data/murrayc-ThinkPad-X220.lower-test
ERROR: 1005 Can't create table 'db' (errno: 13)
130102 17:48:52 [ERROR] Aborting
130102 17:48:52 [Note] /usr/sbin/mysqld: Shutdown complete
This can be worked around by adding this in
/etc/apparmor.d/local/usr.sbin/mysqld:
/home/murrayc/testmysql/data/ r,
/home/murrayc/testmysql/data/** rwk,
but that is not useful to application code, such as Glom, that needs to
use arbitrary paths without asking the (non-technical) user to edit an
apparmor file and restart apparmor.
I'm using Ubuntu Quantal
** Affects: mysql-5.5 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1095370
Title:
apparmor prevents non-default mysql data directories
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1095370/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
