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



저는 미국에있어서 싱가폴 AWS설정안하고 미국으로 했는데, 그래서 다른진 모르겠는데 아래 connection sting이 다릅니다. 이것때문에 DB 테스트 저장하는데 문제 발생하는걸까요?




*강의 connection string*

*제것 connection string*

mongodb+srv://test:<password>@cluster0.40l6j6u.mongodb.net/?retryWrites=true&w=majority


*강의 보고 바꾼것*

-password바꾸고 Cluster0를 ?앞에 넣음

mongodb+srv://test:sparta@cluster0.40l6j6u.mongodb.net/Cluster0?retryWrites=true&w=majority


*강의 기본코드*

from pymongo import MongoClient
client = MongoClient('여기에 URL 입력')
db = client.dbsparta

*url 복붙해서 넣은 테스트*

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

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

db.users.insert_one(doc)

*결과-에러*

C:\Users\bchoi\sparta\pythonprac2\venv\Scripts\python.exe C:/Users/bchoi/sparta/pythonprac2/dbprac.py 
Traceback (most recent call last):
  File "C:/Users/bchoi/sparta/pythonprac2/dbprac.py", line 10, in <module>
    db.users.insert_one(doc)
  File "C:\Users\bchoi\sparta\pythonprac2\venv\lib\site-packages\pymongo\collection.py", line 621, in insert_one
    self._insert_one(
  File "C:\Users\bchoi\sparta\pythonprac2\venv\lib\site-packages\pymongo\collection.py", line 562, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "C:\Users\bchoi\sparta\pythonprac2\venv\lib\site-packages\pymongo\mongo_client.py", line 1447, in _retryable_write
    with self._tmp_session(session) as s:
  File "C:\Users\bchoi\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Users\bchoi\sparta\pythonprac2\venv\lib\site-packages\pymongo\mongo_client.py", line 1729, in _tmp_session
    s = self._ensure_session(session)
  File "C:\Users\bchoi\sparta\pythonprac2\venv\lib\site-packages\pymongo\mongo_client.py", line 1712, in _ensure_session
    return self.__start_session(True, causal_consistency=False)
  File "C:\Users\bchoi\sparta\pythonprac2\venv\lib\site-packages\pymongo\mongo_client.py", line 1657, in __start_session
    self._topology._check_implicit_session_support()
  File "C:\Users\bchoi\sparta\pythonprac2\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support
    self._check_session_support()
  File "C:\Users\bchoi\sparta\pythonprac2\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support
    self._select_servers_loop(
  File "C:\Users\bchoi\sparta\pythonprac2\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-vinxpza-shard-00-02.40l6j6u.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-vinxpza-shard-00-00.40l6j6u.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-vinxpza-shard-00-01.40l6j6u.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124), Timeout: 30s, Topology Description: <TopologyDescription id: 633ca22bcf2901254332b3d9, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-vinxpza-shard-00-00.40l6j6u.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-vinxpza-shard-00-00.40l6j6u.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-vinxpza-shard-00-01.40l6j6u.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-vinxpza-shard-00-01.40l6j6u.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-vinxpza-shard-00-02.40l6j6u.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-vinxpza-shard-00-02.40l6j6u.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>]>


Process finished with exit code 1




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