Zabbix and PostgreSQL TLS error

[JC_D]

Hello!

I'm trying to set up Zabbix 7.0 with PostgreSQL 16 on two hosts with Debian 12. I set up TLS certificates to connect to the database. If I run the psql command on the host with the Zabbix server, I successfully connect to the database.

psql "host=zabbix-db.domain.local port=5432 user=zabbix dbname=zabbix sslmode=verify-full sslcert=zabbix.crt sslkey=zabbix.key sslrootcert=ca.crt"

However, when setting up the connection in the web interface, I get the error:

"Cannot connect to the database."

In the database logs I see the message:

"[unknown]@[unknown] LOG: could not accept SSL connection: EOF detected"

pg_hba.conf contains the following settings:

# IPv4 remote connections for authenticated users

hostssl all zabbix [URL="http://192.168.0.31/32"]192.168.0.31/32[/URL]scram-sha-256 clientcert=verify-full

Please tell me what the problem could be?

[ivanmirandaf]

Você conseguiu resolver? Também estou com o mesmo problema, o backend conecta mas o frontend não.