SFTP

[Lo via 4D_Tech]

Dear friends

I am of course very dense so please excuse a question I'm sure has been 
answered before.

Any way of transferring files using SFTP in native 4D?
IC have FTP commands, can these use SFTP? Doesn't seem to work for me.
Or any other hints?

OS : Windows
4D : any version that works

Many thanks
Love and kisses
Lo
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP

[Jeffrey Kain via 4D_Tech]

Lo!

I'd suggest starting with Miyako's curl plug-in:

  https://github.com/miyako/4d-plugin-curl/blob/master/README.md

You could also include a copy of curl for Windows in your Resources folder and 
use LAUNCH EXTERNAL PROCESS to interact with it.

HTH -

Jeff



--
Jeffrey Kain
jeffrey.k...@gmail.com




> On Aug 4, 2018, at 11:23 AM, Lo via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> I am of course very dense so please excuse a question I'm sure has been 
> answered before.
> 
> Any way of transferring files using SFTP in native 4D?
> IC have FTP commands, can these use SFTP? Doesn't seem to work for me.
> Or any other hints?

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP

[Keisuke Miyako via 4D_Tech]

for SFTP:

https://github.com/miyako/4d-plugin-curl-ftp

2018/08/05 0:56、Jeffrey Kain via 4D_Tech 
<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:for SFTP
 https://github.com/miyako/4d-plugin-curl/blob/master/README.md



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: SFTP

[Lo via 4D_Tech]

Thank you Gentlemen.
Spot on, as always.

Best
Lo


-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako via 
4D_Tech
Sent: 04 August 2018 23:16
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Keisuke Miyako 
Subject: Re: SFTP

for SFTP:

https://github.com/miyako/4d-plugin-curl-ftp

2018/08/05 0:56、Jeffrey Kain via 4D_Tech 
<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:for SFTP  
https://github.com/miyako/4d-plugin-curl/blob/master/README.md



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP

[Ed Heckman via 4D_Tech]

