Ubuntu 18 upgrade to 20: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(init) |
K (sql) |
||
| (7 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
== Upgrade == | == Upgrade == | ||
mount -o remount,rw,exec /tmp | <syntaxhighlight lang="bash">mount -o remount,rw,exec /tmp | ||
vgck --updatemetadata vg0 | vgck --updatemetadata vg0</syntaxhighlight> | ||
== Apache == | == Apache == | ||
<syntaxhighlight lang="apache"> | |||
/etc/apache2/apache2.conf | /etc/apache2/apache2.conf | ||
# Include the virtual host configurations: | # Include the virtual host configurations: | ||
Include sites-enabled/*.conf | Include sites-enabled/*.conf | ||
#Include sites-enabled/ | #Include sites-enabled/ | ||
</syntaxhighlight> | |||
== MySQL == | == MySQL == | ||
=== Installation === | === Installation === | ||
/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/ | datadir = /srv/mysql/datadir55/</syntaxhighlight> | ||
<syntaxhighlight lang="sql"> | |||
/etc/mysql/conf.d/mysqld.cnf | |||
----- | |||
41gg | |||
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/ | ||
[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 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.</syntaxhighlight> | |||
Solution: | Solution: | ||
ALTER TABLE tab ROW_FORMAT=DYNAMIC; | <syntaxhighlight lang="sql">ALTER TABLE tab ROW_FORMAT=DYNAMIC;</syntaxhighlight> | ||
=== Password === | === 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' | <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? | |||
<syntaxhighlight lang="bash"> | |||
horde | |||
libpam | |||
apt install libpam0g-dev</syntaxhighlight> | |||
== PHPMYADMIN == | |||
Warning: Der phpMyAdmin-Konfigurationsspeicher ist nicht vollständig konfiguriert, einige erweiterte Funktionen wurden deaktiviert. | |||
Lösung: | |||
<syntaxhighlight lang="bash"> | |||
cd /srv/www/mygretchen.de/htdocs/member/sql/sql | |||
mysqlpw | |||
mysql -u root -p < upgrade_tables_mysql_4_1_2+.sql | |||
.. | |||
</syntaxhighlight> | |||
<syntaxhighlight lang="php"> | |||
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'; | |||
</syntaxhighlight> | |||
== PHP-CACHE == | |||
As of PHP 8.0.0, apcu-bc is no longer supported. | |||
== AWSTATS == | |||
Verzeichnis existiert nicht. Welches? | |||
[[Kategorie:Linux]] | [[Kategorie:Linux]] | ||
[[Kategorie:Ubuntu]] | [[Kategorie:Ubuntu]] | ||
Aktuelle Version vom 23. April 2024, 03:34 Uhr
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/
/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';
PHP-CACHE
As of PHP 8.0.0, apcu-bc is no longer supported.
AWSTATS
Verzeichnis existiert nicht. Welches?