Connect eazyBI to Postgres database with SSL

Questions & Answers
1

I am running “eazyBI Reports and Charts for Jira” v6.6.0 on Jira v9.4.7. I cannot find any information on how to connect eazyBI to a Postgres13 database with SSL.
When I “Configure” eazyBI settings through the Jira “Manage apps” page I can check the box “Use SSL” but that fails because I also need to specify the location of the certificates.
How can I specify the location of the certificates, or the jdbc url, or what is needed in eazybi.toml? The eazybi.toml file currently has non-ssl settings in it.

This is what I need to set for the jdbc url.
ssl=true
sslmode=verify-full
sslrootcert=/my/rootcert
sslkey=/my/key.pk8
sslcert=/my/sslcert

The jdbc url should look something like this.

jdbc:postgresql://mydatabase.local.net:5432/eazybi_jira?ssl=true&sslmode=verify-full&sslrootcert=/my/rootcert&sslkey=/my/key.pk8&sslcert=/my/sslcert

2

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”

1 Like