Process Automation - "Please check database settings" during installation against MS SQL with SSL
search cancel

Process Automation - "Please check database settings" during installation against MS SQL with SSL

book

Article ID: 98404

calendar_today

Updated On:

Products

CA Process Automation Base Process Automation Manager

Issue/Introduction

The MS SQL database requires SSL to force encrypted connection.

However, the CA PAM installer cannot create the database or or test the database connection, as an error appears on screen:

"Setup
<X> Please check database settings.
<OK>"


Environment

CA Process Automation 4.3.x when attempting to install against a MS SQL Server with an SSL requirement.

 

Cause

In 4.3 SP2 and earlier, this is due to our deployment of a 3rd Party JDBC Driver from JTDS, which does not fully support the secure requirement.  

In 4.3 SP3 and later releases, where we support and can install using a Microsoft provided MS SQL JDBC Driver, our installer does not automatically enter the required additional configuration options, but they can be manually added on the database screens.


 

Resolution

Steps for 4.3 Sp2 and earlier.  
We have found a very narrow work around for the earlier versions of Process Automation that do not support the Microsoft JDBC Driver. This work around requires using an older JDK, specifically JDK version 1.7.02 or 1.7.03.

1. Install JDK 1.7.03

2. Begin Install of Process Automation, choosing the 1.7.03 JDK

3. On the Database Configuration screens, add to the Database Name,
";ssl=request" without quotes

For example for the Repository Database;
PAM_LIB;ssl=request

4. Click Create Database

5. Complete the other 2 database dialogs adding ";ssl=request" to each databasename, for example:
PAM_RUN;ssl=request
PAM_REP;ssl=request

6. Complete the installation

7. Open the \pam\server\c2o\.config\OasisConfig.properties file. Check the "database.additionalparamurl" settings to ensure that the ;ssl=secure parameter is set at the end of each line.
There are 3 lines in the oassiconfig file to review:

oasis.database.additionalparamurl=;responseBuffering=full;SelectMethod=cursor;MultiSubnetFailover=True;ssl=request;
oasis.reporting.database.additionalparamurl=;responseBuffering=full;SelectMethod=cursor;MultiSubnetFailover=True;ssl=request;
oasis.runtime.database.additionalparamurl=;responseBuffering=full;SelectMethod=cursor;MultiSubnetFailover=True;ssl=request;

8. Start Process Automation.
 



Steps for 4.3 Sp3 and Sp4:
1. Install JDK 1.8.162

2.  Install of Process Automation, choosing the 1.8.162 JDK

3. On the Database Configuration screens, select the MS SQL JDBC Driver "mssql-jdbc-6.1.0.jre7" from the /drivers/ folder on Disk one; add to the Database Name:
";ssl=request" without quotes.

For example for the Repository Database:
PAM_LIB;ssl=request

4. Click Create Database

5. Complete the other 2 database dialogs using the "mssql-jdbc-6.1.0.jre7" driver, adding ";ssl=request" to each databasename, for example:
PAM_RUN;ssl=request
PAM_REP;ssl=request

6. Complete the installation

7. Open the \pam\server\c2o\.config\OasisConfig.properties file. Check the "database.additionalparamurl" settings to ensure that the ;ssl=secure parameter is set at the end of each line.
There are 3 lines in the oassiconfig file to review:

oasis.database.additionalparamurl=;responseBuffering=full;SelectMethod=cursor;MultiSubnetFailover=True;ssl=request;
oasis.reporting.database.additionalparamurl=;responseBuffering=full;SelectMethod=cursor;MultiSubnetFailover=True;ssl=request;
oasis.runtime.database.additionalparamurl=;responseBuffering=full;SelectMethod=cursor;MultiSubnetFailover=True;ssl=request;

8. Start Process Automation.