화성 땅 주문하기 를 누르면 alert도 뜨지 않고 아무런 변화가 없습니다. 터미널에서는 아래와 같은 내용이 나오구요.
그런데 이따가 다시 해보면 이젠 아예 접속도 안됩니다. localhost:5000 가도 사이트에 연결할 수 없다고 떠요.
접속이 안되는 문제, 그리고 어떻게 어떻게 접속이 되도 작동을 안하고..난감하네요.
코드 화면
작성한 코드 및 에러 메세지
app.py
from flask import Flask, render_template, request, jsonify
app = Flask(__name__)
from pymongo import MongoClient
import certifi
ca = certifi.where()
client = MongoClient('mongodb+srv://test:sparta@cluster0.내주소.mongodb.net/내DB명?retryWrites=true&w=majority', tlsCAFile=ca)
db = client.dbsparta
@app.route('/')
def home():
return render_template('index.html')
@app.route("/mars", methods=["POST"])
def 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 mars_get():
return jsonify({'msg':'GET 연결 완료!'})
if __name__ == '__main__':
app.run('0.0.0.0', port=5000, debug=True)
---
Index.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js"
integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM"
crossorigin="anonymous"></script>
<link href="https://fonts.googleapis.com/css2?family=Gowun+Batang:wght@400;700&display=swap" rel="stylesheet" />
<title>선착순 공동구매</title>
<style>
* {
font-family: "Gowun Batang", serif;
color: white;
}
body {
background-image: linear-gradient(0deg,
rgba(0, 0, 0, 0.5),
rgba(0, 0, 0, 0.5)),
url("https://cdn.aitimes.com/news/photo/202010/132592_129694_3139.jpg");
background-position: center;
background-size: cover;
}
h1 {
font-weight: bold;
}
.order {
width: 500px;
margin: 60px auto 0px auto;
padding-bottom: 60px;
}
.mybtn {
width: 100%;
}
.order>table {
margin: 40px 0;
font-size: 18px;
}
option {
color: black;
}
</style>
<script>
$(document).ready(function () {
show_order();
});
function show_order() {
fetch('/mars').then((res) => res.json()).then((data) => {
console.log(data)
alert(data['msg'])
})
}
function save_order() {
let name = $('#name').val()
let address = $('#address').val()
let size = $('#size').val()
let formData = new FormData();
formData.append("name_give", name)
formData.append("address_give", address)
formData.append("size_give", size)
fetch('/mars', { method: "POST", body: formData }).then((res) => res.json()).then((data) => {
alert(data["msg"]);
});
}
</script>
</head>
<body>
<div class="mask"></div>
<div class="order">
<h1>화성에 땅 사놓기!</h1>
<h3>가격: 평 당 500원</h3>
<p>
화성에 땅을 사둘 수 있다고?<br />
앞으로 백년 간 오지 않을 기회. 화성에서 즐기는 노후!
</p>
<div class="order-info">
<div class="input-group mb-3">
<span class="input-group-text">이름</span>
<input id="name" type="text" class="form-control" />
</div>
<div class="input-group mb-3">
<span class="input-group-text">주소</span>
<input id="address" type="text" class="form-control" />
</div>
<div class="input-group mb-3">
<label class="input-group-text" for="size">평수</label>
<select class="form-select" id="size">
<option selected>-- 주문 평수 --</option>
<option value="10평">10평</option>
<option value="20평">20평</option>
<option value="30평">30평</option>
<option value="40평">40평</option>
<option value="50평">50평</option>
</select>
</div>
<button onclick="save_order()" type="button" class="btn btn-warning mybtn">
주문하기
</button>
</div>
<table class="table">
<thead>
<tr>
<th scope="col">이름</th>
<th scope="col">주소</th>
<th scope="col">평수</th>
</tr>
</thead>
<tbody id="order-box">
<tr>
<td>홍길동</td>
<td>서울시 용산구</td>
<td>20평</td>
</tr>
<tr>
<td>임꺽정</td>
<td>부산시 동구</td>
<td>10평</td>
</tr>
<tr>
<td>세종대왕</td>
<td>세종시 대왕구</td>
<td>30평</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
---
터미널 에러 메세지
guihy@DESKTOP-OABH4GQ MINGW64 ~/Desktop/Sparta/projects/02.mars
$ c:/Users/guihy/Desktop/Sparta/projects/02.mars/venv/Scripts/python.exe c:/Users/guihy/Desktop/Sparta/projects/02.mars/app.py * Serving Flask app 'app'
* Debug mode: on
WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead. * Running on all addresses (0.0.0.0)
* Running on http://127.0.0.1:5000
* Running on http://192.168.1.86:5000
Press CTRL+C to quit * Restarting with stat
* Debugger is active!
* Debugger PIN: 570-846-522
127.0.0.1 - - [15/Mar/2023 10:09:43] "GET / HTTP/1.1" 200 -
127.0.0.1 - - [15/Mar/2023 10:09:44] "GET /mars HTTP/1.1" 200 -
127.0.0.1 - - [15/Mar/2023 10:09:53] "GET /favicon.ico HTTP/1.1" 404 -
127.0.0.1 - - [15/Mar/2023 10:13:08] "POST /mars HTTP/1.1" 500 -
Traceback (most recent call last):
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\flask\app.py", line 2551, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\flask\app.py", line 2531, in wsgi_app
response = self.handle_exception(e)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\flask\app.py", line 2528, in wsgi_app
response = self.full_dispatch_request()
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\flask\app.py", line 1825, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\flask\app.py", line 1823, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\flask\app.py", line 1799, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
File "c:\Users\guihy\Desktop\Sparta\projects\02.mars\app.py", line 23, in mars_post
db.mars.insert_one(doc)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one
self._insert_one(
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one
self.__database.client._retryable_write(acknowledged, _insert_command, session)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write
with self._tmp_session(session) as s:
File "C:\Users\guihy\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
return next(self.gen)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session
s = self._ensure_session(session)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session
return self.__start_session(True, causal_consistency=False)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session
self._topology._check_implicit_session_support()
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support
self._check_session_support()
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support
self._select_servers_loop(
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop
raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-ddlhzlf-shard-00-00.hq4jwjz.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-ddlhzlf-shard-00-01.hq4jwjz.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124),ac-ddlhzlf-shard-00-02.hq4jwjz.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124), Timeout: 30s, Topology Description: <TopologyDescription id: 6411fbd7d673ee4b2e24c073, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-ddlhzlf-shard-00-00.hq4jwjz.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-ddlhzlf-shard-00-00.hq4jwjz.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-ddlhzlf-shard-00-01.hq4jwjz.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-ddlhzlf-shard-00-01.hq4jwjz.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>, <ServerDescription ('ac-ddlhzlf-shard-00-02.hq4jwjz.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-ddlhzlf-shard-00-02.hq4jwjz.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1124)')>]>
* Detected change in 'c:\\Users\\guihy\\Desktop\\Sparta\\projects\\02.mars\\app.py', reloading
Exception in thread Thread-1:
Traceback (most recent call last):
File "C:\Users\guihy\AppData\Local\Programs\Python\Python38\lib\threading.py", line 932, in _bootstrap_inner
self.run()
File "C:\Users\guihy\AppData\Local\Programs\Python\Python38\lib\threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\werkzeug\serving.py", line 766, in serve_forever
super().serve_forever(poll_interval=poll_interval)
File "C:\Users\guihy\AppData\Local\Programs\Python\Python38\lib\socketserver.py", line 232, in serve_forever
ready = selector.select(poll_interval)
File "C:\Users\guihy\AppData\Local\Programs\Python\Python38\lib\selectors.py", line 323, in select
r, w, _ = self._select(self._readers, self._writers, [], timeout)
File "C:\Users\guihy\AppData\Local\Programs\Python\Python38\lib\selectors.py", line 314, in _select
r, w, x = select.select(r, w, w, timeout)
OSError: [WinError 10038] 소켓 이외의 개체에 작업 을 시도했습니다
* Restarting with stat
Traceback (most recent call last):
File "c:\Users\guihy\Desktop\Sparta\projects\02.mars\app.py", line 5, in <module>
import certifi
ModuleNotFoundError: No module named 'certifi'
(venv)
guihy@DESKTOP-OABH4GQ MINGW64 ~/Desktop/Sparta/projects/02.mars
$ c:/Users/guihy/Desktop/Sparta/projects/02.mars/venv/Scripts/python.exe c:/Users/guihy/Desktop/Sparta/projects/02.mars/app.py
Traceback (most recent call last):
File "c:/Users/guihy/Desktop/Sparta/projects/02.mars/app.py", line 5, in <module>
import certifi
ModuleNotFoundError: No module named 'certifi'
(venv)
guihy@DESKTOP-OABH4GQ MINGW64 ~/Desktop/Sparta/projects/02.mars
$ pip install certifi
Collecting certifi
Using cached certifi-2022.12.7-py3-none-any.whl (155 kB)
Installing collected packages: certifi
Successfully installed certifi-2022.12.7
WARNING: You are using pip version 20.2.1; however, version 23.0.1 is available.
You should consider upgrading via the 'c:\users\guihy\desktop\sparta\projects\02.mars\venv\scripts\python.exe -m pip install --upgrade pip' command.
(venv)
guihy@DESKTOP-OABH4GQ MINGW64 ~/Desktop/Sparta/projects/02.mars
$ c:/Users/guihy/Desktop/Sparta/projects/02.mars/venv/Scripts/python.exe c:/Users/guihy/Desktop/Sparta/projects/02.mars/app.py
Traceback (most recent call last):
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 89, in _resolve_uri
results = _resolve(
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 43, in _resolve
return resolver.resolve(*args, **kwargs)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\dns\resolver.py", line 1368, in resolve
return get_default_resolver().resolve(
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\dns\resolver.py", line 1190, in resolve
(request, answer) = resolution.next_request()
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\dns\resolver.py", line 691, in next_request
raise NXDOMAIN(qnames=self.qnames_to_try, responses=self.nxdomain_responses)
dns.resolver.NXDOMAIN: The DNS query name does not exist: _mongodb._tcp.cluster0.xn--220bl33agsf.mongodb.net.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "c:/Users/guihy/Desktop/Sparta/projects/02.mars/app.py", line 9, in <module>
client = MongoClient('mongodb+srv://test:sparta@cluster0.내주소.mongodb.net/내DB명?retryWrites=true&w=majority', tlsCAFile=ca)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\mongo_client.py", line 736, in __init__
res = uri_parser.parse_uri(
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\uri_parser.py", line 542, in parse_uri
nodes = dns_resolver.get_hosts()
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 121, in get_hosts
_, nodes = self._get_srv_response_and_hosts(True)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\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\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 97, in _resolve_uri
raise ConfigurationError(str(exc))
pymongo.errors.ConfigurationError: The DNS query name does not exist: _mongodb._tcp.cluster0.xn--220bl33agsf.mongodb.net.
(venv)
guihy@DESKTOP-OABH4GQ MINGW64 ~/Desktop/Sparta/projects/02.mars
$ ^C
(venv)
guihy@DESKTOP-OABH4GQ MINGW64 ~/Desktop/Sparta/projects/02.mars
$ c:/Users/guihy/Desktop/Sparta/projects/02.mars/venv/Scripts/python.exe c:/Users/guihy/Desktop/Sparta/projects/02.mars/app.py
Traceback (most recent call last):
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 89, in _resolve_uri
results = _resolve(
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 43, in _resolve
return resolver.resolve(*args, **kwargs)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\dns\resolver.py", line 1368, in resolve
return get_default_resolver().resolve(
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\dns\resolver.py", line 1190, in resolve
(request, answer) = resolution.next_request()
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\dns\resolver.py", line 691, in next_request
raise NXDOMAIN(qnames=self.qnames_to_try, responses=self.nxdomain_responses)
dns.resolver.NXDOMAIN: The DNS query name does not exist: _mongodb._tcp.cluster0.xn--220bl33agsf.mongodb.net.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "c:/Users/guihy/Desktop/Sparta/projects/02.mars/app.py", line 9, in <module>
client = MongoClient('mongodb+srv://test:sparta@cluster0.내주소.mongodb.net/내DB명?retryWrites=true&w=majority', tlsCAFile=ca)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\mongo_client.py", line 736, in __init__
res = uri_parser.parse_uri(
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\uri_parser.py", line 542, in parse_uri
nodes = dns_resolver.get_hosts()
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 121, in get_hosts
_, nodes = self._get_srv_response_and_hosts(True)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\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\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 97, in _resolve_uri
raise ConfigurationError(str(exc))
pymongo.errors.ConfigurationError: The DNS query name does not exist: _mongodb._tcp.cluster0.xn--220bl33agsf.mongodb.net.
(venv)
guihy@DESKTOP-OABH4GQ MINGW64 ~/Desktop/Sparta/projects/02.mars
$ c:/Users/guihy/Desktop/Sparta/projects/02.mars/venv/Scripts/python.exe c:/Users/guihy/Desktop/Sparta/projects/02.mars/app.py
Traceback (most recent call last):
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 89, in _resolve_uri
results = _resolve(
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 43, in _resolve
return resolver.resolve(*args, **kwargs)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\dns\resolver.py", line 1368, in resolve
return get_default_resolver().resolve(
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\dns\resolver.py", line 1190, in resolve
mars\venv\lib\site-packages\pymongo\uri_parser.py", line 542, in parse_uri
nodes = dns_resolver.get_hosts()
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 121, in get_hosts
_, nodes = self._get_srv_response_and_hosts(True)
File "C:\Users\guihy\Desktop\Sparta\projects\02.mars\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\guihy\Desktop\Sparta\projects\02.mars\venv\lib\site-packages\pymongo\srv_resolver.py", line 97, in _resolve_uri
raise ConfigurationError(str(exc))
pymongo.errors.ConfigurationError: The DNS query name does not exist: _mongodb._tcp.cluster0.xn--220bl33agsf.mongodb.net.
(venv)
guihy@DESKTOP-OABH4GQ MINGW64 ~/Desktop/Sparta/projects/02.mars
$
