
mongodB 연결하는 부분인데, 어떻게 해도 오류가 나네요..
파이썬에서 insert_one() 함수 실행 안되고 오류가나요. 데이터베이스 지우고 다시생성도 해봤는데.. 왜 안되는지 잘 모르겠네요.
몽고db atlas 데이터베이스 생성(Cluster0) -> 계정 test:sparta 생성, 네트워크 규칙추가(ip 0.0.0.0 )-> 파이썬에서 pymongo 클라이언트 객체
MongoClient("mongodb+srv://test:sparta@cluster0.6vmo67v.mongodb.net/?retryWrites=true&w=majority")
오류가나는 부분은 .insert_one 함수 부분이에요.
-문제 될만한사항

작성한 코드 및 에러 메세지
작성코드 입니다.
from pymongo import MongoClient
client = MongoClient("mongodb+srv://test:sparta@cluster0.6vmo67v.mongodb.net/?retryWrites=true&w=majority")
db = client.dbsparta
doc = {
'name':'bobby',
'age':21
}
db.users.insert_one(doc)
오류내용입니다.
/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/bin/python /Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/dbprac.py
Traceback (most recent call last):
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/dbprac.py", line 11, in <module>
db.users.insert_one(doc)
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/collection.py", line 705, in insert_one
self._insert(document,
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/collection.py", line 620, in _insert
return self._insert_one(
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/collection.py", line 609, in _insert_one
self.__database.client._retryable_write(
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1551, in _retryable_write
with self._tmp_session(session) as s:
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/contextlib.py", line 113, in __enter__
return next(self.gen)
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1948, in _tmp_session
s = self._ensure_session(session)
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1935, in _ensure_session
return self.__start_session(True, causal_consistency=False)
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1883, in __start_session
server_session = self._get_server_session()
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1921, in _get_server_session
return self._topology.get_server_session()
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/topology.py", line 520, in get_server_session
session_timeout = self._check_session_support()
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/topology.py", line 504, in _check_session_support
self._select_servers_loop(
File "/Users/ihyeonsu/workspace/spartan/pythonProject/pythonprac2/venv/lib/python3.8/site-packages/pymongo/topology.py", line 218, in _select_servers_loop
raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: SSL handshake failed: ac-dmfyqal-shard-00-01.6vmo67v.mongodb.net:27017: _ssl.c:1091: The handshake operation timed out,ac-dmfyqal-shard-00-02.6vmo67v.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108),ac-dmfyqal-shard-00-00.6vmo67v.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108), Timeout: 30s, Topology Description: <TopologyDescription id: 63514ddd50f37f7930a2ea03, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-dmfyqal-shard-00-00.6vmo67v.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-dmfyqal-shard-00-00.6vmo67v.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>, <ServerDescription ('ac-dmfyqal-shard-00-01.6vmo67v.mongodb.net', 27017) server_type: Unknown, rtt: None, error=NetworkTimeout('SSL handshake failed: ac-dmfyqal-shard-00-01.6vmo67v.mongodb.net:27017: _ssl.c:1091: The handshake operation timed out')>, <ServerDescription ('ac-dmfyqal-shard-00-02.6vmo67v.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-dmfyqal-shard-00-02.6vmo67v.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>]>
종료 코드 1(으)로 완료된 프로세스
오류 발생 시, 작성한 코드 전체와 에러 메시지를 첨부해 주세요.
Tip 1) </> 아이콘을 눌러 코드박스를 만들어 보세요.
Tip 2) Ctrl+A(맥의 경우 Command+A) 단축키로 코드를 한 번에 선택할 수 있어요!
