Chat now with support
Chat with Support

Foglight 5.9.4 - Installing Foglight on Windows with an Embedded PostgreSQL Database

Before Installing Foglight Installing Foglight
Preparing to install Installing a new version of the Management Server Installed directories Foglight settings Uninstalling Foglight Upgrading the Management Server
Running the Management Server Installing and Upgrading Cartridges Installing Agents Appendix: Switching from an Embedded to an External Database

Agent installers

Agents that depend on the Agent Manager are installed using the remote installation procedure. See Remote agent installation and the Administration and Configuration Guide.

Some cartridges Foglight include one or more executable agent installers. The agent installers that are available for download are listed on the Components for Download dashboard. You can use the controls on this dashboard to download agent installers from the Management Server to a remote machine.

To download an agent installer:
1
On the navigation panel, under Dashboards, click Administration > Cartridges > Components for Download.
The Components for Download dashboard appears.
2
Click the name of the installer that you want to download.
3
Follow the on-screen instructions for each step of the installation process and specify the appropriate installation options.
 
* 
NOTE: For agents that are installed individually, run the agent installer executable and set up the agent on each machine you want to monitor with that type of agent.
The Agent Manager defines agents with their Agent Package name. When displayed in the Create Agent dialog, the agent names are prepended with the cartridge name.

Depending on the type of agent that you installed, you may need to edit its properties to configure it for the part of your environment that you want to monitor. For information about agent properties, see the Administration and Configuration Guide and the User Guide for the cartridge with which the agent was included.

Remote agent installation

You can install Foglight agents on any remote host on which the Agent Manager is installed. See the Agent Manager Guide.

For more information about remote agent installation, see the Administration and Configuration Guide.

 

Appendix: Switching from an Embedded to an External Database

You may find a performance improvement in Foglight if you use an external database.

This section describes how to migrate from using an embedded PostgreSQL® database with the Management Server to using an external PostgreSQL database.

1
Stop the Management Server.
2
Start the embedded database manually:
<foglight_home>\bin\runDb.sh
3
Export the database content:
<foglight_home>\postgresql\bin\pg_dump ‑U root -h localhost -p 15432 foglight > <foglight_home>/foglight_dump.sql
4
Shut down the database:
<foglight_home>\bin\shutdownDb.sh
5
Connect to the external PostgreSQL instance:
<foglight_home>\postgresql\bin\psql -h [postgresql host] -p [postgresql port] -U [superuser] [dbname]
6
Create the “foglight” user by running:
postgres=# CREATE USER "foglight" WITH PASSWORD 'foglight';
7
Re-import the data dump:
postgres=# \i <foglight_home>/foglight_dump.sql
 
* 
NOTE: You have to use slash in the path when executing this command on a Windows® platform. You may see some errors like in the following example:
psql:dump_db.sql:51991: ERROR: role "root" does not exist
psql:dump_db.sql:51992: ERROR: role "root" does not exist

It is safe to ignore these errors because the embedded database includes the super user root but the external may not.

Also, the foglight_dump.sql includes these two statements at the end of the file:

REVOKE ALL ON SCHEMA public FROM root;
GRANT ALL ON SCHEMA public TO root;
8
Configure the Management Server to use this new database by opening the following file:
<foglight_home>\config\server.config
9
Update the following values in the server.config file:
server.database.host = "[postgresql host]";
server.database.port = "[postgresql port]";
server.database.name = "[postgresql dbname]";
server.database.embedded = "false";
 
* 
NOTE: The server.database.password must also be updated if in Step 6 you set a different password than the embedded “foglight” user password.
10
Restart the Management Server.
11
Verify that the Management Server starts successfully:
a
Open the most recent Management Server log file in <foglight_home>\logs.
b
Look for the message Forge Server startup completed and ensure that there are no errors listed after it.
12
Verify that the Management Server connects to the migrated external PostgreSQL database. There are two ways to do so:
•
Open the most recent Management Server log file in <foglight_home>\logs. Verify that the parameter server.database.host lists your external PostgreSQL database host as its value and that server.database.embedded is set to false.
•
Log in to the browser interface and navigate to Dashboards > Administration > Setup & Support > Management Server Configuration. Verify that your external PostgreSQL database host is listed in the Database Host box and that Embedded is set to false.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating