VMware Cloud Community
LukasWe
Enthusiast
Enthusiast
Jump to solution

vRO 8 - MySQL Database Connection

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
Jump to solution

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

5 Replies
iiliev
VMware Employee
VMware Employee
Jump to solution

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
Jump to solution

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

Reply
0 Kudos
LukasWe
Enthusiast
Enthusiast
Jump to solution

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.

jesse_cohen
Enthusiast
Enthusiast
Jump to solution

This seems to be broken again in v8.8.  Any new fix?

Reply
0 Kudos
thomas1147
Contributor
Contributor
Jump to solution

yes, it seems to be broken in v8.8.2. Is it already working in newer versions, e.g 8.11.1?

Reply
0 Kudos