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 http://dev.mysql.com/doc/connector-j/en/connector-j-reference-using-ssl.... 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.