Arch Linux

walterjwhite

Member

Registered: 2011-05-01

Posts: 207

mysql + aufs / tmpfs

Hi all,

I'm running my machines with an aufs root so I'm using tmpfs to make everything writable.  The problem that I'm having is that I cannot start mysql:

[root@L153CDO007005 ~]# systemctl status mysqld
mysqld.service - MySQL database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled)
   Active: activating (start-post) (Result: exit-code) since Thu 2013-07-18 10:28:14 EDT; 5s ago
  Process: 12114 ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
  Control: 12115 (mysqld-post)
   CGroup: name=systemd:/system/mysqld.service
           └─control
             ├─12115 /bin/sh /usr/bin/mysqld-post
             └─12165 sleep 1

Jul 18 10:28:14 L153CDO007005 mysqld[12114]: 130718 10:28:14 [Warning] Can't create test file /var/lib/...test
Jul 18 10:28:14 L153CDO007005 mysqld[12114]: 130718 10:28:14 [Warning] Can't create test file /var/lib/...test
Jul 18 10:28:14 L153CDO007005 systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE

The owner and group on /var/lib/mysql is mysql:mysql and I even tried mounting another tmpfs volume at /var/lib/mysql (rather than the root aufs) and have the same issue.  It appears to be a permission issue, but mysql is the owner and group.

What else am I missing here?

Thanks,

Walter

walterjwhite

Member

Registered: 2011-05-01

Posts: 207

Re: mysql + aufs / tmpfs

It appears the problem appears to be the underlying filesystem has the wrong permissions.  Even though the tmpfs filesystem has the correct information it still causes permission denied.

Hence going forward, I need to ensure the underlying filesystem has the correct permissions.

Walter