PRTG version = 18.3.43.2323 Sensor = MySQL v2
DATABASE
We're monitoring a MariaDB RDS instance
SENSOR CONFIGS
- Data
- SQL Query File: custom-file.sql
- Handle DBNull in Channel Values as: Number 0
- Select Channel Value by: Column Number
- Sensor Channel #1 Name: Count
- Sensor Channel #1 Column Number: 0
- Sensor Channel #1 Unit: Count
- CHANNEL CONFIGS
- Limits: Enable alerting based on limits
- Upper Error Limit (#): 0
- SENSOR NOTIFICATION TRIGGERS
- State Trigger:
- When sensor state is Down: send alert
- When sensor state is Up: send alert
- State Trigger:
RESULTS / GOAL
- Custom-file.sql runs a select statement to get a count from a table
- The sql statement works and provides the correct value - we're simply running tests and updating the db to toggle the output to be expected
- the sensor is reporting the accurate count, and sending Down/Up alerts as expected
- the sensor is also reporting Red/Green correctly based on whether the count crosses limit
ISSUE
Channel graph color does not reset after alert clears.
The sensor resets to an Up status/Green, but, the channel graph remains Red.
This leads to a confusing visual when looking into the sensor specifically.
RESOURCES REFERENCED
- https://www.paessler.com/manuals/prtg/mysql_v2_sensor
- https://kb.paessler.com/en/topic/70618-how-to-setup-the-sql-v2-sensors-in-prtg-is-there-a-guide
- https://kb.paessler.com/en/topic/71779-how-can-i-monitor-mysql-performance-via-mysqlv2-sensor
- https://kb.paessler.com/en/topic/75786-monitoring-mysql-stat-s
- https://kb.paessler.com/en/topic/63259-how-can-i-monitor-strings-from-an-sql-database-and-show-a-sensor-status-depending-on-it
Add comment