Key store Issue while connecting to Mongo DB

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Ok. I am not pretty sure about this issue.

But lets check with other experts @xdshi  and @rhall 

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

[Anonymous]

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