You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
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
The text was updated successfully, but these errors were encountered:
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.
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
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
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
The text was updated successfully, but these errors were encountered: