Unattended Installation - Windows & Linux v2.5-v6.0

Versions:2.5 to 6.0

QuerySurge Unattended Installation: Using the Command Line

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.

Usage

Installer flag	Description	Default Value	Allowed Value(s)
--help	Display the list of valid options
--version	Display product informat
--unattendedmodeui	Unattended Mode UI	none	None,minimal,minimalWithDialogs
--mode	Installation mode	win32	win32,unattended
--enable-components	Comma-separated list of components	MySQL,Server,Agent,SampleData	MySQL,Server,Agent SampleData,CLI,Connectors
--disable-components	Comma-separated list of components	CLI,Connectors	MySQL,Server,Agent SampleData,CLI,Connectors
--prefix	Installation Directory	C:\Program Files/QuerySurge
--service_install	Install as a service?	1	1,0
--mysql_port	QuerySurge Database Port	3306
--tomcat_username	QuerySurge Admin Username
--tomcat_password	QuerySurge Admin Password
--user_tomcat_hostname	App Server Hostname or IP Address
--user_tomcat_http_port	App Server HTTP Port	80
--user_tomcat_hostname2	App Server Hostname or IP Address
--user_tomcat_http_port2	App Server HTTP Port	80
--tomcat_username2	QuerySurge Username
--tomcat_password2	QuerySurge Password
--tomcat_http_port	QuerySurge App Server HTTP Port	80
--tomcat_shutdown_port	QuerySurge App Server Shutdown Port	8005
--db_hostname	Hostname
--db_port	Port	3306
--bundle_oracle_driver	Oracle (ojdbc7)	0	1,0
--bundle_teradata_driver	Teradata (terajdbc4)	0	1,0
--bundle_ase_driver	SAP ASE (jTDS 1.3.1)	0	1,0
--bundle_flatfile_driver	Flat File and XML (JStels)	0	1,0
--bundle_sqlserver4_driver	MS SQL Server (sqljdbc 4.2)	0	1,0
--bundle_mysql_driver	MySQL (Connector/J 5.1.33)	0	1,0
--bundle_ssas_driver	SSAS (Olap4j)	0	1,0
--hadoop_driver_choice	Hadoop (Hive)		none, bundle_apache_hive_1_2_1_driver, bundle_hortonworks_2_3_driver, bundle_cloudera_5_5_driver
--agent_server_hostname	Hostname
--agent_server_port	Port	80
--register_agent	Test Agent Connection With Server	0	1,0

Sample Full Installation Command Line (64 bit Windows installer)

Note: the installer name shows “X.Y.Z” for the QuerySurge version – you will need to replace this with the actual version numbers.

Note: This command should be executed as an Admin user.

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,SampleData,Agent,Statsmon
--db_hostname localhost --db_port 3306 --tomcat_http_port 80
--tomcat_shutdown_port 8005 --bundle_oracle_driver 1
--bundle_teradata_driver 1 --bundle_sqlserver4_driver 1
--undle_mysql_driver 1 --bundle_ase_driver 1 --bundle_flatfile_driver 1
--register_agent 1 --register_statsmon 1 --tomcat_username admin
--tomcat_password admin --tomcat_username2 admin --tomcat_password2 admin
--installdir "C:\Program Files\QuerySurge"

Sample Full Installation Command Line (64 bit Linux installer)

Note: the installer name shows “X.Y.Z” for the QuerySurge version – you will need to replace this with the actual version numbers.

Note: This command should be executed as root or using sudo.

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

./querysurge-installer-X.Y.Z-linux-x64.run --mode unattended
--enable-components Server,MySQL,SampleData,Agent,Statsmon
--db_hostname 127.0.0.1 --db_port 3306 --tomcat_http_port 80
--tomcat_shutdown_port 8005 --bundle_oracle_driver 1
--bundle_teradata_driver 1 --bundle_sqlserver4_driver 1
--bundle_mysql_driver 1 --bundle_ase_driver 1 --bundle_flatfile_driver 1
--register_agent 1 --register_statsmon 1 --tomcat_username admin
--tomcat_password admin --tomcat_username2 admin --tomcat_password2 admin
--installdir "/opt/QuerySurge"

Sample Multiple Machine Installation Command Line (64 bit Windows installer)

Database Machine (no agent):

Note: the installer name shows “X.Y.Z” for the QuerySurge version – you will need to replace this with the actual version numbers.

