We have an Azure WebJob that needs to connect to a remote PostgreSQL database via encrypted connection. This job interacts with a customer's database so the connection string and SSL certificate files are dynamic and cannot be deployed with the service, either as a separate file or an embedded resource. The connection string not a problem, but the SslOptions class appears to only accept paths to files.
Searching the web and these forums, the 6.0 release from 2012 notes say:
"The MemCryptStorage class for storing SSL certificates in the application memory is implemented."
We tried using this and calling the AddCert and AddKey methods but it did not work. Searching the web, DevArt documentation, and DevArt forums, there is almost zero information on this class. This surprises me because loading keys and certs from memory seems like a reasonably common scenario.
Questions
- Is there any official documentation on MemCryptStorage?
- Both AddCert and AddKey require a "id" parameter. How is this parameter later used? Is there some id value that needs to be set on the connection or something to get it to find the stored credentials?
- Is MemCryptStorage the correct way to accomplish our goal?
- Is there any way to accomplish our goal with dotConnect for PostgreSQL?
Dave Parker