SQL to export SSO SAML configuration?

Savvas Radevic February 19, 2024

Hi we would like to automate several SSO/SAML configuration, to export from and re-import to the SQL database (MySQL).

Do you know which data (tables/columns/values) to export to get the configuration for the Atlassian SSO plugin?

https://marketplace.atlassian.com/apps/1216096/sso-for-atlassian-server-and-data-center

 

Thank you.

2 answers

1 accepted

1 vote
Answer accepted
Savvas Radevic February 19, 2024

 

how to configure SSO / SAML through REST API and/or MySQL

quoting the Atlassian developer support:

https://confluence.atlassian.com/confkb/list-of-rest-apis-available-to-configure-sso-on-confluence-dc-1085188345.html

You may want to assess if you can use the available REST API endpoints for the activity you would like to conduct.
Although it mentions Confluence, these are valid for Jira as well.

 

Regarding on which database tables the configuration are stored, you may check the following SQL queries for Jira:

Generic configuration.

select pe.property_key,ps.*,pt.*
from propertyentry pe
left join propertystring ps on pe.id = ps.id
left join propertytext pt on pe.id = pt.id
where pe.property_key like 'com.atlassian.plugins.authentication%';

IdP configuration.

select *
from "AO_ED669C_IDP_CONFIG";

 

1 vote
Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 19, 2024

Hi @Savvas Radevic 

Best option is to reach out to the developer of the app.

They will know where the information is stored in your DB in relation to the configuration.

As it's an app from Atlassian, reach out via Atlassian Support

Suggest an answer

Log in or Sign up to answer