<br>
"%" is the mysql wildcard, like "*" in other systems.<br>
<br>
Did you see this page? <a href="http://www.mythtv.org/docs/mythtv-HOWTO-6.html">http://www.mythtv.org/docs/mythtv-HOWTO-6.html</a><br><br><div><span class="gmail_quote">On 7/11/06, <b class="gmail_sendername">H P Ladds</b>
<<a href="mailto:householdwords@gmail.com">householdwords@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div>Nick,</div>
<div> </div>
<div>Thanks so much.</div>
<div> </div>
<div>Did I mention my newbie status? I need to ask a few follow-up questions.</div>
<div> </div>
<div>How do I accertain the address of my local network? You correctly
noticed that error messages report failed attempts to connect to <a href="http://192.168.2.102" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.2.102</a>. (The <a href="http://192.168.0.112" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
192.168.0.112</a> adresses were hypothetical). ifconfig of my Front/Backend is <a href="http://192.168.2.102" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.2.102</a>.
I was trying to isolate on the "%" in the address; Is
that the correct usuage? Is "%" some tyope of wild card to
indicate that all addresses on the network may have access?
</div>
<div> </div>
<div>Thanks Again!<br> </div>
<div></div><div><span class="q"><span class="gmail_quote">On 7/11/06, <b class="gmail_sendername">Nick</b> <<a href="mailto:knowledgejunkie@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
knowledgejunkie@gmail.com</a>> wrote:</span>
</span></div><div><span class="e" id="q_10c5f2be16d14c8b_2"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">On 11/07/06, H P Ladds <<a href="mailto:householdwords@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
householdwords@gmail.com</a>> wrote:
<br>><br>> Hey all,<br>><br>> I can't connect to the Backend of my Frontend/Backend machine from a remote<br>> Frontend machine.<br>><br>> Using Knoppmyth. Frontend/Backend is a AMD 3500+ 64 machine. (Works Fine)
<br>> The Frontend only machine is a Celeron 3.05. (Has worked as a dedicated<br>> Front/Backend machine.)<br>> But using the Celeron as Frontend only....<br>><br>> Below are the error messages I receive:<br>
><br>> 2006-07-11 09:43:26.513 Using runtime prefix = /usr<br>> 2006-07-11 09:43:26.540 New DB connection, total: 1<br>> 2006-07-11 09:43:26.542 Unable to connect to database!<br>> 2006-07-11 09:43:26.542 Driver error was [1/2003]:
<br>> QMYSQL3: Unable to connect<br>> Database error was:<br>> Can't connect to MySQL server on '<a href="http://192.168.2.102" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.2.102
</a>' (111)<br>><br>> 2006-07-11 09:43:26.600 DB Error (KickDatabase):
<br>> Query was:<br>> SELECT NULL;<br>> No error type from QSqlError? Strange...<br>> 2006-07-11 09:43:26.653 Unable to connect to database!<br>> 2006-07-11 09:43:26.653 Driver error was [1/2003]:<br>> QMYSQL3: Unable to connect
<br>> Database error was:Can't connect to MySQL server on '<a href="http://192.168.2.102" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.2.102</a>' (111)<br>> ....<br>><br>> (note: many more instances of the above error message edited out ... )
<br>
><br>> 2006-07-11 09:43:36.003 DB Error (KickDatabase):<br>> Query was:<br>> SELECT NULL;<br>> No error type from QSqlError? Strange...<br>> 2006-07-11 09:43:36.056 Failed to init MythContext, exiting.<br>
><br>> I've tried a multitude of setup option provided by that Knoppmyth's API --<br>> no luck, always the same error messages as above.<br>><br>> I have also tried is solution from the web -- "Fedora Myth Tips-n-tTricks"
<br>> However, I can't tell if there is a typo in the instructions. If my backend<br>> is <a href="http://192.168.0.112" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.0.112</a> and the frontend is
<a href="http://192.168.0.115" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.0.115</a>. Are the instructions
<br>> suggesting that I grant permission to mythtv@"192.168.0.%" ? (Please see<br>> text below.)<br><br>If your local network is <a href="http://192.168.0.0/24" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
192.168.0.0/24</a> and you want remote machines
<br>to be able to connect to the SQL server with username 'mythtv', then<br>you need to grant access to either each machine explicitly, or more<br>commonly the local network as a whole, which is what the GRANT command<br>
above will do.<br><br>Note however, that the errors you posted above are trying to connect<br>to a SQL server on <a href="http://192.168.2.102" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.2.102
</a>, so you need to make sure you use the<br>correct network address in the GRANT command.
<br><br>> " Configuring a remote front-end is relatively easy. There are<br>> only a few steps you need to take on your back-end machine.<br>><br>> 1. On the machine you're running mysql (typically the same machine as your
<br>> MythTV master backend server), you need to allow mysql connections from<br>> other hosts on your network. This example assumes your local area network is<br>> <a href="http://10.0.1.0/255.255.255.0" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
10.0.1.0/255.255.255.0
</a>, adjust accordingly for your network:<br>> $ mysql -u root -p mythconverg<br>> mysql> grant all on mythconverg.* to mythtv@"10.0.1.%" identified by<br>> "mythtv";<br>> mysql> flush privileges;
<br>> mysql> quit<br><br>Note that the GRANT command above gives access to clients on the local<br><a href="http://10.0.1.0/24" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">10.0.1.0/24</a>
network logging into the database with username 'mythtv'.<br>If you want to alter this at any time, you will need to update the
<br>privileges.<br><br>> 3. On your remote systems, you'll need to edit one or more files. If your<br>> remote system is a remote frontend only, open up ~/.mythtv/mysql.txt, and<br>> change the DBHostName variable from localhost to the IP or host name of your
<br>> back-end server (the one you just set in the previous step). If your remote<br>> system is a slave backend ( i.e., it has a tuner card you want to use with<br>> MythTV), you'll need to make the same changes to /.mythtv/mysql.txt and
<br>> /root/.mythtv/mysql.txt.<br><br>Note that the mysql.txt file contains details of the SQL server,<br>database, username and password that MythTV will connect to, but if<br>you haven't granted access permissions to remote machines on the SQL
<br>server, you will not be abe to connect.<br><br>Nick<br><br>--<br>MythTV Official wiki:<br><a href="http://mythtv.org/wiki/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://mythtv.org/wiki/
</a><br>MythTV users list archive:<br><a href="http://www.gossamer-threads.com/lists/mythtv/users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.gossamer-threads.com/lists/mythtv/users</a><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></span></div><div></div><br>
</div><br>_______________________________________________<br>mythtv-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br><br><br></blockquote></div><br>