<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=Windows-1252">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=858040114-30122003>Well,
a good night's sleep, and a fresh look at the strace output has opened my
eyes. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=858040114-30122003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=858040114-30122003>The
problem in my case was NOT that the Qt sql drivers were in the wrong
place, but that the libmysqlclient.so.10 file was not being found. Come to
find out that it was in </SPAN></FONT><FONT face=Arial color=#0000ff
size=2><SPAN class=858040114-30122003>/usr/lib/mysql (not in /usr/lib) and so by
adding /usr/lib/mysql to my /etc/ld.so.conf file and running ldconfig it
was included.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=858040114-30122003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=858040114-30122003>Hope
this can help someone else fighting the same battle.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=858040114-30122003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=858040114-30122003>Regards, </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=858040114-30122003>Derek</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
mythtv-users-bounces@mythtv.org [mailto:mythtv-users-bounces@mythtv.org] <B>On
Behalf Of </B>info@edivise.com<BR><B>Sent:</B> Monday, December 29, 2003 9:07
PM<BR><B>To:</B> mythtv-users@mythtv.org<BR><B>Subject:</B> [mythtv-users]
QMYSQL3 not loading<BR><BR></FONT></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>Having scoured the
mailing lists and other sources and still coming up empty, I now bow before
the MythTV gods with this problem. Hopefully together we can find a
resolution for what appears to be a common issue:</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>I have largely
followed the Fedora/ATrpm guide to this point, troubleshooting each error
along the way. Here's my system description:</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>Fedora Core
1</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>mythtv
0.13</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial
size=2>qt-3.1.2</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>mysql
3.23.58</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>When trying to run
'mythtvsetup' I get this familiar error:</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>QSqlDatabase
warning: QMYSQL3 driver not loaded</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>QSqlDatabase:
available drivers: QODBC3</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>QSqlDatabase
warning: QMYSQL3 driver not loaded</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003><FONT face=Arial size=2>QSqlDatabase:
available drivers: QODBC3</FONT></SPAN></DIV>
<DIV><SPAN class=488554223-29122003>Unable to connect to
database!</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>No error type from QSqlError?
Strange...</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>unable to open database:</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>Driver error was:</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>Driver not loaded</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>Database error was:</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>Driver not loaded</SPAN></DIV>
<DIV><SPAN class=488554223-29122003></SPAN> </DIV>
<DIV><SPAN class=488554223-29122003>What is interesting is that initially the
error did not show anything after the 'available drivers:' bit. I then
used apt-get and I pulled down the qt-ODBC package, which installed fine, and
then it started to show up (which makes me thing that the path variables and
QTDIR are set properly).</SPAN></DIV>
<DIV><SPAN class=488554223-29122003></SPAN> </DIV>
<DIV><SPAN class=488554223-29122003>Here are the troubleshooting steps I have
taken thus far, all giving me the same result:</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>-- In the
/usr/lib/qt-3.1/plugins/sqldrivers directory is both libqsqlmysql.so and
libqsqlodbc.so</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>-- I have confirmed that mysql is running
and that the 'mythconverg' database has been created.</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>-- I have appropriately changed the
mysql.txt in the /usr/share/mythtv directory for my local database
user/pwd.</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>-- I have confirmed that the Environment
variables are set properly: (</SPAN><SPAN class=488554223-29122003>PATH
includes /usr/lib/qt-3.1/lib and </SPAN><SPAN class=488554223-29122003>QTDIR =
/usr/lib/qt-3.1/)</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>-- I have verified that the library paths
settings in 'qtconfig' includes /usr/lib/qt-3.1/plugins</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>-- I have completely removed qt (and all
dependent packages, mind you) and re-installed, as well as making sure that
qt-MySQL is in place before installing any of the MythTV
packages.</SPAN></DIV>
<DIV><SPAN class=488554223-29122003>-- </SPAN><SPAN class=488554223-29122003>I
have confirmed that /usr/lib/qt-3.1/lib is in my /etc/ld.so.conf file and have
run 'ldconfig' as root.</SPAN></DIV>
<DIV><SPAN class=488554223-29122003></SPAN> </DIV>
<DIV><SPAN class=488554223-29122003>Some other postings (on various
groups/lists) suggest that the MySQL driver needs to be compiled in with the
Qt core...but I wasn't sure if that would apply since I am getting compiled
RPMs rather than source.</SPAN></DIV>
<DIV><SPAN class=488554223-29122003></SPAN> </DIV>
<DIV><SPAN class=488554223-29122003>Any insight is appreciated. All the
steps up to this point have been well described by all. </SPAN></DIV>
<DIV><SPAN class=488554223-29122003></SPAN> </DIV>
<DIV><SPAN class=488554223-29122003>Best, </SPAN></DIV>
<DIV><SPAN class=488554223-29122003>Derek</SPAN></DIV></FONT></SPAN></DIV><BR>
<P><FONT size=2>---<BR><BR>Checked by AVG anti-virus system
(http://www.grisoft.com).<BR>Version: 6.0.556 / Virus Database: 348 - Release
Date: 12/26/2003<BR></FONT></P><BR>
<P><FONT size=2>---<BR><BR>Checked by AVG anti-virus system
(http://www.grisoft.com).<BR>Version: 6.0.556 / Virus Database: 348 - Release
Date: 12/26/2003<BR></FONT></P>
<P><FONT face=Arial size=2></FONT></P></BLOCKQUOTE></BODY></HTML>
<BR>
<P><FONT SIZE=2>---<BR>
<BR>
Checked by AVG anti-virus system (http://www.grisoft.com).<BR>
Version: 6.0.556 / Virus Database: 348 - Release Date: 12/26/2003<BR>
</FONT> </P>