topic Re: tFTPConnection not working in Talend Studio

tFTPConnection not working

DBS1 — Wed, 24 Jul 2024 06:23:39 GMT

Hi Team

I am trying to establish FTP connection using tFTPConnection component in Talend. For Authentication method, I am using 'Public key and password'. I am proving the values for hostname, port, username, password and also the path to Private key and Key passphrase as well.

I am getting the error as Invalid Private Key. I am providing the same credentials and private key in WinScp and is getting connected.
I have also tried converting the private key (ppk file) into OpenSSH key and used in tFTPConnection component, but it also didn't work.

Please help in resolving this issue.

Thanks
DBS

Re: tFTPConnection not working

quentin-vigne — Wed, 24 Jul 2024 15:06:20 GMT

Hello DBS1,

One mistake I used to do all the time was forgetting to put the path to Private key and Key passphrase between "". If you don't do it it can interpret the special characters and fail to connect

Re: tFTPConnection not working

DBS1 — Thu, 25 Jul 2024 04:09:16 GMT

Hi

Thanks for the reply.
I have already put path and passphrase under double quotes only.

Thanks

DBS

Re: tFTPConnection not working

quentin-vigne — Thu, 25 Jul 2024 07:56:38 GMT

In your original message you said you tried to use OpenSSH.

Did you try to generate the key using the command :

ssh-keygen -t rsa

Talend tFTPConnection doesn't work with Putty keys for example.

You also have the option to load the .ppk into PuttyGen, use the Conversions menu to export it in OpenSSH format (save it as yourprivatekey.ppk) and use that key instead.

Re: tFTPConnection not working

DBS1 — Thu, 25 Jul 2024 08:41:03 GMT

I have used PuttyGen to convert the ppk file into Open SSH format. I have saved the file with .ppk, .pem and .key extension and have tried as well.
In that case, I am getting the following error:

tFTPConnection_1 Auth fail for methods 'publickey,password'
com.jcraft.jsch.JSchException: Auth fail for methods 'publickey,password'
at com.jcraft.jsch.Session.connect(Session.java:532)
at com.jcraft.jsch.Session.connect(Session.java:194)

Re: tFTPConnection not working

quentin-vigne — Thu, 25 Jul 2024 08:49:40 GMT

Could you provide a screenshot of your tFTPConnection ? You can blur out any confidential information if needed

Re: tFTPConnection not working

DBS1 — Thu, 25 Jul 2024 10:21:03 GMT

Please find the below.
I have blurred the credentials. The password and the keyphrase, I have defined as context and the values are provided in the context section.

Re: tFTPConnection not working

Fabio_Caimi — Thu, 25 Jul 2024 12:06:49 GMT

Hi DBS,
which version of Talend are you using?
And how was your key generated, in terms of encryption method?

For example, if you are using Talend version 6, its Java version would be too old to support recent Ed25519 keys.

Regards,
Fabio

Re: tFTPConnection not working

DBS1 — Thu, 25 Jul 2024 12:23:04 GMT

I am using Talend Cloud data Integration Platform and the version is 8.

Thanks

DBS

Re: tFTPConnection not working

DBS1 — Thu, 25 Jul 2024 12:28:21 GMT

And also regarding the key generation. I got the ppk key from IT team and using that key it is getting connected to the FTP server via WinSCP.

For making use of the key in Talend, I have converted the ppk file into Open SSH key using PuttyGen and in type of key to generate, I have chosen SSH-1 (RSA)

Thanks

Dhanoop

Re: tFTPConnection not working

quentin-vigne — Thu, 25 Jul 2024 13:04:25 GMT

1. Do you have an HTTPS Proxy ? If so, it doesn't work, you'll have to use tSetProxy

2. Do you use the conversion menu in PuttyGen ? Don't use the buttons on the bottom to Generate a new key

Import your ".ppk" key using the "Import key" in "Conversions" menu.

Then use "Export OpenSSH key" and save it as "new.ppk"

Use this new key

Re: tFTPConnection not working

DBS1 — Thu, 25 Jul 2024 13:28:57 GMT

Hi @quentin-vigne

I am not having any HTTPS Proxy.

And for conversion, I am doing the same way as you have described above. I have tried different but nothing is working.

Thanks

DBS