2
I've got a directory, /var/www/someProject/backup/mysql, and I want the user mysql to write to it. Each time I try to write to it with the mysql user, I get a "can't read/write" error. Yet the directory is 777 as you can see here:
drwxrwxrwx 2 aUser users 4096 2010-03-17 17:14 mysql
I also tried to chown the directory to mysql:mysql, just like the home dir of the mysql user, but no luck, that changed nothing.
What am I doing wrong here? Or is the mysql user limited to his home dir in some other way in Ubuntu? Been bugging me for days now, this problem so any help greatly appreciated.
777 permissions are wrong in most cases. – geek – 2010-03-19T12:43:35.407
I know, and so is changing the owner as I don't want mysql to become the owner, just trying out stuff to get this to work. Any idea what I might be doing wrong here? I'm pretty noob towards linux. – Peter – 2010-03-19T12:58:11.927
Could you add the exact error message you are seeing ? Is there some additional information in the mysql log file ? – Dominik – 2010-03-19T14:54:32.160
The full error message is: Message: Mysqli statement execute error : Can't create/write to file '/var/www/someProject/backup/mysql/1269005862_tableName.sql' (Errcode: 13) Cheers for trying to help me out Dominik – Peter – 2010-03-19T15:31:56.017
Just double checked my mysql logs and they are empty – Peter – 2010-03-19T15:35:44.540
I just checked my syslog, and there I found this: Mar 19 16:51:49 serverName kernel: [13584.420001] type=1503 audit(1269013909.540:24): operation="inode_create" requested_ mask="a::" denied_mask="a::" fsuid=112 name="/var/www/someProject/backup/mysql/1269013909_tableName.sql" pid=8554 prof ile="/usr/sbin/mysqld" – Peter – 2010-03-19T15:53:50.200