Use Case: Automation System

Linux is the most common platform for use by automation systems. Typically hosts that are part of automated processes do not have access to the internet. 

1. From a host that has access to the internet, download the Datical DB composite repository, which contains installation files for the Datical DB clients and JDBC drivers.
2. Move the composite repository to the host where you want Datical DB to run. 
3. Run the installation from the command line. 
4. Test the installation using the CLI
5. Create scripts for the automation system that call Datical DB commands

Videos

See video 13 Installing Liquibase on Linux in How Liquibase Enterprise (fka DaticalDB) Works.

Installing Datical DB on a Linux System

Follow these steps to install Datical DB. 

1. Download Installation Files

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

...

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

2. Verify the JRE 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 JRE (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 named "datical". As a user with root or sudoers permissions, create the datical user:

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

4.  Set Up Installation Directories

Datical will be installed in the DaticalDB_x.y.z directory. If installing in the recommended location of /opt, this operation must be performed as a user with root or sudoers permissions:

...

sudo chown -R datical:datical ./datical

5.  Prepare the Installation Files

Open a new login session and login as the previously created datical user, or alternatively, switch to the datical user:

...

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

6.  Gather the information required by the installer

Target path of the installation. This is the full path to location of the DaticalDB_x.y.z directory that was created when setting up the installation directories. For example, /opt/datical/DaticalDB_8.1.7474

...

The full path to your Enterprise license file.

7. Run the Installer to Install the Datical DB Clients

Run the installer as the "datical" user.  You will be prompted for the required information.

java -jar <Datical Installer>.jar -console

8. Update the PATH Variable

1. Add Datical DB CLI to the path
   
   

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

   
   

2. Source the updated .bash_profile

   Code Block
   . ~/.bash_profile

   
   

9. Install the License File

Copy the license file to the DaticalDB/repl directory and install it.

cp /opt/datical/license/<license_filename> /opt/datical/DaticalDB/repl
hammer installLicense /opt/datical/license/<license_filename>

10. Install the Database Drivers for the CLI

At the command line, run the following command:

<datical_install_dir>/repl/hammer installDrivers jar:file:/<path_to_repo>/DaticalDBCompositeRepo-<version>.zip\!/

...

Also note the escaped exclamation point in the command for Linux:

\!/

11. Verify the Install

Run the following commands to verify the install.

hammer checkdrivers
hammer show version
hammer show license

...