topic Re: Error: com.jcraft.jsch.JSchException: Auth cancel in Talend Studio

Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Fri, 29 Jan 2021 06:05:33 GMT

Hi Team,

I'm trying to establish SFTP connection using tFTPConnection component and I'm using auth type is Public Key but getting error Auth Cancel. But with the same creds I'm able login in WinSCP, so problem with component, Could someone please have look into it. Please.

Getting below error :

Error: com.jcraft.jsch.JSchException: Auth cancel

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Fri, 29 Jan 2021 06:07:46 GMT

@Shicong Hong @Xiaodi Shi @Fred Trebuchet @Manohar B @David Oxley

one of thread where David did some changes in javalet file but dont know what changes he made

He's reply - 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?

Can someone please me to understand what changes he made? @Richard Hall

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

Anonymous — Fri, 29 Jan 2021 08:57:30 GMT

Hello,

Are you using ssh service for this server?

Is it OK with you to use "tScpConnection" and enable sftp with same login information as tFtpConnection to see if it works?

Best regards

Sabrina

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Fri, 29 Jan 2021 10:43:45 GMT

@Xiaodi Shi is not working, could you please suggest me something else, actually there is multi factor authentication require and Tftp connection not supporting this multi auth.

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

Anonymous — Mon, 01 Feb 2021 06:49:14 GMT

Hi arpiitv

David was using v6.3.0 which was a bit old version, it should be a bug. Which version of studio are you using?

Regards

Shong

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Mon, 01 Feb 2021 12:15:27 GMT

Hi @Shicong Hong , thanks for reply

@Shicong Hong @Xiaodi Shi @Richard Hall @Lolling Jan

I'm using 7.3.1 version. please see attachment also of component and error

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

Anonymous — Tue, 02 Feb 2021 16:26:38 GMT

Hi @Arpit Verma you mention that multi-factor authentication is required here. Can you explain exactly how this would work? Multi-factor authentication usually involves a user intervention. This may not actually be possible here without a Java workaround. Before we can understand the full issue we need to know what the precise steps are for access to this FTP location

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Tue, 02 Feb 2021 20:18:37 GMT

@Richard Hall you're right but looks like @David Oxley he was facing that issue too but he did made some changes on java let file, please find his comments -one of thread where David did some changes in javalet file but dont know what changes he made

He's reply - I managed to apply a hack/patch to make this work..

And it worked.

Can we please wire this option into future versions?

@Shicong Hong

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

Anonymous — Wed, 03 Feb 2021 00:30:01 GMT

Password and public key is not what I was thinking when you said multi-factor authentication. Usually multi-factor authentication involves a manual step during the login process. If you were to login to this FTP location manually (without Talend), how would you go about doing this? What steps are required?

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Wed, 03 Feb 2021 06:12:05 GMT

Hi @Richard Hall @Shicong Hong @Xiaodi Shi , Attaching snaps of steps which I've followed while connecting FTP through WinSCP.

First I've given username, host , post and password. Below is attachment.
Changed the advance setting to set ppk file.
proxy setting in advance site setting itself.

All things are saved, one more thing I want to show while connection FTP location winSCP gives authentication steps.Kindly take a look, hope these things will help you get your answers. @Shicong Hong @Richard Hall @Xiaodi Shi

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

Anonymous — Wed, 03 Feb 2021 17:42:25 GMT

Hi @Arpit Verma,

I am confused. You are saying you are using v7.3.1 and you do not have the option of using both a public key and password. Unfortunately I do not have access to a suitable FTP server to test this, but I have looked at the component and it seems to give you the option of using both. You can see that in this screenshot....

Are you saying that filling in all of the fields shown here is not working? If that is the case it sounds different to David's case. I believe David's case was that he was not presented with all of the fields. It sounds like it may be a bug. Do you have a support license with Talend? If so, can you raise this with Support? If not, can you let us know and we will see if we can get this raised.

@Shicong Hong or @Xiaodi Shi can you raise this issue if @Arpit Verma does not have a support contract?

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Wed, 03 Feb 2021 18:44:55 GMT

@Richard Hall yes fulfilling all fields while using public key auth that is not working, I've attached the screenshot of ftp component and erros in above reply.

Also, as I'm getting Auth Cancel error so that's mean Authentication not Fullly ccompleted.

@Shicong Hong @Xiaodi Shi

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Wed, 03 Feb 2021 20:16:03 GMT

Here is Auth Cancel error I'm getting@Richard Hall @Shicong Hong @Xiaodi Shi Here is configuration of component

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Thu, 04 Feb 2021 16:55:10 GMT

