Mailing List Archive: mythtv setup can't talk to mysql/mariadb after ubuntu 20.04 upgrade

mythtv setup can't talk to mysql/mariadb after ubuntu 20.04 upgrade

Oct 11, 2020, 8:14 AM

Post #1 of 4 (321 views)

Found a lot of stories of this:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)But the solutions mentioned didn't help.my /etc/mythtv/config.xml is not a symlink (apparently systemd can't find symlinks)
I verified the mysql passwords for the mythtv user are all the same in that config file, the ~mythtv/.mythtv/config.xml and ~/.mythtv/config.xml files
I verified that doing:
mysql -u mythtv mythconverg -p
and typing in the password in those files works fine.mysql -u mythtv -h 127.0.0.1 mythconverg
also works fine.
But mythsetup is always stuck on the above.
BTW, for anyone upgrading to Ubuntu 20.04, MariaDB will timeout on startup because Ubuntu's new AppArmor feature...follow the bug report tip here to fix that:
https://stackoverflow.com/questions/40997257/mysql-service-fails-to-start-hangs-up-timeout-ubuntu-mariadb

ken

Re: mythtv setup can't talk to mysql/mariadb after ubuntu 20.04 upgrade [ In reply to ]

kenkyee at yahoo

Oct 11, 2020, 10:02 AM

Post #2 of 4 (321 views)

Permalink

Finally did this:sudo dpkg-reconfigure mythtv-database
sudo dpkg-reconfigure mythtv-commonfromhttps://help.ubuntu.com/community/MythTV/Install/Troubleshooting

and also had to disable mysqld from AppArmor (setting it to complain didn't work).
And things seem back to normal except themes don't seem to get set properly in the 0.31 FrontEnd so it stays the default, but I can live with it :-)
So forewarned that AppArmor causes lots of fun in Ubuntu 20.04 :-(

Re: mythtv setup can't talk to mysql/mariadb after ubuntu 20.04 upgrade [ In reply to ]

stephen_agent at jsw

Oct 11, 2020, 7:34 PM

Post #3 of 4 (318 views)

Permalink

On Sun, 11 Oct 2020 17:02:13 +0000 (UTC), you wrote:

>Finally did this:sudo dpkg-reconfigure mythtv-database
>sudo dpkg-reconfigure mythtv-commonfromhttps://help.ubuntu.com/community/MythTV/Install/Troubleshooting
>
>and also had to disable mysqld from AppArmor (setting it to complain didn't work).
>And things seem back to normal except themes don't seem to get set properly in the 0.31 FrontEnd so it stays the default, but I can live with it :-)
>So forewarned that AppArmor causes lots of fun in Ubuntu 20.04 :-(

I have to say I am surprised at all the troubles you have been having
with Ubuntu 20.04. I installed Ubuntu 20.04 in a VirtualBox virtual
machine using network tuners when it first came out and it worked fine
without any of the problems you have encountered. I did have to
update my 18.04 LIRC fixup script for 20.04, as the LIRC install is
still broken, but that was the only major problem I can remember.
MariaDB worked just fine, and still does with all the updates that
have happened since then.

But there are probably quite a few things I just habitually do when
setting up a new MythTV system, so one or more of those may have
prevented the problems you had. I certainly did not have any AppArmor
problems though.
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org

Re: mythtv setup can't talk to mysql/mariadb after ubuntu 20.04 upgrade [ In reply to ]

jam at tigger

Oct 12, 2020, 2:52 AM

Post #4 of 4 (315 views)

Permalink

> On 12 Oct 2020, at 10:34 am, Stephen Worthington <stephen_agent@jsw.gen.nz> wrote:
>
>> Finally did this:sudo dpkg-reconfigure mythtv-database
>> sudo dpkg-reconfigure mythtv-commonfromhttps://help.ubuntu.com/community/MythTV/Install/Troubleshooting
>>
>> and also had to disable mysqld from AppArmor (setting it to complain didn't work).
>> And things seem back to normal except themes don't seem to get set properly in the 0.31 FrontEnd so it stays the default, but I can live with it :-)
>> So forewarned that AppArmor causes lots of fun in Ubuntu 20.04 :-(
>
> I have to say I am surprised at all the troubles you have been having
> with Ubuntu 20.04. I installed Ubuntu 20.04 in a VirtualBox virtual
> machine using network tuners when it first came out and it worked fine
> without any of the problems you have encountered. I did have to
> update my 18.04 LIRC fixup script for 20.04, as the LIRC install is
> still broken, but that was the only major problem I can remember.
> MariaDB worked just fine, and still does with all the updates that
> have happened since then.
>
> But there are probably quite a few things I just habitually do when
> setting up a new MythTV system, so one or more of those may have
> prevented the problems you had. I certainly did not have any AppArmor
> problems though.

But it depends on your hardware too,
I had a torrid time with audio being pegged to FSD (127) using various Gen 8, 9, 10 NUC but NOT on my gen 6.
(xubuntu, 20.04 but all from kde, gnome to lxde and lxqt)
I think its all to do with the intel-microsoft conspiracy to force users of new hardware (gen 8 + cpu) to use windows 10. Earlier windoze won’t run on later hw.
James

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org