Zabbix – Null Byte

Excluding Zabbix from EPEL repo in RHEL/ROCKY/ALMA Linux

By Antti Hurme 03/03/2024 No Comments 2 Min Read

Now that Zabbix is a part of the EPEL repo, you might need to exclude it from the DNF configuration, if your using the official Zabbix repository. The error will be something similar to the following: Edit the repository config: /etc/yum.repos.d/epel.repo, and add an exclude in the [epel] repository configuration: run “dnf clean all” and “dnf update” again to check if the problem is solved. Excluding Zabbix when Updating Use…

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

Homelab Linux Zabbix

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…

[Z3005] Zabbix PostgreSQL database upgrade failed

Zabbix

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…

Zabbix 4.0 Proxy Upgrade database issues

Zabbix

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…