- Green versionView
- Green versionView
- Green versionView
- Green versionView
Yearning software features
SQL Query
Query work orders
Export
Auto-complete, smart prompts
Query statement audit
SQL Audit
Process chemical work order
SQL statement detection and execution
SQL rollback
Historical audit records
Customized review levels
Push
E-mail work order push
DingTalk webhook robot work order push
User permissions and management
User-based fine-grained permissions
Register
Others
todoList
LDAP Login
Dynamic audit rule configuration
AutoTask automatic execution
Yearning software features
longing for function
Desire to have multiple practical functions. Help DBA improve work automation and standardization.
Desire to have the following features:
Automated SQL statement review, which can automatically detect and execute SQL
Automatically generate rollback statements after DDL/DML statements are executed
审核/查询审核功能
Supports LDAP login/DingTalk and email message push
Support custom review workflow
Support fine-grained permission allocation
Grammar support
So far, it is compatible with 99% of Mysql standard SQL syntax. However, due to limitations of audit logic and other factors, correct feedback cannot be guaranteed for certain SQL statements.
Complex query statements (multiple tables, multiple functions, optional. Not all complex statements are not supported)
Foreign key related statements
Does not support rollback of cross-database DML statements
Stored Procedure/Twisted
It only represents the current syntax support progress, not the future completion level.
Yearning installation instructions
Things to note
Yearning does not rely on any third-party SQL audit tool as the audit engine, and has implemented its own audit/rollback related logic internally.
Only relies on the Mysql database.
The mysql version must be 5.7 and above (for 8.0 and above, please set sql_mode to empty) and have been installed in advance and created the Yearning library. The character set should be UTF8mb4 (mysql version required by Yearning only)
Yearning is developed based on 1080p resolution and only supports access to 1080p and above displays.
For the problem of overlapping configurations on the settings page, please confirm your resolution and whether you have zoomed in.
Please use the latest version of Chrome (excluding 360 and other modified versions)
Yearning Download
Yearning-go provides binary download package
Please select the latest version and select the Yearning-x.x.x.linux-amd64.zip package in Assets to download.
If you need to modify the code or compile it yourself, please go to the secondary development page
Yearning directory structure
Yearning (SQL audit platform)
1. Fill in the configuration file
Yearning (SQL audit platform)
About SecretKey
SecretKey is the salt for token/database password encryption/decryption.
It is recommended that all users change the SecretKey before installing Yearning for the first time (if not changed, there will be security risks)
Format: Both uppercase and lowercase letters are acceptable, the length must be 16 digits. If the length is not 16 digits, the new data source will not be created.
Special attention:
This key can only be changed during the initial installation! It cannot be changed again after that! If it is changed again, the previously stored data source password cannot be decrypted, and ultimately the relevant data source information cannot be obtained.
Help
Yearning (SQL audit platform)
2.Initialize data structure
./Yearning -m
Please be sure to perform the -m initialization operation before -s starts!
If you want to initialize again, please delete all tables under the yearning library first, otherwise repeated execution will be invalid.
3. Start the service
Start by default
./Yearning -s
Parameter start
./Yearning -s -b "172.27.80.35" -p "8000"
Open the browser http://172.27.80.35:8000
Default account/password: admin/Yearning_admin
Yearning update log
1.Fix several bugs;
2. Optimize detailed issues;
Huajun editor recommends:
Yearning software is a software with excellent performance, which is obvious to all. Huajun Software Park also hasSQL Server automatic installer,SQLyog,access tools,DBF Commander,DBeaverWaiting for related software that is definitely worth downloading and using, come and choose your favorite one!
Your comment needs to be reviewed before it can be displayed