Insights 1.11.2 Single Server Installation Guide for Windows

In this guide we'll run you through installing qTest Insights 1.11.2 on a Windows Machine

Before you begin

Before you install qTest Insights 1.11.2, make sure following things are done:

• Your machine needs to satisfy qTest's recommended hardware requirements
• qTest Manager 8.4.4 has been deployed 
• qTest Sessions 3.0.9 has been deployed
• Access to the server where you install qTest Manager's Database, connect to your Manager database and create a schema for Insights as following instructions:

Connect qTest DB using postgres user

C:\Program Files\PostgreSQL\9.5\bin>psql -h [Your_Postgres_server_address] -U postgres -W [Your_qTest_DBName]
Password for user postgres: //enter your password here

Create Insights schema

create schema [Insights_Schema];

Install qTest Insights 1.11.2

1. Download qTest Insights installation package 

Click this link to download the installation package 

2. Extract the package

Access the directory "\qtestctl-windows-x64\qtestctl" 

3. Modify the configure file 

Open the file \qtestctl\qtest.config and follow instructions below to modify it.

// list of applications
apps = ['insights']

insights {
 //HTTP Port of qTest Insights 
 httpport = 8081
 //Admin Port of qTest Insights
 adminport = 8007
 
 postgres {
 auth {
 user = 'postgres' 
 //Password of user postgres to qTest Manager DB
 pass = 'root'
 }
 }

 scheduler {
 //Scheduler port, make sure this port is avalable
 port = 56982

 passKey = 'defaultKey'
 //scheduler host (same machine with insights)
 server = 'localhost'
 }

 etl {
 //path to directory where you installed jsvc on Linux, please ignore this if you're installing on Windows
 jsvc = '/usr/bin/jsvc'

 //default period of time etl run to update project module and test cycle, default is 10
 cylcleupdateinterval = 10
 projectmoduleupdateinterval = 10
 }
}

session {
 //IP of Sessions' Postgres Database
 host = '52.192.91.55'
 //Port to Sessions' Postgres Database
 port = 5432

 postgres {
 auth {
 user = 'postgres'
 //Password of user postgres to qTest Sessions DB
 pass = 'root'
 }
 db {
 //Sessions DB
 session = 'sessions'
 }
 }
}

postgres {
 //IP of qTest Manager's Postgres DB
 host = '52.192.91.56'
 //Port to qTest Manager's Postgres DB
 port = 5432
 auth {
 user = 'postgres'
 //Password of user postgres to qTest Manager's Postgres DB
 pass = 'root'
 }
 db {
 //qTest Manager's DB
 qtest = 'qtest'
 }
}

/* DO NOT EDIT ANYTHING BELOW THIS LINE */

insights {
 version = '1.0'
}
insightsscheduler {
 version = '1.0'
}
insightsetl {
 version = '1.0'
}

postgres {
 url {
 qtest = "jdbc:postgresql://${postgres.host}:${postgres.port}/ 
${postgres.db.qtest}"
 }
}

 

4. Install and Start

Open the console on your machine, change the current path to qtestctl directory and run following command to let Insights run as service and run following command

 C:\[path_to_qtestctl]>install.bat

Start

 C:\[path_to_qtestctl]>qtestctl.bat start

 

That's everything and you now have qTest Insights being installed and started.

Now, you need to connect it to your qTest Manager, access to your qTest Insights and follow steps in the section "Set up qTest Insights"

Set up qTest Insights

Access your Administration page

Under System Configuration page, scroll to section MISCELLANEOUS and enter qTest URL into the field qTest server's Domain.

Scroll to Insights section and enter Insights URL

http://<IP of the machine where you installed qTest Insights>:<Insights port which you've specified in the config file>

Test Connection and save the configuration.

 

That's it! You now can access qTest Insights via its option in 9box icon

 

 

NOTE

In order for the Insights Scheduler (it is to send scheduled report to your email) to work properly, make sure that you do configure your Email Server in qTest Manager's System Configuration page.