<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 2, 2017 at 9:20 AM, Stephen Worthington <span dir="ltr"><<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="gmail-HOEnZb"><div class="gmail-h5">On Wed, 2 Aug 2017 11:48:36 +0100, you wrote:<br>
<br>
>I beg to differ. This is mine:<br>
><br>
>mythtv@jade:/home/mythtv# cat /etc/mythtv/config.xml<br>
><Configuration><br>
> <LocalHostName><a href="http://jade.example.com" rel="noreferrer" target="_blank">jade.example.<wbr>com</a></LocalHostName><br>
> <Database><br>
> <PingHost>1</PingHost><br>
> <Host>192.168.NNN.NNN</Host><br>
> <UserName>mythtv</UserName><br>
> <Password>XXXXXXXXXX</<wbr>Password><br>
> <DatabaseName>mythconverg</<wbr>DatabaseName><br>
> <Port>3306</Port><br>
> </Database><br>
> <WakeOnLAN><br>
> <Enabled>0</Enabled><br>
> <SQLReconnectWaitTime>0</<wbr>SQLReconnectWaitTime><br>
> <SQLConnectRetry>5</<wbr>SQLConnectRetry><br>
> <Command>echo 'WOLsqlServerCommand not set'</Command><br>
> </WakeOnLAN><br>
></Configuration><br>
><br>
>mythtv@jade:/home/mythtv#<br>
><br>
>That LocalHostName entry is important. /Some/ of the checking that reads the file uses the hostname<br>
>(jade) for the 'Hostname' entries in the database and /some/ of the checking uses the fully<br>
>qualified domain name [FQDN] (<a href="http://jade.example.com" rel="noreferrer" target="_blank">jade.example.com</a>).<br>
><br>
>(I forgot during a recent upgrade and ended up with the backend using one and the frontend using the<br>
>other. Hilarity ensued? Er, no.)<br>
><br>
>It is best to make certain that the system knows what the host is called by specifying a<br>
>LocalHostName entry. It doesn't matter what it is; you can use the hostname, the FQDN or anything<br>
>else that is unique on your system.<br>
><br>
>Oh, and in mythtv-setup, make certain that the backend has the *same* IP address for backend and<br>
>master backend entries. Putting hostnames or FQDNs there can cause other problems.<br>
<br>
</div></div>I have never had to use the LocalHostName option - my database has<br>
then used the correct hostname for the box without any problems. I<br>
would guess that it gets it from /etc/hostname. My database does not<br>
contain anything that uses the FQDN:<br>
<br>
MariaDB [mythconverg]> select distinct hostname from settings;<br>
+-----------+<br>
| hostname |<br>
+-----------+<br>
| mypvr |<br>
| savaidh |<br>
| NULL |<br>
| jubalcho |<br>
| localhost |<br>
+-----------+<br>
5 rows in set (0.01 sec)<br></blockquote><div><br></div><div>I get this:</div><div><br></div><div><br></div><div>+------------------------+</div><div>| hostname |</div><div>+------------------------+</div><div>| mythmaster.localdomain |</div><div>| NULL |</div><div>| mythmaster |</div><div>+------------------------+</div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
In that list, mypvr is the main backend/frontend box, and savaidh and<br>
jubalcho are boxes that have had remote frontends on them in the past.<br>
I am not sure where localhost came from, but there is only one<br>
settings entry using it:<br>
<br>
MariaDB [mythconverg]> select * from settings where<br>
hostname='localhost';<br>
+-------+-----------+---------<wbr>--+<br>
| value | data | hostname |<br>
+-------+-----------+---------<wbr>--+<br>
| Theme | Mythbuntu | localhost |<br>
+-------+-----------+---------<wbr>--+<br>
1 row in set (0.00 sec)<br></blockquote><div><br></div><div>MariaDB [mythconverg]> select * from settings where hostname='localhost';</div><div>Empty set (0.00 sec)</div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
I think that if you have entries using an FQDN, then at some point<br>
your box must have lacked an /etc/hostname file, and then got the<br>
hostname from /etc/hosts or some other place that might have had an<br>
FQDN.<br>
<div class="gmail-HOEnZb"><div class="gmail-h5">______________________________<wbr>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/<wbr>mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/<wbr>Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</div></div></blockquote></div><br>I also did this:
</div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">MariaDB [mythconverg]> select * from settings where value like '%ServerIP';</div><div class="gmail_extra">+-----------------+-----------+------------------------+</div><div class="gmail_extra">| value | data | hostname |</div><div class="gmail_extra">+-----------------+-----------+------------------------+</div><div class="gmail_extra">| BackendServerIP | 172.16.10.54 | mythmaster.localdomain |</div><div class="gmail_extra">| MasterServerIP | 172.16.10.54 | NULL |</div><div class="gmail_extra">+-----------------+-----------+------------------------+</div><div><div>MariaDB [mythconverg]> select * from settings where data='0.0.0.0';</div><div>Empty set (0.00 sec)</div><div><br></div><div>MariaDB [mythconverg]> select * from settings where data='127.0.0.1';</div><div>Empty set (0.00 sec)</div></div><div><br></div><div><br></div></div></div>