OpenVPMS Installation (Windows)

Important Note- when installing OpenVPMS you should be logged in on an account that has administrator privileges!

Download OpenVPMS Installation Files

Download the latest OpenVPMS Installation files . The following assumes OpenVPMS 1.5.1 is being installed.
Create a folder to unzip the release in. The following assumes a folder named C:\OpenVPMS
Unzip the Installation Pack to the C:\OpenVPMS folder. This should create a C:\OpenVPMS\openvpms-release-1.5.1 folder with the necessary files to install OpenVPMS.
Create a folder called C:\OpenVPMS\Installation

Download Open Office from openoffice.org and save in C:\OpenVPMS\Installation folder.
Double Click on the installation file in C:\OpenVPMS\Installation folder.
Unpack to the default location (Desktop)
Select Complete Installation
Select File Types Open Office will be default application for. This is your choice !
Remove Installation Files from Desktop.
Start Open Office and set options as required.

In My Computer->Properties->Advanced->Environmental Variables double click on System Path variable and add path to OpenOffice program folder to end.
Click OK to save settings.

In order for other applications to be able to find the java installation we need to set an environmental variable on the system.

Using Windows explorer navigate the the location of the installed java installation.
Highlight the address bar and copy using Control-C
Right Click on My Computer and select Properties
Click on the Advanced tab and then click on Environmental Variable button
In the System variables section click New
In Variable Name type JAVA_HOME
In Variable value hit Control-V. This should enter the path name we copied before.
Click OK on all open Dialogues.

Download the Windows MySQL installation file from the MySQL site.
Select Windows Essentials (x86) and download into C:\OpenVPMS\Installation
Double click mysql-essential-5.0.45-win32.msi in c:\OpenVPMS\installation folder.
Select Typical Installation
Skip Sign Up
Select Configure MySQL Server Now
Select Developer Machine (Typically on server would select Server machine)
Select Multifunctional Database
Select Decision Support option (Larger installs would utilise manual connections settings. OpenVPMS application does connection pooling)
Select Enable TCP/IP Networking
Select Enable Strict Mode
Select Standard Character Set
Select Install as Windows Service
Select Include Bin Directory in Path
Enter the root password as openvpms twice
Select Enable root access from remote machine
De-select Anonymous User
Click Execute
Sometimes will fail on setting security and give option to Retry. Click Retry and should succeed.

Stop the MySQL database server. My Computer->Manage->Services->MySQL. Right Click and Stop.
Navigate to MySQL application folder C:\Program Files\MySQL\MySQL Server 5.0
Save copy of my.ini file
Double click on my.ini file at the bottom of the file add the lines
max_allowed_packet=16M
innodb_file_per_table
save the file
Restart the MySQL server

Download the MYSQL GUI Tools the MySQL site
Select the Windows X86 option and save into C:\OpenVPMS\Installation folder.
Double click on mysql-gui-tools-5.0-r12-win32.msi file in C:\OpenVPMS\Installation folder.
Accept License
Select default location
Select Complete install
Create shortcut to to MYSQL Administrator on desktop

Double Click MySQL Administrator icon
Click Elipses next to Stored Connections
Click New Connection Enter localhost, root, openvpms and localhost into fields.
Click Apply and then Close Select stored connection and enter root password (openvpms) and click OK.

Download Apache Tomcat and save in C:\OpenVPMS\Installation folder
Double click on apache-tomcat-5.5.28.exe file in C:\OpenVPMS\installation folder.
Select webapps in the available components
Select default location.
Set the admin password to openvpms
Select the default JRE location. (If you happen to have mutliple JRE locations select the one installed during the Java SDK installation - Must at least be a 1.5XXX version)
De-Select ReadMe and Run Apache Tomcat

-XX:PermSize=128m
-Xincgc

Set Initial Memory Pool and Maximum Memory Pool to same value dependent on number of users. Suggest 512M.
Clikc OK

Download IReport 3.0.0 from sourceforge and save to C:\OpenVPMS\Installation folder.
Double click on the iReport installation file in the C:\OpenPMS\Installation folder.
De-select sources
Select default location

Download MySQL connector from MySQL and save to C:\OpenVPMS\Installation folder
Copy the connector file mysql-connector-java-5.1.6-bin.jar found in the downloaded zip file to c:\OpenVPMS\openvpms-release-1.5.1\lib folder.
Copy the same connector to Tomcat shared library folder i.e C:\Program Files\Apache Software Foundation\Tomcat 5.5\shared\lib

Open a command prompt.
Navigate to C:\OpenVPMS\openvpms-release-1.5.1\db
Start the mysql command line client and enter the following commands
mysql -u root -p
mysql> source createdb.sql;
mysql> use openvpms;
mysql> source db.sql;
mysql> quit;
Navigate to C:\OpenVPMS\openvpms-release-1.5.1\bin
To load the database with data suitable for a site converting from an existing system next enter dataload base
To load the database with data suitable for a new site enter dataload setup

In My Computer -> Manage select Local Users and Computers -> Users
Right click in User Pane and select New User...
Enter user name and password as openvpms (you may use a different password for security but remember for later Apache Tomcat step)
De-select change password at next login.
Click Create.
Double click new user in list and add to Administrators group.
Logout and login as new openvpms user.
Run open office and check no startup prompts.
Logout and login as your local administrator.

Copy openvpms.war file from c:\OpenVPMS\openvpms-release-1.5.1\webapps to Tomcat Webapps folder at C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps

In My Computer ->Manage ->Services right click the Apache Tomcat service and select properties
On General tab select a Startup type of Automatic
On Logon tab enter openvpms and your openvpms user account password setup above.
Click on OK
Start the service by right clicking and selecting Start

Open up your Internet Browser and in the address enter http://localhost:8080/openvpms/app
Login to OpenVPMS using user 'admin' and password 'admin'