[mythtv-users] Issue with back end host address

[Stephen Worthington]

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.