Is there a version of this plugin that works for v14? (We're still 
working on converting subtables to real tables. That limits this project 
to v14 until that's done.)



Ed Heckman <mailto:eheck...@dimensioni.com>
Dimension i Technologies <http://dimensioni.com>
(717) 892-1444


Keisuke Miyako via 4D_Tech wrote:

for SFTP:

https://github.com/miyako/4d-plugin-curl-ftp

2018/08/05 0:56、Jeffrey Kain via 
4D_Tech<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:for SFTP
  https://github.com/miyako/4d-plugin-curl/blob/master/README.md



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP

[B.Bippus via 4D_Tech]

 (We're still
working on converting subtables to real tables. That limits this project
to v14 until that's done.)

Do you know that V16 works with subtables?

Bernd.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP

[Lee Hinde via 4D_Tech]

But not sub-sub-tables. (actually had one of those handed off to me last year.)


> On Mar 26, 2019, at 3:35 PM, B.Bippus via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> (We're still
> working on converting subtables to real tables. That limits this project
> to v14 until that's done.)
> 
> Do you know that V16 works with subtables?
> 
> Bernd.
> 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP

[Keisuke Miyako via 4D_Tech]

I do not support (by which I mean test) versions before v16,
but plugin architecture has basically not changed since v14.

that said, if you mean v14 mac,
you need to use the 32-bit version (carbon).

> 2019/03/27 3:08、Ed Heckman のメール:
> Is there a version of this plugin that works for v14? (We're still working on 
> converting subtables to real tables.
> That limits this project to v14 until that's done.)



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SFTP & PGP Encryption

[Tarawerkz via 4D_Tech]

Hi All,


In the wake of the prevailing security considerations, my client has enquired 
of the following for an on-site 4D v17 application running on Windows Server 
2012…..

1.  to provide an external facing SFTP through which the enterprise SAP can 
connect to ?

2.  to support this connection via PGP encryption (to pick up files which the 
4D application will generate in CSV format) ?

Is the new version of 4D (or v18) able to support such features?


Regards,
Ronnie
Tarawerkz




**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SFTP and Internet Commands

[Cannon Smith via 4D_Tech]

Does anyone know of a way to use Internet Commands to login to an FTP site 
using SFTP?

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SFTP - Native to 4D?

[Janet Jonas via 4D_Tech]

Does 4D have any native capability to do SFTP file transfers and/or generate a 
SSH-2 RSA public and private key pair?

Any pointers would be welcome.

JJ
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP & PGP Encryption

[John DeSoi via 4D_Tech]

> On Oct 13, 2020, at 8:03 PM, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 1.  to provide an external facing SFTP through which the enterprise SAP can 
> connect to ?

4D has no direct support for SFTP as a client or a server in the latest 
version. HTTPS is probably the best secure network connectivity option directly 
supported by 4D.

> 
> 2.  to support this connection via PGP encryption (to pick up files which the 
> 4D application will generate in CSV format) ?


4D has support for public key encryption for data which should be sufficient 
for most applications.

https://doc.4d.com/4Dv18R4/4D/18-R4/ENCRYPT-BLOB.301-4982910.en.html

John DeSoi, Ph.D.


**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP & PGP Encryption

[Peter Bozek via 4D_Tech]

On Wed, Oct 14, 2020 at 3:03 AM Tarawerkz via 4D_Tech
<4d_tech@lists.4d.com> wrote:

> 1.  to provide an external facing SFTP through which the enterprise SAP can 
> connect to ?

SFTP is a protocol running under SSH, and while 4D contains OpenSSL
library, to provide SSH functionality is far outside the scope of data
/ application / web server, what 4D is. But both Mac and Windows OS
should contain support of SSH and thus SFTP. All that user will have
to do is enable and configure it, on Mac it is matter of checking a
checkbox in preferences, on Windows it may be a bit more complex, see
https://docs.microsoft.com/en-us/windows-server/administration/openssh/openssh_overview
. With older Windows versions, client may have to install third-party
SSH server.

>
> 2.  to support this connection via PGP encryption (to pick up files which the 
> 4D application will generate in CSV format) ?

PGP is a specific (open-source) implementation of public key
encryption. While 4D supports public key encryption, it may be simpler
to instal PGP on user's machine and let 4D encrypt the exported files
with PGP command line interface.

>
> Is the new version of 4D (or v18) able to support such features?

Not as something developer can switch on with a checkbox. Both SFTP
(SSH) and PGP are not very user friendly, and require some knowledge
how to set it up and use, but this is not that hard and what your
client requests should be definitely doable.

HTH,

Peter Bozek
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP & PGP Encryption

[John DeSoi via 4D_Tech]

Public keys would need to be exchanged one time. Then the encrypted CSV files 
could be sent. The sender would encrypt the file with the recipient's public 
key.

John DeSoi, Ph.D.


> On Oct 13, 2020, at 11:20 PM, Tarawerkz  wrote:
> 
> Hi John,
> 
> Thanks for the confirmation with regards to SFTP support in 4D.
> Although it’s probably possible to use WinSCP to do this, I have no 
> inclination to manage that on behalf of the client and will leave it to the 
> client’s IT if they insist on that route.
> 
> With public key encryption, it means what we will send over is the encrypted 
> blob and the public key (in lieu of the csv file itself)?
> 
> Regards,
> Ronnie
> Tarawerkz
> 

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: SFTP and Internet Commands

[Stephen J. Orth via 4D_Tech]

Cannon,

I don't so we ended up using WINSCP...

We utilize BAT files, and a pre-built WINSCP configuration, to send payroll 
data to ADP.

Best,


Steve

*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.com
*
-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Cannon Smith 
via 4D_Tech
Sent: Tuesday, December 19, 2017 11:50 AM
To: 4D iNug Technical <4D_Tech@lists.4D.com>
Cc: Cannon Smith 
Subject: SFTP and Internet Commands

Does anyone know of a way to use Internet Commands to login to an FTP site 
using SFTP?

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Milan Adamov via 4D_Tech]

SFTP and FTP has nothing in common as protocols, you can’t expect FTP commands 
to work with SFTP.

http://www.differencebetween.net/technology/internet/difference-between-ftp-and-sftp/

Milan

Sent from my iPad

> On Dec 19, 2017, at 18:49, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Does anyone know of a way to use Internet Commands to login to an FTP site 
> using SFTP?
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Tim Nevels via 4D_Tech]

On Dec 19, 2017, at 12:41 PM, Cannon Smith wrote:

> Does anyone know of a way to use Internet Commands to login to an FTP site 
> using SFTP?

No built in support for SFTP in 4D Internet Commands plugin. You need a third 
party SFTP application that can be controlled by 4D using LEP and the command 
line interface. I use WS_FTP for this on Windows. 

On macOS there are several ftp programs that support SFTP and they can be 
controlled by AppleScript. And macOS already has built in command line SFTP 
support you can use. You can use LEP to control those and shell scripts. 

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: SFTP and Internet Commands

[Timothy Penner via 4D_Tech]

Like Milan said; SFTP is essentially File Transfer over SSH, which is very 
different from FTP and FTPS.  4DIC does not support SSH so therefore it does 
not support SFTP.

However, maybe this plugin will help you?

https://github.com/miyako/4d-plugin-curl-ftp
The description of the plugin is " FTP/SFTP/FTPS client based on libcurl"

I haven't tried it, I just found it.

-Tim



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Cannon Smith via 4D_Tech]

Thanks, everyone who responded about this. I didn’t realize there was a 
difference between FTP and SFTP other than the SSL part of things. I need it to 
work on both platforms, so I think I’ll start with Miyako’s plugin and see how 
that works.

Thanks for the help! And Merry Christmas to everyone.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Dec 19, 2017, at 12:56 PM, Timothy Penner via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Like Milan said; SFTP is essentially File Transfer over SSH, which is very 
> different from FTP and FTPS.  4DIC does not support SSH so therefore it does 
> not support SFTP.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Cannon Smith via 4D_Tech]

The more I look into this, the more I realize it isn’t even SFTP that I want. 
What I’m really trying to do is upload a file using FTPS. Apparently the 
placement of the “S” is kind of a big deal.

So let me start the question again. Is there a way to use Internet Commands to 
send a file to an FTPS account?

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Dec 19, 2017, at 11:40 AM, Milan Adamov via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> SFTP and FTP has nothing in common as protocols, you can’t expect FTP 
> commands to work with SFTP.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Keisuke Miyako via 4D_Tech]

