[mythtv-users] 0.19 - local frontend working great , remote frontend not (localhost:6543)

[Mark Knecht]

Phil,
   Thanks. I am sure you are on the right track. However you have
uncovered a problem here with MySQL permissions that I'm not
understanding. I hope you can help.

1) When I change (using mythfrontend or editing .mythtv/mysql.txt) the
backend server value in Dragonfly (the backend) from localhost to
either dragonfly or 192.168.1.55, then local frontend is no longer
able to connect to the server. Change it back to localhost and the
local frontend connect.

2) Since the above implies that the backend machine cannot connect to
mysql on itself, I try the following command sitting on the backend:

mark at dragonfly ~ $ mysql -u mythtv -h dragonfly mythconverg -p
Enter password:
ERROR 1045 (28000): Access denied for user 'mythtv'@'Dragonfly' (using
password: YES)
mark at dragonfly ~ $

So indeed the backend cannot connect to itself through the net. It
only connects when it connects through localhost:

mark at dragonfly ~ $ mysql -u mythtv -h localhost mythconverg -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.1.20-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye
mark at dragonfly ~ $

However, if I go to Lightning, one of the remote machines, it will
connect across the network:

mark at lightning ~ $ mysql -u mythtv -h dragonfly mythconverg -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.1.20-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Now, the way I'm trying to grant access is using the commands on this page:

http://www.mythtv.org/docs/mythtv-HOWTO-6.html

<QUOTE>
Finally, if you just want to restrict by IP subnet (in this example,
the 192.168.1. network):

    $ mysql -u root mythconverg
    mysql> grant all on mythconverg.* to mythtv@"192.168.1.%"
identified by "mythtv";
    mysql> flush privileges;
</QUOTE>

Before I did this none of the remote machines could connect, but for
whatever reason the local machine cannot.

Why?

Is there some way to read all the currently installed rules in the
database? I suspect that maybe some rule is overriding this granting
of access for the local machine?

NOTE: I also tried restarting mythbackend and mysql. That wasn't the solution.

Thanks,
Mark


On 7/19/06, Phill Wiggin <alamar at gmail.com> wrote:
> Go on  your backend computer (Dragonfly) and fire up Mythfrontend.
> There's a Settings menu.  Somewhere in there (pardon me, I'm not at my
> mythbox) there's an option for "Myth Backend" that's going to say
> "localhost". Change that to the IP of Dragonfly.
>
> Basically, what's happening is your Mysql table lists "MythBackend" as
> "localhost".  When Dragonfly starts up mythfrontend, it connects and
> queries for "MythBackend". All works fine on Dragonfly, because
> "localhost" resolves.  However, when Lightningbug connects to mysql,
> it asks for the value of "MythBackend" and gets the response
> "localhost", which resolves to "Lightning".... which has no backend
> service running.
>
> Change the MythBackend Server value on the backend machine
> (Dragonfly). There's no reason not to. "localhost" and "<Dragonfly's
> IP>" resolve the same way.  Hopefully, the next time you fire up
> mythfrontend on Lightning, it'll pick up that IP address and run.
>
> --Phill W.
>
> (Hope this isn't too vague, but I'm working from 2-3month old memories
> here... and my memory's never good very good. :))
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>