Menu

Windows Install prerequisites for Manager 7.7

Important_icon.pngImportant: It is strongly recommended that you copy commands on this instruction and paste to your console so that the installation can be completed without issues.

»Install MySQL 5.6 on Windows

»Install MySQL Connector/J on Windows

»Install RabbitMQ on Windows

»Install PostgreSQL on Windows

»Install Redis on Windows

»Install ElasticSearch on Windows

Install MySQL 5.6 on Windows

  • Please use MySQL version 5.6 (Please Note: Newer versions of MySQL are not currently supported at this time.)
  • Click here to download and MySQL.

Important_icon.pngImportant:

  1. After MySQL installation is complete, please make sure that the transaction isolation level is set to READ-COMMITTED
    • Access to your MySQL instance. Check if variable tx_isolation's value is READ-COMMITTED by executing the following SQL statement
      mysql> SHOW VARIABLES LIKE 'tx_isolation';
      
    • If it is not READ-COMMITTED: under MySQL's installation directory, search for file [MySQL's installation directory]\MySQL Server 5.6\my.ini (you will need to show hidden files in Windows).
    • Open the file, add the following text to the end of section [mysqld].
      transaction-isolation = READ-COMMITTED
      
    • Save the file.
  2. This step is only required if you are deploying qTest with load balancing: Check if the maximum number of connections ofMySQL server is appropriate to the number ofqTest instances in the cluster.
    • Give the number (n) of qTest application servers in your cluster, then the appropriate number of connections to MySQL should be: 100 * (n + 1) + 10 (For 1 qTest server max_connections would be 210, for 2 qTest servers it would be 310 ect.)
    • Access to your MySQL instance and execute this command:
      mysql> SHOW VARIABLES LIKE ‘max_connections’;
      
    • If the maximum number of connections is less than the appropriate number, search for file [MySQL's installation directory]\MySQL Server 5.6\my.ini, open it and add the text below to the of section [mysqld].
      max_connections=[the_appropriate_number(210/420/630/840)]
      
    • Save the file.
  3. Save the file and restart the service.

 

Install MySQL Connector/J on Windows

Important_icon.pngImportant:

  • qTest works with MySQL Connector/J version 5.1.34+.
  • It needs to be downloaded to every server instance in which you are installing qTest.

Access to MySQL Connector/J's download page: http://dev.mysql.com/downloads/connector/j/

Select Platform Independent.

Download the ZIP Archive.

After the file has been downloaded, extract it. In the extracted directory, search for the jar file: mysql-connector-java-5.1.35.jar. You will need to specify the path to this file when installing qTest.

 

Install RabbitMQ on Windows

Important_icon.pngImportant:

  • In case you are deploying qTest with load balancing, you are required to install RabbitMQ. If not, you can skip installing this.

Follow this instruction to install RabbitMQ.

After RabbitMQ has been install successfully, please follow steps below to configure it:

  1. Open command prompt and navigate to [RabbitMQ_Installation_Directory]\sbin\. For example: C:\Program Files (x86)\RabbitMQ Server\rabbitmq_server-3.5.2\sbin\
  2. Execute these 2 commands:
    rabbitmq-plugins enable rabbitmq_stomp
    rabbitmq-plugins enable rabbitmq_management
    
  3. Open your browser and navigate to http://localhost:15672. Login with username and password as guest/guest.
  4. Navigate to Admin tab and select Users panel. Expand Add a user section and add a new user.
  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.
  6. Expand All virtual hosts section. Click on the virtual host which you have created in the above step to grant users the access.
  7. Expand Permissions section. Select the user whom you have created in step #4. Input. * in Configure regexp, Write regexp and Read regexp as the image below. Click on Set permission button to grant the access.
  8. Navigate to Overview tab. Expand Permissions section. Note down amqp port and stomp port. You will need to use them while installing qTest.

Install PostgreSQL on Windows

  • Click here to download PostgreSQL.
  • Double click on the installer file, an installation wizard will appear. Click on Next button.

Specify your installation directory, or keep the default directory.

Specify the directory where you want to store the data or keep the default.

Enter the password for the database superuser and service account.

Enter the port for PostgreSQL. Make sure that no other applications are using this port. Leave it as default if you are unsure.

Important_icon.pngImportant:

  • 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.

Choose the default locale.

Click the Next button and installing process starts.

The installation may take a few minutes to complete.

Click Finish button to complete the installation.

From the Start menu, type services.msc and enter. Search for postgres. Configure the service to start with the OS

Enable remote access to PostgreSQL database server:

  • Open file C:\Program Files\PostgreSQL\[version]\data\pg_hba.conf. Append the following configuration line, in which [IP_Address] is the IP of the machine from which you remotely connect to PostgreSQL server.
    host    all             all             [IP_Address]/24            md5  
    
  • Open file C:\Program Files\PostgreSQL\[version]\data\postgresql.conf. Append the following line:
    listen_addresses = '*'  
    

Create Database Schema

After PostgreSQL has been successfully installed, you will need to create a database schema. It will be used when installing qTest Sessions.

  • Open the console on your machine. Change the current path to PostgreSQL installation directory:
    C:\Users\SampleUser>cd C:\Program Files\PostgreSQL\9.3\bin
    
  • Create a database schema using the command below:
    createdb -h [YOUR_IP_POSTGRES_SERVER] -p [YOUR_POSTGRES_PORT] -U postgres -W [YOUR_DATA_BASE_NAME]
    
    For example:
    C:\Program Files\PostgreSQL\9.3\bin>createdb -h 192.168.74.77 -p 5432 -U postgres -W testdb77 //postgres is the username and testdb77 is the schema name
    Password: [INPUT_YOUR_PASSWORD_POSTGRESQL_HERE] //enter password of user postgres
    
  • Connect to the database:
    C:\Program Files\PostgreSQL\9.3\bin>psql -U postgres -W
    Password for user postgres: //enter your password here
    psql (9.3.5)
    WARNING: Console code page (437) differs from Windows code page (1252)
             8-bit characters might not work correctly. See psql reference
             page "Notes for Windows users" for details.
    Type "help" for help.
    
  • List out existing schema to check if the above one has been successfully created:
    postgres=# \l
                                                        List of databases
           Name       |  Owner   | Encoding |          Collate           |
     Ctype            |   Access privileges
    ------------------+----------+----------+----------------------------+----------------------------+-----------------------
     postgres         | postgres | UTF8     | English_United States.1252 | English_United States.1252 |
     template0        | postgres | UTF8     | English_United States.1252 | English_United States.1252 | 
     testdb77         | postgres | UTF8     | English_United States.1252 | English_United States.1252 |
    (3 rows)
    
    testdb77 has been created and listed above.
  • Quit thepsql program.
    postgres-# \q
    

 

Install Redis on Windows

Important_icon.pngImportant:

  • We currently support Redis 2.4.6+ on Windows. Click here to download.

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:

  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. # 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"
    

Open your console. Change the current path to C:\redis-2.8.17. Execute the following command to install Redis:

C:\redis-2.8.17>redis-server --service-install redis.windows.conf --loglevel verbose

Start the service:

C:\redis-2.8.17>redis-server --service-start

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, then press Enter button.
  • From Services windows, check if Redis is running.

 

Install ElasticSearch on Windows

Important_icon.pngImportant:

  • Java 7+ is required and $JAVA_HOME must be configured.
  • You can install Java 7 for free here
  • Click here to download ElasticSearch.

Extract the downloaded package to a directory on your computer. For example: D:\elasticsearch-1.7.3

From the Console, access to the bin directory (D:\elasticsearch-1.7.3\bin), run the following command to install the service on your Windows:

D:\elasticsearch-1.7.3\bin>service.bat install

From the Start menu, type services.msc and enter. Search for ElasticSearch. Configure the service to start with the OS.

Important_icon.pngImportant:

  • Default ElasticSearch HTTP and TCP ports are respectively 9200 and 9300. Make sure that the ports are available. Click here for the instruction to check which ports are available.
  • Make sure that the ports are not blocked by your firewall.
Subscribe To Our Blog
Powered by Zendesk