How to configure SSL for eazyBI for Jira Postgres connection

[Christopher St_ John]

I am running Jira v9.4.7 and eazyBI Reports and Charts for Jira v6.6.0. I cannot find any information on how to setup SSL for Postgres in eazyBI. When I configure eazyBI settings I can check the box "Use SSL" which fails because  also need to specify the location of the certificates. How can I specify the jdbc url with:

ssl=true

sslmode=verify-full

sslrootcert=/my/rootcert

sslkey=/my/key.pk8

sslcert=/my/sslcert

[Christopher St_ John · Accepted solution]

I was able to get it working by adding the following to eazybi.toml and restarting Jira. I had an existing non-ssl database connection.

[database.advanced.properties]
sslcert= "/path/to/public.crt"
sslkey = "/path/to/private.key"
sslmode = "verify-full"
sslrootcert = "/path/to/ca-chain.cer"

I also found out I could add the following to the installer advanced settings and it would work too. I did not check the box "Use SSL" in the eazyBI settings because sslmode was specified. I'm guessing if I checked the box I did not need to specify sslmode.

[properties]
sslcert= "/path/to/public.crt"
sslkey = "/path/to/private.key"
sslmode = "verify-full"
sslrootcert = "/path/to/ca-chain.cer"

[Gerda Grantiņa]

Hi @Christopher St_ John 
On eazyBI, you can enable SSL for PostgreSQL with those Database advanced settings:

[properties]
sslmode = "require"

For more information, check this documentation about eazyBI installation on PostgreSQL: https://docs.eazybi.com/eazybi/set-up-and-administer/atlassian-server-and-data-center/installation-on-jira#InstallationonJira-PostgreSQL

Best,
Gerda // support@eazybi.com

[Marc - Devoteam]

Hi @Christopher St_ John 

I think your question relates to SSL setup for EazyBI this can be found in their documentation

https://docs.eazybi.com/eazybi/set-up-and-administer/private-eazybi/https-or-ssl-setup 

[Christopher St_ John]

Thanks for the reply, but the document is for eazyBI's web page. I need the SSL setup for the Postgres database connection.

[Marc - Devoteam]

Hi @Christopher St_ John 

I would reach out to eazyBI directly for help on the configuration. They should have had this question before.

I would ask them if they are able to update their documentation on the topic as well if its not in there or not in a logic location