How to disable the miniOrange SAML SSO (external app) authentication in Bamboo from the backend database

Still need help?

The Atlassian Community is here for you.

Ask the community


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.