Foglight 5.9.3 - Installing Foglight on Windows with an External MySQL Database

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.

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 -Ddb.admin.user must exist, and must have database administrator privileges.

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

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.