While performing a fresh install of MythTV (<a href="http://mythtv-suite-0.19-57.at">mythtv-suite-0.19-57.at</a>) on FC5 for use a slave backend, the command:<br><br><font size="1"><span style="font-family: courier new,monospace;">
service mythbackend start</span></font> <br><br>this will not start the slave backend properly. An error in the log stated that the master database could not be found while attempting to connect to mysqld on localhost. The only workaround was to start the slave backend by running the server directly with command:
<br><br><font size="1"> </font><span style="font-family: courier new,monospace;"><font size="1">/etc/rc.d/init.d/mythbackend start</font><br><br style="font-family: arial,sans-serif;"></span><span style="font-family: arial,sans-serif;">
I have been using this workaround since the release of FC5. Today I realized the mythtv-setup program was using /root/.mythtv/mysql.txt for backend configuration while the Fedora service interface was using /.mythtv/mysql.txt. Yes, that is right! It was created in the root dorectory. This caused the
mysql.txt file to be created (if not already present) with the default value of localhost as the master backend hostname.<br><br>Is this a bug/errata? I tried the same exact installation on both i686 and x86_64 with the same results. The only difference on the slave and the master installs is that I did not create a mythtv user before the mythtv-suite was installed. I suspect that the installation on the slave without a user already created, built the mythtv user as a 'no login and no rights' kind of user and it's profile and path were junked. As soon as I edited the /.mythtv/mysql.text to the correct master backend hostname the service and chkconfig interfaces worked again. Now this is not the correct place for the config to be placed. Can anyone tell how to move that config to /var/lib/mythtv/mysql.txt so that the service interface uses it corectly?
<br></span><br>The error message is here:<br><font size="1"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">2006-04-09 18:10:30.730 Using runtime prefix = /usr</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">2006-04-09 18:10:30.752 Unable to read configuration file mysql.txt</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
2006-04-09 18:10:30.753 Trying to create a basic mysql.txt file</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">2006-04-09 18:10:30.770 Writing settings file //.mythtv/mysql.txt
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">2006-04-09 18:10:30.797 New DB connection, total: 1</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
2006-04-09 18:10:30.801 Unable to connect to database!</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">2006-04-09 18:10:30.802 Driver error was [1/2002]:</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">QMYSQL3: Unable to connect</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Database error was:</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">QSqlQuery::exec: database not open</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">QSqlQuery::exec: database not open
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">2006-04-09 18:10:30.857 DB Error (KickDatabase):</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
Query was:</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">SELECT NULL;</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
No error type from QSqlError? Strange...</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">2006-04-09 18:10:30.908 Failed to init MythContext, exiting.</span></font><br>
<br>Someone, please use this post to your advantage. It's racked my brain for several weeks.<br><br clear="all"><br>-- <br>Chris Everest<br>