In order to run ACToR locally you will need the following: 1. Apache Tomcat 6.0 http://tomcat.apache.org/ 2. Java 1.6 http://java.sun.com/ 3. MySQL Server http://dev.mysql.com/downloads/ 4. MySQL Connector/J http://dev.mysql.com/downloads/connector/j/5.1.html 5. ACToR Data http://actor.epa.gov/actor/faces/Download.jsp 6. ACToR Interface http://actor.epa.gov/actor/faces/Download.jsp 7. ToxRefDB Data http://actor.epa.gov/actor/faces/Download.jsp 8. ToxRefDB Interface http://actor.epa.gov/actor/faces/Download.jsp 9. ToxCastDB Data http://actor.epa.gov/actor/faces/Download.jsp *****Install Java 1.6 If Java 1.6 is not installed on your system then follow the instructions at http://java.sun.com/ to down load and install Java 1.6. *****Install Apache Tomcat 6.0 Follow the instructions at http://tomcat.apache.org/ to down load and install Tomcat version 6.0. *****Install MySQL If not already install, then follow the instructions at http://dev.mysql.com/downloads/ to install MySQL 5.0 or better. *****Install MySQL Connector/J Down load MySQL Connector/J from http://dev.mysql.com/downloads/connector/j/5.1.html and install the mysql-connector-java-???-bin.jar into the lib/ext directory of your Java 1.6 installation home. *****Create ACToR & ToxRefDB accounts in MySQL As root in MySQL create ACToR account using the following example mysql> grant all on actor_2010q4a.* to 'my_actor_user'@'localhost' identified by 'my_actor_pass'; mysql> grant all on toxrefdb_2010q1b.* to 'my_actor_user'@'localhost' identified by 'my_actor_pass'; mysql> grant all on toxminer_v17.* to 'my_actor_user'@'localhost' identified by 'my_actor_pass'; *****Create ACToR & ToxRefDB Databases login into MySQL with newly created user and password. mysql -u my_actor_user -pmy_actor_pass create database. mysql> create database actor_2010q4a; mysql> create database toxrefdb_2010q1b; mysql> create database toxminer_v17; *****Download ACToR From http://actor.epa.gov/ download the following: actor_2010q4a.sql.gz toxrefdb_2010q1b.sql.gz toxminer_v17.sql.gz actor.war toxrefdb.war *****Decompress the data gunzip actor_2010q4a.sql.gz gunzip toxrefdb_2010q1b.sql.gz gunzip toxminer_v17.sql.gz *****Load the data mysql -u my_actor_user actor_2010q4a -pmy_actor_pass < actor_2010q4a.sql mysql -u my_actor_user toxrefdb_2010q1b -pmy_actor_pass < toxrefdb_2010q1b.sql mysql -u my_actor_user toxminer_v17 -pmy_actor_pass < toxminer_v17.sql *****Install ACToR & ToxRefDB Interfaces place the war files,actor.war and toxrefdb.war, in the webapps/ directory of your Tomcat installation. Starting the Tomcat server will cause the actor.war to be expanded. It will result in the creation of a webapps/actor directory. Edit the webapps/actor/WEB-INF/classes/jdbc.properties and webapps/toxrefdb/WEB-INF/classes/jdbc.properties files as follows: every occurrence of "my_actor_user" should be replaced with the user name you used when creating your database every occurrence of "my_actor_pass" should be replaced with the user password you used when creating your database every occurrence of "134.67.216.49" should be replaced with the IP address of your database server Your jdbc.properties files should be similar to the following: jdbc.toxrefdb.url=jdbc:mysql://134.67.216.49/toxrefdb_2010q1b jdbc.toxrefdb.username=my_actor_user jdbc.toxrefdb.password=my_actor_pass jdbc.toxrefdb.initialSize=2 jdbc.toxrefdb.maxActive=30 jdbc.toxrefdb.validationQuery=select * from tbl_study_general_info limit 1 jdbc.toxrefdb.testOnBorrow=false jdbc.toxrefdb.testWhileIdle=true jdbc.toxrefdb.timeBetweenEvictionRunsMillis=120000 jdbc.toxrefdb.numTestsPerEvictionRun=5 jdbc.actor.url=jdbc:mysql://134.67.216.49/actor_2010q4a jdbc.actor.username=my_actor_user jdbc.actor.password=my_actor_pass jdbc.actor.initialSize=2 jdbc.actor.maxActive=30 jdbc.actor.validationQuery=select data_collection_id from data_collection limit 1 jdbc.actor.testOnBorrow=false jdbc.actor.testWhileIdle=true jdbc.actor.timeBetweenEvictionRunsMillis=120000 jdbc.actor.numTestsPerEvictionRun=5 jdbc.toxminer.url=jdbc:mysql://134.67.216.49/toxminer_v17 jdbc.toxminer.username=my_actor_user jdbc.toxminer.password=my_actor_pass jdbc.toxminer.initialSize=2 jdbc.toxminer.maxActive=10 jdbc.toxminer.validationQuery=select * from data_collection limit 1 jdbc.toxminer.testOnBorrow=false jdbc.toxminer.testWhileIdle=true jdbc.toxminer.timeBetweenEvictionRunsMillis=120000 jdbc.toxminer.numTestsPerEvictionRun=5 After restarting the Tomcat server, ACToR should be accessible via http://localhost:8080/actor depending on the port specified in Tomcat/conf/server.xml