2020-08-17 15:49:02 Password for user zbx_monitor: psql: fe_sendauth: no password supplied?

Question

PostgreSQL

These are the matyuki covers Zabbix Server 5 client on a host with 5 agents and postgres 9.6

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

And so on, everything was done according to normal manuals, and even in order not to strain at all, pg_hba.conf was brought to this format.

# "local" is for Unix domain socket connections only
local   all             all                                     trust
host    all             postgres                                trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
host    all             zbx_monitor 127.0.0.1/32                trust
host    all             zbx_monitor 0.0.0.0/0                   trust
host    all             zbx_monitor ::0/0                       trust

I've read a lot of Google and still can't figure it out.

[[email protected] zabbix_agentd.d]# psql -h 127.0.0.1 --username=postgres postgres
Пароль пользователя postgres: 
psql (9.6.11)
Введите "help", чтобы получить справку.

postgres=# \q

[[email protected] zabbix_agentd.d]# psql -h 127.0.0.1 --username=zbx_monitor  postgres
Пароль пользователя zbx_monitor: 
psql (9.6.11)
Введите "help", чтобы получить справку.

postgres=# \q

Thanks in advance.

Answer 1

[[email protected] zabbix_agentd.d]# psql -h 127.0.0.1 --username=zbx_monitor postgres zbx_monitor
user password:

Do you see the password request?
If you don't enter a password - no password supplied from psql will be.
And since there is a password request, it means that you did not trust. reload was not commanded or there is some syntax error in the file - see database logs.