【已解答】宝塔运行python 报错
系统：Ubuntu 22.04.1 LTS (Jammy Jellyfish) x86_64(Py3.7.8)
全部日志见附件
Traceback (most recent call last):
File "/www/wwwroot/video_python/label.py", line 2, in <module>
import pc3
File "/www/wwwroot/video_python/pc3.py", line 13, in <module>
video_service = VideoInfoService(DATABASE_URL)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/wwwroot/video_python/video_service.py", line 9, in __init__
self.db.create_tables()
File "/www/wwwroot/video_python/db_helper.py", line 17, in create_tables
self.Base.metadata.create_all(self.engine)
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/sql/schema.py", line 5925, in create_all
bind._run_ddl_visitor(
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3248, in _run_ddl_visitor
with self.begin() as conn:
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/contextlib.py", line 137, in __enter__
return next(self.gen)
^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3238, in begin
with self.connect() as conn:
^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3274, in connect
return self._connection_cls(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 148, in __init__
Connection._handle_dbapi_exception_noconnection(
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2439, in _handle_dbapi_exception_noconnection
raise sqlalchemy_exception.with_traceback(exc_info) from e
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 146, in __init__
self._dbapi_connection = engine.raw_connection()
^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3298, in raw_connection
return self.pool.connect()
^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 1264, in _checkout
fairy = _ConnectionRecord.checkout(pool)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 713, in checkout
rec = pool._do_get()
^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/impl.py", line 179, in _do_get
with util.safe_reraise():
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get
return self._create_connection()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
return _ConnectionRecord(self)
^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 675, in __init__
self.__connect()
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 901, in __connect
with util.safe_reraise():
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 897, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/create.py", line 646, in connect
return dialect.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 625, in connect
return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore # NOQA: E501
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/connections.py", line 361, in __init__
self.connect()
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/connections.py", line 669, in connect
self._request_authentication()
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/connections.py", line 957, in _request_authentication
auth_packet = self._read_packet()
^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/connections.py", line 775, in _read_packet
packet.raise_for_error()
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
(Background on this error at: https://sqlalche.me/e/20/e3q8) 这是全部日志
Traceback (most recent call last):
File "/www/wwwroot/video_python/label.py", line 2, in <module>
import pc3
File "/www/wwwroot/video_python/pc3.py", line 13, in <module>
video_service = VideoInfoService(DATABASE_URL)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/wwwroot/video_python/video_service.py", line 9, in __init__
self.db.create_tables()
File "/www/wwwroot/video_python/db_helper.py", line 17, in create_tables
self.Base.metadata.create_all(self.engine)
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/sql/schema.py", line 5925, in create_all
bind._run_ddl_visitor(
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3248, in _run_ddl_visitor
with self.begin() as conn:
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/contextlib.py", line 137, in __enter__
return next(self.gen)
^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3238, in begin
with self.connect() as conn:
^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3274, in connect
return self._connection_cls(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 148, in __init__
Connection._handle_dbapi_exception_noconnection(
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2439, in _handle_dbapi_exception_noconnection
raise sqlalchemy_exception.with_traceback(exc_info) from e
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 146, in __init__
self._dbapi_connection = engine.raw_connection()
^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3298, in raw_connection
return self.pool.connect()
^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 1264, in _checkout
fairy = _ConnectionRecord.checkout(pool)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 713, in checkout
rec = pool._do_get()
^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/impl.py", line 179, in _do_get
with util.safe_reraise():
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get
return self._create_connection()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
return _ConnectionRecord(self)
^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 675, in __init__
self.__connect()
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 901, in __connect
with util.safe_reraise():
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 897, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/create.py", line 646, in connect
return dialect.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 625, in connect
return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore # NOQA: E501
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/connections.py", line 361, in __init__
self.connect()
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/connections.py", line 669, in connect
self._request_authentication()
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/connections.py", line 957, in _request_authentication
auth_packet = self._read_packet()
^^^^^^^^^^^^^^^^^^^
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/connections.py", line 775, in _read_packet
packet.raise_for_error()
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File "/www/server/pyporject_evn/video_py_venv/lib/python3.12/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
(Background on this error at: https://sqlalche.me/e/20/e3q8)
关键错误信息
表示使用 pymysql驱动连接 mysql数据库时被拒绝访问
检查数据库配置是否正确
数据库是否正常运行
权限是否设置正确
页:
[1]