Public bug reported: Package: mysql-server-5.1 Release: Karmic alpha-6 (up-to-date @ bugreport) Version: 5.1.37-1ubuntu4
Hello, I have installed a LAMP server when installed the base system. Usually I use mysql in chroot-ed environment, here is a good howto: http://blog.blackdown.de/2006/12/30/chrooting-recent-mysql-versions-on-debian-and-ubuntu/ When I started the mysql, in logs there are these messages: ... mysqld: 090922 15:47:43 [ERROR] chroot: Operation not permitted ... mysqld: 090922 15:47:43 [ERROR] Aborting Since Jaunty, when mysql runs in chroot, there must modify the apparmor config (enable sys_chroot cap, and accesing many files - it passed). Then were: ... mysqld: 090922 15:57:40 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! ... mysqld: ... mysqld: 090922 15:57:40 [ERROR] Aborting ... mysqld: Okay, I changed running user from mysql to root - mysql started in chroot. It's not a good idea to run as root, I rejected this chance. I moved usr.sbin.mysqld from apparmor directory, then mysql started in chroot, but it wanted to use /var/log/mysql/mysql.log instead of $CHROOT/var/log/mysql/mysql.log. (In /proc/pid_of_mysql/root contains only the restricted chroot, which I've set up, so mysql ran in chroot it sure) I downgraded to mysql-server-5.0, and now mysql runs perfectly in chroot with user mysql. ** Affects: ubuntu Importance: Undecided Status: New ** Tags: apparmor chroot mysql -- mysql-server-5.1 can't chroot https://bugs.launchpad.net/bugs/434915 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs