Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
DBS1
Contributor III
Contributor III

tFTPConnection not working

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

Labels (2)
11 Replies
quentin-vigne
Partner - Contributor III
Partner - Contributor III

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

DBS1
Contributor III
Contributor III
Author

Hi

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

Thanks

DBS

quentin-vigne
Partner - Contributor III
Partner - Contributor III

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.

DBS1
Contributor III
Contributor III
Author

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)

quentin-vigne
Partner - Contributor III
Partner - Contributor III

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

DBS1
Contributor III
Contributor III
Author

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.

DBS1_1-1721902650802.pngDBS1_2-1721902677933.png

 

 

Fabio_Caimi
Contributor II
Contributor II

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

DBS1
Contributor III
Contributor III
Author

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

Thanks

DBS

DBS1
Contributor III
Contributor III
Author

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