Key store Issue while connecting to Mongo DB

Five Stars

Key store Issue while connecting to Mongo DB

Hi,

 

This is regarding one of the talend job in Data wareHouse which connects to the MongoDB (In order to connect to the source MongoDB database, a Java Key store is required. This component reads the contents of that key store and passes it to the next component) to pull the data. 

However, the job is getting failed with following error when its trying to connect to Mongo DB. 

 

Error Message : 

 

"[FATAL]: protocol.mongo_read_runtime_param_0_1.mongo_read_runtime_param - tMongoDBConnection_1 Timed out after 30000 ms while waiting to connect. Client view of cluster state is
{type=UNKNOWN, servers=[{address=<<mongo db host name and port >>, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketOpenException: Exception opening socket},
caused by {java.net.SocketException: java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: IBMJSSE2, class: com.ibm.jsse2.aj)},
caused by {java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: IBMJSSE2, class: com.ibm.jsse2.aj)}, caused by
{java.io.IOException: Keystore was tampered with, or password was incorrect}, caused by {java.security.UnrecoverableKeyException: Password verification failed}}]"

 

In order to fix the above issue, we have tried following options:

1. We tried to create a key store ( Unix and Windows ) from the existing certificate also with the downloaded certificate (https://vault.optimus-dev-new.slc.co.uk/v1/pki/ca/pem )

2. We tried to change the password to default in the Talend job which is for keystore.

 

Please help me here.

 

Regards,

Venu

Employee

Re: Key store Issue while connecting to Mongo DB

Hi,

 

   Are you able to connect to MongoDB through command line mode? Did you try username and password method to connect to DB? Could you please share a screenshot of the job and component after masking the confidential values?

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now