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

Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.

Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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 making any database modifications. 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:

    1 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:

    1 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:

    1 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:

    1 SELECT * from BANDANA where BANDANA_ID=<id from the query in step 2>;
  7. Start Bamboo.

Updated on March 17, 2025

Still need help?

The Atlassian Community is here for you.