Key store Issue while connecting to Mongo DB

Highlighted
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

Five Stars

Re: Key store Issue while connecting to Mongo DB

Hello Nikhil,

 

We were able to connect to Mongo DB from command line, as the firewall set up is done. We got a new certificate, out of which we generated a key store and used the same key store in our talend job and tried re-running the job. 

 

However job is still its failing with same issue as before : 

 

[FATAL]: mongoone.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=<<mongodbserver>>:<<portnumber>>, 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}}]

From this, we could see its not about the connectivity issue between our production server and mongo DB server, seems like a certificate issue or key store issue. Would you be able to suggest us anything here.

 

Regards,

Venu

 

 

Employee

Re: Key store Issue while connecting to Mongo DB

Ok. I am not pretty sure about this issue.

 

But lets check with other experts @xdshi  and @rhall_2_0 

 

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

Community Manager

Re: Key store Issue while connecting to Mongo DB

The approach described here might help. I am not certain, but this is what I would try first

https://help.talend.com/reader/hCrOzogIwKfuR3mPf~LydA/vtX3yufxJvu5vRasGDVfng

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