Installation : Orchestra and Stat on the Same Server
  

Orchestra and Stat on the Same Server

Installation Scenario

The picture below illustrates the installation scenario where Orchestra, Stat and Business Intelligence are all installed on the same server:
For this scenario, you will need to run the Orchestra installation wizard. If you then also want to install Business Intelligence, as in the picture above, please see “Business Intelligence” .
In this scenario, the Orchestra installation wizard, see “Orchestra Installation Wizard - installing both Orchestra and Stat” , installs the following:
• JDK
• Wildfly 11
• Orchestra
• Stat
• PostgreSQL (if used/needed)
Also, it runs the database scripts needed for Orchestra and Stat.
When the Orchestra installation is completed, if you also want to install Business Intelligence, it is time to run the Business Intelligence installation wizard, see “Business Intelligence Installation Wizard” , which installs the following:
• JDK
• Tomcat
• Pentaho
Also, it runs the database scripts needed for Business Intelligence.

Installation - Windows

Preparation:

1. Copy the QP_Central__win_<type>-<version_number>.zip file and unpack the files to a suitable directory, such as tmp.
It is recommended that path names containing spaces should not be used.

Configuration - Database

Prepare your database by running the scripts corresponding to your database (Oracle Database / Microsoft SQL / PostgreSQL).
If you are going to use PostgreSQL and will be installing it at the same time as installing Orchestra, this configuration can be skipped.
1. Open a database tool that allows you to run a database script (e.g. SQL Developer for Oracle Database, or SQL Server Management Studio for Microsoft SQL). For PostgreSQL see special instructions below.
2. Run the script corresponding to your database in a tool that can execute the script:
Microsoft SQL Server:
<tmp_dir>/db/central-mssql.sql
<tmp_dir>/db/stat-mssql.sql
 
Oracle Database:
<tmp_dir>/db/central-oracle.sql
<tmp_dir>/db/stat-oracle.sql
 
PostgreSQL:
1. Make sure the PostgreSQL bin folder is added to environment variables.
2. Open the command prompt in the <tmp_dir>/db/ directory.
3. Run the commands:
psql -U postgres -f central-postgres.sql
 
and:
psql -U postgres -f stat-postgres.sql
 

Installation

1. Open the Windows Task Manager and ensure that there is no application called “Services” running, see the picture below. If there is, close the Services application. This is done, to not cause any problems with starting and stopping the Orchestra service, during the installation procedure.
2. Run the Installation Wizard, install.bat. See “Orchestra Installation Wizard - installing both Orchestra and Stat” .
/<tmp_dir>/install.bat
 
Using the Installation Wizard to install Orchestra means that all modules will automatically be installed. If you know for a fact that you will not be needing certain modules, you should rather use the install.properties file to select the wanted modules and then run the installation in silent mode, using the command install.bat -s for Windows, or install.sh -s for Linux.

Orchestra Installation Wizard - installing both Orchestra and Stat

The wizard contains the following steps:
 
