Details
-
Bug
-
Resolution: Fixed
-
Medium
-
8.4.3, 8.4.0, 8.4.1, 8.4.2, 8.5.0, 8.5.1
-
None
-
8.04
-
1
-
Severity 2 - Major
-
Description
Issue Summary
When using the Azure template, deploying to a Postgres database fails (deploying to SQL Server completes successfully).
Steps to Reproduce
- Use the Azure template to deploy Jira 8.4 or higher
- Choose Postgres as your database
Expected Results
Jira successfully deploys a Postgres database and Jira 8.4+ instance and connects to it.
Actual Results
Jira fails to start with the following error
2019-12-05 19:04:35,598 localhost-startStop-1 ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database: org.postgresql.util.PSQLException: Could not open SSL root certificate file /home/jira/.postgresql/root.crt.
Workaround
This appears to be caused by the updated Postgres driver that's included in Jira 8.4 and above.
The following workaround (performed on all nodes) appears to resolve the issue, however:
sudo su -
service jira stop
rm -f /opt/atlassian/jira/lib/postgresql-9.4.1211.jar
curl -LO https://www.digicert.com/CACerts/BaltimoreCyberTrustRoot.crt
openssl x509 -inform DER -in BaltimoreCyberTrustRoot.crt -text -out root.crt
mkdir -p /home/jira/.postgresql
cp root.crt /home/jira/.postgresql
chown jira:jira /home/jira/.postgresql/root.crt
service jira start