LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices



Reply
 
Search this Thread
Old 09-09-2010, 08:28 AM   #1
naveenrajn
LQ Newbie
 
Registered: Mar 2005
Location: India
Distribution: Redhat
Posts: 21

Rep: Reputation: 0
After moving mysql db to NFS[netapp] unable to start mysql server throws error


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 ???
 
Old 09-09-2010, 09:07 AM   #2
naveenrajn
LQ Newbie
 
Registered: Mar 2005
Location: India
Distribution: Redhat
Posts: 21

Original Poster
Rep: Reputation: 0
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???
 
Old 09-09-2010, 09:12 AM   #3
carltm
Member
 
Registered: Jan 2007
Location: Canton, MI
Distribution: CentOS, SuSE, Red Hat, Debian, etc.
Posts: 700

Rep: Reputation: 96
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.
 
Old 09-13-2010, 03:20 AM   #4
naveenrajn
LQ Newbie
 
Registered: Mar 2005
Location: India
Distribution: Redhat
Posts: 21

Original Poster
Rep: Reputation: 0
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 03:13 PM
MySQL 5.0.67: Unable to install & run. Error /var/lib/mysql/mysql.sock' (2) peteyperson Linux - Server 2 03-04-2009 02:16 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 04:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM


All times are GMT -5. The time now is 11:00 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration