Select the Database tab of the Configuration page to configure the database connection

Mandatory: Yes

Driver

The driver for connecting to the database.

Driver

Database Management System

oracle

Oracle SQL

postgres

​PostgreSQL

sqlserver

Microsoft SQL Server

See Database requirements for the supported DBMS versions.

Mandatory: Yes.

JDBC URL

The JDBC URL to connect to the database when Driver is oracle. For example, to connect with a database hosted in multiple Oracle nodes:

(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=yes)(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host1.domain.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2.domain.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ServiceName)))

Do not include the following prefix in the parameter value:

jdbc:oracle:thin:@

Mandatory: database connection settings support the following combinations.

Driver

Database name

Host

​Port

JDBC URL

​oracle

(tick)

(tick)

(tick)

(error)

oracle

(error)

(error)

(error)

(tick)

postgres

(tick)

(tick)

(tick)

(error)

sqlserver

(tick)

(tick)

(tick)

(error)

Remove any unnecessary parameters.

Host

The IP address or hostname of the database host.

Mandatory: database connection settings support the following combinations.

Driver

Database name

Host

​Port

JDBC URL

​oracle

(tick)

(tick)

(tick)

(error)

oracle

(error)

(error)

(error)

(tick)

postgres

(tick)

(tick)

(tick)

(error)

sqlserver

(tick)

(tick)

(tick)

(error)

Remove any unnecessary parameters.

Port

The TCP port where the database listens.

Mandatory: database connection settings support the following combinations.

Driver

Database name

Host

​Port

JDBC URL

​oracle

(tick)

(tick)

(tick)

(error)

oracle

(error)

(error)

(error)

(tick)

postgres

(tick)

(tick)

(tick)

(error)

sqlserver

(tick)

(tick)

(tick)

(error)

Remove any unnecessary parameters.

Database name

The same value assigned to the DBNAME parameter when Setting the variables of the Validation Authority database scripts.

Mandatory: database connection settings support the following combinations.

Driver

Database name

Host

​Port

JDBC URL

​oracle

(tick)

(tick)

(tick)

(error)

oracle

(error)

(error)

(error)

(tick)

postgres

(tick)

(tick)

(tick)

(error)

sqlserver

(tick)

(tick)

(tick)

(error)

Remove any unnecessary parameters.

OCSP Responder User

The same user identifier assigned to the OCSPRESPONDER_DB_USER parameter when Setting the variables of the Validation Authority database scripts.

Mandatory: Yes.

OCSP Responder password

The same password assigned to the OCSPRESPONDER_DB_PASSWORD parameter when Setting the variables of the Validation Authority database scripts.  

Mandatory: Yes.

Status Feeder User

The same user identifier assigned to the STATUSFEEDER_DB_USER parameter when Setting the variables of the Validation Authority database scripts.

Mandatory: Yes.

Status Feeder password

The same password assigned to the STATUSFEEDER_DB_PASSWORD parameter when Setting the variables of the Validation Authority database scripts

Mandatory: Yes.

Max connections

The number of maximum concurrent database connections. as an integer equal to or greater than 1.

Since three internal services of Validation Authority utilize this value, the database must support at least three times the maximum concurrent connections set by this parameter.

Mandatory: Yes.

Connection timeout

The timeout for database connections.

Mandatory: No. This optional value defaults to 5 seconds.

SSL mode

(tick)  to enable SSL security in the database connection; (error)  otherwise.

The (error) option is for testing environments only.

Mandatory: Yes.

SSL validation certificate

The CA certificate for validating the database SSL certificate.

As explained in Database SSL certificate, the SSL certificate for the database host must include the IP address or FQDN of the host.

Mandatory: When SSL mode is enable, and Driver is postgres or sqlserver. See the following table for details.

Driver

SSL mode

SSL validation certificate

​postgres

enabled​

​Click Select Files to import a file containing this certificate in PEM format and Base64 encoding.

oracle

enabled

Use the Oracle utilities to set this certificate.

sqlserver

enabled

Click Select Files to import a file containing this certificate in PEM format and Base64 encoding.