IC offers low level TCP commands, so I guess technically, it's possible.
but the high level FTP commands do not support either implicit or explicit FTPS.
that's what moved me to write the curl-ftp plugin which uses curl internally 
but focuses on FTP tasks.

2017/12/20 10:49、Cannon Smith via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
So let me start the question again. Is there a way to use Internet Commands to 
send a file to an FTPS account?


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Cannon Smith via 4D_Tech]

Hi Miyako,

Thanks for that. I was a bit confused when reading the documentation of your 
plugin. Although I had SFTP on my mind at the time. So it does handle FTPS, 
then?

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Dec 19, 2017, at 7:09 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> IC offers low level TCP commands, so I guess technically, it's possible.
> but the high level FTP commands do not support either implicit or explicit 
> FTPS.
> that's what moved me to write the curl-ftp plugin which uses curl internally 
> but focuses on FTP tasks.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Keisuke Miyako via 4D_Tech]

Hi,

you can find examples of FTP, SFTP and FTPS in the sample DB.

in fact, because the backend library is curl and it accepts a URL not a host 
name,
you can pass http://, https:.., tftp://, telnet:// etc. to its send/receive 
commands.

2017/12/20 11:11、Cannon Smith via 4D_Tech 
<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> のメール：
I was a bit confused when reading the documentation of your plugin. Although I 
had SFTP on my mind at the time. So it does handle FTPS, then?


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Cannon Smith via 4D_Tech]

Thanks, Miyako.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Dec 19, 2017, at 7:47 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> in fact, because the backend library is curl and it accepts a URL not a host 
> name,
> you can pass http://, https:.., tftp://, telnet:// etc. to its send/receive 
> commands.
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Cannon Smith via 4D_Tech]

Hi Miyako,

I’m really struggling to get the right syntax to upload a file with your 
plugin. I can get it to work fine on the command line:

curl --ftp-ssl -T "/Users/Cannon/Desktop/test.zip" -u “install:redacted" 
"ftp://install.herdly.cloud/install/"; --connect-timeout 5

But can’t figure out the equivalent code with your plugin. Would it be possible 
to show me the way?

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Dec 19, 2017, at 7:47 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> you can find examples of FTP, SFTP and FTPS in the sample DB.
> 
> in fact, because the backend library is curl and it accepts a URL not a host 
> name,
> you can pass http://, https:.., tftp://, telnet:// etc. to its send/receive 
> commands.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Keisuke Miyako via 4D_Tech]

did you try the code snippet on the documentation?



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Keisuke Miyako via 4D_Tech]

> curl --ftp-ssl -T "/Users/Cannon/Desktop/test.zip" -u “install:redacted" 
> "ftp://install.herdly.cloud/install/"; --connect-timeout 5

translates to something like

$path:=System folder(Desktop)+"test.zip"

C_OBJECT($options)

OB SET($options;\
"URL";"ftps://install.herdly.cloud/install/test.zip";\
"USERNAME";"install";"redacted";"pass";"CONNECTTIMEOUT";5)

$createMissingDir:=1

$error:=cURL_FTP_Send (JSON Stringify($options);$path;$createMissingDir)

---

the local path is not POSIX. (this is mandatory)
the remote path includes the file name (it might work either way, haven't 
tested)



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Keisuke Miyako via 4D_Tech]

also, if you specify ftps instead of ftp,
you might have to pass CAINFO (see sample DB),
or else disable SSL_VERIFYHOST and SSL_VERIFYPEER





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Cannon Smith via 4D_Tech]

I did try to figure it out from the sample DB, but I guess I wasn’t smart 
enough. I’ve tried your example in the email alone, with SSL_VERIFYHOST set to 
0, with SSL_VERIFYPEER set to 0, with both set to 0. I’ve also tried using the 
CAINFO option with the very you have in the Resources folder. So far nothing 
has worked. I’m not sure what else to try. Also tried ftp, ftps, and tfps for 
the protocol.

--
Cannon Smith

> On Dec 20, 2017, at 2:59 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> also, if you specify ftps instead of ftp,
> you might have to pass CAINFO (see sample DB),
> or else disable SSL_VERIFYHOST and SSL_VERIFYPEER
> 
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Cannon Smith via 4D_Tech]

I’d like to thank Miyako for his help on this issue. It turned out that the 
plugin needed to be updated (twice!) to handle the type of FTP I was using and 
he did it all very quickly. If anyone else needs this, there is a version 1.2 
of the plugin available now.



Thanks, Miyako!

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Dec 20, 2017, at 2:53 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
>> curl --ftp-ssl -T "/Users/Cannon/Desktop/test.zip" -u “install:redacted" 
>> "ftp://install.herdly.cloud/install/"; --connect-timeout 5
> 
> translates to something like
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[ADeeg via 4D_Tech]

hmm, something is wrong in my code: it works with ftp and sftp, but not with
ftps (latest build ftp 1.2)

OB SET($options;\
"URL";"ftps://ftp.node.de/auto2.png";\
"USERNAME";"myuser";\
"PASSWORD";"mypass";\
"SSL_VERIFYHOST";0;\
"SSL_VERIFYPEER";0)

$createMissingDir:=1

