[mythtv-users] MySql permissions required for Frontend accessing Backend?

[Andrew Guenther]

On 7/7/06, alunt2003 at googlemail.com <alunt2003 at googlemail.com> wrote:
> On Fri, Jul 07, 2006 at 10:00:21AM -0500, Kevin Kuphal wrote:
> > alunt2003 at googlemail.com wrote:
> > > I have just the ip addresses in both frontends.
> > > I have the same user and password in both frontends as well.
> > >
> > > It's strange the way i can see some info. I can see for example when
> > > mythfilldatabase last ran, but not my recordings.
> > >
> > > Everything works beautifuuly on the combined frontend/backend
> > >
> > That must not be the case though because your frontend is trying to
> > connect to your backend using a name.  When you configured the backend
> > in mythtv-setup, did you tell it to identify itself as hostname or IP
> > address?
> >
> > Basically, the process is that the frontend connects to the DB using the
> > identifier you put in the frontend config, from there it reads the
> > master backend information you configured when you set up the backend,
> > then it tries to connect to that backend.
> >
> > I'm thinking that if you use IP on the frontend, then hostname on the
> > backend, that this might be causing problems.
> >
> > Kevin
>
> Kevin, your a genius!
> That's exactly what was wrong.
> I ran mythtv-setup and your right enough, I had hostnames in the "ip
> address of this machine" and "ip address of master server".
> I changed them to the actual ip address and problem solved.
>
> Thank you very much.
> Alun.
>
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

Score again for this thread. My MasterServerIP and BackendServerIP
were both set to 127.0.0.1.

Quickie check if you have this problem:
  mysqldump -u mythtv -pmythtv mythconverg settings -c > /tmp/sqldump
  grep -i serverip /tmp/sqldump

You should get two lines that look like vaguely like this:
INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES
('MasterServerIP','192.168.1.3',NULL);
INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES
('BackendServerIP','192.168.1.3','dinedin');

Those IPs cannot be set to localhost, 127.0.0.1, or anything else that
is not properly resolvable from your frontends. Actual IP of backend
server recommended. Run your favorite mythtv-setup program and try
again.