<div><font size="2">Hey all,</font></div>
<div><font size="2"></font> </div>
<div><font size="2">I can't connect to the Backend of my Frontend/Backend machine from a remote Frontend machine.</font></div>
<div><font size="2"></font> </div>
<div><font size="2">Using Knoppmyth. Frontend/Backend is a AMD 3500+ 64 machine. (Works Fine) The Frontend only machine is a Celeron 3.05. (Has worked as a dedicated Front/Backend machine.)</font></div>
<div><font size="2">But using the Celeron as Frontend only....</font> </div>
<div><font size="2"></font> </div>
<div><font size="2">Below are the error messages I receive: </font></div>
<div><font size="2"></font> </div>
<div><font size="2">2006-07-11 09:43:26.513 Using runtime prefix = /usr</font></div>
<div><font size="2">2006-07-11 09:43:26.540 New DB connection, total: 1</font></div>
<div><font size="2">2006-07-11 09:43:26.542 Unable to connect to database!</font></div>
<div><font size="2">2006-07-11 09:43:26.542 Driver error was [1/2003]:</font></div>
<div><font size="2">QMYSQL3: Unable to connect</font></div>
<div><font size="2">Database error was:</font></div>
<div><font size="2">Can't connect to MySQL server on '<a href="http://192.168.2.102">192.168.2.102</a>' (111)</font></div>
<div><font size="2"></font> </div>
<div><font size="2">2006-07-11 09:43:26.600 DB Error (KickDatabase):</font></div>
<div><font size="2">Query was:</font></div>
<div><font size="2">SELECT NULL;</font></div>
<div><font size="2">No error type from QSqlError? Strange...</font></div>
<div><font size="2">2006-07-11 09:43:26.653 Unable to connect to database!</font></div>
<div><font size="2">2006-07-11 09:43:26.653 Driver error was [1/2003]:</font></div>
<div><font size="2">QMYSQL3: Unable to connect</font></div>
<div><font size="2">Database error was:Can't connect to MySQL server on '<a href="http://192.168.2.102">192.168.2.102</a>' (111) ....</font></div>
<div><font size="2"></font> </div>
<div><font size="2">(note: many more instances of the above error message edited out ... )</font></div>
<div><font size="2"></font> </div>
<div><font size="2">2006-07-11 09:43:36.003 DB Error (KickDatabase):</font></div>
<div><font size="2">Query was:</font></div>
<div><font size="2">SELECT NULL;</font></div>
<div><font size="2">No error type from QSqlError? Strange...</font></div>
<div><font size="2">2006-07-11 09:43:36.056 Failed to init MythContext, exiting.</font></div>
<div><font size="2"></font> </div>
<div><font size="2">I've tried a multitude of setup option provided by that Knoppmyth's API -- no luck, always the same error messages as above.</font></div>
<div><font size="2"></font> </div>
<div><font size="2">I have also tried is solution from the web -- "<a href="http://wilsonet.com/mythtv/tips.php">Fedora Myth Tips-n-tTricks</a>" </font><font size="2">However, I can't tell if there is a typo in the instructions. If my backend is
<a href="http://192.168.0.112">192.168.0.112</a> and the frontend is <a href="http://192.168.0.115">192.168.0.115</a>. Are the instructions suggesting that I grant permission to mythtv@"192.168.0.%" ? (Please see text below.)
</font></div>
<div><font size="2"></font> </div>
<div><font size="2"> " </font><font size="2">Configuring a remote front-end is relatively easy. There are only a few steps you need to take on your back-end machine.</font></div>
<p style="MARGIN-LEFT: 40px"><font size="2">1. On the machine you're running mysql (typically the same machine as your MythTV master backend server), you need to allow mysql connections from other hosts on your network. This example assumes your local area network is
<a href="http://10.0.1.0/255.255.255.0">10.0.1.0/255.255.255.0</a>, adjust accordingly for your network:</font></p>
<div class="cmd" style="MARGIN-LEFT: 40px"><font size="2">$ mysql -u root -p mythconverg<br>mysql> grant all on mythconverg.* to mythtv@"10.0.1.%" identified by "mythtv";<br>mysql> flush privileges;
<br>mysql> quit </font></div>
<p style="MARGIN-LEFT: 40px"><font size="2">2. In the mythtvsetup application on your back-end, you'll need to make sure you set the variables for "IP address for <host>" and "Master Server IP address" to the IP address of the back-end's network card, rather than the loopback address (
<a href="http://127.0.0.1">127.0.0.1</a>).</font></p>
<p style="MARGIN-LEFT: 40px"><font size="2">3. On your remote systems, you'll need to edit one or more files. If your remote system is a remote frontend only, open up ~/.mythtv/mysql.txt, and change the DBHostName variable from localhost to the IP or host name of your back-end server (the one you just set in the previous step). If your remote system is a slave backend (
i.e., it has a tuner card you want to use with MythTV), you'll need to make the same changes to /.mythtv/mysql.txt and /root/.mythtv/mysql.txt.</font></p>
<p style="MARGIN-LEFT: 40px"><font size="2">4. In the mythtvsetup application on your front-end, you'll need to make sure you set the variable for "Master Server IP address" to the IP address of the machine you just set in your
mysql.txt file.</font></p>
<div style="MARGIN-LEFT: 40px" align="left"><font size="2">These are the primary changes that differentiate a setup with a remote front-end, but you'll also have to go through the bulk of the rest of the steps detailed here to get things working. A few of the packages installed throughout this guide aren't necessary for a front-end only system, but it won't hurt anything to install them anyway, so I'm not going to go into what they are."
</font></div>
<div style="MARGIN-LEFT: 40px" align="left"><font size="2"></font> </div><font size="2"><font size="2">
<div>I have read that problems similar to mine are caused by running differing versions of MySQL. I installed from the same installation disk, so I'm assuming that the same version has been installed. But perhaps not; might KnoppmythTV install two differing version of MySQL -- depending upon the machine's hardware?
</div>
<div> </div>
<div>Thanks All</div>
<div> </div>
<div> </div></font></font>
<div><font size="2"></font> </div>