$cacert:=Get 4D folder(Current resources folder)+"cacert.pem"
OB SET($options;\
"CAINFO";$cacert)  //need this for ftps
$path:=System folder(Desktop)+"auto2.png"

$error:=cURL_FTP_Send (JSON Stringify($options);$path;$createMissingDir)

Regards Armin


4D Tech mailing list wrote
> $path:=System folder(Desktop)+"test.zip"
> 
> C_OBJECT($options)
> 
> OB SET($options;\
> "URL";"ftps://install.herdly.cloud/install/test.zip";\
> "USERNAME";"install";"redacted";"pass";"CONNECTTIMEOUT";5)
> $createMissingDir:=1
> $error:=cURL_FTP_Send (JSON Stringify($options);$path;$createMissingDir)





--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Keisuke Miyako via 4D_Tech]

some FTP servers don't expect direct connection to port 990 (implicit),
they want you to first connect to port 21 and switch over to FTPS. (explicit)

https://en.wikipedia.org/wiki/FTPS

when that is the case, you need to add the following option:

"USE_SSL";"USESSL_TRY"



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP and Internet Commands

[Keisuke Miyako via 4D_Tech]

to be clear:

- set the protocol to ftps:// if you want to use implicit FTPS
- set the protocol to ftp:// and add the option USE_SSL if you want to use 
explicit FTPS

also, setting a "CAINFO" path and "SSL_VERIFYPEER" to 0 contradict each other.

> 2017/12/24 1:27、ADeeg via 4D_Tech <4d_tech@lists.4d.com> のメール：
>
> OB SET($options;\
> "URL";"ftps://ftp.node.de/auto2.png";\
> "USERNAME";"myuser";\
> "PASSWORD";"mypass";\
> "SSL_VERIFYHOST";0;\
> "SSL_VERIFYPEER";0)
>
> $createMissingDir:=1
>
> $cacert:=Get 4D folder(Current resources folder)+"cacert.pem"
> OB SET($options;\
> "CAINFO";$cacert)  //need this for ftps
> $path:=System folder(Desktop)+"auto2.png"




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: SFTP - Native to 4D?

[Stephen J. Orth via 4D_Tech]

We ended up using WinSCP as our SFTP tool.  It was easy to create a profile, 
write a BAT file, and send the information.


Steve


-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Janet Jonas 
via 4D_Tech
Sent: Wednesday, September 13, 2017 10:28 AM
To: 4d_tech@lists.4d.com
Cc: Janet Jonas 
Subject: SFTP - Native to 4D?

Does 4D have any native capability to do SFTP file transfers and/or generate a 
SSH-2 RSA public and private key pair?

Any pointers would be welcome.

JJ

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP - Native to 4D?

[John DeSoi via 4D_Tech]

> On Sep 13, 2017, at 10:27 AM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Does 4D have any native capability to do SFTP file transfers and/or generate 
> a SSH-2 RSA public and private key pair?

4D does not have any native capability to SFTP. For the Mac I ended up using 
curl via LAUNCH EXTERNAL PROCESS. 

4D can generate RSA key pairs.

http://doc.4d.com/4Dv16/4D/16.2/GENERATE-ENCRYPTION-KEYPAIR.301-3434177.en.html

John DeSoi, Ph.D.


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: SFTP - Native to 4D?

[Janet Jonas via 4D_Tech]

Thanks, Stephen, but we are an all Mac shop.

JJ

> On Sep 13, 2017, at 9:30 AM, 4d_tech-requ...@lists.4d.com wrote:
> 
> Message: 11
> Date: Wed, 13 Sep 2017 11:22:50 -0500
> From: "Stephen J. Orth"  <mailto:s.o...@the-aquila-group.com>>
> To: "'4D iNug Technical'" <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>>
> Cc: "'Janet Jonas'" mailto:ja...@prcousa.com>>
> Subject: RE: SFTP - Native to 4D?
> Message-ID: <009601d32cac$8ba0bac0$a2e23040$@the-aquila-group.com 
> <mailto:009601d32cac$8ba0bac0$a2e23040$@the-aquila-group.com>>
> Content-Type: text/plain; charset="utf-8"
> 
> We ended up using WinSCP as our SFTP tool.  It was easy to create a profile, 
> write a BAT file, and send the information.
> 
> 
> Steve
> 
> 
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com 
> <mailto:4d_tech-boun...@lists.4d.com>] On Behalf Of Janet Jonas via 4D_Tech
> Sent: Wednesday, September 13, 2017 10:28 AM
> To: 4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>
> Cc: Janet Jonas mailto:ja...@prcousa.com>>
> Subject: SFTP - Native to 4D?
> 
> Does 4D have any native capability to do SFTP file transfers and/or generate 
> a SSH-2 RSA public and private key pair?
> 
> Any pointers would be welcome.
> 
> JJ
> 
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: SFTP - Native to 4D?

[Janet Jonas via 4D_Tech]

Thanks, John for the link to the key creation information.

What do you launch with LEP?

JJ

