[mythtv-users] Can't connect to remote backend database (again)

[Phill Edwards]

>
> > Back in June I posted a problem where I couldn't connect any remote
>
> > This is my list of users:
> > mysql> select host,user from mysql.user;
> > +-------------+------------------+
> > | host        | user             |
> > +-------------+------------------+
> > | %           | mythtv           |
> > | 192.168.0.% | mythtv           |
> > | localhost   | debian-sys-maint |
> > | localhost   | mysql.infoschema |
> > | localhost   | mysql.session    |
> > | localhost   | mysql.sys        |
> > | localhost   | root             |
> > +-------------+------------------+
>
> Run that mysql query again, but use:
>
> select host, user, password from mysql.user;
>
> So you can check if the (hash of the) passwords are the same. I have
> never seemed to have had any luck with using the '%' wildcard for
> connections. So I specify each one by IP:
>
> MariaDB [(none)]> select host,user,password from mysql.user where user =
> "mythtv";
> +-------------------+--------+-------------------------------------------+
> | host              | user   | password                                  |
> +-------------------+--------+-------------------------------------------+
> | localhost         | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC
> | 192.168.1.99      | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC
> | 192.168.1.96      | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC
> | 192.168.1.95      | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC
> | 192.168.1.86      | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC
>
> Those are the main desktop, the mythbox and the laptop (wired and
> wireless) as set in /etc/hosts and on each computer.
> Works for me.
>


Hi, thanks for this tip. I've literally been trying to get this working on
and off for weeks, but no success. As a last resort I dropped the user and
re-created it and used a brand new password, but it still won't connect.

If it was a normal linux frontend I could SSH in and test connectivity etc.
But as this is a Chromecast With Google TV device I can't do that - can I?
Any ideas how to troubleshoot this? The problem could be network
connectivity (probably not as the Leanfront app works), or database grants
or incorrect password? Any suggestions on how I can troubleshoot this?

Also, I noticed the Chromecast With Google TV device has an IPv6 address as
well as IPv4. Could that be causing a problem?



BTW the column names are different on MySQL vs MariaDB, so the MySQL query
should be
mysql> select host, user, authentication_string from mysql.user;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210806/0d4603dc/attachment.htm>