Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung Nächste ÜberarbeitungBeide Seiten der Revision | ||
server:zabbix [2020/06/29 19:52] – [Begriffe] st | server:zabbix [2021/10/16 10:00] – [Server und Datenbank tuning] st | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
+ | ====== Zabbix ====== | ||
+ | |||
+ | Zabbix ist ein Monitoringsystem das auf Agents basiert. Besonders die von Haus aus enthaltenen Graphen und Templates mit Autodiscovery von z.B. mountpoints sind von Vorteil. | ||
+ | |||
+ | |||
+ | ===== Links ===== | ||
+ | |||
+ | * [[http:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | ===== Begriffe ===== | ||
+ | |||
+ | Komponenten: | ||
+ | * agent / agent2 | ||
+ | * server | ||
+ | * webinterface | ||
+ | |||
+ | Begriffe: | ||
+ | * items | ||
+ | * trigger | ||
+ | * key | ||
+ | * application | ||
+ | |||
+ | **Menustruktur der Weboberfläche**: | ||
+ | * Monitoring | ||
+ | * Dashboard | ||
+ | * Problems | ||
+ | * Hosts | ||
+ | * Overview | ||
+ | * Latest data | ||
+ | * Screens | ||
+ | * Maps | ||
+ | * Discovery | ||
+ | * Services | ||
+ | * Inventory | ||
+ | * Overview | ||
+ | * Hosts | ||
+ | * Reports | ||
+ | * System information | ||
+ | * Triggers top 100 | ||
+ | * Audit | ||
+ | * Actions Log | ||
+ | * Notifications | ||
+ | * Configuration | ||
+ | * Host groups | ||
+ | * Templates | ||
+ | * Hosts | ||
+ | * Maintenance (periods) | ||
+ | * [[https:// | ||
+ | * Event Correlation | ||
+ | * Discovery (rules) | ||
+ | * Services | ||
+ | * Administration | ||
+ | * General | ||
+ | * Proxies | ||
+ | * Authentication (Internes Verzeichnis, | ||
+ | * User groups | ||
+ | * User | ||
+ | * Media types | ||
+ | * Scripts | ||
+ | * Queue (overview) | ||
+ | * Support | ||
+ | * Share | ||
+ | * Help | ||
+ | * User settings | ||
+ | * Sign out | ||
+ | |||
+ | ===== IPv6 ===== | ||
+ | |||
+ | Zabbix unterstützt IPv6. Wenn die Verbindungen mit DNS-Namen benutzt werden brauch nichts weiter eingestellt werden. | ||
+ | |||
+ | Zu Beachten im Dualstack-Betrieb: | ||
+ | * wenn ListenIP angegeben ist werden nur die angegebenen IPs gebunden. 0.0.0.0 heißt IPv4 only! Die Direktive kann entfernt werden. | ||
+ | * checks werden dann nur auf v6 gemacht (v4 only-Adressen weiterhin geprüft). Eine mögliche Lösung wäre macros auf dem Host (z.B {$IPV4} und {$IPV6} ) und diese statt | ||
+ | ====== Installation ====== | ||
+ | |||
+ | ===== Ansible ===== | ||
+ | |||
+ | Für die Installation kann auf Automatisierung zurückgegriffen werden: | ||
+ | * [[https:// | ||
+ | |||
+ | bis dato ((11.07.2020)) unterstützt die collection noch keine Version 5.0, dies scheint jedoch eine triviale Anpassung zu sein: | ||
+ | * Datei '' | ||
+ | |||
+ | **Ansible Rollen** (keine Weiterentwicklung, | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | ===== Händische Installation ===== | ||
+ | |||
+ | Siehe Anleitung auf [[https:// | ||
+ | |||
+ | Für 32bit gibt es keine Pakete mehr: | ||
+ | < | ||
+ | deb-src [arch=amd64] http:// | ||
+ | deb [arch=amd64] http:// | ||
+ | </ | ||
+ | ===== puppet ===== | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | |||
+ | ===== Agent Installation ===== | ||
+ | |||
+ | <code bash> | ||
+ | apt install zabbix-agent | ||
+ | systemctl stop zabbix-agent.service | ||
+ | # check if still running: | ||
+ | lsof -i -n | grep zab | ||
+ | |||
+ | mv / | ||
+ | </ | ||
+ | |||
+ | Neue Config: / | ||
+ | < | ||
+ | # my Zabbix config | ||
+ | PidFile=/ | ||
+ | LogFile=/ | ||
+ | # size of Logfile in MB, Range: 0-1024; 0 means " | ||
+ | LogFileSize=10 | ||
+ | # Source IP address for outgoing connections | ||
+ | # SourceIP= | ||
+ | EnableRemoteCommands=1 | ||
+ | ListenPort=10050 | ||
+ | # Unique, case sensitive hostname. | ||
+ | # Required for active checks and must match hostname as configured on the server. | ||
+ | # Value is acquired from HostnameItem (default: HostnameItem=system.hostname) if undefined: | ||
+ | Hostname=MY.HOSTNAME.DOMAIN.TLD | ||
+ | Server=1.2.3.4/ | ||
+ | ServerActive=1.2.3.4/ | ||
+ | Include=/ | ||
+ | </ | ||
+ | |||
+ | <code bash> | ||
+ | systemctl enable zabbix-agent.service</ | ||
+ | |||
+ | |||
+ | ==== agent2 ==== | ||
+ | |||
+ | Der zabbix-agent2: | ||
+ | * ist in go geschrieben (statt C) | ||
+ | * hat mehr [[https:// | ||
+ | * siehe auch https:// | ||
+ | |||
+ | Es besteht keine upgradezwang, | ||
+ | |||
+ | |||
+ | ==== Windows ==== | ||
+ | |||
+ | - Konfiguration anpassen " | ||
+ | - Dienst einrichten (cmd.exe) -- hierbei beachten, daß die Bindestriche Unterstriche sein müssen (zabbix_agentd)C: | ||
+ | - Dienst starten: | ||
+ | - Server-Manager-> | ||
+ | - -> | ||
+ | |||
+ | |||
+ | ===== Firewall ===== | ||
+ | |||
+ | Unter CentOS ist standardmäßig die Firewall aktiv, folgende Ports/ | ||
+ | < | ||
+ | # server/ | ||
+ | firewall-cmd --zone=public --add-port=80/ | ||
+ | firewall-cmd --zone=public --add-port=443/ | ||
+ | # server/ | ||
+ | firewall-cmd --zone=public --add-port=10051/ | ||
+ | # agent: | ||
+ | firewall-cmd --zone=public --add-port=10050/ | ||
+ | firewall-cmd --reload | ||
+ | </ | ||
+ | |||
+ | ==== Probleme mit selinux ==== | ||
+ | |||
+ | Wenn keine Verbindung zum Server zustande kommt kann auch selinux das " | ||
+ | |||
+ | Status prüfen: '' | ||
+ | |||
+ | Im enforcing-modus fehlen u.U. Fähigkeiten: | ||
+ | |||
+ | '' | ||
+ | Ausgabe: | ||
+ | < | ||
+ | httpd_can_connect_zabbix --> off | ||
+ | zabbix_can_network --> off | ||
+ | </ | ||
+ | ...auf on setzen: | ||
+ | '' | ||
+ | setsebool -P zabbix_can_network on'' | ||
+ | |||
+ | |||
+ | |||
+ | ===== Befehle per sudo erlauben ===== | ||
+ | |||
+ | Alle Befehle ohne Passwort erlauben (nicht empfohlen): | ||
+ | < | ||
+ | |||
+ | Ausgewählte Befehle erlauben: | ||
+ | < | ||
+ | |||
+ | |||
+ | ====== Konfiguration ====== | ||
+ | |||
+ | PHP-Konfiguration_ | ||
+ | |||
+ | < | ||
+ | date.timezone = Europe/ | ||
+ | max_execution_time = 300 | ||
+ | </ | ||
+ | |||
+ | Der Installationsassistent findet sich unter '' | ||
+ | |||
+ | |||
+ | Konfigurationsdatei (''/ | ||
+ | |||
+ | <code php> | ||
+ | <?php | ||
+ | global $DB_TYPE, $DB_SERVER, $DB_PORT, $DB_DATABASE, | ||
+ | |||
+ | $DB_TYPE = " | ||
+ | $DB_SERVER = " | ||
+ | $DB_PORT = " | ||
+ | $DB_DATABASE = " | ||
+ | $DB_USER = " | ||
+ | $DB_PASSWORD = " | ||
+ | |||
+ | $IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG; | ||
+ | ?> | ||
+ | </ | ||
+ | |||
+ | Am Ende der Installation ist der Login mit " | ||
+ | |||
+ | ===== Server und Datenbank tuning ===== | ||
+ | |||
+ | Größe der Datenbank: <code sql> SELECT table_schema " | ||
+ | |||
+ | Zabbix meldet wenn bestimmt Poller ausgelastet sind (viele Proxies, viele System nicht erreichbar etc.) | ||
+ | |||
+ | < | ||
+ | StartPollers=100 | ||
+ | # für passive proxies: | ||
+ | StartProxyPollers=5 | ||
+ | StartHTTPPollers=5 | ||
+ | </ | ||
+ | |||
+ | Anschließend könnte mysql in Bedrängnis geraten weil Zabbix zu viele Datenbankverbindungen anfordert (in der'' | ||
+ | < | ||
+ | max_connections = 500</ | ||
+ | |||
+ | ===== Benachrichtigungen ===== | ||
+ | |||
+ | ==== E-Mail ==== | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | ==== Telegram ==== | ||
+ | |||
+ | https:// | ||
+ | |||
+ | Es wird benutzt: | ||
+ | * [[https:// | ||
+ | * ein Telegram_bot | ||
+ | * [[https:// | ||
+ | |||
+ | Vorgehensweise: | ||
+ | - Bot bei Telegram anlegen | ||
+ | - dazu im Client mit BotFather eine neue Konversation starten, der Befehl ist: /newbot | ||
+ | - es führt ein Assistent durch die Einrichtung: | ||
+ | - ...und bekommt am Ende einen token für die HTTP API (z.B. 124226418: | ||
+ | - Skript ablegen in / | ||
+ | # to must be $chat_id or " | ||
+ | to=$1 | ||
+ | subject=$2 | ||
+ | body=$3 | ||
+ | |||
+ | botID=" | ||
+ | |||
+ | curl -X POST --retry 5 --retry-delay 0 --retry-max-time 60 --data-urlencode " | ||
+ | if [ $? -ne 0 ]; then | ||
+ | exit 1 | ||
+ | fi | ||
+ | </ | ||
+ | - Im Monitoring-System: | ||
+ | - Name: Telegram | ||
+ | - Type: Skript | ||
+ | - Script name: $Dateiname (ohne Pfad!) | ||
+ | - Script parameters: | ||
+ | - {ALERT.SENDTO} | ||
+ | - {ALERT.SUBJECT} | ||
+ | - {ALERT.MESSAGE} | ||
+ | - Options entsprechend ausfüllen | ||
+ | - Im Monitoring-System: | ||
+ | - Type: Telegram | ||
+ | - Send to: $Benutzername (aus Telegram) oder die $ChatID | ||
+ | |||
+ | |||
+ | ==== Signal ==== | ||
+ | |||
+ | * https:// | ||
+ | * https:// | ||
+ | |||
+ | <code bash> | ||
+ | apt-get install libunixsocket-java default-jre --no-install-recommends | ||
+ | wget https:// | ||
+ | wget https:// | ||
+ | tar xfv signal-cli-0.7.4.tar.gz -C /opt | ||
+ | |||
+ | ln -sf / | ||
+ | |||
+ | # (besser in / | ||
+ | nano / | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | zabbix | ||
+ | </ | ||
+ | |||
+ | <code bash> | ||
+ | cd / | ||
+ | |||
+ | # Absender: 4930123456 | ||
+ | # Empfänger: 4930987654321 | ||
+ | |||
+ | # ohne --voice wird eine sms geschickt: | ||
+ | sudo -u zabbix signal-cli -u +4930123456 register --voice | ||
+ | # Verifzierungscode: | ||
+ | sudo -u zabbix signal-cli -u +4930123456 verify 123-456 | ||
+ | sudo -u zabbix signal-cli -u +4930123456 send -m "Hello this is test message " +4930987654321 | ||
+ | </ | ||
+ | |||
+ | grep -i AlertScriptsPath / | ||
+ | # AlertScriptsPath=/ | ||
+ | |||
+ | nano / | ||
+ | |||
+ | <code bash> | ||
+ | #!/bin/bash | ||
+ | PATH="/ | ||
+ | |||
+ | number=" | ||
+ | |||
+ | sanitize() { | ||
+ | echo " | ||
+ | } | ||
+ | |||
+ | # This is for shamsi date with Jcal you can replace jdate with date | ||
+ | DATE_EXEC=" | ||
+ | |||
+ | A=$(sanitize " | ||
+ | B=$(sanitize " | ||
+ | C=$(sanitize " | ||
+ | |||
+ | TEXT=" | ||
+ | $B | ||
+ | Sent: $DATE_EXEC" | ||
+ | |||
+ | echo " | ||
+ | if [ " | ||
+ | echo " | ||
+ | exit | ||
+ | fi | ||
+ | |||
+ | echo " | ||
+ | |||
+ | echo " | ||
+ | </ | ||
+ | |||
+ | chmod +x / | ||
+ | ===== Lokalisation ===== | ||
+ | |||
+ | Welche Lokales angezeigt werden legt einseits der [[https:// | ||
+ | |||
+ | ''/ | ||
+ | < | ||
+ | function getLocales() { | ||
+ | return [ | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ]; | ||
+ | } | ||
+ | </ | ||
+ | |||
+ | ...aber auch die Lokales die im System vorhanden sind. Bei Debian/ | ||
+ | |||
+ | ===== Verschlüsselung zum Agent (PSK) ===== | ||
+ | |||
+ | Möchte man keine CA für die Absicherung der Kommunikation zwischen Server und dem Agent einsetzen, so sind alternativ pre-shared keys (PSK) möglich. | ||
+ | Siehe auch: [[https:// | ||
+ | |||
+ | <code bash> | ||
+ | # 32Byte / 256 Bit-Zufallszeichenkette erzeugen: | ||
+ | openssl rand -hex 32 > / | ||
+ | chmod 600 / | ||
+ | chown zabbix.zabbix / | ||
+ | </ | ||
+ | Den Inhalt von / | ||
+ | |||
+ | ''/ | ||
+ | < | ||
+ | TLSConnect=psk | ||
+ | TLSAccept=psk | ||
+ | TLSPSKFile=/ | ||
+ | TLSPSKIdentity=$SERVERNAME_oder_anderer_String | ||
+ | </ | ||
+ | |||
+ | <code bash> | ||
+ | |||
+ | <box 100% red round left > Noch eine letzte **Warnung zu duplizierten Identitäten**: | ||
+ | |||
+ | Die Ansible-Rolle aus den collections hat eine Funktion ((zabbix_agent_tlspsk_auto: | ||
+ | </ | ||
+ | ===== Verbindung zum Agent testen ===== | ||
+ | |||
+ | <code bash> | ||
+ | |||
+ | ===== Rückgabewerte testen ===== | ||
+ | |||
+ | |||
+ | Beispiel: key " | ||
+ | <code bash>su -c ' | ||
+ | ===== E-Mail-Einstellungen (Server ausgehend) ===== | ||
+ | |||
+ | 2DO: | ||
+ | |||
+ | https:// | ||
+ | |||
+ | |||
+ | ====== Templates ====== | ||
+ | |||
+ | [[https:// | ||
+ | ===== Template OS Linux ===== | ||
+ | |||
+ | Anpassungen: | ||
+ | |||
+ | Es gibt System die haben keinen Swap-Speicher, | ||
+ | Ich möchte diesen Trigger nur sehen wenn Swap da ist: | ||
+ | |||
+ | '' | ||
+ | |||
+ | |||
+ | ====== Zabbix Upgrade ====== | ||
+ | |||
+ | |||
+ | ===== Änderungen von 5.2x auf 5.4x ===== | ||
+ | |||
+ | https:// | ||
+ | |||
+ | * Global value mapping has been removed | ||
+ | * | ||
+ | |||
+ | ===== Vorgehensweise ===== | ||
+ | |||
+ | - Die oben aufgeführte Paketquelle in / | ||
+ | - Pakete upgrade | ||
+ | - Anschließend muss der zabbix-server neu gestartet werden:< | ||
+ | - der Neustart triggert das Datenbank-upgrade (zu verfolgen in ''/ | ||
+ | | ||
+ | - [[https:// | ||
+ | - System-dashboard " | ||
+ | - Änderungen anwenden: https:// | ||
+ | MODIFY value_min DOUBLE PRECISION DEFAULT ' | ||
+ | MODIFY value_avg DOUBLE PRECISION DEFAULT ' | ||
+ | MODIFY value_max DOUBLE PRECISION DEFAULT ' | ||
+ | ALTER TABLE history MODIFY value DOUBLE PRECISION DEFAULT ' | ||
+ | - <code bash> | ||
+ | - Alt: <code sql> | ||
+ | - Neu: <code sql> | ||
+ | - <code bash> | ||
+ | // https:// | ||
+ | $DB[' | ||
+ | - das web interface von Version 5.0 brauch php 7.2, bei Debian Jessie ist aber nur 7.0 vorhanden. Entweder dist-upgrade oder deprecated-Paket holen http:// | ||
+ | |||
+ | ===== Datenbank Anpassung bei falschem Character-set oder Collation ===== | ||
+ | |||
+ | Fehler im serverlog: | ||
+ | < | ||
+ | |||
+ | <code sql> | ||
+ | |||
+ | Ergebnis: | ||
+ | < | ||
+ | SELECT DEFAULT_CHARACTER_SET_NAME, | ||
+ | +----------------------------+------------------------+ | ||
+ | | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | | ||
+ | +----------------------------+------------------------+ | ||
+ | | utf8 | utf8_bin | ||
+ | +----------------------------+------------------------+ | ||
+ | </ | ||
+ | |||
+ | Änderung wenn Tabellen nicht utf8 als Standard-Character-set haben oder Collation *nicht* utf8_bin ist: | ||
+ | |||
+ | Liste von Tabellen erstellen (mit mysql-Batchmode ausführen um den Rahmen wegzubekommen: | ||
+ | <code sql> | ||
+ | SELECT CONCAT(' | ||
+ | </ | ||
+ | Ergebnis: | ||
+ | <code sql> | ||
+ | ALTER TABLE zabbix.acknowledges CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.alerts CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.application_discovery CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.application_prototype CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.application_template CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.applications CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.auditlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.auditlog_details CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.autoreg_host CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.conditions CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.config CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.config_autoreg_tls CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.corr_condition CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.corr_condition_group CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.corr_condition_tag CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.corr_condition_tagpair CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.corr_condition_tagvalue CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.corr_operation CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.correlation CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.dashboard CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.dashboard_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.dashboard_usrgrp CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.dbversion CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.dchecks CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.dhosts CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.drules CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.dservices CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.escalations CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.event_recovery CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.event_suppress CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.event_tag CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.events CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.expressions CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.functions CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.globalmacro CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.globalvars CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.graph_discovery CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.graph_theme CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.graphs CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.graphs_items CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.group_discovery CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.group_prototype CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.history CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.history_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.history_str CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.history_text CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.history_uint CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.host_discovery CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.host_inventory CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.host_tag CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.hostmacro CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.hosts CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.hosts_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.hosts_templates CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.housekeeper CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.hstgrp CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.httpstep CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.httpstep_field CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.httpstepitem CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.httptest CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.httptest_field CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.httptestitem CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.icon_map CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.icon_mapping CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.ids CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.images CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.interface CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.interface_discovery CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.interface_snmp CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.item_application_prototype CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.item_condition CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.item_discovery CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.item_preproc CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.item_rtdata CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.items CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.items_applications CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_macro_path CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_condition CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_opdiscover CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_operation CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_ophistory CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_opinventory CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_opperiod CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_opseverity CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_opstatus CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_optag CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_optemplate CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.lld_override_optrends CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.maintenance_tag CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.maintenances CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.maintenances_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.maintenances_hosts CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.maintenances_windows CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.mappings CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.media CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.media_type CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.media_type_message CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.media_type_param CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.module CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.opcommand CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.opcommand_grp CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.opcommand_hst CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.opconditions CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.operations CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.opgroup CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.opinventory CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.opmessage CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.opmessage_grp CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.opmessage_usr CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.optemplate CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.problem CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.problem_tag CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.profiles CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.proxy_autoreg_host CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.proxy_dhistory CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.proxy_history CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.regexps CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.rights CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.screen_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.screen_usrgrp CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.screens CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.screens_items CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.scripts CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.service_alarms CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.services CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.services_links CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.services_times CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sessions CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.slides CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.slideshow_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.slideshow_usrgrp CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.slideshows CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sysmap_element_trigger CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sysmap_element_url CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sysmap_shape CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sysmap_url CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sysmap_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sysmap_usrgrp CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sysmaps CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sysmaps_elements CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sysmaps_link_triggers CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.sysmaps_links CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.tag_filter CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.task CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.task_acknowledge CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.task_check_now CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.task_close_problem CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.task_data CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.task_remote_command CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.task_remote_command_result CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.task_result CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.timeperiods CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.trends CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.trends_uint CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.trigger_depends CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.trigger_discovery CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.trigger_tag CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.triggers CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.users CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.users_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.usrgrp CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.valuemaps CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.widget CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | ALTER TABLE zabbix.widget_field CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; | ||
+ | </ | ||
+ | |||
+ | ====== Problembehebung ====== | ||
+ | |||
+ | **Verbindungsprobleme zum agent**: | ||
+ | * stimmt psk und secret überein? | ||
+ | * IP und/oder DNS-Namen in Zabbix aktuell? | ||
+ | |||
+ | **Startprobleme des agents**: | ||
+ | * Dateirechte ok? | ||
+ | * / | ||
+ | * wenn userparameter-Dateien in / | ||
+ | |||
+ | ===== Homeverzeichnis des agents fixen ===== | ||
+ | |||
+ | <code bash> | ||
+ | systemctl stop zabbix-agent | ||
+ | usermod -d / | ||
+ | systemctl start zabbix-agent | ||
+ | </ | ||
+ | |||
+ | mit ansible ad-hoc-Kommando (Gruppe // | ||
+ | <code bash> | ||
+ | ansible -i inventory -m shell -a " | ||
+ | ansible -i inventory -m shell -a " | ||
+ | ansible -i inventory -m shell -a " | ||
+ | </ | ||