[mythtvnz] Broken communication from front end

[Steve Hodge]

On Thu, Sep 20, 2012 at 8:51 PM, Worik Stanton <worik.stanton at gmail.com>wrote:

> [snip]
> >
> > Need a bit more info.
> >
> > a) You stated your authentication password was "mythtv".
> >     Is this a sanitized value?
> >     Is the actual passwod you used the same as the
> >     password in       /home/mythtv/.mythtv/mysql.txt  ?
>
> Did I state that?


Yes, you did. The command you issued was:
'grant all on mythconverg.* to mythtv@"192.168.1.%" identified by "mythtv";'

If the user 'mythtv@"192.168.1.%"' doesn't already exist, then that command
will create the user with the password specified by the "identified by"
clause. So I think the issue you have is caused by the frontend now trying
to connect with this new user, but the wrong (old) password. Either change
the password for the mysql user or change the password specified in
/home/mythtv/.mythtv/mysql.txt.


mysql> select Host, User from user;
> +-------------+------------------+
> | Host        | User             |
> +-------------+------------------+
> | %           | mythtv           |
> | 127.0.0.1   | root             |
> | 192.168.1.% | mythtv           |
> | cardamom    | root             |
> | localhost   | debian-sys-maint |
> | localhost   | mythtv           |
> | localhost   | root             |
> +-------------+------------------+
>

Notice that there are several mysql users. A frontend running on the server
would connect using mysql at localhost. A frontend running somewhere else on
the network would connect using 'mythtv@"192.168.1.%"'. You've set these
users up with different passwords.

Cheers,
Steve
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20120920/ed0406a7/attachment.html>