SFTP Connection without host public key

[ManuelRühl]

I tried to establish a connection via SFTP with username and password. The Server is online and I can access the folders via WinSCP.

But the Qlik-Connection needs a key even the fields are not marked as mandatory:

[ManuelRühl]

In the documentation is written: "You must specify at least one of Password OR Private Key File."

The sftp-servers host told me: "It seems like wrong config for ftp client. I think this message say "You try to connect with rsa key but key not found". But we don't use this type of auth. Vendor should off auth by key and on auth by login and password."

[ManuelRühl]

Answer from Qlik Support:

A host public key or host public key fingerprint is also required for authentication; it is not possible using just a user name and password.

Für die Authentifizierung ist ebenfalls ein Host Public Key oder Host Public Key fingerprint notwendig, nur über Username und Password ist es nicht möglich.

[giohb_]

Were you able to figure out how to get the Host Public Key fingerprint ?

I am getting that error: 

Failed: The specified public key fingerprint does not match server fingerprint!

[Bjorn_Wedbratt]

You could try using ssh-keyscan <address for your sftp server>:

ssh-keyscan example.com
# example.com:22 SSH-2.0-OpenSSH_5.3
example.com ssh-rsa AAAAB3NzaC1

If using WinScp the host key is cached and can be retrieved using details found here: https://winscp.net/eng/docs/faq_hostkey#:~:text=Once%20you%20connect%2C%20WinSCP%20caches,Server%20a....

Hope that helps.

Best regards 

Björn 

[Ken_T]

did you ever find the solution for the error: 

Failed: The specified public key fingerprint does not match server fingerprint!
?

[Frank_S]

Check this article.

https://community.qlik.com/t5/Official-Support-Articles/How-to-create-an-SFTP-data-connection-in-a-Q...

Hope it helps.