<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 10:56 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" 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="">
On Mon, Jan 8, 2018 at 9:27 PM, Jim Abernathy<span class="Apple-converted-space"> </span><span dir="ltr" class=""><<a href="mailto:jfabernathy@outlook.com" target="_blank" class="">jfabernathy@outlook.com</a>></span><span class="Apple-converted-space"> </span>wrote:<br class="">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;">
<div style="word-wrap: break-word; line-break: after-white-space;" class=""><br class="">
<div class=""><span class=""><br class="">
<blockquote type="cite" class="">
<div class="">On Jan 8, 2018, at 10:13 PM, Bill Meek <<a href="mailto:keemllib@gmail.com" target="_blank" class="">keemllib@gmail.com</a>> wrote:</div>
<br class="m_3673644970117524579Apple-interchange-newline">
<div class="">
<div class="">On 01/08/2018 09:05 PM, Jim Abernathy wrote:<br class="">
<blockquote type="cite" class="">I trimmed most of the previous text.<br class="">
I went to<span class="Apple-converted-space"> </span><a href="http://mariadb.com/" target="_blank" class="">mariadb.com</a><<a href="http://mariadb.com/" target="_blank" class="">http://mariadb.com</a><wbr class="">> and looked into Configuring for remote
Client access. They say:<br class="">
* MariaDB is bound to the loopback interface by default because it makes it impossible to connect to the TCP port on the server from a remote host (the bind-address must refer to a local IP address, or you will receive a fatal error and MariaDB will not
start). This of course is not desirable if you want to use the TCP port from a remote host, so you must remove this bind-address directive (MariaDB only supports one bind-address, but binds to 0.0.0.0, or :: (every IP) if the bind-address directive is left
out).<br class="">
This tells me that either of these 2 statements are the same:<br class="">
bind-address=::<br class="">
#bind-address=::<br class="">
So not sure why it didn’t work after mythtv install because they set it to the 2nd statement.<br class="">
</blockquote>
<br class="">
Because it is set in another file (follow the includedirs in the previous post.)<br class="">
<br class="">
Or, do this: grep -r bind-address /etc/mysql and, at least on my box,<br class="">
there are two other instances setting it to the 127.... address. These<br class="">
files are parsed before mythtv.cnf.<br class="">
<br class="">
--<span class="Apple-converted-space"> </span><br class="">
Bill<br class="">
</div>
</div>
</blockquote>
<div class=""><br class="">
</div>
</span>I think I see the problem:</div>
<div 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_3673644970117524579Apple-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>
<span class=""></span><br class="">
</div>
</div>
</blockquote>
</div>
</div>
<div class="gmail_extra">No, just remove the hash mark from the beginning of the line in mythtv.conf and it should work.<br class="">
</div>
</div>
</div>
</blockquote>
<div><br class="">
</div>
That didn’t work since removing it didn’t override the 50-server.cnf bind-address statement. Moving it to mariadb.conf.d and making it bind-address=:: or bind-address=0.0.0.0 will work. It’s just in the wrong directory for the way mysql (mariadb) search.</div>
<div><br class="">
</div>
<div>Jim A</div>
<div><br class="">
<blockquote type="cite" class="">
<div class=""><span 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; float: none; display: inline !important;" class="">_______________________________________________</span><br 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="">
<span 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; float: none; display: inline !important;" class="">mythtv-users
mailing list</span><br 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="">
<a href="mailto:mythtv-users@mythtv.org" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">mythtv-users@mythtv.org</a><br 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="">
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br 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="">
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://wiki.mythtv.org/Mailing_List_etiquette</a><br 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="">
<span 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; float: none; display: inline !important;" class="">MythTV
Forums:<span class="Apple-converted-space"> </span></span><a href="https://forum.mythtv.org/" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">https://forum.mythtv.org</a></div>
</blockquote>
</div>
<br class="">
</body>
</html>