hhyo / Archery

SQL 审核查询平台
https://archerydms.com
Apache License 2.0
6k stars 1.68k forks source link

v1.11.1初始化数据库报错 #2659

Closed cc4dogman closed 4 months ago

cc4dogman commented 4 months ago

重现步骤

1.使用v1.11.1源码通过docker进行部署拉起容器 2.使用命令行进入到容器中 3.执行https://archerydms.com/installation/docker/ 此步骤的数据库初始化

预期外的结果

正常初始化数据库

日志文本

Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying contenttypes.0002_remove_content_type_name... OK
  Applying auth.0001_initial... OK
  Applying auth.0002_alter_permission_name_max_length... OK
  Applying auth.0003_alter_user_email_max_length... OK
  Applying auth.0004_alter_user_username_opts... OK
  Applying auth.0005_alter_user_last_login_null... OK
  Applying auth.0006_require_contenttypes_0002... OK
  Applying auth.0007_alter_validators_add_error_messages... OK
  Applying auth.0008_alter_user_username_max_length... OK
  Applying auth.0009_alter_user_last_name_max_length... OK
  Applying auth.0010_alter_group_name_max_length... OK
  Applying auth.0011_update_proxy_permissions... OK
  Applying auth.0012_alter_user_first_name_max_length... OK
  Applying sql.0001_initial... OK
  Applying admin.0001_initial... OK
  Applying admin.0002_logentry_remove_auto_add... OK
  Applying admin.0003_logentry_add_action_flag_choices... OK
  Applying django_q.0001_initial... OK
  Applying django_q.0002_auto_20150630_1624... OK
  Applying django_q.0003_auto_20150708_1326... OK
  Applying django_q.0004_auto_20150710_1043... OK
  Applying django_q.0005_auto_20150718_1506... OK
  Applying django_q.0006_auto_20150805_1817... OK
  Applying django_q.0007_ormq... OK
  Applying django_q.0008_auto_20160224_1026... OK
  Applying django_q.0009_auto_20171009_0915... OK
  Applying django_q.0010_auto_20200610_0856... OK
  Applying django_q.0011_auto_20200628_1055... OK
  Applying django_q.0012_auto_20200702_1608... OK
  Applying django_q.0013_task_attempt_count... OK
  Applying django_q.0014_schedule_cluster... OK
  Applying sessions.0001_initial... OK
(venv4archery) root@914759089a96:/opt/archery# python3 manage.py dbshell<sql/fixtures/auth_group.sql
python3 manage.py dbshell<src/init_sql/mysql_slow_query_review.sql
2024-05-21 22:42:44,548 - environ.environ - INFO - /opt/archery/.env not found - if you're not configuring your environment separately, check this.
CommandError: You appear not to have the 'mysql' program installed or on your path.
2024-05-21 22:42:45,143 - environ.environ - INFO - /opt/archery/.env not found - if you're not configuring your environment separately, check this.
CommandError: You appear not to have the 'mysql' program installed or on your path.

版本

v1.11.1

部署方式

Docker

是否还有其他可以辅助定位问题的信息?比如数据库版本等

MySQL: 8.0.34 Browsers: Chrome goInception: v1.3.0

LeoQuote commented 4 months ago

You appear not to have the 'mysql' program installed or on your path.

这报错挺清晰的呀,你怎么理解这个错误?

cc4dogman commented 4 months ago

You appear not to have the 'mysql' program installed or on your path.

这报错挺清晰的呀,你怎么理解这个错误?

老版本安装不需要自己注入mysql客户端吧,新版本才需要,所以问一下

LeoQuote commented 4 months ago

感谢你为项目提出的 issue, 我已经提出了对应的 pr, 请等待 merge 后重试, 欢迎为项目提出更多的 issue 或 pr, 本项目 wiki 也开放编辑, 欢迎为本项目添砖加瓦.

jiaping0424 commented 2 months ago

你这个问题解决了吗?我也遇到这个问题了。