Ubuntu 18 upgrade to 20: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K (sql) |
K (fff) |
||
Zeile 3: | Zeile 3: | ||
vgck --updatemetadata vg0</syntaxhighlight> | vgck --updatemetadata vg0</syntaxhighlight> | ||
== | == systemd == | ||
<syntaxhighlight lang=" | systemd failing enable with "service is transient or generated". What's wrong with this configuration? | ||
/etc/ | <syntaxhighlight lang="bash"> | ||
mv /run/systemd/generator.late/vboxadm-sa.service /etc/systemd/system | |||
systemctl daemon-reload | |||
systemctl status vboxadm-sa.service | |||
update-rc.d vboxadm-sa enable | |||
</syntaxhighlight> | </syntaxhighlight> | ||
Zeile 38: | Zeile 39: | ||
=== Password === | === Password === | ||
<syntaxhighlight lang="sql">[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'</syntaxhighlight> | <syntaxhighlight lang="sql">[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'</syntaxhighlight> | ||
== PHPMYADMIN == | == PHPMYADMIN == | ||
Zeile 73: | Zeile 66: | ||
As of PHP 8.0.0, apcu-bc is no longer supported. | As of PHP 8.0.0, apcu-bc is no longer supported. | ||
== dovecot == | |||
== | see https://doc.dovecot.org/2.3/installation_guide/upgrading/from-2.2-to-2.3/ | ||
[[Kategorie:Linux]] | [[Kategorie:Linux]] | ||
[[Kategorie:Ubuntu]] | [[Kategorie:Ubuntu]] |
Aktuelle Version vom 13. September 2024, 12:27 Uhr
Upgrade
mount -o remount,rw,exec /tmp
vgck --updatemetadata vg0
systemd
systemd failing enable with "service is transient or generated". What's wrong with this configuration?
mv /run/systemd/generator.late/vboxadm-sa.service /etc/systemd/system
systemctl daemon-reload
systemctl status vboxadm-sa.service
update-rc.d vboxadm-sa enable
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/
/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'
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';
PHP-CACHE
As of PHP 8.0.0, apcu-bc is no longer supported.
dovecot
see https://doc.dovecot.org/2.3/installation_guide/upgrading/from-2.2-to-2.3/