introduce

Ten years ago. Ten years ago. Ten years ago. Provide query audit, SQL audit and other functions, support Mysql, can to a certain extent to solve the operation and maintenance and development between that ring, rich features, open source code, easy installation and deployment!

Open source address

Gitee.com/cookieYe/Ye…

Function is introduced

1. SQL query query export query automatic query completion

2, SQL audit process chemical single SQL statement test SQL statement execute SQL rollback

3. Historical audit records

4. Query audit

5, push E-mail work single push nail webhook machine manual single push

6. Other LDAP login user permissions and management schema Fine-grained permission division (a total of 12 independent permissions, can be arbitrarily combined)

Module is introduced

Dashboard

The dashboard displays data on this day including number of users, number of data sources, number of jobs, number of queries and other charts. In the personal information bar a user can change his password, email address, or real name, and view the user’s permissions and application permissions

My work order

Displays the work order information submitted by the user. For failed or rejected work orders, click details to modify the SQL and submit them

For successful work orders, you can view the rollback statement and quickly submit the SQL

The repair order DLL

DDL related SQL submission audit, view table structure/index, SQL syntax highlighting/auto-complete

DML audit

DML related SQL is submitted for review with SQL syntax highlighting/auto-completion

The query

Query/Export data SQL Syntax Highlighting/auto complete Fast DML statement submission

The repair order review

DDL/DML administrator reviews and executes

Query the audit

User query audit

Permission to audit

User permission Audit

User management

Create, modify, or delete a user

Database management

Add/edit/delete data source

User permissions

Modify or clear user permissions

Basic Settings and advanced Settings

Setting the notification push information includes the nail robot /email, LDAP, global configuration, and global configuration switch

Review the rules

Example Set the SQL detection rule

Approval process

On this basis, a two-stage/multi-stage audit mode is adopted. The process can be changed based on actual demand. The role of the implementer can only be specified after the multi-stage audit is started (please go to the setting page if the multi-stage audit is started). Otherwise unexecuted work order will not be able to retrieve. If multi-level audit is disabled, the system does not automatically reset the role of the user whose role is executor. You need to reset the corresponding user role

Secondary audit process:

1. Users submit work orders to the corresponding work order submission unit (DDL,DML) according to their own permissions

2. After receiving the message, the administrator will review the work order request on the review work order page and execute/reject the corresponding work order

3. Execution records will be recorded under the administrator account

Multi-stage audit process:

1. Users submit work orders to the corresponding work order submission unit (DDL,DML) according to their own permissions.

2. After receiving the message, the administrator will review the work order request on the review work order page, agree/reject the corresponding work order and select the corresponding executor (the executor must be the user whose role is the executor).

3. Execute/reject the work order after receiving it

4. Execution records will be recorded under the executor user

Installation (this part can be directly connected to the code cloud or official website to view)

This does not rely on any third party SQL audit tool as an audit engine and implements its own audit/rollback logic. Rely only on the Mysql database. Ten years ago. The mysql version must be 5.7 or later. Install and create a library on this day with the UTF-8/UTF8mb4 character set. On 1080p resolution. Accessed on 1080p and above displays only.

Filling in the Configuration File

cat conf.toml
[Mysql]
Db = "Yearning"
Host = "127.0.0.1"
Port = "3306"
Password = "xxxx"
User = "root"

[General] Database encryption and decryption key can only be changed once.
SecretKey = "dbcjqheupqjsuwsm"
Copy the code

Initializing the database

./Yearning -m

Start the service

The default startup

Parameters of the start

Open the corresponding port of the browser. The default password is admin/Yearning_admin

conclusion

Ten years ago. Ten years ago. Ten years ago. Ten years ago. Ten years ago. Ten years ago. Ten years ago.