Foglight for Virtualization Enterprise Edition 8.9.3 - Installing Foglight on a UNIX System with an External PostgreSQL Database

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

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.

Option 2 - Run SQL scripts to configure the database

If you clicked Create during the database installation step, the SQL scripts in the<foglight_home>/scripts/sql directory are prepared with the provided configuration options. There are four SQL files for each database type ([dbtype]):

•

[dbtype]_drop_db.sql

•

[dbtype]_create_db.sql

•

[dbtype]_create_schema.sql

•

[dbtype]_populate_db.sql

You can review these scripts before running them.

You must run the configured scripts against the database using a third-party tool.

To perform manual database configuration:


	NOTE: After running the psql command, you will be prompted for the password. The first two commands you need to type the <DBA_username> password, and the last two commands you need to type the <foglight_username> password.