Ubuntu 18 upgrade to 20
Upgrade
mount -o remount,rw,exec /tmp vgck --updatemetadata vg0
Apache
/etc/apache2/apache2.conf
- Include the virtual host configurations:
Include sites-enabled/*.conf
- Include sites-enabled/
MySQL
Installation
/etc/apparmor.d/usr.sbin.mysqld - /srv/mysql/datadir55/ r, - /srv/mysql/datadir55/** rwk,
/etc/mysql/mysql.conf.d/mysqld.cnf datadir = /srv/mysql/datadir55/
Upgrade
https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/
[Warning] [MY-011825] [InnoDB] Cannot add field `favicon` in table `coaching_rander`.`o5bni_acymailing_mail` because after adding it, the row size is 8471 which is greater than maximum allowed size (8126) for a record on index leaf page.
Solution: ALTER TABLE tab ROW_FORMAT=DYNAMIC;
Password
[Warning] [MY-013360] [Server] Plugin mysql_native_password reported: mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'