{"batchcomplete":"","continue":{"lecontinue":"20230309091819|38","continue":"-||"},"query":{"logevents":[{"logid":48,"ns":0,"title":"Monitorov\u00e1n\u00ed Dockeru pomoc\u00ed Zabbixe","pageid":32,"logpage":32,"params":{},"type":"create","action":"create","user":"Admin","timestamp":"2023-03-10T12:41:30Z","comment":"zalo\u017eena nov\u00e1 str\u00e1nka s textem \u201eC\u00edlem je monitorovat stav dockeru a kontejner\u016f pomoc\u00ed zabbixe.  Prvn\u00edm krokem je nahr\u00e1t \u0161ablonu, kter\u00e1 je klasicky pro agenta2 do frontendu Zabbixe.  D\u00e1le je pot\u0159eba p\u0159idat u\u017eivatele zabbix do skupiny docker, jinak hl\u00e1si chyby a monitoring nefunguje:  [Docker] cannot fetch data: Get <nowiki>http://1.28/info</nowiki>: dial unix /var/run/docker.sock: connect: permission denied   ZBX_NOTSUPPORTED: Cannot fetch data. T\u00edmto p\u0159\u00edkazem p\u0159id\u00e1m\u2026\u201c"},{"logid":47,"ns":0,"title":"Monitorov\u00e1n\u00ed SQL datab\u00e1ze pomoc\u00ed Zabbixe","pageid":31,"logpage":31,"params":{},"type":"create","action":"create","user":"Admin","timestamp":"2023-03-10T11:42:31Z","comment":"zalo\u017eena nov\u00e1 str\u00e1nka s textem \u201ePro monitorov\u00e1n\u00ed je vhodn\u00e9 pou\u017e\u00edt zabbix-agent2, proto\u017ee m\u00e1 v sob\u011b plugin p\u0159\u00edmo pro mysql a konfigurace prob\u00edh\u00e1 jen na \u00farovni frontendu, narozd\u00edl od zabbix-agent v1.  Prvn\u00edm krokem je odinstalace star\u00e9 verze agenta, pokud je na serveru nainstalov\u00e1na:  apt purge zabbix-agent Dal\u0161\u00edm krokem je vymaz\u00e1n\u00ed repozit\u00e1\u0159e zabbixe, pokud je zastaral\u00fd:  rm -Rf /etc/apt/sources.list.d/zabbix.list D\u00e1le je pot\u0159eba nahr\u00e1t nov\u00fd repozit\u00e1\u0159:\u2026\u201c"},{"logid":46,"ns":0,"title":"Instalace Zabbix frontendu na vzd\u00e1len\u00fd server","pageid":30,"logpage":30,"params":{},"type":"create","action":"create","user":"Admin","timestamp":"2023-03-09T18:39:53Z","comment":"zalo\u017eena nov\u00e1 str\u00e1nka s textem \u201eInstalace frontendu Zabbixe na vzd\u00e1len\u00fd server je mo\u017en\u00e1 po sta\u017een\u00ed cel\u00e9ho bal\u00edku zabbixe a uploadu slo\u017eky UI do ko\u0159enov\u00e9ho adres\u00e1\u0159e webserveru.  \u017d\u00e1d\u00e1 si to \u00fapravy konfigurace PHP a instalaci PHP modulu bcmath:  apt install php8.1-bcmath  a zm\u011bny nutn\u00e9 pro provoz nastavit v PHP (v tomto p\u0159\u00edpad\u011b jen v ispconfigu:  post_max_size=16M  max_execution_time=300  max_input_time=300  D\u00e1le, aby frontend vid\u011bl statistiky serveru, nutno v k\u2026\u201c"},{"logid":45,"ns":0,"title":"Konfigurace MySQL parametru innodb buffer pool size","pageid":29,"logpage":29,"params":{},"type":"create","action":"create","user":"Admin","timestamp":"2023-03-09T14:20:10Z","comment":"zalo\u017eena nov\u00e1 str\u00e1nka s textem \u201eHodnota innodb_buffer_pool_size je hodnota, kter\u00e1 n\u00e1m ur\u010duje velikost vyrovn\u00e1vac\u00ed pam\u011bti pro datab\u00e1zov\u00fd server. M\u011bla by b\u00fdt vypo\u010d\u00edt\u00e1v\u00e1na z velikosti RAM v serveru a jej\u00ed p\u0159\u00edli\u0161 n\u00edzk\u00e1 hodnota m\u00e1 za n\u00e1sledek zpomalen\u00ed aplikac\u00ed, jeliko\u017e se data na\u010d\u00edtaj\u00ed z disku a ne z mezipam\u011bti z RAM.  V na\u0161em p\u0159\u00edpad\u011b m\u00e1 server 16GB RAM a optim\u00e1ln\u00ed hodnota by m\u011bla b\u00fdt cca 75% velikosti RAM, co\u017e n\u00e1m d\u00e1v\u00e1 nastaven\u00ed innodb_buffer_\u2026\u201c"},{"logid":44,"ns":0,"title":"Konfigurase MySQL parametru innodb buffer pool size","pageid":0,"logpage":28,"params":{},"type":"delete","action":"delete","user":"Admin","timestamp":"2023-03-09T14:18:50Z","comment":"obsah byl: \u201eHodnota innodb_buffer_pool_size je hodnota, kter\u00e1 n\u00e1m ur\u010duje velikost vyrovn\u00e1vac\u00ed pam\u011bti pro datab\u00e1zov\u00fd server. M\u011bla by b\u00fdt vypo\u010d\u00edt\u00e1v\u00e1na z velikosti RAM v serveru a jej\u00ed p\u0159\u00edli\u0161 n\u00edzk\u00e1 hodnota m\u00e1 za n\u00e1sledek zpomalen\u00ed aplikac\u00ed, jeliko\u017e se data na\u010d\u00edtaj\u00ed z disku a ne z mezipam\u011bti z RAM.  V na\u0161em p\u0159\u00edpad\u011b m\u00e1 server 16GB RAM a optim\u00e1ln\u00ed hodnota\u2026\u201c a jedin\u00fdm p\u0159isp\u011bvatelem byl \u201e[[Special:Contributions/Admin|Admin]]\u201c ([[User talk:Admin|diskuse]])"},{"logid":43,"ns":0,"title":"Konfigurase MySQL parametru innodb buffer pool size","pageid":0,"logpage":28,"params":{},"type":"create","action":"create","user":"Admin","timestamp":"2023-03-09T14:11:42Z","comment":"zalo\u017eena nov\u00e1 str\u00e1nka s textem \u201eHodnota innodb_buffer_pool_size je hodnota, kter\u00e1 n\u00e1m ur\u010duje velikost vyrovn\u00e1vac\u00ed pam\u011bti pro datab\u00e1zov\u00fd server. M\u011bla by b\u00fdt vypo\u010d\u00edt\u00e1v\u00e1na z velikosti RAM v serveru a jej\u00ed p\u0159\u00edli\u0161 n\u00edzk\u00e1 hodnota m\u00e1 za n\u00e1sledek zpomalen\u00ed aplikac\u00ed, jeliko\u017e se data na\u010d\u00edtaj\u00ed z disku a ne z mezipam\u011bti z RAM.  V na\u0161em p\u0159\u00edpad\u011b m\u00e1 server 16GB RAM a optim\u00e1ln\u00ed hodnota by m\u011bla b\u00fdt cca 75% velikosti RAM, co\u017e n\u00e1m d\u00e1v\u00e1 nastaven\u00ed innodb_buffer_\u2026\u201c"},{"logid":42,"ns":0,"title":"Nastaven\u00ed parametr\u016f MySQL serveru a jeho optimalizace","pageid":27,"logpage":27,"params":{},"type":"create","action":"create","user":"Admin","timestamp":"2023-03-09T14:04:55Z","comment":"zalo\u017eena nov\u00e1 str\u00e1nka s textem \u201ePo instalaci MySQL serveru je vhodn\u00e9 zm\u011bnit n\u011bkolik m\u00e1lo hodnot tak, aby server b\u011b\u017eel na optim\u00e1ln\u00ed v\u00fdkon.  Prvn\u00ed takovou hodnotou je innodb_buffer_pool_size, kter\u00e1 m\u00e1 v\u00fdchoz\u00ed hodnotu 128MB, co\u017e je opravdu m\u00e1lo, potom doch\u00e1z\u00ed k \u010dast\u00fdm z\u00e1pis\u016fm na disk, co\u017e v p\u0159\u00edpad\u011b SSD m\u00e1 za n\u00e1sledek sn\u00ed\u017een\u00ed \u017eivotnosti (omezen\u00fd po\u010det p\u0159epis\u016f).\u201c"},{"logid":41,"ns":0,"title":"Swapov\u00e1n\u00ed Debian","pageid":26,"logpage":26,"params":{},"type":"create","action":"create","user":"Admin","timestamp":"2023-03-09T13:22:58Z","comment":"zalo\u017eena nov\u00e1 str\u00e1nka s textem \u201eV\u0161iml jsem si swapov\u00e1n\u00ed a narazil na parametr swappiness. Ve v\u00fdchoz\u00edm nastaven\u00ed m\u00e1 debian hodnotu 60, co\u017e m\u00e1 za n\u00e1sledek, \u017ee pokud je v pam\u011bti vyu\u017eito u\u017e 40%, za\u010dne swapowat, co\u017e je zbyte\u010dn\u00e9 ub\u00edr\u00e1n\u00ed v\u00fdkonu a nevyu\u017eit\u00ed pam\u011bti.  \u0158e\u0161en\u00edm je tedy nastavit\u201c"},{"logid":40,"ns":0,"title":"Zabbix chyba po upgradu log bin trust function creators","pageid":25,"logpage":25,"params":{},"type":"create","action":"create","user":"Admin","timestamp":"2023-03-09T11:15:13Z","comment":"zalo\u017eena nov\u00e1 str\u00e1nka s textem \u201eP\u0159i upgradu Zabbixe z 6.2.7 na 6.4.0 do\u0161lo k chyb\u011b p\u0159i aktualizaci datab\u00e1ze, viz screenshot. Chybov\u00e1 zpr\u00e1va: ERROR 1419 (HY000) at line 2119: 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)  Na obr\u00e1zku je patrn\u00e1 chyba upgradu i \u00fasp\u011b\u0161n\u00e9 spu\u0161t\u011bn\u00ed upgradu DB po zm\u011bn\u011b parametru v MySQL.  Soubor:Zabbix db upgrade error.jpg|vlevo|n\u00e1hled|Za\u2026\u201c"},{"logid":39,"ns":0,"title":"Instalace a upgrade zabbixe","pageid":24,"logpage":24,"params":{},"type":"create","action":"create","user":"Admin","timestamp":"2023-03-09T09:19:30Z","comment":"zalo\u017eena nov\u00e1 str\u00e1nka s textem \u201eP\u0159i upgradu zabbixe z 6.2.7 na 6.4.0 do\u0161lo k chyb\u011b p\u0159i aktualizaci datab\u00e1ze, viz screen. Na obr\u00e1zku je patrn\u00e1 chyba upgradu i \u00fasp\u011b\u0161n\u00e9 spu\u0161t\u011bn\u00ed upgrdu DB po zm\u011bn\u011b parametru v mysql. [[Soubor:Zabbix db upgrade error.jpg|vlevo|n\u00e1hled|Zabbix db upgrade error z 6.2.7 na 6.4.0]]        \u0158e\u0161en\u00edm bylo:  Code:  mysql> SHOW VARIABLES LIKE 'log_bin_trust_function_creators';  +---------------------------------+-------+  | Variable_name\u2026\u201c"}]}}