Foglight 5.9.5 - Installing Foglight on Windows with an External Microsoft SQL Server Database


	IMPORTANT: See the Administration and Configuration Guide for information about license requirements, managing licenses, and the different categories of cartridges (based on their license requirements).

Providing a license file during installation

You can install a license file during installation if you perform a Custom Install. See Step 13: Add Foglight license file in Installing a new version of the Management Server.

Importing a license file after installation

You can also import a license after installing Foglight. There are three ways of providing a license file to the Management Server after installation.

Using the manual process

•

Move an existing license file into the <foglight_home>\license folder.

Using the Foglight Administration module

•

Upload a license file using the Foglight Administration module. See the Administration and Configuration Guide for instructions.

Using the command line

Start the Foglight Management Server.

Ensure that JAVA_HOME is set.

If you have not already done so, extract the file fglcmd.zip in <foglight_home>\tools.

Upload a license by navigating to <foglight_home>\tools and entering the following command:

fglcmd -usr <username> -pwd <password> -cmd license:import ‑f <license_file>

The preceding command assumes that you are using the default port 8080 and localhost. If you are not running with these default values, use the following options to indicate server and port:

-port <xx> -srv <server_name>

For example, if you want to connect to the Management Server using the default HTTPS port, include the option -port 8443 with the fglcmd command.


	NOTE: See the Command-Line Reference Guide for information about running the fglcmd utility and the options that can be used with fglcmd, including additional license-management commands.

Installation modes

The default mode for the installer is the graphical user interface mode. However, in cases where a graphics display is not available, the Foglight installer can be started in command-line mode by using the console mode or silent mode.

Console mode

In console mode, the install instructions are in text format, but otherwise are the same as the graphical user interface install.

To execute the console mode, type the following command:

Windows® - Foglight only

Foglight-5_9_x-install_windows-x86_64.exe -i console

Windows® - Foglight Evolve

Foglight_Evolve-x_x_x-install_windows-x86_64.exe -i console

Silent mode

In silent mode, a properties file is used to feed in the installation parameters. The file consists of a list of key-value pairs, which are described in the following table.


	IMPORTANT: Silent mode does not work if you set parameters in the properties file for Foglight to connect to an external database, and an existing Foglight schema is present in that database. There is no Foglight silent installer parameter for using an existing database schema in order to prevent the contents of an existing database from being lost. If you attempt to run the silent installer using a properties file that specifies an external database where an existing Foglight schema is present, a fatal error appears in the installation logs. See Installing Foglight FAQ for more information about the error message and workarounds.

To run the installer in silent mode:

Foglight only

Foglight-5_9_x-install_windows-x86_64.exe -i silent

Foglight for Evolve only

Foglight-Evolve-x_x_x-install_windows-x86_64.exe -i silent

To use a specific properties file in silent mode, append the following option:

-f <fms_silent_install>.properties

The installer loads the specified properties file. When the file name and installer prefix are the same, the installer uses the properties automatically.


	NOTE: In certain configurations the Management Server uses ports in addition to the ones that you set using the silent installer; for example, when Foglight is running in High Availability (HA) mode. See the Administration and Configuration Guide for details.

The following table lists the properties available for configuring a silent installation, and their default values.

Table 1. Properties available for configuring a silent installation
Property	Description	Default
FMS_ADMIN_PASSWORD	Administrator password for Foglight.	foglight
FMS_CLUSTER_MCAST_PORT	Cluster Multicast port. Must be set to the same value for all Management Servers that are part of the same HA partition. See Configuring the cluster multicast port used in High Availability mode for more information about setting this port when running Foglight in HA mode.	45566
FMS_DB	Allows you to specify whether the database is embedded or external. Must be set to external if FMS_HA_MODE=1	embedded
FMS_DB_ADMIN_PASSWORD	Allows you to specify the password for the database administrator user account. This setting is not required if FMS_DB=embedded. Must be set to the same value for all Management Servers that are part of the same HA partition.	None.
FMS_DB_ADMIN_USER	Allows you to specify the database administrator user account. This setting is not required if FMS_DB=embedded. Must be set to the same value for all Management Servers that are part of the same HA partition.	foglight
FMS_DB_HOST	Allows you to specify the host name of the database machine. This setting is not required if FMS_DB=embedded. Must be set to the same value for all Management Servers that are part of the same HA partition.	127.0.0.1
FMS_DB_NAME	Allows you to specify the name of the Foglight database. This setting is not required if FMS_DB=embedded. Must be set to the same value for all Management Servers that are part of the same HA partition.	foglight
FMS_DB_PORT	Required. User-defined port or instance name for the database. Must be set to the same value for all Management Servers that are part of the same HA partition.	15432
FMS_DB_SETUPNOW	0 = Set up the database after installation is complete. 1 = Set up the database as part of the installation.	1
FMS_DB_TYPE	Specifies the database type. Must be set to the database type: (sqlsvr). This setting is not required if FMS_DB=embedded. Must be set to the same value for all Management Servers that are part of the same HA partition.	postgresql
FMS_DB_USER	Database user name. Must be set to the same value for all Management Servers that are part of the same HA partition.	foglight
FMS_DB_USER_PASSWORD	Database user password. Must be set to the same value for all Management Servers that are part of the same HA partition.	foglight
FMS_FEDERATION_PORT	Federation communication port.	1099
FMS_HA_MODE	0 = Run Foglight in standalone mode. 1 = Run Foglight in HA (High Availability) mode.	0
FMS_HA_PARTITION	High Availability (HA) partition name. Only required if FMS_HA_MODE=1. Must be set to the same value for all Management Servers that are part of the same HA partition.	FMS_HA
FMS_HTTP_PORT	HTTP port.	8080
FMS_HTTPS_ONLY	0 = Do not run Foglight in secure mode (HTTPS) only. 1 = Run Foglight in secure mode (HTTPS) only.	0
FMS_HTTPS_PORT	HTTPS port.	8443
FMS_LICENSE_AGREEMENT	License agreement acknowledgment.	yes
FMS_LICENSE_FILE	Allows you to add a license file by specifying the path to the license. NOTE: See the Administration and Configuration Guide for information about license requirements, managing licenses, and the different categories of cartridges (based on their license requirements).	None (the license file you specify is validated).
FMS_QP5APP_PORT	The port for an embedded query engine.	8448
FMS_RUN_NOW	Starts the Management Server at the end of the installation.	false
FMS_SERVICE	For enabling Foglight as a Windows® service.	false
FMS_UPGRADE	Only required to update an existing installation, in which case it must be set to 1.	1
INSTALLER_UI	The property is set to SILENT for silent mode. This setting is the default one and is mandatory.	SILENT
USER_INSTALL_DIR	The Foglight installation directory. If you want to upgrade an existing installation, specify the path to the existing installation directory here (and ensure that FMS_UPGRADE is set to 1).	None.
USER_SHORTCUTS	Sets the shortcut location.	None.
FMS_SERVICE_LINUX_ENABLED	For enabling Foglight as a Linux service, in which case it must be set to 1.	0
FMS_SERVICE_LINUX_VALID_PLATFORM	For enabling Foglight as a Linux service, in which case it must be set to true.	false
FMS_SERVICE_LINUX_RUN_USER	The username who is used to run the Foglight.	None.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight 5.9.5 - Installing Foglight on Windows with an External Microsoft SQL Server Database

Licensing

Installation modes

Console mode

Silent mode