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

[Nick Rosier]

On 8/12/05, Andy Pflueger <andypflueger at gmail.com> wrote:
> 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. :(

Have you started the backend yet? I thought it created or updated all
tables to the latest scheme.

N.