This article explains whether Foglight can monitor the Sybase Database Error Log (Database_Error_Log_Details) using a remote MDA agent, clarifying requirements and limitations based on current product design and code.
Foglight can monitor the Sybase Database Error Log by querying the Sybase system table master..monErrorLog. Unlike backup server error log monitoring, this does not require direct filesystem access to the physical error log file on the database host. Some confusion exists because certain error log collections (like backup logs or error log size) may require local file access, leading to the belief that all error log monitoring needs local agents.
Foglight’s "Database_Error_Log" and "Database_Error_Log_Details" alarms and collections use SQL queries against master..monErrorLog to retrieve error events.
If the remote Foglight agent has network connectivity and sufficient permissions to the Sybase database, it can monitor the Database Error Log without being local to the host.
No direct file access is needed for this collection.
Note: Backup Server Error Log & Errorlog Size collections may require local access to the Sybase host’s filesystem and can be disabled or limited in remote agent scenarios. Remote backup error log monitoring was added to the Sybase MDA agent beginning in the 7.3.2.10 release.