* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.

* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.

파이썬에서 DB로 연결하면 user가 새로 생긴다고 하는데 저는 생기지가 않고 터미널에 아래 에러 메세지가 뜹니다.

pip install certifi 를 실행하고
tlsCAFile=ca를 url의 뒤에 반드시 추가했는데도

ㅎㅐ결이 되질 않네요

작성한 코드 및 에러 메세지

오류 발생 시, 작성한 코드 전체와 에러 메시지를 첨부해 주세요.

(venv) Jeong-Dae@mannix pythonprac % "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonpra

c/venv/bin/python" "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/dbprac.py"

Traceback (most recent call last):

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/dbprac.py", line 9, in <module>

  db.users.insert_one(doc)

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/collection.py", line 628, in insert_one

  self._insert_one(

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/collection.py", line 569, in _insert_one

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

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1475, in _retryable_write

  with self._tmp_session(session) as s:

 File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/contextlib.py", line 113, in __enter__

  return next(self.gen)

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1757, in _tmp_session

  s = self._ensure_session(session)

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1740, in _ensure_session

  return self.__start_session(True, causal_consistency=False)

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1685, in __start_session

  self._topology._check_implicit_session_support()

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/topology.py", line 538, in _check_implicit_session_support

  self._check_session_support()

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/topology.py", line 554, in _check_session_support

  self._select_servers_loop(

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/topology.py", line 238, in _select_servers_loop

  raise ServerSelectionTimeoutError(

pymongo.errors.ServerSelectionTimeoutError: ac-bova84e-shard-00-02.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108),ac-bova84e-shard-00-01.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108),ac-bova84e-shard-00-00.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108), Timeout: 30s, Topology Description: <TopologyDescription id: 647c036df2b5d19b1d29528d, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-bova84e-shard-00-00.81cdsms.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-bova84e-shard-00-00.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>, <ServerDescription ('ac-bova84e-shard-00-01.81cdsms.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-bova84e-shard-00-01.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>, <ServerDescription ('ac-bova84e-shard-00-02.81cdsms.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-bova84e-shard-00-02.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>]>

(venv) Jeong-Dae@mannix pythonprac % pip install certifi

Requirement already satisfied: certifi in ./venv/lib/python3.8/site-packages (2023.5.7)

WARNING: You are using pip version 19.2.3, however version 23.1.2 is available.

You should consider upgrading via the 'pip install --upgrade pip' command.

(venv) Jeong-Dae@mannix pythonprac % "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonpra

c/venv/bin/python" "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/dbprac.py"

Traceback (most recent call last):

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/dbprac.py", line 9, in <module>

  db.users.insert_one(doc)

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/collection.py", line 628, in insert_one

  self._insert_one(

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/collection.py", line 569, in _insert_one

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

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1475, in _retryable_write

  with self._tmp_session(session) as s:

 File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/contextlib.py", line 113, in __enter__

  return next(self.gen)

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1757, in _tmp_session

  s = self._ensure_session(session)

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1740, in _ensure_session

  return self.__start_session(True, causal_consistency=False)

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1685, in __start_session

  self._topology._check_implicit_session_support()

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/topology.py", line 538, in _check_implicit_session_support

  self._check_session_support()

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/topology.py", line 554, in _check_session_support

  self._select_servers_loop(

 File "/Users/Jeong-Dae/Documents/Coding Club/Sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/topology.py", line 238, in _select_servers_loop

  raise ServerSelectionTimeoutError(

pymongo.errors.ServerSelectionTimeoutError: ac-bova84e-shard-00-02.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108),ac-bova84e-shard-00-01.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108),ac-bova84e-shard-00-00.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108), Timeout: 30s, Topology Description: <TopologyDescription id: 647c03edeec14bdddb5ee9d1, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-bova84e-shard-00-00.81cdsms.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-bova84e-shard-00-00.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>, <ServerDescription ('ac-bova84e-shard-00-01.81cdsms.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-bova84e-shard-00-01.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>, <ServerDescription ('ac-bova84e-shard-00-02.81cdsms.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-bova84e-shard-00-02.81cdsms.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>]>