Re: SFTP & PGP Encryption
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 & PGP Encryption
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
> 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 **
SFTP & PGP Encryption
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 **