
<전체 코드>
from pymongo import MongoClient
client = MongoClient('mongodb+srv://test:sparta@cluster0.oi21xcu.mongodb.net/Cluster0?retryWrites=true&w=majority')
db = client.dbsparta
doc = {
'name':'bob',
'age':27
}
db.users.insert_one(doc)
<에러 메시지>
C:\Users\User\Desktop\sparta\pythonprac\venv\Scripts\python.exe C:/Users/User/Desktop/sparta/pythonprac/dbprac.py
Traceback (most recent call last):
File "C:/Users/User/Desktop/sparta/pythonprac/dbprac.py", line 10, in <module>
db.users.insert_one(doc)
File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 621, in insert_one
self._insert_one(
File "C:\Users\User\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\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1447, 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\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1729, in _tmp_session
s = self._ensure_session(session)
File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1712, in _ensure_session
return self.__start_session(True, causal_consistency=False)
File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1657, in __start_session
self._topology._check_implicit_session_support()
File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support
self._check_session_support()
File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support
self._select_servers_loop(
File "C:\Users\User\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop
raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-9yfcqck-shard-00-02.oi21xcu.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-9yfcqck-shard-00-00.oi21xcu.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-9yfcqck-shard-00-01.oi21xcu.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124), Timeout: 30s, Topology Description: <TopologyDescription id: 62eb89554ffe0190bd098072, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-9yfcqck-shard-00-00.oi21xcu.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-9yfcqck-shard-00-00.oi21xcu.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-9yfcqck-shard-00-01.oi21xcu.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-9yfcqck-shard-00-01.oi21xcu.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-9yfcqck-shard-00-02.oi21xcu.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-9yfcqck-shard-00-02.oi21xcu.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>]>
종료 코드 1(으)로 완료된 프로세스
ㄴ mongoDB에서 데이터베이스 생성한 화면도 같이 첨부합니다!
데이터베이스랑 프로젝트 아예 삭제하고 처음부터 다시 만들어서 연결 시도해봤는데 그래도 연결이 되지 않고 있습니다.
connect 할 때 사용하는 url (mongodb+srv://test:<password>@cluster0.oi21xcu.mongodb.net/?retryWrites=true&w=majority)의 형태가 수업에 나오는 선생님의 url과 조금 다른 듯한데 이것이 문제인건지 아니면 다른 문제가 있는 건지 잘 모르겠습니다..!!
