Installing OpenVPMS 1.9.3 on a Windows 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 1.9.3 on a PC with a Windows 10 32-bit or 64-bit operating system. Originally written with images for Wibndows 7, there have been some changes in software appearance and links and images will be updated for Windows 10 if there's any significant difference Links accurate as of 14 April 2020..

When installing OpenVPMS you should be logged in on an account with Administrator privileges. Disabling UAC may also smooth the installation process. This may become important especially when trying to configure Tomcat.

Download OpenVPMS Installation And Other Required Files (updated)

Start Installation

1. Install Java7 (updated)

Execute jre-7u80-windows-xi586.exe (32-bit Java) and accept all defaults.
Check your Control Panel to ensure that you have only Java 7 installed. (Start | Control Panel | Programs | Program and Features). If Java 8 is installed delete it.

If a bubble pops up (as below) advising that a new Java is available, DO NOT accept installation.

2. Set Java 7 Environment Variable (updated)

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(4), then enter JAVA_HOME and c:\Program Files\Java\jre7 in the appropriate fields (5) 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 (updated)

 

Click Start | Control Panel | System And Security:

Click on Windows Defender 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 (updated)

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":

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







You now need to ensure all permissions are enabled.

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

5. Install MySQL GUI Tools (updated)

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.

 

6. MySQL Configuration (updated)

Click Start | MySql | right-click MySql Administrator | More | 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 (updated)

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 (updated)

At this point you would normally click Start, right-click on Configure Tomcat and select Run As Administrator:

But unfortunately you would be presented with this error message:

You need to take two additional steps:

1.  disable UAC.  Click Start | Control Panel | System and Security | Change User Account Control Settings and set UAC to "Never Notify:

2.  Browse to Tomcat 7.0\bin folder, right-click on Tomcat7w.exe 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 (updated)

Double-click on the "Apache_OpenOffice_4.1.7_Win_x86_install_en-GB.exe" file you have downloaded to commence installation; accept all default values as per the following images:

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

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

If Open Office cannot find a Java JRE it means you must have installed 64-bit Java7; as mentioned at beginning, install 32-bit Java as OpenOffice is a 32-bit program and doesn't use 64-bit Java:


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

Click OK to close options.

Close OpenOffice.

10. Configure OpenOffice Path (Updated)

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 ), click on Path (4), then click Edit (5);


Press New (6), then Browse (7) and select c:\Program Files (x86)\OpenOffice4\program (8) and press Ok (9):


Click  OK, then close the remaining window.

Test your OpenOffice path configuration.

Click Start | Windows System |  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. 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