안녕하세요

mongoDB 연결하기 에서 진행이 되지않아서요ㅠㅠ

에러상황을 보니 이전에 어떤분이 문의하신글과 유사하긴한데,

(Q. DB Atlas 사용시, pymongo.errors.ServerSelectionTimeoutError: ~ [SSL: CERTIFICATE_VERIFY_FAILED]~ 를 포함한 에러 메시지가 뜨면서 실행이 되지 않습니다. 

https://teamsparta.notion.site/FAQ-9a10bc3536ea404d9d76bdb5c3f0d14f)

저는 certifi 설치까지 했는데도 안되서요ㅠㅠ

<from pymongo import MongoClient
import certifi

ca = certifi.where()

client = MongoClient('mongodb+srv://test:<sparta>@cluster0.gz3lawk.mongodb.net/?retryWrites=true&w=majority', tlsCAFile=ca)
db = client.test

doc = {
    'name':'bob',
    'age':27
}
db.users.insert_one(doc)>

C:\Users\User\Desktop\sparta\pythonprac\venv\Scripts\python.exe C:/Users/User/Desktop/sparta/pythonprac/dbprac.py 

Traceback (most recent call last):

 File "C:/Users/User/Desktop/sparta/pythonprac/dbprac.py", line 14, in <module>

  db.users.insert_one(doc)

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

  self._insert_one(

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

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

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

  return self._retry_with_session(retryable, func, s, None)

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1321, in _retry_with_session

  return self._retry_internal(retryable, func, session, bulk)

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\_csot.py", line 105, in csot_wrapper

  return func(self, *args, **kwargs)

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1353, in _retry_internal

  with self._get_socket(server, session) as sock_info:

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

  return next(self.gen)

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1189, in _get_socket

  with server.get_socket(handler=err_handler) as sock_info:

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

  return next(self.gen)

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1406, in get_socket

  sock_info = self._get_socket(handler=handler)

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1519, in _get_socket

  sock_info = self.connect(handler=handler)

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1377, in connect

  sock_info.authenticate()

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 869, in authenticate

  auth.authenticate(creds, self)

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 549, in authenticate

  auth_func(credentials, sock_info)

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 475, in _authenticate_default

  return _authenticate_scram(credentials, sock_info, "SCRAM-SHA-1")

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 241, in _authenticate_scram

  res = sock_info.command(source, cmd)

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 766, in command

  return command(

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\network.py", line 166, in command

  helpers._check_command_response(

 File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\helpers.py", line 181, in _check_command_response

  raise OperationFailure(errmsg, code, response, max_wire_version)

pymongo.errors.OperationFailure: bad auth : Authentication failed., full error: {'ok': 0, 'errmsg': 'bad auth : Authentication failed.', 'code': 8000, 'codeName': 'AtlasError'}

종료 코드 1(으)로 완료된 프로세스

로 나옵니다.

확인 후 답변주세요ㅠㅠ답답해서 속터질것같아여,,^^..감사합니다,,