id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
13576	fixes/31 mythweb on Xubuntu 20.04 LTS Daily Build	Mike Bibbings	Bill Meek	"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

"	Bug Report - General	closed	minor	31.0	Plugin - MythWeb	v31-fixes	medium	fixed			0