from pymongo import MongoClient
client = MongoClient('여기에 URL 입력')
db = client.dbsparta

3-12에서 위의 코드스니펫 처럼 코딩하면 mongodb접속 오류가 나고

이 즉문즉답의 다른 질문에서 보고 수정한 아래 코드로 하면

import certifi
from pymongo import MongoClient
client = MongoClient('여기에 URL 입력', tlsCAFile=certifi.where())
db = client.dbsparta

오류가 안납니다.

그래서 3-12는 위 코드로 잘 마무리 했는데요....

4-8에서 다시 mongodb연결이 나오는데요

import certifi

from flask import Flask, render_template, request, jsonify
app = Flask(__name__)

from pymongo import MongoClient
client = MongoClient('mongodb+srv://test:sparta@cluster0.yx8n0lh.mongodb.net/?retryWrites=true&w=majority' , tlsCAFile=certifi.where())
db = client.dbsparta


@app.route('/')
def home():
   return render_template('index.html')

@app.route("/mars", methods=["POST"])
def web_mars_post():
    name_receive = request.form['name_give']
    address_receive = request.form['address_give']
    size_receive = request.form['size_give']

    doc = {
        'name':name_receive,
        'address':address_receive,
        'size':size_receive
    }
    db.mars.insert_one(doc)

    return jsonify({'msg': '화성땅 주문 완료!'})

@app.route("/mars", methods=["GET"])
def web_mars_get():
    return jsonify({'msg': 'GET 연결 완료!'})

if __name__ == '__main__':
   app.run('0.0.0.0', port=5000, debug=True)

위 처럼 하면

Traceback (most recent call last):

 File "C:/Users/FamilyPC/Desktop/sparta/projects/mars/app.py", line 2, in <module>

  import certifi

ModuleNotFoundError: No module named 'certifi'

라고 오류가 납니다.

원래의 mongodb연결 소스인 import 문 지우고 client의 마지막 항목을 지우면

app.py는 실행이 잘 되지만, index.html에서 주문하기를 누르면 한참 있다가 아래 오류가 발생합니다.

Traceback (most recent call last):

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 2548, in __call__

  return self.wsgi_app(environ, start_response)

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 2528, in wsgi_app

  response = self.handle_exception(e)

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 2525, in wsgi_app

  response = self.full_dispatch_request()

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 1822, in full_dispatch_request

  rv = self.handle_user_exception(e)

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 1820, in full_dispatch_request

  rv = self.dispatch_request()

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 1796, in dispatch_request

  return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\app.py", line 27, in web_mars_post

  db.mars.insert_one(doc)

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\collection.py", line 621, in insert_one

  self._insert_one(

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\collection.py", line 562, in _insert_one

  self.__database.client._retryable_write(acknowledged, _insert_command, session)

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1447, in _retryable_write

  with self._tmp_session(session) as s:

 File "C:\Users\FamilyPC\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__

  return next(self.gen)

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1729, in _tmp_session

  s = self._ensure_session(session)

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1712, in _ensure_session

  return self.__start_session(True, causal_consistency=False)

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1657, in __start_session

  self._topology._check_implicit_session_support()

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support

  self._check_session_support()

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support

  self._select_servers_loop(

 File "C:\Users\FamilyPC\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop

  raise ServerSelectionTimeoutError(

pymongo.errors.ServerSelectionTimeoutError: ac-exvj9rc-shard-00-02.yx8n0lh.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-exvj9rc-shard-00-00.yx8n0lh.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-exvj9rc-shard-00-01.yx8n0lh.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124), Timeout: 30s, Topology Description: <TopologyDescription id: 63182f3a63c9eba17d366a06, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-exvj9rc-shard-00-00.yx8n0lh.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-exvj9rc-shard-00-00.yx8n0lh.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-exvj9rc-shard-00-01.yx8n0lh.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-exvj9rc-shard-00-01.yx8n0lh.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-exvj9rc-shard-00-02.yx8n0lh.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-exvj9rc-shard-00-02.yx8n0lh.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>]>