InfoBright created files' permissions issue.

corina.pelmus · 05-12-2010, 10:28 AM

Hello!

I have a NFS shared directory between two linux machines, one with RedHat3 and one with CentOS 5.4.

On the CentOS 5.4 machine I have InfoBright installed.
In that directory, I want to create files with InfoBright and then to select from them with MySQL on the RedHat3 machine.

The problem is that InfoBright creates files with 660 permissions and mysql with 666, and I cannot SELECT from any file due to the fact that is not "readable by all"(this is the actual error). I can change the permissions manually, but I need them to be created with 666 permissions, so that I can import them automatically on the other side with a script.

Is there any way to change the permissions of the InfoBright created files?

Thanks,
Corina

kurwongbah · 05-13-2010, 09:14 PM

This might help!

http://www.linuxquestions.org/questi...ia-nfs-214288/

You basically need to have the the server forcing the two clients to use the same UID/GID and they'll both will be able to access the files.

Alternatively (IF ALL ELSE FAILS!!!), you could do the permission change in the script using sudo...

BTW Redhat3 sounds ancient =)

corina.pelmus · 05-14-2010, 01:41 AM

Hello!

What you suggested is not working, it was one of the first things I tried.
It doesn't work if you create the same group with the same UID/gid on both machines.

Thank you for the tip anyway!

I solved it by changing the file's permissions from the mysql client before loading the data.

mysql> system chmod 666 /mnt/test.txt;
mysql> LOAD DATA INFILE '/mnt/test.txt'
-> INTO TABLE `test`.`dummy`
-> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '`'
-> LINES TERMINATED BY '\n';

kurwongbah · 05-14-2010, 06:14 PM

Great that you were able to solve it.
For the record: You should tell the NFS server to force client connections to use the same uid/gid, not the clients.
That way they should be able to access each others files.