One Star

[resolved] SFTP Connection Error Message

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
1 ACCEPTED SOLUTION

Accepted Solutions
Four Stars

Re: [resolved] SFTP Connection Error Message

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

Re: [resolved] SFTP Connection Error Message

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
One Star

Re: [resolved] SFTP Connection Error Message

Thanks for the fast reply. I have quickly installed CuteFTP and tried it from there.
ERRORSmiley Embarassed 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.
8) 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?
One Star

Re: [resolved] SFTP Connection Error Message

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

Re: [resolved] SFTP Connection Error Message

- 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
One Star

Re: [resolved] SFTP Connection Error Message

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

Re: [resolved] SFTP Connection Error Message

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.
Four Stars

Re: [resolved] SFTP Connection Error Message

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
One Star

Re: [resolved] SFTP Connection Error Message

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?
Four Stars

Re: [resolved] SFTP Connection Error Message

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

Re: [resolved] SFTP Connection Error Message

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

Re: [resolved] SFTP Connection Error Message

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).
Moderator

Re: [resolved] SFTP Connection Error Message

Hi cihanc83,
Is there any update for your issue?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.