Hi.
Im trying to connecton to my Postgresql database in Azure and I'm getting this error:
[root@zabbix-~]# zabbix_get -s 127.0.0.1 -p 10050 -k pgsql.dbstat["***s.database.azure.com:5432","zbx_monitor"," PASW ORD"]
ZBX_NOTSUPPORTED: Connection failed: failed to connect to `host=***s.database.azure.com user=zbx_monitor database=postgres`: server error (FATAL: no pg_hba.conf entry for host "x.x.x.x", user "zbx_monitor", database "postgres", no encryption (SQLSTATE 28000)).
I can connect from the same host using psql with no problem
[root@zabbix ~]# psql -h ****.database.azure.com -p 5432 -U zbx_monitor postgres
Password for user zbx_monitor:
psql (10.23, server 14.6)
WARNING: psql major version 10, server major version 14.
Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.
Im trying to connecton to my Postgresql database in Azure and I'm getting this error:
[root@zabbix-~]# zabbix_get -s 127.0.0.1 -p 10050 -k pgsql.dbstat["***s.database.azure.com:5432","zbx_monitor"," PASW ORD"]
ZBX_NOTSUPPORTED: Connection failed: failed to connect to `host=***s.database.azure.com user=zbx_monitor database=postgres`: server error (FATAL: no pg_hba.conf entry for host "x.x.x.x", user "zbx_monitor", database "postgres", no encryption (SQLSTATE 28000)).
I can connect from the same host using psql with no problem
[root@zabbix ~]# psql -h ****.database.azure.com -p 5432 -U zbx_monitor postgres
Password for user zbx_monitor:
psql (10.23, server 14.6)
WARNING: psql major version 10, server major version 14.
Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.
Comment