Archery 之SQL审核系统部署

官网

https://github.com/hhyo/Archery

Docker方式部署

安装

https://github.com/hhyo/Archery/releases
tar xf Archery-1.11.1.tar.gz
yum install -y yum-utils device-mapper-persistent-data lvm2
yum install -y git###
cd /app/Archery-1.11.1/src/docker-compose
docker-compose -f docker-compose.yml up -d
docker ps

表结构初始化

cd /opt/archery
source /opt/venv4archery/bin/activate
python3 manage.py makemigrations sql
python3 manage.py migrate

数据初始化

python3 manage.py dbshell<sql/fixtures/auth_group.sql
python3 manage.py dbshell<src/init_sql/mysql_slow_query_review.sql

创建管理用户

python3 manage.py createsuperuser

重启并检查日志

docker restart archery##
docker logs archery -f --tail=10
logs/archery.log