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/

vi /etc/mysql/conf.d/mysqld.cnf

---

41gg s#NO_AUTO_CREATE_USER,##

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'

Horde

needed?

horde
libpam
apt install libpam0g-dev

PHPMYADMIN

Warning: Der phpMyAdmin-Konfigurationsspeicher ist nicht vollständig konfiguriert, einige erweiterte Funktionen wurden deaktiviert.

Lösung:

cd /srv/www/mygretchen.de/htdocs/member/sql/sql
mysqlpw
mysql -u root -p < upgrade_tables_mysql_4_1_2+.sql
..
vi config.inc.php:

/*
 * Tempdir
 */
$cfg['TempDir'] = '/tmp';

$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';