topic Re: Talend ftp connexion / Encryption in Talend Studio

Talend ftp connexion / Encryption

Anonymous — Thu, 06 Jun 2019 12:53:30 GMT

Bonjour,

implementing a new step in my talend job sending file to a third party ftp server.

The third party is asking me to encrypt the transfer "Require implicit FTP over TLS".

how to specify it in a tFTPConnection and/or tFTPPut ?

thank you for your help.

Damien

Re: Talend ftp connexion / Encryption

TRF — Thu, 06 Jun 2019 15:44:59 GMT

Tick the option "Support SFTP" on tFTPConnection or tFTPPut components

Re: Talend ftp connexion / Encryption

Anonymous — Thu, 06 Jun 2019 15:54:16 GMT

Bonjour TRF,

it's what I did ... see attached

but I have reject :

[2019-06-06 14:48] Upload file on Trax FTP :
Exception in component tFTPConnection_1
com.jcraft.jsch.JSchException: connection is closed by foreign host
at com.jcraft.jsch.Session.connect(Session.java:269)
at com.jcraft.jsch.Session.connect(Session.java:183)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tFTPConnection_1Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5626)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tLoop_1Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5421)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tWarn_7Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5248)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tWarn_6Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5128)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tWarn_3Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5017)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tWarn_2Process(APM_TRAX_ExtractActualFlights_NewFTP.java:4896)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tWarn_1Process(APM_TRAX_ExtractActualFlights_NewFTP.java:4771)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.runJobInTOS(APM_TRAX_ExtractActualFlights_NewFTP.java:6845)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.main(APM_TRAX_ExtractActualFlights_NewFTP.java:6586)
Exception in component tFTPPut_1
java.lang.NullPointerException
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tFTPPut_1Process(APM_TRAX_ExtractActualFlights_NewFTP.java:5753)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.tFTPConnection_1_error(APM_TRAX_ExtractActualFlights_NewFTP.java:609)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:376)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
2019-06-06 14:48:13|tkRRd6|tkRRd6|tkRRd6|FLIGHTS|APM_TRAX_ExtractActualFlights_NewFTP|PROD|6|Java Exception|tFTPPut_1|java.lang.NullPointerException:null|1
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP$TalendException.printStackTrace(APM_TRAX_ExtractActualFlights_NewFTP.java:364)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.runJobInTOS(APM_TRAX_ExtractActualFlights_NewFTP.java:6852)
at flights.apm_trax_extractactualflights_newftp_0_5.APM_TRAX_ExtractActualFlights_NewFTP.main(APM_TRAX_ExtractActualFlights_NewFTP.java:6586)
2019-06-06 14:48:14|tkRRd6|tkRRd6|tkRRd6|FLIGHTS|APM_TRAX_ExtractActualFlights_NewFTP|PROD|6|Java Exception|tFTPConnection_1|com.jcraft.jsch.JSchException:connection is closed by foreign host|1
[statistics] disconnected
Job APM_TRAX_ExtractActualFlights_NewFTP ended at 14:48 06/06/2019. [exit code=1]

Capture tftp1.PNG

Re: Talend ftp connexion / Encryption

TRF — Thu, 06 Jun 2019 16:25:30 GMT

Are you able to use a tool such as Filezilla to transfer your file via stfp?

This is to validate there is not a connection error due your server configuration or something like that.

Re: Talend ftp connexion / Encryption

Anonymous — Thu, 06 Jun 2019 16:43:27 GMT

Yes, it works correctly.

Status: Connection established, initializing TLS...
Status: Verifying certificate...
Status: TLS connection established, waiting for welcome message...
Status: Logged in
Status: Retrieving directory listing...
Status: Directory listing of "/" successful

Re: Talend ftp connexion / Encryption

Anonymous — Tue, 11 Jun 2019 10:47:15 GMT

So it works correctly with Filezilla, not with Talend Studio 5.6 (yes I know, I am aware that is an old version ... but we plan to migrate with the support of Talend after summer).

Any idea in the settings I should have in my tFTPConnexion or tFTPput ?

See attached filezilla inputs

filezilla ok.PNG

Re: Talend ftp connexion / Encryption

Anonymous — Fri, 14 Jun 2019 20:13:17 GMT

Starting job TestNewFTP at 19:07 14/06/2019.

[statistics] connecting to socket on port 3570
[statistics] connected
[2019-06-14 19:07] Check context before upload : PROD
java.io.FileNotFoundException:
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at flights.testnewftp_0_5.TestNewFTP$1MyTrust_tFTPConnection_1.getTrustManagers(TestNewFTP.java:4502)
at flights.testnewftp_0_5.TestNewFTP$1MyTrust_tFTPConnection_1.access$0(TestNewFTP.java:4490)
at flights.testnewftp_0_5.TestNewFTP.tFTPConnection_1Process(TestNewFTP.java:4521)
at flights.testnewftp_0_5.TestNewFTP.tWarn_6Process(TestNewFTP.java:4400)
at flights.testnewftp_0_5.TestNewFTP.runJobInTOS(TestNewFTP.java:5311)
at flights.testnewftp_0_5.TestNewFTP.main(TestNewFTP.java:5052)
Exception in component tFTPPut_1
java.lang.NullPointerException
at flights.testnewftp_0_5.TestNewFTP.tFTPPut_1Process(TestNewFTP.java:4774)
at flights.testnewftp_0_5.TestNewFTP.tWarn_1Process(TestNewFTP.java:4687)
at flights.testnewftp_0_5.TestNewFTP.tWarn_6Process(TestNewFTP.java:4418)
at flights.testnewftp_0_5.TestNewFTP.runJobInTOS(TestNewFTP.java:5311)
[2019-06-14 19:07] Etape 2:
2019-06-14 19:07:04|KZeb7v|KZeb7v|KZeb7v|FLIGHTS|TestNewFTP|PROD|6|Java Exception|tFTPPut_1|java.lang.NullPointerException:null|1
at flights.testnewftp_0_5.TestNewFTP.main(TestNewFTP.java:5052)
[statistics] disconnected
Job TestNewFTP ended at 19:07 14/06/2019. [exit code=1]

Re: Talend ftp connexion / Encryption

Anonymous — Fri, 21 Jun 2019 16:42:50 GMT

it seems that we need to use a SSL certificate to produce the requested information ...

https://community.talend.com/t5/Design-and-Development/tFTPPut-using-FTPS-Support-for-TLS-SSL-Implicit-encryption/td-p/33062

not easy ...