Install advanced authentication without giving database information

Products

• CA Rapid App Security
• CA Advanced Authentication
• CA API Gateway

Issue/Introduction

How can I install advanced authentication products without giving database information during installation. 

Environment

Any strongauth, riskAuth installation on any OS

Resolution

During installation, the installer will ask for database details. At this point you can give any dummy details. When the installation is complete you have to modify below files to use the correct database details:

You have to change the below information manually: 

 

1) In arcotcommon.ini file under [arcot/db/primarydb] add the Datasource name, username of the database and the URL. For example: 

 

[arcot/db/primarydb] 

 

Datasource.1=aadsn 

AppServerConnectionPoolName.1= 

URL.1=jdbc:sqlserver://xyz.com:1433;database=aadb;selectMethod=cursor 

Username.1=aauser 

 

2) In server.xml of the application server you have to again add the database details inside the Resource tag. For example: 

 

 

<Resource name="primaryJNDI" auth="Container" type="javax.sql.DataSource" username="aauser" password="password" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://xyz.com:1433;database=aadb;selectMethod=cursor" maxWait="30000" maxActive="32" maxIdle="4" initialSize="4" timeBetweenEvictionRunsMillis="600000" minEvictableIdleTimeMillis="600000"/> 

 

3) odbc.ini file will be under odbc32v70wf folder. You will need to open this file and add the dsn details here as well. For example: 

 

[aadsn] 

ConnectionRetryDelay=3 

ConnectionRetryCount=0 

Database=aadb-183274 

SnapshotSerializable=0 

LoadBalancing=0 

ReportDateTimeType=1 

Server=xyz.com 

HostName=arcotSERVERcom 

ReportCodepageConversionErrors=0 

Driver=/opt/arcot/odbc32v70wf/lib/WFsqls26.so 

FetchTWFSasTime=0 

FetchTSWTZasTimestamp=0 

AnsiNPW=Yes 

Address=sudaw01-u178832.ca.com,1433 

QuotedId=No 

PortNumber=1433 

 

4) You need to update the securestore.enc file using the dbutil command. 

The dbutil tool is placed under ARCOT_HOME/tools/linux. 

 

Below is the link that will help you provide the details of DButil command. 

"https://docops.ca.com/ca-advanced-authentication/8-0/EN/administrating/administrating-ca-strong-authentication/system-administrators-utilities/dbutil-ca-strong-authentication-database-utility/the-dbutil-utility-options" 

 

The above settings are for sqlServer. There shouldn't be much difference in these settings. 

 

4) Create a dsn from by using the "odbcad32" application which is under windows/SysWOW64. For this open the odbcad32>click system DSN tab > Click Add > Then from the list select "CA Advanced Authentication SQL server wire protocol"