[mythtv-users] Can't connect to MYSQL

[Mike A]

On 11/21/2010 08:00 PM, Robert McNamara wrote:
> On Sun, Nov 21, 2010 at 6:53 PM, Mike A<mlnx at mho.com>  wrote:
>    
>> Still can't connect, but I have more info. When mythtv-setup executes a
>> terminal window appears with event messages but is only visible a very short
>>   time since the mythtv screen comes up and covers everything.  After running
>> it several times I was able to piece together the following messages.
>>
>> Runtime prefix /usr
>> Using config dir ~/.mythv
>> Using local hose value of localhost
>> SQL Database: QMYSQL3 driver not loaded
>> SQL Database: available drivers:
>> Unable to init db connection
>> New Database connection Total:1
>> SQL Database Opendatabase(): db object is not valid
>>
>> It seems I am missing a driver. Does the 3 in QMYSQL3 mean Qt3.  I do not
>> have qt3 installed, just  qt4.  However since I installed mythtv with Ubuntu
>> 10.4 distribution packages, I would think they would include any qt3 libs.
>>      
> Please bottom post on our lists.
>
> No.  QMYSQL3 means Qt MySQL driver for MySQL versions 3 and later.
>
>    
>> Anybody know what qt3 package I need to install?
>>      
> You don't need to.  But the above message *does* mean you are missing
> a Qt4 mysql package.  On Ubuntu this means libqt4-sql-mysql and
> libqt4-sql.
>
> Robert
>    
Both drivers are installed, just not being loaded. Also note in my 
previous post that there are no available drivers listed.  Does MythTV 
use an env variable to find the libs? I looked to see where Synaptic put 
the drivers.
Package libqt4-sql
    /usr/lib/libQtSql.so.4
     /usr/lib/libQtSql.so.4.6
     /usr/lib/libQtSql.so.4.6.2
Package libqt4-sql-mysql
     /usr/lib/qt4/plugins/sqldrivers/libqsqlmysql.so

Mike


> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>