SFTP with .PPK file

[Charles Warwick]

Hi Steve,

My apologies... there is a mistake in the documentation for tsNet which 
I only just noticed.

The array element for the SSH private key should be 
tSettings["ssh_private_key"], not tSettings["ssh_priv_key"].

So if you change the following line:

     put tPrivKey into tSettings["ssh_priv_key"]

to:

     put tPrivKey into tSettings["ssh_private_key"]

you should be right to go!

(I will get this fixed in the documentation for the next version)

Best Regards,

Charles


On 17/03/2017 6:31 PM, Charles Warwick via use-livecode wrote:
> Hi Steve,
>
> The tsNet command only requires the SSH private key, so that is ok.
>
> I will test again here to make sure there is nothing else going on in 
> LC 9.0 DP6....
>
> Just to check though, I assume your private key does not require a 
> passphrase?
>
> Another thing to try is to download the following simple stack:
>
> https://downloads.techstrategies.com.au/tsnet/debug_liburl.livecode
>
> Run that stack at the same time as your own, and click "Start Debug" 
> before you try make the SSH connection.
>
> It should provide some additional debug information that may shed more 
> light on what is actually happening.
>
> Regards,
>
> Charles
>
>
> On 16/03/2017 10:24 PM, Stephen MacLean via use-livecode wrote:
>> Hi Charles,
>>
>> One other thing… in looking at the .ppk file, it contains both 
>> “public lines”  and "private lines”. All I see in the ssh key file is 
>> private.
>>
>> Not sure that make any difference, but thought I’d mention it.
>>
>> Best,
>>
>> Steve
>>
>>> On Mar 16, 2017, at 7:53 AM, Stephen MacLean via use-livecode 
>>> <use-livecode at lists.runrev.com> wrote:
>>>
>>> Hi Charles,
>>>
>>> Thank you so much for reply!
>>>
>>> I converted the key file as you described, however, I’m still 
>>> getting the error 67 (authentication error) when running the script.
>>>
>>> Any further help would be greatly appreciated.
>>>
>>> Best,
>>>
>>> Steve MacLean
>>>
>>>> On Mar 16, 2017, at 3:08 AM, Charles Warwick via use-livecode 
>>>> <use-livecode at lists.runrev.com> wrote:
>>>>
>>>> Hi Steve,
>>>>
>>>> It looks like you are using a SSH private key in PuTTY format 
>>>> (.ppk).  tsNet requires it to be in OpenSSH format.
>>>>
>>>> That is easy to fix though, you can convert the .ppk with PuttyGen.
>>>>
>>>> To do this, open PuttyGen and load the .ppk file.  Then select 
>>>> "Conversions" -> "Export OpenSSH key".
>>>>
>>>> Apart from that, just make sure that your call to tsNetGet includes 
>>>> the full path of the file you want to download.
>>>>
>>>> Hope that helps,
>>>>
>>>> Cheers,
>>>>
>>>> Charles
>>>>
>>>>
>>>> On 16/03/2017 6:01 AM, Stephen MacLean via use-livecode wrote:
>>>>> Well, still no luck in getting it to work, but getting closer…
>>>>>
>>>>> I found a sample file linked to on livecode.com 
>>>>> <http://livecode.com/>. Modifying it to use the key file, I have:
>>>>>
>>>>> on mouseUp
>>>>>    local tHeaders, tResult, tSettings
>>>>>    put “xxxxxxxx" into tSettings["username"]
>>>>>    put URL "binfile:D:\private.ppk" into tPrivKey
>>>>>    put tPrivKey into tSettings["ssh_priv_key"]
>>>>>    tsNetInit
>>>>>    put tsNetGet("1", "sftp://secure.xxxxxxxx.us/", tHeaders, 
>>>>> "transferComplete", tSettings) into tResult
>>>>> end mouseUp
>>>>>
>>>>> However, it returns:
>>>>>
>>>>> tsneterr: (67) Authentication failure
>>>>>
>>>>> Again, I can access the sftp site with no problems using the 
>>>>> WinSCP ftp client and the key file.
>>>>>
>>>>> Any suggestions??
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Steve MacLean
>>>>>
>>>>>> On Mar 15, 2017, at 9:38 AM, Stephen MacLean via use-livecode 
>>>>>> <use-livecode at lists.runrev.com> wrote:
>>>>>>
>>>>>> Hi All,
>>>>>>
>>>>>> Looking to use tsNet to connect to a SFTP server that uses 
>>>>>> username and a private key instead of a password. The private key 
>>>>>> is contained in a file.
>>>>>>
>>>>>> I use WinSCP and can link the connection to the file and can 
>>>>>> connect fine.
>>>>>>
>>>>>> In LC, I’ve set the CABundle to the file, but am not sure this is 
>>>>>> how it’s supposed to work. Getting an auth error when doing 
>>>>>> tsNetGet.
>>>>>>
>>>>>> Any help would be appreciated.
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Steve MacLean
>>>>>>
>>>>>> PS: Running 9.0 dp6 Business
>>>>>>
>>>>>> _______________________________________________
>>>>>> use-livecode mailing list
>>>>>> use-livecode at lists.runrev.com
>>>>>> Please visit this url to subscribe, unsubscribe and manage your 
>>>>>> subscription preferences:
>>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>> _______________________________________________
>>>>> use-livecode mailing list
>>>>> use-livecode at lists.runrev.com
>>>>> Please visit this url to subscribe, unsubscribe and manage your 
>>>>> subscription preferences:
>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>
>>>> _______________________________________________
>>>> use-livecode mailing list
>>>> use-livecode at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your 
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>>
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your 
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>>
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your 
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode