Menu

Prerequisite Software for Manager 8.7.3 Installation Guide for Windows machine

In this article, we'll run you through how to installing and configuring prerequisite applications before you install qTest Manager 8.7.3 on a Windows machine. There are 3 required applications: PostgreSQL, Redis, RabbitMQ. 

 

PostgreSQL 9.5

1. Install PostgreSQL 9.5

Follow this article to install Postgres

2. Configure PostgreSQL

Once PostgreSQL is installed, follow steps below to enable remote access to PostgreSQL database server:

2.1 Open file C:\Program Files\PostgreSQL\9.5\data\pg_hba.conf.

2.2 Edit the file and append the following line to specify the IP of the server which will remotely connect to your PostgreSQL. This should be the server where qTest packages are installed.

  • If you want to allow connection from multiple client machines on a specific network, specify the network address here in the CIDR-address format
  • If you want your PostgreSQL to accept all incoming connections regardless of the source IP address, use 0.0.0.0/0 as the IP address
host    all             all             [IP_Address]            md5  

2.3 Open file C:\Program Files\PostgreSQL\9.5\data\postgresql.conf. Append the following line:

listen_addresses = '*'  

 

Redis 

1. Download Redis 2.8.19

Download Redis 2.8.19 from this link 

2. Configure Redis

After you have downloaded the package, extract it to a folder on your machine. For example: C:\redis-2.8.17.

In the extracted folder, open file redis.windows.conf. Search for and update the following line:

2.1 # maxheap

  • Remove the # and specify a max heap size.
  • The size is half the volume of your server RAM. For example, if my server's RAM is 8GB, then:
maxheap 4G

2.2 # heapdir

  • Remove the # and specify your directory path.
  • The directory's free space should be larger than (RAM + 2*maxheap). For example:
heapdir "D:\Redis Heap"

2.3 Install Redis

  • Open your console. Change the current path to C:\redis-2.8.17. Execute the following command:
C:\redis-2.8.17>redis-server --service-install redis.windows.conf --loglevel verbose
  • Then start the service:
C:\redis-2.8.17>redis-server --service-start

redis.png

Important_icon.pngImportant:

  • Default Redis port is 6379. Make sure that the port is available. Click here for the instruction to check which ports are available.
  • Make sure that the port is not blocked by your firewall.

To check if Redis has been installed successfully on your machine:

  • From "Start\Search box", enter services.msc, then press Enter button.
  • From Services windows, check if Redis is running.

redisservice.png

 

RabbitMQ 

RabbitMQ is required to be installed in case you want to deploy qTest Manager with load balancing. Otherwise, please skip this section.

1. Install Erlang

Download and install Erlang following this article

2. Install RabbitMQ 3.5.4

Download RabbitMQ 3.5.4 here 

3. Configure RabbitMQ

Once RabbitMQ is installed, follow steps below to configure it:

3.1 Open command prompt and navigate to [RabbitMQ_Installation_Directory]\sbin\. For example: C:\Program Files (x86)\RabbitMQ Server\rabbitmq_server-3.5.4\sbin

3.2 Execute these 2 commands:

rabbitmq-plugins enable rabbitmq_stomp
rabbitmq-plugins enable rabbitmq_management

configrabbitmq.png

3.3 Open your browser and navigate to http://localhost:15672.

Login with username and password as guest/guest.  

3.4 Navigate to Admin tab and select Users panel.

Expand Add a user section and add a new user.   

3.5 Select Virtual Hosts panel.

  • Expand Add a new virtual host section.
  • Enter a host name and click on Add virtual host to add a new host.

3.6. Expand All virtual hosts section.

Click on the virtual host which you have created in the above step to grant users the access. 

3.7. Expand Permissions section.

  • Select the user whom you have created in step #2.4.
  • Input. * in Configure regexp, Write regexp and Read regexp as the image below.
  • Click on Set permission button to grant the access. 

3.8 Navigate to Overview tab.

  • Expand Port and contexts section.
  • Note down amqp port and stomp port. You will need to use them while installing qTest Manager

 

 

Install and Configure MongoDB 3.4

1. Install MongoDB 3.4

qTest Parameters requires MongoDB 3.4 that you can download it here. After downloading, double click on the downloaded file and follow the installation wizard to install it.

When installation completes, make sure MongoDB’s bin folder be added to System Environment Variables.

mongo-env-vars.png

2. Configure MongoDB

MongoDB requires a data directory to store all data. Create this folder by running the following command in a Command Prompt:

md [PATH\TO\DB\FOLDER]

For example:

md C:\data\db

Start MongoDB with following command. Notes: if your path includes spaces, enclose the entire path with double quotes.

mongod --dbpath [PATH\TO\DB\FOLDER] --reptSet "rs0"

For example:

mongod --dbpath C:\data\db --replSet "rs0"

Open second Command Prompt, execute below command to create a root user:

mongo
rs.initiate()
use admin
db.createUser ({
    user: "[USER_NAME]",
    pwd: "[PASSWORD]",
    roles: ["root"]
})

For example:

mongo
rs.initiate()
use admin
db.createUser ({
    user: "tdm",
    pwd: "password",
    roles: ["root"]
})

Close both Command Prompt windows.

3. Run MongoDB as a Window service

Open a new Command Prompt as an Administrator.

Create a folder for log files

md [PATH\TO\LOG\FOLDER]

For example:

md C:\data\log

Create a configuration file at MongoDB installation folder, e.g. C:\Program Files\MongoDB\Server\3.4\mongod.cfg. Open your favorite text editor as an Administrator and edit the file as following:

systemLog:
  destination: file
  path: [PATH\TO\LOG\FOLDER]
storage:
  dbPath: [PATH\TO\DB\FOLDER]
replication:
  replSetName: rs0
security:
  authorization: enabled

For example:

systemLog:
  destination: file
  path: C:\data\log\mongod.log
storage:
  dbPath: C:\data\db
replication:
  replSetName: rs0
security:
  authorization: enabled

Create the MongoDB service by running following command:

sc.exe create MongoDB binPath="\"[MONGODB_INSTALLATION_FOLDER]\bin\mongod.exe\" --service --config=\"[PATH\TO\CONFIG\FILE]\"" DisplayName="MongoDB" start="auto"

For example:

sc.exe create MongoDB binPath="\"C:\Program Files\MongoDB\Server\3.4\bin\mongod.exe\" --service --config=\"C:\Program Files\MongoDB\Server\3.4\mongod.cfg\"" DisplayName="MongoDB" start="auto"

If successfully created, the following log message will be displayed in the Command Prompt

[SC] CreateService SUCCESS

Start the MongoDB service by running following command

net start MongoDB

Notes:

* If you would like to stop the MongoDB service as needed, run the following command:

net stop MongoDB

* If you would like to remove the MongoDB service as needed, first stop the service and then run the following command:

sc.exe delete MongoDB

Verify that MongoDB service is running by following below steps:

  • Open Command Prompt and type services.msc to open Services window 
  • On Services window, look for the service named MongoDB and make sure its Status is Running and its Startup Type is set to Automatic, as shown in below screenshot:

mongodb-service.png

Powered by Zendesk