[Bug 227615] [NEW] mysql failing to start due to permission errors

[vik]

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.