[mythtv-users] remote frontend connect issues and solutions?
James Abernathy
jfabernathy at gmail.com
Sat May 16 11:33:19 UTC 2026
On Fri, May 15, 2026 at 11:21 PM Bill Meek <keemllib at gmail.com> wrote:
> On Friday 15 May 2026 07:27:57 PM (-05:00), James Abernathy wrote:
>
>
> > I encounter this issue every time I rebuild my remote backend which
> occurs about every 2 years. Today I installed Debian 13 XFCE4 on my
> backend and got it working locally in about 1 hour using Mythtv v36. But
> it took 2 more hours to get the other PCs in the house to talk to the
> remote backend. Here's what I found out.
> >
> >
> > It takes more than a correct bind-address statement the my mariadb cnf
> file.
> >
> >
> > At present Debian 13 works with mysql from 11.8.6-MariaDB. I used to
> just make sure that the bind-address= * statement that took affect was in
> the right file.
> >
> >
> > But that was not enough in May 2026. I used:
> > sudo grep --recursive bind-address /etc/mysql
> > to find any file with a bind-address statement and make sure they did
> not override the bind-address= * I needed.
> >
> >
> > But I also needed a file:
> > mariadb.conf.d/80-mythconverg.cnf
> >
> > [mysqld]
> > binlog-ignore-db = mythconverg
> >
> >
> > Once I added this new file and restarted mariadb.service my remote PCs
> could run mythfrontend.
> >
> >
> > I have no clue what this fixed it but it's working now. Luckily, 90%
> of
> my viewing of the remote backend is via Leanfront on a Google TV streaming
> device.
>
>
> Hey Jim,
>
> binlog-ignore-db had doesn't control binding in any way. Maybe the
> bind-address addition
> wasn't followed by a restart.
>
> --
> Bill
>
> Thanks, for the help, guys. I think I did a sudo systemctl restart
maraidb after every edit of a .cnf file on the debian backend using SSH.
but who knows at this point.
Since Kodi and Leanfront worked from the beginning and mythfrontend on the
actual backend I was pretty sure it was a .cnf config somewhere.
I deleted any line in any .cnf file that used bind-address even if it was
commented out. So now I only see:
sudo grep --recursive bind-address /etc/mysql
/etc/mysql/mariadb.conf.d/80-mythtv.cnf:bind-address = *
For this rebuild I built the mythtv-light and mythplugins-light on the
backend and used Ansible for the dependencies. I like to control how all
the other things that the PPA build does for Ubuntu users just the way I
want instead of undoing and redoing it to fit my needs.
For example, I like to delete the cron weekly backup and add a systemd
timer/service that runs daily at a specific time and includes checking,
optimization and backing up of the mythconverg database. I'm more of a
systemd fan. Never have understood cron. I never liked the System V Rel 4
init system even back in the 1980s when I saw in in ATT Unix.
So I understand and like systemd. I include 6 or 7 systemd units that make
sure I don't have any race conditions when I boot with different types of
tuner initializing. I even use systemd to run mythfilldatabase.
So as you can see, a real systemd fanboy :-)
Jim A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20260516/50e51726/attachment.htm>
More information about the mythtv-users
mailing list