Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-70368

Deploying to Postgres using the Azure template fails

XMLWordPrintable

      Issue Summary

      When using the Azure template, deploying to a Postgres database fails (deploying to SQL Server completes successfully).

      Steps to Reproduce

      1. Use the Azure template to deploy Jira 8.4 or higher
      2. 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
      

            Unassigned Unassigned
            ilay Ivan Lay
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: