QuerySurge Multi Machine Installation Procedure
Note: See our article on permissions required for installation on Linux here.
Prepare for Installation
- Download the QuerySurge Installer to the machines you want to install QuerySurge on - an App Server and a Database Server. In addition, you'll likely want to install an Agent on a box (it need not be a server), so the installer should be copied to any location where an Agent install is planned.
- At the linux prompt on each machine, use the cd command to go to the directory in which you have downloaded the installer.
- At the prompt, issue the command ls –al to check the filename. You should see a listing similar to the following (where ‘x.x.x’ is the QuerySurge version number):
-rw-rw-r--. 1 root root 232635922 Nov 21 11:07 querysurge-installer-x.x.x-linux-x64.run - To make the installer file executable, type chmod +x <filename> at the prompt, where <filename> is the QuerySurge installer name from the previous command:
chmod +x querysurge-installer-x.x.x-linux-x64.run - Type ls -al again to confirm the change; at the left of the file listing, you should see rwxrwxr-x:
-rwxrwxr-x. 1 root root 232635922 Nov 21 11:07 querysurge-installer-x.x.x-linux-x64.run
Installing the QuerySurge Database
- On the box designated as the QuerySurge Database server, issue the command at the prompt: ./<filename> where <filename> is the QuerySurge installer shown from the ls command (where ‘x.x.x’ is the QuerySurge version number):
./querysurge-installer-x.x.x-linux-x64.run --mode text - Press the 'Enter' key as required to review the license agreement, which begins:
------------------------------------------------------------------
Welcome to the QuerySurge Setup Wizard.
------------------------------------------------------------------
Please Please read the following License Agreement. You must accept the terms of this agreement before continuing with the installation.
Press [Enter] to continue :
EVALUATION AGREEMENT
THIS EVALUATION AGREEMENT (?AGREEMENT?) IS ENTERED INTO BY AND BETWEEN REAL-TIME
TECHNOLOGY SOLUTIONS, INC. (?RTTS?) AND ?EVALUATOR?. BY CLICKING ON THE
"ACCEPT" BUTTON, YOU OR THE ENTITY OR COMPANY THAT YOU REPRESENT (?EVALUATOR?)
ARE UNCONDITIONALLY CONSENTING TO BE BOUND BY AND ARE BECOMING A PARTY TO THIS
AGREEMENT. EVALUATOR?S INSTALLATION AND USE OF THE PRODUCT SHALL ALSO
CONSTITUTE ASSENT TO THE TERMS OF THIS AGREEMENT. IF EVALUATOR DOES NOT
UNCONDITIONALLY AGREE TO ALL OF THE TERMS OF THIS AGREEMENT, CLICK THE "CANCEL"
BUTTON. IF THESE TERMS ARE CONSIDERED AN OFFER, ACCEPTANCE IS EXPRESSLY LIMITED
TO THESE TERMS. BY CLICKING ?ACCEPT? YOU ACKNOWLEDGE AND AGREE ON BEHALF OF
YOURSELF AND YOUR EMPLOYER TO BE BOUND TO THIS AGREEMENT. YOU REPRESENT THAT
YOU ARE AUTHORIZED TO ACCEPT THIS AGREEMENT ON YOUR EMPLOYER?S BEHALF. -
Type 'y' to accept the license agreement:
Press [Enter] to continue :
Do you accept this license? [y/n]: y
- Specify the directory where you want QuerySurge to be installed or press 'Enter' to accept the default location:
------------------------------------------------------------------
Please specify the directory where QuerySurge will be installed.
Installation Directory [/opt/QuerySurge]: - Type 'y' at 'Database' install the Database components and 'N' for all other components.
------------------------------------------------------------------
Select the components you want to install; clear the components you do not want to install.
Database [Y/n]: y
App Server [Y/n]: N
Agent [Y/n]: N
Tutorial + Sample Data [Y/n]: N
Command Line API [y/N]: N
Test Management Tool Connectors [y/N]: N - Press the 'Enter' key to confirm your selections
Is the selection above correct? [Y/n]: y
- Press the 'Enter' key to confirm installation of QuerySurge as a service:
------------------------------------------------------------------
Install Service
Install QuerySurge as a service
Install as a service? [Y/n]: y - Enter the QuerySurge Database Port or accept the default value (3306). Note the port number, along with the server name or IP address of this server, as these values are required for the QuerySurge App Server installation.
------------------------------------------------------------------
QuerySurge Database Port
Choose a port for the QuerySurge embedded database
QuerySurge Database Port [3306]: - Type 'N' and press the 'Enter' key to proceed:
Test Statsmon Connection With Server [y/N]: N - Press the 'Enter' key to confirm the installation of the QuerySurge Database
------------------------------------------------------------------
Setup is now ready to begin installing QuerySurge on your computer.
Do you want to continue? [Y/n]: y - The QuerySurge Database should install. This will take several minutes (< 20 min).
Installing the QuerySurge App Server
- On the box designated as the QuerySurge App server, issue the command at the prompt: ./<filename> where <filename> is the QuerySurge installer shown from the ls command (where ‘x.x.x’ is the QuerySurge version number):
./querysurge-installer-x.x.x-linux-x64.run --mode text - Press the 'Enter' key as required to review the license agreement, which begins:
------------------------------------------------------------------
Welcome to the QuerySurge Setup Wizard.
------------------------------------------------------------------
Please Please read the following License Agreement. You must accept the terms of this agreement before continuing with the installation.
Press [Enter] to continue :
EVALUATION AGREEMENT
THIS EVALUATION AGREEMENT (?AGREEMENT?) IS ENTERED INTO BY AND BETWEEN REAL-TIME
TECHNOLOGY SOLUTIONS, INC. (?RTTS?) AND ?EVALUATOR?. BY CLICKING ON THE
"ACCEPT" BUTTON, YOU OR THE ENTITY OR COMPANY THAT YOU REPRESENT (?EVALUATOR?)
ARE UNCONDITIONALLY CONSENTING TO BE BOUND BY AND ARE BECOMING A PARTY TO THIS
AGREEMENT. EVALUATOR?S INSTALLATION AND USE OF THE PRODUCT SHALL ALSO
CONSTITUTE ASSENT TO THE TERMS OF THIS AGREEMENT. IF EVALUATOR DOES NOT
UNCONDITIONALLY AGREE TO ALL OF THE TERMS OF THIS AGREEMENT, CLICK THE "CANCEL"
BUTTON. IF THESE TERMS ARE CONSIDERED AN OFFER, ACCEPTANCE IS EXPRESSLY LIMITED
TO THESE TERMS. BY CLICKING ?ACCEPT? YOU ACKNOWLEDGE AND AGREE ON BEHALF OF
YOURSELF AND YOUR EMPLOYER TO BE BOUND TO THIS AGREEMENT. YOU REPRESENT THAT
YOU ARE AUTHORIZED TO ACCEPT THIS AGREEMENT ON YOUR EMPLOYER?S BEHALF. -
Type 'y' to accept the license agreement:
Press [Enter] to continue :
Do you accept this license? [y/n]: y
- Specify the directory where you want QuerySurge™ to be installed or press 'Enter' to accept the default location:
------------------------------------------------------------------
Please specify the directory where QuerySurge will be installed.
Installation Directory [/opt/QuerySurge]: - Type 'y' at 'App Server' and 'N' for all other components.
------------------------------------------------------------------
Select the components you want to install; clear the components you do not want to install.
Database [Y/n]: N
App Server [Y/n]: Y
Agent [Y/n]: N
Tutorial + Sample Data [Y/n]: N
Command Line API [y/N]: N
Test Management Tool Connectors [y/N]: N - Press the 'Enter' key to confirm your selections
Is the selection above correct? [Y/n]: y - Press the 'Enter' key to confirm installation of QuerySurge as a service:
------------------------------------------------------------------
Install Service
Install QuerySurge as a service
Install as a service? [Y/n]: y - Enter the QuerySurge HTTP Port or accept the default value (80). Note the HTTP Port number and the server name or IP address, as these values are required for further setup and for logging into QuerySurge.
------------------------------------------------------------------
QuerySurge Application Server Configuration
Choose ports for the QuerySurge application server
QuerySurge App Server HTTP Port [80]:
QuerySurge App Server Shutdown Port [8005]: - Enter the hostname and port for the QuerySurge Database. These are the values that you entered and noted in Step 8 of "Installing the QuerySurge Database". (The default Database Port is 3306.)
Database Configuration
Enter the fully qualified server name of the machine you have installed QuerySurge’s embedded database and database port as well.
Hostname []: <Hostname or IP of Database Machine>
Port []: <Database Port> -
Press the 'Enter' key to confirm the installation of QuerySurge
Setup is now ready to begin installing QuerySurge on your computer. Do you want to continue? [Y/n]: y
------------------------------------------------------------------ - The QuerySurge App Server should install. This will take several minutes (< 20 min).
- Launch a supported browser (supported browsers are listed here) and perform a test login to QuerySurge.
In the browser, navigate to the URL:
http://<server_name>/QuerySurge
If you specified a different port other than the default HTTP Port 80 in Step 7, then the URL is:http://<server_name>:<port>/QuerySurge
The default QuerySurge admin credentials are: admin/admin. You should set the Admin password to a value of your choosing.
Install a QuerySurge Agent
- On a box designated for a QuerySurge Agent, issue the command at the prompt: ./<filename> where <filename> is the QuerySurge installer shown from the l command (where ‘x.x.x’ is the QuerySurge version number):
./querysurge-installer-x.x.x-linux-x86.run --mode text - Press the 'Enter' key as required to review the license agreement, which begins:
------------------------------------------------------------------
Welcome to the QuerySurge Setup Wizard.
------------------------------------------------------------------
Please Please read the following License Agreement. You must accept the terms of this agreement before continuing with the installation.
Press [Enter] to continue :
EVALUATION AGREEMENT
THIS EVALUATION AGREEMENT (?AGREEMENT?) IS ENTERED INTO BY AND BETWEEN REAL-TIME
TECHNOLOGY SOLUTIONS, INC. (?RTTS?) AND ?EVALUATOR?. BY CLICKING ON THE
"ACCEPT" BUTTON, YOU OR THE ENTITY OR COMPANY THAT YOU REPRESENT (?EVALUATOR?)
ARE UNCONDITIONALLY CONSENTING TO BE BOUND BY AND ARE BECOMING A PARTY TO THIS
AGREEMENT. EVALUATOR?S INSTALLATION AND USE OF THE PRODUCT SHALL ALSO
CONSTITUTE ASSENT TO THE TERMS OF THIS AGREEMENT. IF EVALUATOR DOES NOT
UNCONDITIONALLY AGREE TO ALL OF THE TERMS OF THIS AGREEMENT, CLICK THE "CANCEL"
BUTTON. IF THESE TERMS ARE CONSIDERED AN OFFER, ACCEPTANCE IS EXPRESSLY LIMITED
TO THESE TERMS. BY CLICKING ?ACCEPT? YOU ACKNOWLEDGE AND AGREE ON BEHALF OF
YOURSELF AND YOUR EMPLOYER TO BE BOUND TO THIS AGREEMENT. YOU REPRESENT THAT
YOU ARE AUTHORIZED TO ACCEPT THIS AGREEMENT ON YOUR EMPLOYER?S BEHALF. -
Type 'y' to accept the license agreement:
Press [Enter] to continue :
Do you accept this license? [y/n]: y
- Specify the directory where you want QuerySurge to be installed or press 'Enter' to accept the default location:
------------------------------------------------------------------
Please specify the directory where QuerySurge will be installed.
Installation Directory [/opt/QuerySurge]: - Type 'y' at 'Agent' to install the Agent and 'N' for all other components.
------------------------------------------------------------------
Select the components you want to install; clear the components you do not want to install.
Database [Y/n]: N
App Server [Y/n]: N
Agent [Y/n]: Y
Tutorial + Sample Data [Y/n]: N
Command Line API [y/N]: N
Test Management Tool Connectors [y/N]: N - Press the 'Enter' key to confirm your selections
Is the selection above correct? [Y/n]: y - Press the 'Enter' key to confirm installation of QuerySurge as a service:
------------------------------------------------------------------
Install Service
Install QuerySurge as a service
Install as a service? [Y/n]: y - Type 'y' for each of the bundled JDBC driver selections that you want to deploy:
Oracle (ojdbc7) [y/N]:
Teradata (terajdbc4) [y/N]:
Sybase (jTDS 1.3.1) [y/N]:
Flat File and XML (JStels) [Y/n]:
MS SQL Server (sqljdbc4) [y/N]:
MySQL (Connector/J 5.1.33) [Y/n]:
Amazon Redshift [y/N]:[1] –Select—
[2] Apache Hive 1.2.1
[3] Cloudera CDH 5.5
[4] Hortonworks 2.3
Please choose an option [1] :Note: If you do not see your specific data source technology listed, you will be able to add additional vendor drivers to QuerySurge post-installation. See your vendor website for driver download information. The procedure for "manually" adding a driver to an Agent is discussed here.
- You will need to accept the license terms for the drivers you have selected by typing 'y' at each request.
- Press the 'Enter' key to test the connection with the QuerySurge App Server:
Test Agent Connection
With Server [y/N]: y - Enter the hostname and port for the QuerySurge App Server. These are the values you entered and noted in Step 8 of "Installing the QuerySurge App Server". (The default HTTP Port is 80.)
------------------------------------------------------------------
Agent Connection
QuerySurge agents need a connection to the QuerySurge App server.
The hostname of the QuerySurge App server
Hostname []: <Hostname of App Server>
The port of the QuerySurge server
Port [80]: <App Server HTTP Port> -
Press the 'Enter' key to confirm the installation of QuerySurge
Setup is now ready to begin installing QuerySurge on your computer. Do you want to continue? [Y/n]: y
------------------------------------------------------------------ - The QuerySurge Agent should install. This will take several minutes.
- Once the installer has completed, your QuerySurge Agent should be installed, and should have self-registered with QuerySurge, but it will not be Enabled. Log into QuerySurge as a QuerySurge Admin user, and navigate to the Admin view. In the upper left of the Admin view, click on Agents in the Admin tree. A list of existing Agents will show in the grid in the main panel. Locate the Agent you have just installed, and Enable it by clicking on the checkbox in the Enabled column. In the lower right of the main panel, click on the Refresh button. You should now see in the Last Ping column that the Agent has successfully pinged into QuerySurge.
- You may want to install additional Agents (a minimum of one is required). Currently, there is a limit of one Agent install per Operating System (OS). You can repeat this procedure on additional OS's.
The core installation of QuerySurge is now complete.
Note: The local firewall may require ports to be opened. The default QuerySurge ports are 80 (HTTP) and 3306 (database), however you may have modified these during installation. If the ports used during installation are blocked, the firewall may be the cause.
Comments
0 comments
Please sign in to leave a comment.