Chat now with support
Chat with Support

Foglight 5.9.7 - Installing Foglight on Windows 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

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:

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.

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.

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:
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

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

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

NOTE: The tool creates the -Ddb.schema.username user when you run the command.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating