[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)

Egor_Gerimo · 2023-01-16T12:57:46.893Z

I’m new with mongodb. I’ve tried to add new entry and get this error.

Jack_Woehr · 2023-01-17T04:34:03.564Z

Are you getting this Compass or mongosh or in a program?
If your installation has a self-signed certificate, you have to tell MongoDB tooling where to get a copy of the acceptable certificate.
E.g., in PHP, you’d connect something like
new MongoDB\Client($mongodb_uri, b['tls' => true, 'tlsCAFile' => $mongodb_cert_path]);

Andres_Castaneda · 2023-01-21T03:37:05.993Z

I saw an answer that worked for me, it appears i had not yet installed the python certificates on my mac, so from the following path i went and installed it

/Applications/Python 3.10/Install Certificates.command

Only change the version of your python, after that everything, worked fine for me

PS: I had been trying to solve the problem for half a day, I even asked ChatGPT

Egor_Gerimo · 2023-01-23T10:22:02.930Z

Unfortunately that didn’t help

Egor_Gerimo · 2023-01-23T10:22:51.963Z

Using pyCharm, macOs Ventura 13.1

Full code:

from pymongo import MongoClient
cluster = MongoClient('mongodb+srv://pystudy:<password>@cluster0.fyglnvy.mongodb.net/?retryWrites=true&w=majority')
db = cluster['test']
collection = db['test']

post = {'_id': 0, 'name': 'Jeff', 'score': 9}
collection.insert_one(post)

Yilmaz_Durmaz · 2023-01-23T10:54:48.884Z

open a new terminal and follow these (use “python” and “pip” if “python3” and “pip3” does not work):

create a test folder and cd into it: mkdir test && cd test
create clean environment python3 -m venv .venv (do MacOS use python or python3 for v3.x? )
and activate it: .venv/Scripts/activate
install pymongo only : pip3 install pymongo
you should see this clean list: pip3 list (versions might change)

Package Version

dnspython 2.3.0
pip 22.2.2
pymongo 4.3.3
setuptools 63.2.0
and start python repl: python3
copy-paste your code above (replace password) and run in the repl.

if your code works this way, then the installation pycharm uses might be broken and need a repair or full reinstllation. (or pycharm is broken)

if not, then either your system has a problem or you messed with some settings in Atlas (I can’t point any).

Joe_Montanari · 2023-03-01T15:00:31.541Z

This worked for me.
Thank you mate!

Jim_Olivi · 2023-03-12T15:04:44.680Z

I had similar problems and it felt like I tried everything. MacOS Ventura 13.2.1, PyCharm 2022.3.3 Professional, Python 3.11.2

The final fix…

I rebooted!!!

So, some of these changes don’t take effect until a complete reboot.

Info_Pixienetwork · 2023-04-20T09:31:19.242Z

For me - After a few hours I found this thread that said that I need to open the client using certifi

stackoverflow.com

PyMongo [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate

python-3.x, mongodb, ssl, mongodb-atlas

asked by MaxwellN on 11:59PM - 24 Jun 21 UTC

Able to use Compass with no problems, Atlas UI all looks good but couldn’t connect using Python.

Using Python 3.11, pymongo==3.11, Mac Monterey, VS Code

As a newbie I am disappointed that I had to spend a lot of time on ChatGPT and Google to resolve this.
Not a fantastic first impression but happy to blame myself for something i missed - maybe others will miss whatever I missed too…

suzyy_tom · 2023-04-20T11:07:14.353Z

Thank you mate!

This worked for me.

Adil_Azeez · 2023-07-01T11:32:08.742Z

Thanks, worked for me!

Erik_Williams · 2024-02-21T03:43:38.350Z

Upgrading from pip3 23.2.1 to 24.0 fixed this issue for me. No clue why!

Geoffrey_Sautreau · 2024-03-13T16:11:48.833Z

Thank you, I had to do it after upgrading Python to 3.11

ashish_rajoria · 2024-04-24T07:52:28.986Z

This worked for me

pip install certifi

adamo_figueroa · 2024-09-09T09:58:05.814Z

wow still working on Sep 2024, looks like Mac does not install certificates by default, but the file is there, just go to the folder applications/ python 12.5 and click on install certificates, everything works after that

Ellite_Garcia · 2025-05-02T07:30:39.853Z

The error [[SSL: CERTIFICATE_VERIFY_FAILED](https://cheapsslweb.com/blog/ssl-certificate-verify-failed-error-in-python/)] means your system can’t verify MongoDB’s SSL certificate—usually because it’s missing the root or intermediate certificates. This often happens if you’re using Python (like with pymongo) on macOS or Windows without proper certificates installed. A quick fix is to disable certificate validation (only for testing!) using ssl_cert_reqs=ssl.CERT_NONE in your connection string. For a secure fix, download and install the missing CA certificates or update your system’s certificate store. Avoid skipping SSL checks in production environments.