Liquibase Enterprise was formerly known as Datical DB.

Silent Install of Liquibase Enterprise on Linux Systems

Use Case: Automation System

A silent install does not require any input from the user so it can be done by an automation agent such as Jenkins.   At a high-level, the steps for an automated install are:

  1. From a host that has access to the internet, download the Datical DB installer and Composite Repository, which contains installation files for the Datical DB clients and JDBC drivers.
  2. Move the DaticalDB installer and Composite Repository to the host where you want Datical DB to run. 
  3. Create an XML file to provide the installation input parameters.
  4. Install Datical DB. 
  5. Install the CLI drivers from the Composite Repository.
  6. Verify the installation.

Silent Install of Datical DB on a Linux System

1. Download the Installation Files

On a host that has internet access, download the following items from https://download.liquibase.com/:

  • Linux installer (.jar file) - Example: DaticalDB-linux.gtk.x86_64-5.12.5833
  • Composite repository - Example: DaticalDBCompositeRepo-5.12.5833.zip

Go to https://download.liquibase.com/ to download files. 

2. Verify the JDK Version on the Installation Host

Run the following "java -version" command in a terminal window to check that you are running a supported version of the JDK (version 1.11.x)

# java –version
java version "1.11.0_xx"
Java(TM) SE Runtime Environment (build 1.11.0_xxx)
Java HotSpot(TM) Client VM (build 24.75-b04, mixed mode, sharing)

3. Create the Datical User.

Datical should be installed as a non-root user.  Commonly this user is named "datical".

groupadd datical
useradd -d /opt/datical -g datical datical
passwd datical


4. Set Up Installation Directories 


mkdir datical
mkdir datical/installers
mkdir datical/license
mkdir datical/DaticalDB_x.y.z
ln -sf DaticalDB_x.y.z datical/DaticalDB


5.  Prepare the Installation Files

  1. Copy the Linux installer to the datical/installers directory
  2. Copy the Composite Repo to the datical/installers directory
  3. Copy your license file to the datical/license directory

  4. Copy the following XML file and place it in the datical/installers directory.
    The file should be named autoInstall.xml.
    Update the <installpath> and "license.path" for your installation.

XML file for version 7.x - name this file autoInstall.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<AutomatedInstallation langpack="eng">
<com.izforge.izpack.panels.HelloPanel id="UNKNOWN (com.izforge.izpack.panels.HelloPanel)"/>
<com.izforge.izpack.panels.LicencePanel id="UNKNOWN (com.izforge.izpack.panels.LicencePanel)"/>
<com.izforge.izpack.panels.TargetPanel id="UNKNOWN (com.izforge.izpack.panels.TargetPanel)">
<installpath>/opt/datical/DaticalDB_7.2</installpath>
</com.izforge.izpack.panels.TargetPanel>
<com.izforge.izpack.panels.PacksPanel id="UNKNOWN (com.izforge.izpack.panels.PacksPanel)">
<pack index="0" name="Liquibase Enterprise Desktop" selected="true"/>
<pack index="1" name="Liquibase Enterprise CLI" selected="true"/>
<pack index="2" name="Liquibase Enterprise license manager" selected="true"/>
<pack index="3" name="Java 11 Runtime" selected="true"/>
<pack index="4" name="Oracle Instant Client" selected="true"/>
</com.izforge.izpack.panels.PacksPanel>
<com.izforge.izpack.panels.UserInputPanel id="SelectLicenseFilePanel">
<userInput>
<entry key="license.path" value="/opt/datical/license/myLicense.lic"/>
</userInput>
</com.izforge.izpack.panels.UserInputPanel>
<com.izforge.izpack.panels.InstallPanel id="UNKNOWN (com.izforge.izpack.panels.InstallPanel)"/>
<com.izforge.izpack.panels.ShortcutPanel id="UNKNOWN (com.izforge.izpack.panels.ShortcutPanel)"/>
<com.izforge.izpack.panels.FinishPanel id="UNKNOWN (com.izforge.izpack.panels.FinishPanel)"/>
</AutomatedInstallation>

