<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<p> </p>
<p style="margin-bottom: 0in; line-height: 100%">Hi Stephen!</p>
<p>
<style type="text/css">
p { margin-bottom: 0.1in; line-height: 115% }
a:link { so-language: zxx }</style></p>
<div class="moz-cite-prefix"><br>
</div>
<blockquote type="cite"
cite="mid:mailman.5.1592913602.18575.mythtv-users@mythtv.org">
<pre class="moz-quote-pre" wrap="">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
</pre>
</blockquote>
<p> </p>
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.
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Results:</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"> </p>
<p style="margin-bottom: 0in; line-height: 100%">barry@Backend-3:~$
sudo su</p>
<p style="margin-bottom: 0in; line-height: 100%">[sudo] password for
barry: </p>
<p style="margin-bottom: 0in; line-height: 100%">root@Backend-3:/home/barry#
mysql</p>
<p style="margin-bottom: 0in; line-height: 100%">Welcome to the
MariaDB monitor. Commands end with ; or \g.</p>
<p style="margin-bottom: 0in; line-height: 100%">Your MariaDB
connection id is 617</p>
<p style="margin-bottom: 0in; line-height: 100%">Server version:
10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Copyright (c) 2000,
2018, Oracle, MariaDB Corporation Ab and others.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Type 'help;' or
'\h'
for help. Type '\c' to clear the current input statement.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">MariaDB
[(none)]>
use mythconverg;</p>
<p style="margin-bottom: 0in; line-height: 100%">Reading table
information for completion of table and column names</p>
<p style="margin-bottom: 0in; line-height: 100%">You can turn off
this feature to get a quicker startup with -A</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Database changed</p>
<p style="margin-bottom: 0in; line-height: 100%">MariaDB
[mythconverg]> update settings set data='192.168.4.3' where
value='BackendServerAddr' and hostname='backend-3';</p>
<p style="margin-bottom: 0in; line-height: 100%">Query OK, 1 row
affected (0.00 sec)</p>
<p style="margin-bottom: 0in; line-height: 100%">Rows matched: 1
Changed: 1 Warnings: 0</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">MariaDB
[mythconverg]> update settings set data='' where
value='EventCmdAll' and hostname='backend-3';</p>
<p style="margin-bottom: 0in; line-height: 100%">Query OK, 1 row
affected (0.02 sec)</p>
<p style="margin-bottom: 0in; line-height: 100%">Rows matched: 1
Changed: 1 Warnings: 0</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">MariaDB
[mythconverg]> quit</p>
<p style="margin-bottom: 0in; line-height: 100%">Bye</p>
<p style="margin-bottom: 0in; line-height: 100%">root@Backend-3:/home/barry#
systemctl restart mythtv-backend</p>
<p style="margin-bottom: 0in; line-height: 100%">root@Backend-3:/home/barry#
exit</p>
<p style="margin-bottom: 0in; line-height: 100%">exit</p>
<p style="margin-bottom: 0in; line-height: 100%">barry@Backend-3:~$
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">- - - </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Took maybe two
minutes to get back to the prompt at the restart mythtv-backend
line.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">--- </p>
<p style="margin-bottom: 0in; line-height: 100%">And now the test!
<drumroll...></p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">YESSSS!!!!!!
<Cartwheels, fireworks, marching bands> :)</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Test on a
stand-alone device:</p>
<p style="margin-bottom: 0in; line-height: 100%">Errors because
(remote) FE still set to the old IP; correct that. .. Thinks a
while, connects!! (Figured it would, just wanted to verify.)</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Thanks to you and
Bill and Hika (hope I didn’t miss any one) for helping out!</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">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.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Barry </p>
<p>
<style type="text/css">
p { margin-bottom: 0.1in; line-height: 115% }
a:link { so-language: zxx }</style></p>
<p><br>
</p>
</body>
</html>