"The driver 'com.mysql.jdbc.Driver' for 'XXX' database cannot be found!" error when attempting to add a database to vRO

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

• Workflows against databases fail with a similar error to the one below:

java.lang.IllegalArgumentException: The driver 'com.mysql.jdbc.Driver' for 'MySQL' database cannot be found! (Dynamic Script Module name : addDatabase#9

Environment

VMware vRealize Orchestrator 8.x

Cause

This issue occurs when vRO is unable to detect the relevant jdbc driver for the database in question.

Resolution

Before proceeding best practise dictates you first backup the vRO appliances

1. Download the required driver from the vendor website.
2. SSH to each of the vRO appliances.
3. Change directory to: /data/vco/var/run/vco
4. Run the following command to create a new directory:

mkdir -p plugins/SQL/lib

5. Place the driver into the newly created directory:

/data/vco/var/run/vco/plugins/SQL/lib

6. Open the vRO Control Center.
7. Go to System Properties.
8. Add a new property with the following details (replace <name_of_driver> with the correct name):

key = o11n.plugin.SQL.classpath
value = /var/run/vco/plugins/SQL/lib/<name_of_driver>.jar

9. Save changes and wait for the server to restart.

Additional Information

Impact/Risks:
Note: In a clustered environment the steps below will need to be performed on each node.
Note: With the Automation Orchestrator 8.18.1 release, the Control Center is removed. To configure your Automation Orchestrator deployment, use the command line interface of the appliance Please refer to 8.18.1 release notes: https://techdocs.broadcom.com/us/en/vmware-cis/aria/aria-automation/8-18/vmware-aria-automation-release-notes.html 
For solution refer to article https://knowledge.broadcom.com/external/article?articleNumber=326160