Complete cleanup of the Strong Auth/Risk Auth old instances from the Admin console

Products

• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)
• CA Strong Authentication
• CA Risk Authentication

Issue/Introduction

We are seeing old instances in the Admin console but not the new ones, provide the steps to do the clean up. The Instance shows Graceful Shutdown in Admin screen.

Environment

Release : 9.1

Component : AuthMinder(Arcot WebFort) Strong Authentication

RiskMinder ( Arcot RiskFort) Risk Authentication

Database: Oracle

Note-> For MS SQL server the Insert queries will be a bit different so do not run the below ones if you are using the MS SQL DB.

Resolution

This article has the complete steps for the Instance cleanup. These are prerequisite steps before you go through the process.

• Stop the application server, Strong Auth server instance and Risk server Instances.
• These steps are specific for Oracle database as the queries are specific to that.
• If SSL is configured then that has to be reconfigured for the protocols used.

Strong Authentication Old Instance Cleanup:

• Connect to the Strong Auth database and run the below query:

             delete from arwfinstances where INSTANCENAME='<Host_Name>';

You can also delete all the entries from this table and entries will be recreated once the Strong Auth service is started.

• Run below query to remove the protocol entries associated with that instance:
  delete from ARWFPROTOCOLCONFIGURATION where INSTANCEID != 'DefaultInstance';
  commit;

Risk Authentication Old Instance Cleanup:

• Connect to Risk Auth database.
• Run below query to remove RA instance:

        delete from arrfinstances where HOSTNAME='<Host_Name>';

• Run below query to remove the protocol entries associated with that instance:

        delete from ARRFPROTOCOLREGISTRY where INSTANCEID like '<Host_Name>';

You can delete everything but InstanceID as DEFAULTID, you can use the below query

       delete from ARRFPROTOCOLREGISTRY where INSTANCEID != 'DEFAULTID';

Admin and UDS Old Instance Cleanup:

• Connect to the Strong Auth and Risk Auth database.
• Run the below query -
  delete from ARPFCMNINSTANCE;
  commit;

ARADMINMAP table contains all the instances we see in Admin console connectivity screens so that table has to be truncated as well, Please note that if there is SSL configuration done in your environment then that has to be redone for this.

Run the below query to truncate the ARADMINMAP table.

truncate table ARADMINMAP;

Now we need to populate the data in the ARADMINMAP table with the default values. Run the below queries -

INSERT INTO ARADMINMAP (DATATYPE, DESCRIPTION, KEY, KEYSCOPE, VALUE, BLOBVALUE)
        VALUES (6, 'ARWF_ADMIN_CONFIGS', 'ARWF_ADMIN_CONFIGS', 'WebFort', null, '61646D696E2E686F73742E310A6C6F63616C686F73740A61646D696E2E706F72742E310A393734350A61646D696E2E636F6E6E656374696F6E54696D656F75742E310A31303030300A61646D696E2E7265616454696D656F75742E310A33303030300A61646D696E2E7472616E73706F72742E310A7463700A61646D696E2E73657276657243414365727450454D2E310A0A61646D696E2E636C69656E74436572744B65795031322E310A0A61646D696E2E636C69656E74436572744B657950617373776F72642E310A0A706F6F6C2E6D61784163746976650A33320A706F6F6C2E6D617849646C650A380A706F6F6C2E6D61785761697454696D654D696C6C69730A2D310A706F6F6C2E6D696E457669637461626C6549646C6554696D654D696C6C69730A3330303030300A706F6F6C2E74696D654265747765656E4576696374696F6E52756E734D696C6C69730A3630303030300A706F6F6C2E746573746F6E626F72726F770A74727565');

INSERT INTO ARADMINMAP (DATATYPE, DESCRIPTION, KEY, KEYSCOPE, VALUE, BLOBVALUE)
        VALUES (6, 'ARWF_ISSUANCE_CONFIGS', 'ARWF_ISSUANCE_CONFIGS', 'WebFort', null, '69737375616E63652E686F73742E310A6C6F63616C686F73740A69737375616E63652E706F72742E310A393734320A69737375616E63652E636F6E6E656374696F6E54696D656F75742E310A31303030300A69737375616E63652E7265616454696D656F75742E310A33303030300A69737375616E63652E7472616E73706F72742E310A7463700A69737375616E63652E73657276657243414365727450454D2E310A0A69737375616E63652E636C69656E74436572744B65795031322E310A0A69737375616E63652E636C69656E74436572744B657950617373776F72642E310A0A706F6F6C2E6D61784163746976650A33320A706F6F6C2E6D617849646C650A380A706F6F6C2E6D61785761697454696D654D696C6C69730A2D310A706F6F6C2E6D696E457669637461626C6549646C6554696D654D696C6C69730A3330303030300A706F6F6C2E74696D654265747765656E4576696374696F6E52756E734D696C6C69730A3630303030300A706F6F6C2E746573746F6E626F72726F770A74727565');

