
* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.
* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.
안녕하세요, 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
