Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Maintain SAML/SSO 2.0 during pushing prod to test

We changed our productive system to use SAML  / SSO 2.0 to authenticate users as primary authentication method. Part of the authentication configuration is the URL of our Jira-Instance.

If we restore a Jira-Backup from our productive system to our testing system, then the configuration of SSO (containing the productive systems URL) would not match to the testing systems URL. Resulting in any authentication attempt to fail, preventing us to log in on the testing system.

Is there any way to maintain/retain the SSO configuration of a testing system when restoring into it a backup of the productive system?


1 answer

1 accepted

0 votes
Answer accepted

After a lot of analysis we found that the biggest part of the configuration of out testsystem is in the Jira database, including the configuration of SSO. So pushing prod to test is done by copying the database and then applying a SQL-Script which resets all values different in the testsystem to the correct values. Setting the correct certificate for sso for example results in the following query:


update propertytext set propertyvalue='-----BEGIN CERTIFICATE----- ABCDEFG -----END CERTIFICATE-----' where ID in (select ID from propertyentry where PROPERTY_KEY='com.atlassian.plugins.authentication.sso.config.signing-cert');


Suggest an answer

Log in or Sign up to answer

Atlassian Community Events