From owner-freebsd-questions@FreeBSD.ORG Sat Jun 25 01:27:02 2011 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9851A106566B for ; Sat, 25 Jun 2011 01:27:02 +0000 (UTC) (envelope-from torfinn.ingolfsen@broadpark.no) Received: from thalia-smout.broadpark.no (thalia-smout.broadpark.no [80.202.8.21]) by mx1.freebsd.org (Postfix) with ESMTP id 51BB08FC08 for ; Sat, 25 Jun 2011 01:27:02 +0000 (UTC) MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Received: from ignis-smin.broadpark.no ([80.202.8.11]) by thalia-smout.broadpark.no (Sun Java(tm) System Messaging Server 7u3-15.01 64bit (built Feb 12 2010)) with ESMTP id <0LNB00449L8ZIRA0@thalia-smout.broadpark.no> for freebsd-questions@freebsd.org; Sat, 25 Jun 2011 02:26:59 +0200 (CEST) Received: from kg-v2.kg4.no ([80.203.92.230]) by ignis-smin.broadpark.no (Sun Java(tm) System Messaging Server 7u3-15.01 64bit (built Feb 12 2010)) with SMTP id <0LNB00LI8L8ZLSG0@ignis-smin.broadpark.no> for freebsd-questions@freebsd.org; Sat, 25 Jun 2011 02:26:59 +0200 (CEST) Date: Sat, 25 Jun 2011 02:26:58 +0200 From: Torfinn Ingolfsen To: Mark 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> X-Mailer: Sylpheed 3.1.0 (GTK+ 2.22.1; amd64-portbld-freebsd8.1) X-Face: "t9w2,-X@O^I`jVW\sonI3.,36KBLZE*AL[y9lL[PyFD*r_S:dIL9c[8Y>V42R0"!"yb_zN,f#%.[PYYNq; m"_0v; ~rUM2Yy!zmkh)3&U|u!=T(zyv,MHJv"nDH>OJ`t(@mil461d_B'Uo|'nMwlKe0Mv=kvV?Nh@>Hb<3s_z2jYgZhPb@?Wi^x1a~Hplz1.zH Content-transfer-encoding: quoted-printable Cc: help help Subject: Re: mythtv 0.23.1 and the pvr250 driver - testing X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 25 Jun 2011 01:27:02 -0000 On Fri, 24 Jun 2011 11:46:06 -0700 (PDT) Mark wrote: > > From: Torfinn Ingolfsen > > 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 > > 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