INSERT INTO ARADMINMAP (DATATYPE, DESCRIPTION, KEY, KEYSCOPE, VALUE, BLOBVALUE)
        VALUES (6, 'ARWF_AUTHENTICATION_CONFIGS', 'ARWF_AUTHENTICATION_CONFIGS', 'WebFort', null, '61757468656E7469636174696F6E2E686F73742E310A6C6F63616C686F73740A61757468656E7469636174696F6E2E706F72742E310A393734320A61757468656E7469636174696F6E2E636F6E6E656374696F6E54696D656F75742E310A31303030300A61757468656E7469636174696F6E2E7265616454696D656F75742E310A33303030300A61757468656E7469636174696F6E2E7472616E73706F72742E310A7463700A61757468656E7469636174696F6E2E73657276657243414365727450454D2E310A0A61757468656E7469636174696F6E2E636C69656E74436572744B65795031322E310A0A61757468656E7469636174696F6E2E636C69656E74436572744B657950617373776F72642E310A0A706F6F6C2E6D61784163746976650A33320A706F6F6C2E6D617849646C650A380A706F6F6C2E6D61785761697454696D654D696C6C69730A2D310A706F6F6C2E6D696E457669637461626C6549646C6554696D654D696C6C69730A3330303030300A706F6F6C2E74696D654265747765656E4576696374696F6E52756E734D696C6C69730A3630303030300A706F6F6C2E746573746F6E626F72726F770A74727565');

INSERT INTO ARADMINMAP (DATATYPE, DESCRIPTION, KEY, KEYSCOPE, VALUE, BLOBVALUE)
        VALUES (6, 'ARWF_SERVERMANAGEMENT_CONFIGS', 'ARWF_SERVERMANAGEMENT_CONFIGS', 'WebFort', null, '7365727665726D616E6167656D656E742E686F73742E310A6C6F63616C686F73740A7365727665726D616E6167656D656E742E706F72742E310A393734330A7365727665726D616E6167656D656E742E636F6E6E656374696F6E54696D656F75742E310A31303030300A7365727665726D616E6167656D656E742E7265616454696D656F75742E310A33303030300A7365727665726D616E6167656D656E742E7472616E73706F72742E310A7463700A7365727665726D616E6167656D656E742E73657276657243414365727450454D2E310A0A7365727665726D616E6167656D656E742E636C69656E74436572744B65795031322E310A0A7365727665726D616E6167656D656E742E636C69656E74436572744B657950617373776F72642E310A0A706F6F6C2E6D61784163746976650A33320A706F6F6C2E6D617849646C650A380A706F6F6C2E6D61785761697454696D654D696C6C69730A2D310A706F6F6C2E6D696E457669637461626C6549646C6554696D654D696C6C69730A3330303030300A706F6F6C2E74696D654265747765656E4576696374696F6E52756E734D696C6C69730A3630303030300A706F6F6C2E746573746F6E626F72726F770A74727565');

INSERT INTO ARADMINMAP (DATATYPE, DESCRIPTION, KEY, KEYSCOPE, VALUE)
        VALUES (0, 'ARWF_PRIMARY_SERVERMANAGEMENT', 'ARWF_PRIMARY_SERVERMANAGEMENT', 'WebFort', 'http://localhost:9743');

--- Insert for RiskFort Connectivity Screen ----
INSERT INTO ARADMINMAP (DATATYPE,DESCRIPTION,KEY,KEYSCOPE,VALUE,BLOBVALUE) VALUES (6,'ARRF_ADMIN_CONFIGS','ARRF_ADMIN_CONFIGS','RiskFort',null, '7269736B666F727461646D696E706F6F6C2E686F73742E310A6C6F63616C686F73740A7269736B666F727461646D696E706F6F6C2E706F72742E310A373737370A7269736B666F727461646D696E706F6F6C2E636F6E6E656374696F6E54696D656F75742E310A31303030304C0A7269736B666F727461646D696E706F6F6C2E7265616454696D656F75742E310A33303030304C0A7269736B666F727461646D696E706F6F6C2E7472616E73706F72742E310A7463700A7269736B666F727461646D696E706F6F6C2E73657276657243414365727450454D2E310A0A7269736B666F727461646D696E706F6F6C2E636C69656E74436572744B65795031322E310A0A7269736B666F727461646D696E706F6F6C2E636C69656E74436572744B657950617373776F72642E310A0A706F6F6C2E6D61784163746976650A33320A706F6F6C2E6D617849646C650A380A706F6F6C2E6D61785761697454696D654D696C6C69730A2D314C0A706F6F6C2E6D696E457669637461626C6549646C6554696D654D696C6C69730A3330303030304C0A706F6F6C2E74696D654265747765656E4576696374696F6E52756E734D696C6C69730A3630303030304C');

