Enabling the SQL Audit Log Link

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

  1. Go to the %AGILIANCE_HOME%\Tomcat\webapps\spc\WEB-INF\classesdirectory and open the .default.system.properties file using a text editor.

  2. Uncomment the following line:
  3. Comment the following line:

  4. 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:

  1. Go to the %AGILIANCE_HOME%\Tomcat\webapps\spc\WEB-INF\classesdirectory and open the file.default.system.properties using a text editor.

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

  3. Save the file.default.system.properties.
  4. Go to the %AGILIANCE_HOME%\Tomcat\webapps\spc\WEB-INF\classesdirectory and open the spy.properties files using a text editor

    • Edit 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=

  5. Save the filespy.properties.

  6. Restart the RiskVision Tomcat service to affect the latest changes.