topic Re: Using SFTP with tFTPConnection in Talend Studio

Using SFTP with tFTPConnection

Anonymous — Mon, 05 Dec 2016 20:49:58 GMT

Hi,
I am trying to connect to a SFTP site using the "Public key" authentication method.
I receive the following error..
Exception in component tFTPConnection_1
com.jcraft.jsch.JSchException: Auth cancel
at com.jcraft.jsch.Session.connect(Session.java:511)
at com.jcraft.jsch.Session.connect(Session.java:183)
at employsure.sftp_0_1.sftp.tFTPConnection_1Process(sftp.java:408)
at employsure.sftp_0_1.sftp.runJobInTOS(sftp.java:814)
at employsure.sftp_0_1.sftp.main(sftp.java:666)
I can successfully connect to this site using the WINSCP tool using the same credentials.
I notice using the WINSCP tool, if I don't set the password property it prompts me for it.

Looking at the generated code for both authentication types (Public Key & Password), it seems Talend does not set the password when using Public Key authentication.

Can you confirm if this is by design? And, if there is way to use both?

Re: Using SFTP with tFTPConnection

Anonymous — Tue, 06 Dec 2016 07:34:04 GMT

Hi,
Is your private key valid? What's the build version you are using?
Best regards
Sabrina

Re: Using SFTP with tFTPConnection

Anonymous — Thu, 08 Dec 2016 21:26:49 GMT

Yes, private key is valid - I'm using the same file with WINSCP (and other FTP clients).
Using 6.3.0.20161026

Re: Using SFTP with tFTPConnection

Anonymous — Fri, 09 Dec 2016 00:33:20 GMT

I managed to apply a hack/patch to make this work..
I edited the "plugins\org.talend.designer.components.localprovider_6.3.0.20161026_1219\components\tFTPConnection\tFTPConnection_begin.javajet" file and forced the template to generate both the "public key" code option and the "password" option, not either or.
And it worked.
Can we please wire this option into future versions?

Re: Using SFTP with tFTPConnection

Anonymous — Wed, 18 Jan 2017 07:53:49 GMT

Hi,
Could you please create a jira issue on talend bug tracker for this issue?
Best regards
Sabrina

Re: Using SFTP with tFTPConnection

Anonymous — Wed, 18 Jan 2017 08:49:07 GMT

Hi David,
Can you please specify where and what exactly you have edited in the tFTPConnection_begin.javajet file ?

Re: Using SFTP with tFTPConnection

Anonymous — Thu, 19 Jan 2017 06:30:00 GMT

Hi,
It should be located in < TalendStudioInstallationPath\plugins\org.talend.designer.components.localprovider_6.x.x.xxx.xx\components\tFTPConnection folder.
Best regards
Sabrina

Re: Using SFTP with tFTPConnection

Anonymous — Thu, 19 Jan 2017 07:54:33 GMT

Yes I got the path to the file but what exactly needs to be changed in that file ?

Re: Using SFTP with tFTPConnection

Anonymous — Thu, 19 Jan 2017 08:04:47 GMT

Hi,
We have no idea about the change. Did you get the same situation with davidoxley?
Best regards
Sabrina

Re: Using SFTP with tFTPConnection

Anonymous — Thu, 19 Jan 2017 10:54:11 GMT

Hi,
I am getting the same error as davidoxley got but the difference is I am using Talend 5.6 and port used is 12922.
Still I can try the change that he did in the tFTPConnection_begin.javajet file provided I come to know what is the exact change that I need to do.

Sabrina, Can you also tell me that tFTPConnection component only supports port 22 ?

Re: Using SFTP with tFTPConnection

arpiitv — Fri, 29 Jan 2021 06:00:39 GMT

Hi @David Oxley Could you please help what changes you have made in javalet file? facing same issue.

Re: Using SFTP with tFTPConnection

arpiitv — Sat, 30 Jan 2021 18:46:43 GMT

@Shicong Hong @Xiaodi Shi @Fred Trebuchet @Richard Hall Could you guys please help me out. What changes @David Oxley made, could you please let us know.

Re: Using SFTP with tFTPConnection

arpiitv — Sat, 30 Jan 2021 18:48:05 GMT

@Foram Shah have you resolved this problem?

Re: Using SFTP with tFTPConnection

arpiitv — Sat, 30 Jan 2021 18:50:34 GMT

@Shicong Hong I'm facing similar issue, could you please help me.

Re: Using SFTP with tFTPConnection

Anonymous — Tue, 02 Feb 2021 16:21:15 GMT

Hi @Arpit Verma can you explain the precisely what error you are getting and what you are doing (how you have set this component up)? This *may* be a different issue, in which case a new post may be a better route. Lets find out here and possibly take this in a different route when we know what is happening.