esstokes1
Enthusiast
Enthusiast

mysql jdbc workflow

Jump to solution

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?

0 Kudos
1 Solution

Accepted Solutions
Burke-
VMware Employee
VMware Employee

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?

If my answer resolved or helped you, please mark it as Correct or Helpful to award points. Thank you! Visit http://www.vcoteam.info & http://blogs.vmware.com/orchestrator for vRealize Orchestrator tips and tutorials - @TechnicalValues on Twitter

View solution in original post

0 Kudos
5 Replies
Burke-
VMware Employee
VMware Employee

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

If my answer resolved or helped you, please mark it as Correct or Helpful to award points. Thank you! Visit http://www.vcoteam.info & http://blogs.vmware.com/orchestrator for vRealize Orchestrator tips and tutorials - @TechnicalValues on Twitter
0 Kudos
Burke-
VMware Employee
VMware Employee

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

If my answer resolved or helped you, please mark it as Correct or Helpful to award points. Thank you! Visit http://www.vcoteam.info & http://blogs.vmware.com/orchestrator for vRealize Orchestrator tips and tutorials - @TechnicalValues on Twitter
0 Kudos
esstokes1
Enthusiast
Enthusiast

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

0 Kudos
Burke-
VMware Employee
VMware Employee

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?

If my answer resolved or helped you, please mark it as Correct or Helpful to award points. Thank you! Visit http://www.vcoteam.info & http://blogs.vmware.com/orchestrator for vRealize Orchestrator tips and tutorials - @TechnicalValues on Twitter

View solution in original post

0 Kudos
esstokes1
Enthusiast
Enthusiast

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

0 Kudos