Personal tools

Ace:Audit Manager Installation Guide

From Adapt

Revision as of 15:30, 10 September 2008 by Toaster (talk | contribs)
Jump to: navigation, search

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:

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