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
• 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 icon in the details box. Your collection will now scan all files and register tokens. Please see the User Documentation for more details.