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

[James]

> On 1 May 2022, at 6:58 pm, James Abernathy <jfabernathy at gmail.com> 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.

Jim in my journey I just installed (but I built from src) and all worked splendidly.
Backintime is IMHO the best backup tool out there. But (python woes) it does not work on 22.04.
I vaguely remember struggling to find the 
bind = 0.0.0.0. 
The easy test is from another machine 
$ mysql -u mythtv -pmythtv -h backend.machine mythconverg

IIRC I also needed to get the qt5mysql deb.

If you are using someone else's ppa then you are at their mercy.
Even ubuntu's repository is sus eg apt-get install backintime-qt and it does not work.

A few days back I posted an ansible xml that DOES work. Not sure of status a few days later. But building with ansible (I was playing with an ASUS 8 core ryzen: built in 1 min) is quick n easy. There is an mc.sql in the src and 
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-20-04 <https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-20-04>

Shows you all that gets mythweb working.

James
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220502/11d303e4/attachment.htm>