You can also install s-Server from the command line, which does not display the graphical installation wizard. To do so, enter
sudo ./SQLstream-sServer-X.Y.Z-x64.run --mode text
where X.Y.Z represent the release and version numbers, as in SQLstream-<version>, and x64 or x32 represents running on a 64-bit or 32-bit operating system.
Note: substitute sStudio or clienttools to install either as a standalone in text mode.
if you are logged in as a super user, you do not need to include “sudo”.
The text-mode installer performs the same steps as the graphical one, but displays its prompts and messages in the console window.
By default, the installer will run in graphical mode, GTK. If this is not possible, it will run in xwindow mode.
If there is no graphical environment available it will fall back to text mode.
There are command-line options to perform nearly all of the functions available in the GUI version. For a list of the command-line options and their meanings, type
./<installername> --help
If the installation directory contains a previous installation of s-Server, the installer will ask you if you want to overwrite the directory. If you choose to do so, all customizations and catalog object definitions for the previous installation will be lost. You can choose to override this warning by appending –overwrite to the installer when you launch it.
You can also install in –mode unattended*. This mode installs with all default values. There are two required parameters: –email and –companyName. To run in unattended mode, enter a command along the following lines:
sudo ./SQLstream-sServer-<version>
.0-x64.run --mode unattended --email user@example.com --companyName Example
If the company name contains a space, you need to put it in quotation marks:
--companyName "SQLstream Inc."
You can also combine unattended mode with other options to provide a customized install. When you install in unattended mode, you are implicitly agreeing to the license agreement. The most likely options for one to use for an unattended server install would be the last ones listed by –help:
| Option | Description |
|---|---|
| Registration email. Required. | |
| –prefix <prefix> | Installation Directory. Defaults to /opt/sqlstream/<VERSION> |
| –catalogdir <catalogdir> | Catalog Directory. Defaults to /opt/sqlstream/<VERSION>/catalog |
| –createService <createService> | Whether or not a service, *sserverd, is created. |
| –overwrite | Asks installer to overwrite any existing installation. |
| –enable-components <enable-components> | Lets you specify components to be installed by entering a comma-separated list of components. Defaults to: Server, Plugins, corePlugins, Studio, Demo, clienttools, JDBC, SQLLine, datagen, ecdaagent, webagent, thirdparty, MSJDBC, OJDBC, TeradataJDBC, PostgresJDBC. Allowed Options: Server, Documentation, cassandra, hdfs, kinesis, snowflake, systemml, Studio, Demo, clienttools, SQLLine, datagen, ecdaagent, webagent, gbqconnector, thirdparty, MSJDBC, OJDBC, TeradataJDBC, PostgresJDBC |
| –disable-components <\disable-components> | Lets you specify components to not install by entering a comma-separated list of components. Defaults to: Documentation, cassandra, hdfs, kinesis, snowflake, systemml, gbqconnector. Allowed Options: Server, Documentation, cassandra, hdfs, kinesis, snowflake, systemml, Studio, Demo, clienttools, SQLLine, datagen, ecdaagent, webagent, gbqconnector, thirdparty, MSJDBC, OJDBC, TeradataJDBC, PostgresJDBC |
(These options correspond to the options in the GUI.)
| Option | Description |
|---|---|
| –optionfile <optionfile> | Installation option file |
| –mode <mode> | Installation mode. Defaults to gtk. Allowed: gtk xwindow text unattended |
| –installer-language <installer-language> | Language selection. Defaults to en. Allowed: sq ar es_AR pt_BR bg ca hr cs da nl en et fi fr de el he hu it ja ko lv lt no pl pt ro ru sr zh_CN sk sl es sv th zh_TW tr va cy |
| –prefix <prefix> | Installation Directory. Defaults to /opt/sqlstream/<VERSION> (depends on whether installer user is super user or not). |
| –defaultServer <defaultServer> | Name of the server on which s-Server is installed |
| Option | Description |
|---|---|
| –optionfile \ |
Installation option file |
| –mode <mode> | Installation mode. Allowed: gtk xwindow text unattended |
| –enable-components <enable-components> | Comma-separated list of components. Defaults to All. Allowed: SQLLine datagen ecdaagent logfileagent filewriteragent socketagent webagent gbqconnector |
| –disable-components <disable-components> | Comma-separated list of components. Defaults to none. Allowed: SQLLine datagen ecdaagent logfileagent filewriteragent socketagent webagent gbqconnector |
| –installer-language <installer-language> | Language selection. Defaults to en. Allowed: sq ar es_AR pt_BR bg ca hr cs da nl en et fi fr de el he hu it ja ko lv lt no pl pt ro ru sr zh_CN sk sl es sv th zh_TW tr va cy |
| –prefix <prefix> | Installation Directory. Defaults to /opt/sqlstream/<VERSION> (depends on whether installer user is super user or not). |
| –defaultServer <defaultServer> | Name of the server on which s-Server is installed. Required. |