Ace:Update Audit Manager

Updating previous versions of ACE.

1. Note the version you are running.

Login to your installation and note the current version you are running at the bottom of the web site.

2. Stop tomcat.

Run TOMCAT/bin/shutdown.sh or TOMCAT/bin/shutdown.bat

3. Remove old version.

Delete the ace war file(ace-am.war) and directory(ace-am) in TOMCAT/webapps. it may be named begin with an uppercase A as in Ace-am.

4. Install latest webapp.

Place the latest war file from http://narademo.umiacs.umd.edu/aceam/ in the webapps directory. If your previous version was named Ace-am rather than ace-am you will need to rename the war file appropriately.

5. Download database updates.

On the download page above, save all the appropriate updates.sql file. For example, if you are upgrading from 1.0 to 1.2.1, you will need to download 1.0-1.1.update.sql and 1.1-1.2.updates.sql.

6. Update database.

Connect to mysql and update the ace database. execute each sql script in order. For example, run 1.0-1.1.update.sql before 1.1-1.2.updates.sql, etc...

[root@loach ~]# mysql -Daceam 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 648
Server version: 5.0.45 Source distribution

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

mysql> source 1.0-1.1.update.sql;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> source 1.1-1.2.updates.sql;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> quit
Bye

7. Restart tomcat.

Run TOMCAT/bin/startup.sh(unix) or TOMCAT/bin/startup.bat (windows) and point your web browser at the audit manager. You should see the latest version listed at the bottom of the page.