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

[Bill Meek]

On Saturday 08 February 2025 01:37:10 PM (-06:00), James Abernathy wrote:

Snipped everything...


sudo grep --recursive --extended-regexp "include|bind.address" /etc/mysql

Search path:
   /etc/mysql/mariadb.cnf:!includedir /etc/mysql/conf.d/
   /etc/mysql/mariadb.cnf:!includedir /etc/mysql/mariadb.conf.d/ <<--- 
searched last

I removed the # from these files to match the original issue:
   /etc/mysql/mariadb.conf.d/50-server.cnf
   /etc/mysql/mariadb.conf.d/mythtv.cnf

Removed this as it's not a .cnf file:
   /etc/mysql/mariadb.conf.d/mythtv.cnf.original:#bind-address=:: (not a 
.cnf file)

The files are parsed in lexical order (and that means numbers before 
letters).
So the search would look like this:

   /etc/mysql/mariadb.conf.d/50-server.cnf:bind-address            = 
127.0.0.1
   /etc/mysql/mariadb.conf.d/60-galera.cnf:#bind-address = 0.0.0.0
   /etc/mysql/mariadb.conf.d/80-mythtv.cnf:bind-address = *
   /etc/mysql/mariadb.conf.d/mythtv.cnf:bind-address=:: 
<---------------------

Per: https://mariadb.com/kb/en/server-system-variables/#bind_address, 
MariaDB
v10.6 and above:

     :: means listen on all IPv6 addresses
     *  means both IPv4 and IPv6.
  
I'm guessing you don't connect to your DB server via IPv6. Therefore the 
above
failed.

Per: 
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_bind_address

MySQL v8.0 and .4,

     :: and * accept IPv4 and IPv6 addresses.

See the links for more detail.

mythtv.cnf comes from the *buntu distribution. 80-mythtv.cnf is the more 
correct filename.
MythTV packaging should be switched to the 2nd name. I don't know if that 
would remove
the 1st. 

-- 
Bill