Archery SQL audit query platform v1.11.3

Archery is positioned as a SQL audit query platform, aiming to improve DBA work efficiency. It supports SQL online and query for multiple databases, and supports rich MySQL operation and maintenance functions. All functions are compatible with mobile phone operations.

start up

Download the Releases file, unzip it and enter the docker-compose folder

#start up

docker-compose -f docker-compose.yml up -d

#Table structure initialization

docker exec -ti archery /bin/bash

cd /opt/archery

source /opt/venv4archery/bin/activate

python3 manage.py makemigrations sql

python3 manage.py migrate

#Data initialization

python3 manage.py dbshellpython3 manage.py dbshell

#Create administrative user

python3 manage.py createsuperuser

#Restart service

docker restart archery

#Log viewing and troubleshooting

docker logs archery -f --tail=10

logs/archery.log

access

http://127.0.0.1:9123/

Archery SQL audit query platform update log

v1.8.5

Solve the problem of action build failure

Handle clickhouse special data type serialization issues

Fixed the problem of error reporting when using plugins when password contains special characters

Update docker settings

Fixed the problem that logged-in users cannot configure 2FA

Fixed the problem that when obtaining oracle rollback sql, there is a probability that an exception will be thrown when the sql function format verification is combined.

Fixed the problem of 2FA authentication error after turning on LDAP

Added forced global 2FA switch

Fixed the issue where Oracle's SQL was online and a single rollback SQL exceeding 4000 in length was forcibly truncated into multiple pieces.

v1.8.3

New

Support ClickHouse online and query

Support ODPS query

Added independent audit module

Added my2sql tool plug-in module

Added data dictionary support for mssql and oracle

MySQL account management supports recycling permissions (REVOKE)

redis supports cluster mode

optimization

SQL work order notification supports staged control

Add permissions for data query and download

Classify and report errors returned by ajax requests

Archery Kubernetes Helm Chart Maintenance

Oracle backs up the original definition when executing DDL

oracle view table structure adds comment column

oracle desensitization replacement function

Sort the instance list (supports Chinese character sorting)

Add the timeout parameter when redis/pg creates a connection

redis query results json formatted display

SSH tunnel connection adds a new option to upload a local file key. After uploading, the key information is saved to the database and read from the database during connection.

When SQL goes online, front-end optimization of the time range can be performed, and the required time interval must be greater than 60 minutes.

repair

Fixed instance detection returning connection status error bug fix

Fixed the issue where the mongodb table name with - and . symbols could not be applied for online

Fix the problem of WARNING when calling shell to execute mongodb command

Fix plug-in shell command injection vulnerability

Fix the problem that Redis hgetall results are not displayed

Fixed the issue where notifications were not sent for manually executed work orders

Fix abbreviated SQL garbled problem

Fix the SQL injection risk in session management

Fix error when creating mongodb native connection

Fix the problem that pgsql obtains table structure without adding schame filtering

Fix the problem of incorrect SQL path in admin.sh