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 1NmvEd-0000vO-MG for garchives@archives.gentoo.org; Wed, 03 Mar 2010 20:31:59 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id B3E0DE0BCE; Wed, 3 Mar 2010 20:31:20 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by pigeon.gentoo.org (Postfix) with ESMTP id 73114E0BCE for ; Wed, 3 Mar 2010 20:31:20 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by smtp.gentoo.org (Postfix) with ESMTP id 0FCF71B402B for ; Wed, 3 Mar 2010 20:31:20 +0000 (UTC) X-Virus-Scanned: amavisd-new at gentoo.org X-Spam-Score: -0.865 X-Spam-Level: X-Spam-Status: No, score=-0.865 required=5.5 tests=[AWL=-0.333, BAYES_00=-2.599, RCVD_NUMERIC_HELO=2.067] Received: from smtp.gentoo.org ([127.0.0.1]) by localhost (smtp.gentoo.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id pKfkcgpXCima for ; Wed, 3 Mar 2010 20:31:13 +0000 (UTC) Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by smtp.gentoo.org (Postfix) with ESMTP id 2CC7B1B4015 for ; Wed, 3 Mar 2010 20:31:11 +0000 (UTC) Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1NmvDp-00008H-74 for gentoo-user@gentoo.org; Wed, 03 Mar 2010 21:31:09 +0100 Received: from 64.122.56.22 ([64.122.56.22]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 03 Mar 2010 21:31:09 +0100 Received: from grant.b.edwards by 64.122.56.22 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 03 Mar 2010 21:31:09 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: gentoo-user@lists.gentoo.org From: Grant Edwards Subject: [gentoo-user] Re: No more mythtv for Gentoo users? Date: Wed, 3 Mar 2010 20:30:50 +0000 (UTC) Message-ID: References: <5bdc1c8b1003030958q29637a19j937b087fdd62b4fa@mail.gmail.com> <5bdc1c8b1003031149w1e5d1f07p3835bf996bcb5b49@mail.gmail.com> 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 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: 64.122.56.22 User-Agent: slrn/pre0.9.9-102 (Linux) X-Archives-Salt: 75a73405-22e8-4dbe-9930-6201435ce2e3 X-Archives-Hash: 926ebc8a2721cc17b78f94d897c5d470 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 Ver 14.12 Distrib 5.0.84, for pc-linux-gnu (i686) using readline 6.0 Connection id: 106 Current database: mythconverg Current user: mythtv@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.0.84-log Gentoo Linux mysql-5.0.84-r1 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 1 day 20 hours 44 min 55 sec Threads: 5 Questions: 261810 Slow queries: 0 Opens: 1400 Flush tables: 1 Open tables: 59 Queries per second avg: 1.625 -------------- > 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. Not 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... > upgrade your server, emerge mythtv-0.22 on one frontend, make sure it > works, and then move on with any other machine. > > Good luck and report back how it goes! -- Grant Edwards grant.b.edwards Yow! Are we on STRIKE yet? at gmail.com