This topic assumes installation onto a clean Windows machine which contains none of the prerequisite components. If you are installing into an established environment, you may need to adjust or skip some steps below. We also assume that you have super-user/administrator access to the machine.

Installation Steps:

• Determine Supported Versions
• Create Folder Structure
• Install Java
• Install the Database Server
• Download the LabKey Distribution
• Deploy the LabKey Components
• Customize the application.properties File
• Configure the LabKey User and Service
• Start the Server

Determine Supported Versions

Before beginning, identify the versions of Java and your database that will be compatible with the version of LabKey you are installing. Learn more in this topic:

• Supported Technologies

Create Folder Structure

We recommend using the directory structure described here, which will make our documentation and any support needed much easier to follow. Create this folder hierarchy:

Install Java

Download the latest supported version of Java for your platform and store it in C:\labkey\src.

Unzip the downloaded distribution and deploy under your apps location:

C:\labkey\apps\java\jdk-##.#.#

Set the JAVA_HOME environmental variable and add it's bin subdirectory to the PATH.

• Open the editor for Environment Variables on your machine.
• Under System Variables, click New... and add a variable named "JAVA_HOME" with the full path to your JDK as the value. For example, "C:\labkey\apps\java\jdk-##.#.#"
• Click OK to confirm your changes.

• Select the System Variable named Path and click Edit...
• Add: %JAVA_HOME%\bin

• Click OK to confirm the stacked dialog boxes.

Install the Database (PostgreSQL)

This section explains how to install PostgreSQL for an installation of LabKey Server.

If you already have PostgreSQL installed, LabKey Server can use that installed instance, provided the version is supported.

To install PostgreSQL on Windows:

• Download and run the Windows PostgreSQL one click installer for the latest supported version. When the wizard prompts you to choose where to install PostgreSQL, point it to C:\labkey\apps\
• Keep track of the PostgreSQL Windows Service account name and password. LabKey Server needs to ask for it so that we can pass it along to PostgreSQL.
• Keep track of the database superuser name and password. You'll need these to initially create the LabKey database, the LabKey database user, and grant that user the owner role.
• We recommend that you install the graphical tool pgAdmin 4.x for easy database administration. Leave the default settings as they are on the "Installation Options" page to include pgAdmin.
• Create the database. Using superuser permissions, do the following:
• Create an empty database.
• Create a PostgreSQL user named 'labkey'.
• Grant the owner role to the labkey user over the database.
• Revoke public permissions from the database.

• Connect to the DB server as the Postgres Super User using the psql command:

sudo -u postgres psql

• Issue the following commands to create the user, database and revoke public permissions from the database. Use the example below, after substituting your chosen values for LABKEY_USERNAME and PASSWORD_HERE. Retain the single quotes around the password value.

create user labkey password 'PASSWORD_HERE' ;
create database labkey with owner labkey;
revoke all on database labkey from public;
\q

• The username and password you choose above will be used in the application.properties file.

Notes

• You may need to disable your antivirus or firewall software before installing PostgreSQL, as the PostgreSQL installer conflicts with some antivirus or firewall software programs. (see http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows for more information).
• On Windows you may need to remove references to Cygwin from your Windows system path before installing PostgreSQL (see http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows for more information).
• If you uninstall and reinstall PostgreSQL, you may need to manually delete the data directory in order to reinstall. By default the data directory on a Windows computer is C:\Program Files\PostgreSQL\x.y\data.

Download the LabKey Distribution

Download the binaries:

• Premium Edition users can download their custom distribution from the Server Builds section of their client support portal.
• Community Edition users can register and download the distribution here: Download LabKey Server Community Edition.

It will contain:

• The "labkeyServer.jar" file
• A VERSION text file that contains the version number of LabKey
• A bin directory that contains various DLL and EXE files
• A config directory, containing an application.properties template
• An example Windows service install script named "install_service.bat"
• An example systemd unit file for Linux (Not needed for installation on Windows)

Deploy the LabKey Components

Copy the following from the unpacked distribution into <LABKEY_HOME>.

• The labkeyServer.jar
• The config directory
• The bin directory

<LABKEY_HOME>\logs

Customize the application.properties File

In the <LABKEY_HOME>\config folder you just copied, you need to edit your application.properties file to provide settings and configurations including, but not limited to:

• Your database configuration and credentials
• The port and TLS/SSL settings (HTTP and HTTPS access information)
• Other details and customizations you may need

• Set Application Properties

Configure the LabKey User and Service

1. Confirm where your labkey-tmp directory is located. It might be <LABKEY_HOME>\labkey-tmp. If not, you'll need to edit the service file.

2. Create the 'labkey' user, making it a SYSTEM user.

• Confirm that this user has Full Control permissions under the Security tab of the properties for all files and folders under <LABKEY_HOME>.

• https://dlcdn.apache.org/commons/daemon/binaries/windows/commons-daemon-1.3.4-bin-windows.zip

• Note: Be sure to copy the correct file for your CPU. In the downloaded bundle, the 32-bit version is in the main directory and there is a 64-bit version in the AMD64 subfolder. If you use the incorrect one, the service will not install correctly. You will need to delete that partially-created service, and recreate it with the correct prunsrv version.

• Edit this new <LABKEY_HOME>\install_service.bat file to customize any paths or other settings that do not match the template.
• You must change the line for prunsrv to read:

  --Install "
  - Review details of other common edits required in this topic (it will open in a new tab):
  -- ">" href="./wiki-page.view?name=configTomcat">Service File Customizations
  - Save and close the file.
  
  6. To install your Windows Service, open a Command Prompt and navigate to the <LABKEY_HOME> directory. Both "install_service.bat" and "prunsrv.exe" are in this directory. Then run the following command:

code: null


Start LabKey Server
Go to the Windows Services console and start your service.  The server will start and begin generating logs under <LABKEY_HOME>\logs.
You can now access the running server, and as the first user, you are invited to create the initial user profile, as a Site Administrator.
Related Topics

Set Application Properties
Install LabKey