mythtv 0.23.1 and the pvr250 driver - testing

[Torfinn Ingolfsen]

On Fri, 24 Jun 2011 11:46:06 -0700 (PDT)
Mark <redtick at sbcglobal.net> wrote:

> > From: Torfinn Ingolfsen <torfinn.ingolfsen at broadpark.no>
> > Subject: Re: mythtv 0.23.1 and the pvr250 driver - testing
> > To: freebsd-multimedia at FreeBSD.org
> > Date: Friday, June 24, 2011, 12:47 PM
> > On Sun, 05 Jun 2011 22:27:51 +0200
> > Torfinn Ingolfsen <torfinn.ingolfsen at broadpark.no>
> > wrote:
> > 
> > > Hello,
> > > Today I tried to test MythTV 0.23.1 from ports (I used
> > portdowngrade)
> > > on my test machine[1], which has a PVR-350 card, and I
> > use the pvr250 driver from ports. 
> > > As before; the card and driver is tested with mplayer
> > and works fine.
> > > Details:
> > > root at kg-quiet# uname -a
> > > FreeBSD kg-quiet.kg4.no 8.2-STABLE FreeBSD 8.2-STABLE
> > #0: Sun Apr  3 19:49:05 CEST 2011 
> >    root at kg-quiet.kg4.no:/usr/obj/usr/src/sys/GENERIC 
> > amd64
> > > root at kg-quiet# pv | grep pvr
> > > pvr250-20101010_1       
> >    =  up-to-date with port 
> > > root at kg-quiet# pv | grep mythtv
> > > mythtv-0.23.1           
> >    <  needs updating (port has
> > 0.24.1_1) 
> > > 
> > > This time, it apperas that mythtv-setup has problems
> > with upgrading the db schema.
> > > (I deleted the database, since it was newer than 0.23,
> > and ran mysql -uroot -p <
> > /usr/local/share/mythtv/database/mc.sql first).
> > > >From the shell where mythtv-setup is running:
> > > 
> > > 2011-06-05 22:07:51.171 Inserting MythTV initial
> > database information.
> > > 2011-06-05 22:07:51.171 New DB connection, total: 3
> > > 2011-06-05 22:07:51.172 Connected to database
> > 'mythconverg' at host: localhost
> > > 2011-06-05 22:07:51.172 Upgrading to MythTV schema
> > version 1226
> > > 
> > > and then mythtv-setup just sits there, nothing more
> > happening.
> > > Any hints on how to fix that?
> > 
> > Nobody has any hints?
> > -- 
> > Torfinn
> > 
> 
> When you "drop database" it does not change the permissions on the database you dropped.  Check out "grant" if you have not used it.

Good hint.
But the sql script already does the grant:
root at kg-quiet# more /usr/local/share/mythtv/database/mc.sql
CREATE DATABASE IF NOT EXISTS mythconverg;
GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Any other hints?
-- 
Torfinn