Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Download Tool with SFTP and multiple Known Hosts keys

cam_w
11 - Bolide

Hi!

 

Hopefully a quick confirmation question ... My understanding is that the Download Tool is based on libcurl. From my reading of the curl docs, I can't see that curl supports the passing of 'known host' public keys to validate server connections. It seems that the only option is to disable the check of server public key.

 

Has anyone else seen this and know of a solution (using the Download Tool)? PuTTY and other SSH clients have a 'known host' parm that can be provided to account for this situation. Do we know if libcurl have plans to add this functionality?

 

Thanks,

 

Cameron

4 REPLIES 4
cam_w
11 - Bolide

I thought I'd check "one more time" because I've been 'burnt' recently ... and sure enough, cURL does have this option starting in version 7.17.1. The option is --hostpubmd5 <md5>:

 

https://curl.haxx.se/docs/manpage.html

 

Am I correct that the Download Tool is using version 7.15.1?

 

PS C:\Program Files\Alteryx\bin\RuntimeData\Analytic_Apps> .\curl -V
curl 7.15.1 (i586-pc-mingw32msvc) libcurl/7.15.1 zlib/1.2.2
Protocols: tftp ftp gopher telnet dict ldap http file
Features: Largefile NTLM SSPI libz

 

 

Plamena10
6 - Meteoroid

Hello, any idea if this is implemented ? 

cam_w
11 - Bolide

I have NOT checked back on the Download Tool and the version of libcurl installed with Designer, but it would be relatively easy for you to check.

 

I ended up sending the Alteryx information to a temp file and then used PuTTY 0.70 (or higher) to get access to the multiple host key functionality. I actually created 2 versions - macro and python - to connect Alteryx and PuTTY. The simplest way to get started is to use PuTTY command line tool (psftp.exe) manually until you understand the syntax, and then replicate the functionality in the macro or in python.

 

Depending on your computer environment (enterprise/home/business/etc) you may already have an openssh client installed with recent versions of Windows 10. Read this documentation to get started and then check your environment to see if it exists:

 

https://docs.microsoft.com/en-us/windows/terminal/tutorials/ssh

 

 

Plamena10
6 - Meteoroid

Hi, it's just checked its still 

curl 7.15.1

 

thank you for sharing the knowledge, i won't be able to resolve this with python yet, 

but i managed thru batch scripting and winscp.exe on our Alteryx server. Its not very user friendly,

i hope Alteryx 2021 version will solve this issue.

Labels