fe_sendauth: no password supplied about libzbxpgsql HOT 4 CLOSED

i love u

from libzbxpgsql.

Firstly, thanks for taking a look at the existing issues before raising a new one. I agree this is not the same as #19.

The easiest way forward, since you are installed on the DB server, would be to tell the template to connect using Unix sockets. You should be able to connect with the default (blank) connection string set in the template. This is what zabbix_agentd -p uses.

When you call zabbix_agentd -p it uses the default connection string, which connects via Unix socket, not TCP/IP. It probably works because it would be using peer or ident auth for the local connection in your pg_hba.conf.

Your zabbix template on the other hand, is connecting via TCP/IP (host=127.0.0.1) and probably requires md5 password authentication. In this case, you must specify a password in the connection string, or more preferably, use a .pgpass file as per http://cavaliercoder.com/libzbxpgsql/agent-keys/#remote-monitoring-agent.

Please advise how you go.

from libzbxpgsql.

:argh:

You are correct!

Had to have the .pgpass file for the agent to use in the default Zabbix agent user account home directory /var/run/zabbix.

Permanent fit was to change the Zabbix agent home directory to /home/zabbix (or something of your choosing) because the contents of /var/run are not permanent, then copy/paste the .pgpass file here and then restart the Zabbix agent

from libzbxpgsql.

Excellent! Thanks for providing the answer.

from libzbxpgsql.