[mythtv-users] Issue with back end host address

[Dave Ulrick]

Deleting the value of BackendServerIP changes the issue. Now 127.0.0.1 
is treated as the one-and-only Primary IP Address plus it is assigned to 
a new instance of BackendServerIP:

1. Stop mythbackend
2. Launch mythtv-setup
3. General.
4. Host Address Backend Setup
5. Uncheck Listen on All IP Addresses
6. Select Primary IP Address/DNS Name
7. The only IP listed is 127.0.0.1.
8. Select New Entry and enter 192.168.4.7.
9. Exit Settings / Save and Exit
10. Redo steps 4 - 7. The Primary IP is still 127.0.0.1.

 From the database:

MariaDB [mythconverg]> select * from settings where data like '127.0.0.1';
+-------------------+-----------+----------------+
| value             | data      | hostname       |
+-------------------+-----------+----------------+
| BackendServerIP   | 127.0.0.1 | calvin.home.du |
| MasterServerIP    | 127.0.0.1 | NULL           |
| BackendServerAddr | 127.0.0.1 | calvin.home.du |
+-------------------+-----------+----------------+

Dave


On 6/15/21 8:09 AM, Dave Ulrick wrote:
> MariaDB [mythconverg]> select * from settings where data like 
> '192.168.%';
> +-------------------+-------------+----------------+
> | value             | data        | hostname       |
> +-------------------+-------------+----------------+
> | BackendServerIP   | 192.168.1.5 | calvin.home.du |
> | MasterServerIP    | 192.168.4.7 | NULL           |
> | BackendServerAddr | 192.168.4.7 | calvin.home.du |
> +-------------------+-------------+----------------+
>
> BackendServerIP has the same 'data' value that is being used by 
> mythtv-frontend.
>
> Dave
>
>
> On 6/15/21 4:20 AM, Stephen Worthington wrote:
>> On Mon, 14 Jun 2021 14:40:36 -0500, you wrote:
>>
>>> A few weeks ago I successfully migrated a MythTV 31 backend to a new 
>>> PC.
>>> Recently I noticed the backend was set up to listen on all 
>>> interfaces so
>>> I thought I'd reconfigure it to listen on just the PC's primary IP,
>>> 192.168.4.7. It didn't go very well:
>>>
>>> 1. Stop mythbackend
>>> 2. Launch mythtv-setup
>>> 3. General.
>>> 4. Host Address Backend Setup
>>> 5. Uncheck Listen on All IP Addresses
>>> 6. Select Primary IP Address/DNS Name
>>> 7. The only IP listed was 192.168.1.5 which was an old IP for the old
>>> PC. The old PC's IP was 192.168.4.5 at the time I took the database
>>> backup which I imported into the new backend's database. None of the 
>>> new
>>> PC's IPs--192.168.4.7 or 127.0.0.1--were listed.
>>> 8. Select New Entry and enter 192.168.4.7.
>>> 9. Exit Settings / Save and Exit
>>> 10. Redo steps 4 - 7. The Primary IP is still 192.168.1.5.
>>>
>>> I ended up going back to Listen on All IP Addresses. This lets me
>>> connect on 192.168.4.7 OK. I'd just like to turn off listening on the
>>> other IPs.
>>>
>>> Is this a bug or might I have migrated a stale database entry with the
>>> old 192.168.1.5 IP? Any way to get this straightened out?
>>>
>>> Thanks,
>>> Dave
>> Check your settings in the database - what does this query show?
>>
>> sudo mysql
>> use mythconverg;
>> select * from settings where data like '192.%';
>> quit
>>
>> I get this:
>>
>> MariaDB [mythconverg]> select * from settings where data like '10.%';
>> +-------------------+----------+----------+
>> | value             | data     | hostname |
>> +-------------------+----------+----------+
>> | MasterServerIP    | 10.0.2.4 | NULL     |
>> | BackendServerIP   | 10.0.2.4 | mypvr    |
>> | BackendServerAddr | 10.0.2.4 | mypvr    |
>> +-------------------+----------+----------+
>> 3 rows in set (0.002 sec)
>>
>> but I believe BackendServerIP is historical and no longer used.
>> _______________________________________________
>> 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
>
> _______________________________________________
> 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