The page contains an example of installing, setting up and deleting BI server on Debian OS and Ubuntu OS. The supported versions of Linux are given in the Supported Versions of Linux OS article.
NOTE. BI server functionality is limited by the set of available operations and their implementation.
In this article:
Execute preparatory actions before BI server installation:
Make sure that the operating system is set up and hardware and software requirements are met for correct installation and full-functional work of the Prognoz Platform 9 web application.
Set up DBMS back end.
Using the Prognoz Platform desktop application on Windows OS, create a metadata repository, security subsystem service user and set up repository connection. Before setting up it is recommended to study the Installing Prognoz Platform 9 Desktop Application section.
Install DBMS front end.
Working with Prognoz Platform 9 BI server requires installation of third-party packages that can be downloaded from the internet or from DVD repository or from built-in DEB packages. If internet connection is provided via proxy server, determine settings required for connection.
Before installation of any packages, update package information in repository. To do this, execute the command:
sudo apt-get update
If the work is executed in Astra Linux OS, go to the section below about Apache HTTP Server with the coworker module installation. When working with other distribution kits, this setting is not required.
On installing BI server DEB package on Astra Linux OS, first, install the Apache HTTP Server (httpd) build with the MPM coworker module and provide access to the repository (OS installation disk is suitable) containing the libc6 libstdc++6 libssl1.0.0 libglib2.0-0 libx11-6 libglu1-mesa libgomp1 xvfb packages.
The foresight-httpd2.2_2.2.22-1~AstraLinuxSE~1.4_amd64.deb DEB package with Apache HTTP Server is included in the distribution kit of BI server for Linux OS. Copy it to the home directory and install by executing the following command:
sudo dpkg -i foresight-httpd2.*
After this proceed to BI server installation.
Installation of BI server DEB package requires access to a repository with dependent packages: libc6 libstdc++6 libssl1.0.0 libglib2.0-0 libx11-6 libglu1-mesa libgomp1 libodbc1 odbcinst xvfb apache2 apache2-mpm-worker.
If there are modules or packages not compatible with MPM Worker (for example, libapache2-mod-php5), they must be disabled in the BI server instance, or removed if they conflict with BI server installation. Then execute the following operations:
Copy a DEB package of the "foresight-pp9.0-biserver_9.0.*.deb" type to the home directory.
Install the copied package (other utility can be used for package installation):
sudo dpkg -i foresight-pp9.0-biserver*
Install the required dependencies (it may require to refresh a list of packages from repositories by the command sudo apt-get update):
sudo apt-get -f install
After the installation, a new Apache2 configuration instance is created for BI server, the mpm_worker module is enabled, the pp9.0-biserver module is enabled for loading mod_axis2, links of the apache2ctl-pp9.0 type are created in the /usr/local/sbin directory for managing the instance, the apache2-pp9.0 service is registered and added to autorun, the Prognoz Platform files are installed, the foresight-xvfb service is registered and added to autorun for starting the virtual graphic display No. 987. The foresight-xvfb service is started automatically, and apache2-pp9.0 must be started by the command:
sudo service apache2-pp9.0 start
NOTE. To change BI server version, install another package version over the previous one. Configuration files are saved if their version is not updated in the package.
After installing to monitor BI server performance and detecting various errors, the user can enable logging of system messages:
Add and uncomment the following strings in the file /etc/opt/foresight/pp9.0-biserver/envvars:
## Uncomment line below to export extended log
#export PP_LOG=1
Add the following strings to the file /etc/apache2-pp9.0/mods-available/pp9.0-biserver.conf:
Axis2LogFile "/opt/foresight/pp9.0-biserver/logs/axis2.log"
Axis2LogLevel info
After installing the BI server, proceed to the web application back end installation.
BI server uses settings specified in the settings.xml file. See its structure and make modifications if required.
NOTE. A file with settings is optional. If the file is absent, default parameter values are used.
To get information about repositories to work with, BI server uses the registry.reg or Metabases.xml file. For details about setting up these files, see the Configuration and Setup article.
All additional files used by BI server must have access permissions for an Apache HTTP Server user:
sudo chown -R www-data:www-data /opt/foresight/pp9.0-biserver
After determining settings and granting permissions restart BI server service:
sudo service apache2-pp9.0 restart
Check BI server performance.
The installed BI server will work in background as a separate Linux service. The Apache2 instance with BI server starts on the 88xx port, where xx corresponds to the minor version of the Prognoz Platform release.
After installing and setting up BI server, proceed to the web application back end installation.
To remove BI server files without removing configuration files, execute the command and confirm removal:
sudo apt-get remove pp9.0-biserver
All configuration files in the folders /etc/apache2-pp9.0 and /etc/opt/foresight/pp9.0-biserver, as well as new files that are not included into the setup package, are saved in these folders and /opt/foresight/pp9.0-biserver and can be used on the next package installation.
To delete BI server with configuration files, execute the command and confirm deletion:
sudo apt-get purge pp9.0-biserver
In this case, new files that are not included into the setup package, are saved.
See also:
Installing Web Application on Linux OS | Checking BI Server Performance