@Richard Hall @Shicong Hong Kindly take a look into this.

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

Anonymous — Fri, 05 Feb 2021 15:47:26 GMT

@Arpit Verma I have raised this as a bug. I am afraid that this might take some time for it to be actioned.

However, since this is clearly holding you up, I have decided to create a workaround. I have set up an SFTP server that I suspect is like yours. I have recreated the issue. I have also found a solution using Java. In order to use this in a Talend job you will need to use a bit of Java, but most of the hard work I have done for you. This a job that will list all of the files in a folder and at the end it will download one of them. I have done this so that you can have an idea of how to sort this for yourself.

This is NOT supported code and you should use it entirely at your OWN RISK!

An image of the job is below.....

It is just two components. A tLibraryLoad component to load the jsch-0.1.55.jar library into the Job. The second is a tJavaFlex component. This allows you to cycle through files and do something per file if you wish.

The tLibraryLoad is shown below......

That is all you need to do for that component.

The tJavaFlex's different code sections are shown below......

Start Code

**************************************************************************************************

com.jcraft.jsch.Session jschSession = null;

try{

com.jcraft.jsch.JSch jsch = new com.jcraft.jsch.JSch();

jsch.setKnownHosts("/Users/richardhall/known_hosts_new");

jsch.addIdentity("/Users/richardhall/.ssh/id_rsa", "mypassphrase");

jschSession = jsch.getSession("richard", "192.168.1.25", 22);

jschSession.setPassword("mypassword");

// 10 seconds session timeout

jschSession.connect(10000);

com.jcraft.jsch.Channel sftp = jschSession.openChannel("sftp");

// 5 seconds timeout

sftp.connect(5000);

com.jcraft.jsch.ChannelSftp channelSftp = (com.jcraft.jsch.ChannelSftp) sftp;

System.out.println(channelSftp.getHome());

java.util.Vector filelist = channelSftp.ls(channelSftp.getHome()+"/Documents");

for(int i=0; i<filelist.size();i++){

**************************************************************************************************

What I am doing above is getting the connection, then printing the home folder, then getting a file list from the "Documents" folder and adding the values to a Vector. I then open a FOR loop to iterate over the Vector. The code to print the filenames, etc, is in the Main Code section.

Main Code

**************************************************************************************************

com.jcraft.jsch.ChannelSftp.LsEntry entry = (com.jcraft.jsch.ChannelSftp.LsEntry) filelist.get(i);

System.out.println(entry.getFilename());

**************************************************************************************************

The above code simply gets the file details and prints the filenames out one at a time. Remember that the Main Code section is run for every iteration of the For loop.

End Code

**************************************************************************************************

}

channelSftp.get(channelSftp.getHome()+"/Documents/hellotest.txt", "/Users/richardhall/Documents/hellotest.txt");

} catch (com.jcraft.jsch.JSchException e) {

e.printStackTrace();

} finally {

if (jschSession != null) {

jschSession.disconnect();

}

**************************************************************************************************

This code basically closes the For Loop opened in the Start Code section. I also demonstrate how to download a file (get). I then close down the try/catch block that I opened in the Start Code.

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Fri, 05 Feb 2021 19:21:00 GMT

@Richard Hall first of all, Thank you much for this code that you have written. Really appreciate it!!

Looks like I need to do add some additions in order to use this approach. But I was wondering if that workaround only happen with FTP component.

I'm trying another solution to achieve this to write shell script and call it by tSystem component, hope that works.

Please update about raised ticket status whenever you get. Thank you @Richard Hall !!

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

Anonymous — Sat, 06 Feb 2021 02:19:40 GMT

Hi @Arpit Verma ,

This workaround should allow you to do anything you need with regard to the SFTP part of the process. In theory, it should actually allow you more freedom. You just need to look for Java examples to extrapolate from

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

arpiitv — Sat, 06 Feb 2021 05:38:38 GMT

@Richard Hall Sure, Thanks!!

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

madhukolli2003 — Fri, 12 Mar 2021 19:59:14 GMT

Hi @Richard Hall ,

I am facing same issue, are you able to fix it in the tftpconnection component level ?

Thanks & Regards,

Madhu Kolli

Re: Error: com.jcraft.jsch.JSchException: Auth cancel

Anonymous — Fri, 19 Mar 2021 21:15:24 GMT

Hi @MADHUSUDHANA kolli,

Sorry about the delay in responding to your question. I have checked on the progress of the case that I raised and I am afraid it has been treated as a feature request instead of a bug. The justification behind this does make sense, but it is frustrating. As such, I do not have an ETA for when this will be done.