question

tym-8147 avatar image
0 Votes"
tym-8147 asked WarnerSmith-7159 commented

Data Factory PostgreSQL Error "Cannot load trust store"

I am trying to make a Copy Data connection to an external (IBM bare-metal) PostgreSQL server with SSL encryption. I have verified the certificate over ODBC locally, but keep getting "Cannot load trust store" error from the ADF PostgreSQL connector if I try to set the connection to Validate server certificate. I don't see a way to set TrustStore parameters in the interface, and wouldn't know what they need to be set to in order to avoid the error. Has anyone else run into this and found a solution?

azure-data-factory
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi there,

Can you please share a screenshot of the error? That will help us to diagnose the issue faster.

0 Votes 0 ·

8988-screen-shot-2020-06-03-at-161149.png



Here is the error screenshot

0 Votes 0 ·

Hi Tym,

Sorry for the delayed response. Was the issue resolved?

0 Votes 0 ·

1 Answer

ChiragMishra-MSFT avatar image
0 Votes"
ChiragMishra-MSFT answered WarnerSmith-7159 commented

Hi @tym-8147,

Sorry for the delay in my response. Was your issue resolved?

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @tym-8147,


Just wanted to check - was your issue resolved? Or do you need assistance?


0 Votes 0 ·
RULS-5897 avatar image RULS-5897 ChiragMishra-MSFT ·

Hello, I just run into the same issue, could you please assistant me?

0 Votes 0 ·

Hello - Also hit this same error creating a PostgreSQL linked service using a self-hosted integration runtime with ValidateServerCertificate=1. Although the requester hasn't responded it would be helpful to update this post with official guidance on what's supported and what steps should be taken when this connection failure is encountered. If the solution is to turn off ValidateServerCertificate, it would be helpful to to have an explanation on how the risk of a ManInTheMiddle attack is mitigated. Thank you!

0 Votes 0 ·