Awesome

中文文档

SQLE DB2 Plugin

This is A DB2 SQL audit for SQLE, which is an SQL audit platform.

1. Add Rule

You can define a rule in coresponding file, and then add it to the plugin by AddRule() method. More details please refer to docs.

2. Build Binary

Docker compile

execute make docker_install

The binary file is located in bin/ folder, and you can use it to audit your database.

3. Prepare the plugin runtime environment

1. Download the driver on the machine deployed by SQLE

   curl -L https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/linuxx64_odbc_cli.tar.gz -o /opt/sqle/linuxx64_odbc_cli.tar.gz
   

2. Unzip the driver

   tar zxvf /opt/sqle/linuxx64_odbc_cli.tar.gz -C /opt/sqle/
   

3. Add environment variables for sqled

   systemctl set-environment "LD_LIBRARY_PATH=/opt/sqle/clidriver/lib"
   

4. Restart sqled

   systemctl restart sqled
   

4. Begin to use

More details please refer to docs.