INSERT INTO ARADMINMAP (DATATYPE,DESCRIPTION,KEY,KEYSCOPE,VALUE,BLOBVALUE) VALUES (6,'ARRF_CASEMGMT_CONFIGS','ARRF_CASEMGMT_CONFIGS','RiskFort',null, '7266636173656d676d74706f6f6c2e7265616454696d656f75742e310a33303030304c0a7266636173656d676d74706f6f6c2e636c69656e74436572744b65795031322e310a0a706f6f6c2e6d617849646c650a380a706f6f6c2e74696d654265747765656e4576696374696f6e52756e734d696c6c69730a3630303030304c0a7266636173656d676d74706f6f6c2e73657276657243414365727450454d2e310a0a7266636173656d676d74706f6f6c2e706f72742e310a373737390a706f6f6c2e6d61785761697454696d654d696c6c69730a2d314c0a7266636173656d676d74706f6f6c2e686f73742e310a6c6f63616c686f73740a7266636173656d676d74706f6f6c2e636c69656e74436572744b657950617373776f72642e310a0a706f6f6c2e6d696e457669637461626c6549646c6554696d654d696c6c69730a3330303030304c0a7266636173656d676d74706f6f6c2e7472616e73706f72742e310a7463700a706f6f6c2e6d61784163746976650a33320a7266636173656d676d74706f6f6c2e636f6e6e656374696f6e54696d656f75742e310a31303030304c');

INSERT INTO ARADMINMAP (DATATYPE,DESCRIPTION,KEY,KEYSCOPE,VALUE,BLOBVALUE) VALUES (6,'ARRF_SERVERMANAGEMENT_CONFIGS','ARRF_SERVERMANAGEMENT_CONFIGS','RiskFort',null, '7365727665726d616e6167656d656e742e3130342e310a52462e7b6c6f63616c686f73747d2e7b433a5c50524f4752414d2046494c45532028583836295c4152434f542053595354454d537d0a7365727665726d616e6167656d656e742e686f73742e310a6c6f63616c686f73740a7365727665726d616e6167656d656e742e706f72742e310a373938300a7365727665726d616e6167656d656e742e636f6e6e656374696f6e54696d656f75742e310a31303030304c0a7365727665726d616e6167656d656e742e7265616454696d656f75742e310a33303030304c0a7365727665726d616e6167656d656e742e7472616e73706f72742e310a7463700a7365727665726d616e6167656d656e742e73657276657243414365727450454d2e310a0a7365727665726d616e6167656d656e742e636c69656e74436572744b65795031322e310a0a7365727665726d616e6167656d656e742e636c69656e74436572744b657950617373776f72642e310a0a7365727665726d616e6167656d656e742e3130342e320a434d2e7b6c6f63616c686f73747d2e7b433a5c50524f4752414d2046494c45532028583836295c4152434f542053595354454d537d0a7365727665726d616e6167656d656e742e686f73742e320a6c6f63616c686f73740a7365727665726d616e6167656d656e742e706f72742e320a373738300a7365727665726d616e6167656d656e742e636f6e6e656374696f6e54696d656f75742e320a31303030304c0a7365727665726d616e6167656d656e742e7265616454696d656f75742e320a33303030304c0a7365727665726d616e6167656d656e742e7472616e73706f72742e320a7463700a7365727665726d616e6167656d656e742e73657276657243414365727450454d2e320a0a7365727665726d616e6167656d656e742e636c69656e74436572744b65795031322e320a0a7365727665726d616e6167656d656e742e636c69656e74436572744b657950617373776f72642e320a0a706f6f6c2e6d61784163746976650a33320a706f6f6c2e6d617849646c650a380a706f6f6c2e6d61785761697454696d654d696c6c69730a2d314c0a706f6f6c2e6d696e457669637461626c6549646c6554696d654d696c6c69730a3330303030304c0a706f6f6c2e74696d654265747765656e4576696374696f6e52756e734d696c6c69730a3630303030304c');

commit;

Now go ahead and start the services in this order -

1. Start the Strong Auth service.
2. Start the Risk Auth service.
3. Start the application server.

Login to Admin console with Master Admin privileges and then update the entries in Strong Auth connectivity screen and Risk Auth connectivity screens and you will see only the instances which are supposed to be seen and all old references will be removed.