How to remove SAML config for JIRA 7 from back end or to change config

[Prashant Karakanagoudar]

Hi,

We have installed SAML pligin for JIRA.

Everything works fine when we set config to Seconday authentication and tested. However as soon as we select Primary authentication in configuration JIRA will be not reachable. 

We would like to change this config via DB or some other way. Can any one help me to identify which table contain the SAML plugin details.

I found a link related to confluence, however this wont help as i could not find similar table as explained here.

https://confluence.atlassian.com/confkb/how-to-switch-saml-from-the-primary-to-the-secondary-authentication-method-in-the-database-945120249.html

regards,

Prashant

[Rudy Dullier · Accepted solution]

Hi,

This is quite outdated but I had same issue, here is some SQL to do so.

This is using PostgreSQL and Jira 8.1.0.

This requires a restart of Jira as we hacked its DB.

-- View all params about SAML
select *
from propertyentry pe join propertystring ps on pe.id = ps.id
where Lower(pe.property_key) like '%saml%'

-- Specific search on redirect on login
select * from propertystring
where id = (select id from propertyentry where property_key = 'com.atlassian.plugins.authentication.samlconfig.redirect-on-login')

-- Update that one to false
update propertystring
set propertyvalue = 'false'
where id = (select id from propertyentry where property_key = 'com.atlassian.plugins.authentication.samlconfig.redirect-on-login')

To know what property type to look after, see https://confluence.atlassian.com/jirakb/propertyset-table-mappings-317196217.html

Regards,

Rudy