mythfrontend on AMD64 - will it work with qt-4? (cannot connect to database)

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. At this point I can connect to the
mythconverg database
by hand:

marklightning ~ $ mysql -h 192.168.1.55 -u mythtv -p
mythconverg
Enter password:
Reading table information for completion of table and column
names
You can turn off this feature to get a quicker startup with
-A

Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 43
Server version: 5.0.40 Gentoo Linux mysql-5.0.40

Type 'help;' or 'h' for help. Type 'c' to clear the
buffer.

mysql> exit
Bye
marklightning ~ $

   However when I try to start the frontend it complains
like this:

marklightning ~ $ 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...


   After doing some reading I find that the long time answer
to this
question is compiling qt with mysql support. I believe I've
done that
but it still didn't work. I noticed a new flag about
qt3support so I
rebuilt qt with that turned on but it still fails to
connect:

lightning ~ # emerge -pv qt

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild   R   ] x11-libs/qt-4.2.3-r1  USE="cups dbus
gif jpeg mysql
opengl png qt3support zlib -accessibility -debug -doc
-examples
(-firebird) -glib -mng -nas -nis -odbc -pch -postgres
-sqlite -sqlite3
-xinerama" INPUT_DEVICES="-wacom" 0 kB

Total: 1 package (1 reinstall), Size of downloads: 0 kB
lightning ~ #

   Is there a known problem with mythfrontend on AMD64? I'm
pretty
lost for things to try right now.

   Thanks in advance for any ideas.

Cheers,
Mark
-- 
gentoo-amd64gentoo.org mailing list

I'm also experimenting with mythtv on an amd64, but for now
I have
frontend, backend and mywql running on the same diskless
machine so I
don't have direct answer for you. But in my system the
frontend works fine.

If memory serves (I'm on a different system now), during the
emerge of
mythtv qt3 library was pulled in, not qt4. That was a couple
of weeks
ago, at the time there was no qt3support flag yet, or I did
not notice
it. Maybe you could try emerging qt-3 instead of qt-4 with
qt3support

bye,

raffaele

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. At this point I can connect to the
mythconverg database
> by hand:
> 
> marklightning ~ $ mysql -h 192.168.1.55 -u mythtv -p
mythconverg
> Enter password:
> Reading table information for completion of table and
column names
> You can turn off this feature to get a quicker startup
with -A
> 
> Welcome to the MySQL monitor.  Commands end with ; or
g.
> Your MySQL connection id is 43
> Server version: 5.0.40 Gentoo Linux mysql-5.0.40
> 
> Type 'help;' or 'h' for help. Type 'c' to clear the
buffer.
> 
> mysql> exit
> Bye
> marklightning ~ $
> 
>   However when I try to start the frontend it complains
like this:
> 
> marklightning ~ $ 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...
> 
> 
>   After doing some reading I find that the long time
answer to this
> question is compiling qt with mysql support. I believe
I've done that
> but it still didn't work. I noticed a new flag about
qt3support so I
> rebuilt qt with that turned on but it still fails to
connect:
> 
> lightning ~ # emerge -pv qt
> 
> These are the packages that would be merged, in order:
> 
> Calculating dependencies... done!
> [ebuild   R   ] x11-libs/qt-4.2.3-r1  USE="cups
dbus gif jpeg mysql
> opengl png qt3support zlib -accessibility -debug -doc
-examples
> (-firebird) -glib -mng -nas -nis -odbc -pch -postgres
-sqlite -sqlite3
> -xinerama" INPUT_DEVICES="-wacom" 0 kB
> 
> Total: 1 package (1 reinstall), Size of downloads: 0
kB
> lightning ~ #
> 
>   Is there a known problem with mythfrontend on AMD64?
I'm pretty
> lost for things to try right now.
> 
>   Thanks in advance for any ideas.
> 
> Cheers,
> Mark
-- 
gentoo-amd64gentoo.org mailing list

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:
> 
> marklightning ~ $ 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-amd64gentoo.org mailing list

On 5/15/07, Brett Johnson <brettblzj.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:
> >
> > marklightning ~ $ 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-amd64gentoo.org mailing list
>
>

Hi Brett.
   Thanks for responding.

   I have both qt3 and qt4 installed:

marklightning ~ $ 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:

marklightning ~ $ 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*)
marklightning ~ $ 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*)
marklightning ~ $

   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-amd64gentoo.org mailing list

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 <markknechtgmail.com> wrote:
> On 5/15/07, Brett Johnson <brettblzj.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:
> > >
> > > marklightning ~ $ 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-amd64gentoo.org mailing list
> >
> >
>
> Hi Brett.
>    Thanks for responding.
>
>    I have both qt3 and qt4 installed:
>
> marklightning ~ $ 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:
>
> marklightning ~ $ 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*)
> marklightning ~ $ 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*)
> marklightning ~ $
>
>    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-amd64gentoo.org mailing list

----- Original Message ----- 
From: "Mark Knecht" <markknechtgmail.com>
To: <gentoo-amd64lists.gentoo.org>
Sent: Tuesday, May 15, 2007 11:12 AM
Subject: Re: [gentoo-amd64] mythfrontend on AMD64 - will it
work with qt-4? 
(cannot connect to database)


> 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
<snip>
http://gent
oo-wiki.com/HOWTO_Setup_MythTV 

-- 
gentoo-amd64gentoo.org mailing list