Chat now with support
Chat with Support

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

Before Installing Foglight Installing Foglight
Preparing to install Installing a new version of the Management Server Installed directories Foglight settings HP patch checking tool Uninstalling Foglight Upgrading the Management Server Installing Foglight FAQ
Running the Management Server Installing and Upgrading Cartridges Installing Agents

External MySQL database access for remote users

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:
1
From the MySQL Server Instance Configuration dialog box, select the Modify Security Settings check box.
2
Type a new root password (this password is used when executing the GRANT ALL ON query executed below).
3
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
Directory
Contents

bin

Foglight executables for running the server and utilities.

cartridge

Installed cartridge files in their original form.

client

Files that client programs (such as the command-line client) use for remote access to Foglight.

compat

Cartridge files: Core-HostServices-compatibility-5_9_x.car

and FTR-WS-1_0_0.car

config

Configuration files and subdirectories.

The files in the config directory contain settings that are most likely to require editing. Files at the next level are less likely to need changing. Files at the lowest level contain settings that are unlikely to need changing except in special circumstances.

docs

HTML and PDF versions of the product documentation.

dtd

Descriptors for configuration files that can be imported into Foglight (for example, by installing a cartridge).

extension

Directory for extension cartridges (optional cartridges that are not installed by default).

fglam

Directories for the embedded Agent Manager.

jre

Version of the JRE (1.8) that Foglight uses.

lib

The Foglight JAR files.

license

The Foglight license file you install.

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).

logs

Default location of the log files that Foglight generates when it runs.

Generated at runtime.

postgresql

Default location for the embedded PostgreSQL® library.

If the embedded database is selected during installation, then the database is created, populated, and used for Foglight runtime.

To start the embedded database separately, without running Foglight, use these parameters:
[run|shutdown]Db.sh in <install-dir>/bin

scripts

SQL scripts and examples of the two types of Script Agents.

scripts/agent contains sample Type 1 and Type 2 Script Agent files. See the Administration and Configuration Guide for more information about Script Agents.

scripts/sql-templates contains SQL scripts to drop/create schema, or create/populate the database. The scripts included in this directory are specific to the type of database that you selected when installing Foglight.

server

JAR files and data files that a particular Foglight server variant uses (such as default).

state

Where the running state of Foglight is kept.

It includes the following sub-directories:

•
cartridge.exploded. A working directory for deploying cartridges. It contains files extracted from installed cartridges. This is the same data as in the corresponding CAR files, just unzipped. The contents change on cartridge redeployment, but should not change on server restart. Users should not modify this data (even if the server is not running).
•
postgresql-data. Default location for the embedded PostgreSQL® data.

support

Where support bundled archive information is stored.

tmp/cartridge.deployed

A working directory for deploying cartridges. This directory contains files extracted from cartridges for the current Management Server run. Contents may change on restart or cartridge redeployment.

This data can be deleted if the server is not running. The server re-creates what is necessary on restart.

tools

Various Foglight utilities.

UninstallerData

Files that the Foglight uninstaller uses.

upgrade

Directory that the installer uses.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating