on Nov 23, 2016Article Content
| Article Number | 000034428 |
| Applies To | RSA Product Set: Adaptive Authentication (OnPrem) RSA Product/Service Type: Adaptive Authentication (OnPrem) RSA Version/Condition: 7.2 |
| Issue | While 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. |
| Tasks | Log 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; |
| Resolution | Log 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. |