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

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

[Mark Knecht]

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:

mark@lightning ~ $ 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
mark@lightning ~ $

   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...


   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-amd64@gentoo.org mailing list

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

[Raffaele BELARDI]

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:
> 
> mark@lightning ~ $ 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
> mark@lightning ~ $
> 
>   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...
> 
> 
>   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-amd64@gentoo.org mailing list

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

[Brett Johnson]

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

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@blzj.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@gentoo.org 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@gentoo.org mailing list

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@gmail.com> wrote:
> On 5/15/07, Brett Johnson <brett@blzj.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@gentoo.org 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@gentoo.org mailing list

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

[Drake Donahue]

----- Original Message ----- 
From: "Mark Knecht" <markknecht@gmail.com>
To: <gentoo-amd64@lists.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://gentoo-wiki.com/HOWTO_Setup_MythTV 

-- 
gentoo-amd64@gentoo.org mailing list