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 BaseProcess 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:
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: