[mythtv-users] QSqlDatabase: QMYSQL3 driver not loaded

[Juergen Sachs]

Hmm,

I did not update any other parts than mythtv.
Reinstall qt did not help, but reinstall mysql fixed it.

Thanks for your help.

Juergen
> 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
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users