On Mon, Aug 20, 2012 at 3:30 PM, Stephen Jones
<[log in to unmask]> wrote:
On 08/20/2012 03:06 PM, Govind Songara wrote:
RE: CREAM
Hi Lisa,
It is
drwxrwx--- 5 root edguser 196608 Aug 20 12:24 /etc/grid-security/
I have corrected permission. Does ownership also need to be correct from root:edguser to root:root ?
Perhaps not - you have set it so any user can access that dir. But on my EMI2 cream, both dir and file are root:root.
[root@hepgrid5 grid-security]# ls -lrtd admin-list
-rw-r--r-- 1 root root 154 Aug 20 14:39 admin-list
[root@hepgrid5 grid-security]# ls -lrtd .
drwxr-xr-x 5 root root 4096 Aug 20 14:39 .
[root@hepgrid5 grid-security]#
Easy way to check is to make tomcat loginable (is that a word?) and check that you can su and read file.
RE: SQL
20 Aug 2012 14:56:05,195 ERROR org.glite.ce.creamapi.jobmanagement.cmdexecutor.JobStatusEventManager (JobStatusEventManager.java:100) - (TP-Processor25) Error retrieving events fom database: Can't create/write to file '/tmp/#sql_e28_0.MYI' (Errcode: 13)
20 Aug 2012 14:56:05,195 ERROR org.glite.ce.cream.cmdmanagement.CommandManager (CommandManager.java:383) - (TP-Processor25) CommandManager insertCommand: QUERY_EVENT error Error retrieving events fom database: Can't create/write to file '/tmp/#sql_e28_0.MYI' (Errcode: 13)
I can write to tmp and there is enough space (14Gb free)
Dunno. Never seen it. By the look and feel of this (I'm more of an Oracle man) I'd suggest that the sql_e28_0.MYI file is a "temporary sort run" from a SQL statement.
You can write to tmp and there is enough space, but can the owner of the database write to tmp? Are the permissions of /tmp root:root 777?
This fella sees the same thing: http://xenforo.com/community/threads/cant-create-write-to-file-errcode-13.29469/
And this guys talks about the sticky bit: http://wordpress.org/support/topic/infamous-cant-createwrite-to-file-errcode13-problem
Steve