AnsweredAssumed Answered

HTTPS authentication error

Question asked by YK Park Employee on May 27, 2018
Latest reply on Jun 17, 2018 by YK Park

Hi.

 

Recently I upgraded Pentaho 7.0 to Pentaho 8.0.

The transformation that I used worked well in 7.0 PDI, however this issue occurs from 8.0.

 

Mainly transformation is to communicate with HCI server using HCI REST API.

First step is getting authentication token. Since HCI use "https", I downloaded certificate into my local machine and registered into JAVA using keytool at pentaho directory.

 

For transformation detail, please refer to my blog.

Calling HCI REST API from Pentaho Kettle

 

The error that I am facing right now as follows.

2018/05/28 14:51:34 - Auth API.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Because of an error, this step can't continue:

2018/05/28 14:51:34 - Auth API.0 - Can not result from [https://10.1.1.27:8000/auth/oauth/]

2018/05/28 14:51:34 - Auth API.0 - javax.net.ssl.SSLException: Certificate for <10.1.1.27> doesn't match common name of the certificate subject: hci-temporary-cert

2018/05/28 14:51:34 - Auth API.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : org.pentaho.di.core.exception.KettleException:

2018/05/28 14:51:34 - Auth API.0 - Can not result from [https://10.1.1.27:8000/auth/oauth/]

2018/05/28 14:51:34 - Auth API.0 - javax.net.ssl.SSLException: Certificate for <10.1.1.27> doesn't match common name of the certificate subject: hci-temporary-cert

2018/05/28 14:51:34 - Auth API.0 -

2018/05/28 14:51:34 - Auth API.0 - at org.pentaho.di.trans.steps.rest.Rest.callRest(Rest.java:262)

2018/05/28 14:51:34 - Auth API.0 - at org.pentaho.di.trans.steps.rest.Rest.processRow(Rest.java:492)

2018/05/28 14:51:34 - Auth API.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)

2018/05/28 14:51:34 - Auth API.0 - at java.lang.Thread.run(Unknown Source)

2018/05/28 14:51:34 - Auth API.0 - Caused by: com.sun.jersey.api.client.ClientHandlerException: javax.net.ssl.SSLException: Certificate for <10.1.1.27> doesn't match common name of the certificate subject: hci-temporary-cert

2018/05/28 14:51:34 - Auth API.0 - at com.sun.jersey.client.apache4.ApacheHttpClient4Handler.handle(ApacheHttpClient4Handler.java:187)

2018/05/28 14:51:34 - Auth API.0 - at com.sun.jersey.api.client.Client.handle(Client.java:652)

2018/05/28 14:51:34 - Auth API.0 - at com.sun.jersey.api.client.WebResource.handle(WebResource.java:682)

2018/05/28 14:51:34 - Auth API.0 - at com.sun.jersey.api.client.WebResource.access$200(WebResource.java:74)

2018/05/28 14:51:34 - Auth API.0 - at com.sun.jersey.api.client.WebResource$Builder.post(WebResource.java:570)

2018/05/28 14:51:34 - Auth API.0 - at org.pentaho.di.trans.steps.rest.Rest.callRest(Rest.java:185)

2018/05/28 14:51:34 - Auth API.0 - ... 3 more

2018/05/28 14:51:34 - Auth API.0 - Caused by: javax.net.ssl.SSLException: Certificate for <10.1.1.27> doesn't match common name of the certificate subject: hci-temporary-cert

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:185)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.conn.ssl.BrowserCompatHostnameVerifier.verify(BrowserCompatHostnameVerifier.java:62)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:153)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:115)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.conn.ssl.SSLSocketFactory.verifyHostname(SSLSocketFactory.java:580)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.conn.ssl.SSLSocketFactory.createLayeredSocket(SSLSocketFactory.java:574)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.conn.ssl.SSLSocketFactory.connectSocket(SSLSocketFactory.java:557)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.conn.ssl.SSLSocketFactory.connectSocket(SSLSocketFactory.java:414)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:180)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:326)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:610)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:445)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:835)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:118)

2018/05/28 14:51:34 - Auth API.0 - at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56)

2018/05/28 14:51:34 - Auth API.0 - at com.sun.jersey.client.apache4.ApacheHttpClient4Handler.handle(ApacheHttpClient4Handler.java:173)

2018/05/28 14:51:34 - Auth API.0 - ... 8 more

2018/05/28 14:51:34 - Auth API.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)

2018/05/28 14:51:34 - auth_test - Transformation detected one or more steps with errors.

2018/05/28 14:51:34 - auth_test - Transformation is killing the other steps!

2018/05/28 14:51:34 - auth_test - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Errors detected!

2018/05/28 14:51:34 - Spoon - The transformation has finished!!

2018/05/28 14:51:34 - auth_test - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Errors detected!

2018/05/28 14:51:34 - auth_test - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Errors detected!

Please help.

Outcomes