Issues trying to run Percona Server on Centos 7 with attached disk

MitchnicMitchnic EntrantInactive User Role Participant
I am attempting to run Percona Server on CentOS 7 in a VM on Windows Azure. This is using an attached disk for the data storage.

Unfortunately when I try and get the server to start with the datadir being on the attached disk, it fails for the following reason:
: /usr/bin/mysqld_safe: line 184: /datadrive/mysqldata/binlogs/udb6.log: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: touch: cannot touch ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: chown: cannot access ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: chmod: cannot access ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: 150516 06:05:20 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
May 16 06:05:20 pppudb6 mysqld_safe[50758]: /usr/bin/mysqld_safe: line 147: /datadrive/mysqldata/binlogs/udb6.log: Permission denied
May 16 06:05:20 pppudb6 systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
May 16 06:08:54 pppudb6 systemd[1]: Stopping MySQL Percona Server...
May 16 06:08:54 pppudb6 systemd[1]: Stopped MySQL Percona Server.
May 16 06:08:54 pppudb6 systemd[1]: Unit mysqld.service entered failed state.


Permissions look fine as per:

drwxr-xr-x. 76 mysql mysql 4.0K May 15 03:48 2015-05-12_03-06-22 * This is the mysql data dir
drwxr-xr-x. 2 mysql mysql 4.0K May 15 04:36 binlogs * binlogs dir

Yet, when it attempts to run it says there is the permission issue. If I run it using default settings in /var/lib/mysql it works, just not on the attached disk which would be useful if I could get it to work!

Any ideas? I can get this to run fine on Ubuntu, but not on CentOS.

Comments

  • mirfanmirfan Database Administrator Inactive User Role Mentor
    You can check by sudo mysql user and try to write file from mysql user on /datadrive/mysqldata/ directory.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.