I have verified that the user can read and write as I mentioned in my first post.
Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network Engineer Safe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 26, 2007 12:37 PM To: David Ruggles Subject: RE: Select into outfile on nfs mount point >>> Date: Monday, March 26, 2007 11:50:59 AM -0400 >>> From: David Ruggles <[EMAIL PROTECTED]> >>> To: mysql@lists.mysql.com >>> Subject: Select into outfile on nfs mount point >>> >>> I'm unable to select into an outfile, the path is in an nfs mount >>> point. I'm sure it's some sort of permissions issue or something, >>> but I can't figure it out. I've googled everything I can think of >>> and haven't found anything. Any help or suggestions would be greatly >>> appreciated. >>> >>> The error I'm getting is: >>> Error Code : 1 >>> Can't create/write to file './sqldata/test.txt' (Errcode: 524) >>> >>> I see from the mysql site that Error Code 1 = Operation not >>> permitted >>> >>> The sqldata is an nfs mount to another server with full read/write >>> permissions. I can read and write without problem from the >>> commandline as the mysql user. >> Sent: Monday, March 26, 2007 12:01 PM >> >> the file on the mount point has to be able to be created, and >> read/write by the user that is invoking the mysql call. e.g., if this >> is begin done at the commandline - then it's the logged-in user (not >> the user "-u <user>" on the mysql command). if via a script, then by >> whatever user is calling the script (e.g., if via cron, what user is >> the crontab under). if it's through a web server, then it's the user >> that the web server is running as. >> >> - Rick > > From: David Ruggles <[EMAIL PROTECTED]> > Yes, but wouldn't it be the user that the mysql service is running > as? That is the user I am logging in as to test this. > yes, sorry, i misspoke (have to admit that i don't use "outfile" much). the file is indeed written by the user running mysqld, generally "mysql". make certain that that user can create (e.g., using "touch") files in the desired location. - Rick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
