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

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

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


MongdoDB database 준비부분에서 연결 테스트까지 어렵지 않게 모두 따라했는데 연결 테스트에서 계속 에러메시지가 뜹니다. 반복해서 과정을 살펴봐도 무엇이 문제인지 어디서부터 다시 시도해보아야 하는지 도저히 모르겠습니다. 도와주세요.ㅠ




여러번 확인해본 과정들...

  1. MongoDB 회원가입 후 셋업완료
  2. Connection method 완료 (user, password 확인)
  3. Pycharm 에서 pymongo, dnspython 패키지 설치 완료
  4. 코드 스니펫 붙이고 URL 부분 수정- password 입력 (강의에는 myFirstDatabase 지우고 Cluster0 입력하라는데 현재 MongoDB 에서는 myFirstDatabase 가 안붙어서 나옴 그래서 Cluster0 입력 혹은 삭제 둘 다 실행 해도 에러메시지)





작성한 코드 및 에러 메세지

from pymongo import MongoClient
client = MongoClient('mongodb+srv://test:sparta@cluster0.w8bwceb.mongodb.net/Cluster0?retryWrites=true&w=majority')
db = client.dbsparta

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

db.users.insert_one(doc)

에러메시지

C:\Users\201EDG06\Desktop\sparta\pythonprac\venv\Scripts\python.exe C:\Users\201EDG06\Desktop\sparta\pythonprac\dbprac.py 
Traceback (most recent call last):
  File "C:\Users\201EDG06\Desktop\sparta\pythonprac\dbprac.py", line 10, in <module>
    db.users.insert_one(doc)
  File "C:\Users\201EDG06\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 621, in insert_one
    self._insert_one(
  File "C:\Users\201EDG06\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\201EDG06\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write
    with self._tmp_session(session) as s:
  File "C:\Users\201EDG06\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Users\201EDG06\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session
    s = self._ensure_session(session)
  File "C:\Users\201EDG06\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session
    return self.__start_session(True, causal_consistency=False)
  File "C:\Users\201EDG06\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session
    self._topology._check_implicit_session_support()
  File "C:\Users\201EDG06\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support
    self._check_session_support()
  File "C:\Users\201EDG06\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support
    self._select_servers_loop(
  File "C:\Users\201EDG06\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-vxd2ze8-shard-00-02.w8bwceb.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-vxd2ze8-shard-00-00.w8bwceb.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-vxd2ze8-shard-00-01.w8bwceb.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124), Timeout: 30s, Topology Description: <TopologyDescription id: 63723618d1ff73dc7b5e658d, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-vxd2ze8-shard-00-00.w8bwceb.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-vxd2ze8-shard-00-00.w8bwceb.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-vxd2ze8-shard-00-01.w8bwceb.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-vxd2ze8-shard-00-01.w8bwceb.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-vxd2ze8-shard-00-02.w8bwceb.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-vxd2ze8-shard-00-02.w8bwceb.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>]>


Process finished with exit code 1





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