Skip to content

[Bug]: docker-compose部署显示install成功,但是登录报错 #1955

Description

@yogurt-ui

Preflight Checklist

  • I agree to follow the Code of Conduct that this project adheres to.
  • I have searched the issue tracker for an issue that matches the one I want to file, without success.
  • I am not looking for support or already pursued the available support channels without success.

Version

1.15

Installation Type

Official Docker Compose

Service Name

Deploy(DongTai-deploy)

Describe the details of the bug and the steps to reproduce it

docker-compose部署显示成功,无法登录,查看dongtai-server,log日志报错如下:启动uwsgi服务
INFO 2025-04-24 20:48:28,925 [init.monkey_patch:68] app: dongtai_common module: dongtai_engine.plugins.method_pool class: func : method_pool_after_scan is patched by PlugMethodPoolAfterScan
INFO 2025-04-24 20:48:29,165 [report_handler_factory.wrapper:80] Registration report type 130 handler FilePathHandler
INFO 2025-04-24 20:48:29,167 [report_handler_factory.wrapper:80] Registration report type 129 handler ThirdPartyServiceHandler
INFO 2025-04-24 20:48:29,168 [report_handler_factory.wrapper:80] Registration report type 97 handler ApiRouteHandler
INFO 2025-04-24 20:48:29,170 [report_handler_factory.wrapper:80] Registration report type 81 handler ErrorLogHandler
INFO 2025-04-24 20:48:29,172 [report_handler_factory.wrapper:80] Registration report type 37 handler HardEncodeVulHandler
INFO 2025-04-24 20:48:29,176 [report_handler_factory.wrapper:80] Registration report type 1 handler HeartBeatHandler
INFO 2025-04-24 20:48:29,184 [report_handler_factory.wrapper:80] Registration report type 33 handler NormalVulnHandler
INFO 2025-04-24 20:48:29,190 [report_handler_factory.wrapper:80] Registration report type 36 handler SaasMethodPoolHandler
INFO 2025-04-24 20:48:29,235 [report_handler_factory.wrapper:80] Registration report type 17 handler ScaHandler
INFO 2025-04-24 20:48:29,235 [report_handler_factory.wrapper:80] Registration report type 18 handler ScaBulkHandler
use local file
is in gevent patched : False
preheat settings now : True
File “/opt/dongtai/static/i18n/en/LC_MESSAGES/django.po” is already compiled and up to date.
File “/opt/dongtai/static/i18n/zh/LC_MESSAGES/django.po” is already compiled and up to date.

