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

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

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


mongoDB 연결 중 자꾸 오류가 나옵니다ㅜ


처음엔 SSL:CERTIFICATE_VERIFY_FAILED ~~ 와 같은 오류가 나와

인터프리터에서 certifi 패키지를 설치 하고


import certifi

ca=certifi.where()

tlsCAFile=ca


코드 추가해서 다시 실행하니 다른 형식의 오류가 나오네요..ㅠ_ㅠ



스파르타 즉문즉답




작성한 코드 및 에러 메세지

from pymongo import MongoClient
import certifi

ca = certifi.where()

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

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

db.users.insert_one(doc)


/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/bin/python /Users/yoonjeonghoon/Desktop/sparta/pythonprac/dbprac.py 
Traceback (most recent call last):
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/dbprac.py", line 14, in <module>
    db.users.insert_one(doc)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/collection.py", line 621, in insert_one
    self._insert_one(
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/collection.py", line 562, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1476, in _retryable_write
    return self._retry_with_session(retryable, func, s, None)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1349, in _retry_with_session
    return self._retry_internal(retryable, func, session, bulk)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/_csot.py", line 105, in csot_wrapper
    return func(self, *args, **kwargs)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1381, in _retry_internal
    with self._get_socket(server, session) as sock_info:
  File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1217, in _get_socket
    with server.get_socket(handler=err_handler) as sock_info:
  File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/pool.py", line 1407, in get_socket
    sock_info = self._get_socket(handler=handler)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/pool.py", line 1520, in _get_socket
    sock_info = self.connect(handler=handler)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/pool.py", line 1378, in connect
    sock_info.authenticate()
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/pool.py", line 870, in authenticate
    auth.authenticate(creds, self)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/auth.py", line 549, in authenticate
    auth_func(credentials, sock_info)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/auth.py", line 475, in _authenticate_default
    return _authenticate_scram(credentials, sock_info, "SCRAM-SHA-1")
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/auth.py", line 241, in _authenticate_scram
    res = sock_info.command(source, cmd)
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/pool.py", line 767, in command
    return command(
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/network.py", line 166, in command
    helpers._check_command_response(
  File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/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(으)로 완료된 프로세스


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