Note: This command should be executed as root or using sudo.

This command installs 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,SampleData
--db_hostname 127.0.0.1 --db_port 3306
--register_agent 0 --register_statsmon 1 --tomcat_username admin
--tomcat_password admin --tomcat_username2 admin --tomcat_password2 admin
--installdir "C:\Program Files\QuerySurge"

App Server Machine (no agent):

Note: the installer name shows “X.Y.Z” for the QuerySurge version – you will need to replace this with the actual version numbers.

Note: the db_hostname must be the ip address or hostname of the QuerySurge database machine – you will need to replace this with the actual values.

Note: This command should be executed as root or using sudo.

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

querysurge-installer-X.Y.Z-windows-x64.exe --mode unattended
--enable-components Server
--disable-components MySQL,Agent,SampleData,Statsmon
--db_hostname 192.168.0.71 --db_port 3306 --tomcat_http_port 80
--tomcat_shutdown_port 8005
--register_agent 0 --tomcat_username admin --tomcat_password admin
--tomcat_username2 admin --tomcat_password2 admin
--installdir "C:\Program Files\QuerySurge"

Agent Machine:

Note: the installer name shows “X.Y.Z” for the QuerySurge version – you will need to replace this with the actual version numbers.

Note: This command should be executed as root or using sudo.

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
--disable-components Server,MySQL,SampleData,Statsmon
--db_hostname 192.168.0.71 --db_port 3306 --tomcat_http_port 80
--tomcat_shutdown_port 8005 --bundle_oracle_driver 1
--bundle_teradata_driver 1 --bundle_sqlserver4_driver 1
--bundle_mysql_driver 1 --bundle_ase_driver 1 --bundle_flatfile_driver 1
--register_agent 1 --register_statsmon 1 --tomcat_username admin
--tomcat_password admin --tomcat_username2 admin --tomcat_password2 admin
--installdir "C:\Program Files\QuerySurge"

Sample Full Installation Command Line (64 bit Linux installer)

Database Machine (no agent):

Note: the installer name shows “X.Y.Z” for the QuerySurge version – you will need to replace this with the actual version numbers.

Note: This command should be executed as root or using sudo.

This command installs QuerySurge Database in the default (Linux) location

./querysurge-installer-X.Y.Z-linux-x64.run --mode unattended
--enable-components MySQL,Statsmon
--disable-components Server,Agent,SampleData
--db_hostname 127.0.0.1 --db_port 3306
--register_agent 0 --register_statsmon 1 --tomcat_username admin
--tomcat_password admin --tomcat_username2 admin --tomcat_password2 admin
--installdir "/opt/QuerySurge"

App Server Machine (no agent):

Note: the installer name shows “X.Y.Z” for the QuerySurge version – you will need to replace this with the actual version numbers.

Note: the db_hostname must be the ip address or hostname of the QuerySurge database machine – you will need to replace this with the actual values.

Note: This command should be executed as root or using sudo.

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

./querysurge-installer-X.Y.Z-linux-x64.run --mode unattended
--enable-components Server
--disable-components MySQL,Agent,SampleData,Statsmon
--db_hostname 192.168.0.71 --db_port 3306 --tomcat_http_port 80
--tomcat_shutdown_port 8005
--register_agent 0 --tomcat_username admin --tomcat_password admin
--tomcat_username2 admin --tomcat_password2 admin
--installdir "/opt/QuerySurge"

Agent Machine:

Note: the installer name shows “X.Y.Z” for the QuerySurge version – you will need to replace this with the actual version numbers.

Note: This command should be executed as root or using sudo.

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

./querysurge-installer-X.Y.Z-linux-x64.run --mode unattended
--enable-components Agent
--disable-components Server,MySQL,SampleData,Statsmon
--db_hostname 192.168.0.71 --db_port 3306 --tomcat_http_port 80
--tomcat_shutdown_port 8005 --bundle_oracle_driver 1
--bundle_teradata_driver 1 --bundle_sqlserver4_driver 1
--bundle_mysql_driver 1 --bundle_ase_driver 1 --bundle_flatfile_driver 1
--register_agent 1 --register_statsmon 1 --tomcat_username admin
--tomcat_password admin --tomcat_username2 admin --tomcat_password2 admin
--installdir "/opt/QuerySurge"