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

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

몽고DB가 연결이 안돼서 질문 게시판을 보면서 여러 방법을 따라해봤는데도 아직 해결이 안됩니다.

우선 노션에 있는 코드로 제일 먼저 해봤습니다.

Traceback (most recent call last):
  File "C:\Workspace\pythonprac\dbprac.py", line 10, in <module>
    db.users.insert_one(doc)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one
    self._insert_one(
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1476, in _retryable_write
    return self._retry_with_session(retryable, func, s, None)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1349, in _retry_with_session
    return self._retry_internal(retryable, func, session, bulk)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\_csot.py", line 105, in csot_wrapper
    return func(self, *args, **kwargs)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1381, in _retry_internal
    with self._get_socket(server, session) as sock_info:
  File "C:\Users\eunps\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1217, in _get_socket
    with server.get_socket(handler=err_handler) as sock_info:
  File "C:\Users\eunps\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1407, in get_socket
    sock_info = self._get_socket(handler=handler)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1520, in _get_socket
    sock_info = self.connect(handler=handler)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1378, in connect
    sock_info.authenticate()
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 870, in authenticate
    auth.authenticate(creds, self)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 549, in authenticate
    auth_func(credentials, sock_info)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 475, in _authenticate_default
    return _authenticate_scram(credentials, sock_info, "SCRAM-SHA-1")
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 241, in _authenticate_scram
    res = sock_info.command(source, cmd)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 767, in command
    return command(
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\network.py", line 166, in command
    helpers._check_command_response(
  File "C:\Workspace\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'}

위의 오류가 발생해서 certifi를 설치해서 진행해봤습니다.

Traceback (most recent call last):
  File "C:\Workspace\pythonprac\dbprac.py", line 12, in <module>
    db.users.insert_one(doc)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one
    self._insert_one(
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1476, in _retryable_write
    return self._retry_with_session(retryable, func, s, None)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1349, in _retry_with_session
    return self._retry_internal(retryable, func, session, bulk)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\_csot.py", line 105, in csot_wrapper
    return func(self, *args, **kwargs)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1381, in _retry_internal
    with self._get_socket(server, session) as sock_info:
  File "C:\Users\eunps\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1217, in _get_socket
    with server.get_socket(handler=err_handler) as sock_info:
  File "C:\Users\eunps\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1407, in get_socket
    sock_info = self._get_socket(handler=handler)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1520, in _get_socket
    sock_info = self.connect(handler=handler)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1378, in connect
    sock_info.authenticate()
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 870, in authenticate
    auth.authenticate(creds, self)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 549, in authenticate
    auth_func(credentials, sock_info)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 475, in _authenticate_default
    return _authenticate_scram(credentials, sock_info, "SCRAM-SHA-1")
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 241, in _authenticate_scram
    res = sock_info.command(source, cmd)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 767, in command
    return command(
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\network.py", line 166, in command
    helpers._check_command_response(
  File "C:\Workspace\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'

같은 오류가 발생해서 사용자 권한...? 도 수정해봤습니다

이렇게 설정 변경하여 위의 두 과정을 진행해봤는데 마찬가지의 오류가 발생했습니다.

네트워크도 강의에서 말한 것처럼 현재 네트워크가 아니라 모든 IP 주소에서 접근이 가능하게 설정된 상황입니다.

FAQ에 있는 설명글을 참고해서 실행해봐도 아래의 오류가 발생합니다.

Traceback (most recent call last):
  File "C:\Workspace\pythonprac\dbprac.py", line 12, in <module>
    db.users.insert_one(doc)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one
    self._insert_one(
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1476, in _retryable_write
    return self._retry_with_session(retryable, func, s, None)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1349, in _retry_with_session
    return self._retry_internal(retryable, func, session, bulk)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\_csot.py", line 105, in csot_wrapper
    return func(self, *args, **kwargs)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1381, in _retry_internal
    with self._get_socket(server, session) as sock_info:
  File "C:\Users\eunps\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1217, in _get_socket
    with server.get_socket(handler=err_handler) as sock_info:
  File "C:\Users\eunps\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1407, in get_socket
    sock_info = self._get_socket(handler=handler)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1520, in _get_socket
    sock_info = self.connect(handler=handler)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1378, in connect
    sock_info.authenticate()
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 870, in authenticate
    auth.authenticate(creds, self)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 549, in authenticate
    auth_func(credentials, sock_info)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 475, in _authenticate_default
    return _authenticate_scram(credentials, sock_info, "SCRAM-SHA-1")
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 241, in _authenticate_scram
    res = sock_info.command(source, cmd)
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 767, in command
    return command(
  File "C:\Workspace\pythonprac\venv\lib\site-packages\pymongo\network.py", line 166, in command
    helpers._check_command_response(
  File "C:\Workspace\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'}

from pymongo import MongoClient
import certifi
ca = certifi.where()
client = MongoClient('mongodb://test:<sparta>@ac-qmpzeex-shard-00-00.jmqgyz3.mongodb.net:27017,ac-qmpzeex-shard-00-01.jmqgyz3.mongodb.net:27017,ac-qmpzeex-shard-00-02.jmqgyz3.mongodb.net:27017/Cluster0?ssl=true&replicaSet=atlas-12tg1b-shard-0&authSource=admin&retryWrites=true&w=majority', tlsCAFile=ca)
db = client.dbsparta

doc = {
    'name':'bob',
    'age':27

위의 코드는 혹시 url 부분에서 잘못 입력한 부분이 있을까봐 첨부했습니다.

여기까지 시도해봤는데.. 이유가 뭔지 모르겠습니다. 계정정보는 test:sparta로 제대로 설정해놨습니다.