Menu

Insights 1.2 to 1.11.2 Single Server Upgrade Guide for Windows

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

Before you begin

Before you upgrade qTest Insights 1.2, make sure following things are done:

  • qTest Manager has been upgraded to 8.4.4 
  • qTest Sessions has been upgraded to 3.0.9
  • 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];

 

Upgrade qTest Insights from 1.2 to 1.11.2

 

1. Stop current Insights service, Insights Scheduler service

  • Open command prompt and type services.msc to open Services window 
  • On Services window, look for the service named qTest Insights Scheduler and qTest Insights. Stop both of them

insights.pnginsights1.png

2. Install qTest Insights 1.11.2

2.1 Click this link to download the installation package

2.2 Extract the package and access the directory "\qtestctl-windows-x64\qtestctl" 

2.3 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}"
}
}

 

2.4 Install & Start qTest Insights 1.11.2

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

 

3. Migrate data from Insights 1.2 to Insights 1.11.2

3.1 Stop Insights 1.11.2

 C:\[path_to_qtestctl]>qtestctl.bat stop

 

3.2 Migrate Scheduler data

Copy data from directory \qTest Insights 2\local\insights-scheduler\Schedules of Insights 1.2

to new location of Insights 1.11.2 at 

\qtestctl-windows-x64\qtestctl\insights\build\insightsscheduler\Schedules

 

3.3 Migrate web data

Under Root folder of Insights 1.2 \qTest Insights 2\local\insights\webapps\ROOT

copy following folders 

CustomReports
ExecutedReports
rdDataCache
rdDownload
SavedBookmarks
SavedDashboards

to new location of Insights 1.11.2 at \qtestctl-windows-x64\qtestctl\insights\build\apache-tomcat-8.5.15\webapps\ROOT

 

4. Start Insights 1.11.2

Start Insights 1.11.2

 C:\[path_to_qtestctl]>qtestctl.bat start

 

That's everything and you now have qTest Insights being upgraded to 1.11.2. You want to access to your qTest Insights instance via browser to verify if the upgrade process completes successfully, then you may want to unintall qTest Insights 1.2.

 

 

 

 

 

 

Subscribe To Our Blog
Powered by Zendesk