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

Stephen Worthington stephen_agent at jsw.gen.nz
Sat Aug 7 02:18:06 UTC 2021


On Fri, 6 Aug 2021 17:52:52 +1000, you wrote:

>>
>> > 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;

You can run Wireshark on the server and see the network traffic.


More information about the mythtv-users mailing list