Jaspersoft Studio - Connect to SSL enabled Server

book

Article ID: 138877

calendar_today

Updated On:

Products

STARTER PACK-CLARITY PPM Clarity PPM SaaS

Issue/Introduction

You cannot directly connect Jaspersoft Studio to SSL enabled Jaspersoft Server until you import the SSL Certificates into your studio installation directory.


Cause

Jaspersoft Studio uses a specific holder for its security certificate.

Environment

Component : Clarity PPM/Jaspersoft SAAS APPLICATION

Resolution

Customer needs to import the certificate into Jaspersoft Studio Professional-7.1.0.final\features\jre.win32.win32.x86_64.feature_1.8.0.u151\jre\lib\security directory, the user will be able to make HTTPS calls to the server and connect successfully.

Additional Information

How to download the certificates from the client website.

<Chrome Browser> as example: 

1. Visit https://cppmXXXX.ondemand.ca.com 

2. Hit F12 (Developer Tools) -> Click the - Security Tab -> Click on View Certificate and navigate to certification path to view All required certificates that are required to make connection (for some customers root and intermediate will be different to the ones from OD)

3. On Pop-up Window -> Click Details Tab -> then Copy to File -> Click Next and take the default option (DER) -> give it a filename <example: ondemand.cer> -> save it to folder


- Close any Studio instance that is open and running

- Open the studio installation directory in command prompt (folder similar to <local jaspersoft installation directory>\features\jre.win32.win32.x86_64.feature_1.8.0.u151\jre\bin)

- Run the following command:

keytool -import -alias <alliasname> -keystore "<local jaspersoft installation directory>\features\jre.win32.win32.x86_64.feature_1.8.0.u151\jre\lib\security\cacerts" -file <path of the certificate>\abc.cer

<aliasname>: Any name that you want to give for the certificate

<path of the certificate> : Location where your certificates are saved on your desktop

abc.cer: Name of the certificate

- Enter password as "changeit"

- Run the above command for all the certificates

- Open Studio and connect to Jasper Server


Examples

Add Keystore:

"C:\Program Files\TIBCO\Jaspersoft Studio Professional-7.1.0.final\features\jre.win32.win32.x86_64.feature_1.8.0.u151\jre\bin\keytool" -import -keystore "C:\Program Files\TIBCO\Jaspersoft Studio Professional-7.1.0.final\features\jre.win32.win32.x86_64.feature_1.8.0.u151\jre\lib\security\cacerts" -file "C:\certs\ca_on_demand2.cer" -alias ca_on_demand -trustcacerts

Delete keystore:

"C:\Program Files\TIBCO\Jaspersoft Studio Professional-7.1.0.final\features\jre.win32.win32.x86_64.feature_1.8.0.u151\jre\bin\keytool" -delete -keystore "C:\Program Files\TIBCO\Jaspersoft Studio Professional-7.1.0.final\features\jre.win32.win32.x86_64.feature_1.8.0.u151\jre\lib\security\cacerts" -alias ca_on_demand -storepass changeit


Create a backup copy of the default certs file

For example: Copy the file in jre\lib\security\cacerts to cacerts.bak

This file can copied back in place if necessary