Topic
  • 6 replies
  • Latest Post - ‏2016-11-01T14:39:59Z by JeffLong
tcrochet
tcrochet
13 Posts

Pinned topic BIRT https connection through Eclipse

‏2016-05-02T10:58:07Z | birt database eclipse

Good morning,

 

I am trying to access a remote database through the Eclipse Tririga BIRT Plugin. I successfully connected to some sites using http protocols but I fail to connect to a site using https protocol. Here is the stacktrace when I test the connection:

javax.net.ssl.SSLException: java.lang.UnsupportedOperationException
 at sun.security.ssl.Alerts.getSSLException(Unknown Source)
 at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source)
 at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source)
 at sun.security.ssl.SSLSocketImpl.handleException(Unknown Source)
 at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
 at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
 at sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
 at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
 at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source)
 at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source)
 at com.tririga.platform.clientserver.client.http.HTTPClientServerCommunication.sendRequest(HTTPClientServerCommunication.java:125)
 at com.tririga.platform.birt.preferences.TririgaConnectionPreferencePage$2.run(TririgaConnectionPreferencePage.java:73)
Caused by: java.lang.UnsupportedOperationException
 at com.tririga.platform.clientserver.client.http.HTTPClientServerCommunication$TririgaTrustManager.getAcceptedIssuers(HTTPClientServerCommunication.java:58)
 at sun.security.ssl.AbstractTrustManagerWrapper.checkAlgorithmConstraints(Unknown Source)
 at sun.security.ssl.AbstractTrustManagerWrapper.checkAdditionalTrust(Unknown Source)
 at sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(Unknown Source)
 at sun.security.ssl.ClientHandshaker.serverCertificate(Unknown Source)
 at sun.security.ssl.ClientHandshaker.processMessage(Unknown Source)
 at sun.security.ssl.Handshaker.processLoop(Unknown Source)
 at sun.security.ssl.Handshaker.process_record(Unknown Source)
 at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
 at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
 ... 8 more
 

Is it currently possible to connect to an https website through the Tririga BIRT Feature or is the problem elsewhere ?

 

Current Installation on a Windows 7 64bits environment:

- Eclipse IDE for Java and Report Developers 4.5.0.20150621-1200 epp.package.reporting null (I also tried on a 4.4 version of Eclipse)

- IBM TRIRIGA BIRT Feature 1.0.1.v201405291025 com.tririga.platform.birt.feature.feature.group IBM TRIRIGA

 

  • dmazzella
    dmazzella
    152 Posts
    ACCEPTED ANSWER

    Re: BIRT https connection through Eclipse

    ‏2016-05-11T22:28:23Z  

    What platform are you running?  There was a defect  fixed in 3.4.2.1 

     

    Defect: 187424
    Description: The IBM TRIRIGA BIRT plug-in now connects with the HTTPS SSL servers for downloading the plug-in and 
    previewing reports.

  • dmazzella
    dmazzella
    152 Posts

    Re: BIRT https connection through Eclipse

    ‏2016-05-11T00:11:55Z  

    Is that a self signed https certificate?  If so, you will need to install it into your Java VM used by BIRT/Eclipse on your workstation.  There are tools out there that can help,  Google: "install self signed certificate https java"

    but we cannot support the usage or validity of the tools like Portecle

  • tcrochet
    tcrochet
    13 Posts

    Re: BIRT https connection through Eclipse

    ‏2016-05-11T09:03:21Z  
    • dmazzella
    • ‏2016-05-11T00:11:55Z

    Is that a self signed https certificate?  If so, you will need to install it into your Java VM used by BIRT/Eclipse on your workstation.  There are tools out there that can help,  Google: "install self signed certificate https java"

    but we cannot support the usage or validity of the tools like Portecle

    Thank you for you quick response.

     

    I tried adding the certificates to the cacert file of my JRE7 but the same javax.net.ssl.SSLException: java.lang.UnsupportedOperationException is thrown. I tried with multiple version of Eclipse but none is able to reach the server.

    (attached is the error log as seen in eclipse)

  • dmazzella
    dmazzella
    152 Posts

    Re: BIRT https connection through Eclipse

    ‏2016-05-11T22:28:23Z  

    What platform are you running?  There was a defect  fixed in 3.4.2.1 

     

    Defect: 187424
    Description: The IBM TRIRIGA BIRT plug-in now connects with the HTTPS SSL servers for downloading the plug-in and 
    previewing reports.

  • tcrochet
    tcrochet
    13 Posts

    Re: BIRT https connection through Eclipse

    ‏2016-05-12T14:19:36Z  

    IBM TRIRIGA BIRT Feature 1.0.1.v201405291025 com.tririga.platform.birt.feature.feature.group IBM TRIRIGA

     

    I am trying to get a more recent version for now.

  • MarkSc
    MarkSc
    32 Posts

    Re: BIRT https connection through Eclipse

    ‏2016-07-15T22:22:42Z  
    • dmazzella
    • ‏2016-05-11T22:28:23Z

    What platform are you running?  There was a defect  fixed in 3.4.2.1 

     

    Defect: 187424
    Description: The IBM TRIRIGA BIRT plug-in now connects with the HTTPS SSL servers for downloading the plug-in and 
    previewing reports.

    Is it possible to confirm this is actually fixed and working in 3.5.1 platform? I'm unable to connect (with similar errors) to an 3.5.1 site using https. Using the supported 4.3.1 eclipse. I can connect to all other 3.5.1 and http sites I have available. Using a newer 4.4 birt designer I can connect to the https site. I haven't yet tested if the tririga site will work with a report designed in this newer version or if it must be 4.3.1. But, it appears there's still an issue in 3.5.1. If so, do you know what other birt versions are supported (even if unofficially)? Thanks.

  • JeffLong
    JeffLong
    19 Posts

    Re: BIRT https connection through Eclipse

    ‏2016-11-01T14:39:59Z  
    • MarkSc
    • ‏2016-07-15T22:22:42Z

    Is it possible to confirm this is actually fixed and working in 3.5.1 platform? I'm unable to connect (with similar errors) to an 3.5.1 site using https. Using the supported 4.3.1 eclipse. I can connect to all other 3.5.1 and http sites I have available. Using a newer 4.4 birt designer I can connect to the https site. I haven't yet tested if the tririga site will work with a report designed in this newer version or if it must be 4.3.1. But, it appears there's still an issue in 3.5.1. If so, do you know what other birt versions are supported (even if unofficially)? Thanks.

    There is a known issue with 3.5.1 Platform and connecting via BIRT Plugin.  There is an APAR on this available for review here: http://www.ibm.com/support/docview.wss?crawler=1&uid=swg1IV88018

     

    We have updated the Compatibility Matrix to reflect this for Tririga Platform 3.5.1, you can find that Matrix here: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM+TRIRIGA1/page/Archive+of+IBM+TRIRIGA+Support+Matrices

     

    In short, for 3.5.1 you should use BIRT Report Designer 4.6 (Requires Java 8).