[mythtv-users] Getting mythfilldatabase error

[Nick Morrott]

On 23/02/07, Sreeram Kumar <Sreeramkumar at yahoo.com> wrote:
> 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
-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin