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
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.
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.
Alright, thanks for the info. Hope there is a fix soon!
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.
This seems to be broken again in v8.8. Any new fix?
yes, it seems to be broken in v8.8.2. Is it already working in newer versions, e.g 8.11.1?