The graphs for the Postfix application are blank. Any help you are able to provide is greatly appreciated.
Mail server to be monitored is Postfix
mail_version = 3.4.13
I run the following command to troubleshoot.
./poller.php -h mail1 -d
Load poller module applications
SQL[SELECT * FROM applications WHERE device_id = ? [383] 0.25ms]
SNMP[‘/usr/bin/snmpbulkwalk’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-Oqv’ ‘-M’ ‘/opt/librenms/mibs’ ‘udp:HOSTNAME:161’ ‘.1.3.6.1.4.1.8072.1.3.2.3.1.2.5.109.97.105.108.113’]
No Such Instance currently exists at this OID
Invalid snmp_walk() data = No Such Instance currently exists at this OID
SNMP[‘/usr/bin/snmpbulkwalk’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-Oqv’ ‘-M’ ‘/opt/librenms/mibs’ ‘udp:HOSTNAME:161’ ‘.1.3.6.1.4.1.8072.1.3.2.3.1.2.15.112.111.115.116.102.105.120.100.101.116.97.105.108.101.100’]
No Such Instance currently exists at this OID
Invalid snmp_walk() data = No Such Instance currently exists at this OID
RRD[update mail1/app-postfix-5.rrd N:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U --daemon unix:/var/run/rrdcached.sock]
SQL[UPDATE applications set app_state=?,app_status=?,timestamp=NOW() WHERE app_id = ? [“UNKNOWN”,“”,5] 1.23ms]
SQL[SELECT * FROM application_metrics WHERE app_id=? [5] 0.35ms]
: …
Runtime for poller module ‘applications’: 0.0548 seconds with 24912 bytes
SNMP: [2/0.05s] MySQL: [3/0.00s] RRD: [2/0.00s]
Unload poller module applications
RRD[update mail1/poller-perf-applications.rrd N:0.054781913757324 --daemon unix:/var/run/rrdcached.sock]
Modules status: Global-
OS
Device
Module [ mib ] disabled globally.
Modules status: Global+
OS-
Device
Module [ stp ] disabled on os.
Modules status: Global+
OS
Device
Load poller module ntp
Runtime for poller module ‘ntp’: 0.0001 seconds with 400 bytes
SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [1/0.00s]
Unload poller module ntp
RRD[update mail1/poller-perf-ntp.rrd N:0.00011706352233887 --daemon unix:/var/run/rrdcached.sock]
Modules status: Global-
OS
Device
Module [ loadbalancers ] disabled globally.
Modules status: Global-
OS
Device
Module [ mef ] disabled globally.
Modules status: Global+
OS
Device
Load poller module mpls
Runtime for poller module ‘mpls’: 0.0003 seconds with 24112 bytes
SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [1/0.00s]
Unload poller module mpls
RRD[update mail1/poller-perf-mpls.rrd N:0.00034809112548828 --daemon unix:/var/run/rrdcached.sock]
RRD[update mail1/ping-perf.rrd N:1.57 --daemon unix:/var/run/rrdcached.sock]
RRD[update mail1/poller-perf.rrd N:1.814 --daemon unix:/var/run/rrdcached.sock]
Enabling graphs: SQL[select * from device_graphs where device_graphs.device_id = ? and device_graphs.device_id is not null [383] 0.32ms]
SQL[UPDATE devices set uptime=?,last_ping=NOW(),last_ping_timetaken=?,last_polled=NOW(),last_polled_timetaken=? WHERE device_id = ? [3387065,1.5700000000000001,1.8140000000000001,383] 3.46ms]
Updating mail1
Polled in 1.814 seconds
Start Device Groups
SQL[select * from devices where devices.device_id = ? limit 1 [383] 0.6ms]
SQL[select * from device_groups 0.27ms]
SQL[select devices.device_id, device_group_device.device_group_id as pivot_device_group_id, device_group_device.device_id as pivot_device_id from devices inner join device_group_device on devices.device_id = device_group_device.device_id where device_group_device.device_group_id in (1, 2, 3, 4) 0.79ms]
SQL[select exists(select * from devices where (devices.os REGEXP ?) and devices.device_id = ?) as exists [“Windows”,383] 0.23ms]
SQL[select exists(select * from devices where (devices.os = ?) and devices.device_id = ?) as exists [“Linux”,383] 0.2ms]
SQL[select exists(select * from devices where (devices.os = ?) and devices.device_id = ?) as exists [“VMware”,383] 0.2ms]
SQL[select * from device_group_device where device_group_device.device_id = ? [383] 0.33ms]
Groups Added:
Groups Removed:
End Device Groups, runtime: 0.0094s
Start Alerts
SQL[select exists(select * from alert_schedule where (start <= ? and end >= ? and (recurring = ? or (recurring = ? and ((time(start) < time(end) and time(start) <= ? and time(end) > ?) or (time(start) > time(end) and (time(end) <= ? or time(start) > ?))) and (recurring_day like ? or recurring_day is null)))) and (exists (select * from devices inner join alert_schedulables on devices.device_id = alert_schedulables.alert_schedulable_id where alert_schedule.schedule_id = alert_schedulables.schedule_id and alert_schedulables.alert_schedulable_type = ? and alert_schedulables.alert_schedulable_id = ?) or exists (select * from device_groups inner join alert_schedulables on device_groups.id = alert_schedulables.alert_schedulable_id where alert_schedule.schedule_id = alert_schedulables.schedule_id and alert_schedulables.alert_schedulable_type = ? and alert_schedulables.alert_schedulable_id in (?)) or exists (select * from locations inner join alert_schedulables on locations.id = alert_schedulables.alert_schedulable_id where alert_schedule.schedule_id = alert_schedulables.schedule_id and alert_schedulables.alert_schedulable_type = ? and alert_schedulables.alert_schedulable_id = ?))) as exists [“2021-09-21T19:55:27.785549Z”,“2021-09-21T19:55:27.785549Z”,0,1,“19:55:27”,“19:55:27”,“19:55:27”,“19:55:27”,“%”,“device”,383,“device_group”,2,“location”,14] 0.56ms]
SQL[select * from devices where devices.device_id = ? limit 1 [383] 0.35ms]
SQL[SELECT DISTINCT a.* FROM alert_rules a
LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?)
LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?))
LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?))
LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
WHERE a.disabled = 0 AND (
(d.device_id IS NULL AND g.group_id IS NULL)
OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL))
) [383,383,383,383,383,383,383,383] 0.97ms]
Rule #1 (Devices up/down):
SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [383] 0.32ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,383] 0.19ms]
Status: NOCHG
Rule #12 (State Sensor Critical):
SQL[SELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 [383] 0.5ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [12,383] 0.19ms]
Status: NOCHG
End Alerts
./poller.php mail1 2021-09-21 15:55:27 - 1 devices polled in 2.057 secs
SNMP [34/0.71s]: Get[8/0.17s] Getnext[4/0.06s] Walk[22/0.47s]
MySQL [35/0.04s]: Cell[3/0.00s] Row[-3/-0.00s] Rows[15/0.01s] Column[1/0.00s] Update[18/0.03s] Insert[1/0.00s] Delete[0/0.00s]
RRD [85/0.01s]: Update[85/0.01s]
-bash-4.2$