fixes/31 mythweb on Xubuntu 20.04 LTS Daily Build

[Mike Bibbings]

Built debs locally using mythtv/packaging/deb/ and installed mythtv.

Basics work, channel scanning (HD HomeRun Quattro) Live TV, Recordings.

mythweb does not work, something to do with mysql 8 in focal.

mythtv user has been created with default of caching_sha2_password

mysql> select host,user,plugin from user where user="mythtv";
+------+--------+-----------------------+
| host | user   | plugin                |
+------+--------+-----------------------+
| %    | mythtv | caching_sha2_password |
+------+--------+-----------------------+
1 row in set (0.00 sec)

Confirmed my suspicion by manually changing user mythtv in mysql

ALTER USER 'mythtv'@'%' IDENTIFIED WITH mysql_native_password BY 'password from /etc/mythtv/config.xml';

and rebooting, after which mythweb works.

I believe mc.sql (in mythtv) and mythtv-database.postinst need changing for mysql 8 to make sure mysql_native_password is used, alternatively fix mythweb so it works with caching_sha2_password or mysql_native_password (I have no idea on how to do this!).

Note: trac needs updating to allow Version v31-fixes to be selected.

Mike

[Bill Meek <billmeek@…>]

In beb8a43e78/mythtv:

Error: Processor CommitTicketReference failed

GIT backend not available

[Bill Meek <billmeek@…>]

In 6d43d669d0/mythtv:

Error: Processor CommitTicketReference failed

GIT backend not available

[Bill Meek <billmeek@…>]

In 12706dac9/mythtv:

Error: Processor CommitTicketReference failed

GIT backend not available

[Bill Meek <billmeek@…>]

In a51f21ab23/mythtv:

Error: Processor CommitTicketReference failed

GIT backend not available