AnsweredAssumed Answered

Pentaho ETL - How to ignore HTTPS error

Question asked by maneesh m on Feb 6, 2019
Latest reply on Feb 22, 2019 by maneesh m

Hi,

I am developing an ETL using Pentaho Data Integration to get data from Solarwinds to another software. I am using Rest Client step in the ETL to get data from Solarwinds' https endpoint. Because it is a self signed certificate on Solarwinds, I am getting the following error.

Is there a way to ignore the error in Pentaho, at least during the development phase?

ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : Because of an error, this step can't continue:
Can not result from [https://xx.xxx.xx.xxx:17778/SolarWinds/InformationService/v3/Json/Query?query=SELECT+NodeID,IPAddress,Description,SysName,CPULoad,NodeName+FROM+Orion.Nodes+where+CPULoad%3E=0]
java.net.ConnectException: Connection refused: connect
ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : org.pentaho.di.core.exception.KettleException:
Can not result from [https://xx.xxx.xx.xxx:17778/SolarWinds/InformationService/v3/Json/Query?query=SELECT+NodeID,IPAddress,Description,SysName,CPULoad,NodeName+FROM+Orion.Nodes+where+CPULoad%3E=0]
java.net.ConnectException: Connection refused: connect

at org.pentaho.di.trans.steps.rest.Rest.callRest(Rest.java:256)
at org.pentaho.di.trans.steps.rest.Rest.processRow(Rest.java:453)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.sun.jersey.api.client.ClientHandlerException: java.net.ConnectException: Connection refused: connect
at com.sun.jersey.client.apache4.ApacheHttpClient4Handler.handle(ApacheHttpClient4Handler.java:187)
at com.sun.jersey.api.client.filter.HTTPBasicAuthFilter.handle(HTTPBasicAuthFilter.java:105)
at com.sun.jersey.api.client.Client.handle(Client.java:652)
at com.sun.jersey.api.client.WebResource.handle(WebResource.java:682)
at com.sun.jersey.api.client.WebResource.access$200(WebResource.java:74)
at com.sun.jersey.api.client.WebResource$Builder.get(WebResource.java:509)
at org.pentaho.di.trans.steps.rest.Rest.callRest(Rest.java:179)
... 3 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at org.apache.http.conn.ssl.SSLSocketFactory.connectSocket(SSLSocketFactory.java:542)
at org.apache.http.conn.ssl.SSLSocketFactory.connectSocket(SSLSocketFactory.java:414)
at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:180)
at org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:326)
at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:610)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:445)
at org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:835)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:72)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56)
at com.sun.jersey.client.apache4.ApacheHttpClient4Handler.handle(ApacheHttpClient4Handler.java:171)
... 9 more

Outcomes