When trying to connect to a MySQL database in vRealize Orchestrator, you will get an error like
no suitable driver found.
First, ssh into your appliance and see the version:
Download your version of mysql from the links in the KB above. I chose the platform independent version
- Copy the
/usr/lib/vco/app-server/libdirectory on the Orchestrator server.
1 2 3 4 5 6 7 8 9 10
# copy from my machine to vro machine scp /mnt/c/scripts/mysql-connector-java-5.1.47.jar root@vra03:/root/tmp/mysql-connector-java-5.1.47.jar # move to correct dir mv /root/tmp/mysql-connector-java-5.1.47.jar /usr/lib/vco/app-server/lib/mysql-connector-java-5.1.47.jar # change the ownership of the mysql-connector-java-x.x.x.jar file. chown vco:vco mysql-connector-java-5.1.47.jar # change the permissions of the mysql-connector-java-5.1.47.jar. chmod 644 mysql-connector-java-x.x.x.jar # restart the Orchestrator server service. service vco-server restart
- Copy the
After this, I still got the same error when trying to add a mysql server, this was fixed by copying the same file to all 3 nodes! So if you have the VRA cluster setup, copy the mysql connector to all three nodes and restart the service on each. After that, I just had to make sure my SQL user I was connecting with had access rights to add a database.