<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 16, 2023 at 4:06 PM Roland Ernst <<a href="mailto:rcrernst@gmail.com">rcrernst@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 16, 2023 at 9:46 PM James Abernathy <<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 16, 2023 at 1:23 PM James Abernathy <<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 16, 2023 at 12:57 PM Mike Perkins <<a href="mailto:mikep@randomtraveller.org.uk" target="_blank">mikep@randomtraveller.org.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 16/03/2023 17:26, James Abernathy wrote:<br>
> I have a working Ubuntu 22.10 mythtv v33 system, but mythfrontend only<br>
> works locally. I can run Leanfront from a FireTV remotely, but not<br>
> mythfrontend on the same firetv stick.<br>
> <br>
> My /etc/mysql/conf.d/mythtv.cnf is<br>
> [mysqld]<br>
> #bind-address=::<br>
> max_connections=100<br>
> <br>
> When I remove the # from the bind-address statement as you do in mysql the<br>
> database fails to connect locally with the backend. So there must be a<br>
> different way in mariaDB systems.<br>
> <br>
Same comment I just made to someone else: The mariadb config files override the mysql ones. Look for <br>
bind-address statements elsewhere in that tree.<br>
<br>
-- <br>
<br>
Mike Perkins<br></blockquote><div><br></div><div>I can only find 2 bind-address statements in the searchable path.</div><div>one is</div>bind-address = 127.0.0.1<br><div>with this explanation</div><div># Instead of skip-networking the default is now to listen only on<br># localhost which is more compatible and is not less secure.<br>bind-address = 127.0.0.1<br></div><div><br></div><div>in the mythtv.cnf there is another bind commented out:</div><div><span style="color:rgb(80,0,80)">#bind-address=::</span><br></div><div><span style="color:rgb(80,0,80)"><br></span></div><div><font color="#500050">Removing that # make mythtv not work at all.</font></div><div><font color="#500050"><br></font></div><div><font color="#500050">So I'm lost.</font></div><div><font color="#500050"><br></font></div><div><font color="#500050">Jim A</font></div></div></div></blockquote><div><br></div><div>I have tried using bind-address=0.0.0.0 everywhere I can find a bind-address statement. my mythtv-setup > General had the real IP of the backend and not 127.0.0.1.</div><div><br></div><div>When I start up mythfrontend on the FireTV it can't find the database and if I select Search, it comes back with </div><div>No UPnP backends found.</div><div><br></div><div>Jim A </div></div></div><br></blockquote><div> </div><div>You look into the wrong path. For MariaDB, the path is <br></div><div>/etc/mysql/mariadb.conf.d</div><div><br></div><div>Create a file 80-mythtv.cnf under above path and add</div><div><br></div><div># Additions form MythTV:<br>[mysqld]<br>bind-address=*<br>max_connections=100</div><div><br></div><div><br></div><div>Note the asterisk (*) is used for ipv4, the '::' is used for ipv6.</div><div>Creating an own file survives system updates.</div><div><br></div><div>Roland</div></div></div></blockquote><div><br></div><div>Thanks, that allowed me to manually setup the IP and mythconverg username and password and get mythfrontend for FireTV working.</div><div><br></div><div>I used to be about to do Search for backends, but UPnP doesn't seem to be configured in the default ubuntu fixes/33?</div><div><br></div><div>Jim A</div><div> </div></div></div>