mysql jdbc workflow

[esstokes1]

I'm getting 'Connection to database failed (Reason: InternalError: No suitable driver' error when trying to run the JDBC connection example workflow.  We are running vCO 5.1.0 build 2725 - I thought jdbc support for mysql was already included.  Is there something else I need to configure?

[Burke-]

You'll need to download the mysql driver from Oracle... this is not included in vCO due to redistribution issues.

[Burke-]

You can find details here: http://www.vmware.com/files/pdf/techpaper/vco-experimental-dbs-openldap-support.pdf

[esstokes1]

I followed that doc but still no luck.  We deployed the vCO appliance for 5.1 - not sure if that matters.  It appears the doc is more for Windows and the paths were not the same:

VMware vCenter Orchestrator configuration interface:

/opt/vmo/configuration/jetty/lib/ext   (there is already a mysql-connector.jar file so I didn't overwrite it)

VMware vCenter Orchestrator server:

/opt/vmo/app-server/server/vmo/lib

Are these the correct paths?

Thanks

[Burke- · Accepted solution]

Yes, those are the correct paths ... I'm afraid I don't currently have any mySQL dbs accessible to me to also test this. In the past, all I had to do was place the file as specified in the doc and it all worked.. did you restart the configuration and server services? Does anything come up in your log files when you start the services that maybe indicate an issue with the mysql drivers?

[esstokes1]

I had permissions issue on the mysql-connector jar file.  Thanks