PostgreSQL JDBC via SSL

dujas

Guys,

I am using PostgreSQL 13.5 as the backend database for JSM 8.21.0.

To enable mTLS connection between JSM and database, I have turned on SSL on database side, it is working fine. And generated the necessary files on JSM side, I could verify it via:

psql "host=<FQDN> port=5432 user=jiradbuser dbname=jiradb sslmode=verify-full sslcert=/path/to/jiradb.crt sslrootcert=/path/to/root.crt sslkey=/path/to/jiradb.key"

Meanwhile, in pg_hba.conf, I have added "cert clientcert=1" as well.

However, when I turned that into JDBC string it is always complaining:

no pg_hba.conf entry for host <ip address of JSM>, user "jiradbuser", database "jiradb", SSL off

May I know what the correct format of the JDBC should be?

Nic Brough -Adaptavist-

This is not an error in your Jira settings, the pg_hba file is access control on the database.  It is saying you need to add access for Jira to that file on the database side.