Enable Support for MySQL Databases via SQL Plugin on VCO Appliance 5.1.1

[slahy]

Hi

I am trying to connect to a mysql database from a workflow using the SQL plugin 1.1.0 . Every time I run the Add Database workflow I get the following error

"java.lang.IllegalArgumentException: The driver 'com.mysql.jdbc.Driver' for 'MySQL' database cannot be found! (Dynamic Script Module name : addDatabase#8)"

I have found some documentation on enabling this in windows just not on the appliance. I have tried placing the jar file in

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

But I still get the error.

How do I instal this driver ?

Thanks.

[Burke- · Accepted solution]

When you placed the mySQL driver on your appliance, did you make sure to set permissions on the file properly? it should be owned by the vco user and vco group. The following commands should be issued from the /opt/vmo/app-server/server/vmo/lib/ext directory:

chown vco.vco *.jar

And:

chmod 640 *.jar

[slahy]

That did the job Burke, Thanks very much.