Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
stan1609735726
Contributor
Contributor
‎2022-10-06 02:49 PM

Files transfer to sftp without password using SSH private key

I am currently using tftp and tftpput to file transfer to a sftp location using userid and password. I was asked to change this to passwordless file transfer, and provided with private and public key to be used for this implementation. Could you please advise how to achieve this request?

Labels (2)
Labels
533 Views
0 Likes
4 Replies
Anonymous
Not applicable
‎2022-10-09 05:40 AM

Hello,

You could try to generate the SSH key from the server where your FTP is hosted. On tFTPXXX component, check the box 'SFTP Support', select 'Publich key' in the Authentication method list and browse your private key in Private key field.

Feel free to let us know if it works.

Best regards

Sabrina

533 Views
0 Likes
stan1609735726
Contributor
Contributor
‎2022-10-10 10:39 PM
Author

Thank for your response. I tried the same and this is the error:

Exception in component tFTPConnection_1 (testing_ftp)

com.jcraft.jsch.JSchException: invalid privatekey: [B@71be98f5....

Could you please let me know what this means and how to correct?

533 Views
0 Likes
stan1609735726
Contributor
Contributor
‎2022-10-10 10:45 PM
Author

In response to Anonymous

The keys i using were provided by the other party for the sftp server which i will be connecting to. I didn't generate one from the Talend server and I used them as you recommended here and getting this error:

Exception in component tFTPConnection_1 (testing_ftp)

com.jcraft.jsch.JSchException: invalid privatekey: [B@71be98f5

533 Views
0 Likes
Anonymous
Not applicable
‎2022-10-10 11:23 PM

Hello,

Are you able to connect to that server (password and SSH private key) with WinScp tool using same details or does this issue only repro when connecting via talend job?

The invalid private key error points to a private key (.ssh/id_rsa) format that JGit does not work with, on the Studio machine. Talend Studio relies on the JSch library for SSH. This library supports only some private key formats, such as keys in OpenSSL (traditional SSLeay) and PKCS#8 formats. For more information, see JSch - Java Secure Channel.

However, it is possible to convert the private key format into a format supported by JSch using PuTTYgen. For more information, see Change Private Key Format to Use with PuTTY.

Hope it helps.

Best regards

Sabrina

533 Views
0 Likes