XML file for version 8.x - name this file autoInstall.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<AutomatedInstallation langpack="eng">
<com.izforge.izpack.panels.HelloPanel id="UNKNOWN (com.izforge.izpack.panels.HelloPanel)"/>
<com.izforge.izpack.panels.LicencePanel id="UNKNOWN (com.izforge.izpack.panels.LicencePanel)"/>
<com.izforge.izpack.panels.TargetPanel id="UNKNOWN (com.izforge.izpack.panels.TargetPanel)">
<installpath>C:\Users\Administrator\DaticalDB</installpath>
</com.izforge.izpack.panels.TargetPanel>
<com.izforge.izpack.panels.PacksPanel id="UNKNOWN (com.izforge.izpack.panels.PacksPanel)">
<pack index="0" name="Liquibase Enterprise Desktop" selected="true"/>
<pack index="1" name="Liquibase Enterprise CLI" selected="true"/>
<pack index="2" name="Liquibase Enterprise license manager" selected="true"/>
<pack index="3" name="Java 11 Runtime" selected="true"/>
<pack index="4" name="Oracle Instant Client" selected="true"/>
<pack index="5" name="Edbplus Client" selected="true"/>
</com.izforge.izpack.panels.PacksPanel>
<com.izforge.izpack.panels.UserInputPanel id="SelectLicenseFilePanel">
<userInput>
<entry key="license.path" value=""/>
</userInput>
</com.izforge.izpack.panels.UserInputPanel>
<com.izforge.izpack.panels.InstallPanel id="UNKNOWN (com.izforge.izpack.panels.InstallPanel)"/>
<com.izforge.izpack.panels.ShortcutPanel id="UNKNOWN (com.izforge.izpack.panels.ShortcutPanel)">
<programGroup name="Liquibase"/>
<shortcut KdeSubstUID="false" categories="" commandLine="" createForAll="false" description="This starts Datical DB" encoding="" group="false" icon="C:\Users\Administrator\DaticalDB\img\datical.ico" iconIndex="0" initialState="1" mimetype="" name="Datical DB" target="C:\Users\Administrator\DaticalDB\datical.exe" terminal="" terminalOptions="" tryexec="" type="2" url="" usertype="0" workingDirectory="C:\Users\Administrator\DaticalDB"/>
<shortcut KdeSubstUID="false" categories="" commandLine="" createForAll="false" description="This starts Datical DB" encoding="" group="true" icon="C:\Users\Administrator\DaticalDB\img\datical.ico" iconIndex="0" initialState="1" mimetype="" name="Datical DB" target="C:\Users\Administrator\DaticalDB\datical.exe" terminal="" terminalOptions="" tryexec="" type="1" url="" usertype="0" workingDirectory="C:\Users\Administrator\DaticalDB"/>
<shortcut KdeSubstUID="false" categories="" commandLine="-jar "C:\Users\Administrator\DaticalDB\Uninstaller\uninstall.jar"" createForAll="false" description="Datical DB Uninstaller" encoding="" group="true" icon="C:\Users\Administrator\DaticalDB\img\recycle.ico" iconIndex="0" initialState="0" mimetype="" name="Datical DB Uninstaller" target="C:\Program Files (x86)\Java\jre1.8.0_271\bin\javaw.exe" terminal="" terminalOptions="" tryexec="" type="1" url="" usertype="0" workingDirectory=""/>
</com.izforge.izpack.panels.ShortcutPanel>
<com.izforge.izpack.panels.FinishPanel id="UNKNOWN (com.izforge.izpack.panels.FinishPanel)"/>
</AutomatedInstallation>

6. Install DaticalDB 

Run the installer as the datical user.

cd /opt/datical/installers
java -jar <Datical Installer>.jar autoInstall.xml
cp /opt/datical/license/*.lic /opt/datical/DaticalDB/repl
export PATH=$PATH:/opt/datical/DaticalDB/repl
hammer installDrivers jar:file:/opt/datical/installers/DaticalDBCompositeRepo-x.y.z.zip\!/

7. Verify the Install 

Run the following commands to verify the install. 

hammer checkdrivers
hammer show version
hammer show license

8. Update the PATH Variable

Add Datical DB CLI to the path of the datical user.

vi ~/.bash_profile
export DATICAL_DB_HOME=/opt/datical/DaticalDB
export PATH=${PATH}:${ DATICAL_DB_HOME }/repl



Copyright © Liquibase 2012-2022 - Proprietary and Confidential