[mythtv-users] Issue with back end host address

[Dave Ulrick]

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