[mythtvnz] Script help please

[tortise]

On 6/01/2014 8:43 p.m., tortise wrote:
> On 6/01/2014 7:07 p.m., Steve Holdoway wrote:
>> On Mon, 2014-01-06 at 18:45 +1300, tortise wrote:
>>> Hi
>>> I'm trying to run a script from crontab -e with
>>>
>>> * * * * * /home/user1/cronping.sh
>>> * * * * * /home/user1/mythlinks.sh
>>>
>>> from the tab.
>>>
>>> syslog shows each is being called each minute, however only cronping
>>> seems to run.
>>>
>>> mythlinks.sh is:
>>> #!/bin/bash
>>>
>>> /usr/share/doc/mythtv-backend/contrib/user_jobs/mythlink.pl --link
>>> /var/www/mythlinks --format '%T/%T - %Y%m%d-%H%i -%S'
>>> /usr/share/doc/mythtv-backend/contrib/user_jobs/mythlink.pl --link
>>> /var/www/mythlinksall --format '%T - %Y%m%d-%H%i -%S'
>>> /usr/share/doc/mythtv-backend/contrib/user_jobs/mythlink.pl --link
>>> /var/www/mythlinksalldate --format '%Y%m%d-%H%i - %T -%S'
>>>
>>> sudo /home/user1/mythlinks.sh runs fine.
>>>
>>> I've been running mythlinks.sh here every minute for testing purposes,
>>> but when its working I will knock it back to hourly.
>>>
>>> What am I missing? How can I debug this further as mythlinks.sh won't
>>> run from the crontab, which is what I am seeking.
>>>
>> If it only runs with sudo, then it needs to be in the root cron, not
>> user1's which is where crontab -e will get you to. sudo crontab -e might
>> work? I'm a luddite and just log in as root so can't confirm or not.
>
> Sorry I should have said I was running sudo crontab -e
> crontab -e does get you to just the user1's crontab (its blank in terms
> of active commands)
> Also this is on mythbuntu 10.04. (The alternative approach is to upgrade
> to 12.04 and see if the issue persists but debugging 10.04 seemed the
> most expedient path...maybe...!?)

Logging errors to a file I find repeated:

DBI 
connect('database=mythconverg:host=localhost;port=3306','mythtv',...) 
failed: Access denied for user 'mythtv'@'localhost' (using password: 
YES) at /usr/share/perl5/MythTV.pm line 351
Cannot connect to database:

* * * * * mythtv /home/user1/mythlinks.sh does not work either....hmmm