glzjin / ctfd-whale Goto Github PK

在安装插件后，访问CTFd会频繁的500，js什么的经常调用不了
日志查看了一遍，没发现什么问题，最后查看了uwsgi.log，看到以下信息，不知道是否相关

Traceback (most recent call last):
File "wsgi.py", line 11, in
app = create_app()
File "./CTFd/init.py", line 281, in create_app
init_plugins(app)
File "./CTFd/plugins/init.py", line 196, in init_plugins
module.load(app)
File "./CTFd/plugins/ctfd-whale/init.py", line 216, in load
redis_util = RedisUtils(app=app)
File "./CTFd/plugins/ctfd-whale/redis_utils.py", line 9, in init
self.redis_client = FlaskRedis(app)
File "/opt/pyenv/versions/3.7.5/envs/ctfdenv/lib/python3.7/site-packages/flask_redis/client.py", line 16, in init
self.init_app(app)
File "/opt/pyenv/versions/3.7.5/envs/ctfdenv/lib/python3.7/site-packages/flask_redis/client.py", line 38, in init_app
redis_url, **self.provider_kwargs
File "/opt/pyenv/versions/3.7.5/envs/ctfdenv/lib/python3.7/site-packages/redis/client.py", line 638, in from_url
connection_pool = ConnectionPool.from_url(url, db=db, **kwargs)
File "/opt/pyenv/versions/3.7.5/envs/ctfdenv/lib/python3.7/site-packages/redis/connection.py", line 999, in from_url
'schemes (%s)' % valid_schemes)
ValueError: Redis URL must specify one of the followingschemes (redis://, rediss://, unix://)

请问这个该怎么解决

新版CTFd(3.0+)部署

https://github.com/frankli0324/CTFd-Whale/blob/master/INSTALL.md
https://github.com/frankli0324/CTFd-Whale/blob/master/INSTALL.zh-cn.md

会及时维护

从ctfd/ctfd的repo里，使用docker-compose搭建，版本 3.1.1

按照安装步骤 (https://github.com/frankli0324/CTFd-Whale/blob/master/INSTALL.zh-cn.md) ，但进入插件设置页面后，只有这一条设置

在后端查看到报错

然后去看了下数据库

都是空表

新版CTFd(2.2.0)的base.html中延迟引入jQuery，需要在config.html中重新引入，或者放到新的文件中延迟引入

https://github.com/CTFd/CTFd/blob/354954bbe90cf583f05d272b9ce0437c1c9ad24f/CTFd/themes/core/templates/base.html#L193

我在使用时遇到了unicode编码错误，但是修改日志显示是frp_utils.py中的put方法传入了\u200b，我尝试使用quote但是没能成功解决。

在rootthebox看到作者的回复，感谢🙏，期待支持

1. 定时回收容器的机制, 即设定每道题的答题时间范围
2. 增加题目是否可以复用的属性, 若否, 则该题每次创建时, 为每个用户启用单独的容器实例
   2.1 针对非复用容器, 希望能控制容器实例个数, 当到达限制, 前端提示进入排队等候
3. 用户分离
   3.1 WEB可以通过hash的子域名+Nginx host绑定实现每个用户单独的域名访问
   3.2 针对nc连接类型的题目,能做tcp层的认证, 即有前置的服务器A, nc连接到A, 输入口令后, A会透明代理到口令对应的题目.(目前golang已实现)
   (3.3 下发vgrant 虚拟题目, 前端返回VPN接入口令)
4. 底层Paas四个组件模块:

上面,仅为我的想法,Thanks!

执行docker-compose up -d报如下错误，请问要如何解决？

ERROR: unsatisfiable constraints:
python (missing):
required by: world[python]
python-dev (missing):
required by: world[python-dev]
ERROR: Service ‘ctfd’ failed to build: The command ‘/bin/sh -c sed -i ‘s/dl-cdn.alpinelinux.org/mirror.tuna.tsinghua.edu.cn/g’ /etc/apk/repositories && apk update && apk add python python-dev linux-headers libffi-dev gcc make musl-dev py-pip mysql-client git openssl-dev’ returned a non-zero code: 2

在ubuntu18.04 64 server上按照https://www.zhaoj.in/read-6333.html中方式1的说明安装配置后，发现ctfd_ctfd_1不断重启，doker logs的输出如下：
Waiting for db: to be ready
db is ready
Traceback (most recent call last):
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 581, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.7/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/usr/local/lib/python3.7/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/usr/local/lib/python3.7/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.7/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/usr/local/lib/python3.7/site-packages/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.7/site-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/usr/local/lib/python3.7/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1060, "Duplicate column name 'captain_id'")

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

Traceback (most recent call last):
File "manage.py", line 9, in
app = create_app()
File "/opt/CTFd/CTFd/init.py", line 164, in create_app
upgrade()
File "/usr/local/lib/python3.7/site-packages/flask_migrate/init.py", line 95, in wrapped
f(*args, **kwargs)
File "/usr/local/lib/python3.7/site-packages/flask_migrate/init.py", line 280, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/usr/local/lib/python3.7/site-packages/alembic/command.py", line 298, in upgrade
script.run_env()
File "/usr/local/lib/python3.7/site-packages/alembic/script/base.py", line 489, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/local/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 98, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/lib/python3.7/site-packages/alembic/util/compat.py", line 184, in load_module_py
spec.loader.exec_module(module)
File "", line 728, in exec_module
File "", line 219, in _call_with_frames_removed
File "migrations/env.py", line 99, in
run_migrations_online()
File "migrations/env.py", line 91, in run_migrations_online
context.run_migrations()
File "", line 8, in run_migrations
File "/usr/local/lib/python3.7/site-packages/alembic/runtime/environment.py", line 846, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/local/lib/python3.7/site-packages/alembic/runtime/migration.py", line 520, in run_migrations
step.migration_fn(**kw)
File "/opt/CTFd/migrations/versions/b5551cd26764_add_captain_column_to_teams.py", line 27, in upgrade
op.add_column("teams", sa.Column("captain_id", sa.Integer(), nullable=True))
File "", line 8, in add_column
File "", line 3, in add_column
File "/usr/local/lib/python3.7/site-packages/alembic/operations/ops.py", line 1929, in add_column
return operations.invoke(op)
File "/usr/local/lib/python3.7/site-packages/alembic/operations/base.py", line 374, in invoke
return fn(self, operation)
File "/usr/local/lib/python3.7/site-packages/alembic/operations/toimpl.py", line 132, in add_column
operations.impl.add_column(table_name, column, schema=schema, **kw)
File "/usr/local/lib/python3.7/site-packages/alembic/ddl/impl.py", line 237, in add_column
self._exec(base.AddColumn(table_name, column, schema=schema))
File "/usr/local/lib/python3.7/site-packages/alembic/ddl/impl.py", line 140, in _exec
return conn.execute(construct, *multiparams, **params)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 982, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1044, in _execute_ddl
compiled,
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1250, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1476, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 581, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.7/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/usr/local/lib/python3.7/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/usr/local/lib/python3.7/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.7/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/usr/local/lib/python3.7/site-packages/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.7/site-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/usr/local/lib/python3.7/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1060, "Duplicate column name 'captain_id'")
[SQL: ALTER TABLE teams ADD COLUMN captain_id INTEGER]
(Background on this error at: http://sqlalche.me/e/2j85)

请问该如何解决？

首先感谢glzjin开源这么好的项目，我有关于frp疑惑请教下您。
requests.put("http://" + configs.get("frp_api_ip") + ":" + configs.get("frp_api_port") + "/api/config", output,
timeout=5)
requests.get("http://" + configs.get("frp_api_ip") + ":" + configs.get("frp_api_port") + "/api/reload", timeout=5)
我不清楚，这个frp的rest api接口，从哪里查看这个接口文档，谢谢。