Requirements

OpenVPMS can be installed on either a unix system (most commonly a Ubuntu* server), or a Windows system.  For Windows, for small practices you can install on a desktop or laptop running Windows 7, 8 or 10; for larger practices it may be better to use a Windows Server operating system.

*NOTE: OpenVPMS requires MySQL 5.5, which is included in Ubuntu 14.04. Later releases include MySQL 5.6 or MySQL 5.7 which are only supported via configuration changes.

32 or 64 bit version? Both Java and MySQL are available in 32 and 64 bit versions. For larger systems (where you will want to run MySQL and Tomcat with large memory allocations) you should use the 64 bit versions. Otherwise the 32 bit versions are adequate.

Server Software

• Java Platform, Standard Edition 8
  The Java Runtime Environment (JRE) is the minimum requirement. That is, neither the SDK or Server JRE packages are needed.
  See http://www.oracle.com/technetwork/java/javase/downloads/index.html

• Tomcat 7.x
  See http://tomcat.apache.org/download-70.cgi
  On Windows, select the 32-bit/64-bit Windows Service Installer
   
• MySQL 5.5.x
  Do not use 5.6 or later.
  See http://dev.mysql.com/downloads/mysql/5.5.html#downloads

  Download the MySQL Community Server 'Generally Available (GA) Release'.

  On Windows, the MySQL installer may require that the Microsoft .Net Framework 4 be installed. This is available from:
  http://www.microsoft.com/en-au/download/details.aspx?id=17851

  NOTE: if you are upgrading from MySQL 5.1, see the MySQL 5.5 Reference Manual - Updating MySQL for instructions on migrating the existing MySQL 5.1 data to 5.5.

  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
     
• MySQL Connector/J JDBC driver
  See http://dev.mysql.com/downloads/connector/j/5.1.html

    This may be included in the MySQL server installation.

• OpenOffice 4.0.x or higher
  See http://www.openoffice.org/download/

  NOTE: several users have indicated that LibreOffice 5 is not 100% compatible with OpenOffice. Fields may not merge correctly, and documents created in LibreOffice may look different when printed via OpenVPMS.
   

• Locale and Fonts
  For unix systems see Unix Locale and Fonts
  For windows systems see Windows Locale and Fonts

Workstation Software

If you wish to use the External Edit facility then the following software is required on all workstations that will edit documents in OpenVPMS:

• Java Platform, Standard Edition 8
  The Java Runtime Environment (JRE) is the minimum requirement. That is, neither the SDK or Server JRE packages are needed.
  See http://www.oracle.com/technetwork/java/javase/downloads/index.html

  NOTE: later versions of the Java Platform deprecate or remove Java Web Start which is required to launch External Edit.
   

• OpenOffice 4.1.2 or higher

See http://www.openoffice.org/download/

Optional Software

• Jaspersoft Studio 6.2.0 or higher
  This is only required to customise document templates.
  See https://community.jaspersoft.com/project/jaspersoft-studio/releases

   

• MySQL Workbench
  This is not required by OpenVPMS itself, but if you are going to do any report development, then you will find that the Workbench’s ability to build and test SQL queries is very useful. You can download it from http://dev.mysql.com/downloads/workbench.