<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
<div class="moz-cite-prefix">On 3/9/14, 1:48 AM, Phill Edwards
wrote:<br>
</div>
<blockquote
cite="mid:CAE2RtTMHbMXh_ueXLq1XBODVWJ4iRGy+DiBRH9GAzzGDha+XwQ@mail.gmail.com"
type="cite">
<div dir="ltr">I've been fiddling around with things on my home
LAN and got into a situation where my Frontend kept having
connection errors with the separate Backend. Once I'd got things
back to the way they were on the LAN, I could still no longer
get a connection. So I tried to telnet to backend port 3306 from
the frontend and got this error:
<div>
<br>
</div>
<div>
<div><font face="courier new, monospace">$ telnet
192.168.0.120 3306</font></div>
<div><font face="courier new, monospace">Trying
192.168.0.120...</font></div>
<div><font face="courier new, monospace">Connected to
192.168.0.120.</font></div>
<div><font face="courier new, monospace">Escape character is
'^]'.</font></div>
<div><font face="courier new, monospace">hHost 'mfe1.local' is
blocked because of many connection errors; unblock with
'mysqladmin flush-hosts'Connection closed by foreign host.</font></div>
</div>
<div><br>
</div>
<div>I then logged into mysql as root on the backend and issued"
flush hosts" command. But the frontend still can't connect to
the backend, even though I can now get a telnet connection on
port 3306:</div>
<div><br>
</div>
<div>
<div><font face="courier new, monospace">$ telnet
192.168.0.120 3306</font></div>
<div><font face="courier new, monospace">Trying
192.168.0.120...</font></div>
<div><font face="courier new, monospace">Connected to
192.168.0.120.</font></div>
<div><font face="courier new, monospace">Escape character is
'^]'.</font></div>
<div><font face="courier new, monospace">[</font></div>
<div><font face="courier new, monospace">5.5.35-0ubuntu0.12.04.2▒\yk-;!3▒/w.y;W%QJ`"&mysql_native_password</font></div>
</div>
<div><br>
</div>
<div>I'm now in that eternal loop where the frontend asks for
hostname, DB name, DB user etc (the "Database Configuration"
screens) but it can't connect when you click the Finish button
so it loops round again to have another go.</div>
<div><br>
</div>
<div>I would have thought if the telnet connection is working it
would all be OK. Any idea how I can resolve this?</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
</pre>
</blockquote>
Telnet isn't the answer, mysql is. As in mysql to the backend. Even
money, your FE isn't being accepted as a connection, as its account
isn't accepted *or* mysql isn't accepting connections from any IP
that isn't itself.<br>
It's in the MythTV wiki. <br>
Ran into that myself. The wiki will explain it easier than my late
night attempt and give you further clues to other issues that could
occur.<br>
<br>
</body>
</html>