In this article:

Repository Connection Settings

Advanced Settings

Environment Variables

BI Server Files and Folders

Starting Service Applications

Configuration and Setup

This article describes various settings to be determined after installation of BI server on Linux OS.

Repository Connection Settings

BI server in Linux supports connection to repositories created on Oracle, PostgreSQL and SQLite DBMS.

Repository connection settings can be stored in the registry.reg and/or Metabases.xml file. The registry.reg file can be obtained by exporting a Windows registry key, which stores information about repositories. To get the file, execute the following operations:

  1. Export registry key at the workstation with installed Windows OS.

  1. Copy registry.reg file to Linux home directory and edit if required. After this, if the file was obtained from the registry key [HKEY_LOCAL_MACHINE], copy it to the folder /opt/ Foresight /fp9.2-biserver/bin. If the file was obtained from the key [HKEY_CURRENT_USER], copy it to the folder /root/.config/Foresight/Foresight Analytics Platform/registry/.

It is assumed that the bin folder with the platform contains the registry key [HKEY_LOCAL_MACHINE], and the root folder /root/.config/Foresight/Foresight Analytics Platform/registry contains the registry key [HKEY_CURRENT_USER]. It automatically stores saved repositories from the HKEY_CURRENT_USER key on using the PP.Util utility to save confidential credentials for database connection. The BI server must have access to registry.reg files.

Registry export result is saved in the UTF-16 encoding, but BI server in Linux can work with a file in the UTF-16 and UTF-8 encoding. The file can be converted into UTF-8 encoding to facilitate editing in Linux, and the "vi" editor can work with the file in the UTF-16 encoding.

The Metabases.xml file must be located in the folder with the platform /opt/Foresight/fp9.2-biserver/bin, BI server must have access to the file. Metabases.xml can be easier edited in Linux, but this file have limitations because it cannot save credentials for connecting to repository database, for example, guest user credentials.

To apply changed settings for repository connection or new repositories, restart BI server.

Advanced Settings

Advanced settings are stored in the registry.reg or settings.xml file. The settings.xml file must be located in the directory /root/.config/Foresight/Foresight Analytics Platform (the directory may differ if the HOME environment variable is changed).

The file enables the user to determine such settings as the number of BI server connections to DBMS server, and so on.

Environment Variables

Environment variables that are read on startup of BI server with Apache2 instance are located in the file /etc/opt/Foresight/fp9.2-biserver/envvars.

Variables are added to the file in the format:

export VARIABLE_NAME=VALUE

The following variables can be added:

Environment variables Description
export PP_LOG=1 To output debug info about BI server performance to the file /var/log/apache2-fp9.2/error.log, add the variable to the end of the file (or uncomment the existing string).
export DISPLAY=:987 To change number of the display, on which graphics is rendered, edit the string (by default, output is set up via xvfb).
export LSHOST=lserver1~lserver2 The LSHOST variable is used to specify network name or IP address of license network servers, servers are enumerated via the "~" character.
export LSFORCEHOST=NO-NET To specify the use of local stand-alone license, set the LSFORCEHOST variable.
export HOME=/root To change the path, relative to which configuration files and a license file are searched, specify the HOME variable (be default, it matches home directory of the user, under whom the Apache2 parent process is started, that is, /root).
export USER=root To change the user, under whom data, that is saved in the registry on DBMS authorization, is deciphered, the USER variable is used (it must match the user, under whom the Apache2 parent process is started, by default, it is root).
export TNS_ADMIN=/etc/opt/foresight/9.2 On using Oracle DBMS based repositories, set the TNS_ADMIN variable and specify the path to the folder with the tnsnames.ora file (the Apache2 child process must have access to the file).

NOTE. When working in Red Hat Enterprise Linux OS or CentOS OS and when using systemd as initialization system, the export command is not necessary to be written for correct setup. In this case, the following string are added to the file: DISPLAY=:987.

BI Server Files and Folders

Various BI server files will be located in the following folders:

Folder or file Description
/opt/Foresight/fp9.2-biserver/bin Main files of BI server.
/opt/Foresight/fp9.2-biserver/logs/axis2.log Communication history of BI server.
/etc/opt/Foresight/fp9.2-biserver Additional configuration files of BI server instance, such as the envvars file to determine environment variables of Apache HTTP Server.
/etc/opt/Foresight/httpd-fp9.2 (Astra Linux)
/etc/apache2-fp9.2 (Debian and Ubuntu)
/etc/httpd-fp9.2 (RHEL)
Configuration files of the Apache HTTP Server instance.
/var/opt/Foresight/httpd/logs/error-fp9.2.log (Astra Linux)
/var/log/apache2-fp9.2/error.log (Debian and Ubuntu)
/var/log/httpd/error-fp9.2.log (RHEL)
Errors and debagging messages of Apache HTTP Server instance.
/var/opt/Foresight/httpd/access-fp9.2.log (Astra Linux)
/var/log/apache2-fp9.2/access.log (Debian and Ubuntu)
/var/log/httpd/access-fp9.2.log (RHEL)
Access history of Apache HTTP Server instance.
/root/.config/Foresight/Foresight Analytics Platform Common configuration files of BI server (the path may differ on changing the HOME environment variable).
/etc/init.d/Foresight-httpd-fp9.2 (Astra Linux)
/etc/init.d/apache2-fp9.2 (Debian and Ubuntu)
/etc/init.d/httpd-fp9.2 (RHEL)
init-script of Apache HTTP Server instance startup.
/etc/init.d/Foresight-xvfb init-script of virtual display (X virtual framebuffer, by default it is started on the display No. 987 dpi 96).
/opt/Foresight/fp9.2-biserver/bin/in/fonts
/usr/share/fonts
/usr/local/share/fonts
The fonts that can be used by BI server in work.

Starting Service Applications

After installing BI server, some applications can also be available, which are included into the software package:

PP_LOG=1 DISPLAY=:987 ./axis2_http_server

DISPLAY=:987 ./UpdateManager

PP_NODISPLAY=1 ./PP.Util

DISPLAY=:987 ./Scheduler

See also:

Installing BI Server on Linux OS | System Registry Settings | Settings.xml | Metabases.xml | Advanced Settings