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/:

• 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 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 mkdir ./datical
sudo mkdir ./datical/installers
sudo mkdir ./datical/license
sudo mkdir ./datical/DaticalDB_x.y.z
cd ./datical
sudo ln -sf ./DaticalDB_x.y.z ./DaticalDB

Make sure that the "datical" user owns the datical directory and subdirectories.

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:

sudo su - datical

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 packs you wish to install. While some packs are required, optional client packs can be installed at a later time.

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
   
   

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

2. Source the updated .bash_profile

   . ~/.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\!/

You need to replace "<version>" with your actual Datical DB version number in the command above, and replace "<path to repo> with the actual path to your zip file.

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