> On Sep 13, 2017, at 12:00 PM, 4d_tech-requ...@lists.4d.com wrote:
> 
> Message: 7
> Date: Wed, 13 Sep 2017 12:17:07 -0500
> From: John DeSoi mailto:de...@pgedit.com>>
> To: 4D iNug Technical <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>>
> Subject: Re: SFTP - Native to 4D?
> Message-ID: <55177636-cb8c-4b1d-9a8b-3020e51db...@pgedit.com 
> <mailto:55177636-cb8c-4b1d-9a8b-3020e51db...@pgedit.com>>
> Content-Type: text/plain; charset=us-ascii
> 
> 
>> On Sep 13, 2017, at 10:27 AM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com 
>> <mailto:4d_tech@lists.4d.com>> wrote:
>> 
>> Does 4D have any native capability to do SFTP file transfers and/or generate 
>> a SSH-2 RSA public and private key pair?
> 
> 4D does not have any native capability to SFTP. For the Mac I ended up using 
> curl via LAUNCH EXTERNAL PROCESS. 
> 
> 4D can generate RSA key pairs.
> 
> http://doc.4d.com/4Dv16/4D/16.2/GENERATE-ENCRYPTION-KEYPAIR.301-3434177.en.html
>  
> <http://doc.4d.com/4Dv16/4D/16.2/GENERATE-ENCRYPTION-KEYPAIR.301-3434177.en.html>
> 
> John DeSoi, Ph.D.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP - Native to 4D?

[Janet Jonas via 4D_Tech]

John - 

I was familiar with the encryption command, we used it to generate a key for 
securing a website hosted by a copy of 4D, however the documentation talks 
about browsers. We would want to be sending files to another website via SFTP. 
Now we send similar files via regular 4D FTP commands in the Internet Commands 
component. Would we need a new private/public key pair for this? We also use a 
client certificate supplied to us for encrypting payments via LAUNCH EXTERNAL 
PROCESS using PHP cURL. Would that be the same type of thing we need for SHTP?

Again, any help/clues welcome.

JJ



> On Sep 13, 2017, at 1:18 PM, Janet Jonas  wrote:
> 
> Thanks, John for the link to the key creation information.
> 
> What do you launch with LEP?
> 
> JJ
> 
>> On Sep 13, 2017, at 12:00 PM, 4d_tech-requ...@lists.4d.com 
>> <mailto:4d_tech-requ...@lists.4d.com> wrote:
>> 
>> Message: 7
>> Date: Wed, 13 Sep 2017 12:17:07 -0500
>> From: John DeSoi mailto:de...@pgedit.com>>
>> To: 4D iNug Technical <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>>
>> Subject: Re: SFTP - Native to 4D?
>> Message-ID: <55177636-cb8c-4b1d-9a8b-3020e51db...@pgedit.com 
>> <mailto:55177636-cb8c-4b1d-9a8b-3020e51db...@pgedit.com>>
>> Content-Type: text/plain; charset=us-ascii
>> 
>> 
>>> On Sep 13, 2017, at 10:27 AM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com 
>>> <mailto:4d_tech@lists.4d.com>> wrote:
>>> 
>>> Does 4D have any native capability to do SFTP file transfers and/or 
>>> generate a SSH-2 RSA public and private key pair?
>> 
>> 4D does not have any native capability to SFTP. For the Mac I ended up using 
>> curl via LAUNCH EXTERNAL PROCESS. 
>> 
>> 4D can generate RSA key pairs.
>> 
>> http://doc.4d.com/4Dv16/4D/16.2/GENERATE-ENCRYPTION-KEYPAIR.301-3434177.en.html
>>  
>> <http://doc.4d.com/4Dv16/4D/16.2/GENERATE-ENCRYPTION-KEYPAIR.301-3434177.en.html>
>> 
>> John DeSoi, Ph.D.
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP - Native to 4D?

[Chuck Miller via 4D_Tech]

If you look in the archive you will find examples of using applescript to do 
this

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Sep 13, 2017, at 4:17 PM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Thanks, Stephen, but we are an all Mac shop.
> 
> JJ
> 
>> On Sep 13, 2017, at 9:30 AM, 4d_tech-requ...@lists.4d.com wrote:
>> 
>> Message: 11
>> Date: Wed, 13 Sep 2017 11:22:50 -0500
>> From: "Stephen J. Orth" > <mailto:s.o...@the-aquila-group.com>>
>> To: "'4D iNug Technical'" <4d_tech@lists.4d.com 
>> <mailto:4d_tech@lists.4d.com>>
>> Cc: "'Janet Jonas'" mailto:ja...@prcousa.com>>
>> Subject: RE: SFTP - Native to 4D?
>> Message-ID: <009601d32cac$8ba0bac0$a2e23040$@the-aquila-group.com 
>> <mailto:009601d32cac$8ba0bac0$a2e23040$@the-aquila-group.com>>
>> Content-Type: text/plain;charset="utf-8"
>> 
>> We ended up using WinSCP as our SFTP tool.  It was easy to create a profile, 
>> write a BAT file, and send the information.
>> 
>> 
>> Steve
>> 
>> 
>> -Original Message-
>> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com 
>> <mailto:4d_tech-boun...@lists.4d.com>] On Behalf Of Janet Jonas via 4D_Tech
>> Sent: Wednesday, September 13, 2017 10:28 AM
>> To: 4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>
>> Cc: Janet Jonas mailto:ja...@prcousa.com>>
>> Subject: SFTP - Native to 4D?
>> 
>> Does 4D have any native capability to do SFTP file transfers and/or generate 
>> a SSH-2 RSA public and private key pair?
>> 
>> Any pointers would be welcome.
>> 
>> JJ
>> 
>> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: SFTP - Native to 4D?

