search

retrievercommunications / docker-jasperserver

Docker image for the community edition of JasperReports® Server.
https://hub.docker.com/r/retriever/jasperserver/
MIT License
46 stars 50 forks source link

enable SSL #39

Open finosyspk opened 3 years ago

finosyspk commented 3 years ago

How to enable ssl for mysql connections

grange74 commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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.