On Fri, 24 Jun 2011 11:46:06 -0700 (PDT) Mark <[email protected]> wrote:
> > From: Torfinn Ingolfsen <[email protected]> > > Subject: Re: mythtv 0.23.1 and the pvr250 driver - testing > > To: [email protected] > > Date: Friday, June 24, 2011, 12:47 PM > > On Sun, 05 Jun 2011 22:27:51 +0200 > > Torfinn Ingolfsen <[email protected]> > > 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@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 > > [email protected]:/usr/obj/usr/src/sys/GENERIC > > amd64 > > > root@kg-quiet# pv | grep pvr > > > pvr250-20101010_1 > > = up-to-date with port > > > root@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@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 IDENTIFIED BY "mythtv"; FLUSH PRIVILEGES; ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; Any other hints? -- Torfinn _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[email protected]"
