000034428 - RSA Adaptive Authentication (On Premise) 7.2 customer enabled "Use of External Identity Provider" & was locked out of Back Office

Document created by RSA Customer Support Employee on Nov 23, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034428
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Product/Service Type: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.2
 
IssueWhile trying to implement External Identify Provider in Back Office, an administrator locked themselves out of Back Office.  They were not able to get back into Back Office to disable the External Identity Provider option.
 
TasksLog into the database server, and run the following queries:
#1. Select ID from RSA_CORE.GEN_CONFIG_PARAM_VALUE where GEN_CONFIG_PARAM_ID = ( select ID from RSA_CORE.GEN_CONFIG_PARAM where name = 'USE_CUSTOM_PROVIDER' and version='1')
#2. Select GEN_CONFIG_PARAM_ID from RSA_CORE.GEN_CONFIG_PARAM_VALUE where GEN_CONFIG_PARAM_ID = ( select ID from RSA_CORE.GEN_CONFIG_PARAM where name = 'USE_CUSTOM_PROVIDER' and version='1')
#3. UPDATE RSA_CORE.GEN_CONFIG_PARAM_VALUE
SET VALUE='false'
WHERE ID='value from query #1 ' and GEN_CONFIG_PARAM_ID='value from query #2 ';
COMMIT;
 
ResolutionLog into the database server, and run the following queries:
#1. Select ID from RSA_CORE.GEN_CONFIG_PARAM_VALUE where GEN_CONFIG_PARAM_ID = ( select ID from RSA_CORE.GEN_CONFIG_PARAM where name = 'USE_CUSTOM_PROVIDER' and version='1')
#2. Select GEN_CONFIG_PARAM_ID from RSA_CORE.GEN_CONFIG_PARAM_VALUE where GEN_CONFIG_PARAM_ID = ( select ID from RSA_CORE.GEN_CONFIG_PARAM where name = 'USE_CUSTOM_PROVIDER' and version='1')
#3. UPDATE RSA_CORE.GEN_CONFIG_PARAM_VALUE
SET VALUE='false'
WHERE ID='value from query #1 ' and GEN_CONFIG_PARAM_ID='value from query #2 ';
COMMIT;
Restart the application server for the Back Office.  Once the Back Office is back up,
the admin should be able to log in again.

Attachments

    Outcomes