Mongo DB Query component and self-signed certificates
Is there a way to configure the MongoDB Query component to accept a self-signed certificate for SSL?
I have a scenario where the MongoDB instance I'm querying uses SSL, but the certificate in use is self-signed. When connecting via MongoDB Compass (for example), I can specify that I'll accept the self-signed certificate by specifying the sslAllowInvalidCertificates parameter, but I can't seem to get this to work with the MongoDB Query component. Once I indicate we're using SSL, it gives me a JDBC exception because the certificate doesn't contain a valid root certifying authority.
Has anybody successfully dealt with this scenario, and if so, how?
6 Community Answers
Ian Funnell —
Please could you try adding a Connection Option, and setting SSLServerCert to just a single * character.