This topic is provided to help administrators and developers migrate specific features from older releases.
The ETL module has been removed from the Community Edition and the functionality has migrated to the dataintegration
module, available with all Premium Editions. Premium clients will not experience any change in functionality or interruption in service.
The announcement made on the Developer Forum about this change can be found here
with premium clients who have enlisted in the version control project
and will be using ETLs in 18.3 and beyond will need to take the following steps in order to continue to use the premium 'dataintegration' module from Git.
- To obtain access, you will need to provide your LabKey Account Manager with the username of your GitHub account if you have not already done so.
- Migrate your enlistment to 20.11 following the instructions here. If you need to stay on a release of LabKey Server prior to 20.11, switch to use the instructions in the documentation archives instead.
- Clone the dataintegration module into your modules directory.
- Execute these two commands in this order to ensure that you clear out the old copy and are solely building and running the module from Git:
Create Chart View
Windows Installer Decommission
The LabKey Server Windows-only Graphical Installer will be decommissioned as part of the 18.3 release in November 2018. Moving forward, virtual machine images will be provided with each release as an alternate method for evaluating LabKey Server on-premise. We encourage new users looking to evaluate LabKey Server to take advantage of the cloud-hosted trial version of LabKey Server.
Upgrading Servers Installed with the Graphical Installer
If you used the Windows graphical installer in the past and want to update your LabKey Server, complete these steps:
- Backup your database to be safe and notify any users that the server will be down for a period of time. Place the database backup in the C:\labkey\backup\ location suggested and save the pg_dumpall output in the Notepad for use below.
- Create the recommended folder structure for your future LabKey installations.
- Set the environment variable CATALINA_HOME to the location of your tomcat installation. Following our recommended folder structure, this would be the following (substituting your actual version numbers for the # symbols):
CATALINA_HOME = C:\labkey\apps\apache\apache-tomcat-#.#.##
- Backup the files in your previous installation: Open the C:\Program Files (x86)\LabKey Server directory. Right click on the files folder and select Send To > Compressed (zipped) folder to create a zip file. Move this zip file to C:\labkey\backup\.
- Delete the uninstaller, uninst.exe, that was bundled with the windows installer. You can find it under the C:\Program Files (x86)\LabKey Server directory.
- Confirm that you are running the recommended versions of Java, Tomcat, and Postgres. If you are upgrading any component, you should also delete the LabKey tomcat service LabKeyTomcat7 using the registry editor (regedit).
You should now be able to follow the procedures to upgrade your LabKey installation as if it was originally installed manually, using this topic:
If you encounter any difficulties, the following details may be helpful.
Restoring PostgreSQl User and Backup
During the migration process, you can avoid making manual changes to the labkey.xml file and restore the database backup by completing these steps to configure the new installation after you have upgraded LabKey.
- After installing the new PostgreSQL version, locate the pgAdmin4.# utility and run it.
- Locate your server within pgAdmin. It will likely prompt you for the postgres user. Enter the password you found in the labkey.xml file.
- Double click on the "postgres" database to open it.
- Now right click on the postgres database and select the option for the Query tool.
- Copy the SQL that you saved when you did the pg_dumpall during backup, specifically the "Roles" section. It will look something like this:
CREATE ROLE databaseusername;
ALTER ROLE databaseusername WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'long-md5-32-character-password-hash';
- Paste these CREATE ROLE and ALTER ROLE lines from your notepad into the Query tool and click on the lightning bolt button to run the SQL. This will recreate the database user from your previous labkey.xml file with the same password so you don't need to edit the file again.
- Right click on 'databases' and select the option to create a new database. Name it "labkey". Make sure to assign the new user you just created as the owner of this new database.
- After the database is created, right-click on it again and select the option to restore the database. Select your backup file from C:\labkey\backup\labkey_migration_backup.bak and restore it.
Install LabKey and Restore Files Backup
- Follow the installation steps, making sure you install to the <LABKEY_HOME> directory (i.e. C:\labkey\labkey)
- Copy the listed JAR files from the tomcat-lib directory in the unzipped distribution to <CATALINA_HOME>\lib (Note: <CATALINA_HOME> is the location of your Tomcat installation.)
- Create the new directory C:\labkey\labkey\files
- Start the new Tomcat service and confirm that your new instance of LabKey is accessible.
- Once you've started the server, point the file root at the new location in order to automatically move the files to the new location.
- Select (Admin) > Site > Admin Console.
- Click Settings.
- Under Configuration, click Files.
- Change the Site-Level File Root to C:\labkey\labkey\files.
- Click Save and the files will be moved for you.