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
• [[%ATTACHURL%/ace-am.war][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.

<verbatim> 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 </verbatim>

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.

<verbatim>

 <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" />

</verbatim>

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 [[AceV3Usage][User Documentation]] for more details.