<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
<br class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On Jan 8, 2018, at 11:07 PM, Greg Oliver <<a href="mailto:oliver.greg@gmail.com" class="">oliver.greg@gmail.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">On Mon, Jan 8, 2018 at 10:01 PM, Jim Abernathy <span dir="ltr" class="">
<<a href="mailto:jfabernathy@outlook.com" target="_blank" class="">jfabernathy@outlook.com</a>></span> wrote:<br class="">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;line-break:after-white-space" class=""><span class=""><br class="">
<div class="">
<blockquote type="cite" class="">
<div class="">
<div style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" class="">
<div class=""><br class="">
</div>
I think I see the problem:</div>
<div style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" class="">
<div style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;background-color:rgb(253,253,253)" class="">
<span style="font-variant-ligatures:no-common-ligatures;color:rgb(50,187,37)" class=""><b class="">jim@mythbuntu</b></span><span style="font-variant-ligatures:no-common-ligatures" class="">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(82,47,224)" class=""><b class="">~</b></span><span style="font-variant-ligatures:no-common-ligatures" class="">$
sudo grep -r bind-address /etc/mysql </span></div>
<div style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;background-color:rgb(253,253,253)" class="">
<span style="font-variant-ligatures:no-common-ligatures" class="">/etc/mysql/mariadb.conf.d/50-<wbr class="">server.cnf:bind-address<span class="m_-4847731015851484270Apple-tab-span" style="white-space:pre-wrap">
</span>= 127.0.0.1</span></div>
<div style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;background-color:rgb(253,253,253)" class="">
<span style="font-variant-ligatures:no-common-ligatures" class="">/etc/mysql/conf.d/mythtv.cnf:#<wbr class="">bind-address=::</span></div>
<div style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(50,187,37);background-color:rgb(253,253,253)" class="">
<span style="font-variant-ligatures:no-common-ligatures" class=""><b class="">jim@mythbuntu</b></span><span style="font-variant-ligatures:no-common-ligatures" class="">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(82,47,224)" class=""><b class="">~</b></span><span style="font-variant-ligatures:no-common-ligatures" class="">$ </span></div>
<div style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(50,187,37);background-color:rgb(253,253,253)" class="">
<span style="font-variant-ligatures:no-common-ligatures" class="">I think it chases the conf.d directory with the mythtv.cnf before it goes to mariadb.conf.d where ther is a bind-address=127.0.0.1</span></div>
<div style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(50,187,37);background-color:rgb(253,253,253)" class="">
<span style="font-variant-ligatures:no-common-ligatures" class=""><br class="">
</span></div>
<div style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(50,187,37);background-color:rgb(253,253,253)" class="">
<span style="font-variant-ligatures:no-common-ligatures" class="">So I need to move the mythtv.cnf to mariadb.conf.d because it would be last in the list so that would fix it. I’ll test that tomorrow.</span></div>
</div>
</div>
</blockquote>
<br class="">
</div>
</span>
<div class="">I got this fixed and tested, but I think it points out a potential “Bug” with the mythtv v29 installation. Here’s what I think needs to change.</div>
<div class=""><br class="">
</div>
<div class="">On install when the dialog about remote computers accessing mythtv backend is displayed and ‘Yes’ is chosen, the mythtv.cnf file needs to get created and placed in mariadb.conf.d instead of conf.d because mariadb.conf.d is searched last and since
the name mythtv.cnf is last alphabetically the bind-address statement will be the last one picked. SInce the 50-server.cnf file has a bind-address=127.0.0.1, the mythtv.cnf needs to override that bind-address by being set and not commented out. So “bind-address=::”</div>
<div class=""><br class="">
</div>
<div class="">That’s what I did and everything is working now.</div>
<div class=""><br class="">
</div>
<div class="">If the experts agree how does this get reported and fixed?</div>
<div class=""><br class="">
</div>
<div class="">Jim A</div>
<br class="">
</div>
</blockquote>
<div class=""><br class="">
</div>
<div class="">I know it seems like a pain, but it is part of the process. There are pros and cons on both sides, but I definitely do not want anything changing my database server settings. I would recommend just making a mental (or physical) note on it.
I can pretty much guarantee noone is going to change it. The mythbuntu distribution that Mashos maintained for so long was very nice that it did all of that for you, but unfortunately it is gone for good apparently.
<br class="">
</div>
<div class=""><br class="">
</div>
<div class="">No regular distribution (not 100% geared toward MythTV) would sanely change your settings like that.
<br class="">
</div>
</div>
</div>
</div>
</div>
</blockquote>
<div><br class="">
</div>
I understand what you say about mythbuntu being gone. But I didn’t use that I just started with a clean Ubuntu 16.04 Server install and then installed the v29 repository and then mythtv.</div>
<div><br class="">
</div>
<div>That process does ask if remote computers will be used. Since it creates the mythtv.cnf file in response to that, I think it needs to set in the last searched directory (mariadb.conf.d) and it needs to be bind-address=:: or 0.0.0.0</div>
<div><br class="">
</div>
<div>I’ll document all this for my own needs but I think it’s a bug. v0.28 when installed on Ubuntu Server didn’t have this problem.</div>
<div><br class="">
</div>
<div>Jim A</div>
<div><br class="">
</div>
<div>P.S. thanks to all those who helped.<br class="">
<blockquote type="cite" class="">
<div class="">_______________________________________________<br class="">
mythtv-users mailing list<br class="">
<a href="mailto:mythtv-users@mythtv.org" class="">mythtv-users@mythtv.org</a><br class="">
http://lists.mythtv.org/mailman/listinfo/mythtv-users<br class="">
http://wiki.mythtv.org/Mailing_List_etiquette<br class="">
MythTV Forums: https://forum.mythtv.org<br class="">
</div>
</blockquote>
</div>
<br class="">
</body>
</html>