Public bug reported: Binary package hint: mysql-server-5.0
I have installed ubuntu server 8.04, and have set up a directory structure where /var/lib is a symlink to a different volume (/mnt/fastdata/var/lib). Mysqld fails to start with the following errors in syslog: May 7 15:51:55 vcke-gl-linux mysqld_safe[5886]: started May 7 15:51:55 vcke-gl-linux kernel: [ 82.391726] audit(1210139515.249:2): type=1503 operation="inode_create" requested_mask="w::" denied_mask="w::" name="/mnt/fastdata/var/lib/mysql/vcke-gl-linux.lower-test" pid=5888 profile="/usr/sbin/mysqld" namespace="default" May 7 15:51:55 vcke-gl-linux mysqld[5890]: 080507 15:51:55 [Warning] Can't create test file /var/lib/mysql/vcke-gl-linux.lower-test May 7 15:51:55 vcke-gl-linux kernel: [ 82.393387] audit(1210139515.259:3): type=1503 operation="inode_create" requested_mask="w::" denied_mask="w::" name="/mnt/fastdata/var/lib/mysql/vcke-gl-linux.lower-test" pid=5888 profile="/usr/sbin/mysqld" namespace="default" May 7 15:51:55 vcke-gl-linux mysqld[5890]: 080507 15:51:55 [Warning] Can't create test file /var/lib/mysql/vcke-gl-linux.lower-test May 7 15:51:55 vcke-gl-linux kernel: [ 82.487247] audit(1210139515.349:4): type=1503 operation="inode_create" requested_mask="w::" denied_mask="w::" name="/mnt/fastdata/tmp/ib7jXL82" pid=5888 profile="/usr/sbin/mysqld" namespace="default" May 7 15:51:55 vcke-gl-linux mysqld[5890]: ^G/usr/sbin/mysqld: Can't create/write to file '/tmp/ib7jXL82' (Errcode: 13) May 7 15:51:55 vcke-gl-linux mysqld[5890]: 080507 15:51:55 InnoDB: Error: unable to create temporary file; errno: 13 May 7 15:51:55 vcke-gl-linux kernel: [ 82.508111] audit(1210139515.369:5): type=1503 operation="inode_mknod" requested_mask="w::" denied_mask="w::" name="/mnt/fastdata/var/run/mysqld/mysqld.sock" pid=5888 profile="/usr/sbin/mysqld" namespace="default" May 7 15:51:55 vcke-gl-linux mysqld[5890]: 080507 15:51:55 [ERROR] Can't start server : Bind on unix socket: Permission denied May 7 15:51:55 vcke-gl-linux mysqld[5890]: 080507 15:51:55 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ? May 7 15:51:55 vcke-gl-linux mysqld[5890]: 080507 15:51:55 [ERROR] Aborting May 7 15:51:55 vcke-gl-linux mysqld[5890]: May 7 15:51:55 vcke-gl-linux mysqld[5890]: 080507 15:51:55 [Note] /usr/sbin/mysqld: Shutdown complete May 7 15:51:55 vcke-gl-linux mysqld[5890]: May 7 15:51:55 vcke-gl-linux mysqld_safe[5892]: ended As far as I can tell, the permissions in /var/lib/mysql are correct: $ ls -ld /var/lib/mysql drwxr-xr-x 3 mysql mysql 4096 2008-05-07 16:09 /var/lib/mysql $ ls -ld /mnt/fastdata/var/lib/mysql drwxr-xr-x 3 mysql mysql 4096 2008-05-07 16:09 /mnt/fastdata/var/lib/mysql (/var/lib/ is a symlink to /mnt/fastdata/lib) This seems to be a problem if the directory for mysql data is anywhere outside /var/lib/mysql : http://ubuntuforums.org/showthread.php?t=782224 I have tried purging and re-installing mysql-server-5.0 to no avail. Other info: $ apt-cache policy mysql-server-5.0 mysql-server-5.0: Installed: 5.0.51a-3ubuntu5 Candidate: 5.0.51a-3ubuntu5 Version table: *** 5.0.51a-3ubuntu5 0 500 http://ftp.netspace.net.au hardy/main Packages 100 /var/lib/dpkg/status $ lsb_release -rd Description: Ubuntu 8.04 Release: 8.04 ** Affects: mysql-dfsg-5.0 (Ubuntu) Importance: Undecided Status: New -- mysql failing to start due to permission errors https://bugs.launchpad.net/bugs/227615 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
