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

Open Office and JDK 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.

Open Office Path Configuration

  • 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.

JDK Configuration

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.

MySQL Installation

  • 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.

MySQL Configuration

  • 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

MySQL GUI Tools Installation

  • 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

MySQL Administrator Configuration

  • 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.

Apache Tomcat Installation

  • 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

Apache Tomcat Configuration

  • Run Configure Tomcat from Apache Tomcat program menu.
  • On Java tab in Java Options section add

-XX:PermSize=128m
-Xincgc

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

IReport Installation

  • 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

MySQL Database Driver Setup

  • 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

OpenVPMS Database Setup

  • 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

OpenVPMS Service User 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.

OpenVPMS Application Install

  • 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

Apache Tomcat Service setup

  • 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

OpenVPMS Test

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Hello, I'm try to install the latest version of OpenVPMS 1.7.1  on Windows Server 2008 but with this install instructions : OpenVPMS Installation (Windows) I can't Start the Services of Apache Tomcat and after trying start Services it give me this Error : Windows could not start the Apache Tomcat on Loal Computer .... error Code 0
Syndicate content