SQL to export SSO SAML configuration?

[Savvas Radevic]

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.

[Savvas Radevic · Accepted solution]

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";

[Marc - Devoteam]

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