Ace:Audit Manager Installation Guide

The ACE Audit manager is a web portal to monitor the integrity of any collection you specify. The manager will register any new files found in addition to checking the integrity of files in a collection during an audit.

Requirements

Before you begin, you will need to have the following software installed:

• Java 1.6 or later http://java.sun.com
• Tomcat 6.0 or later http://tomcat.apache.org
• MySQL 4.0 or later http://www.mysql.org
• MySQL connector 5.0.7 or better http://www.mysql.com/products/connector/j/

Files

The following files are needed to install the Audit Manager

• [[%ATTACHURL%/ace.sql][ace.sql]]: sql tables
• ace-am.war: ace webapp
• [[%ATTACHURL%/ace-am.xml][ace-am.xml]]: ace configuration file

Quick Setup

1. Create Database

Create a new database called 'aceam', grant permissions and setup table structure.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database aceam;
Query OK, 1 row affected (0.01 sec)

mysql> grant all on aceam.* to 'aceam'@'localhost' identified by 'YOUR_PASSWORD';
Query OK, 0 rows affected (0.00 sec)

mysql> use aceam;
Database changed
mysql> source ace.sql;
ERROR 1146 (42S02): Table 'aceam.ACTIVITY_LOG_ENTRY' doesn't exist
ERROR 1146 (42S02): Table 'aceam.ACTIVITY_LOG_ENTRY' doesn't exist
...
...
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> exit
Bye

The ace.sql listed is the file from above. Set YOUR_PASSWORD to a password to use for this database.

2. Install Webapp

Install tomcat on your server and verify it's working. Shutdown the server and place a copy of the ace-am.war file in your TOMCAT/webapps directory. Place a copy of the configuration file ace-am.xml in your TOMCAT/conf/Catalina/localhost directory. Open up the configuration file and edit the following setting.

  <Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" 
  maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/aceamdb" 
  testOnBorrow="true" type="javax.sql.DataSource" 
  url="jdbc:mysql://localhost/aceam" username="aceam" validationQuery="SELECT 1"
  password="YOUR_PASSWORD" />

Change the password from YOUR_PASSWORD to whatever you used above.

Place a copy of the mysql-connector-java-5.0.XX-bin.jar in your TOMCAT/lib directory.

3. Register your first collection

When the monitor starts up, you will see a status screen with no collections.

• Click Add Collection from the status screen.
• Enter a descriptive name, and the directory you want to monitor. Choose the type of storage where this directory is located. Click Configure Storage when finished.
• If you selected something other than local for your storage, a box will appear with additional setting you need to fill out
• Click Save when finished.

4. Audit your collection

Click the Status link at the top of the page. Click on the name of the collection and then click the <img src="%ATTACHURLPATH%/file-audit-start.jpg" alt="start.jpg" width="15" height="13" /> icon in the details box. Your collection will now scan all files and register tokens. Please see the User Documentation for more details.