Re: [gentoo-amd64] mythfrontend on AMD64 - will it work with qt-4? (cannot connect to database)

[Mark Knecht]

On 5/15/07, Brett Johnson <brett@××××.com> wrote:
> 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@g.o mailing list
>
>

Hi Brett.
   Thanks for responding.

   I have both qt3 and qt4 installed:

mark@lightning ~ $ eix -I x11-libs/qt
[I] x11-libs/qt
     Available versions:
        (3)     3.3.4-r8 3.3.8-r2
        (4)     4.2.3-r1 ~*4.3.0_beta1 ~4.3.0_rc1
        {accessibility cups dbus debug doc examples firebird gif glib
immqt immqt-bc input_devices_wacom ipv6 jpeg mng mysql nas nis odbc
opengl pch png postgres qt3support sqlite sqlite3 ssl tiff xinerama
zlib}
     Installed versions:  3.3.8-r2(3)(09:05:22 PM 04/18/2007)(cups
-debug -doc -examples -firebird gif -immqt -immqt-bc ipv6 mysql -nas
-nis -odbc opengl -postgres -sqlite -xinerama)
                          4.2.3-r1(4)(07:42:10 PM
05/14/2007)(-accessibility cups dbus -debug -doc -examples -firebird
gif -glib -input_devices_wacom jpeg -mng mysql -nas -nis -odbc opengl
-pch png -postgres qt3support -sqlite -sqlite3 -xinerama zlib)
     Homepage:            http://www.trolltech.com/
     Description:         The Qt toolkit is a comprehensive C++
application development framework.


   As far as I can tell Myth and most everything else does depend on qt3:

mark@lightning ~ $ equery depends =x11-libs/qt-3.3.8-r2
[ Searching for packages depending on =x11-libs/qt-3.3.8-r2... ]
app-cdr/k3b-1.0.1 (=x11-libs/qt-3.3*)
app-crypt/qca-1.0-r2 (=x11-libs/qt-3.3*)
app-text/poppler-bindings-0.5.4 (qt3? =x11-libs/qt-3*)
dev-libs/dbus-qt3-old-0.70 (=x11-libs/qt-3*)
kde-base/kdebase-3.5.5-r4 (=x11-libs/qt-3.3*)
kde-base/kdelibs-3.5.5-r10 (=x11-libs/qt-3.3.8-r2)
kde-misc/filelight-1.0_rc2 (=x11-libs/qt-3.3*)
media-sound/qjackctl-0.2.22 (=x11-libs/qt-3*)
media-tv/mythtv-0.20.1_p13344 (=x11-libs/qt-3.3*)
x11-themes/mythtv-themes-0.20.1 (=x11-libs/qt-3.3*)
mark@lightning ~ $ equery depends =x11-libs/qt-4.2.3-r1
[ Searching for packages depending on =x11-libs/qt-4.2.3-r1... ]
app-text/poppler-bindings-0.5.4 (qt4? =x11-libs/qt-4*)
mark@lightning ~ $

   I did upgrade mysql to version 5 so I'll try rebuilding qt3 using
this command:

emerge -av =x11-libs/qt-3*

   If the info above suggests other ideas please post back when you
get a chance.

thanks,
Mark
-- 
gentoo-amd64@g.o mailing list