[mythtv-users] Mythfilldatabase temporary tables do not exist (SOLVED)

[Michael T. Dean]

On 12/07/2007 06:53 PM, R. G. Newbury wrote:
> Daniel Kristjansson wrote:
>   
>> On Wed, 2007-12-05 at 10:51 -0500, R. G. Newbury wrote:
>>     
>>> At present, mysql creates temporary tables at (be default) /tmp.
>>> /tmp is owned by root and mysql does not have permission to write.
>>>       
>> Every user should be able to write to tmp:
>> drwxrwxrwt 12 root root 4096 2007-12-07 17:05 /tmp/
>>
>> That "t" at the end means that anyone can create a file in that
>> directory and will retain ownership of the file.
>>     
>
> Well that might provide an explanation of how things went pear-shaped. I 
> don't remember what the perms were but when I went checking, they were 
> NOT drwxrwxrwxt... Possibly I inadvertently borked that...which lead to 
> all of the other (self-inflicted!) pain.  Dang, I hate it when that 
> happens...
>   

That t would be the 1 in 1777 at
http://www.gossamer-threads.com/lists/mythtv/users/300986#300986 .


> ...
> Interestingly, neither the laptop nor the desktop server have the sticky 
> bit set. The fileserver does however.

TTBOMK, that is broken according to the File system Hierarchy Standard
(FHS).  The sticky bit prevents users from removing another user's files
(only owner and superuser can remove the files), so MySQL relies on it
for security of the Unix socket file (see the second link in my post above).

Mike