Quick Installation

Required Software

• Java 7+
• JDBC Accessible Database (MySQL is used in the example below)
• Web Servlet Container (Tomcat 8 is used in the example below, though Tomcat 7 should also work)

Chart Review Downloads

Download all artifacts from github

• chart-review.xml (the Chart Review tomcat database context)
• chart-review-demo-omop.sql (the initial Chart Review database)
• chart-review-omop-data-2016.01.25.Final.sql (OMOP example data)
• chart-review-2016.01.25.Final.war (the Chart Review war file)

Installation

1. Install Java, Mysql, and Tomcat.
2. Create the user and database in Mysql that will house Chart Review.

   mysql -uroot -p
       CREATE DATABASE chartreview;
       CREATE USER 'chartreview'@'localhost' IDENTIFIED BY 'passw0rd';
       GRANT ALL PRIVILEGES ON chartreview.* TO 'chartreview'@'localhost' with grant option;
       flush privileges;

3. Create the OMOP example data database in Mysql that will house example OMOP data.

   mysql -uroot -p
       CREATE DATABASE omop;
       GRANT ALL PRIVILEGES ON omop.* TO 'chartreview'@'localhost';
       flush privileges;

4. Before starting up Tomcat, copy the chart-review context file (chart-review.xml) to the tomcat/conf/Catalina/localhost/ directory. Note: You may need to create this directory.
5. Edit the chart-review.xml and set the appropriate connection parameters:

   <Context>
           <Resource name="jdbc/chartReviewDS" auth="Container" 
                        type="javax.sql.DataSource" 
                        username="chartreview" 
                        password="passw0rd" 
                        driverClassName="com.mysql.jdbc.Driver" 
                        url="jdbc:mysql://localhost:3306/chartreview" maxActive="15" maxIdle="3"/>
   </Context>

6. Import the initial Chart Review database: mysql -uroot -p chartreview < chart-review-demo-omop.sql
7. Import the OMOP example data database: mysql -uroot -p omop < chart-review-omop-data-2016.01.25.Final.sql
8. Copy the downloaded war to TOMCAT_HOME/webapps, and rename it chart-review.war
9. Start Tomcat
10. Browse to http://localhost:8080/chart-review/
11. Example users are username: admin password:admin and username: u1 password:u1.

More Detailed Instructions & User Guide

For detailed installation instructions, see the installation guide. The user guide is available in the Help link of the Chart Review application, or as a downloadable pdf.