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

  • SQL query Query export Query automatic query completion
  • SQL audit process Chemical Single SQL statement detection SQL statement execution SQL rollback
  • Historical audit record
  • Query the audit
  • Push E-mail work single push nail webhook machine manual single push
  • Other LDAP login user permissions and management schema Fine-grained permission division (12 independent permissions, optional combination)

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 reviews the work order request and executes/rejects 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 reviews the work order request on the work order review page, agrees/rejects the corresponding work order and selects the corresponding executor (the executor must be the user whose role is the executor).
  • 3. Execute/reject 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

    Ten years ago. Cat conf. Toml [Mysql] Db = “reminiscent” Host = “127.0.0.1” Port = “3306” Password = “XXXX” User = “root” [General] Database encryption and decryption key can only be changed once. SecretKey = “dbcjqheupqjsuwsm”

  • 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.