[mythtv-users] Getting mythfilldatabase error

Sreeram Kumar Sreeramkumar at yahoo.com
Sat Feb 24 00:59:01 UTC 2007


 On Friday 23 February 2007 09:17, Sreeram Kumar
wrote: 
> 
> > Hi, 
> > My mythfilldatabase doesnt run automatically. when
I 
> 
> > checked the log I am seeing the following error. I

> am 
> > able to run it manually though. Also, I see the 
> > videosource as a table in the database when i do 
> > select tables; I have a cron job "01 10 * * *
sleep 
> > $(expr $RANDOM \% 14400) && mythfilldatabase > 
> > /var/log/mythtv/mythfilldatabase.log 2>&1 
> > " 
> > 
> > Thanks, 
> > Sreeram 
> > 
> > 2007-01-27 22:14:54.256 Using runtime prefix =
/usr 
> > 2007-01-27 22:14:54.274 New DB connection, total:
1 
> > 2007-01-27 22:14:54.280 Connected to database 
> > 'mythconverg' at host: localhost 
> > 2007-01-27 22:14:54.284 DB Error (loading channel 
> > sources): 
> > Query was: 
> > SELECT 
> >
sourceid,name,xmltvgrabber,userid,password,lineupid 
> > FROM videosource ORDER BY sourceid; 
> > Driver error was [2/1146]: 
> > QMYSQL3: Unable to execute query 
> > Database error was: 
> 
> > This error can happen with the wrong file > 
> permissions, regardless of mysql 
> > permissions. 
> > Table 'mythconverg.videosource' doesn't exist 
> > 
> > change file permissions 
> > of /var/lib/mysql/mythconverg/ and files to owner 
> > mysql, group mysql and 660 or 666 
> 
> I have 660 with mysql as group and owner already. 
> 
> Awithers--> My DB server is a local host. I didnt
get 
> what you mean by no home and mysql.txt 
>
> If you run mythfilldatabase from a cron job or in >
your system startup 
> scripts you may find that the $HOME variable is not
> defined, which can 
> result in mythfilldatabase not finding MythTV's >
database access 
> settings. These normally live in
~/.mythtv/mysql.txt> (where ~ is the 
> user's home dir). 
>
> Make sure that for whichever user your MFDB is >
running as, there is a 
> good mysql.txt file and $HOME is correct. 
> 
> Nick 
Looks like everything is ok now when i made the
permissions to 666. But, still mythfilldatabase wont
run even though i enabled it from the mythtvsetup to
run between 8-10am everyday. I leave my PC on always.

Sreeram



 
____________________________________________________________________________________
Now that's room service!  Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097


More information about the mythtv-users mailing list