Mailing List Archive

Foolish cron question (mythfilldatabase)
All-

I apologize in advance, because I'm sure I'm missong something really easy
here, but I'm trying to get a cron job to successfully run mythfilldatabase
on a daily basis. Below, you can see a listing of the cron job, followed
by a listing of the text file created when this job runs. Right now, I've
got the job in the hourly directory, because I'm working on it. Obviously,
I'll move it once it starts working. Note that if I run this as either
root or a normal user, it runs fine (except for xmltv's problems with the
new North American format -- I'll have to reinstall xmltv at some point, it
seems.)

[root@localhost root]# cat /etc/cron.hourly/mythfilldb
#!/bin/bash
QTDIR=/usr/lib/qt3
PATH=$PATH:/usr/lib/qt3
echo $PATH >/var/store/tv/filldblog.txt
echo $QTDIR >>/var/store/tv/filldblog.txt
/usr/local/bin/mythfilldatabase >>/var/store/tv/filldblog.txt
2>>/var/store/tv/filldblog.txt
[root@localhost root]# cat /var/store/tv/filldblog.txt
/sbin:/bin:/usr/sbin:/usr/bin:/usr/lib/qt3
/usr/lib/qt3
QSqlDatabase warning: QMYSQL3 driver not loaded
QSqlDatabase: available drivers:
couldn't open db
[root@localhost root]#

So, what's the deal with QMYSQL3? Is that the Qt MySQL driver? I've
scoured the lists, and checked the things mentioned in posts dealing with
the driver, but to no avail. Any insight would be greatly appreciated.

-Jeff
Re: Foolish cron question (mythfilldatabase) [ In reply to ]
Use the cronjob that comes in in the configfiles directory.


----- Original Message -----
From: <Jeff_Mitchell@accessbusinessgroup.com>
To: "Discussion about mythtv" <mythtv-users@snowman.net>
Sent: Friday, February 07, 2003 9:12 AM
Subject: [mythtv-users] Foolish cron question (mythfilldatabase)


> All-
>
> I apologize in advance, because I'm sure I'm missong something really
easy
> here, but I'm trying to get a cron job to successfully run
mythfilldatabase
> on a daily basis. Below, you can see a listing of the cron job,
followed
> by a listing of the text file created when this job runs. Right now,
I've
> got the job in the hourly directory, because I'm working on it.
Obviously,
> I'll move it once it starts working. Note that if I run this as either
> root or a normal user, it runs fine (except for xmltv's problems with
the
> new North American format -- I'll have to reinstall xmltv at some point,
it
> seems.)
>
> [root@localhost root]# cat /etc/cron.hourly/mythfilldb
> #!/bin/bash
> QTDIR=/usr/lib/qt3
> PATH=$PATH:/usr/lib/qt3
> echo $PATH >/var/store/tv/filldblog.txt
> echo $QTDIR >>/var/store/tv/filldblog.txt
> /usr/local/bin/mythfilldatabase >>/var/store/tv/filldblog.txt
> 2>>/var/store/tv/filldblog.txt
> [root@localhost root]# cat /var/store/tv/filldblog.txt
> /sbin:/bin:/usr/sbin:/usr/bin:/usr/lib/qt3
> /usr/lib/qt3
> QSqlDatabase warning: QMYSQL3 driver not loaded
> QSqlDatabase: available drivers:
> couldn't open db
> [root@localhost root]#
>
> So, what's the deal with QMYSQL3? Is that the Qt MySQL driver? I've
> scoured the lists, and checked the things mentioned in posts dealing
with
> the driver, but to no avail. Any insight would be greatly appreciated.
>
> -Jeff
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@snowman.net
> http://www.snowman.net/mailman/listinfo/mythtv-users
Re: Foolish cron question (mythfilldatabase) [ In reply to ]
William-

Hmm, never saw one. My configfiles directory contains a lircd.conf and
lircrc. Was it added in 0.8? (I'm still running 0.7) I'll check CVS, and
see if I can't pull one from there.

-Jeff

P.S. Sorry if you get this all the time, but I have to know: What's your
middle initial?
Re: Foolish cron question (mythfilldatabase) [ In reply to ]
William Preston and C Mead-

Thanks for your help. It appears the problem was that I forgot to export
my environment variables. ('Foolish' was quite correct in this case.) I
realized this as soon as I looked at the cron in CVS, thanks to William's
tip. Anyway, things are running correctly now, so thanks again.

-Jeff