[resolved] https support in tFileFetch

[Anonymous]

I am trying to download some CSV file from a website which only supports download via https. The error message I am getting in tFileFetch, and the lack of any settings for SSL support in tFileFetch, lead me to believe that this is not supported. Am I missing something?
Exception in component tFileFetch_1
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at com.sun.net.ssl.internal.ssl.Alerts.getSSLException(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Unknown Source)
at com.sun.net.ssl.internal.ssl.ClientHandshaker.serverCertificate(Unknown Source)
at com.sun.net.ssl.internal.ssl.ClientHandshaker.processMessage(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.processLoop(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.process_record(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.writeRecord(Unknown Source)
at com.sun.net.ssl.internal.ssl.AppOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at org.apache.commons.httpclient.HttpConnection.flushRequestOutputStream(HttpConnection.java:827)
at org.apache.commons.httpclient.HttpMethodBase.writeRequest(HttpMethodBase.java:1975)
at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:993)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:397)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
at jfof.bnp2bbg_0_1.BNP2BBG.tFileFetch_1Process(BNP2BBG.java:241)
at jfof.bnp2bbg_0_1.BNP2BBG.runJobInTOS(BNP2BBG.java:479)
at jfof.bnp2bbg_0_1.BNP2BBG.main(BNP2BBG.java:367)
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.validator.PKIXValidator.doBuild(Unknown Source)
at sun.security.validator.PKIXValidator.engineValidate(Unknown Source)
at sun.security.validator.Validator.validate(Unknown Source)
at com.sun.net.ssl.internal.ssl.X509TrustManagerImpl.validate(Unknown Source)
at com.sun.net.ssl.internal.ssl.X509TrustManagerImpl.checkServerTrusted(Unknown Source)
at com.sun.net.ssl.internal.ssl.X509TrustManagerImpl.checkServerTrusted(Unknown Source)
... 20 more
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(Unknown Source)
at java.security.cert.CertPathBuilder.build(Unknown Source)
... 26 more

[Anonymous · Accepted solution]

Hello guy
Please try the exchange component: tWebDavGet provided by jsd03, it support https connection.
Note that, if you would install it on TOS3.1.X or greater, you need modify two places:
1)Open tWebDavGet_messages.properties and remove this line: FAMILY=Internet
2)Open tWebDavGet_java.xml and add the <FAMILIES> parameter between <HEARDER> and <DOCUMENTATION>:
</HEADER>
<FAMILIES>
<FAMILY>Internet</FAMILY>
</FAMILIES>
<DOCUMENTATION>
<URL/>
</DOCUMENTATION>
Best regards

shong

[Anonymous]

Thanks - that works great. It would be really helpful for beginners such as myself to have information about where to install plugins (TOS-Win32-r30698-V3.2.0\plugins\org.talend.designer.components.localprovider_3.2.0.r30698\components) more readily available in the documentation. It took me almost an hour to figure that out.

[Anonymous]

Hi
I had a problem of not being able to find tWebDavGet using TIS until I placed it only here:
C:\TIS_TE-All-r19980-V3.0.1\plugins\org.talend.designer.components.tisprovider_3.0.1.r19980\components\tWebDavGet
thanks for the previous posts to get me here, since I couldn't find any documentation on how to install it!
bob