Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 25 Jun 2011 02:26:58 +0200
From:      Torfinn Ingolfsen <torfinn.ingolfsen@broadpark.no>
To:        Mark <redtick@sbcglobal.net>
Cc:        help help <freebsd-questions@freebsd.org>
Subject:   Re: mythtv 0.23.1 and the pvr250 driver - testing
Message-ID:  <20110625022658.f12aa0f8.torfinn.ingolfsen@broadpark.no>
In-Reply-To: <152319.41054.qm@web81208.mail.mud.yahoo.com>
References:  <20110624194707.df1f49de.torfinn.ingolfsen@broadpark.no> <152319.41054.qm@web81208.mail.mud.yahoo.com>

next in thread | previous in thread | raw e-mail | index | archive | help
On Fri, 24 Jun 2011 11:46:06 -0700 (PDT)
Mark <redtick@sbcglobal.net> wrote:

> > From: Torfinn Ingolfsen <torfinn.ingolfsen@broadpark.no>
> > Subject: Re: mythtv 0.23.1 and the pvr250 driver - testing
> > To: freebsd-multimedia@FreeBSD.org
> > Date: Friday, June 24, 2011, 12:47 PM
> > On Sun, 05 Jun 2011 22:27:51 +0200
> > Torfinn Ingolfsen <torfinn.ingolfsen@broadpark.no>
> > wrote:
> >=20
> > > 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.=20
> > > As before; the card and driver is tested with mplayer
> > and works fine.
> > > Details:
> > > root@kg-quiet# uname -a
> > > FreeBSD kg-quiet.kg4.no 8.2-STABLE FreeBSD 8.2-STABLE
> > #0: Sun Apr=A0 3 19:49:05 CEST 2011=A0
> > =A0=A0=A0root@kg-quiet.kg4.no:/usr/obj/usr/src/sys/GENERIC=A0
> > amd64
> > > root@kg-quiet# pv | grep pvr
> > > pvr250-20101010_1=A0 =A0 =A0 =A0
> > =A0=A0=A0=3D=A0 up-to-date with port=20
> > > root@kg-quiet# pv | grep mythtv
> > > mythtv-0.23.1=A0 =A0 =A0 =A0 =A0 =A0
> > =A0=A0=A0<=A0 needs updating (port has
> > 0.24.1_1)=20
> > >=20
> > > 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:
> > >=20
> > > 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
> > >=20
> > > and then mythtv-setup just sits there, nothing more
> > happening.
> > > Any hints on how to fix that?
> >=20
> > Nobody has any hints?
> > --=20
> > Torfinn
> >=20
>=20
> When you "drop database" it does not change the permissions on the databa=
se you dropped.  Check out "grant" if you have not used it.

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

Any other hints?
--=20
Torfinn




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20110625022658.f12aa0f8.torfinn.ingolfsen>