topic Re: [resolved] SFTP Connection Error Message in Talend Studio

[resolved] SFTP Connection Error Message

Anonymous — Fri, 13 Jun 2014 08:57:03 GMT

Hey everyone,
I am trying to build a data flow where I get certain files from a folder with an (S)FTP connection.
I am using the tFtpConnection component and in the Basic Setting window, I have already entered the host, port, username and password information. Authentication method is set to "password" and SFTP Support is checked.
When I press F6 and run the job, I immediately get the following error message:
------------------------------------

connecting to socket on port 3654
connected
Exception in component tFTPConnection_1
com.jcraft.jsch.JSchException: connection is closed by foreign host
at com.jcraft.jsch.Session.connect(Session.java:240)
at com.jcraft.jsch.Session.connect(Session.java:154)
at edi_on_nav.cmd_sftp_mget_iftmin_in_prod_0_1.CMD_SFTP_mget_IFTMIN_IN_PROD.tFTPConnection_1Process(CMD_SFTP_mget_IFTMIN_IN_PROD.java:513)
at edi_on_nav.cmd_sftp_mget_iftmin_in_prod_0_1.CMD_SFTP_mget_IFTMIN_IN_PROD.runJobInTOS(CMD_SFTP_mget_IFTMIN_IN_PROD.java:1301)
at edi_on_nav.cmd_sftp_mget_iftmin_in_prod_0_1.CMD_SFTP_mget_IFTMIN_IN_PROD.main(CMD_SFTP_mget_IFTMIN_IN_PROD.java:1166)
the end is near
172 milliseconds
disconnected

-------------------------------------
What exactly does "Exception in component tFTPConnection_1
com.jcraft.jsch.JSchException: connection is closed by foreign host" mean? What should I be checking here? Could it be related to the connection details or am I perhaps skipping a step?
Thanks!
Cihan

Re: [resolved] SFTP Connection Error Message

Anonymous — Fri, 13 Jun 2014 09:33:48 GMT

Can you connect using same setting using ftp client like cuteftp or filezilla from the same machine?
Usually SFTP port is different than the FTP port... can you pl check once again?
Vaibhav

Re: [resolved] SFTP Connection Error Message

Anonymous — Fri, 13 Jun 2014 09:41:25 GMT

Thanks for the fast reply. I have quickly installed CuteFTP and tried it from there.
ERROR The connection failed due to an error or timeout.

1) Verify that the destination IP address is correct.
2) Increase the connection timeout threshold under Global Settings | Connection.
3) Switch to the opposite data connection type (PASV or PORT) under Site Settings | Type tab.
4) Verify that the problem is not local by trying to connect to an alternate server.
5) If a server name was used, verify it resolves to the correct address.
6) If using a local server table for server name resolution, check to see that it doesn't resolve to an obsolete address.
7) Try pinging the address.
😎 If you are using a router, verify the router is up and running (check by pinging it and then ping an address outside of the router).
9) Do a traceroute to the destination to verify all routers along the connection path are operational.
10) Verify that your subnet mask is setup properly.
11) Verify that your local software or hardware firewall is not blocking outbound connections originating from CuteFTP.
12) Verify that your anti-virus software is not at fault (try disabling it).

I am on a company laptop; could my firewall/anti-virus software be blocking me?

Re: [resolved] SFTP Connection Error Message

Anonymous — Fri, 13 Jun 2014 09:58:27 GMT

I pinged the IP address, too. That worked. I'm guessing it's the authentication part that is causing the issue?

Re: [resolved] SFTP Connection Error Message

Anonymous — Fri, 13 Jun 2014 10:20:08 GMT

- Firewall blocks external communication within your intranet and not outside...
If you are able to connect through client, then you should be able to connect through talend as well.
Thanks
vaibhav

Re: [resolved] SFTP Connection Error Message

Anonymous — Fri, 13 Jun 2014 10:21:49 GMT

OK, this is the first time I am working with SFTP, so I am at a loss here. Thanks for the tips.

Re: [resolved] SFTP Connection Error Message

Anonymous — Fri, 13 Jun 2014 13:06:01 GMT

I tried to check if the SFTP port 22 open is, using telnet <hostname> <port>. It appears that 22 is closed (I am getting a connecting error in the command window of Windows, whereas 21 (used for FTP, if I am not wrong) is open.

Re: [resolved] SFTP Connection Error Message

Anonymous — Fri, 13 Jun 2014 13:15:12 GMT

Have you tried connecting to existing available port, and checked if you can get required data...?
Many times we don't know that which port is used by SFTP.
Vaibhav

Re: [resolved] SFTP Connection Error Message

Anonymous — Mon, 16 Jun 2014 10:11:58 GMT

Sorry for the late reply/update. No, the port is supposedly 22; I received that info from the guys running the server, along with other details like IP, password, etc.
Are there in Talend any other ways to establish SFTP connections? Aside from the tFTP components?

Re: [resolved] SFTP Connection Error Message

Anonymous — Mon, 16 Jun 2014 11:29:53 GMT

You can think of using tSystem component and fire commands to connect to ftp server.
Vaibhav

Re: [resolved] SFTP Connection Error Message

Anonymous — Mon, 16 Jun 2014 13:49:09 GMT

You can also use the tSCPxxx components which actually does the same.

Re: [resolved] SFTP Connection Error Message

Anonymous — Mon, 16 Jun 2014 16:01:36 GMT

SFTP and SCP are both subsystems of the SSHD daemon (default port 22). If you are receiving a connection closed then there is a firewall or some network device sending a RST packet when attempting to connect to that port. Since you can connect to port 21 (FTP), you should ask the sysadmins if there is a firewall preventing SSH connections to the machine (also check your own firewall configuration).

Re: [resolved] SFTP Connection Error Message

Anonymous — Tue, 17 Jun 2014 07:57:52 GMT

Hi cihanc83,
Is there any update for your issue?
Best regards
Sabrina