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

[Mark Knecht]

It seems that re-emerging qt3 solved this problem. My remote frontend
is working fine.

Now to solve the remaining problems on the backend.....

thanks all!

Cheers,
Mark

On 5/15/07, Mark Knecht <markknecht@×××××.com> wrote:
> 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