[mythtv-users] Frontend MySQL connection not working

[Stephen P. Villano]

On 3/9/14, 1:48 AM, Phill Edwards wrote:
> 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:
>
> $ telnet 192.168.0.120 3306
> Trying 192.168.0.120...
> Connected to 192.168.0.120.
> Escape character is '^]'.
> hHost 'mfe1.local' is blocked because of many connection errors;
> unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.
>
> 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:
>
> $ telnet 192.168.0.120 3306
> Trying 192.168.0.120...
> Connected to 192.168.0.120.
> Escape character is '^]'.
> [
> 5.5.35-0ubuntu0.12.04.2?\yk-;!3?/w.y;W%QJ`"&mysql_native_password
>
> 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.
>
> I would have thought if the telnet connection is working it would all
> be OK. Any idea how I can resolve this?
>
>
> _______________________________________________
>
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.
It's in the MythTV wiki.
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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140309/57212ac8/attachment.html>