*Erledigt*Paketverwaltung max_allowed_packet (Derzeit werden nur Pakete bis 16 MB akzeptiert).

Hilfe zu OTRS Problemen aller Art
Post Reply
captntano
Znuny newbie
Posts: 4
Joined: 18 May 2022, 09:09
Znuny Version: 6.0.43
Real Name: captnstabbn

*Erledigt*Paketverwaltung max_allowed_packet (Derzeit werden nur Pakete bis 16 MB akzeptiert).

Post by captntano »

Hey,
ich habe folgende Fehlermeldung in der Paketverwaltung.
Stellen Sie sicher, dass Ihre Datenbank Pakete über 64 MB akzeptiert (Derzeit werden nur Pakete bis 16 MB akzeptiert). Bitte passen Sie die Einstellung max_allowed_packet Ihrer Datenbank-Konfiguration an, um Fehler zu vermeiden.
Znuny LTS 6.0.43 mit MariaDB 10.5.15
Zuerst hatte ich die /etc/mysql/my.cnf angepasst.

Code: Select all

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 0. "/etc/mysql/my.cnf" symlinks to this file, reason why all the rest is read.
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# If you are new to MariaDB, check out https://mariadb.com/kb/en/basic-mariadb-articles/

#
# This group is read both by the client and the server
# use it for options that affect everything
#
[mysqld]
max_allowed_packet = 512M
query_cache_size = 64M
innodb_log_file_size = 256M
character-set-server = utf8
collation-server = utf8_unicode_ci
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[client-server]
# Port or socket location where to connect
# port = 3306
socket = /run/mysqld/mysqld.sock
# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/


Jedoch wurden keine änderungen übernommen.
Daher habe ich dann die /etc/mysql/mariadb.cnf angepasst

Code: Select all

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 0. "/etc/mysql/my.cnf" symlinks to this file, reason why all the rest is read.
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# If you are new to MariaDB, check out https://mariadb.com/kb/en/basic-mariadb-articles/

#
# This group is read both by the client and the server
# use it for options that affect everything
#
[mysqld]
max_allowed_packet = 512M
query_cache_size = 64M
innodb_log_file_size = 256M
character-set-server = utf8
collation-server = utf8_unicode_ci
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[client-server]
# Port or socket location where to connect
# port = 3306
socket = /run/mysqld/mysqld.sock
# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
hat auch nichts gebracht,
Selbst das set global max_allowed_packet erwirkt keinerlei veränderug. Der Wert bleibt gleich .
--------------------+----------+
| Variable_name | Value |
+--------------------+----------+
| max_allowed_packet | 16777216 |
+--------------------+----------+
1 row in set (0.002 sec)

*edit
Gelöst!!
es war ein chmod 644 /etc/mysql/my.cnf nötig
Post Reply