After moving mysql db to NFS[netapp] unable to start mysql server throws error

naveenrajn · 09-09-2010, 07:28 AM

Hi All,
Need help with mysql db data store movement. After moving the mysql db data store to NFS drive[netapp] i am unable to start mysql server. It throws the below error

Code:

service mysqld start
touch: cannot touch `/usr/mysql/log/mysqld.log': Permission denied
chmod: changing permissions of `/usr/mysql/log/mysqld.log': Operation not permitted
chown: changing ownership of `/usr/mysql': Operation not permitted
chmod: changing permissions of `/usr/mysql': Operation not permitted
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]

Any ideas ???

naveenrajn · 09-09-2010, 08:07 AM

Ok got a workaround.
I assume the problem was with local root not able to write to the new mysql data store[NFS drive - netapp]. Had to add the linux server [mysql host server] to list of admin servers in the netapp filer, this is just for starting mysql server once its started it can be removed from the list.
This should work as once mysql server is started user switches from root to mysql.

Any other ideas anyone???

carltm · 09-09-2010, 08:12 AM

Your NFS partition will have its own set of users that probably don't
corespond to the list of users on the mysql server. The one user
that does need to be right is mysql. Make sure that the user id for
the NFS user mysql is the same as the user id for the server's user
mysql. And make sure that the NFS user has read/write access to
the required directories.

naveenrajn · 09-13-2010, 02:20 AM

Yes i did notice there were 2 'mysql' users, one local to the MySQL server and another NIS 'mysql' user with different uids and gids. As you suggested i tried making the local mysql user same as NIS user by copying the line from the NIS passwd file to the local machine and gave write permission to the dir to mysql user. The 'mysql' user had write permissions but local root was not able to write to the NFS drive. It only started working after adding the MySQL server to the list of admin hosts to the Netapp - this will enable local roots to write to the NFS shares comming from Netapp Filer.