Get the latest vulnerability rules.
INFO 2025-04-24 20:48:32,343 [init.monkey_patch:68] app: dongtai_common module: dongtai_engine.plugins.method_pool class: func : method_pool_after_scan is patched by PlugMethodPoolAfterScan
INFO 2025-04-24 20:48:32,577 [report_handler_factory.wrapper:80] Registration report type 130 handler FilePathHandler
INFO 2025-04-24 20:48:32,579 [report_handler_factory.wrapper:80] Registration report type 129 handler ThirdPartyServiceHandler
INFO 2025-04-24 20:48:32,579 [report_handler_factory.wrapper:80] Registration report type 97 handler ApiRouteHandler
INFO 2025-04-24 20:48:32,580 [report_handler_factory.wrapper:80] Registration report type 81 handler ErrorLogHandler
INFO 2025-04-24 20:48:32,582 [report_handler_factory.wrapper:80] Registration report type 37 handler HardEncodeVulHandler
INFO 2025-04-24 20:48:32,584 [report_handler_factory.wrapper:80] Registration report type 1 handler HeartBeatHandler
INFO 2025-04-24 20:48:32,589 [report_handler_factory.wrapper:80] Registration report type 33 handler NormalVulnHandler
INFO 2025-04-24 20:48:32,596 [report_handler_factory.wrapper:80] Registration report type 36 handler SaasMethodPoolHandler
INFO 2025-04-24 20:48:32,645 [report_handler_factory.wrapper:80] Registration report type 17 handler ScaHandler
INFO 2025-04-24 20:48:32,645 [report_handler_factory.wrapper:80] Registration report type 18 handler ScaBulkHandler
use local file
is in gevent patched : False
preheat settings now : True
strategy: 100%|██████████| 45/45 [00:00<00:00, 278.05it/s]
hook_type: 100%|██████████| 106/106 [00:00<00:00, 562.39it/s]
policy: 0%| | 0/83 [00:00<?, ?it/s]
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python3.10/site-packages/django/db/backends/mysql/base.py", line 73, in execute
return self.cursor.execute(query, args)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1364, "Field 'pref_level' doesn't have a default value")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/opt/dongtai/manage.py", line 21, in
main()
File "/opt/dongtai/manage.py", line 17, in main
execute_from_command_line(sys.argv)
File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 419, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 413, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 354, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 398, in execute
output = self.handle(*args, **options)
File "/opt/dongtai/deploy/commands/management/commands/load_hook_strategy.py", line 168, in handle
HookStrategy.objects.create(hooktype=policy_hook_type, **hook_strategy)
File "/usr/local/lib/python3.10/site-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 453, in create
obj.save(force_insert=True, using=self.db)
File "/usr/local/lib/python3.10/site-packages/django/db/models/base.py", line 739, in save
self.save_base(using=using, force_insert=force_insert,
File "/usr/local/lib/python3.10/site-packages/django/db/models/base.py", line 776, in save_base
updated = self._save_table(
File "/usr/local/lib/python3.10/site-packages/django/db/models/base.py", line 881, in _save_table
results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw)
File "/usr/local/lib/python3.10/site-packages/django/db/models/base.py", line 919, in _do_insert
return manager._insert(
File "/usr/local/lib/python3.10/site-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1270, in _insert
return query.get_compiler(using=using).execute_sql(returning_fields)
File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1416, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python3.10/site-packages/django/db/backends/mysql/base.py", line 73, in execute
return self.cursor.execute(query, args)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
django.db.utils.OperationalError: (1364, "Field 'pref_level' doesn't have a default value")
ERROR: Lost connection to MySQL server !!!

Additional Information

No response

Logs

启动uwsgi服务
INFO 2025-04-24 20:48:28,925 [__init__.monkey_patch:68] app: dongtai_common module: dongtai_engine.plugins.method_pool class:  func : method_pool_after_scan is patched by PlugMethodPoolAfterScan
INFO 2025-04-24 20:48:29,165 [report_handler_factory.wrapper:80] Registration report type 130 handler FilePathHandler
INFO 2025-04-24 20:48:29,167 [report_handler_factory.wrapper:80] Registration report type 129 handler ThirdPartyServiceHandler
INFO 2025-04-24 20:48:29,168 [report_handler_factory.wrapper:80] Registration report type 97 handler ApiRouteHandler
INFO 2025-04-24 20:48:29,170 [report_handler_factory.wrapper:80] Registration report type 81 handler ErrorLogHandler
INFO 2025-04-24 20:48:29,172 [report_handler_factory.wrapper:80] Registration report type 37 handler HardEncodeVulHandler
INFO 2025-04-24 20:48:29,176 [report_handler_factory.wrapper:80] Registration report type 1 handler HeartBeatHandler
INFO 2025-04-24 20:48:29,184 [report_handler_factory.wrapper:80] Registration report type 33 handler NormalVulnHandler
INFO 2025-04-24 20:48:29,190 [report_handler_factory.wrapper:80] Registration report type 36 handler SaasMethodPoolHandler
INFO 2025-04-24 20:48:29,235 [report_handler_factory.wrapper:80] Registration report type 17 handler ScaHandler
INFO 2025-04-24 20:48:29,235 [report_handler_factory.wrapper:80] Registration report type 18 handler ScaBulkHandler
use local file
is in gevent patched : False
preheat settings now : True
File “/opt/dongtai/static/i18n/en/LC_MESSAGES/django.po” is already compiled and up to date.
File “/opt/dongtai/static/i18n/zh/LC_MESSAGES/django.po” is already compiled and up to date.

Get the latest vulnerability rules.
INFO 2025-04-24 20:48:32,343 [__init__.monkey_patch:68] app: dongtai_common module: dongtai_engine.plugins.method_pool class:  func : method_pool_after_scan is patched by PlugMethodPoolAfterScan
INFO 2025-04-24 20:48:32,577 [report_handler_factory.wrapper:80] Registration report type 130 handler FilePathHandler
INFO 2025-04-24 20:48:32,579 [report_handler_factory.wrapper:80] Registration report type 129 handler ThirdPartyServiceHandler
INFO 2025-04-24 20:48:32,579 [report_handler_factory.wrapper:80] Registration report type 97 handler ApiRouteHandler
INFO 2025-04-24 20:48:32,580 [report_handler_factory.wrapper:80] Registration report type 81 handler ErrorLogHandler
INFO 2025-04-24 20:48:32,582 [report_handler_factory.wrapper:80] Registration report type 37 handler HardEncodeVulHandler
INFO 2025-04-24 20:48:32,584 [report_handler_factory.wrapper:80] Registration report type 1 handler HeartBeatHandler
INFO 2025-04-24 20:48:32,589 [report_handler_factory.wrapper:80] Registration report type 33 handler NormalVulnHandler
INFO 2025-04-24 20:48:32,596 [report_handler_factory.wrapper:80] Registration report type 36 handler SaasMethodPoolHandler
INFO 2025-04-24 20:48:32,645 [report_handler_factory.wrapper:80] Registration report type 17 handler ScaHandler
INFO 2025-04-24 20:48:32,645 [report_handler_factory.wrapper:80] Registration report type 18 handler ScaBulkHandler
use local file
is in gevent patched : False
preheat settings now : True
strategy: 100%|██████████| 45/45 [00:00<00:00, 278.05it/s]
hook_type: 100%|██████████| 106/106 [00:00<00:00, 562.39it/s]
policy:   0%|          | 0/83 [00:00<?, ?it/s]
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/mysql/base.py", line 73, in execute
    return self.cursor.execute(query, args)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 148, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 310, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1364, "Field 'pref_level' doesn't have a default value")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/opt/dongtai/manage.py", line 21, in <module>
    main()
  File "/opt/dongtai/manage.py", line 17, in main
    execute_from_command_line(sys.argv)
  File "/usr/local/lib/python3.10/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line
    utility.execute()
  File "/usr/local/lib/python3.10/site-packages/django/core/management/__init__.py", line 413, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 354, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 398, in execute
    output = self.handle(*args, **options)
  File "/opt/dongtai/deploy/commands/management/commands/load_hook_strategy.py", line 168, in handle
    HookStrategy.objects.create(hooktype=policy_hook_type, **hook_strategy)
  File "/usr/local/lib/python3.10/site-packages/django/db/models/manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 453, in create
    obj.save(force_insert=True, using=self.db)
  File "/usr/local/lib/python3.10/site-packages/django/db/models/base.py", line 739, in save
    self.save_base(using=using, force_insert=force_insert,
  File "/usr/local/lib/python3.10/site-packages/django/db/models/base.py", line 776, in save_base
    updated = self._save_table(
  File "/usr/local/lib/python3.10/site-packages/django/db/models/base.py", line 881, in _save_table
    results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw)
  File "/usr/local/lib/python3.10/site-packages/django/db/models/base.py", line 919, in _do_insert
    return manager._insert(
  File "/usr/local/lib/python3.10/site-packages/django/db/models/manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1270, in _insert
    return query.get_compiler(using=using).execute_sql(returning_fields)
  File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1416, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 66, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 79, in _execute
    with self.db.wrap_database_errors:
  File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/mysql/base.py", line 73, in execute
    return self.cursor.execute(query, args)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 148, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 310, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
django.db.utils.OperationalError: (1364, "Field 'pref_level' doesn't have a default value")
ERROR: Lost connection to MySQL server !!!

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions