Foglight comes with several Rules out of the box, and some of them have an associated EmailAction action. ... Those can be customized to also execute a CommandAction action, which passes a specified command to the OS where the Foglight Management Server is running.
When trying to validate the type of connection being established by the Windows agents, the log file 001 for the agent can be reviewed for the keywords:
From Foglight web console, navigate to the Databases dashboard. ... Select all of the database agents of a single type (for example SQL Server) to change. ... Click Settings | Administration ... select Connection Details
An agent blackout or global blackout is configured during a maintenance window; no alarms are received while the blackout is active but once it ends many Credential Management Event alarms fire and get cleared automatically.
Foglight is unable to start when using MySQL 8.x as the external database; the errors in the Management Server log indicate that the connection is not using a password even though one is set in the server configuration file.
All other database related data is being collected. ... CAUSE 1 ... Within the agent configuration (viewed via the latest agent log file), the Top SQL collection appears to be disabled: ... CAUSE 3
How to configure email notifications when the FMS crashes or stops unexpectedly. ... <p>High Availability foglight can be used in conjuction with <a href="https://support.quest.com/technical-documents/foglight/7.1.0/high-availability-field-guide/4#TOPIC-2071242" target="_blank">Remote Monitor</a>
: Caused by: net.snowflake.client.jdbc.SnowflakeSQLLoggedException: Private key provided is invalid or not supported: X:\Quest\Foglight\fglam\Keys\SVC_SNOWFLAKE_FOGLIGHT.p8: PBE parameter parsing error: expecting the object identifier for AES cipher
How can a user test deadlocks and blocking in the SQL Server agent? ... Lock: is done by database when any connection accesses the same piece of data concurrently. ... One connection needs to access a piece of data .
Foglight is not picking up deadlock activity on a monitored SQL Server instance. ... Foglight generates an email notification or alarm advising a deadlock condition has occurred, but the Activity dashboard does not display any data indicating a deadlock has or is occurring.
Which Foglight Cartridge for SQL Server Availability/Usability alarms will fire against certain system status? <p>Below are the expected alarms to trigger when the monitored system is in a particular status.
DBSS_Databases collection times out with messages like the following in the agent log ... java.lang.RuntimeException: Failed to execute collection [DBSS_Database], reason=The query has timed out.
The SQL Server system was rebooted and no DBSS - Instance Availability alarm was fired from the Foglight SQL Server cartridge. ... <div> </div> <div>There could be also a situation in which a reboot take less then 5min which is the collection frequency.
Are there any alarms which notify when the Foglight database or server is having issues? ... What do alarms and email notifications regarding the "Catalyst" mean? ... The "Catalyst" alarms are related to the Foglight Management Server repository database or the server itself; for example:
A DB2 agent was installed using a DB2 user with SYSADM permissions, but it is not the instance owner. ... The permission check verified that user is sysadm and then skipped the permission check. ... When the DB2 agent was activated, missing permissions related errors were found in the agent log file and collections did not run.
Please increase the maximum number of Top SQL rows retrieved in the Sybase agent properties and restart the Agent. ... From Foglight UI go to: Administration | Agents | Agent Status ... Select the Agent in question
How can be Foglight be installed to monitor SQL Server database instances on hosts in a DMZ? <p>There are two options available to monitor a SQL Server host located in the DMZ outside of an internal firewall.</p> <ul><li>Install a Foglight Agent Manager in the DMZ and then have the FglAM communicate with the hosts also in the DMZ.
The Foglight Infrastructure Cartridge (IC) agent does not display the Windows network or mapped drive. ... Save and deactivate/activate the Windows agent.</p><p> </p><p>RESOLUTION 2:</p><p>Run wbemtest and execute the following WMI query.
For Oracle ASM monitoring using SSL the password file should be configured correctly. ... ASM (Automatic Storage Management) is a system used by Oracle to manage storage for databases. ... It requires a password file to securely control administrative access, particularly when connecting remotely or performing critical operations.
An error message similar to the following appears in the agent log file. ... ERROR [FglAM:IncomingMessage[5]-139] com.quest.qsi.fason.core.collection.RMISubmissionCollection - An exception occurred during the execution of a processor from com.quest.qsi.fason.sqlserver.collection.processor.DBSSRMICallbacklGeneralProcessor class.
After upgrading to 7.2.2.10 and higher, the username and password or service account that is running the FMS application is being passed to retrieve data from SQL PI instead of previously entered PI repository credentials.
Can a default database other than sybsystemprocs be used in the Sybase SAP ASE agent? ... The Sybase agent stored procedures are hardcoded to be written to sybsystemprocs. ... WORKAROUND ... None.
How to update SAML 2.0 hostname used in the metadata.xml if you need to use a custom DNS entry instead of the physical hostname.
In order to set up Statement monitoring in the PostgreSQL agent monitoring Azure Database for PostgreSQL you'll need to first follow these steps to enable the pg_stat_statements extension for collecting query statistics.
Investigating OS connection issues can be challenging when there are numerous credentials present in the FMS. ... This knowledgebase article describes some techniques to identify and resolve common OS credentials issues for Windows and Linux / Unix.
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center