OpenVPMS ${pom.version} Release ========================== 1. Installation Notes 1.1 Requirements - OpenVPMS requires the following to be installed: - Java 1.5.x or higher See http://java.sun.com/javase/downloads/index_jdk5.jsp - MySQL 5.0.24a or higher See http://www.mysql.org/downloads/mysql/5.0.html - MySQL Connector/J JDBC driver See http://dev.mysql.com/downloads/connector/j/5.1.html - Tomcat 5.5.12 or higher See http://tomcat.apache.org/download-55.cgi - OpenOffice 2.2.1 or higher See http://download.openoffice.org/ - MySQL: - should be on the same host as Tomcat - should accept connections on port 3306 - include the following lines in my.ini max_allowed_packet=16M innodb_file_per_table 1.2 Directory structure The OpenVPMS installation has a single top-level directory named openvpms-release-${pom.version} This will be referred to as in the remainder of this document. This directory has the following sub-directories: - bin contains a number of tool scripts used to load data into OpenVPMS - conf contains configuration files for the tools in bin/ - db contains MySQL SQL scripts to create the initial database - import contains data to import into OpenVPMS - lib contains jars used by the tools in bin/ - reports contains document templates for reporting - update contains data and scripts to migrate from earlier versions of OpenVPMS - webapps contains the OpenVPMS web applications 1.3 JDBC driver installation The MySQL Connector/J JDBC driver needs to be downloaded from: http://dev.mysql.com/downloads/connector/j/5.1.html It is typically named mysql-connector-java-5.1..zip or mysql-connector-java-5.1..tar.gz where represents the minor version number. The JDBC driver in the archive is named: mysql-connector-java-5.1.-bin.jar. This needs to be copied to: * the Apache Tomcat shared library directory: /shared/lib * the OpenVPMS library directory: /lib 1.4 Database setup To create the OpenVPMS MySQL database, run the following in a shell prompt > cd /db > mysql -u admin -p < createdb.sql > mysql -u admin -p openvpms < db.sql NOTE: replace 'admin' with a user that has administrator priviledges in MySQL Next, run the 'dataload' script. This provides two options, 'base' and 'setup'. The former loads a base database setup in preparation for data migration. The latter contains a default setup suitable for a new installation. E.g: > cd /bin > dataload setup 1.5. Web application installation To install the OpenVPMS web application, copy /webapps/openvpms.war to the /webapps directory. 2. Testing the installation To test the installation, open up your Internet Browser and enter the address: http://localhost:8080/openvpms/app Login to OpenVPMS using user admin and password admin