[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