web cli不能打开列管资产

说明(发布前可手动删除说明内容):

  • 发布话题前请确认好标题与标签、你已经看过了[JumpServer版规V1.0] ;
  • 如有必要请附带以下信息:JumpServer 版本、运行方式(安装包运行 or 源码运行 )、浏览器版本、更多描述或截图信息。
    想要修改https登陆,更改了配置文件,不知道哪弄错了,现在通过web cli打不开列管的资产,请求协助!

详细一点描述,这样说也看不出啥 :melting_face:

配置文件改了哪里。改了重启服务了吗

/opt/jumpserver/config/config.txt和/opt/jumpserver/config/nginx/lb_https_server.conf,改完都重启jms或重启系统的

f12看前端,/data/jumpserver/core/data/logs/jumpserver.log,看服务日志


2024-07-23 13:34:54 [log ERROR] Internal Server Error: /api/v1/terminal/endpoints/smart/
Traceback (most recent call last):
File “/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/usr/local/lib/python3.8/site-packages/django/db/backends/mysql/base.py”, line 73, in execute
return self.cursor.execute(query, args)
File “/usr/local/lib/python3.8/site-packages/MySQLdb/cursors.py”, line 206, in execute
res = self._query(query)
File “/usr/local/lib/python3.8/site-packages/MySQLdb/cursors.py”, line 319, in _query
db.query(q)
File “/usr/local/lib/python3.8/site-packages/MySQLdb/connections.py”, line 254, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1054, “Unknown column ‘terminal_endpoint.mysql_port’ in ‘field list’”)

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

Traceback (most recent call last):
File “/usr/local/lib/python3.8/site-packages/django/core/handlers/exception.py”, line 47, in inner
response = get_response(request)
File “/usr/local/lib/python3.8/site-packages/django/core/handlers/base.py”, line 181, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File “/usr/local/lib/python3.8/contextlib.py”, line 75, in inner
return func(*args, **kwds)
File “/usr/local/lib/python3.8/site-packages/django/views/decorators/csrf.py”, line 54, in wrapped_view
return view_func(*args, **kwargs)
File “/usr/local/lib/python3.8/site-packages/rest_framework/viewsets.py”, line 125, in view
return self.dispatch(request, *args, **kwargs)
File “/usr/local/lib/python3.8/site-packages/rest_framework/views.py”, line 509, in dispatch
response = self.handle_exception(exc)
File “/usr/local/lib/python3.8/site-packages/rest_framework/views.py”, line 469, in handle_exception
self.raise_uncaught_exception(exc)
File “/usr/local/lib/python3.8/site-packages/rest_framework/views.py”, line 480, in raise_uncaught_exception
raise exc
File “/usr/local/lib/python3.8/site-packages/rest_framework/views.py”, line 506, in dispatch
response = handler(request, *args, **kwargs)
File “/opt/jumpserver/apps/terminal/api/endpoint.py”, line 36, in smart
endpoint = self.match_endpoint()
File “/opt/jumpserver/apps/terminal/api/endpoint.py”, line 43, in match_endpoint
endpoint = self.match_endpoint_by_target_ip()
File “/opt/jumpserver/apps/terminal/api/endpoint.py”, line 54, in match_endpoint_by_target_ip
endpoint = EndpointRule.match_endpoint(target_ip, self.target_protocol, self.request)
File “/opt/jumpserver/apps/terminal/models/endpoint.py”, line 122, in match_endpoint
endpoint = Endpoint.get_or_create_default(request)
File “/opt/jumpserver/apps/terminal/models/endpoint.py”, line 65, in get_or_create_default
endpoint, created = cls.objects.get_or_create(id=cls.default_id, defaults=data)
File “/usr/local/lib/python3.8/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.8/site-packages/django/db/models/query.py”, line 581, in get_or_create
return self.get(**kwargs), False
File “/usr/local/lib/python3.8/site-packages/django/db/models/query.py”, line 431, in get
num = len(clone)
File “/usr/local/lib/python3.8/site-packages/django/db/models/query.py”, line 262, in len
self._fetch_all()
File “/usr/local/lib/python3.8/site-packages/django/db/models/query.py”, line 1324, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/usr/local/lib/python3.8/site-packages/django/db/models/query.py”, line 51, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File “/usr/local/lib/python3.8/site-packages/django/db/models/sql/compiler.py”, line 1175, in execute_sql
cursor.execute(sql, params)
File “/usr/local/lib/python3.8/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.8/site-packages/django/db/backends/utils.py”, line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File “/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/usr/local/lib/python3.8/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.8/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/usr/local/lib/python3.8/site-packages/django/db/backends/mysql/base.py”, line 73, in execute
return self.cursor.execute(query, args)
File “/usr/local/lib/python3.8/site-packages/MySQLdb/cursors.py”, line 206, in execute
res = self._query(query)
File “/usr/local/lib/python3.8/site-packages/MySQLdb/cursors.py”, line 319, in _query
db.query(q)
File “/usr/local/lib/python3.8/site-packages/MySQLdb/connections.py”, line 254, in query
_mysql.connection.query(self, query)
django.db.utils.OperationalError: (1054, “Unknown column ‘terminal_endpoint.mysql_port’ in ‘field list’”)

缺少字段,你之前的服务正常的吗,有没有做过数据库迁移或者升级版本的操作

少字段了。是不是调整过表

没有,我已重建,谢谢!

没有,我已重建,谢谢!