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

3-12강중 파이썬과 몽고디비와 연결하는 과정에서 문제 발생

편집기 터미널에서 파이썬 실행 후 몽고디비의 브라우저콜렉션스 클릭하면 user 가 insert 되지 않음


스파르타 즉문즉답


작성 코드

from pymongo import MongoClient

client = MongoClient('mongodb+srv://sparta:test@cluster0.89ioulf.mongodb.net/?retryWrites=true&w=majority')

db = client.dbsparta


doc = {

    'name':'영수',

    'age':24

}

db.users.insert_one(doc)


Error 내용

user@Hera MINGW64 ~/Desktop/Sparta/phythonprac

$ source c:/Users/user/Desktop/Sparta/phythonprac/venv/Scripts/activate

(venv) 

user@Hera MINGW64 ~/Desktop/Sparta/phythonprac

$ c:/Users/user/Desktop/Sparta/phythonprac/venv/Scripts/python.exe c:/Users/user/Desktop/Sparta/phythonprac/dbprac.py

Traceback (most recent call last):

 File "c:/Users/user/Desktop/Sparta/phythonprac/dbprac.py", line 9, in <module>

  db.users.insert_one(doc)

 File "C:\Users\user\Desktop\Sparta\phythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one

  self._insert_one(

 File "C:\Users\user\Desktop\Sparta\phythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one

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

 File "C:\Users\user\Desktop\Sparta\phythonprac\venv\lib\site-packages\pymongo\mongo_client.py", 

line 1475, in _retryable_write

  with self._tmp_session(session) as s:

 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\phythonprac\venv\lib\site-packages\pymongo\mongo_client.py", 

line 1757, in _tmp_session

  s = self._ensure_session(session)

 File "C:\Users\user\Desktop\Sparta\phythonprac\venv\lib\site-packages\pymongo\mongo_client.py", 

line 1740, in _ensure_session

  return self.__start_session(True, causal_consistency=False)

 File "C:\Users\user\Desktop\Sparta\phythonprac\venv\lib\site-packages\pymongo\mongo_client.py", 

line 1685, in __start_session

  self._topology._check_implicit_session_support()

 File "C:\Users\user\Desktop\Sparta\phythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support

  self._check_session_support()

 File "C:\Users\user\Desktop\Sparta\phythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support

  self._select_servers_loop(

 File "C:\Users\user\Desktop\Sparta\phythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop

  raise ServerSelectionTimeoutError(

pymongo.errors.ServerSelectionTimeoutError: ac-vz0tken-shard-00-01.89ioulf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-vz0tken-shard-00-02.89ioulf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify 

failed: certificate has expired (_ssl.c:1124),ac-vz0tken-shard-00-00.89ioulf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124), Timeout: 30s, Topology Description: <TopologyDescription id: 644a71a0272b4d9b2d2bedc7, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-vz0tken-shard-00-00.89ioulf.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-vz0tken-shard-00-00.89ioulf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-vz0tken-shard-00-01.89ioulf.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-vz0tken-shard-00-01.89ioulf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-vz0tken-shard-00-02.89ioulf.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-vz0tken-shard-00-02.89ioulf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>]>

(venv)

user@Hera MINGW64 ~/Desktop/Sparta/phythonprac

$ pip list

Package      Version

------------------ ---------

beautifulsoup4   4.12.2

bs4        0.0.1

certifi      2022.12.7

charset-normalizer 3.1.0

dnspython     2.3.0

idna        3.4

pip        23.1.2

pymongo      4.3.3

requests      2.29.0

setuptools     49.2.1

soupsieve     2.4.1

urllib3      1.26.15

(venv)

user@Hera MINGW64 ~/Desktop/Sparta/phythonprac

$







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