Failed: connection is not valid aborting using addjbossDatasource

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

Running addjbossDatasource identity-portal as discussed in:

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-suite/14-5/virtual-appliance/administering-virtual-appliance/using-the-login-shell.html

It fails with the below:

INFO] Adding IdentityManager datasources on host 10.0.0.1 
Adding external datasource from file /opt/CA/VirtualAppliance/custom/IdentityManager/dataSources/identity-portal on 10.0.0.1... 
[OK] successfully configured external datasource from file "/opt/CA/VirtualAppliance/custom/IdentityManager/dataSources/identity-portal" on 10.0.0.1 (return code: 0) 
================================================================================= 
[INFO] Successfully created security-domain: identity-portal 
[INFO] Successfully created datasource: identity-portal 
[WARN] The datasource was created successfully but the connection to the database failed: Connection is not valid 
[WARN] The datasource was created successfully but the connection to the database failed: Connection is not valid - Aborting... 

Environment

Release: 14.x
Component: IDSVA

Resolution

This was caused by special characters used in the database password.  You must escape each special character.  Example below.

If a password is ExamplePassword$123

This is entered as: 

DATASOURCE_NAME=identity-portal 
DB_URL=jdbc:oracle:thin:@//server.internal.domain.com:1521/Server01
DB_USER=ExampleUser
DB_PASSWORD=ExamplePassword\$123

This works. 

[INFO] Adding IdentityManager datasources on host 10.0.0.1
Adding external datasource from file /opt/CA/VirtualAppliance/custom/IdentityManager/dataSources/identity-portal on 10.0.0.1... 
[OK] successfully configured external datasource from file "/opt/CA/VirtualAppliance/custom/IdentityManager/dataSources/identity-portal" on 10.0.0.1 (return code: 0) 
================================================================================= 
[INFO] Successfully created security-domain: identity-portal 
[INFO] Successfully created datasource: identity-portal 
===============================================