<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Sat, Feb 8, 2025 at 11:38 AM James Abernathy <<a href="mailto:jfabernathy@gmail.com">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 Sat, Feb 8, 2025 at 2:31 PM Bill Meek <<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@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><span></span><br><br>On Saturday 08 February 2025 01:06:57 PM (-06:00), James Abernathy wrote:<br><br><blockquote style="margin:0px 0px 0.8ex;border-left:2px solid rgb(0,0,255);padding-left:1ex"><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Nov 28, 2024 at 4:22 AM Stephen Worthington <<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>> wrote:<br></div><blockquote class="gmail_quote" style="padding-left:1ex;border-left:1px solid rgb(204,204,204);margin:0px 0px 0px 0.8ex">On Wed, 27 Nov 2024 21:06:51 -0500, you wrote:<br>
<br>
>I'm trying to come up with a set of instructions to avoid all the<br>
>experimenting I did tonight to get a remote frontend to talk to a new<br>
>backend.<br>
><br>
>What works for me on my production backend I don't understand but it<br>
>works. Any new frontend just has to search for the backend on its<br>
>first run.<br>
><br>
>On my production backend I run mariadb for my 'mysql' databases. If I<br>
>look at the /etc/mysql directory I have 2 files of interest.<br>
><br>
>cat conf.d/mythtv.cnf<br>
>------------------------<br>
>[mysqld]<br>
>bind-address=::<br>
>max_connections=100<br>
><br>
>And<br>
> cat mariadb.conf.d/mythtv.cnf<br>
>---------------------------------<br>
>[mysqld]<br>
>bind-address=*<br>
>max_connections=100<br>
><br>
>My understanding is that the last bind-address=* found is the one that<br>
>is in effect.<br>
>So in /etc/mysql/mariadb.conf.d/<br>
><br>
>cat * | grep 'bind-address'<br>
>bind-address = 127.0.0.1<br>
>#bind-address = 0.0.0.0<br>
>bind-address=*<br>
><br>
>Can I assume that the only .cnf file that matters on a mariadb system<br>
>is the one in mariadb.conf.d directory?<br>
><br>
>Also it seems that you need to make sure the mythtv.cnf is the last<br>
>one with a bind-address statement determined by a normal search. I've<br>
>seen some name their file 80-mythtv.cnf to force it higher in the<br>
>search.<br>
><br>
>Also it appears that only bind-address=* works. I've had no luck with<br>
>bind-address=:: or bind-address=0.0.0.0.<br>
><br>
>Can any exports out there confirm any of this?<br>
><br>
>Jim A<br>
<br>
There is an order that the config files get loaded in, but I believe<br>
it differs between MySQL and MariaDB. And I have never seen any good<br>
documentation on what the order actually is. And it is documented<br>
somewhere that either the first or the last one read will be the one<br>
that is used, but I can never remember which. The only safe thing I<br>
can see to do is to comment out all instances of bind-address except<br>
the one I want it to use, so that is what I have always done.<br>
<br>
The bind-address settings of :: and 0.0.0.0 do work, but a few<br>
versions of MySQL and MariaDB ago, what they actually mean was<br>
redefined. So :: now means any IPv6 address, and 0.0.0.0 means any<br>
IPv4 address, and * means any IPv4 or IPv6 address. So it used to be<br>
that you used :: to get any IPv4 or IPv6 address, and now you need to<br>
use * instead.<br>
_______________________________________________<br></blockquote><div><br></div><div>This comment from Stephen back in November nailed it for my problem I brought up today. It didn't take the last bind-address but the first. I'm using mariadb and the solution of removing all bind-address statements except the one you want is the solution.</div><div><br></div><div>Thanks Stephen.</div><div><br></div><div>JIm A</div></div></div></blockquote><span><div><span><br></span></div><div><span>Jim,</span></div><div><span><br></span></div><div><span>Please post the output of this from the host that was failing:</span></div><div><span><br></span></div><div><span> sudo grep --recursive --extended-regexp "include|bind.address" /etc/mysql</span></div><div><span><br></span></div><div><span>I'm curious as I've never had to comment out everything else.</span></div><div><span><br></span></div>-- <br>Bill</span></div>_______________________________________________</blockquote><div><br></div><div><span style="font-family:monospace">sudo grep --recursive --extended-regexp "include|bind.address" /etc/mysql<br>/etc/mysql/mariadb.conf.d/60-galera.cnf:#bind-address = 0.0.0.0<br>/etc/mysql/mariadb.conf.d/50-server.cnf:#bind-address = 127.0.0.1<br>/etc/mysql/mariadb.conf.d/mythtv.cnf.original:#bind-address=::<br>/etc/mysql/mariadb.conf.d/mythtv.cnf:#bind-address=::<br>/etc/mysql/mariadb.conf.d/80-mythtv.cnf:bind-address = *<br>/etc/mysql/my.cnf.fallback:!includedir /etc/mysql/conf.d/<br>/etc/mysql/mariadb.cnf:!includedir /etc/mysql/conf.d/<br>/etc/mysql/mariadb.cnf:!includedir /etc/mysql/mariadb.conf.d/</span><br> </div><div>I commented out the entries:</div><div><br></div><div><span style="font-family:monospace">/etc/mysql/mariadb.conf.d/50-server.cnf:#bind-address = 127.0.0.1</span></div><div><span style="font-family:monospace">/etc/mysql/mariadb.conf.d/mythtv.cnf:#bind-address=::</span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:arial,sans-serif">So it must have picked up the 127.0.0.1 entry that was first before it was commented out instead of the last which was the one I wanted.</span></div><div><span style="font-family:monospace">/etc/mysql/mariadb.conf.d/80-mythtv.cnf:bind-address = *</span></div></div></div></blockquote><div><br></div><div><font face="monospace">Mine looks like this... but I might have deleted some bind-address lines entirely instead of commenting it out.. I knew I should have taken notes, sigh.</font></div><div><font face="monospace"><br></font></div><div><font face="monospace">root@mythtv2:/etc/mysql# grep -R bind *<br>mariadb.conf.d/60-galera.cnf:#bind-address = 0.0.0.0<br>mariadb.conf.d/50-server.cnf:bind-address = 0.0.0.0</font></div><div> <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 class="gmail_quote"><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:arial,sans-serif">Jim A</span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace"><br></span></div></div></div>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div></div>