SSL handshake failed while connecting to cosmos DB for MongoDB using pymongo

Michael 31

Hi,

I created an Azure Cosmos DB for MongoDB account in azure. I got SSL handshake failed error while connecting to it using pymongo.

This is how I connect:

from pymongo import MongoClient

client = MongoClient('mongodb://<account>:<password>@<account>.mongo.cosmos.azure.com:10255/?ssl=true&appName=@<account>@')

client.list_database_names()

I got error:


ServerSelectionTimeoutError: SSL handshake failed: <account>.mongo.cosmos.azure.com:10255: timed out, Timeout: 30s, Topology Description: <TopologyDescription id: 63fd123bc7b2500fd385cc68, topology_type: Single, servers: [<ServerDescription ('<account>.mongo.cosmos.azure.com', 10255) server_type: Unknown, rtt: None, error=NetworkTimeout('SSL handshake failed: <account>.mongo.cosmos.azure.com:10255: timed out')>]>

I have tried 3.2, 3.6, 4.0 and 4.2 version, but got same error for all of them. I'm using python 3.8 in WSL 2.0. (also tried python on windows but got same error too.) I have also verified my python is using TLS 1.2.

Can anyone please help?

Oury Ba-MSFT 18,021 Reputation points Microsoft Employee

2023-02-28T16:31:16.4+00:00

Michael Thank you for reaching out.

I am trying to reproduce this issue from my end. I will let you know the result soon.

Regards,

Oury
Michael 31 Reputation points

2023-02-28T18:05:25.7466667+00:00

Hi Oury,

Probably this is not an issue on your end. I would like to know how to troubleshoot this. Seems to me it is a SSL issue on my side, but I'm not sure where the issue comes from and how to resolve it..

Thanks,

Michael
Michael 31 Reputation points

2023-02-28T18:16:20.83+00:00

I also tried using Azure Data Studio to connect, but got "Failed to connect" error:
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee

2023-03-01T20:05:44.74+00:00

Michael Thank you for getting back. This could also be bug but we cannot confirm that yet. We will need to test this from our end and let you know ASAP.

Regards,

Oury
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee

2023-03-01T22:52:51.81+00:00

Michael Could you please try using the connection string in the azure portal on Mongo dB API database page under quick start.

Regards,

Oury
Michael 31 Reputation points

2023-03-03T18:02:14.2466667+00:00

Hi Qury,

I tried using the connection string in the portal, but still get same issue. Here is a screenshot.

Thanks,

Michael
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee

2023-03-06T18:02:24.7033333+00:00

Michael I would suggest if you have a support plan to open a support case so we can further investigate with proper tool.

Regards,

Oury
Michael 31 Reputation points

2023-03-08T22:38:51.3066667+00:00

Thank you Qury. It turns out to be our internal issue. the problem is fixed.
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee

2023-03-10T21:48:28.77+00:00

Michael

Thank you so much for letting us know. I am glad it is finally resolved.

Regards,

Oury
PALMA MARTINEZ, YERAY (EXTERNAL) 25 Reputation points

2023-08-17T07:10:17.0566667+00:00

Good morning Michael,

I seem to be having the same problems as you with connecting to the database. Could you tell me how you solved the problem? It would be a great help for me.

Thanks in advance,

Yeray
Christopher Ifeanyi Eteka 5 Reputation points

2023-11-13T14:24:11.63+00:00

Faced similar issue recently while using spring-cloud-azure-starter-data-cosmos, turns out that I needed to set the Connection Mode configuration to GATEWAY, this defaults so DIRECT if not specified, and in my case I was getting the error when the it is set to DIRECT.

I hope this helps

Share via

SSL handshake failed while connecting to cosmos DB for MongoDB using pymongo