Manual Database Setup

In case of manual DB selection, the Director Server Installer will not ask for DB details and will not run DB scripts. You have to run the DB scripts (<DirectorHome>\Server\tools\DDL) manually and update the DB details in the <Install_Path_Director_Server>/Server/application.properties file.

config to update in application.properties

The following config should be updated in application.properties in case of Manual database setup:
#DB details
spring.datasource.url=<jdbc url>
spring.datasource.username=<db username>
spring.datasource.password=<db password>
spring.datasource.driverClassName=<Database Driver>
#Hibernate Config
spring.jpa.hibernate.dialect= <Dialect>

Example

Example:

spring.datasource.url=jdbc:db2://zebra682.nonprod.hclpnp.com:50001/testdb4

spring.datasource.username=uc684

spring.datasource.password=ENC(7iWciyBkHv0lfDP6PIftwLgqxu5P8DTs)

spring.datasource.driverClassName=com.ibm.db2.jcc.DB2Driver

spring.jpa.hibernate.dialect=org.hibernate.dialect.DB2Dialect

Encrypting database and Active MQ passwords

Procedure

  1. Go to $INSTALLATION_PATH/Server/tools/bin.
  2. Run the encrypt.sh utility with the given password to encrypt the password's value.
  3. Replace that encrypted value of the password in the application.properties file manually.

Example

For example: $INSTALLATION_PATH/Server/tools/bin/encrypt.bat -p <password to encrypt>