Chatta subito con l'assistenza
Chat con il supporto

Foglight 5.9.2 - Installing Foglight on a UNIX System with an External PostgreSQL Database

Before Installing Foglight Installing Foglight 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.

 

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 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=postgresql -Dserver.database.host=postgresqlhost01
-Dserver.database.port=5432 -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.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione