<!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><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></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>