커뮤니티
포인트
쿠폰
내 강의실
국비 신청 내역
증명서
계정
로그아웃
학습 질문
개발 일지
나의 활동
답변 완료
3-11 DB연결.. 오..류..
undefined주차
북마크
송*석
댓글
5
추천
0
조회수
22
조회수
22
답변 완료

DB를 연결하려고 하는데 계속해서 오류가 나네요ㅠ

certifi도 해보고 했는데도 계속 오류가 납니다








작성한 코드 및 에러 메세지

from pymongo import MongoClient
import certifi

ca = certifi.where()

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

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

db.users.insert_one(doc)

/Users/ssongmin/Desktop/sparta/pythonprac/venv/bin/python /Users/ssongmin/Desktop/sparta/pythonprac/dbprac.py 

Traceback (most recent call last):

 File "/Users/ssongmin/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/srv_resolver.py", line 89, in _resolve_uri

  results = _resolve(

 File "/Users/ssongmin/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/srv_resolver.py", line 43, in _resolve

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

 File "/Users/ssongmin/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/dns/resolver.py", line 1193, in resolve

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

 File "/Users/ssongmin/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/dns/resolver.py", line 1090, in resolve

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

 File "/Users/ssongmin/Desktop/sparta/pythonprac/venv/lib/python3.8/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.dbt5g7d.mongodb.net. IN SRV


During handling of the above exception, another exception occurred:


Traceback (most recent call last):

 File "/Users/ssongmin/Desktop/sparta/pythonprac/dbprac.py", line 6, in <module>

  client = MongoClient('mongodb+srv://test:sparta@cluster0.dbt5g7d.mongodb.net/?retryWrites=true&w=majority', tlsCAFile=ca)

 File "/Users/ssongmin/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 736, in __init__

  res = uri_parser.parse_uri(

 File "/Users/ssongmin/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/uri_parser.py", line 542, in parse_uri

  nodes = dns_resolver.get_hosts()

 File "/Users/ssongmin/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/srv_resolver.py", line 121, in get_hosts

  _, nodes = self._get_srv_response_and_hosts(True)

 File "/Users/ssongmin/Desktop/sparta/pythonprac/venv/lib/python3.8/site-packages/pymongo/srv_resolver.py", line 101, in _get_srv_response_and_hosts

  results = self._resolve_uri(encapsulate_errors)

 File "/Users/ssongmin/Desktop/sparta/pythonprac/venv/lib/python3.8/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.dbt5g7d.mongodb.net. IN SRV


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


라는 에러입니다ㅠ




취소
 공유
취소
댓글 0
댓글 알림
나의얼굴