[resolved] SFTP Connection Error Message

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

- 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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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?

[Anonymous · Accepted solution]

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