Chat now with support
Chat with Support

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

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.

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:
•
Run the .sql scripts by issuing the following commands in the order shown:
a
mysql -u<DBA_username> -p<DBA_password> --force < <foglight_home>/scripts/mysql_drop_db.sql
 
* 
NOTE: When a user does not exist in the current database, the script generates “DROP USER failed” errors messages. These errors can be safely ignored.
b
mysql -u<DBA_username> -p<DBA_password> < <foglight_home>/scripts/mysql_create_db.sql
c
mysql -u<foglight_username> -p<foglight_password> < <foglight_home>/scripts/mysql_create_schema.sql
This script must be run using the Foglight Database Account User ID that you set in Step 10: Foglight repository database type. The default Foglight Database Account User ID is foglight.
d
mysql -u<foglight_username> -p<foglight_password> < <foglight_home>/scripts/mysql_populate_db.sql
This script must be run using the Foglight Database Account User ID that you set in Step 10: Foglight repository database type. The default Foglight Database Account User ID is foglight.

Example (for Foglight only):

a
mysql -uroot -ppassword --force <../Quest/Foglight/scripts/mysql_drop_db.sql
 
* 
NOTE: When a user does not exist in the current database, the script generates “DROP USER failed” errors messages. These errors can be safely ignored.
b
mysql -uroot -ppassword <../Quest/Foglight/scripts/mysql_create_db.sql
c
mysql -uroot -ppassword <../Quest/Foglight/scripts/mysql_create_schema.sql
d
mysql -uroot -ppassword <../Quest/Foglight/scripts/mysql_populate_db.sql

After you have run all four scripts, you can start the Management Server. Proceed to Starting and stopping the Management Server.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating