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