[SPAM] Re: [mythtv-users] Re: Configuring MythTV on Gentoo

[Andy Pflueger]

On 8/12/05, Andy Pflueger <andypflueger at gmail.com> wrote:
> On 8/12/05, Tom E. Craddock Jr. <sigtom at sigtom.com> wrote:
> > Andy Pflueger wrote:
> >
> > >Here's what I'm doing...
> > >
> > >I run "mysql -p < /usr/share/mythtv/database/mc.sql" which just
> > >creates the database and sets a couple GRANTs. Then, I move on to the
> > >next step which is running mythtv-setup but that doesn't populate my
> > >database. I've checked the mc.sql from the tarball versus that from
> > >the Gentoo ebuild and they're completely identical scripts. I am doing
> > >all this as superuser, of course, so I don't feel it could be a
> > >permission issue.
> > >
> > >Any thoughts?
> > >
> > >TIA,
> > >Andy
> > >
> > >On 8/12/05, pschormeir at iiv.de <pschormeir at iiv.de> wrote:
> > >
> > >
> > >>The database will be populated when you start mythtv-setup for the first
> > >>time.
> > >>
> > >>----Ursprüngliche Nachricht-----
> > >>Von: mythtv-users-bounces at mythtv.org
> > >>[mailto:mythtv-users-bounces at mythtv.org]Im Auftrag von Andy Pflueger
> > >>Gesendet: Freitag, 12. August 2005 02:02
> > >>An: mythtv-users at mythtv.org
> > >>Betreff: [mythtv-users] Re: Configuring MythTV on Gentoo
> > >>
> > >>
> > >>Whoops, attached is the mc.sql file as mentioned.
> > >>
> > >>On 8/11/05, Andy Pflueger <andypflueger at gmail.com> wrote:
> > >>
> > >>
> > >>>Hi,
> > >>>
> > >>>I've recently expressed an interest in attempting to install/configure
> > >>>MythTV on my Gentoo box here (which hosts
> > >>>http://www.pflueger-services.com/). Anyway, I'm having some problems
> > >>>with the mc.sql script...it doesn't seem to be populating and creating
> > >>>any tables in the mythconverg database that is created...the database
> > >>>IS being created though. Attached is a copy of my mc.sql that was
> > >>>obtained from Gentoo's ebuild of mythtv. Anybody have any ideas?? I'm
> > >>>currently working with the following Gentoo MythTV setup guide:
> > >>>
> > >>>http://gentoo-wiki.com/HOWTO_Setup_MythTV
> > >>>
> > >>>TIA,
> > >>>Andy
> > >>>
> > >>>
> > >>>
> > >>_______________________________________________
> > >>mythtv-users mailing list
> > >>mythtv-users at mythtv.org
> > >>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> > >>
> > >>
> > >>
> >
> > Howdy,
> >
> > Thought #1, dont top post, makes reading the whole thread a pain....you
> > read top to bottom, not bottom then top, right?
> >
> > Thought #2, you also ran mythfilldatabase?  Ill let you figure out what
> > it does by its name.
> >
> > Tom
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> 
> Tom,
> 
> #1 Sorry for top-posting.
> 
> #2 I did just read right over that step...doh!
> 
> Thanks all,
> Andy
> 

Hmm...I guess I spoke too soon.

I just ran mythfilldatabase and am getting this as a result:

mytoy ~ # mythfilldatabase
2005-08-12 16:06:07.973 New DB connection, total: 1
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:
Table 'mythconverg.videosource' doesn't exist

I realize that the mythconverg.videosource doesn't exist but for some
odd reason mythtv-setup doesn't create the tables. :(