How to disable the miniOrange SAML SSO (external app) authentication in Bamboo from the backend database
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
If SSO is the primary authentication method and for some reason, it fails or want to bypass/disable it from backend, please follow the below instructions mentioned in the solution.
Environment
Bamboo 8.1+ versions with SSO support and miniorange SAML SSO setup used for this case.
Solution
Solution 1:
SSO authentication can be bypassed by enabling the username/password authentication with a REST call. Please follow the steps mentioned in this document Lockout recovery process under section Fallback authentication in Bamboo for the same.
Solution 2:
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
If the above solution didn't work for your Bamboo instance and still authentication points to SSO, please follow the below steps:
Run the below SQL query on the Bamboo database:
SELECT * FROM BANDANA WHERE BANDANA_KEY like '%ENABLE_SAML_SSO%';
If the above query provide you results like below for example, then continue to the next steps:
98926605 | 0 | miniorange.saml.ENABLE_SAML_SSO | <string>true</string>
- Stop Bamboo
- Take a backup of the Bamboo database.
Run the below update SQL query:
UPDATE BANDANA set serialized_data='<string>false</string>' where BANDANA_ID=<id from the query in step 2>;
Once the above update runs successfully, verify the same if updated correctly by running the below query, it should as '<string>false</string>' under the serialized_data column:
SELECT * from BANDANA where BANDANA_ID=<id from the query in step 2>;
- Start Bamboo.