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