SSL Connection for Mysql using Mysql JDBC Connector

I'm trying to connect a JS AWS instance to a mysql server in a VPC on another subnet. I've installed the necessary certificates on the server and have verified that I can connect to the mysql server from the command line. However, I am not able to connect to the server from the connection wizard in the Jaspersoft Server's web interface.

I've read up on and have attempted creating a keystore and truststore, but I don't know where in the Jaspersoft or Tomcat configuration to set the parameters necessary to use those stores. When I try connecting even with the ?usessl=true flag set, I get permission denied (since the server is requiring SSL). 

Can anyone provide me some hints on setting this up? Many thanks.

ben_19's picture
Joined: Apr 8 2015 - 2:12pm
Last seen: 8 years 5 months ago

0 Answers:

No answers yet