I had this same problem using ubuntu, even after using the grand tip.
However, the mysql server was able to listen only the localhost. In my
case, this was setup in /etc/mysql/my.cnf file. the line bind-address
should be commented.<br>
<br>
BR,<br>
Melunko<br><br><div><span class="gmail_quote">On 7/11/06, <b class="gmail_sendername">Nick</b> <<a href="mailto:knowledgejunkie@gmail.com">knowledgejunkie@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;">
On 11/07/06, H P Ladds <<a href="mailto:householdwords@gmail.com">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">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">
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">
192.168.0.112</a> and the frontend is <a href="http://192.168.0.115">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">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">
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">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">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/">http://mythtv.org/wiki/</a><br>MythTV users list archive:<br><a href="http://www.gossamer-threads.com/lists/mythtv/users">http://www.gossamer-threads.com/lists/mythtv/users
</a><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div><br>