mongo_fdw icon indicating copy to clipboard operation
mongo_fdw copied to clipboard

Can't connect Mongo 3.4.23 at Mongo Atlas that requires SSL Self-Signed Certificate

Open efron opened this issue 4 years ago • 1 comments

Hi,

I'm trying to connect Postgre mongo_fdw to Mongo 3.4.23 at Mongo Atlas that requires SSL Self-Signed Certificate with no success.

Beyond host, port, user and password, it requires the following parameters:

ssl=true
authSource=admin
w=majority

and the SSL as Self-Signed Certificate

image

However I can't figure out where to pass those parameters inside pgAdmin as the picture shows:

image

This is the error message in text:

ERROR:  invalid option "weak_cert_validation"
HINT:  Valid options in this context are: username, password
SQL state: HV00D

Is there any other place to pass these parameters, maybe a file in Ubuntu or something? Can anybody help me please to know how to pass those parameters correctly?

Thanks, in advance. Hernán

efron avatar Oct 12 '19 01:10 efron