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.
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 = '*'
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:
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:
- 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.
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
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.
2. Configure MongoDB
MongoDB requires a data directory to store all data. Create this folder by running the following command in a Command Prompt:
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"
mongod --dbpath C:\data\db --replSet "rs0"
Open second Command Prompt, execute below command to create a root user:
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
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
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"
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
* 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: