Chat now with support
Chat with Support

Foglight 5.9.3 - 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

Installing Foglight FAQ

When I try to install Foglight with an external database using silent mode, Foglight generates a fatal error that states “Foglight Database Found: Installation canceled”. Why does this error occur?

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 like the following appears in the installation logs and the installation fails:

An existing Foglight database schema was found.
Cannot continue install. Run the installer in a GUI mode.
Database Install Failed
Foglight Database Found: Installation canceled.
 
Status: FATAL ERROR

If you encounter this error, either run the installer in GUI mode or drop the database manually. When you run the installer in GUI mode, a screen appears if an existing Foglight database schema is found. This screen allows you to keep your existing data, create a database, or select a different database. See Installing a new version of the Management Server for more information.

If it was not set by executing the GRANT ALL ON query, is there a way to manually set grant_priv to give users remote access to an external MySQL® database running with Foglight?

Yes. In some cases, executing the GRANT ALL ON query may not set grant_priv to y for the root user in the user table.

If grant_priv is missing for root@% after running the GRANT ALL query as described in “Executing the Grant All On Query Script” on page 24, follow the instructions below to manually set the required permission.

To update the user table to set grant_priv to the required value for the root user:
1
Login to MySQL as root:
mysql -u root -p <password>
In this command, replace <password> with the root password you specified in the procedure “To provide users with remote access to the database:” on page 24.
2
From the mysql prompt, run the following command to give grant_priv to root for your database:
GRANT ALL ON <database_name> TO 'root'@'%' IDENTIFIED BY <password> with grant option;
In this command, replace <database_name> with the database name you specified while installing Foglight and <password> with same root password you provided above.

 

Running the Management Server

The instructions in this section assume that you have already installed Foglight. If you have not, see Installing Foglight for installation instructions.

For more details, see these topics:

•
Manual database configuration
•
Initializing and tuning the database
•
Starting and stopping the Management Server
•
Logging in to Foglight
•
Running the Management Server FAQ

Manual database configuration

If you chose Manually create the repository database while installing the Management Server for use with an external database, there are two ways in which you can configure the database before starting the Management Server. Choose the one that best suits your needs:

•
Option 1 - Run the Foglight database tool to configure the database
•
Option 2 - Run SQL scripts to configure the database

Option 1 - Run the Foglight database tool to configure the database

Option 1 - Run the Foglight database tool to configure the database

Run Foglight’s database tool from the command line after exiting the installer. The database tool is located in the <foglight_home>/client/ directory.

 
To perform manual database configuration:
•
Create the database. Run the following command, including the -D parameters and values as required:
java [-D...] -jar foglight-database-tool.jar createdb
For example:
java -Dserver.database.type=mysql -Dserver.database.host=mysqldbhost01 ‑Dserver.database.port=3306 ‑Dserver.database.name=foglight ‑Ddb.admin.user=root ‑Ddb.admin.password=foglight ‑Ddb.schema.username=foglight ‑Ddb.schema.password=foglight ‑Ddb.schema.name=foglight ‑jar foglight-database-tool.jar createdb
The database tool requires the following parameters:
•
-Dserver.database.type=<mysql|sqlsrv|oracle|postgresql>
•
-Dserver.database.host
•
-Dserver.database.port
•
-Dserver.database.name
•
-Ddb.admin.user
 
* 
NOTE: The -Ddb.admin.user must exist, and must have database administrator privileges.
•
-Ddb.admin.password
•
-Ddb.schema.username
 
* 
NOTE: The tool creates the -Ddb.schema.username user when you run the command.
•
-Ddb.schema.password
•
-Ddb.schema.name
 
* 
NOTE: To delete the database and start over, run the database tool with the dropdb option instead of the createdb option shown in the preceding example.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating