Abiquo 5.1

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

 

Table of Contents

Background

If JasperReports Server is not configured to work with SSL and your Abiquo platform uses SSL connections, you will get the following error when logging in to JasperReports as an Abiquo user:

Invalid credentials supplied. 

Could not login to JasperReports Server.

 

Trust the certificates on JasperReports Server's Tomcat 

Next you need to trust the certificates on JasperReports Server's Tomcat server so that it can connect. To do this from the JasperReports Server host:

  1. Download InstallCert.zip and uncompress.
  2. Run the tool:

    Code Block
    # java InstallCert <api_IP_or_hostname>:443

    You will get output in the following format:

    Code Block
    Server sent 2 certificate(s):
    
    1 Subject CN=<api_IP_or_hostname>, O=Abiquo, L=Vilanova i la Geltru, ST=Barcelona, C=ES 
    Issuer CN=<api_IP_or_hostname>, O=Abiquo, L=Vilanova i la Geltru, ST=Barcelona, C=ES 
    sha1 76 3b 2c ef d4 c1 37 74 60 f1 68 cf a3 1f d1 42 13 e9 71 54 
    md5 f6 ba 51 d0 f8 c4 3b 41 46 5d 9c 99 72 0f df b2
    
    
    2 Subject CN=<api_IP_or_hostname>, O=Abiquo, L=Vilanova i la Geltru, ST=Barcelona, C=ES 
    Issuer CN=<api_IP_or_hostname>, O=Abiquo, L=Vilanova i la Geltru, ST=Barcelona, C=ES 
    sha1 76 3b 2c ef d4 c1 37 74 60 f1 68 cf a3 1f d1 42 13 e9 71 54 
    md5 f6 ba 51 d0 f8 c4 3b 41 46 5d 9c 99 72 0f df b2
    
    
    Enter certificate to add to trusted keystore or 'q' to quit: [1]
    Tip

    Note that certificate CN needs to match whatever you configured in "abiquoURL" in Jasper.

    Run the tool as many times as needed to import every certificate the server is presenting (run the tool again and enter a different number to add a different certificate). This will add all certificates presented by the server to a java keystore in your working directory named jscacerts. 

     

  3. Next import it into the default java keystore that Tomcat uses:

    Code Block
    # /usr/java/default/bin/keytool -importkeystore -srckeystore jssecacerts -destkeystore /opt/jasperreports-server-cp-5.5.0/java/jre/lib/security/cacerts -srcstorepass changeit -deststorepass changeit
  4. Then restart JasperReports Server

    Code Block
    /opt/jasperreports-server-cp-5.5.0/ctlscript.sh restart