[Tim Nevels via 4D_Tech]

On Sep 13, 2017, at 4:48 PM, Janet Jonas wrote:

> Thanks, John for the link to the key creation information.
> 
> What do you launch with LEP?

I use WS_FTP software from ipswitch. This is what the client already had, so I 
used it.

https://www.ipswitch.com/secure-information-and-file-transfer/wsftp-client

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP - Native to 4D?

[John DeSoi via 4D_Tech]

Hi Janet,

> On Sep 13, 2017, at 3:18 PM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> What do you launch with LEP?

You launch "curl". Type "man curl" in Terminal to see the details. This is 
installed by default on macOS. Not sure if this is fixed in more recent macOS 
versions, but in older ones curl did not have the necessary OpenSSL support 
required to do SFTP. The work around required installing curl via brew (brew 
install curl --with-ssh).

It sounds like you are in the same situation I was -- an FTP requirement turned 
into SFTP. The letters are similar, but the protocols are totally unrelated. I 
ended up creating some 4D wrapper methods that can implement both protocols. 
Somewhat painful using LEP, but completely doable on the Mac.

John DeSoi, Ph.D.



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP - Native to 4D?

[John DeSoi via 4D_Tech]

Hi Janet,

> On Sep 13, 2017, at 3:40 PM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I was familiar with the encryption command, we used it to generate a key for 
> securing a website hosted by a copy of 4D, however the documentation talks 
> about browsers. We would want to be sending files to another website via 
> SFTP. Now we send similar files via regular 4D FTP commands in the Internet 
> Commands component. Would we need a new private/public key pair for this? We 
> also use a client certificate supplied to us for encrypting payments via 
> LAUNCH EXTERNAL PROCESS using PHP cURL. Would that be the same type of thing 
> we need for SHTP?

SFTP is basically a file transfer protocol for SSH. SSH supports two primary 
authentication options: passwords or keys. If you need to generate 
public/private keys for SFTP/SSH, you can use "ssh-keygen" on macOS (man 
ssh-keygen for details).

Using a "client certificate supplied to us for encrypting payments via LAUNCH 
EXTERNAL PROCES using PHP cURL" sounds like something unrelated to SFTP.

John DeSoi, Ph.D.


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP - Native to 4D?

[Koen Van Hooreweghe via 4D_Tech]

Hi Janet,

As others has mentioned, there is no native sftp client (yet?) in 4D. On Mac 
I’m using the OS built in sftp command which is called using LAUNCH EXTERNAL 
PROCESS.
For my purpose, I create a ‘batch’ file which contains the necessary sftp 
commands and then run it with sftp.

Eg. a possible content of the batch file could be:
cd /mydir
ls -1

Set the directory to mydir and get the directory listing. Keep in mind this is 
Unix, you must separate the lines with line feeds.

Then the command is like:
sftp -b ‘pathToBatchFileInPosixFormat’ -i ‘pathToIdentityFileInPosix’ 
-oPort= username@serveraddress

pathToIdentityFileInPosix is the path to the rsa file containing your key. This 
file is normally stored in your home folder in a .ssh directory: 
/Users/yourname/.ssh
You can use eg System folder(Desktop) to get the path to your home folder. Just 
toss out the last part of the path.

The fun with this is you can setup and test first in terminal and when all is 
working as expected, move to 4D.

HTH
Koen

> Op 13 sep. 2017, om 17:27 heeft Janet Jonas via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Does 4D have any native capability to do SFTP file transfers and/or generate 
> a SSH-2 RSA public and private key pair?
> 
> Any pointers would be welcome.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP - Native to 4D?

[Janet Jonas via 4D_Tech]

Koen - 

That was super helpful. Thanks to some Google-fu I was able to find out some 
instructions on making SFTP batch files and how to run them from terminal 
commands, your examples of the commands I would want specifically will make it 
all so much easier.

Thank you,

JJ

> On Sep 14, 2017, at 12:00 PM, 4d_tech-requ...@lists.4d.com wrote:
> 
> 
> Message: 5
> Date: Thu, 14 Sep 2017 11:36:56 +0200
> From: Koen Van Hooreweghe  <mailto:bvbacomp...@telenet.be>>
> To: 4D iNug Technical <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>>
> Subject: Re: SFTP - Native to 4D?
> Message-ID: <73045613-3643-403c-9ac3-37c845c0c...@telenet.be 
> <mailto:73045613-3643-403c-9ac3-37c845c0c...@telenet.be>>
> Content-Type: text/plain; charset=utf-8
> 
> Hi Janet,
> 
> As others has mentioned, there is no native sftp client (yet?) in 4D. On Mac 
> I’m using the OS built in sftp command which is called using LAUNCH EXTERNAL 
> PROCESS.
> For my purpose, I create a ‘batch’ file which contains the necessary sftp 
> commands and then run it with sftp.
> 
> Eg. a possible content of the batch file could be:
> cd /mydir
> ls -1
> 
> Set the directory to mydir and get the directory listing. Keep in mind this 
> is Unix, you must separate the lines with line feeds.
> 
> Then the command is like:
> sftp -b ‘pathToBatchFileInPosixFormat’ -i ‘pathToIdentityFileInPosix’ 
> -oPort= username@serveraddress
> 
> pathToIdentityFileInPosix is the path to the rsa file containing your key. 
> This file is normally stored in your home folder in a .ssh directory: 
> /Users/yourname/.ssh
> You can use eg System folder(Desktop) to get the path to your home folder. 
> Just toss out the last part of the path.
> 
> The fun with this is you can setup and test first in terminal and when all is 
> working as expected, move to 4D.
> 
> HTH
> Koen
> 
>> Op 13 sep. 2017, om 17:27 heeft Janet Jonas via 4D_Tech 
>> <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> het volgende geschreven:
>> 
>> Does 4D have any native capability to do SFTP file transfers and/or generate 
>> a SSH-2 RSA public and private key pair?
>> 
>> Any pointers would be welcome.
> 
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SFTP - Native to 4D?

