
* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.
* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.
mongoDB 연결 중 자꾸 오류가 나옵니다ㅜ
처음엔 SSL:CERTIFICATE_VERIFY_FAILED ~~ 와 같은 오류가 나와
인터프리터에서 certifi 패키지를 설치 하고
import certifi
ca=certifi.where()
tlsCAFile=ca
코드 추가해서 다시 실행하니 다른 형식의 오류가 나오네요..ㅠ_ㅠ

작성한 코드 및 에러 메세지
from pymongo import MongoClient
import certifi
ca = certifi.where()
client = MongoClient('mongodb+srv://test:<sparta>@cluster0.qumtq43.mongodb.net/?retryWrites=true&w=majority', tlsCAFile=ca)
db = client.dbsparta
doc = {
'name' : 'bob',
'age' : 27
}
db.users.insert_one(doc)
/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/bin/python /Users/yoonjeonghoon/Desktop/sparta/pythonprac/dbprac.py
Traceback (most recent call last):
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/dbprac.py", line 14, in <module>
db.users.insert_one(doc)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/collection.py", line 621, in insert_one
self._insert_one(
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/collection.py", line 562, in _insert_one
self.__database.client._retryable_write(acknowledged, _insert_command, session)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1476, in _retryable_write
return self._retry_with_session(retryable, func, s, None)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1349, in _retry_with_session
return self._retry_internal(retryable, func, session, bulk)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/_csot.py", line 105, in csot_wrapper
return func(self, *args, **kwargs)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1381, in _retry_internal
with self._get_socket(server, session) as sock_info:
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/contextlib.py", line 113, in __enter__
return next(self.gen)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1217, in _get_socket
with server.get_socket(handler=err_handler) as sock_info:
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/contextlib.py", line 113, in __enter__
return next(self.gen)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/pool.py", line 1407, in get_socket
sock_info = self._get_socket(handler=handler)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/pool.py", line 1520, in _get_socket
sock_info = self.connect(handler=handler)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/pool.py", line 1378, in connect
sock_info.authenticate()
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/pool.py", line 870, in authenticate
auth.authenticate(creds, self)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/auth.py", line 549, in authenticate
auth_func(credentials, sock_info)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/auth.py", line 475, in _authenticate_default
return _authenticate_scram(credentials, sock_info, "SCRAM-SHA-1")
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/auth.py", line 241, in _authenticate_scram
res = sock_info.command(source, cmd)
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/pool.py", line 767, in command
return command(
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/network.py", line 166, in command
helpers._check_command_response(
File "/Users/yoonjeonghoon/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/helpers.py", line 181, in _check_command_response
raise OperationFailure(errmsg, code, response, max_wire_version)
pymongo.errors.OperationFailure: bad auth : Authentication failed., full error: {'ok': 0, 'errmsg': 'bad auth : Authentication failed.', 'code': 8000, 'codeName': 'AtlasError'}
종료 코드 1(으)로 완료된 프로세스
