Online Installation

This documentation is about how to install SISENSE on a Linux system with Internet connection.
The Sisense release Zetaly is using is L2024-02.
Main informations from this article come from official Sisense web site: https://docs.sisense.com/l2024_2/SisenseLinux/linux-minimum-requirements.htm

Current Limitations

The SISENSE BI Tool deployment is certified to run on the following Linux operating systems:

Ubuntu
- 18.04 LTS
- 20.04 LTS
- 22.04 LTS
RHEL
- 8.6, 8.8, 8.10, 9.2, 9.4
Amazon Linux
- 2023

Supports only x86-64/AMD64 architecture. The ARM64 or s390x (IBM) architectures are currently not supported. You can verify the architecture in place (e.g., Architecture: x86-64) by running the hostnamectl command in Linux.

The Linux operating system versions specified above are also based on the minor release number, and must be taken into account to ensure compatibility.

The Linux operating system must be an official release, and one that has not been customized (i.e. where it was modified to harden the kernel).

Requirements

The package must be uploaded directly on the host machine, which must have the following elements:

RAM : 32 GB minimum
CPU : 8 Core
SSD disks
300 GB minimum on /var
50 GB minimum on /var/log/sisense
500 GB minimum on/opt/sisense mounted on a dedicated disk (Sisense requires SSDs. Required space for ElastiCube files + Plugins + Builds + Backup archives. Sisense recommends a second disk size of at least the size of all ElastiCubes x 2)
Bash shell for .sh scripts execution
Mandatory packages : see related section below

Mandatory packages

These tools must be installed on the server.

python 3
python3-pip
nc
sshpass
jq
libselinux-python3
dbus (for Ubuntu only)

Network configuration

The server hosting the SISENSE BI Tool must be connected to the Internet and must have network access to the following packages repository list :

Packages repository list to be whitelisted :

apt.dockerproject.org
archive.ubuntu.com
auth.cloud.sisense.com
bitbucket.org
bugs.launchpad.net
dl.fedoraproject.org
docs.docker.com
docs.helm.sh
download.docker.com
github.com
gcr.io
grafana.com
help.ubuntu.com
index.docker.io
kubernetes.io
l.sisense.com
mirror.centos.org
ppa.launchpad.net
pypi.python.org
quay.io
registry-1.docker.io
storage.googleapis.com
www.ubuntu.com
yum.dockerproject.org

DNS Configuration

The DNS must be configured in your network. This is needed :

to resolve the Docker registry
for SISENSE component interconnections to function properly (i.e. the DNS server must be accessible from the Kubernetes nodes where SISENSE is deployed)

Whitelisted Resources

The following whitelisted resources must be added :

cdn.redhat.com (for details, see https://access.redhat.com/articles/1525183)
pypi.org to install Python modules

Configuration of the user "sisense"

An user sisense must be created on the system.

The user named sisense must also match the following:

Must be in the sudo (or wheel for RHEL based distributions)
Must be in the docker group
User and Group ID must be equal to 1000
In /etc/sudoersyou must add the following line at the end of the file : sisense ALL=(ALL) NOPASSWD: ALL
Must be able to connect via ssh from the computer to the host machine without a password (i.e. ssh key configured):
- The ssh files must be in /home/sisense/.ssh
- Passphrase must be empty
Must have read / write permissions on the /opt/sisense directory and the ownership
For an HTTPS installation, the key and the certificate must :
- Be stored in a folder /home/sisense/ssl
- The certificate must be called bi.crt
- The key must be called bi.key
- The folder must be owned by the sisense user

Installation

Configuration file

In the provided package, a file called single_config.yaml allows to configure the installation of the SISENSE BI Tool.

Some properties can be updated to customize the installation. The file can be edited thanks to an editor like nano or vi.

Properties that you can updated :

ssh_key
gateway_port

ssh_key : by default, this value is “/home/sisense/.ssh/id_rsa". You can edit this value to indicate the path of private SSH key of the user sisense.

gateway_port : by default, this value is 30845. This is the port used when the BI Tool runs in HTTP. See the following property to have more details.

Installation steps

All the following commands have to be launched with the sisense user

bash biinstall.sh {INTERNAL_IP_ADDRESS} {EXTERNAL_IP_ADDRESS} {IS_SSL} {OPTIONAL_SSL_KEY_PATH} {OPTIONAL_SSL_CERTIFICATE_PATH}

With :

INTERNAL_IP_ADDRESS : the private IP address of the machine hosting the BI Tool
EXTERNAL_IP_ADDRESS : the public IP address (internet facing) of the machine hosting the SISENSE BI Tool
IS_SSL : type 0 if the BI tool runs in HTTP mode, or 1 if it runs on HTTPS mode .
- If IS_SSL = 1, you must provide two additional parameters, the SSL key path and the SSL certificate path
- If IS_SSL = 0, you can keep the two fields empty

All the values must be put into double-quotes except 0 or 1.

Do not use sudo to run the command !

For example for a HTTP installation :
bash biinstall.sh "172.31.24.120" "34.45.203.111" 0

And for an HTTPS installation :
bash biinstall.sh "172.31.24.120" "34.45.203.111" 1 "/domain.key" "/domain.crt"

After the installation is complete, a green message appears indicating that the BI tool is listening on your port 443 if the BI Tool runs in HTTPS mode, or on the port gateway_port if the BI tool runs in HTTP only mode .

Access the web page at the address BI.Host.Scheme://{BI.Host.Base}:{BI.Host.Port}, where {BI.Host.Base} and {BI.Host.Port} are the values of :

BI.Host.Scheme = https or http depending of your running mode of the BI tool
BI.Host.Base = YOUR_INTERNAL_IP_ADDRESS or YOUR_EXTERNAL_IP_ADDRESS depending of your network configurations
BI.Host.Port = 443 or gateway_port depending of your running mode of the BI tool, HTTPS or HTTP

Connect with your admin account then wait for the initialization to end.
Complete the configuration file (by default, “zetalyinstall.cnf”) with the correct information (see below for more information).
Run the following command:

bash post-biinstall.sh {PATH_TO_CNF}

Possible configuration

All the possible configuration are not in the "zetalyinstall.cnf" file by default.

Key	Example or possible values	Description
BI.Host.Base	IP (10.44.85.42) or FQDN (zetaly.domain.io)	BI host
BI.Host.Port	Example: 4456	BI port
BI.UserName	Example: sisense@mycompany.com	Sisense sysadmin username
BI.Password	Example: My_Pas$word	Sisense sysadmin password
Database.Host.Base	IP (10.44.85.42) or FQDN (zetaly.domain.io)	Zetaly database host
Database.Host.Port	Example: 4456	Zetaly database port
Database.UserName	Example: zetaly_user	Zetaly database username
Database.Password	Example: my_P@ssword	Zetaly database password for the previous username
Database.Name	Example: zetalydb	Zetalydatabase name
Database.Type	postgresql/mssql	Database type
Elasticubes.ImportAction	skip/overwrite/duplicate	Elasticube importation behavior.
		Skip: If the cube already exists, skip it Overwrite: If the cube already exits, replace the existing one (If the cube already exists, replace the existing cube (all existing data will be lost). Duplicate: Import the cube but without replacing the existing one