Open Dental Forum

Hello world,

I'm interested in moving away from DropBox as a storage engine and am looking at the SSH option and have a few questions to that effect:

0) This is to the community: how has your experience been using SFTP in production?
1) How are the SFTP credentials protected?
2) Are there any plans for (or is it currently possible but undocumented) implementing key based authentication with the SFTP server? (Exposing port 22 with password based authentication just doesn't sit well)

How are the SFTP credentials protected?

The username is stored the the Open Dental database in plain text. The password is obfuscated and also stored in the database.

Are there any plans for (or is it currently possible but undocumented) implementing key based authentication with the SFTP server?

We do not currently have plans for this. A couple months ago I needed to connect to an SFTP server that required a key file, so I modified my local Open Dental program. It was a pretty simple change, so a feature request wouldn't be too difficult.

Thanks Chris, as always you're quick to reply and your reply is helpful!

Has the Key Based Authentication with SFTP server been implemented?

It has not been implemented. I don't believe the feature request that Chris suggested was ever submitted.

We tried setting up SFTP for trial. The performance test came out ok, however it takes 4-5 sec for each documents and these documents are of size less than 100k