SQL to export SSO SAML configuration?

Savvas Radevic_r4s2nu

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_r4s2nu

 

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