Online installation

Prev Next

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 .

  1. 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

  1. Connect with your admin account then wait for the initialization to end.

  2. Complete the configuration file (by default, “zetalyinstall.cnf”) with the correct information (see below for more information).

  3. 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