[mythtv-users] Problem with mythfilldatabase and the crontab

[ffrr]

duckeo wrote:

> Okay this one is driving me nuts.
>
> I've got my local myth user configured to use mythfilldatabase with 
> tv_grab_au. If I run this manually from the command line as mythtv, it 
> works fine.
>
> I configure up my crontab to run the same job:
>
> mythtv at mythtv:~$ crontab -l
> 00 23 * * * /usr/local/bin/mythfilldatabase
>
> It was set to run once a day early in the morning (but it's 11:00p for 
> testing purposes).
>
> When I check my mythweb status, it says mythfilldatabase last failed 
> and I verify this with the guide still not having the correct data.
>
> I set up the crontab to pipe the output to a file:
>
> mythtv at mythtv:~$ crontab -l
> 00 23 * * * /usr/local/bin/mythfilldatabase > 
> /var/log/mythfilldatabase.log
>
> and in that log, the next day:
> mythtv at mythtv :~$ cat /var/log/mythfilldatabase.log
> 2005-11-12 23:00:02.969 New DB connection, total: 1
> 2005-11-12 23:00:03.048 New DB connection, total: 2
> ----------------- Start of XMLTV output -----------------
> 2005-11-12 23:00: 03.170 New DB connection, total: 3
> ------------------ End of XMLTV output ------------------
> Updating icons for sourceid: 1
> 2005-11-12 23:00:03.207 New DB connection, total: 4
>
> That's all I see, no reason for a failure. My Crontab log shows it is 
> running as the correct user:
>
> root at mythtv:/home/mythtv# cat /var/log/cron.1
> /usr/sbin/crond 2.3.3 dillon, started, log level 8
> USER mythtv pid 18998 cmd /usr/local/bin/mythfilldatabase
>
> Is there some environment variable I need to set within the cron job 
> itself?
>
> Thanks
>
>------------------------------------------------------------------------
>


I was getting an error when mythbackend ran mythfilldatabase. In the log 
I found...

config file //.mythtv/au.xmltv does not exist, run me with --configure

The problem was that the 'HOME' environment variable is not defined. 
To fix it in /etc/init.d/mythtv-backend

Add the following line
HOME=/home/mythtv

directly after
DESC="MythTV server"



Now, you might need to do something similar?  Just a guess...