SSL encryption for new JasperReports Server installations

If you want to install JasperReports Server from scratch and your database connections requires additional certificate settings, you have to perform an extra step compared to the standard installation procedure.

More specifically, you have to configure the following files before you run the /js-install.bat minimal command. You can find them in the buildomatic folder of your JasperReports Server installation:
  • default_master.properties: follow the instructions in the standard procedure when configuring this file. Make sure that you have defined the correct host and port for your secured connection.
  • conf_source\db\sqlserver\db.template.properties: modify lines 10-13 and specify the additional Oracle Wallet settings as in the following example:
    admin.jdbcUrl=jdbc:tibcosoftware:sqlserver://<dbHost>;sendTimestampEscapeAsString=false;EncryptionMethod=SSL;TrustStore=<path-to-certificate>\/<certificate-name>.<certificate-extension>;TrustStorePassword=<truststore-password>
    js.jdbcUrl=jdbc:tibcosoftware:sqlserver://<dbHost>;databaseName=<js.dbName>;sendTimestampEscapeAsString=false;EncryptionMethod=SSL;TrustStore=<path-to-certificate>\/<certificate-name>.<certificate-extension>;TrustStorePassword=<truststore-password>
    sugarcrm.jdbcUrl=jdbc:tibcosoftware:sqlserver://<dbHost>;databaseName=<sugarcrm.dbName>;sendTimestampEscapeAsString=false;EncryptionMethod=SSL;TrustStore=<path-to-certificate>\/<certificate-name>.<certificate-extension>;TrustStorePassword=<truststore-password>
    foodmart.jdbcUrl=jdbc:tibcosoftware:sqlserver://<dbHost>;databaseName=<foodmart.dbName>;sendTimestampEscapeAsString=false;EncryptionMethod=SSL;TrustStore=<path-to-certificate>\/<certificate-name>.<certificate-extension>;TrustStorePassword=<truststore-password>
    In this case:
    • <dbHost> is the fully qualified domain name of your database server
    • <js.dbName> is the name of your JasperReports Server database
    • <path-to-certificate> is the path to your TrustStore certificate; for example, C:\/WorldServer\/SQL_Certificate
    • <certificate-name> is the name of your certificate; for example, sql_cert
    • <certificate-extension> is the extension of your certificate file; for example, .pfx
    • <truststore-password> is the password used to access the certificate file