몽고DB 연결 문제 문의 드립니다.

화면처럼 certifi 설치까지 몇 차례 진행했으나 연결이 되지 않네요.

from pymongo import MongoClient

client = MongoClient('mongodb+srv://sparta:test@cluster0.l6f3uwp.mongodb.net/?retryWrites=true&w=majority')

db = client.dbsparta

doc = {

    'name':'영수',

    'age':24

}

db.users.insert_one(doc)

82108@LAPTOP MINGW64 ~/Desktop/sparta/pythonprac

$ source c:/Users/82108/Desktop/sparta/pythonprac/venv/Scripts/activate

(venv) 

82108@LAPTOP MINGW64 ~/Desktop/sparta/pythonprac

$ c:/Users/82108/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/82108/Desktop/sparta/pythonprac/dbprac.py

Traceback (most recent call last):

 File "c:/Users/82108/Desktop/sparta/pythonprac/dbprac.py", line 9, in <module>

  db.users.insert_one(doc)

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one

  self._insert_one(

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one

  self.__database.client._retryable_write(acknowledged, _insert_command, session)

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write

  with self._tmp_session(session) as s:

 File "C:\Users\82108\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__

  return next(self.gen)

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session   

  s = self._ensure_session(session)

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session 

  return self.__start_session(True, causal_consistency=False) 

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session 

  self._topology._check_implicit_session_support()

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support

  self._check_session_support()

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support

  self._select_servers_loop(

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop 

  raise ServerSelectionTimeoutError(

icaSetNoPrimary, servers: [<ServerDescription ('ac-ipaufec-shard-00-00.hwdn5hv.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-ipaufec-shard-00-00.hwdn5hv.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-ipaufec-shard-00-01.hwdn5hv.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-ipaufec-shard-00-01.hwdn5hv.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-ipaufec-shard-00-02.hwdn5hv.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-ipaufec-shard-00-02.hwdn5hv.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>]>                          (venv)                           82108@LAPTOP MINGW64 ~/Desktop/sparta/pythonprac        $ c:/Users/82108/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/82108/Desktop/sparta/pythonprac/dbprac.py

Traceback (most recent call last):

 File "c:/Users/82108/Desktop/sparta/pythonprac/dbprac.py", line 9, in <module>

  db.users.insert_one(doc)

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one

  self._insert_one(

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one

  self.__database.client._retryable_write(acknowledged, _insert_command, session)

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write

  with self._tmp_session(session) as s:

 File "C:\Users\82108\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__

  return next(self.gen)

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session   

  s = self._ensure_session(session)

 File "C:\Users\82108\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session 

icaSetNoPrimary, servers: [<ServerDescription ('ac-hszvmhu-shard-00-00.l6f3uwp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-hszvmhu-shard-00-00.l6f3uwp.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-hszvmhu-shard-00-01.l6f3uwp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-hszvmhu-shard-00-01.l6f3uwp.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-hszvmhu-shard-00-02.l6f3uwp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-hszvmhu-shard-00-02.l6f3uwp.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>]>

(venv)

82108@LAPTOP MINGW64 ~/Desktop/sparta/pythonprac

$ pip install certifi

Requirement already satisfied: certifi in c:\users\82108\desktop\sparta\pythonprac\venv\lib\site-packages (2022.12.7)

WARNING: You are using pip version 20.2.1; however, version 23.0 is available.You should consider upgrading via the 'c:\users\82108\desktop\sparta\pythonprac\venv\scripts\python.exe -m pip install --upgrade pip' command.(venv)82108@LAPTOP MINGW64 ~/Desktop/sparta/pythonprac$