LukasWe
Enthusiast
Enthusiast

vRO 8 - MySQL Database Connection

Jump to solution

Hi all!

Has anyone already tried to connect a MySQL database via vRO 8 or 8.0.1?

Somehow I need to integrate the mysql-connector library into the container/docker image, but the docker images seem to be recreated after every reboot of the vRO appliance. The thrown exception is "No suitable driver" when i want to establish a new JDBC connection from a workflow to a MySQL database. I know from vRO 7.x that we had to copy the mysql connector jar-file manually on the appliance (see mysql configuration issues in 7.5. release notes), but this was back then way more easy than on the new Kubernetes architecture

Regards,

Lukas

1 Solution

Accepted Solutions
LukasWe
Enthusiast
Enthusiast

We've got a workaround from engineering. This should work:

NOTE: In a clustered environment the steps 1 to 4 below need to be completed on each node.

1. SSH to the vRO appliance as root
2. cd to /data/vco/var/run/vco
3. mkdir -p plugins/SQL/lib
4. Put the MySQL connector into the directory created (/data/vco/var/run/vco/plugins/SQL/lib
5. Open Orchestrator Control Center
6. Go to System Properties
7. Add a new property with the following:

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

  8. Save changes & wait for the server to restart.

This should then allow you to run workflows against your MySQL DB.

View solution in original post

3 Replies
iiliev
VMware Employee
VMware Employee

Hi,

You are right, the workaround with manually copying the MySQL connector binary that worked in 7.x is no longer directly applicable in 8.0 / 8.0.1. At the moment, this is still an open issue; we need to figure out how to fix it in some future 8.x release.

LukasWe
Enthusiast
Enthusiast

Alright, thanks for the info. Hope there is a fix soon!

0 Kudos
LukasWe
Enthusiast
Enthusiast

We've got a workaround from engineering. This should work:

NOTE: In a clustered environment the steps 1 to 4 below need to be completed on each node.

1. SSH to the vRO appliance as root
2. cd to /data/vco/var/run/vco
3. mkdir -p plugins/SQL/lib
4. Put the MySQL connector into the directory created (/data/vco/var/run/vco/plugins/SQL/lib
5. Open Orchestrator Control Center
6. Go to System Properties
7. Add a new property with the following:

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

  8. Save changes & wait for the server to restart.

This should then allow you to run workflows against your MySQL DB.