[mythtv-users] QSqlDatabase: QMYSQL3 driver not loaded

[Jonas Anden]

I got that problem when I upgraded from FC4 to FC5, thereby changing the 
mysql db version. Due to Dependency Hell, qt wasn't upgraded properly 
and so still used old mysql drivers that didn't like the new server. 
Solution for me: uninstall qt, reinstall qt.

  // J

Juergen Sachs wrote:
> Hi,
>
> I checked for old version of the mythtv libs and removed them all.
> I redo all the configuration steps (dist clean, configure, qmake, make, make 
> install) but got the same error message. ldconfig -v gave the following 
> result:
> ----------------------------
> ldconfig -v|grep myth
>         libmythlivemedia-0.20.so.0 -> libmythlivemedia-0.20.so.0.20.0
>         libmythupnp-0.20.so.0 -> libmythupnp-0.20.so.0.20.0
>         libmythfreemheg-0.20.so.0 -> libmythfreemheg-0.20.so.0.20.0
>         libmythui-0.20.so.0 -> libmythui-0.20.so.0.20.0
>         libmythtv-0.20.so.0 -> libmythtv-0.20.so.0.20.0
>         libmyth-0.20.so.0 -> libmyth-0.20.so.0.20.0
>         libmythavformat-0.20.so.0 -> libmythavformat-0.20.so.0.20.0
>         libmythavcodec-0.20.so.0 -> libmythavcodec-0.20.so.0.20.0
>         libmythavutil-0.20.so.0 -> libmythavutil-0.20.so.0.20.0
> ----------------------------
> So I do not have references to old libs. Now I am stuck.....
> I currently compile the new v0.20 bzip files from the website, but the compile 
> will still take a while....
>
> if I try to start the mythbackend from svn I get
> ----------------------------
> 2006-09-11 23:05:53.352 Using runtime prefix = /usr/local
> /usr/lib/libmysqlclient.so.14: undefined symbol:
> QSqlDatabase: QMYSQL3 driver not loaded
> /usr/lib/libmysqlclient.so.14: undefined symbol:
> /usr/lib/libmysqlclient.so.14: undefined symbol:
> QSqlDatabase: available drivers:
> 2006-09-11 23:05:53.523 New DB connection, total: 1
> 2006-09-11 23:05:53.523 Unable to connect to database!
> 2006-09-11 23:05:53.523 No error type from QSqlError?  Strange...
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2006-09-11 23:05:53.577 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2006-09-11 23:05:53.630 Failed to init MythContext, exiting.
> ----------------------------
>
> Since my previous version worked well I am out of options.....
>
> can someone tell me what is going on ?
>
> Thanks
> Juergen
>
>   
>> Am Sonntag, 10. September 2006 22:42 schrieb William Munson:
>>     
>>> Juergen Sachs wrote:
>>>       
>>>> helo,
>>>>
>>>> until this morning I run mythtv svn rev 10946 which run quiet well.
>>>> Today I decided to update and made:
>>>> - svn up (now rev 11110)
>>>> - make dist clean
>>>> - configure (taking default values)
>>>> - qmake mythtv.pro
>>>> - make
>>>> - make install
>>>>
>>>> and to test all I tried:
>>>> "/usr/local/bin/mythbackend"
>>>> and got the following:
>>>> -------------------------------------------
>>>> 2006-09-10 22:05:41.430 Using runtime prefix = /usr/local
>>>> /usr/lib/libmysqlclient.so.14: undefined symbol:
>>>> QSqlDatabase: QMYSQL3 driver not loaded
>>>> /usr/lib/libmysqlclient.so.14: undefined symbol:
>>>> /usr/lib/libmysqlclient.so.14: undefined symbol:
>>>> QSqlDatabase: available drivers:
>>>> 2006-09-10 22:05:41.493 New DB connection, total: 1
>>>> 2006-09-10 22:05:41.493 Unable to connect to database!
>>>> 2006-09-10 22:05:41.493 No error type from QSqlError?  Strange...
>>>> QSqlQuery::exec: database not open
>>>> QSqlQuery::exec: database not open
>>>> 2006-09-10 22:05:41.546 DB Error (KickDatabase):
>>>> Query was:
>>>> SELECT NULL;
>>>> No error type from QSqlError?  Strange...
>>>> 2006-09-10 22:05:41.598 Failed to init MythContext, exiting.
>>>> -------------------------------------------
>>>>
>>>> I guess this is something in my configuration, but I don't know what,
>>>> since the previous version worked.
>>>>
>>>> Since with the old rev 10946 all worked, I should have iunstalled all
>>>> needed mysql and qt files. I also find no note, that I have to take
>>>> care about some changes.
>>>>
>>>> can someone give me a hint what is going on ?
>>>>         
>>> You have a library issue. Remove all references to the 0.19 libs as they
>>> recently switched to 0.20 libs.
>>>       
>> I thought a "ldconfig" should do this ?
>> how do I remove all the references or at least get a list of all ?
>>
>> Thanks for the help !
>>
>> Juegren
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>     
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>