SSL connection between jira service management

Question

Hi Guys, I am trying to set up SSL connection between jira service management and postgresql. What I did is as below: 1. Installed jsm at first 2. Generated server.crt on postgresql server (the server.crt is generated from internal PKI system) 3. Turned on SSL on postgresql server, I verified it as well 4. Copied server.crt to jsm server /tmp folder and stopped jsm, modified dbconfig.xml: jdbc:postgresql://:5432/jiradb?ssl=true&sslmode=verify-full&sslrootcert=/tmp/server.crt 5. Start jsm Once the url is loaded, it navigated me to the setup page instead of the previous login one, it seems the dbconfig.xml is not recognized at all. Same issue I found in https://community.atlassian.com/t5/Jira-questions/Secure-postgres-JDBC-connection/qaq-p/1708162#U1943398, but there is no explicit solution in it. Could anyone have any suggestion for this? Thanks in advance. Best Regards, Jason

Jacob Francois_hmf90i · Answer

When i try to use ";" i get an error. When i use "&" i don't get any errors but Jira asks me to set up a new data base. Have you seen this before.

dujas · Answer

Well, I finally figured out the issue, jdbc string should be like: jdbc:postgresql://:5432/jiradb?ssl=true;sslmode=verify-full;sslrootcert=/tmp/server.crt The delimeter must be ";" instead of "&". Btw, I did not import the crt to keystore on jira server.