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

Error in start #15

Closed stepanovandrey89 closed 4 years ago

stepanovandrey89 commented 6 years ago

root@localhost:/opt/go/bin# go run influxdb-zabbix.go & [5] 20535 root@localhost:/opt/go/bin# 2018/08/29 12:35:04 [T] Log Mode: Console(Trace) 2018/08/29 12:35:04 [T] --- Active tables: 2018/08/29 12:35:04 [T] ----------- | history_uint | Each 15 sec | 30 days per batch | Output by 50000 2018/08/29 12:35:04 [T] ----------- | trends | Each 15 sec | 30 days per batch | Output by 50000 2018/08/29 12:35:04 [T] ----------- | trends_uint | Each 15 sec | 30 days per batch | Output by 50000 2018/08/29 12:35:04 [T] ----------- | history | Each 15 sec | 30 days per batch | Output by 50000 2018/08/29 12:35:04 [I] --- Start polling 2018/08/29 12:35:04 [T] --- Provider: mysql 2018/08/29 12:35:04 [...db-zabbix/log/log.go:299 Error()] [E] Error while executing script: Error 1146: Table 'zabbix.groups' doesn't exist 2018/08/29 12:35:04 [...db-zabbix/log/log.go:299 Error()] [E] Error while executing script: Error 1146: Table 'zabbix.groups' doesn't exist

guillerial commented 5 years ago

@stepanovandrey89 I have the same problem. Did you find any solution? image

stepanovandrey89 commented 5 years ago

Check this table in 3x version. 4x version dont consist this table. I am duplicate(create) table.

пт, 2 нояб. 2018 г. в 14:54, Guillermo Rial Salgueiro < notifications@github.com>:

@stepanovandrey89 https://github.com/stepanovandrey89 I have the same problem. Did you find any solution?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/zensqlmonitor/influxdb-zabbix/issues/15#issuecomment-435355215, or mute the thread https://github.com/notifications/unsubscribe-auth/APcJPSm18aTKmXvmcQwJHHLXj7M1iE-Tks5urDJqgaJpZM4WSIRQ .

guillerial commented 5 years ago

groups table is now hstgrp table. I changed this on mysql.go and it works. Zabbix 4.0

Check this: https://github.com/guillerial/influxdb-zabbix/commit/b5a176b39abb201fee505d2e644c5447f8020105

zensqlmonitor commented 4 years ago

ok fixed