[mythtv-users] Mysql 8 status summary

[John]

Mysql 8 is the default in Ubuntu 19.10 and presumably in the upcoming LTS

Myth frontend and backend run without issues but there are problems with 
the following

1/Syntax change for grant statements

     GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY 
"password";

     Have to be done in two steps.

     CREATE USER 'mythtv'@'localhost' IDENTIFIED BY 'password';

     GRANT ALL ON mythconverg.* TO 'mythtv'@'localhost';

2/Mythweb

     is useable but shows the following error

      error string:  !!NoTrans: SQL Error: Column 'modified' cannot be 
null [#1048]!!
      filename: 
/usr/local/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
      error line:  98

3/The Android version of the frontend on Firestick 4K won't connect to 
the backend.

All the above issues are re-solved by swapping Mysql 8 for MariaDB 10.3

The process of removing MySQL and installing MariaDB is not for the 
faint hearted.

10 mins for somebody with experience took me several hours googling.

The main issue was that Mariadb wont start, it just times out on first 
startup. Its a known issue that AppArmor kills it.

Simply rebooting resolves that issue.

I had to completely purge out mysql and all its configuration files to 
get it to work then resetup and reload the database.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20191122/0b4021b6/attachment.htm>