From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1NmvL0-0001c4-Tz for garchives@archives.gentoo.org; Wed, 03 Mar 2010 20:38:35 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 3B1A2E0BFB; Wed, 3 Mar 2010 20:38:16 +0000 (UTC) Received: from mail-px0-f202.google.com (mail-px0-f202.google.com [209.85.216.202]) by pigeon.gentoo.org (Postfix) with ESMTP id 0AAFAE0BFB for ; Wed, 3 Mar 2010 20:38:15 +0000 (UTC) Received: by pxi40 with SMTP id 40so662708pxi.9 for ; Wed, 03 Mar 2010 12:38:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type :content-transfer-encoding; bh=WjVSbb/t9tfagLs7Z8MdxJRbYpmOToh+ob+KPnkoQiU=; b=fpPd9SnnSvUrk240ZVsGMUXjU6d59WP54Pwa7VRqsonNwPlJDyMDE4AmBfaFIM8Z5G 3dK96ozpjBVKruvLNoyikoD3jS4nWicPdm7CtVjlxYvrEvqszE0D2puv3r3duLtwXIeN sQyc/DixfPaFLxnuWnNSJWBPOPdStbR07DLDU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; b=SODFODfFunAWK3rcffA7Uo2aKRCKeVbn1l0QWYJ3I6A1TyRYOMIRIo5ktPHHmEw6Ee 18vdn66phm+7e5SxoRSXsg6OzSNwhBtXZ50BdciGkUcsZop7NPwU9fPheY5XU47TStVN kj+qohCb8qiAsmVo/EEPKXH1H2K+Txskim2uY= Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Received: by 10.142.9.9 with SMTP id 9mr301554wfi.50.1267648695497; Wed, 03 Mar 2010 12:38:15 -0800 (PST) In-Reply-To: References: <5bdc1c8b1003030958q29637a19j937b087fdd62b4fa@mail.gmail.com> <5bdc1c8b1003031149w1e5d1f07p3835bf996bcb5b49@mail.gmail.com> Date: Wed, 3 Mar 2010 12:38:15 -0800 Message-ID: <5bdc1c8b1003031238j42935a90k79cae5aec8eb130f@mail.gmail.com> Subject: Re: [gentoo-user] Re: No more mythtv for Gentoo users? From: Mark Knecht To: gentoo-user@lists.gentoo.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Archives-Salt: f6c79c93-7012-49b8-8c13-dfbc0c4dc5d9 X-Archives-Hash: 93ff88f0c4cfbbd956a795990a2989b3 On Wed, Mar 3, 2010 at 12:30 PM, Grant Edwards wrote: > On 2010-03-03, Mark Knecht wrote: >> On Wed, Mar 3, 2010 at 10:49 AM, Grant Edwards >>> >>> I read the instructions for fixing the broken database encoding, but >>> it appears mine is fine -- so updating to 0.22 won't be quite as >>> painful as it might have been. ??I'll still have to re-build the >>> frontend, since 0.22 doesn't use a compatible protocol. >> >> You are already using latin1 throughout your database? > > Apparently: > > $ mysql -umythtv -p mythconverg -e 'status;' > Enter password: > -------------- > mysql =C2=A0Ver 14.12 Distrib 5.0.84, for pc-linux-gnu (i686) using readl= ine 6.0 > > Connection id: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0106 > Current database: =C2=A0 =C2=A0 =C2=A0 mythconverg > Current user: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 mythtv@localhost > SSL: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0Not in use > Current pager: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0stdout > Using outfile: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0'' > Using delimiter: =C2=A0 =C2=A0 =C2=A0 =C2=A0; > Server version: =C2=A0 =C2=A0 =C2=A0 =C2=A0 5.0.84-log Gentoo Linux mysql= -5.0.84-r1 > Protocol version: =C2=A0 =C2=A0 =C2=A0 10 > Connection: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Localhost via UNIX = socket > Server characterset: =C2=A0 =C2=A0latin1 > Db =C2=A0 =C2=A0 characterset: =C2=A0 =C2=A0latin1 > Client characterset: =C2=A0 =C2=A0latin1 > Conn. =C2=A0characterset: =C2=A0 =C2=A0latin1 > UNIX socket: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0/var/run/mysqld/mys= qld.sock > Uptime: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1 day 20 = hours 44 min 55 sec > > Threads: 5 =C2=A0Questions: 261810 =C2=A0Slow queries: 0 =C2=A0Opens: 140= 0 =C2=A0Flush tables: 1 =C2=A0Open tables: 59 =C2=A0Queries per second avg:= 1.625 > -------------- > Good stuff. Not true for me. > >> You are lucky if that's true. It isn't for me but I've been running >> myth for about 4 years now. > > I've been running Myth for a while (6 years?), but this database was > created about 7 months ago when I switched from a dedicated FE/BE > machine running KnoppMyth to a split FE/BE setup where the BE runs on > a non-dedicated Gentoo machine. =C2=A0Not sure how it ended up this way > other than the fact that I don't have UTF support enabled on that box > (at some point in the past, having UTF support enabled broke something > else, but I don't remember what). > >> I would suggest that if you use __any__ remote frontends and there is >> any chance of someone else powering one up and using Myth then you >> should first emerge -C mythtv on ALL frontend-only machines, > > The FE doesn't run Gentoo, it runs MiniMyth -- I _think_ all I need to > do is replace the 0.21 rootfs on the USB flash drive with the one > containing 0.22... You've probably read this elsewhere but apparently an older 0.21 frontend can corrupt the MythTV database. Maybe it won't happen for you if you're already using all latin1 everywhere. I'm not so I have to be careful. Cheers, Mark