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

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

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



안녕하세요, mongoDB에 연결이 안 되고 있습니다

처음에 install 오타가 나서 다시 수정하고 다운로드했고,

비슷한 증상을 겪고 있으신 다른 분들의 글도 찾아보며 test의 <>도 수정했고요,

vscode에서 추가적으로 설정이 필요하다고 하여 다운도 받았는데

계속 연결이 안 됩니다.. 어떤 부분에 문제인걸까요ㅠㅠ?



스파르타 즉문즉답




작성한 코드 및 에러 메세지

오류 발생 시, 작성한 코드 전체와 에러 메시지를 첨부해 주세요.

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


doc = {
    'name':'영수',
    'age' :24
}
db.users.insert_one(doc)


summer@DESKTOP-8V0Q2KV MINGW64 ~/Dropbox/PC/Desktop/sparta/pythonprac
$ pip install dnspython
Collecting dnspython
  Downloading dnspython-2.3.0-py3-none-any.whl (283 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 283.7/283.7 kB 8.8 MB/s eta 0:00:00
Installing collected packages: dnspython
Successfully installed dnspython-2.3.0


[notice] A new release of pip available: 22.3.1 -> 23.0.1
[notice] To update, run: python.exe -m pip install --upgrade pip
(venv) 
summer@DESKTOP-8V0Q2KV MINGW64 ~/Dropbox/PC/Desktop/sparta/pythonprac
$ pip istall pymongo
ERROR: unknown command "istall" - maybe you meant "install"
(venv) 
summer@DESKTOP-8V0Q2KV MINGW64 ~/Dropbox/PC/Desktop/sparta/pythonprac
$ pip install pymongo
Collecting pymongo
  Downloading pymongo-4.3.3-cp310-cp310-win_amd64.whl (382 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 382.5/382.5 kB 6.0 MB/s eta 0:00:00
Requirement already satisfied: dnspython<3.0.0,>=1.16.0 in c:\users\김성민\dropbox\pc\desktop\sparta\pythonprac\venv\lib\site-packages (from pymongo) (2.3.0)
Installing collected packages: pymongo
Successfully installed pymongo-4.3.3


[notice] A new release of pip available: 22.3.1 -> 23.0.1
[notice] To update, run: python.exe -m pip install --upgrade pip
(venv) 
summer@DESKTOP-8V0Q2KV MINGW64 ~/Dropbox/PC/Desktop/sparta/pythonprac
$ c:/Users/김성민/Dropbox/PC/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/김성
민/Dropbox/PC/Desktop/sparta/pythonprac/dbprac.py
Traceback (most recent call last):
  File "c:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\dbprac.py", line 9, in <module>    db.users.insert_one(doc)
  File "C:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one
    self._insert_one(
  File "C:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "C:\Users\김성민\Dropbox\PC\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:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2800.0_x64__qbz5n2kfra8p0\lib\contextlib.py", line 135, in __enter__
    return next(self.gen)
  File "C:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session
    s = self._ensure_session(session)
  File "C:\Users\김성민\Dropbox\PC\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\김성민\Dropbox\PC\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\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support
    self._check_session_support()
  File "C:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support
    self._select_servers_loop(
  File "C:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-b0ar9kf-shard-00-00.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997),ac-b0ar9kf-shard-00-01.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997),ac-b0ar9kf-shard-00-02.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate 
has expired (_ssl.c:997), Timeout: 30s, Topology Description: <TopologyDescription id: 63f1e228d12dd9efb60047d9, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-b0ar9kf-shard-00-00.kgma0gj.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-b0ar9kf-shard-00-00.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997)')>, <ServerDescription ('ac-b0ar9kf-shard-00-01.kgma0gj.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-b0ar9kf-shard-00-01.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997)')>, <ServerDescription ('ac-b0ar9kf-shard-00-02.kgma0gj.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-b0ar9kf-shard-00-02.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997)')>]>
(venv) 
summer@DESKTOP-8V0Q2KV MINGW64 ~/Dropbox/PC/Desktop/sparta/pythonprac
$ c:/Users/김성민/Dropbox/PC/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/김성
민/Dropbox/PC/Desktop/sparta/pythonprac/dbprac.py
Traceback (most recent call last):
  File "c:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\dbprac.py", line 9, in <module>    db.users.insert_one(doc)
  File "C:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one
    self._insert_one(
  File "C:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "C:\Users\김성민\Dropbox\PC\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:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2800.0_x64__qbz5n2kfra8p0\lib\contextlib.py", line 135, in __enter__
    return next(self.gen)
  File "C:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session
    s = self._ensure_session(session)
  File "C:\Users\김성민\Dropbox\PC\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\김성민\Dropbox\PC\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\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support
    self._check_session_support()
  File "C:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support
    self._select_servers_loop(
  File "C:\Users\김성민\Dropbox\PC\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-b0ar9kf-shard-00-02.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997),ac-b0ar9kf-shard-00-00.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997),ac-b0ar9kf-shard-00-01.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate 
has expired (_ssl.c:997), Timeout: 30s, Topology Description: <TopologyDescription id: 63f1e29485633402795849c1, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-b0ar9kf-shard-00-00.kgma0gj.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-b0ar9kf-shard-00-00.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997)')>, <ServerDescription ('ac-b0ar9kf-shard-00-01.kgma0gj.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-b0ar9kf-shard-00-01.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997)')>, <ServerDescription ('ac-b0ar9kf-shard-00-02.kgma0gj.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-b0ar9kf-shard-00-02.kgma0gj.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997)')>]>
(venv) 
summer@DESKTOP-8V0Q2KV MINGW64 ~/Dropbox/PC/Desktop/sparta/pythonprac
$ pip install certifi
Requirement already satisfied: certifi in c:\users\김성민\dropbox\pc\desktop\sparta\pythonprac\venv\lib\site-packages (2022.12.7)


[notice] A new release of pip available: 22.3.1 -> 23.0.1
[notice] To update, run: python.exe -m pip install --upgrade pip
(venv)
summer@DESKTOP-8V0Q2KV MINGW64 ~/Dropbox/PC/Desktop/sparta/pythonprac
$ c:/Users/김성민/Dropbox/PC/Desktop/sparta/pythonprac/venv/Scripts/python.exe -m pip install -U autopep8
Collecting autopep8
  Downloading autopep8-2.0.1-py2.py3-none-any.whl (45 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 45.0/45.0 kB 2.3 MB/s eta 0:00:00
Collecting pycodestyle>=2.10.0
  Downloading pycodestyle-2.10.0-py2.py3-none-any.whl (41 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 41.3/41.3 kB ? eta 0:00:00
Collecting tomli
  Downloading tomli-2.0.1-py3-none-any.whl (12 kB)
Installing collected packages: tomli, pycodestyle, autopep8
Successfully installed autopep8-2.0.1 pycodestyle-2.10.0 tomli-2.0.1


[notice] A new release of pip available: 22.3.1 -> 23.0.1
취소
 공유
취소
댓글 0
댓글 알림
나의얼굴