search

zensqlmonitor / influxdb-zabbix

Gather data from Zabbix back-end and load to InfluxDB in near real-time for enhanced performance and easier usage with Grafana.
MIT License
71 stars 26 forks source link

Update mysql.go renamed groups to hstgrp due to zabbix change #16

Closed odnanref closed 4 years ago

odnanref commented 5 years ago

Zabbix has changed the name of table groups to hstgrp due to key reservations in mysql 8

https://www.zabbix.com/forum/zabbix-help/374145-is-table-groups-on-mysql-missing-after-update-3-2-11-to-4-0-4

piotr-sikora-v commented 5 years ago

also need to add in documentation: GRANT SELECT ON zabbix.hstgrp TO influxdb_zabbix@localhost;