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:

  1. Run the below SQL query on the Bamboo database: 

    SELECT * FROM BANDANA WHERE BANDANA_KEY like '%ENABLE_SAML_SSO%'; 
  2. 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>
  3. Stop Bamboo
  4. Take a backup of the Bamboo database.
  5. Run the below update SQL query: 

     UPDATE BANDANA set serialized_data='<string>false</string>' where BANDANA_ID=<id from the query in step 2>;
  6. 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>;
  7. Start Bamboo.




Last modified on Jun 26, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.