我在这里发布我的第一个问题,所以如果我可以提高在这里提问的技能,请告诉我。
我正在 linux 服务器上部署一个 python 应用程序,该应用程序将接收 JSON 有效负载并写入 mariadb 数据库,我已成功在 pycharm 上测试该应用程序,同时将其远程连接到同一数据库。当我在服务器上运行它时,它只给出错误,下面是错误控制台:
**export FLASK_APP=testapp.py
$ python3 -m flask run**
Traceback (most recent call last):
File "/usr/lib/python3.5/runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "/usr/lib/python3.5/runpy.py", line 85, in _run_code
exec(code, run_globals)
File "/usr/lib/python3/dist-packages/flask/__main__.py", line 15, in <module>
main(as_module=True)
File "/usr/lib/python3/dist-packages/flask/cli.py", line 513, in main
cli.main(args=args, prog_name=name)
File "/usr/lib/python3/dist-packages/flask/cli.py", line 380, in main
return AppGroup.main(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/click/core.py", line 696, in main
rv = self.invoke(ctx)
File "/usr/lib/python3/dist-packages/click/core.py", line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/lib/python3/dist-packages/click/core.py", line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/lib/python3/dist-packages/click/core.py", line 534, in invoke
return callback(*args, **kwargs)
File "/usr/lib/python3/dist-packages/click/decorators.py", line 64, in new_func
return ctx.invoke(f, obj, *args[1:], **kwargs)
File "/usr/lib/python3/dist-packages/click/core.py", line 534, in invoke
return callback(*args, **kwargs)
File "/usr/lib/python3/dist-packages/flask/cli.py", line 423, in run_command
app = DispatchingApp(info.load_app, use_eager_loading=eager_loading)
File "/usr/lib/python3/dist-packages/flask/cli.py", line 152, in __init__
self._load_unlocked()
File "/usr/lib/python3/dist-packages/flask/cli.py", line 176, in _load_unlocked
self._app = rv = self.loader()
File "/usr/lib/python3/dist-packages/flask/cli.py", line 237, in load_app
rv = locate_app(self.app_import_path)
File "/usr/lib/python3/dist-packages/flask/cli.py", line 90, in locate_app
__import__(module)
File "/home/573076.cloudwaysapps.com/csthybvwhm/public_html/testapp.py", line 7, in <module>
import mysql.connector as database
File "/home/master/.local/lib/python3.5/site-packages/mysql/connector/__init__.py", line 53, in <module>
from .connection import MySQLConnection
File "/home/master/.local/lib/python3.5/site-packages/mysql/connector/connection.py", line 442
f"This connection is using {tls_version} which is now "
^
Mysql连接配置如下:
import mysql.connector as database
connection = database.connect(
user="username",
password="password",
host="localhost",
database="database",
port="3306"
)
cursor = connection.cursor()
add_user = """INSERT INTO database.tablename
(time, name,email, admin, id, team, remarks)
VALUES (%s,%s,%s,%s,%s,%s,%s)"""
data_user = (name, email, id, team, remarks)
cursor.execute(add_user, data_user)
connection.commit()
cursor.close()
connection.close()
print("Successfully added entry to database")
我尝试为我的 SQL 服务器禁用 SSL,想尝试通过 python 中的 MySQL 配置推送 tls_version,但没有有效的参数让我这样做。
非常欢迎任何帮助或见解,提前谢谢您。这个平台是我到目前为止学习的原因。 :)