enable SSL

[finosyspk]

How to enable ssl for mysql connections

[grange74]

If this for the jasperserver database or a mysql datasource or both?
Do you have relevant documentation that shows how to do it outside of a container?

[finosyspk]

Hi,
This is for jasperserver database.
Actually, I was attempting to deploy jasperserver container on Azure App Services with external jasperserver database on Azure MySQL, but it was failing to connect due to SSL. I disabled SSL on MySQL and it is working fine now,

I wonder if there is some option to add SSL to jasperserver so I can use my db with ssl.

[grange74]

Ok, that makes sense.

Not sure about the full solution but it probably involves changing the JDBC url for MySQL similar to this SQL server article:
https://community.jaspersoft.com/wiki/how-install-tibco-jasperreports-server-ssl-enabled-sql-server-database

Currently we do similar substitutions of the properties in the master.properties on line 13 of the entrypoint.sh script before we run the jasperserver bootstrap scripts on line 24
https://github.com/retrievercommunications/docker-jasperserver/blob/master/entrypoint.sh#L13

Hope this helps.