Unattended Installation - Windows & Linux (Versions: 8.0+)

Versions: 8.0+

The QuerySurge installer can be run in a headless mode using the Command Line, where all installation requirements must be passed in as arguments to the installer. The following article provides sample commands for single machine and multi machine installs with both Windows and Linux installers. A full reference of options can be found in the footer of this article.

Linux Installations

The sample commands below are for Linux distributions of the QuerySurge installer. Any commands should be executed as the root user or preface each command with sudo to ensure the installer has the appropriate permissions. The installer name shows “X.Y.Z” for the QuerySurge version – you will need to replace this with the actual version numbers.

Sample Full Installation (64-bit Linux installer)

This command installs QuerySurge (single platform install) with all components on a single machine (Database, Tomcat, Agent). This command also includes some of the bundled drivers as well as the sample data. The default HTTP and database ports are used as well as the default install location (/opt/QuerySurge).  A full list of bundled drivers is at the end of this document.

sudo ./querysurge-installer-X.Y.Z-linux-x64.run --mode unattended 
--enable-components Server,MySQL,Agent,Statsmon 
--db_hostname 127.0.0.1 --db_port 3306 
--tomcat_http_port 80 --tomcat_shutdown_port 8005
--tomcat_username admin --tomcat_password admin --tomcat_username2 admin --tomcat_password2 admin
--register_agent 1 --bundle_oracle_driver 1 --bundle_teradata_driver 1 --bundle_sqlserver4_driver 1 --bundle_ase_driver 1 --bundle_flatfile_driver 1 
--register_statsmon 1 
--custommemoryconfig 1 --MySQLMemoryValue 8192 --TomcatMemoryValue 8192 --AgentMemoryValue 4096 
--installdir "/opt/QuerySurge"
--feature_code_field_group no_feature_code
--sampleDataFlag 1

Sample Multi-Machine Installation (64-bit Linux installer)

Database Machine (No Agent)

The following command will install the QuerySurge database in the default (Linux) location.

sudo ./querysurge-installer-X.Y.Z-linux-x64.run --mode unattended 
--enable-components MySQL,Statsmon --disable-components Server,Agent
--db_hostname 127.0.0.1 --db_port 3306 
--tomcat_username admin --tomcat_password admin --register_statsmon 1 
--custommemoryconfig 1 --MySQLMemoryValue 8192 --installdir "/opt/QuerySurge"
--sampleDataFlag 1

Note: Since your Tomcat instance (most likely) does not yet exist, the server hostname and port will need to be manually entered in the statsmon configuration file. If installed in the default location, this file is located at /opt/QuerySurge/statsmon/config/statsmonconfig.xml. The qsserverurl parameter will need to be set in the form <protocol>://<host>:<port>. Once set, the statsmon service will need to be restarted for the changes to take effect.

Application Server Machine (No Agent)

 This command installs the QuerySurge App Server in the default (Linux) location.

sudo ./querysurge-installer-X.Y.Z-linux-x64.run --mode unattended 
--enable-components Server 
--disable-components MySQL,Agent,Statsmon
--db_hostname 192.168.0.70 --db_port 3306 
--tomcat_http_port 80 --tomcat_shutdown_port 8005 --tomcat_username2 admin --tomcat_password2 admin 
--register_agent 0 --register_statsmon 1
--custommemoryconfig 1 --TomcatMemoryValue 8192
--installdir "/opt/QuerySurge"
--feature_code_field_group no_feature_code

Note: The --db_hostname value will need to be replaced with the hostname or IP address of your database server. --db_port will also need to be altered if a non-default port was specified during the database installation.

Database and Application Server Machine (No Agent)

This command installs the QuerySurge Database and App Server in the default (Linux) location.

sudo ./querysurge-installer-X.Y.Z-linux-x64.run --mode unattended 
--enable-components MySQL,Server,Statsmon --disable-components Agent
--db_hostname 127.0.0.1 --db_port 3306 
--tomcat_username admin --tomcat_password admin --tomcat_username2 admin --tomcat_password2 admin --tomcat_http_port 80 --tomcat_shutdown_port 8005 
--register_agent 0 --register_statsmon 1 
--custommemoryconfig 1 --MySQLMemoryValue 8192 --TomcatMemoryValue 8192 
--installdir "/opt/QuerySurge" --feature_code_field_group no_feature_code
--sampleDataFlag 1

