How To: Liquibase Enterprise Headless Linux Installation

Headless installation is different from console mode by the fact it does not require any input from the user so it can be done by soe automation agent like Jenkins or ElectricFlow. However it requires an XML file passed as a parameter to the installer instead of the "-console" option) .


The autoInstall-Linux.xml file used for the Ubuntu example and a version tailored for Windows are attached.


Overview:
1.  Verify / Install prerequisites
	> Java Runtime 8.x (only required for initial installation)
	> Oracle Client - Database Utilities (impdp & expdp) (required to run deploymentPackager unless you are using DATAPUMP API, not required for installation)
	> zip, unzip
2.	Create datical group & datical user (optional)
	> Alternatively, install software using existing jenkins user
3.  Download Datical Files (into tmp directory) & Setup Directories
	> Installer: DaticalDB-linux.gtk.x86_64-x.y.z.jar
	> Composite Repo: DaticalDBCompositeRepo-x.y.z.zip
	> License File: filename-admin.lic
	> Directory Structure: datical_install_files.zip
4.  Install Datical
	> Run installer
	> Create symbolic link to versioned install directory (optional)
	> Copy license to install directory & repl directory (optional)
	> Modify logging-config.ini (optional)
	> Modify repl/logging-config.ini (optional)
	> Modify datical.ini (optional)
	> Modify hammer-bin.ini (optional)
	> Unzip reporttemplates.zip to $workspace/.reporttemplates
	> Install Drivers
5.  Verify install
6.  Zip datical for distribution
7.  Unzip /opt on other servers for replication.
8.	Install DaticalDB Jenkins plugin (see Datical DB - Integrating Other Tools Systems.pdf, pg 11-13)
	
Create datical user & group?
Create sym link?
export $PATH (optional) in .bash_profile?
export DATICAL_DB_HOME in .bash_profile?
run ./~.bash_profile

Questions:
* How does the datical/jdbc_drivers directory get recognized?  (See Full Access doc pg. 15)
* Which user / group on linux should install DaticalDB?

RedHat / CentOS

CENTOS 7, Minimum Install:
Commands (RedHat Enterprise / CentOS7):
1.  [root@localhost ~]# yum install zip unzip
	[root@localhost ~]# yum install java-1.8.0-openjdk.x86_64

2.	Create datical group & datical user
	[root@localhost ~]# groupadd datical
	[root@localhost ~]# useradd -d /opt/datical -g datical datical
	[root@localhost ~]# passwd datical

3.  Download Datical Files
	[root@localhost ~]# su datical
	[datical@localhost root]$ cd ~
	[datical@localhost ~]$ mkdir tmp
	[datical@localhost ~]$ cd tmp
	[datical@localhost tmp]$ ftp SJC-FTP.thruinc.net
	   Name:  software.datical.com\user@email.com
	   Password:  password
		ftp> cd COMMON/Datical_DB_Software/Datical_DB_4.18.3999
		ftp> binary
		ftp> get DaticalDB-linux.gtk.x86_64-4.18.3999.jar
		ftp> get DaticalDBCompositeRepo-4.18.3999.zip
		ftp> quit
	[datical@localhost tmp]$ unzip datical_install_files.zip -d ~/
	[datical@localhost tmp]$ mv DaticalDB-linux.gtk.x86_64-4.18.3999.jar ~/installers/daticaldb_4.18.3999/
	[datical@localhost tmp]$ mv filename-admin.lic ~/license/
	[datical@localhost tmp]$ mv DaticalDBCompositeRepo-4.18.3999.zip ~/installers/daticaldb_4.18.3999/

4.	Install Datical	
	[datical@localhost tmp]$ cd ~/app/daticaldb_4.18.3999/
	[datical@localhost daticaldb_4.18.3999]$ java -jar ~/installers/daticaldb_4.18.3999/DaticalDB-linux.gtk.x86_64-4.18.3999.jar -console
		> Select target path [/opt/datical/app/daticaldb_4.18.3999]
		> Do not install license in this step
	[datical@localhost daticaldb_4.18.3999]$ cp ~/license/filename-admin.lic .
	[datical@localhost daticaldb_4.18.3999]$ cp ~/license/filename-admin.lic repl/
	[datical@localhost daticaldb_4.18.3999]$ sed -i -- 's/@user.home\/datical/\/opt\/datical\/workspace/g' datical.ini
	[datical@localhost daticaldb_4.18.3999]$ sed -i -- 's/@user.home\/datical/\/opt\/datical\/workspace/g' repl/hammer-bin.ini
	[datical@localhost daticaldb_4.18.3999]$ cd ~/app
	[datical@localhost app]$ ln -s daticaldb_4.18.3999/ daticaldb
	[datical@localhost app]$ cd ~/workspace
	[datical@localhost workspace]$ unzip ~/tmp/.reporttemplates.zip -d .
	[datical@localhost workspace]$ cd ~/app/daticaldb_4.18.3999/repl
	[datical@localhost repl]$ ./hammer installDrivers jar:file:/opt/datical/installers/daticaldb_4.18.3999/DaticalDBCompositeRepo-4.18.3999.zip\!/

5.  Verify Install
	[datical@localhost daticaldb]$ cd ~/app/daticaldb/repl
	[datical@localhost repl]$ ./hammer checkdrivers
	[datical@localhost repl]$ ./hammer show version
	[datical@localhost repl]$ ./hammer show license
	
6.	Zip for Distribution
	[datical@localhost datical]$ rm -rf installers
	[datical@localhost datical]$ rm -rf tmp
	[datical@localhost datical]$ rm -rf license
	[datical@localhost datical]$ mkdir /tmp/datical
	[datical@localhost datical]$ cd /opt
	[datical@localhost opt]$ zip -r /tmp/datical/datical.zip datical

Ubuntu

Tested on Ubuntu 17.04 with attached autoInstall.xml  (Ubuntu was supported with 4.x and 5.x versions of Datical, but not with 6.x or 7.x versions of Datical.)


sudo apt-get install -y default-jre
sudo apt install -y unzip
sudo apt install -y xterm
sudo apt-get install build-essential


4. Install Datical

sudo mkdir /opt/DaticalDB_4.18.3999
sudo chmod 777 /opt/DaticalDB_4.18.3999
sudo ln -sf /opt/DaticalDB_4.18.3999/ /opt/DaticalDB
java -jar DaticalDB-linux.gtk.x86_64-4.18.3999.jar autoInstall.xml
cp *-admin.lic /opt/DaticalDB
cp *-admin.lic /opt/DaticalDB/repl
export PATH=$PATH:/opt/DaticalDB/repl
hammer installDrivers http://update.datical.com/latest/thirdparty

5.  Verify Install

hammer checkdrivers
hammer show version
hammer show license

Copyright © Datical 2012-2020 - Proprietary and Confidential