커뮤니티
포인트
쿠폰
내 강의실
국비 신청 내역
증명서
계정
로그아웃
학습 질문
개발 일지
나의 활동
답변 완료
3-11 mongo DB 연결하기 오류
undefined주차
북마크
이*훈
댓글
3
추천
0
조회수
18
조회수
18
답변 완료

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

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


mongoDB 연결 오류

다른 게시물에서 동일한 오류가 발생하는 것 같아 'certifi' pakage 설치 및 'Access IP Allow' 설정 등을 해보았는데

오류가 해결 되지 않아 문의 드립니다.


서버를 잘못 만들었는지 하여, 새로운 DB 및 클러스터 설정함

ID : test1

PW : sparta



스파르타 즉문즉답


스파르타 즉문즉답스파르타 즉문즉답스파르타 즉문즉답





작성한 코드 및 에러 메세지

from pymongo import MongoClient
import certifi

ca = certifi.where()

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

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

db.users.insert_one(doc)

-----아래는 error 내용 ------------------------

C:\Users\daniel\Desktop\spartan\pythonprac\venv\Scripts\python.exe C:\Users\daniel\Desktop\spartan\pythonprac\dbprac.py 
Traceback (most recent call last):
  File "C:\Users\daniel\Desktop\spartan\pythonprac\dbprac.py", line 14, in <module>
    db.users.insert_one(doc)
  File "C:\Users\daniel\Desktop\spartan\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 621, in insert_one
    self._insert_one(
  File "C:\Users\daniel\Desktop\spartan\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\daniel\Desktop\spartan\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:\Users\daniel\Desktop\spartan\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:\Users\daniel\Desktop\spartan\pythonprac\venv\lib\site-packages\pymongo\_csot.py", line 105, in csot_wrapper
    return func(self, *args, **kwargs)
  File "C:\Users\daniel\Desktop\spartan\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\daniel\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Users\daniel\Desktop\spartan\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\daniel\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Users\daniel\Desktop\spartan\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1407, in get_socket
    sock_info = self._get_socket(handler=handler)
  File "C:\Users\daniel\Desktop\spartan\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1520, in _get_socket
    sock_info = self.connect(handler=handler)
  File "C:\Users\daniel\Desktop\spartan\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 1378, in connect
    sock_info.authenticate()
  File "C:\Users\daniel\Desktop\spartan\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 870, in authenticate
    auth.authenticate(creds, self)
  File "C:\Users\daniel\Desktop\spartan\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 549, in authenticate
    auth_func(credentials, sock_info)
  File "C:\Users\daniel\Desktop\spartan\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\daniel\Desktop\spartan\pythonprac\venv\lib\site-packages\pymongo\auth.py", line 241, in _authenticate_scram
    res = sock_info.command(source, cmd)
  File "C:\Users\daniel\Desktop\spartan\pythonprac\venv\lib\site-packages\pymongo\pool.py", line 767, in command
    return command(
  File "C:\Users\daniel\Desktop\spartan\pythonprac\venv\lib\site-packages\pymongo\network.py", line 166, in command
    helpers._check_command_response(
  File "C:\Users\daniel\Desktop\spartan\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'}


Process finished with exit code 1




취소
 공유
취소
댓글 0
댓글 알림
나의얼굴