[mythtv-users] Help- mythtvbackend can't connect to database after upgrade to 22.04 LTS

[Stephen Worthington]

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