Agent

This command installs a QuerySurge Agent in the default (Linux) location.

sudo ./querysurge-installer-X.Y.Z-linux-x64.run --mode unattended 
--enable-components Agent,Statsmon --disable-components Server,MySQL
--register_agent 1 --register_statsmon 1
--db_hostname 192.168.0.70 --db_port 3306 
--agent_server_hostname 192.168.0.140 --agent_server_port 80 --tomcat_shutdown_port 8005 --tomcat_username admin --tomcat_password admin 
--bundle_oracle_driver 1 --bundle_teradata_driver 1 --bundle_sqlserver4_driver 1 --bundle_ase_driver 1 --bundle_flatfile_driver 1 
--custommemoryconfig 1 --AgentMemoryValue 4096 --installdir "/opt/QuerySurge"

Note: When installing only the Agent component, you will need to enable the Agent in the QuerySurge UI. You may also need to manually register the Agent in the QuerySurge UI. For instructions on how to do so, consult the Registering an Agent with QuerySurge section of this article.

Windows Installations

The sample commands below are for Windows distributions of the QuerySurge installer. Any commands should be executed as an Administrator to ensure the installer has the appropriate permissions. The installer name shows “X.Y.Z” for the QuerySurge version – you will need to replace this with the actual version numbers.

Sample Full Installation (64 bit Windows installer)

This command installs QuerySurge (single platform install), including all of the bundled drivers, using the default HTTP and database ports, in the default (Windows) location.

querysurge-installer-X.Y.Z-windows-x64.exe --mode unattended 
--enable-components Server,MySQL,Agent,Statsmon 
--db_hostname 127.0.0.1 --db_port 3306 
--tomcat_http_port 80 --tomcat_shutdown_port 8005
--tomcat_username admin --tomcat_password admin --tomcat_username2 admin --tomcat_password2 admin
--register_agent 1 --bundle_oracle_driver 1 --bundle_teradata_driver 1 --bundle_sqlserver4_driver 1 --bundle_ase_driver 1 --bundle_flatfile_driver 1 
--register_statsmon 1 
--custommemoryconfig 1 --MySQLMemoryValue 8192 --TomcatMemoryValue 8192 --AgentMemoryValue 4096 
--installdir "C:\Program Files\QuerySurge"
--feature_code_field_group no_feature_code
--sampleDataFlag 1

Sample Multi-Machine Installation (64-bit Windows installer)

Database Machine (No Agent)

This command installs the QuerySurge Database in the default (Windows) location.

querysurge-installer-X.Y.Z-windows-x64.exe --mode unattended 
--enable-components MySQL,Statsmon --disable-components Server,Agent
--db_hostname 127.0.0.1 --db_port 3306 
--tomcat_username admin --tomcat_password admin --register_statsmon 1 
--custommemoryconfig 1 --MySQLMemoryValue 8192 --installdir "C:\Program Files\QuerySurge"
--sampleDataFlag 1

Application Server Machine (No Agent)

This command installs the QuerySurge Tomcat server in the default (Windows) location.

querysurge-installer-X.Y.Z-windows-x64.exe --mode unattended 
--enable-components Server --disable-components MySQL,Agent,Statsmon
--db_hostname 192.168.0.70 --db_port 3306 
--tomcat_http_port 80 --tomcat_shutdown_port 8005 --tomcat_username2 admin --tomcat_password2 admin 
--register_agent 0 --register_statsmon 1
--custommemoryconfig 1 --TomcatMemoryValue 8192
--installdir "C:\Program Files\QuerySurge"
--feature_code_field_group no_feature_code

Database and Application Server Machine (No Agent)

This command installs the QuerySurge Database and App Server in the default (Windows) location.

