On Sun, May 1, 2022 at 7:13 AM Stephen Worthington <stephen_agent@jsw.gen.nz>
wrote:
> On Sun, 1 May 2022 06:58:34 -0400, you wrote:
>
> >I've been upgrading all my PCs to 22.04 LTS over the past week with
> success
> >and today I thought it was time to try my PC that runs
> >mythtv-backend.service. It now has issues with connecting to the database.
> >
> >Before I restore everything to a previous snapshot, I wanted to see if
> >there was an obvious fix. Here is the log (journalctl -u
> >mythtv-backiend -b) attached to this email.
>
> If you are using MariaDB you may have version 10.6 which has a nasty
> (and stupid) breaking change to how you configure its "bind-address"
> setting. It used to be that you set it to :: to get all IPv4 and all
> IPv6 interfaces, or to * to get only all IPv4 interfaces. Now using
> :: gives you only all IPv6 interfaces, and * gives you all IPv4 and
> all IPv6 interfaces. So if you have previously set it to :: to future
> proof yourself for IPv6, but are still connecting to the database
> using IPv4, you will now be unable to connect. So try changing it to
> *.
>
> See this thread on the MythTV developers list:
>
> https://lists.archive.carbon60.com/mythtv/dev/640444
>
>
Thanks, Stephen. I am running mariadb. That was it. I changed :: to * in
the mythtv.cnf file and it worked.
BTW, this was a real proof of concept for my switch to BTRFS on my PC with
mythtv-backend running on it.
While I was waiting for your answer, which came in less than 15 minutes. I
was able to execute 4 commands in the terminal and restore the complete
system to where it was at 6am this morning. The restore of snapshots is
instantaneous. Once rebooted I was back to normal.
When I got your answer. I reversed the 4 commands, made the change to
mythtv.cnf, and rebooted. Back to a working Kubuntu 22.04 LTS with Mythtv
v32.
Thanks again for all your help over the years.
Jim A