Installing OpenVPMS on a Windows 7 Computer

Warning Much of this guide is outdated. Installers should generally follow the installation guides for each of the required software packages they intend to use. OpenVPMS does not recommend the use of out of date software packages or operating systems that do not receive security updates.


CONTENTS

Introduction

This tutorial describes a step-by-step installation of OpenVPMS on a PC with a Windows 7 32-bit or 64-bit operating system.

When installing OpenVPMS you should be logged in on an account with Administrator privileges. Disabling UAC may also smooth the installation process.

 

Download OpenVPMS Installation And Other Required Files

  • Download the latest openVPMS Installation files.
    Unzip the Installation Pack onto your C: drive into an openVPMS folder. This should create a C:\openvpms\openvpms-release-1.n folder with the necessary files to install OpenVPMS (the "n" refers to the version number you are installing).
    Create a folder called C:\openVPMS\Installation.
    Create a folder called C:\openVPMS\data.
     
  • Download Open Office from openoffice.org and save in C:\OpenVPMS\Installation folder.
    Click on image to view full-size
    (Click image to view full-size)
     
  • Download the latest Java (x86 for 32-bit, x64 for 64-bit depending on your operating system) from the Oracle site and save into C:\OpenVPMS\Installation.
    Click on image to view full-size
    (Click image to view full-size)
     
  • Download the Windows MySQL installation file from the MySQL site.
    Select Windows Essentials (x86) and download into C:\OpenVPMS\Installation
    Click on image to view full-size
    (Click image to view full-size)
     
  • Download the MYSQL GUI Tools from the MySQL site.
    Select the Windows X86 option and save into C:\OpenVPMS\Installation folder. This version has the MySQL Administrator which simplifies Backups and Restores. Newer versions have changed the interface markedly.
    Click on image to view full-size
    (Click image to view full-size)
     
  • Download the MYSQL Java Connector from the MySQL site.
    Select the Windows X86 option and save into C:\OpenVPMS\Installation folder.
    Click on image to view full-size
    (Click image to view full-size)
     
  • Download Apache Tomcat from the Apache Software Foundation site.
    Select the Core | 32/64-bit Windows Service Installer option and save into C:\OpenVPMS\Installation folder. This links you to version 6: some users have found "challenges" with higher versions of Tomcat. Tomcat v6 will work fine.
    Click on image to view full-size
    (Click image to view full-size)
     
  • Download iReport from the Sourcforge.net site and save it to your installation folder.
    Click on image to view full-size
    (Click image to view full-size)
     

Start Installation

1. Install Java

Execute jdk-7-windows-xxxi586.exe (where xxx is i586 or x64) and accept all defaults.
 

 

2. Set Java Environment Variable

Right-Click on Computer icon on desktop, then click "Properties".

 

Click on Advanced System Settings (1), Advanced (2) and then Environment Variables (3):

Under System Variables (lower box - upper box is for User Variables), click on New, then enter JAVA_HOME and c:\Program Files\Java\jre7 in the appropriate fields and press OK

The end result should look like this:

Click OK, OK, then close the remaining window.

 

3. Open Port 3306 in your Windows Firewall

Click Start | Control Panel | System And Security:

Click on Windows Firewall:

Click on Advanced Settings, then follow images as below:








You've confirmed the new rule, so close the window (click on red x).

If you're going to access OpenVPMS from other computers on a network within the clinic, you'll also need to allow port 8080.
Repeat the steps above, this time typing in 8080 as the TCP Port to allow and name it Openvpms.
 

4. Install MySQL

Double-click on the "mysql-essential-5.1.nn-win32.msi" file you have downloaded and follow the images below:


Be patient: at this point, it may take some time for the progress bar to start moving (on one of my PCs, over three minutes), so just leave the PC to do its work: the following screens should be self-explanatory: press Next when prompted to do so:





At this screen, click on the ellipsis (...) and browse to the folder c:\openVPMS\data\ you created at the start:

You may need to browse up the folder tree to C:\, then select "openVPMS" and finally "data":

If you haven't created the data folder, click on the New folder icon and rename "new folder" to "data":

Your screen should then look like this: if it does, click Next to continue:







5. Install MySQL GUI Tools

Double-click on the "mysql-gui-tools-5.0-r17-win32.msi" file you have downloaded to commence installation.
Click "Next" all the way through to complete default installation.

 

You now need to ensure all permissions are enabled (welcome to Windows7!).

  • Click on "Computer" icon, browse to C:\Program Files\MySQL;
  • right-click on MySQL Server 5.1 (1);
  • select Properties and then click on Security (2) tab;
  • select Users (3);
  • then click Edit (4), click Users (5) and click to enable Full Control (6);
  • and press OK.

 

 

6. MySQL Configuration

Open MySQL Administrator from the shortcut on the desktop: right-click and Run As Administrator.
Click on the button with the ellipsis (...) arrowed in image below:

Click on New Connection:

Change New Connection to localhost then fill in the fields (root, openvpms, localhost) as per image below and click Apply | Close:

You should now be back at the opening screen: select localhost from the drop-down box and click OK

On the left-hand pane, click Startup Variables (1), then click on the InnoDB Parameters (2) tab.
Scroll down to, and check One File Per Table (3).

Click on Advanced Networking tab (4), enable Max. packet size and set to 16 M (5), then click Apply Changes and close the window (7)..

 

7. Apache Installation

Double-click on the "apache-tomcat-6.0.nn.exe" file you have downloaded to commence installation; click Next;

Click Next;

Fill in User Name as admin and password as openvpms click Next;

