Zabbix v6.4.6 -configure DB connection with postgreSQL errors out

[Rizzyzam]

Hello All,

I am using certificate DB authentication to a remote postgreSQL DB v 13.11. The auth works fine using psql and zabbix server backend connects to the DB without any issues. However, when I try to configure DB on the frontend, it just says on "Error connecting to the database" no matter what i pass. I added the php config file manually to /usr/share/zabbix/zabbix.conf.php.

update:
I keep getting errors httpd log file( this has nothing to do with DB connections but it seems to be a bug on v6.4.6)

[proxy_fcgi:error].. AH1071: Got error 'PHP message: PHP Warning: Trying to access array offset on value type null in /usr/share/zabbix/include/classes/core/CCookieSession.php on line 194'.

it seems to be performing the client side validations but never sends the connections to the backend. I checked the cookie it seems to have all the details that i am passing.

Could you please provide your suggestions and comments

Version details
RHEL9
zabbix v 6.4.6
httpd - Apache 2.4.53
PHP 8.1.14

[Rizzyzam]

Configured DB certificate authentication from php successfully. It was just a permission issue and i had to create a dedicated certificate directory with permission sets for httpd.

Now both the frontend and backend are authenticating with postgreSQL DB using SSL certificates.