[mythtv-users] Getting mythfilldatabase error

[Sreeram Kumar]

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


 
____________________________________________________________________________________
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives.
http://tools.search.yahoo.com/toolbar/features/mail/