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

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

강의대로 따라했는데 에러메시지 뜨길래

강의자료에 나온대로 certifi 추가설치하고

형광펜 되어있는 코드도 추가입력해주었는데

에러가 나옵니다

from pymongo import MongoClient
import certifi

ca = certifi.where()

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

doc = {
    'name':'bob',
    'age':27
}

db.users.insert_one(doc)

작성한 코드 및 에러 메세지

C:\Users\snl25\Desktop\sparta\pythonprac\venv\Scripts\python.exe C:\Users\snl25\Desktop\sparta\pythonprac\dbprac.py 

Traceback (most recent call last):

 File "C:\Users\snl25\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\srv_resolver.py", line 89, in _resolve_uri

  results = _resolve(

 File "C:\Users\snl25\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\srv_resolver.py", line 43, in _resolve

  return resolver.resolve(*args, **kwargs)

 File "C:\Users\snl25\Desktop\sparta\pythonprac\venv\lib\site-packages\dns\resolver.py", line 1193, in resolve

  return get_default_resolver().resolve(qname, rdtype, rdclass, tcp, source,

 File "C:\Users\snl25\Desktop\sparta\pythonprac\venv\lib\site-packages\dns\resolver.py", line 1090, in resolve

  (answer, done) = resolution.query_result(response, None)

 File "C:\Users\snl25\Desktop\sparta\pythonprac\venv\lib\site-packages\dns\resolver.py", line 696, in query_result

  raise NoAnswer(response=answer.response)

dns.resolver.NoAnswer: The DNS response does not contain an answer to the question: _mongodb._tcp.cluster0.vtc5etr.mongodb.net. IN SRV

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

 File "C:\Users\snl25\Desktop\sparta\pythonprac\dbprac.py", line 6, in <module>

  client = MongoClient('mongodb+srv://test:sparta@cluster0.vtc5etr.mongodb.net/Cluster0?retryWrites=true&w=majority')

 File "C:\Users\snl25\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 736, in __init__

  res = uri_parser.parse_uri(

 File "C:\Users\snl25\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\uri_parser.py", line 542, in parse_uri

  nodes = dns_resolver.get_hosts()

 File "C:\Users\snl25\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\srv_resolver.py", line 121, in get_hosts

  _, nodes = self._get_srv_response_and_hosts(True)

 File "C:\Users\snl25\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\srv_resolver.py", line 101, in _get_srv_response_and_hosts

  results = self._resolve_uri(encapsulate_errors)

 File "C:\Users\snl25\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\srv_resolver.py", line 97, in _resolve_uri

  raise ConfigurationError(str(exc))

pymongo.errors.ConfigurationError: The DNS response does not contain an answer to the question: _mongodb._tcp.cluster0.vtc5etr.mongodb.net. IN SRV

종료 코드 1(으)로 완료된 프로세스