[mythtv-users] Untraceable error message from Mythfilldatabase

[Michael T. Dean]

On 05/04/2008 08:25 PM, R. G. Newbury wrote:
> Michael T. Dean wrote:
>   
>> On 05/04/2008 03:07 AM, R. G. Newbury wrote:
>>     
>>> Somehow Mythfilldatabase has become borken in the last few days.
>>> It runs, but reports near the end:
>>>       
>> ...
>>     
>>> 2008-05-04 02:41:24.845 DataDirect, Error: GrabData: Creating temp post file
>>> 2008-05-04 02:41:24.845 Encountered error in grabbing data.
>>> 2008-05-04 02:41:24.845
>>>
>>>
>>> It *appears* that either mysql or datadirect.cpp has a permissions 
>>> problem. I had not changed any permissions for mysql. In fact, the only 
>>> change was to update the SVN level a few days ago, which is when mfdb 
>>> started to fail.
>>>
>>> I grep'ed around and found that this is from /libs/libmyth/datadirect.cpp.
>>> That file has tmpdir hardwired as "/tmp" and datadirect.cpp tries to 
>>> create temporary subfolders under /tmp. I chowned and chgrped /tmp to 
>>> mysql in an attempt to fix things but still got the error. I chmod'ed to 
>>> 777: no joy.
>>>       
>> Unless you're running mythbackend as the mysql user, that's the wrong 
>> user.  However, you really want /tmp owned by root.  The following 
>> should fix it (right, even):
>>
>> sudo chown root:root /tmp
>> sudo chmod 1777 /tmp
>>
>> Also, make sure you have sufficient free space on the partition that 
>> includes /tmp (this doesn't take /that/ much space, but if the partition 
>> were full, ...).
> Thanks Mike. Not full: that's one of the first things I thought of, 
> having been tagged with a full /var/log partition.
>
> Mythbackend is started as a service...therefore actually root. But the 
> daily mfdb 'runs but did not insert...'.
> I tried mfdb from a terminal, as *root*, using many variants of:
>
> /tmp as root:root
> /tmp as mysql:mysql
> both with chmod 666 and 777
>
> then with datadirect.cpp changed to make tmpdir="/tmp/mysql"
> and with new subdir /tmp/mysql owned by mysql:mysql and set as 777

Did you do the "chmod 1777 /tmp" (yes, that 1 /should be/ there--it's 
actually critical, not a typo--and is probably the missing piece).

Mike