topic Re: need help with connection to MongoDB in Talend Studio

need help with connection to MongoDB

jchen — Sat, 16 Nov 2024 00:54:20 GMT

Hi, Need some help.

I am getting exception error while trying to connect MongoDB using tMongoDBConnection component from Talend Open Studio for Big Data 7.2.1.

com.mongodb.MongoTimeoutException: Timed out after 30000 ms while waiting to connect

I was able to connect on the same machine via MongoDB Compass and NoSQLBooster.

Any troubleshooting tips would be appreciated.

Thanks,

Jun

Re: need help with connection to MongoDB

Anonymous — Mon, 28 Dec 2020 04:07:46 GMT

Hello,

Are you trying to connect the MongoDB Atlas cluster？Did you provide the replica address for the cluster on the tMongoDBConnection component? We will appreciate it a lot if you could post your tMongoDBConnection component setting screenshots here.

Best regards

Sabrina

Re: need help with connection to MongoDB

jchen — Mon, 28 Dec 2020 14:14:40 GMT

Hi Sabrina,

Thank you for getting back to me. Attach is the setting for tMongoDBConnection.

Yes, I am trying to connect to MongoDB Atlas (4.2.11 Enterprise) on AWS.

Thanks,

Jun

Re: need help with connection to MongoDB

Anonymous — Tue, 29 Dec 2020 03:58:50 GMT

Hello,

To connect to the Mongo DB Atlas (tMongoDBConnection component), please select the replica host and provide a list of replica hosts. Also, you no need to set the Keystore component as it is built-in on the mongo DB Atlas. please remove also key store component.

Let us know if it works.

Best regards

Sabrina

Re: need help with connection to MongoDB

jchen — Tue, 29 Dec 2020 19:12:55 GMT

Thanks, Sabrina.

I tried using Replica Host option (see attach) and still getting the same error.

Is a list of hosts required? I only put in one host.

Thanks,

Jun

Re: need help with connection to MongoDB

jchen — Tue, 29 Dec 2020 20:24:09 GMT

This is whole error message. Could it be that Common Name is not matching with the host?

Exception in component tMongoDBConnection_1 (Load_VFD)

com.mongodb.MongoTimeoutException: Timed out after 30000 ms while waiting to connect.

Client view of cluster state is {type=UNKNOWN, servers=[{address=xxxxx.xxxxxxxx.xxxxxxx.healthcareit.net:27017,

type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketWriteException: Exception sending message},

caused by {javax.net.ssl.SSLHandshakeException: java.security.cert.CertificateException:

No subject alternative DNS name matching xxxxx.xxxxxxxx.xxxxxxx.healthcareit.net found.},

caused by {java.security.cert.CertificateException: No subject alternative DNS name matching xxxxx.xxxxxxxx.xxxxxxx.healthcareit.net found.}}]

Re: need help with connection to MongoDB

Anonymous — Wed, 30 Dec 2020 05:19:10 GMT

Hello,

Does this exception come when run from the STUDIO to the local? Did you use any tsetkeystore when enable SSL connection?

Best regards

Sabrina

Re: need help with connection to MongoDB

jchen — Wed, 30 Dec 2020 13:15:51 GMT

No, it's not running from local. I am not using tsetkeystore when enable SSL.

Thanks,

Jun

Re: need help with connection to MongoDB

jchen — Mon, 04 Jan 2021 15:04:33 GMT

Hi Sabrina,

This is the option I used to connect to mongodb in Compass too. Do I need to use the tSetKeystore?

Thanks,

Jun

Re: need help with connection to MongoDB

Anonymous — Tue, 05 Jan 2021 04:59:43 GMT

Hello,

Do you have the Certificate, Certificate Authority and Private key files to connect to MongoDB through Talend Using SSl Connection?

Let us know if this article is helpful for you in understanding the SSL certificate setup

https://unix.stackexchange.com/questions/347116/how-to-create-keystore-and-truststore-using-self-signed-certificate

Best regards

Sabrina

Re: need help with connection to MongoDB

jchen — Tue, 05 Jan 2021 14:45:26 GMT

No, I don't. I will try to get one. So, do I need to use the tSetKeystore since this is a SSL connection? Thanks!

Re: need help with connection to MongoDB

Anonymous — Wed, 06 Jan 2021 05:25:24 GMT

Hello,

To connect to the HTTPS URL of a non-public server, you must provide the Talend Job or Talend server with the SSL certificate file of the server you are trying to connect to.

Connecting to various public servers, such as GitHub or Microsoft, is often easy (that is, you do not have to do any special configuration) because your browser and your Job can check the validity of those servers' SSL certificates with a public certificate authority.

However, if you are trying to connect to a non-public server such as your internal Jira server; for example, jira.mycompany.com, that server's SSL certificate is not known to the public certificate authorities, so you need to configure your Job or Talend server to trust that SSL certificate, and therefore trust that Jira server.

For more information, see the Java67 article, Difference between trustStore vs keyStore in Java SSL.

Best regards

Sabrina

Re: need help with connection to MongoDB

jchen — Thu, 14 Jan 2021 15:47:32 GMT

Hi,

I got the keystore and trustore files. I have setup as shown in attach. Is this correct? I am still getting the same error. Please help.

thanks,

Jun

Re: need help with connection to MongoDB

jchen — Fri, 05 Feb 2021 17:04:52 GMT

the issue was resolved. it was caused incorrect certificate. thank you for your help.

Re: need help with connection to MongoDB

Anonymous — Mon, 08 Feb 2021 06:30:51 GMT

Hello,

Thanks for your feedback and letting us know it is resolved by yourself.

Best regards

Sabrina