zabbix-extensions icon indicating copy to clipboard operation
zabbix-extensions copied to clipboard

Error agent info

Open Dozentz opened this issue 2 years ago • 2 comments

PostgreSQL 13 Zabbix 5.4

database zabbixdb user zbx_monitor

pointed out in pg_hba.conf host zabbixdb zbx_monitor 127.0.0.1/32 trust

Agent info Preprocessing failed for: Password zbx_monitor: .psql: error: fe_sendauth: no password supplied

  1. Failed: cannot extract value from json by path "$.deadlocks": cannot parse as a valid JSON object: invalid object format, expected opening character '{' or '[' at: 'password zbx_monitor: psql: error: fe_sendauth: no password supplied'

When entering a command, it asks for a password sudo -u zabbix psql -h 127.0.0.1 -p 5432 -U zbx_monitor -d zabbixdb -l

Dozentz avatar Sep 28 '21 20:09 Dozentz

you have to check your PostgreSQL setup to enable access for the agent. Please confirm that you are using IPv4 for connection. It might be that you are using a domain socket or IPv6 instead, so your setting won't work. Check postgres logs for further details. So either configure access without password prompt or provide a password.

stephankn avatar Sep 28 '21 21:09 stephankn

Everything worked, thanks. The error was in the pg_hba.conf file, I indicated at the very end, which contradicts all the rules. Tell me where to put the .pgpass file for alternative authorization. And also tell me the output key the size of the base

Dozentz avatar Sep 29 '21 07:09 Dozentz