Complete cleanup of the old instances from the Admin console

book

Article ID: 209129

calendar_today

Updated On:

Products

CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)

Issue/Introduction

We are seeing old instances in the Admin console but not the new ones, provide the steps to do the clean up.

Environment

Release : 9.1

Component : AuthMinder(Arcot WebFort)

RiskMinder ( Arcot RiskFort)

Resolution

This article has the complete steps for the Instance cleanup, 

Follow these steps to clear the Strong Auth instance.

Note -> Stop the application server, Strong Auth server instance and Risk server Instances.

1. 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.

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

Follow these instructions to remove the Risk server instances. 

1. Connect to Risk Auth database.

2. Run below query to remove RA instance:

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

Or you can delete the complete entries from this table and once the services are started they will be entered again.

3. 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';

Follow these instructions to remove the Admin and UDS instances .

1. Connect to the Strong Auth and Risk Auth database.
2. 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.