Using a .PEM certificate with a MongoDB adapter. The connection fails with 'java.security.cert.CertificateException: Server not trusted by the user'

Using a .PEM certificate with a MongoDB adapter. The connection fails with 'java.security.cert.CertificateException: Server not trusted by the user'

book

Article ID: KB0082967

calendar_today

Updated On:

Description

This article discusses the type of SSL certificate that a MongoDB data source will accept.

Resolution

The TIBCO Data Virtualization server does not support .PEM certificates. If you use a .PEM certificate, you will receive an error of the type below:
 
com.compositesw.cdms.webapi.WebapiException: Unable to create a connection for data source
"/shared/DataSources/Physical/Metadata/MongoDB/test_connection". [datasrc-3961000]
Cause: Cannot conclude ssl handshake. Cause: java.security.cert.CertificateException: Server not trusted by the user.
 
You will need to use a .CER certificate.  If you still see the error, follow the steps below:
 
(1)   Use keytool to import the certificate chain into the server strong truststore
Details on keytool and the server strong truststore may be found in the Administration Guide.

(2)  Leave the SSL cert field in the MongoDB data source empty
If the field contains no value, the TIBCO Data Virtualization server will default to using the server strong truststore. This ensures that the certificate is specifically retrieved from this file.

Issue/Introduction

Using a .PEM certificate with a MongoDB adapter. The connection fails with 'java.security.cert.CertificateException: Server not trusted by the user'