[mythtv-users] New IP address not used by Database

[Stephen Worthington]

On Sat, 20 Jun 2020 15:50:22 -0500, you wrote:

>Hi Folks!
>
>Got a new router and so all of my LAN addresses had to be changed from 
>192.168.0.x to 192.168.4.x. Was able to change the static address of my 
>Backend (Ubuntu 18.04, MythTV v. 30, MariaDB. Changed the config.xml to 
>the new address without problem, and can access the machine via the 
>webpage (192.168.4.3:6544). The problem is the database won’t stay 
>updated. Takes at least five minutes to get to the GUI (even using 
>mythtv-setup.real), I can change the database address to the desired 
>192.168.4.3, save and close. Run mythfilldatabase and it gives errors 
>and as it’s already looking at the old 192.168.0.3 address.
>
>(Stephen Worthington: I did update your routine to look to ascertain the 
>network was up.)
>
>Subquestion: A while back there was a thread to post to the website and 
>not this e-mailed forum. What’s the site?? I found the Gossamer Threads 
>repost but not the original. Thanks!
>
>
>TIA
>
>Barry

Check all the settings in your database for the old IP address:

sudo su
mysql
use mythconverg;
select * from settings where data like '%192.168.%';
exit
exit

That should tell you if there is one you missed.  I get this on my
MythTV box:

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.00 sec)


Then check all the different config.xml files:

/etc/mythtv/config.xml
/home/mythtv/.mythtv/config.xml
/home/<mythfrontend user>/.mythtv/config.xml

It can also be a good idea to check all settings in /etc for the old
IP address, such as /etc/hosts:

sudo su
cd /etc
grep -r "192.168." *
exit

The MythTV forums are here:

https://forum.mythtv.org