[Bug 434915] [NEW] mysql-server-5.1 can't chroot

[Launchpad Bug Tracker]

You have been subscribed to a public bug:

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: mysql-dfsg-5.1 (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 Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.