1. Click Start to start the installation.
2. Select Install.
3. Enter the wanted installation path, IP and Hostname.
It is important that the External IP matches what the user will enter in his/her browser.
It is also possible to enter a valid domain name, for example qmatic.com, or a host name, such as GOT-JOHSTA-001. This can also be updated post installation, in the file agent.conf.
Host names used by Orchestra should follow the RFC952 specifications. For more information, see https://tools.ietf.org/html/rfc952.
4. Select the wanted components.
If both Orchestra and Stat are selected, they will be installed on the same server.
If however, you want to install Stat on a separate server, see “Orchestra and Stat on Separate Servers” .
5. Select whether or not you already have an existing database server that you want to use. If you select Yes, you will need to enter the settings for your database server in the following pages. If you select No, PostgreSQL will be installed.
6. If you answered Yes in the previous step, select the wanted database here.
7. Enter your database settings (Hostname and Port for PostgreSQL and SQL Server, Hostname, Port, and SID (for Oracle). It is also possible (not mandatory) to test the connection here.
For SQL Server, you can also select Windows Authentication. For more information, see “Installation Note - Windows Authentication” .
8. If you selected SQL Server and Windows Authentication in the previous steps, enter and confirm your password on this page.
9. This page shows an Installation Summary. You can either go back through the wizard and update your settings, or click Next to proceed.
Here, it is also possible to save the configuration file.
10. This page shows the progress of the installation.
11. When the installation has been successfully completed, click Finish. It is also possible to download the log file.
 
 
12. When the installation has finished, Orchestra is automatically started.
13. Open the URL and start configuring the system. Please refer to the Administrator’s Guide, that can be found on Qmatic World.
http://<ORCHESTRA_IP>:8080
User: superadmin
Password: ulan
Once you have successfully managed to log in to Orchestra, you will know that the installation is complete!
If you want to import a system configuration, we recommend that you do this before any other configuration is done.
For more information, see “Import and export” .

Installation - Linux

Preparation:

1. Transfer the QP_Central_linux64-<version>.tgz file to the server, preferably to a tmp directory. Use for example scp to transfer the file.
It is recommended that path names containing spaces should not be used.
2. Login to the Orchestra Central server with a user with superuser rights.
3. Create a qmatic user:
#sudo adduser qmatic
 
4. Create Orchestra directory:
#sudo mkdir -p /opt/qmatic/orchestra/system
 
5. Grant rights for Orchestra directory to qmatic user:
#sudo chown -R qmatic:qmatic /opt/qmatic
 
6. Switch to qmatic user:
#sudo su - qmatic
 
7. Unpack Orchestra tgz file, to a tmp directory:
$ cd /<tmp_dir>
$ tar zxvf QP_Central_linux64-<version>.tgz
 

Configuration - Database

Prepare your database by running the scripts corresponding to your database (Oracle Database/Microsoft SQL/PostgreSQL).
If you are going to use PostgreSQL and will be installing it at the same time as installing Orchestra, this configuration can be skipped.
The scripts are designed for a rudimentary base installation of Orchestra, and should be reviewed and tuned by the database administrator to match the installation size and performance requirements.
1. Open a database tool that allows you to run a database script (e.g. SQL Developer for Oracle Database, or SQL Server Management Studio for Microsoft SQL). For PostgreSQL see special instructions below.
2. Run the script corresponding to your database in a tool that can execute the script:
Microsoft SQL Server:
<tmp_dir>/db/central-mssql.sql
<tmp_dir>/db/stat-mssql.sql
 
Oracle Database:
<tmp_dir>/db/central-oracle.sql
<tmp_dir>/db/stat-oracle.sql
 
The Oracle scripts will create required schemas in default user table-space. Please review the scripts and assign appropriate table-spaces for the schemas. Larger installations may require tuning of some Oracle instance parameters.
For more information, see “Tuning of Oracle Parameters” .
PostgreSQL:
1. Make sure the PostgreSQL bin folder is added to environment variables.
2. Open the command prompt in the <tmp_dir>/db/ directory.
3. Run the commands:
psql -U postgres -f central-postgres.sql
 
and:
psql -U postgres -f stat-postgres.sql
 
Larger installations may require tuning of some PostgreSQL parameters.
For more information, see “Tuning of PostgreSQL Parameters” .

Installation

1. Switch to qmatic user:
#sudo su - qmatic
 
2. Make sure that the Orchestra installation directory is empty and that there is no space in the path name.
3. Run the Installation Wizard, install.sh. For more information see “Orchestra Installation Wizard - installing both Orchestra and Stat” :
$ /<install_dir>/install.sh
 
To run the installation in silent mode:
$./install.sh -s
 
4. When the installation has finished, switch to user with super user rights:
$ exit
 
5. Change directory:
#cd /opt/qmatic/orchestra/system/bin
 
6. Add startup scripts to operating system:
#sudo ./install-services.sh
 
7. Open the URL and start configuring the system. Please refer to the Administrator’s Guide, that can be found on Qmatic World.
http://<ORCHESTRA_IP>:8080
User: superadmin
Password: ulan
Once you have successfully managed to log in to Orchestra, you will know that the installation is complete!
If you want to import a system configuration, we recommend that you do this before any other configuration is done.
For more information, see “Import and export” .