Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
server:zabbix [2021/10/16 09:10] – [Händische Installation] st | server:zabbix [2023/03/06 20:04] (aktuell) – [Signal] st | ||
---|---|---|---|
Zeile 232: | Zeile 232: | ||
Am Ende der Installation ist der Login mit " | Am Ende der Installation ist der Login mit " | ||
- | ===== Server und Datenbank | + | ===== Datenbank ===== |
+ | |||
+ | **Größe der Datenbank** " | ||
+ | **Größe der zabbix Tabellen**: <code sql> | ||
+ | SELECT | ||
+ | TABLE_NAME AS `Table`, | ||
+ | ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)` | ||
+ | FROM | ||
+ | information_schema.TABLES | ||
+ | WHERE | ||
+ | TABLE_SCHEMA = " | ||
+ | ORDER BY | ||
+ | (DATA_LENGTH + INDEX_LENGTH) | ||
+ | DESC; | ||
+ | </ | ||
+ | |||
+ | ==== housekeeping ==== | ||
+ | |||
+ | Seit Zabbix 6.0 kann das audit log größer werden (u.a. werden discovery-aktionen von Benutzer SYSTEM geloggt): | ||
+ | * Administration -> General -> Audit log ( https:// | ||
+ | |||
+ | ==== housekeeping ==== | ||
+ | |||
+ | Administration -> General -> Housekeeping ( https:// | ||
+ | * Override item history period: 30, ... 90d ? | ||
+ | * ...? | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | manuelles clean-up der Datenbank (vorher BACKUP!): | ||
+ | <code sql> | ||
+ | -- intervals in days | ||
+ | SET @history_interval = 30; | ||
+ | SET @trends_interval = 90; | ||
+ | |||
+ | DELETE FROM alerts WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); | ||
+ | DELETE FROM acknowledges WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); | ||
+ | DELETE FROM events WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); | ||
+ | |||
+ | DELETE FROM history WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); | ||
+ | DELETE FROM history_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); | ||
+ | DELETE FROM history_str WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); | ||
+ | DELETE FROM history_text WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); | ||
+ | DELETE FROM history_log WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@history_interval * 24 * 60 * 60); | ||
+ | |||
+ | DELETE FROM trends WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60); | ||
+ | DELETE FROM trends_uint WHERE (UNIX_TIMESTAMP(NOW()) - clock) > (@trends_interval * 24 * 60 * 60); | ||
+ | </ | ||
+ | |||
+ | ===== Poller ausgelastet ===== | ||
Zabbix meldet wenn bestimmt Poller ausgelastet sind (viele Proxies, viele System nicht erreichbar etc.) | Zabbix meldet wenn bestimmt Poller ausgelastet sind (viele Proxies, viele System nicht erreichbar etc.) | ||
Zeile 300: | Zeile 350: | ||
<code bash> | <code bash> | ||
- | apt-get install libunixsocket-java default-jre --no-install-recommends | + | # noch nötig? |
- | wget https://github.com/ | + | # apt install libunixsocket-java default-jre --no-install-recommends |
- | wget https:// | + | # auf aktuelle Version ändern: |
- | tar xfv signal-cli-0.7.4.tar.gz -C /opt | + | export VERSION=0.11.7 |
- | + | wget https:// | |
- | ln -sf / | + | sudo tar xf signal-cli-" |
+ | sudo ln -sf / | ||
# (besser in / | # (besser in / | ||
Zeile 312: | Zeile 363: | ||
< | < | ||
- | zabbix | + | zabbix |
</ | </ | ||
Zeile 705: | Zeile 756: | ||
* wenn userparameter-Dateien in / | * wenn userparameter-Dateien in / | ||
+ | ==== DB upgrade failed (no SUPER privilege or log_bin_trust_function_creators) ==== | ||
+ | |||
+ | Fehler bei upgrade auf 6.0.11: | ||
+ | < | ||
+ | [Z3005] query failed: [1419] You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) [create trigger hosts_name_upper_insert | ||
+ | before insert on hosts for each row | ||
+ | set new.name_upper=upper(new.name)] | ||
+ | $timestamp database upgrade failed | ||
+ | </ | ||
+ | |||
+ | Lösung: [[https:// | ||
+ | |||
+ | temporär: | ||
+ | <code sql> | ||
+ | set global log_bin_trust_function_creators=1; | ||
+ | </ | ||
+ | |||
+ | permanent: ''/ | ||
+ | < | ||
+ | log_bin_trust_function_creators = 1 | ||
+ | </ | ||
+ | |||
+ | Super-privilegien sind vermutlich nicht nötig: | ||
+ | <code sql> | ||
+ | SELECT Host, | ||
+ | UPDATE mysql.user SET Super_Priv=' | ||
+ | </ | ||
===== Homeverzeichnis des agents fixen ===== | ===== Homeverzeichnis des agents fixen ===== | ||