Customers have requested that any DB credential related entries that are required in say server.xml should be encrypted and not be shown in clear. Hence, CA Strong Authentication version 9.0.02 addresses the security issue and removes any requirements that may lead to exposing the DB credentials in clear.
CA Strong Authenticaion version 9.0.02
1. Run the ArcotAFMWizard (which will create the arcotsm.properties in <ARCOT_HOME>\conf\afm)
2. Ensure that new arcotsm.war that is released as a part of 9.0.02 is deployed correctly (clearing any WORK and Temp folders associated with the application server of choice)
To test if the CA Statemanager is connecting to the Database
Step 1. Use the Statemanager test tool by invoking -http://hostname:port/arcotsm to bring up the Statemanager test page. Then Create a token and Read the token back.
Step #2. After a successful Token Create action using the tool mentioned in Step #1 above please verify that the Tokens are being inserted in ARTSTOKENs table. You may check the inserted row in the ARTSTOKENS table via the SQL query below. This query should return a row for the token that was inserted in Step #1.
select * from ARTSTOKENS where tsTokenId ='Povide the Token that you created in Step 1 ';
Step #3 Examine the arcotsm.log to check that no errors are reported on Create Token or Read Token as attempted in Step #1