querysurge-installer-X.Y.Z-windows-x64 --mode unattended 
--enable-components MySQL,Server,Statsmon --disable-components Agent
--db_hostname 127.0.0.1 --db_port 3306 
--tomcat_username admin --tomcat_password admin --tomcat_username2 admin --tomcat_password2 admin --tomcat_http_port 80 --tomcat_shutdown_port 8005 
--register_agent 0 --register_statsmon 1 
--custommemoryconfig 1 --MySQLMemoryValue 8192 --TomcatMemoryValue 8192 
--installdir "C:\Program Files\QuerySurge" --feature_code_field_group no_feature_code
--sampleDataFlag 1

Agent Server Machine

This command installs QuerySurge Agent including all of the bundled drivers in the default (Windows) location

querysurge-installer-X.Y.Z-windows-x64.exe --mode unattended 
--enable-components Agent,Statsmon --disable-components Server,MySQL
--register_agent 1 --register_statsmon 1
--db_hostname 192.168.0.70 --db_port 3306 
--agent_server_hostname 192.168.0.140 --tomcat_http_port 80 --tomcat_shutdown_port 8005 --tomcat_username admin --tomcat_password admin 
--bundle_oracle_driver 1 --bundle_teradata_driver 1 --bundle_sqlserver4_driver 1 --bundle_ase_driver 1 --bundle_flatfile_driver 1 
--custommemoryconfig 1 --AgentMemoryValue 4096 --installdir "C:\Program Files\QuerySurge"

Reference

The full list of options, potential values, and descriptions for each option are listed below. 

Main Usage

Option	Values	Description
--help		Outputs all commands and their descriptions.
--version		Outputs the version of the installer.
--unattendedmodeui <value>	none minimal minimalWithDialogs	Select the command line UI that will display during installation. Default value is none.
--optionfile <filename>		Rather than providing a list of options, these can be defined in a file and passed into the installer.
--mode <mode>	gtk xwindow text unattended	The installation mode that the installer will run in. The default mode is gtk.
--debugtrace <filename>		Outputs any debug information to a file.
--enable-components <list_of_components>	MySQL Server Agent CLI Connectors AdminTool	A comma separated list of components that will be installed. The default value is MySQL,Server,Agent
--disable-components <list_of_components>	MySQL Server Agent CLI Connectors AdminTool	A comma separated list of components that will not be installed. The default value is CLI,Connectors,AdminTool
--installer-language <language>	en	The language of the installer. The default value is en.
--prefix <path>		The location of the QuerySurge install directory. The default value for Linux is /opt/QuerySurge. The default value for Windows is C:/Program Files/QuerySurge
--service_install <boolean>	0 1	Indicate whether you would like to install QuerySurge as a service. Default value is 1 (yes).
--custommemoryconfig <boolean>	0 1	Indicate whether you would like use a custom memory configuration. Default value is 0 (no).
--sampleDataFlag <boolean>	0 1	Indicate whether you would like to add the Tutorial + Sample data to the default project

Driver Options

When installing an Agent, you can specify which drivers you would like to deploy during the installation. These options do not need to be included and marked false when omitting drivers, simply omitting the option will not deploy the driver during an installation.

Option	Values	Description
--bundle_oracle_driver <boolean>	0 1	Deploys the Oracle (ojdbc7) driver.
--bundle_teradata_driver <boolean>	0 1	Deploys the Teradata (terajdbc4) driver.
--bundle_ase_driver <boolean>	0 1	Deploys the SAP ASE (jTDS 1.3.1) driver.
--bundle_flatfile_driver <boolean>	0 1	Deploys the Flat File and XML (JStels) driver.
--bundle_bi_driver <boolean>	0 1	Deploys the QuerySurge BI Tester driver.
--bundle_sqlserver4_driver <boolean>	0 1	Deploys the MS SQL Server (sqljdbc 4.2) driver.
--bundle_ssas_driver <boolean>	0 1	Deploys the SSAS (Olap4j) driver.
--bundle_redshift_driver <boolean>	0 1	Deploys the Amazon Redshift driver.
--hadoop_driver_choice <driver_choice>	none bundle_apache_hive_1_2_1_driver bundle_hortonworks_2_3_driver bundle_cloudera_5_5_driver	Deploys the specified Hive driver.
--bundle_vertica_driver <boolean>	0 1	Deploys the Vertica (9.1.0) driver.
--bundle_qsexcel_driver <boolean>	0 1	Deploys the QuerySurge Excel driver.