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

[Paul Harrison]

On 01/05/2022 12:12, Stephen Worthington 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


Don't know why no one every recommends it but you can use an actual IP 
address for the bind-address so the db server will only listen on that 
one IP address. My servers all use static IP's so that's what I've done 
for 15 years or more now and never had a problem like this.


Paul H.