QuerySurge™ Single Machine Installation Procedure
Note: See our article on permissions required for installation on Linux here.
Prepare for Installation
1. Download the QuerySurge Installer to the machine you want to install QuerySurge on.
Note: Newer browser versions have started modifying Linux .run file extensions to ".txt" on Windows. If you download your QuerySurge installer on Windows prior to moving it to Linux, it may show up as querysurge-installer-x.x.x-linux-x64.txt instead of querysurge-installer-x.x.x-linux-x64.run. The installer should be intact, however, and you can either restore the ".run" extension, or you can leave it as it is. The installation on Linux should proceed normally either way.
2. At the Linux prompt, use the cd command to go to the directory where you have downloaded the installer.
3. At the prompt, issue the command ls –al to list the filename. You should see a sequence 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
4. Type chmod +x <filename> at the prompt to make the installer file executable, where is the QuerySurge installer name from the previous command:
chmod +x querysurge-installer-x.x.x-linux-x64.run
5. Type ls -al again to confirm this change – to 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
Note: Make sure all antivirus software (or similar software) is shut down before you start the installation, as these processes can interfere with the installation process, potentially breaking your installation.
Install QuerySurge
6. At the prompt, issue the command ./ where 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
7. Review License Agreement and press Enter as prompted Enter, it begins as follows:
----------------------------------------------------------------------------
Welcome to the QuerySurge Setup Wizard.
----------------------------------------------------------------------------
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.
8. Type "y" and press Enter to accept the License Agreement:
Press [Enter] to continue :
Do you accept this license? [y/n]: y
9. To accept the default Directory press Enter. If not insert Directory location and press Enter:
----------------------------------------------------------------------------
Please specify the directory where QuerySurge will be installed.
Installation Directory [/opt/QuerySurge]:
10. To install components type "y" and press Enter: (the default installations are "database", "server", "agent",and "tutorial+sample data")
----------------------------------------------------------------------------
Select the components you want to install; clear the components you do not want to install.
Database [Y/n] :y
App Server [Y/n] :y
Agent [Y/n] :y
Tutorial+Sample Data [Y/n]
QuerySurge APIs [y/N]
Test Management Tool Connectors [y/N]: N
Ready for Analytics [y/N]: y
11. To confirm selections type "y" and press Enter.
Is the selection above correct? [Y/n]: y
12. To accept default Memory Configuration type "N" and press Enter, if not type "y" and adjust configuration and press Enter.
Custom Memory Configuration [y/N]:N
13. To confirm the installation of QuerySurge as a service, press "y" and Enter:
----------------------------------------------------------------------------
Install QuerySurge as a service? [Y/n]: yNote: If you are not installing QuerySurge components as services, note that when you manually start QuerySurge processes, you must start them under a user account with sufficient permissions to access all required required resources (including, but not limited to, directories and files).
14. To accept the default QuerySurge Database Port value (3306) press Enter, if not insert adjusted value and press Enter:
----------------------------------------------------------------------------
QuerySurge Database Port
Choose a port for the QuerySurge embedded database
QuerySurge Database Port [3306]:
15. If you have received a feature code via email upon applying for a BI Tester add on insert it now and press Enter, if not press Enter to continue:
[1] No Feature Code
[2] Feature Code: Please choose and option [1]: No Feature Code
16. To accept the default App Server HTTP Port value (80) and default App Server Shutdown Port value (8005), press Enter, if not insert adjusted value and press Enter:
----------------------------------------------------------------------------
QuerySurge Application Server Configuration
Choose ports for the QuerySurge application server
QuerySurge App Server HTTP Port [80]:
QuerySurge App Server Shutdown Port [8005]:
16. To install Bundled Drivers type "y" and press Enter (your installer may have different options).
----------------------------------------------------------------------------
Bundled Driver Selection Please select drivers to install. If you do not see your driver(s), they can be added post-install.
----------------------------------------------------------------------------
Oracle (ojdbc6) [y/N]:y
Teradata (terajdbc4) [y/N]:y
SAP ASE(jTDS 1.3.1) [y/N]:y
Flat File and XML (JStels) [Y/n]:y
QuerySurge BI Tester [y/N]:y
MS SQL Server(sqljdbc 4.2) [Y/n]:y
SSAS(0lap4j) [y/N]: y
Amazon Redshift [y/N]: y
Hadoop (Hive)(y/N): y
Vertica (9.1.0) [y/N]
QuerySurge Excel Driver [y/N]: y
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 Appendix A or your vendor website for driver download information.
17. You may have to accept License Agreements for each selected Driver, press "y" and Enter as prompted to accept the License Terms.
18. To confirm QuerySurge Installation press Enter.
------------------------------------------------------------------
Setup is now ready to begin installing QuerySurge on your computer.
Do you want to continue? [Y/n]: y
19. An alert message will specify that a Staging Feature needs to be enabled before Staging Queries are run, press Enter to continue.
If you are upgrading from Query Surge version prior to 5.0.X, you will need to apply a license with the Staging feature enabled before you can run Staging Queries
Press [Enter] to continue:
20. QuerySurge will now install.
----------------------------------------------------------------------------
Please wait while Setup installs QuerySurge on your computer.
Installing
0% ______________ 50% ______________ 100%
########################################
The installation of one agent is required as a minimum although the installation of additional agents is encouraged. Operating Systems (OS) have a limit of one Agent per server. You can repeat this procedure on additional OS's.
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.
The core installation of QuerySurge is now complete.
Important: Be sure to back up the QuerySurge database regularly in order to Safeguard QuerySurge Data. Your only protection against data loss is a regular backup schedule. In the case of a severe outage your only possibility of recovery is based on a recent backup.
See this Knowledge Base article for backup procedures.