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

[Barry Martin]

Hi Stephen!


> I am thinking that the simple way to fix this is to just directly
> change the BackendServerAddr in the database.  And the mythsgu event
> is no longer needed, so it can just be removed:
>
> sudo su
> mysql
> use mythconverg;
> update settings set data='192.168.4.3' where value='BackendServerAddr'
> and hostname='backend-3';
> update settings set data='' where value='EventCmdAll' and
> hostname='backend-3';
> quit
> systemctl restart mythtv-backend
> exit

I’m getting better at this stuff! Caught the line wrapping! The ‘and 
hostname’ didn’t make sense, then looked and noticed the lack of the 
semicolon after the line previous.



Results:


barry at Backend-3:~$ sudo su

[sudo] password for barry:

root at Backend-3:/home/barry# mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 617

Server version: 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04


Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input 
statement.


MariaDB [(none)]> use mythconverg;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A


Database changed

MariaDB [mythconverg]> update settings set data='192.168.4.3' where 
value='BackendServerAddr' and hostname='backend-3';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0


MariaDB [mythconverg]> update settings set data='' where 
value='EventCmdAll' and hostname='backend-3';

Query OK, 1 row affected (0.02 sec)

Rows matched: 1 Changed: 1 Warnings: 0


MariaDB [mythconverg]> quit

Bye

root at Backend-3:/home/barry# systemctl restart mythtv-backend

root at Backend-3:/home/barry# exit

exit

barry at Backend-3:~$



- - -


Took maybe two minutes to get back to the prompt at the restart 
mythtv-backend line.


---

And now the test! <drumroll...>


YESSSS!!!!!! <Cartwheels, fireworks, marching bands> :)


Test on a stand-alone device:

Errors because (remote) FE still set to the old IP; correct that. .. 
Thinks a while, connects!! (Figured it would, just wanted to verify.)


Thanks to you and Bill and Hika (hope I didn’t miss any one) for helping 
out!


Should your correction/update command set be placed in a Wiki or some 
sort of help page? This issue is bound to come up again.


Barry


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20200623/f49146a4/attachment.htm>