[mythtv-users] Issue with back end host address

[Dave Ulrick]

Just now I changed bind-address to 192.168.4.7 in my.cnf (I have FEs on 
multiple PCs) and restarted MySQL. Then I stopped mythbackend and ran 
mythtv-config. No change: 127.0.0.1 is still the only accepted host IP 
when Listen on All IP Addresses is unchecked.

Dave




On 6/15/21 2:25 PM, R. G. Newbury wrote:
> On 2021-06-15 12:55 p.m., Dave Ulrick wrote:
>> When I turn on Listen on All IP Addresses, 192.168.4.7 is listed 
>> among the set of IP addresses. I can then choose it as my primary IP. 
>> 192.168.4.7 is saved if I choose Save and Exit. Good. Then, if I turn 
>> off Listen on All IP Addresses, 192.168.4.7 is replaced with 
>> 127.0.0.1, thus recreating my original issue.
>>
>> Just now I booted Linux with IPv6 enabled. The mythtv-setup issue 
>> with the back end host address is the same: 127.0.0.1 is my only 
>> option if I turn off Listen on All IP Addresses.
>>
>> Looks like I'm stuck with listening on all IPs...
>
> This looks like it might be a mysql mis-configuration.
> Search your my.cnf or the files in my.cnf.d for 'bind-address'
> and comment out that line. Restart mysqld. Test.
>
> If you have no bind-address set, then mysql listens ONLY to localhost.
> If you have bind-address=0.0.0.0 then mysql listens to any network.
>
> If you have bind-address=192.168.20.20 then *this* mysql instance will 
> only accept connections from that IP.
> In BE/FE setups, 127.0.0.1 works fine.
> If you have a remote front end, the mysql *CLIENT* must be told to 
> connect to the mysql server using the server's address.
>
> Not sure from this thread whether yours is a BE/FE or remote FE setup.
>
> Geoff
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org