Re: [Bug 582970] Re: mysql-server won't start after update
On 19/05/10 21:34 Serobur wrote: > Can you please describe in details how to fix it? > I'm not sure when fix will be in updates and need mysql to be running now. > If MySQL won't start because of permissions problems (try running sudo -u mysql mysqld or check /var/log/messages and /var/log/mysql/error.log, then this is the same problem that I am having. (Especially if you have changed the location of some files from the defaults.) Check that data and log file directories have the correct rw permissions. Then check /etc/apparmor.d/usr.sbin.mysqld permissions. -- mysql-server won't start after update https://bugs.launchpad.net/bugs/582970 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 582970] Re: mysql-server won't start after update
Can you please describe in details how to fix it? I'm not sure when fix will be in updates and need mysql to be running now. -- mysql-server won't start after update https://bugs.launchpad.net/bugs/582970 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 582970] Re: mysql-server won't start after update
I've found the cause of the problem. It was due to mysql not having permissions to the appropriate directories in AppArmor. Changing them fixed it. Question: why did MySQL run before the update without the permissions?!? (Another bug report, I think.) ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: New => Fix Released -- mysql-server won't start after update https://bugs.launchpad.net/bugs/582970 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 582970] Re: mysql-server won't start after update
/var/log/messages has entries such as: May 19 18:53:16 dwaible kernel: [ 111.737472] type=1505 audit(1274291596.871:17): operation="profile_replace" pid=2491 name="/usr/sbin/mysqld" May 19 18:53:16 dwaible kernel: [ 111.824343] type=1503 audit(1274291596.961:18): operation="mknod" pid=2495 parent=1 profile="/usr/sbin/mysqld" requested_mask="c::" denied_mask="c::" fsuid=0 ouid=0 name="/srv/var/lib/mysql/dwaible.lower-test" May 19 18:53:16 dwaible kernel: [ 111.824471] type=1503 audit(1274291596.961:19): operation="mknod" pid=2495 parent=1 profile="/usr/sbin/mysqld" requested_mask="c::" denied_mask="c::" fsuid=0 ouid=0 name="/srv/var/lib/mysql/dwaible.lower-test" May 19 18:53:16 dwaible kernel: [ 111.840412] type=1503 audit(1274291596.981:20): operation="mknod" pid=2495 parent=1 profile="/usr/sbin/mysqld" requested_mask="c::" denied_mask="c::" fsuid=123 ouid=123 name="/srv/var/log/mysql/error.log" May 19 18:53:16 dwaible kernel: [ 111.850493] type=1503 audit(1274291596.991:21): operation="open" pid=2495 parent=1 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=123 ouid=123 name="/srv/var/lib/mysql/mysql/plugin.frm" Ok. It's not being given access, even though the permissions on the files are fine. So what's blocking it? -- mysql-server won't start after update https://bugs.launchpad.net/bugs/582970 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 582970] Re: mysql-server won't start after update
** Attachment added: ".etc.apparmor.d.usr.sbin.mysqld.txt" http://launchpadlibrarian.net/48737077/.etc.apparmor.d.usr.sbin.mysqld.txt ** Attachment added: "Dependencies.txt" http://launchpadlibrarian.net/48737078/Dependencies.txt ** Attachment added: "Logs.var.log.daemon.log.txt" http://launchpadlibrarian.net/48737079/Logs.var.log.daemon.log.txt ** Attachment added: "Logs.var.log.kern.log.txt" http://launchpadlibrarian.net/48737080/Logs.var.log.kern.log.txt ** Attachment added: "MySQLConf.etc.mysql.my.cnf.txt" http://launchpadlibrarian.net/48737081/MySQLConf.etc.mysql.my.cnf.txt -- mysql-server won't start after update https://bugs.launchpad.net/bugs/582970 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs