pg-monz / pg_monz

This is the Zabbix monitoring template for PostgreSQL Database.
Apache License 2.0
164 stars 81 forks source link

zabbix trapper items are not gathering values #49

Closed AviPairupuni closed 5 years ago

AviPairupuni commented 5 years ago

I have this issue with my zabbix 4. pgsql 11 and Rhel 7. Trappers are unable to gather values from local host. (DB and Server on same host installation) If I push values using sender they are getting updated but its not happening automatically. What could be wrong

pengbo0328 commented 5 years ago

Is there some error in zabbix_server.log ot zabbix_agent.log? I will check it.

pengbo0328 commented 5 years ago

I think the config in "/usr/local/etc/pgsql_funcs.conf" is not correct. You have to make sure you can connect PostgreSQL with the "PGHOST", "PGPORT" ,"PGROLE" and "PGDATABASE" which you configured in "/usr/local/etc/pgsql_funcs.conf".

Try if you can connect PostgreSQL by using psql -h "PGHOST" -p "PGPORT" -U "PGROLE" "PGDATABASE"

AviPairupuni commented 5 years ago

Issue was that the trapper was not in its default location and hence this was not working. I added the path into each of the scripts and that got it working.

Thank you for this Add-On

Regards, Avi