grafana / grafana-zabbix

Zabbix plugin for Grafana dashboard
http://play.grafana-zabbix.org
Apache License 2.0
2.07k stars 457 forks source link

test and save fails with Direct DB enabled, once disabled save & test works. #1347

Open Jieiku opened 2 years ago

Jieiku commented 2 years ago

Describe the bug test and save fails with Direct DB enabled, once disabled save & test works.

THANK YOU for sharing this plugin, its is very cool! I am coming from using telegraf+influxdb for some of my metrics. Once I found out I could use zabbix to capture info to postgres I was very happy to find your plugin for grafana, I hope I can get it fully working with direct db access.

Both Zabbix and Grafana are setup/configured to access the PostgreSQL Database via unix socket, zero issues with zabbix using the db this way (host=/run/postgresql), and zero issues with adding the PostgreSQL datasource this way in grafana. I am just getting hung up on the direct db access for this plugin.

I chose Zabbix 5.0.17 (LTS) because I assumed it would have the least problems, however if this plugin is developed first and foremost with the latest version of Zabbix in mind then please let me know and I will switch to that. I am looking to set it up so that it will just work and be fore the most part trouble free way of monitoring some metrics on various servers/containers.

Expected behavior test and save should succeed, I am currently trying to figure out which logs might provide more clues as to the cause of the breakdown.

I did find one similar issue (but theirs was resolved by updating the plugin): https://github.com/alexanderzobnin/grafana-zabbix/issues/1330

Screenshots with direct db: 2021-11-19_01-30_1

without direct db: 2021-11-19_01-30

Network data If it's related to metric data visualization would be great to get the raw query and response for the network request (check this in browser dev tools network tab, there you can see metric requests, please include the request body and request response)

Software versions

Grafana Zabbix Grafana-Zabbix Plugin
8.2.5 5.0.17 4.2.4

Grafana: v8.2.5 (b57a137acd) Zabbix: Zabbix 5.0.17 (LTS) Grafana-Zabbix Plugin: 4.2.4

PostgreSQL: 14.1 (Ubuntu 14.1-2.pgdg20.04+1) OS: Ubuntu 20.04.3 LTS

github-actions[bot] commented 2 months ago

This issue has been automatically marked as stale because it has not had activity in the last 2 years. It will be closed in 60 days if no further activity occurs. Please feel free to leave a comment if you believe the issue is still relevant. Thank you for your contributions!