Ubuntu 18 upgrade to 20: Unterschied zwischen den Versionen

Aus crazylinux.de
Zur Navigation springen Zur Suche springen
K (ll)
K (fff)
 
(7 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
== Upgrade ==
== Upgrade ==
<source>mount -o remount,rw,exec  /tmp
<syntaxhighlight lang="bash">mount -o remount,rw,exec  /tmp
vgck  --updatemetadata  vg0</source>
vgck  --updatemetadata  vg0</syntaxhighlight>


== Apache ==
== systemd ==
<source>
systemd failing enable with "service is transient or generated". What's wrong with this configuration?
/etc/apache2/apache2.conf
<syntaxhighlight lang="bash">
# Include the virtual host configurations:
mv /run/systemd/generator.late/vboxadm-sa.service /etc/systemd/system
Include sites-enabled/*.conf
systemctl daemon-reload
#Include sites-enabled/
systemctl status vboxadm-sa.service
</source>
update-rc.d  vboxadm-sa enable
</syntaxhighlight>




== MySQL ==
== MySQL ==
=== Installation ===
=== Installation ===
<source>/etc/apparmor.d/usr.sbin.mysqld
<syntaxhighlight lang="ini">/etc/apparmor.d/usr.sbin.mysqld
-  /srv/mysql/datadir55/ r,
-  /srv/mysql/datadir55/ r,
-  /srv/mysql/datadir55/** rwk,
-  /srv/mysql/datadir55/** rwk,


/etc/mysql/mysql.conf.d/mysqld.cnf
/etc/mysql/mysql.conf.d/mysqld.cnf
datadir                = /srv/mysql/datadir55/</source>
datadir                = /srv/mysql/datadir55/</syntaxhighlight>


 
<syntaxhighlight lang="sql">
vi /etc/mysql/conf.d/mysqld.cnf
/etc/mysql/conf.d/mysqld.cnf
-----
-----
41gg
41gg
s#NO_AUTO_CREATE_USER,##
s#NO_AUTO_CREATE_USER,##</syntaxhighlight>


=== Upgrade ===
=== Upgrade ===
https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/
https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/


<source>
<syntaxhighlight lang="sql">
[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.</source>
[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.</syntaxhighlight>


Solution:
Solution:
<source>ALTER TABLE tab ROW_FORMAT=DYNAMIC;</source>
<syntaxhighlight lang="sql">ALTER TABLE tab ROW_FORMAT=DYNAMIC;</syntaxhighlight>


=== Password ===
=== Password ===
<source>[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'</source>
<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>
 
== Horde ==
needed?
 
<source>
horde
libpam
apt install libpam0g-dev</source>


== PHPMYADMIN ==
== PHPMYADMIN ==
Zeile 51: Zeile 44:


Lösung:
Lösung:
<source>
<syntaxhighlight lang="bash">
cd /srv/www/mygretchen.de/htdocs/member/sql/sql
cd /srv/www/mygretchen.de/htdocs/member/sql/sql
mysqlpw
mysqlpw
mysql -u root -p < upgrade_tables_mysql_4_1_2+.sql
mysql -u root -p < upgrade_tables_mysql_4_1_2+.sql
..
..
</syntaxhighlight>
<syntaxhighlight lang="php">
vi config.inc.php:
vi config.inc.php:


Zeile 66: Zeile 61:
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
</source>
</syntaxhighlight>
 
== 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/


[[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/

Abgerufen von „https://crazylinux.de/?title=Ubuntu_18_upgrade_to_20&oldid=4820“