<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>
<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; -webkit-text-stroke-width: 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; -webkit-text-stroke-width: 0px;" class="">
<div class="" style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; background-color: rgb(253, 253, 253);">
<span class="" style="font-variant-ligatures: no-common-ligatures; color: rgb(50, 187, 37);"><b class="">jim@mythbuntu</b></span><span class="" style="font-variant-ligatures: no-common-ligatures;">:</span><span class="" style="font-variant-ligatures: no-common-ligatures; color: rgb(82, 47, 224);"><b class="">~</b></span><span class="" style="font-variant-ligatures: no-common-ligatures;">$
sudo grep -r bind-address /etc/mysql </span></div>
<div class="" style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; background-color: rgb(253, 253, 253);">
<span class="" style="font-variant-ligatures: no-common-ligatures;">/etc/mysql/mariadb.conf.d/50-server.cnf:bind-address<span class="Apple-tab-span" style="white-space: pre;">
</span>= 127.0.0.1</span></div>
<div class="" style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; background-color: rgb(253, 253, 253);">
<span class="" style="font-variant-ligatures: no-common-ligatures;">/etc/mysql/conf.d/mythtv.cnf:#bind-address=::</span></div>
<div class="" 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);">
<span class="" style="font-variant-ligatures: no-common-ligatures;"><b class="">jim@mythbuntu</b></span><span class="" style="font-variant-ligatures: no-common-ligatures;">:</span><span class="" style="font-variant-ligatures: no-common-ligatures; color: rgb(82, 47, 224);"><b class="">~</b></span><span class="" style="font-variant-ligatures: no-common-ligatures;">$ </span></div>
<div class="" 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);">
<span class="" style="font-variant-ligatures: no-common-ligatures;">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 class="" 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);">
<span class="" style="font-variant-ligatures: no-common-ligatures;"><br class="">
</span></div>
<div class="" 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);">
<span class="" style="font-variant-ligatures: no-common-ligatures;">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>
<div>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><br class="">
</div>
<div>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><br class="">
</div>
<div>That’s what I did and everything is working now.</div>
<div><br class="">
</div>
<div>If the experts agree how does this get reported and fixed?</div>
<div><br class="">
</div>
<div>Jim A</div>
<div><br class="">
</div>
<br class="">
</body>
</html>