<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:13 PM, Bill Meek <<a href="mailto:keemllib@gmail.com" class="">keemllib@gmail.com</a>> wrote:</div>
<br class="Apple-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 <a href="http://mariadb.com" class="">mariadb.com</a><<a href="http://mariadb.com" class="">http://mariadb.com</a>> 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="">
-- <br class="">
Bill<br class="">
</div>
</div>
</blockquote>
<div><br class="">
</div>
I think I see the problem:</div>
<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; color: #32bb25" 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: #522fe0" 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-server.cnf:bind-address<span class="Apple-tab-span" style="white-space:pre">
</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:#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; color: #000000" class="">:</span><span style="font-variant-ligatures: no-common-ligatures; color: #522fe0" class=""><b class="">~</b></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000" 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; color: #000000" 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; color: #000000" 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; color: #000000" 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 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; color: #000000" class=""><br class="">
</span></div>
<blockquote type="cite" class="">
<div 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>
</div>
</blockquote>
</div>
<br class="">
</body>
</html>