Not sure completely what to look for - but here you go:
LibreNMS Poller
SQL[select migration from migrations order by id desc limit 1 0.31ms]
SQL[select count(*) as aggregate from migrations limit 1 0.2ms]
SQL[SELECT version() 0.2ms]
===================================
Version info:
Commit SHA: f37e28a5f2f7a1bc90de534ff951afc89531c24d
Commit Date: 1555120070
DB Schema: 2019_02_10_220000_add_dates_to_fdb (132)
PHP: 7.2.15-0ubuntu0.18.04.2
MySQL: 10.1.38-MariaDB-0ubuntu0.18.04.1
RRDTool: 1.7.0
SNMP: NET-SNMP 5.7.3
==================================DEBUG!
Updating os_def.cache…
Done
Override poller modules: applications
Starting polling run:
SQL[SELECT * FROM devices WHERE disabled = 0 AND hostname = ‘mysql.example.net’ ORDER BY device_id ASC 0.9ms]
SQL[SELECT * FROM devices_attribs WHERE device_id = ? [25] 0.19ms]
Hostname: mysql.example.net
Device ID: 25
OS: linux (unix)
[FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 mysql.example.net
array (
‘xmt’ => ‘3’,
‘rcv’ => ‘3’,
‘loss’ => ‘0’,
‘min’ => ‘0.58’,
‘max’ => ‘0.75’,
‘avg’ => ‘0.65’,
‘exitcode’ => 0,
)
SQL[INSERT IGNORE INTO device_perf (xmt,rcv,loss,min,max,avg,device_id,timestamp,debug) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) {“xmt”:“3”,“rcv”:“3”,“loss”:“0”,“min”:“0.58”,“max”:“0.75”,“avg”:“0.65”,“device_id”:25,“debug”:“”} 3.67ms]
SNMP Check response code: 0
Modules status: Global+
OS
Device
Load poller module core
SNMP[‘/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OQnUt’ ‘-m’ ‘SNMPv2-MIB’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell’ ‘udp:HOSTNAME:161’ ‘sysUpTime.0’ ‘sysLocation.0’ ‘sysContact.0’ ‘sysName.0’ ‘sysObjectID.0’ ‘sysDescr.0’]
...0 = 2761490
...0 = Location
...0 = Name
...0 = mysql
...0 = ..4.1.8
...0 = Linux mysql 4.15.0-46-generic #49-Ubuntu SMP Wed Feb 6 09:33:07 UTC 2019 x86_64
SNMP[‘/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OQnUst’ ‘-m’ ‘HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell’ ‘udp:HOSTNAME:161’ ‘snmpEngineTime.0’ ‘hrSystemUptime.0’]
snmpEngineTime.0 = 27615
hrSystemUptime.0 = 8394800
Uptime seconds: 83948
RRD[update mysql.example.net/uptime.rrd N:83948 --daemon unix:/var/run/rrdcached.sock]
Uptime: 23 hours 19 minutes 8 seconds
SQL[select * from locations where (location = ?) limit 1 [“Location”] 0.32ms]
Runtime for poller module ‘core’: 0.0235 seconds with 76592 bytes
SNMP: [2/0.02s] MySQL: [0/0.00s] RRD: [1/0.00s]
Unload poller module core
RRD[update mysql.example.net/poller-perf-core.rrd N:0.023543119430542 --daemon unix:/var/run/rrdcached.sock]
Modules status: Global+
OS
Device
Load poller module applications
SQL[SELECT * FROM applications WHERE device_id = ? [25] 0.41ms]
SNMP[‘/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-Ovq’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell’ ‘udp:HOSTNAME:161’ ‘.1.3.6.1.4.1.8072.1.3.2.3.1.2.5.109.121.115.113.108’]
“a0:0
a1:0
a2:0
a3:0
a4:3
a5:803329
a6:0
a7:2
a8:0
a9:0
aa:8192
ab:6272
ac:1899
ad:0
ae:1718
af:181
ag:24067
ah:20147
ai:1989
aj:43100
ak:15536
al:0
am:0
an:18446744073709551614
ao:-1
ap:0
aq:0
ar:-1
as:0
at:0
au:0
av:0
aw:0
ax:131
ay:0
az:111
b0:3
b1:5448
b2:2
b3:46028
b4:0
b5:195
b6:0
b7:2
b8:794
b9:818
ba:4000
bb:10000
bc:4000
bd:0
be:191
bf:4
bg:0
bh:2
bi:2
bj:4
bk:2
bl:151
bm:9
bn:2179
bo:-1
bp:-1
bq:-1
br:-1
bs:0
bt:-1
bu:-1
bv:-1
bw:-1
bx:-1
by:-1
bz:-1
c0:-1
c1:-1
c2:22473
c3:5157
c4:3
c5:7412
c6:1401
c7:0
c8:0
c9:0
ca:0
cb:0
cc:0
cd:1
ce:0
cf:116
cg:0
ch:4888
ci:0
cj:27
ck:228
cl:198
cm:311
cn:0
co:6
cp:20595401
cq:2596541
cr:16777216
cs:0
ct:417261486
cu:417261486
cv:-1
cw:32768
cx:0
cy:5139
cz:139772672
d0:0
d1:0
d2:0
d3:0
d4:0
d5:0
d6:0
d7:0
d8:0
d9:0
da:0
db:0
dc:0
dd:0
de:0
df:0
dg:1
dh:2
di:21842
dj:1
dk:0
dl:10280
dm:5829
dn:26463
do:19211
dp:16
dq:131
dr:234216
ds:0
dt:0
du:0
dv:5450
dw:106333
dx:0
dy:0
dz:34679
e0:0
e1:-1
e2:-1
e3:0
e4:1
e5:0
e6:2
e7:-1
e8:-1
e9:-1
ea:-1
eb:-1
ec:-1
ed:-1
ee:-1
ef:-1
eg:0
eh:1529856
ei:8388608
ej:0
ek:0
ol:-1
om:-1
on:-1
oo:-1
op:-1
oq:-1
or:-1
os:-1
ot:-1
ou:-1
ov:-1
ow:-1
ox:-1
oy:-1
oz:-1
pg:-1
ph:-1
pi:-1
pj:-1
pk:-1
pl:-1
pm:-1
pn:-1
po:-1
pp:-1
pq:-1
pr:-1
ps:-1
pt:-1
pu:-1
pv:-1
pw:-1
px:-1
py:-1
pz:-1
qg:-1
qh:-1
qi:-1
qj:-1
qk:-1
ql:-1
qm:-1
qn:-1
qo:1718
qp:180881”
mysqlRRD[update mysql.example.net/app-mysql-24.rrd N:16777216:417261486:417261486:228:27:0:198:1989:43100:15536:20147:2:3:46028:5448:1718:181:24067:195:0:8192:1899:6272:0:4000:2:794:818:0:131:111:U:U:151:4:0:191:2:2179:803329:0:0:0:0:U:U:U:U:U:0:311:6:0:0:0:0:0:1.844674407371E+19:0:0:0:0:1:0:116:0:4888:0:2596541:20595401:1401:3:0:0:0:0:7412:5157:0 --daemon unix:/var/run/rrdcached.sock]
RRD[update mysql.example.net/app-mysql-24-status.rrd N:0:0:0:0:0:0:0:0:0:0:0:0:0:0:1:2 --daemon unix:/var/run/rrdcached.sock]
SQL[UPDATE applications set app_state=?,app_status=?,timestamp=NOW() WHERE app_id = ? [“OK”,“”,24] 3.32ms]
SQL[SELECT * FROM application_metrics WHERE app_id=? [24] 0.47ms]
: …SQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [195,193,24,“TLIe”] 9.72ms]
U…SQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [2179,2178,24,“Cs”] 10.67ms]
U…SQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [311,308,24,“CTMPTs”] 10.24ms]
U…SQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [4888,4883,24,“SSn”] 10.04ms]
U.SQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [2596541,2596186,24,“BRd”] 10.18ms]
USQL[UPDATE application_metrics set value=?,value_prev=? WHERE app_id=? && metric=? [20595401,20550013,24,“BSt”] 10.19ms]
U…
SNMP[‘/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-Oqv’ ‘-m’ ‘NET-SNMP-EXTEND-MIB’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell’ ‘udp:HOSTNAME:161’ ‘.1.3.6.1.4.1.8072.1.3.2.4.1.2.8.111.115.117.112.100.97.116.101.1’]
60
RRD[update mysql.example.net/app-os-updates-25.rrd N:60 --daemon unix:/var/run/rrdcached.sock]
SQL[UPDATE applications set app_state=?,app_status=?,timestamp=NOW() WHERE app_id = ? [“OK”,“60”,25] 3.11ms]
SQL[SELECT * FROM application_metrics WHERE app_id=? [25] 0.36ms]
: .
Runtime for poller module ‘applications’: 1.4800 seconds with 72392 bytes
SNMP: [2/1.41s] MySQL: [11/0.07s] RRD: [4/0.00s]
Unload poller module applications
RRD[update mysql.example.net/poller-perf-applications.rrd N:1.4799568653107 --daemon unix:/var/run/rrdcached.sock]
Start Device Groups
SQL[SELECT * FROM device_groups ORDER BY name 0.17ms]
SQL[SELECT device_group_id FROM device_group_device WHERE device_id=? [25] 0.15ms]
Groups Added:
Groups Removed:
End Device Groups
RRD[update mysql.example.net/ping-perf.rrd N:0.65 --daemon unix:/var/run/rrdcached.sock]
RRD[update mysql.example.net/poller-perf.rrd N:2.527 --daemon unix:/var/run/rrdcached.sock]
SQL[UPDATE devices set uptime=?,last_ping=NOW(),last_ping_timetaken=? WHERE device_id = ? [83948,“0.65”,25] 8.8ms]
Updating mysql.example.net
Polled in 2.527 seconds
Start Alerts
SQL[select * from devices where devices.device_id = ? limit 1 [25] 0.43ms]
SQL[select device_groups.*, device_group_device.device_id as pivot_device_id, device_group_device.device_group_id as pivot_device_group_id from device_groups inner join device_group_device on device_groups.id = device_group_device.device_group_id where device_group_device.device_id = ? [25] 0.22ms]
SQL[select exists(select * from alert_schedule inner join alert_schedulables on alert_schedule.schedule_id = alert_schedulables.schedule_id where ((recurring = ? and start <= NOW() and end >= NOW()) or (recurring = ? and (start_recurring_dt <= date_format(NOW(), ‘–%d’) and (end_recurring_dt >= date_format(NOW(), ‘–%d’) or end_recurring_dt is null or end_recurring_dt = ? or end_recurring_dt = ?)) and start_recurring_hr <= date_format(NOW(), ‘%H:%i:%s’) and end_recurring_hr >= date_format(NOW(), ‘%H:%i:%s’) and (recurring_day like CONCAT(‘%’, date_format(NOW(), ‘’), ‘%’) or recurring_day is null or recurring_day = ?))) and ((alert_schedulable_type = ? and alert_schedulable_id = ?) or (alert_schedulable_type = ? and 0 = 1))) as exists [0,1,“0000-00-00”,“”,“”,“device”,25,“device_group”] 0.6ms]
SQL[SELECT DISTINCT a.* FROM alert_rules a
LEFT JOIN alert_device_map d ON a.id=d.rule_id
LEFT JOIN alert_group_map g ON a.id=g.rule_id
LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [25,25] 0.26ms]
Rule #7 (Sensor over limit - Check Device Health Settings):
SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [25] 0.55ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [7,25] 0.17ms]
Status: NOCHG
Rule #8 (Sensor under limit - Check Device Health Settings):
SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors.sensor_limit_low AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [25] 0.5ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [8,25] 0.17ms]
Status: NOCHG
End Alerts
SQL[INSERT IGNORE INTO perf_times (type,doing,start,duration,devices,poller) VALUES (:type,:doing,:start,:duration,:devices,:poller) {“type”:“poll”,“doing”:“mysql.example.net”,“start”:1556214645.960983,“duration”:“2.699”,“devices”:1,“poller”:“nms”} 2.5ms]
./poller.php mysql.example.net 2019-04-26 00:50:48 - 1 devices polled in 2.699 secs
SNMP [5/1.44s]: Get[5/1.44s] Getnext[0/0.00s] Walk[0/0.00s]
MySQL [20/0.09s]: Cell[3/0.00s] Row[-3/-0.00s] Rows[8/0.00s] Column[1/0.00s] Update[9/0.08s] Insert[2/0.01s] Delete[0/0.00s]
RRD [8/0.00s]: Update[8/0.00s] Create [0/0.00s] Other[0/0.00s]