[4dialog via 4D_Tech]

Have used CrushFtp/ CrushSync for many years for backup and sending xml data
to external partners.

It works very well, stable on Mac, flexible, easy to setup.





-
Hilsen
--
Helge Antonsen
4Dialog as
Tel: +47 64 000 164
Mob: +47 90 15 56 19
Web: www.4dialog.no 
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

CURL SFTP issues with SSH

[Peter Hay via 4D_Tech]

Hi,

I'm using Miyako's CURL-FTP plugin to try and connect to an SFTP site using
SSH keys, but I keep getting an error 67.  I've tried the same settings
using CURL from the command line, and get the same error.  I've also tried
the same thing using FileZilla and it works perfectly, so I know the SSH
Keys files are in good shape.

When I run CURL form the command line in verbose mode, here's what I get;

curl -u THEUSER: --key "C:\SSH_Private.ppk" --pass "ThePassword" --pubkey
"C:\SSH_Public.key" sftp://ftp.thesite.com/OUT/ -v -k
*   Trying 123.456.789.0 :22...
* TCP_NODELAY set
* Connected to ftp.thesite.com (123.456.789.0) port 22 (#0)
* SSH MD5 fingerprint: 4dc2acee06bdaa70fc67412187362428
* SSH authentication methods available:
publickey,password,keyboard-interactive
* Using SSH public key file 'C:\SSH_Public.key'
* Using SSH private key file 'C:\SSH_Private.ppk'
* SSH public key authentication failed: Invalid key data, not base64 encoded
* Failure connecting to agent
* Authentication failure
* Closing connection 0
curl: (67) Authentication failure


I've obfuscated some of the details, but you get the idea.

The main problem seems to be that CURL thinks the Public Key should be
Base64 encoded.  I'm pretty sure that it is.  It looks like this;

 BEGIN SSH2 PUBLIC KEY 
B3NzaC1yc2EAAA  ...   4QvuPGkd+ocvyWQ==
 END SSH2 PUBLIC KEY 


As I said, FileZilla works fine with all of this.

Does anyone have any idea what the issue may be?

-- 
Pete Hay
Managing Director
Foreground Software Limited
New Zealand
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

File Transmission to SFTP Server

[Tarawerkz via 4D_Tech]

Hi, 

I would like to ask if there is native support in 4D v17 too send text files 
from 4D Server (on Windows Server 2012) to an sFTP server?

Regards,
Ronnie



**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: CURL SFTP issues with SSH

[Kirk Brooks via 4D_Tech]

Hey Peter,
I can't give you the specific answer but if you haven't already I'd
recommend installing Postman <https://www.getpostman.com/>.
How that may help you is you can look at exactly what is being sent and
received from the destination. The first thing I'd do is capture the
traffic with FileZilla and compare it to the traffic between 4D. That will
at least show you what's different between the two.

Hope this helps

On Thu, Nov 21, 2019 at 12:44 PM Peter Hay via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi,
>
> I'm using Miyako's CURL-FTP plugin to try and connect to an SFTP site using
> SSH keys, but I keep getting an error 67.  I've tried the same settings
> using CURL from the command line, and get the same error.  I've also tried
> the same thing using FileZilla and it works perfectly, so I know the SSH
> Keys files are in good shape.
>
> When I run CURL form the command line in verbose mode, here's what I get;
>
> curl -u THEUSER: --key "C:\SSH_Private.ppk" --pass "ThePassword" --pubkey
> "C:\SSH_Public.key" sftp://ftp.thesite.com/OUT/ -v -k
> *   Trying 123.456.789.0 :22...
> * TCP_NODELAY set
> * Connected to ftp.thesite.com (123.456.789.0) port 22 (#0)
> * SSH MD5 fingerprint: 4dc2acee06bdaa70fc67412187362428
> * SSH authentication methods available:
> publickey,password,keyboard-interactive
> * Using SSH public key file 'C:\SSH_Public.key'
> * Using SSH private key file 'C:\SSH_Private.ppk'
> * SSH public key authentication failed: Invalid key data, not base64
> encoded
> * Failure connecting to agent
> * Authentication failure
> * Closing connection 0
> curl: (67) Authentication failure
>
>
> I've obfuscated some of the details, but you get the idea.
>
> The main problem seems to be that CURL thinks the Public Key should be
> Base64 encoded.  I'm pretty sure that it is.  It looks like this;
>
>  BEGIN SSH2 PUBLIC KEY 
> B3NzaC1yc2EAAA  ...   4QvuPGkd+ocvyWQ==
>  END SSH2 PUBLIC KEY 
>
>
> As I said, FileZilla works fine with all of this.
>
> Does anyone have any idea what the issue may be?
>
> --
> Pete Hay
> Managing Director
> Foreground Software Limited
> New Zealand
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
Kirk Brooks
San Francisco, CA
===

What can be said, can be said clearly,
and what you can’t say, you should shut up about

*Wittgenstein and the Computer *
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: CURL SFTP issues with SSH

[John DeSoi via 4D_Tech]

I had the same situation recently, everything worked with a SFTP client or SFTP 
from the command line. I could not get it to work using curl and --key options 
(curl 7.64.0 (x86_64-apple-darwin18.2.0) libcurl/7.64.0 SecureTransport 
zlib/1.2.11 libssh2/1.8.0). I finally just gave up and switched to using the 
built in SFTP on the Mac.


> * SSH public key authentication failed: Invalid key data, not base64 encoded
> * Failure connecting to agent
> * Authentication failure
> * Closing connection 0
> curl: (67) Authentication failure
> 
> 
> I've obfuscated some of the details, but you get the idea.
> 
> The main problem seems to be that CURL thinks the Public Key should be
> Base64 encoded.  I'm pretty sure that it is.  It looks like this;

You might also look at the private key. I think the error line above is telling 
you generally "public key authentication" failed, and is not specifically 
referring to your SSH_Public.key file. You probably need to convert the ppk 
file for OpenSSH somehow.


John DeSoi, Ph.D.


> On Nov 21, 2019, at 2:44 PM, Peter Hay via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> As I said, FileZilla works fine with all of this.
> 
> Does anyone have any idea what the issue may be?

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: CURL SFTP issues with SSH

[Tom Benedict via 4D_Tech]

I second the recommendation. You don’t even need to know much about Postman to 
use it. It’s got a zillion features, but, at least in my experience, it always 
seems to know what I want to do after minimal fiddling.

Tom Benedict

> On Nov 21, 2019, at 13:13, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hey Peter,
> I can't give you the specific answer but if you haven't already I'd
> recommend installing Postman <https://www.getpostman.com/>.
> How that may help you is you can look at exactly what is being sent and
> received from the destination. The first thing I'd do is capture the
> traffic with FileZilla and compare it to the traffic between 4D. That will
> at least show you what's different between the two.
> 
> Hope this helps
> 
> On Thu, Nov 21, 2019 at 12:44 PM Peter Hay via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> Hi,
>> 
>> I'm using Miyako's CURL-FTP plugin to try and connect to an SFTP site using
>> SSH keys, but I keep getting an error 67.  I've tried the same settings
>> using CURL from the command line, and get the same error.  I've also tried
>> the same thing using FileZilla and it works perfectly, so I know the SSH
>> Keys files are in good shape.
>> 
>> When I run CURL form the command line in verbose mode, here's what I get;
>> 
>> curl -u THEUSER: --key "C:\SSH_Private.ppk" --pass "ThePassword" --pubkey
>> "C:\SSH_Public.key" sftp://ftp.thesite.com/OUT/ -v -k
>> *   Trying 123.456.789.0 :22...
>> * TCP_NODELAY set
>> * Connected to ftp.thesite.com (123.456.789.0) port 22 (#0)
>> * SSH MD5 fingerprint: 4dc2acee06bdaa70fc67412187362428
>> * SSH authentication methods available:
>> publickey,password,keyboard-interactive
>> * Using SSH public key file 'C:\SSH_Public.key'
>> * Using SSH private key file 'C:\SSH_Private.ppk'
>> * SSH public key authentication failed: Invalid key data, not base64
>> encoded
>> * Failure connecting to agent
>> * Authentication failure
>> * Closing connection 0
>> curl: (67) Authentication failure
>> 
>> 
>> I've obfuscated some of the details, but you get the idea.
>> 
>> The main problem seems to be that CURL thinks the Public Key should be
>> Base64 encoded.  I'm pretty sure that it is.  It looks like this;
>> 
>>  BEGIN SSH2 PUBLIC KEY 
>> B3NzaC1yc2EAAA  ...   4QvuPGkd+ocvyWQ==
>>  END SSH2 PUBLIC KEY 
>> 
>> 
>> As I said, FileZilla works fine with all of this.
>> 
>> Does anyone have any idea what the issue may be?
>> 
>> --
>> Pete Hay
>> Managing Director
>> Foreground Software Limited
>> New Zealand
> 
> - 
> Kirk Brooks
> San Francisco, CA

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: File Transmission to SFTP Server

[John DeSoi via 4D_Tech]

There is no SFTP support in any version of 4D. You have to implement it 
yourself using external tools. I use CURL and LAUNCH EXTERNAL PROCESS. Start 
here for options:

https://discuss.4d.com/search?q=sftp 

John DeSoi, Ph.D.


> On Jun 2, 2021, at 4:18 AM, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I would like to ask if there is native support in 4D v17 too send text files 
> from 4D Server (on Windows Server 2012) to an sFTP server?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**