Foglight 5.9.5 - Installing Foglight on a UNIX System with an External MySQL Database

Before installing Foglight with an external MySQL® database, the GRANT ALL ON query needs to be executed once in order to give users remote access to the database.

To provide users with remote access to the database:

From the MySQL Server Instance Configuration dialog box, select the Modify Security Settings check box.

Type a new root password (this password is used when executing the GRANT ALL ON query executed below).

Select the Enable root access from remote machines check box.

Executing the Grant All On Query script

Option 1

For better security, employ this option when the MySQL® instance is being used for more than one database.

To grant remote access to the MySQL Administrator account, create the database, and grant remote access to the database:

•

From the mysql prompt, type:

GRANT ALL ON mysql.* TO 'root'@'%' IDENTIFIED BY ‘<password>’ with grant option;

CREATE DATABASE <database_name> DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

GRANT ALL ON <database_name>.* to ‘root’@’%’ identified by ‘<password>’ with grant option;

Where <database_name> is the database name you will specify while installing Foglight and <password> is the root password you specified in the procedure “To provide users with remote access to the database,” above.

This gives the root user (with username root and password <password>) remote access with all privileges.

Option 2

Use this option only when the MySQL® instance is dedicated entirely to Foglight.

To grant remote access to the entire MySQL instance:

•

From the mysql prompt, type:

GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY ‘<password>’ with grant option;

Where <password> is the root password you specified in the procedure “To provide users with remote access to the database,” above.

This gives the root user (with username root and password <password>) remote access with all privileges.


	IMPORTANT: In some cases, following one of these options might not give grant_priv to the root user. If grant_priv is missing for root@% after executing the GRANT ALL ON query, see Installing Foglight FAQ for more information.

Embedded Agent Manager

An instance of the Agent Manager is automatically installed with new installations of the Management Server. This embedded Agent Manager instance runs on the Management Server machine. You can deploy agents to the embedded Agent Manager if you want to monitor the machine on which the Management Server runs.

In certain environments, Foglight starts and stops the embedded Agent Manager along with the Management Server by default. For more information about running the embedded Agent Manager, see the Agent Manager Guide.

You can run the embedded Agent Manager in tandem with the server or not. For more information, see the Agent Manager Guide.


	NOTE: Although the Foglight Agent Manager Adapter cartridge is installed by default with the embedded Agent Manager, you must install an Agent Manager cartridge that contains installers for your supported platforms, in order to deploy the Agent Manager to remote hosts. See the Agent Manager Guide for information about selecting an Agent Manager cartridge, downloading installers, and installing, configuring, and running the Agent Manager.

Installed directories

The following table describes the directories that are created under your target installation folder. They may vary, depending on the product features that you selected and the components installed for your platform.

Table 2. Installed directories

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

Foglight 5.9.5 - Installing Foglight on a UNIX System with an External MySQL Database

External MySQL database access for remote users

Executing the Grant All On Query script

Embedded Agent Manager

Installed directories