From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.62) (envelope-from ) id 1HnwCP-00027l-ST for garchives@archives.gentoo.org; Tue, 15 May 2007 12:32:18 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.14.0/8.14.0) with SMTP id l4FCTjer004375; Tue, 15 May 2007 12:29:45 GMT Received: from mail.blzj.com (209-249-12-196.ip.openhosting.com [209.249.12.196]) by robin.gentoo.org (8.14.0/8.14.0) with ESMTP id l4FCTiKl004365 for ; Tue, 15 May 2007 12:29:44 GMT Received: by mail.blzj.com (Postfix, from userid 501) id 9B6F21851B6B; Tue, 15 May 2007 07:29:43 -0500 (CDT) Date: Tue, 15 May 2007 07:29:43 -0500 From: Brett Johnson To: gentoo-amd64@lists.gentoo.org Subject: Re: [gentoo-amd64] mythfrontend on AMD64 - will it work with qt-4? (cannot connect to database) Message-ID: <20070515122943.GH11545@blzj.com> References: <5bdc1c8b0705141959u3658eee1g21852225dda69a3c@mail.gmail.com> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-amd64@gentoo.org Reply-to: gentoo-amd64@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5bdc1c8b0705141959u3658eee1g21852225dda69a3c@mail.gmail.com> User-Agent: Mutt/1.5.14 (2007-02-12) X-Archives-Salt: 42141bb4-8d48-4860-87fe-fea7037b25b7 X-Archives-Hash: e3bf75250a49e5411876144f731145c3 On Mon, May 14, 2007 at 07:59:52PM -0700, Mark Knecht wrote: > Hi, > I'm in the early stages of a complete MythTV update across my > network. I have the backend nearly working in an IA32 machine. It runs > fine but isn't getting all the channels correctly yet. In parallel > with that effort I'm trying to get the frontend working again on my > AMD64 machine. > > However when I try to start the frontend it complains like this: > > mark@lightning ~ $ mythfrontend --geometry 800x600 > 2007-05-14 19:56:19.577 Using runtime prefix = /usr > 2007-05-14 19:56:19.585 DPMS is active. > QSqlDatabase: QMYSQL3 driver not loaded > QSqlDatabase: available drivers: > 2007-05-14 19:56:19.595 New DB connection, total: 1 > 2007-05-14 19:56:19.595 Unable to connect to database! > 2007-05-14 19:56:19.596 No error type from QSqlError? Strange... > QSqlQuery::exec: database not open > QSqlQuery::exec: database not open > 2007-05-14 19:56:19.646 DB Error (KickDatabase): > Query was: > SELECT NULL; > No error type from QSqlError? Strange... > > First, I believe MythTV still required QT3. The QT package is slotted, so you should be able to have both 3 and 4 installed. If you upgraded MySQL on the AMD64 box, you may want to rebuild QT3 with something like emerge -av =dev-libs/qt3* If that doesn't fix it, it sounds like it could be a password encryption problem. I had a similar problem when I tried using a RHEL box as a front end. The RHEL distribution only supported MySQL 4.0.x and my back end DB is MySQL 5.x. I could connect fine from the command line, but the front end could not. After a bit of research I determined it was a password encryption problem. I decided the easiest solution for me was to create a second account for the mythconverg DB and encrypt the password using the old_password function. You can also upgrade the client to 5.x. If it's already at 5.x you may need to re-encrypt the password for the account. You may want to look at http://dev.mysql.com/doc/refman/5.0/en/old-client.html and try some of the suggestions. Hope this helps. Brett -- gentoo-amd64@gentoo.org mailing list