[mythtv-users] mythtv.cnf file setup for remote frontends

[Stephen Worthington]

On Wed, 27 Nov 2024 21:06:51 -0500, you wrote:

>I'm trying to come up with a set of instructions to avoid all the
>experimenting I did tonight to get a remote frontend to talk to a new
>backend.
>
>What works for me on my production backend I don't understand but it
>works.  Any new frontend just has to search for the backend on its
>first run.
>
>On my production backend I run mariadb for my 'mysql' databases. If I
>look at the /etc/mysql directory I have 2 files of interest.
>
>cat conf.d/mythtv.cnf
>------------------------
>[mysqld]
>bind-address=::
>max_connections=100
>
>And
> cat mariadb.conf.d/mythtv.cnf
>---------------------------------
>[mysqld]
>bind-address=*
>max_connections=100
>
>My understanding is that the last bind-address=* found is the one that
>is in effect.
>So in /etc/mysql/mariadb.conf.d/
>
>cat * | grep 'bind-address'
>bind-address            = 127.0.0.1
>#bind-address = 0.0.0.0
>bind-address=*
>
>Can I assume that the only .cnf file that matters on a mariadb system
>is the one in mariadb.conf.d directory?
>
>Also it seems that you need to make sure the mythtv.cnf is the last
>one with a bind-address statement determined by a normal search. I've
>seen some name their file 80-mythtv.cnf to force it higher in the
>search.
>
>Also it appears that only bind-address=* works. I've had no luck with
>bind-address=:: or bind-address=0.0.0.0.
>
>Can any exports out there confirm any of this?
>
>Jim A

There is an order that the config files get loaded in, but I believe
it differs between MySQL and MariaDB.  And I have never seen any good
documentation on what the order actually is.  And it is documented
somewhere that either the first or the last one read will be the one
that is used, but I can never remember which.  The only safe thing I
can see to do is to comment out all instances of bind-address except
the one I want it to use, so that is what I have always done.

The bind-address settings of :: and 0.0.0.0 do work, but a few
versions of MySQL and MariaDB ago, what they actually mean was
redefined.  So :: now means any IPv6 address, and 0.0.0.0 means any
IPv4 address, and * means any IPv4 or IPv6 address.  So it used to be
that you used :: to get any IPv4 or IPv6 address, and now you need to
use * instead.