[Bug]: FTP Step in Workflow throws an Exception

[danielvarju]

Apache Hop version?

2.11.0

Java version?

OpenJDK Runtime Environment (build 23.0.1+11-39)

Operating system

Windows

What happened?

Hi,

When I test the FTP connection in the FTP step (workflow), I get the access error. In the 2.09.0 version everything works normally. I cannot retrieve any data via FTP in version 2.11.0.

_ERROR: Error while trying to send files. Exception :
com.jcraft.jsch.JSchAlgoNegoFailException: Algorithm negotiation fail: algorithmName="server_host_key" jschProposal="ssh-ed25519,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,rsa-sha2-512,rsa-sha2-256" serverProposal="ssh-rsa,ssh-dss"
Algorithm negotiation fail: algorithmName="server_host_key" jschProposal="ssh-ed25519,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,rsa-sha2-512,rsa-sha2-256" serverProposal="ssh-rsa,ssh-dss"
ERROR: org.apache.hop.core.exception.HopWorkflowException:
com.jcraft.jsch.JSchAlgoNegoFailException: Algorithm negotiation fail: algorithmName="server_host_key" jschProposal="ssh-ed25519,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,rsa-sha2-512,rsa-sha2-256" serverProposal="ssh-rsa,ssh-dss"
Algorithm negotiation fail: algorithmName="server_host_key" jschProposal="ssh-ed25519,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,rsa-sha2-512,rsa-sha2-256" serverProposal="ssh-rsa,ssh-dss"

at org.apache.hop.workflow.actions.sftp.SftpClient.login(SftpClient.java:178)
at org.apache.hop.workflow.actions.sftpput.ActionSftpPut.execute(ActionSftpPut.java:757)
at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:751)
at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:894)
at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:453)
at org.apache.hop.workflow.Workflow.startExecution(Workflow.java:313)
at org.apache.hop.workflow.engines.local.LocalWorkflowEngine.startExecution(LocalWorkflowEngine.java:248)
at org.apache.hop.ui.hopgui.file.workflow.HopGuiWorkflowGraph.lambda$start$10(HopGuiWorkflowGraph.java:3723)
at java.base/java.lang.Thread.run(Thread.java:1575)

Caused by: com.jcraft.jsch.JSchAlgoNegoFailException: Algorithm negotiation fail: algorithmName="server_host_key" jschProposal="ssh-ed25519,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,rsa-sha2-512,rsa-sha2-256" serverProposal="ssh-rsa,ssh-dss"
at com.jcraft.jsch.KeyExchange.guess(KeyExchange.java:157)
at com.jcraft.jsch.Session.receive_kexinit(Session.java:614)
at com.jcraft.jsch.Session.connect(Session.java:336)
at com.jcraft.jsch.Session.connect(Session.java:198)
at org.apache.hop.workflow.actions.sftp.SftpClient.login(SftpClient.java:173)
... 8 more_

Issue Priority

Priority: 2

Issue Component

Component: Workflows

[hansva]

Are you sure this is an FTP server and not an SFTP server? It seems the server is responding with ssh-rsa as suggested encryption which makes me believe its SFTP

[hansva]

Ah it seems they disabled ssh-rsa in a recent version for security reasons. We should be able to allow this again see AntonShuvaev/elasticsearch4idea#120

[danielvarju]

Sorry, yes it is a SFTP Server.