More

Zabbix

[Z3005] Zabbix PostgreSQL database upgrade failed

By Antti Hurme 07/03/2023 No Comments 1 Min Read

When upgrading your Zabbix Database, you might encounter the following error “[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  permission denied for schema public”. The zabbix user you’ve created doesn’t normally need access to the database schema to work, so this would only be relevant when upgrading the zabbix version, for example between 6.2.x to 6.4.0. To fix the error, you need to give the zabbix database user access to modify the public…

Continue Reading

Zabbix 4.0 Proxy Upgrade database issues

By Antti Hurme 06/10/2018 1 Comment 0 Min Read

Encountered a few Proxy Database upgrade issues while upgrading from Zabbix 3.4.x to 4.0. These issues are simple to fix, but require some database changes. 18576:20181006:140604.487 [Z3005] query failed: [1005] Can’t create table `zabbix`.`#sql-4856_6` (errno: 121 “Duplicate key on write or update”) [alter table `tag_filter` add constraint c_tag_filter_1 foreign key (`usrgrpid`) references `usrgrp` (`usrgrpid`) on delete cascade] 18576:20181006:140604.487 database upgrade failed Fix: alter table tag_filter drop foreign key c_tag_filter_1; 17762:20181006:143448.133…

Continue Reading

Ignoring Windows Services in Zabbix Windows Template Low-Level Service Discovery

By Antti Hurme 27/12/2017 2 Comments 0 Min Read

The new Zabbix Windows templates include a Low-Level Discovery for Windows Services. The service.discovery LLD creates items based on discovered Windows Services and accompanies triggers to services with Automatic startup. To ignore a set of services, from all Windows clients, you need to modify  the discovery regex. To modify the default regex, open Administration > General > Regular Expressions. Modify the Windows Service names for discovery reged that has a…

Continue Reading

Zabbix Windows Security event id 5156

By Antti Hurme 31/10/2016 No Comments 0 Min Read

Noticed in one case the Zabbix agent was spamming the Windows Security eventlog with events “filtering platform connection” of status success and event id 5156. This was especially true when disk space was low and the agent seemed to query the disk space a lot more frequently. This caused the log file to fill up even faster which helped the disk space to fill up. To get around this, I…

Continue Reading
Load More Posts