[mythtv-users] RESOLVED: Yet Again: Unable to connect to back end data base

[Phil Bridges]

On Dec 8, 2007 1:28 PM, Lan Barnes <lan at falleagle.net> wrote:
> Really simple. I booted the old, working Myth box and peeked in
> /etc/my.cnf. I needed to add these lines to /etc/my.cnf:
>
> port=3306
> bind-address=192.168.1.69
>
> Then I restarted mysqld, and all was well.
>
> On Sat, December 8, 2007 9:40 am, Lan Barnes wrote:
> > DAMN! That wasn't supposed to be sent. Please ignore for now -- I'm
> > tracking down more leads.
> >
> > On Sat, December 8, 2007 9:21 am, Lan Barnes wrote:
> >> I am configuring a new Myth box (MythDora 4 w/ Schedules Direct
> >> upgrade).
> >> mysql is still convinced it should listen on 127.0.0.1. because I have
> >> remote FEs, I want it to listen on the network.
> >>
> >> Here is what I've done:
> >>
> >> - granted all privileges on mythconverg.* to 192.168.100.% as "mythtv"
> >> and
> >> flushed
> >>
> >> - disabled selinux
> >>
> >> - shut down lokkit security
> >>
> >> - set a fixed IP on the BE
> >>
> >> - set the BE name to the IP addr in mythtv-setup/general
> >>

Don't you want to comment out the bind-address?  Otherwise, will a
local FE be able to connect.

Please don't top-post.  Thanks!