By default, the download link for SQL Audit log is disabled. To enable the download link, configure the Tomcat server properties files that are specific to the database installed in your environment. The properties files are located in the %AGILIANCE_HOME%\Tomcat\webapps\spc\WEB-INF\classes directory.
If your database is MySQL, follow the steps given below to enable the SQL Audit Log download link:
# if you want to turn the SQL Audit logs, use below the warper driver and comment the jdbc driver.
database.mysql.driver=com.p6spy.engine.spy.P6SpyDriver
#database.mysql.driver=com.mysql.jdbc.Driver
Go to the %AGILIANCE_HOME%\Tomcat\webapps\spc\WEB-INF\classesdirectory and open the .default.system.properties file using a text editor.
- Uncomment the following line:
Comment the following line:
- Restart the RiskVision Tomcat service to affect the latest changes.
If your database is Oracle, follow the steps given below to enable the SQL Audit Log download link:
Go to the
%AGILIANCE_HOME%\Tomcat\webapps\spc\WEB-INF\classes
directory and open the file.default.system.properties
using a text editor.Edit the following lines in the database connection information:
Comment the following lines:
#database.mysql.driver=com.p6spy.engine.spy.P6SpyDriver
#database.mysql.driver=com.mysql.jdbc.Driver
#database.oracle.driver=oracle.jdbc.driver.OracleDriver
Add the following line:
database.oracle.driver=com.p6spy.engine.spy.P6SpyDriver
- Save the file
.default.system.properties
. Go to the
%AGILIANCE_HOME%\Tomcat\webapps\spc\WEB-INF\classes
directory and open thespy.properties
files using a text editorEdit the database driver information by commenting and uncommenting the lines as shown below:
# oracle driver
realdriver=oracle.jdbc.OracleDriver
realdriver2=oracle.jdbc.driver.OracleDriver
#realdriver3=
# mysql Connector/J driver
#realdriver=com.mysql.jdbc.Driver
#realdriver2=
#realdriver3=
Save the file
spy.properties
.Restart the RiskVision Tomcat service to affect the latest changes.