More

Zabbix

Monitoring Temperature, Humidity, Pressure and so on with Zabbix + Ruuvitag

By Antti Hurme 02/07/2023 No Comments 4 Min Read

I’ve been using Ruuvitags to measure different places around my house some time, and storing the data to my Zabbix installation. The GitHub repository below contains all the necessary files, as well as rudimentary install instructions. You need to have a device that can run Python 3.7.x, has a compatible Bluetooth device and has the required Zabbix binaries. In addition you need to follow the ruuvitag-sensor repository guide for the…

Continue Reading

[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
Load More Posts