Installer should find your Java installation without any intervention by you; if you have more than one, pick highest build number, then click Next

Accept default installation folder and click Install;


 

8. Configure Apache Tomcat

Click Start, right-click on Configure Tomcat and select Run As Administrator:

Click on Java tab. In Java Options, scroll down to the bottom and add the following two lines:

-XX:PermSize=128m
-Xincgc

Set Initial Memory Pool and Maximum Memory Pool to the same value, depending on the number of users; say 512.
Changes required are highlighted in yellow in image below:

Click OK and close.

9. OpenOffice Installation

Double-click on the "OOo_3.3.0_Win_x86_install-wJRE_en-GB.exe" file you have downloaded to commence installation; accept all default values;

Once installed, start OpenOffice and from the main menu select Tools | Options:

Click on Java in left column, check Use Java runtime environment and ensure most recent Java is selected;

Click on On-line Update and un-check Check for updates automatically;

Click on Internet | Browser Plug-in and check Display documents in browser;

Click OK to close options.
Start Writer from Menu. Click Tools | Options, click Internet | Browser Plug-in and check Display documents in browser, then click OK:

Close OpenOffice.

10. Configure OpenOffice Path

Right-Click on Computer icon on desktop, then click "Properties".


Click on Advanced System Settings (1), Advanced (2) and then Environment Variables (3):

Under System Variables (lower box - upper box is for User Variables), click on Path, then click Edit;

Press End, then add ;c:\Program Files\OpenOffice.Org 3\program to the path (do include the leading semi-colon):

Click OK, OK, then close the remaining window.

Test your OpenOffice path configuration.
Click Start | All Programs | Accessories | Command Prompt:

 

Type in swriter and press Enter. OpenOffice/Writer should start. Two reasons for doing this:

  1. If it does start, you've set the path correctly.
  2. OpenVPMS starts OpenOffice in the background; if OpenOffice is waiting for questions on registration and checking for updates to be answered, letter merging etc. won't work.
    Reopening OO makes sure it is not asking for you to participate in surveys etc.


If all's well, close OpenOffice.

11. Install iReport

Right-Click on iReport-3.7.6-windows-installer to commence installation:



Accept all defaults:


UN-Check Run iReport 3.7.6 and click Finish:

12. MySQL Database Driver Setup

Open the downloaded mysql-connector-java-5.1.16.zip:
Extract connector file mysql-connector-java-5.1.6-bin.jar to Tomcat shared library folder i.e C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib (note that this is a different folder than Tomcat 5.5):

Extract the same connector to c:\OpenVPMS\openvpms-release-1.n\lib folder:

13. OpenVPMS Database Setup

Click on Computer, navigate to C:\OpenVPMS\openvpms-release-1.n\db, press Shift+Right-Click anywhere on the open area and click on Open command window:

Type mysql -u root -p and press Enter. Enter password (openvpms).
Type source createdb.sql; (including the semi-colon) and press Enter.
Type use openvpms; (including the semi-colon) and press Enter.

Type source db.sql; (including the semi-colon) and press Enter. You'll see lots of message scroll off the screen.
Type quit; (including the semi-colon) and press Enter.

Type cd .. to move up a folder.
Type cd .\bin to move to bin folder.
Type dataload setup to load the database.

You'll see lots of screen messages. Close window when complete.

 

14. OpenVPMS Service User Setup

Copy the openvpms.war file from c:\openvpms\openvpms-release-1.n\webapps
to Tomcat Webapps folder at C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps.
 

15. OpenVPMS Application Install

Click Start | Control Panel | User Accounts and Family Safety:

Click the Add or remove user accounts link:

Click on Create a new account:

Name the new account openvpms, select Administrator and click on Create Account:

Once the account is created, click on Create a password. Type in openvpms twice, then click Create password (you may use a different password for security but remember for later Apache Tomcat step):

Close window when complete. Log off, then Log in as new openvpms user.
Start OpenOffice and check that configuration is the same as in Step #10 above: ie uncheck On-line Updates, check Browser plug-in.
Log off and log in as your regular local administrator.

16. Apache Tomcat Service Setup

On the desktop, right-click on Computer icon and select Manage.

In Services and Applications, click on Services, right-click on Apache Tomcat 6 and select Properties. Click on General tab and change Startup type to Automatic.

Click on Log On tab, click on This account and insert openvpms as account name and openvpms as password (twice). Click OK to close.

Click on Apache Tomcat 6, then click on Restart the service.

17. OpenVPMS Application Test/Run

Open up your internet browser this address: http://localhost:8080/openvpms/app

Login to OpenVPMS using user 'admin' and password 'admin'

18. OpenVPMS Application From Other PCs on Network

First, you need to establish the IPv4 address of your server (the PC that your OpenVPMS installation resides on):
Open a Command Prompt (Start | Accessories | Command Prompt) and type ipconfig and press Enter.
Look for the line IPv4 address: in the screenshot below, it's 192.168.1.101:

To start OpenVPMS on another PC on the network, you will need to type in http://IPv4_address:8080/openvpms; in example below, http://192.168.1.101:8080/openvpms:

Click here to move on to setting up OpenVPMS for use.

This resource is an openVPMS enduser-created tutorial. Constructive criticism and corrections welcome.


Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Username and password as suggested (ie admin) are not working at stage 17.
That should be loaded by: dataload setup from step 13. -Tim
Note that in OpenVPMS 1.5 and higher, there is no need to configure iReport to be compatible with JasperReports 1.3.2 in step 11. -Tim
Step 11 now modified to remove need to configure iReport.
Link fails to open at http://localhost:8080/openvpms/app
Syndicate content