- librenms@LibreNMS:~$ ./poller.php -h Smokeping -d -v -m applications
- LibreNMS Poller
- SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.27ms]
- SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.25ms]
- SQL[select version() [] 0.24ms]
- ===================================
- Version info:
- Commit SHA: a2ad39a38694b9233792d3c3f76e9804e2c278d9
- Commit Date: 1641934858
- DB Schema: 2021_11_29_165436_improve_ports_search_index (229)
- PHP: 7.4.25
- MySQL: 10.5.12-MariaDB-0+deb11u1
- RRDTool: 1.7.2
- SNMP: 5.9
- ==================================DEBUG!
- Updating os_def.cache
- Override poller modules: applications
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'Smokeping' ORDER BY `device_id` ASC [] 0.53ms]
- SQL[select * from `devices` where `device_id` = ? limit 1 [11] 0.29ms]
- SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [11] 0.23ms]
- Attempting to initialize OS: proxmox
- Attempting to initialize Group OS: unix
- OS initialized: LibreNMS\OS\Shared\Unix
- Hostname: Smokeping
- Device ID: 11
- OS: proxmox
- Assigned IP: 10.146.68.4
- (unix)
- [FPING] '/usr/bin/fping' '-e' '-q' '-c' '2' '-p' '200' '-t' '200' '-O' '0' '10.146.68.4'
- response: xmt/rcv/%loss = 2/2/0%, min/avg/max = 0.021/0.037/0.053
- SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' '$Q0GLnG1DhzzNgc6C$sKGJwu' '-a' 'SHA' '-A' '$efjyExR81kNw!PBi#6AbRAx' '-u' 'LibreNMS' '-OQXUte' 'udp:10.146.68.4:161' 'SNMPv2-MIB::sysObjectID.0']
- SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.8072.3.2.10
- SQL[insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0.021,0.053,0.037,2,2,0,11,"2022-01-13 12:20:46"] 0.42ms]
- SQL[update `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0.037,11] 0.25ms]
- RRD[last Smokeping/ping-perf.rrd --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: 1642069200
- OK u:0.00 s:0.00 r:0.23
- RRD[update Smokeping/ping-perf.rrd N:0.037 --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [11] 0.29ms]
- Modules status: Global+
- OS
- Device
- #### Load poller module core ####
- SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' '$Q0GLnG1DhzzNgc6C$sKGJwu' '-a' 'SHA' '-A' '$efjyExR81kNw!PBi#6AbRAx' '-u' 'LibreNMS' '-OQXUte' '-On' 'udp:10.146.68.4:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0']
- .1.3.6.1.2.1.1.1.0 = Linux Smokeping 5.13.19-2-pve #1 SMP PVE 5.13.19-4 (Mon, 29 Nov 2021 12:10:09 +0100) x86_64
- .1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.8072.3.2.10
- .1.3.6.1.2.1.1.3.0 = 146434
- .1.3.6.1.2.1.1.5.0 = Smokeping
- SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' '$Q0GLnG1DhzzNgc6C$sKGJwu' '-a' 'SHA' '-A' '$efjyExR81kNw!PBi#6AbRAx' '-u' 'LibreNMS' '-OQXUte' 'udp:10.146.68.4:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0']
- SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 1464
- HOST-RESOURCES-MIB::hrSystemUptime.0 = 423918
- Uptime seconds: 4239
- RRD[last Smokeping/uptime.rrd --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: 1642069200
- OK u:0.00 s:0.00 r:0.27
- RRD[update Smokeping/uptime.rrd N:4239 --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: OK u:0.00 s:0.00 r:0.23
- Uptime: 1 hour 10 minutes 39 seconds
- SQL[update `devices` set `uptime` = ? where `device_id` = ? [4239,11] 0.29ms]
- >> Runtime for poller module 'core': 0.0461 seconds with 56976 bytes
- >> SNMP: [2/0.04s] MySQL: [1/0.00s] RRD: [2/0.00s]
- #### Unload poller module core ####
- RRD[last Smokeping/poller-perf-core.rrd --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: 1642069200
- OK u:0.00 s:0.00 r:0.28
- RRD[update Smokeping/poller-perf-core.rrd N:0.046087980270386 --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: OK u:0.00 s:0.00 r:0.27
- Modules status: Global+
- OS
- Device
- #### Load poller module applications ####
- SQL[SELECT * FROM `applications` WHERE `device_id` = ? [11] 0.23ms]
- Application: docker, app_id=23SNMP['/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' '$efjyExR81kNw!PBi#6AbRAx' '-u' 'LibreNMS' '-x' 'AES' '-X' '$Q0GLnG1DhzzNgc6C$sKGJwu' '-Oqv' '-m' 'NET-SNMP-EXTEND-MIB' '-M' '/opt/librenms/mibs' 'udp:10.146.68.4:161' 'nsExtendOutputFull.6.100.111.99.107.101.114']
- {"version":"1","data":[{"container":"smokeping","pids":23,"memory":{"used":"107.3MiB","limit":"512MiB","perc":"20.96%"},"cpu":"0.04%"}],"error":"0","errorString":""}
- RRD[last Smokeping/app-docker-23-smokeping.rrd --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: 1642069200
- OK u:0.00 s:0.00 r:1.90
- RRD[update Smokeping/app-docker-23-smokeping.rrd N:0.04:23:536870912:112512204:20.96 --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: OK u:0.00 s:0.00 r:0.27
- SQL[UPDATE `applications` set `app_state`=?,`app_status`=?,`timestamp`=NOW() WHERE `app_id` = ? ["OK","",23] 0.31ms]
- SQL[SELECT * FROM `application_metrics` WHERE app_id=? [23] 0.32ms]
- : SQL[UPDATE `application_metrics` set `value`=?,`value_prev`=? WHERE app_id=? && metric=? [0.04,0,23,"smokeping_cpu_usage"] 0.24ms]
- USQL[UPDATE `application_metrics` set `value`=?,`value_prev`=? WHERE app_id=? && metric=? [23,22,23,"smokeping_pids"] 0.25ms]
- U.SQL[UPDATE `application_metrics` set `value`=?,`value_prev`=? WHERE app_id=? && metric=? [112512204,112197632,23,"smokeping_mem_used"] 0.14ms]
- USQL[UPDATE `application_metrics` set `value`=?,`value_prev`=? WHERE app_id=? && metric=? [20.96,20.9,23,"smokeping_mem_perc"] 0.19ms]
- U
- Application: os-updates, app_id=22SNMP['/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' '$efjyExR81kNw!PBi#6AbRAx' '-u' 'LibreNMS' '-x' 'AES' '-X' '$Q0GLnG1DhzzNgc6C$sKGJwu' '-Oqv' '-m' 'NET-SNMP-EXTEND-MIB' '-M' '/opt/librenms/mibs' 'udp:10.146.68.4:161' '.1.3.6.1.4.1.8072.1.3.2.4.1.2.8.111.115.117.112.100.97.116.101.1']
- 0
- RRD[last Smokeping/app-os-updates-22.rrd --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: 1642069200
- OK u:0.00 s:0.00 r:2.91
- RRD[update Smokeping/app-os-updates-22.rrd N:0 --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: OK u:0.00 s:0.00 r:1.90
- SQL[UPDATE `applications` set `app_state`=?,`app_status`=?,`timestamp`=NOW() WHERE `app_id` = ? ["OK","0",22] 0.33ms]
- SQL[SELECT * FROM `application_metrics` WHERE app_id=? [22] 0.31ms]
- : .
- >> Runtime for poller module 'applications': 2.6328 seconds with 9960 bytes
- >> SNMP: [2/2.63s] MySQL: [9/0.02s] RRD: [6/0.00s]
- #### Unload poller module applications ####
- RRD[last Smokeping/poller-perf-applications.rrd --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: 1642069200
- OK u:0.00 s:0.00 r:2.91
- RRD[update Smokeping/poller-perf-applications.rrd N:2.6328229904175 --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: OK u:0.00 s:0.00 r:2.90
- RRD[last Smokeping/poller-perf.rrd --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: 1642069200
- OK u:0.00 s:0.00 r:2.91
- RRD[update Smokeping/poller-perf.rrd N:2.915 --daemon unix:/var/run/rrdcached.sock]
- RRDtool Output: OK u:0.00 s:0.00 r:2.91
- Polled in 2.915 seconds
- ### Start Device Groups ###
- SQL[select * from `device_groups` [] 0.15ms]
- SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [11] 0.18ms]
- Groups Added:
- Groups Removed:
- ### End Device Groups, runtime: 0.0027s ###
- #### Start Alerts ####
- 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` = ? [11] 0.25ms]
- SQL[select * from `locations` where `locations`.`id` = ? limit 1 [3] 0.21ms]
- SQL[select exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) 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 `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` ["2022-01-13T10:20:49.445397Z","2022-01-13T10:20:49.445397Z",0,1,"10:20:49","10:20:49","10:20:49","10:20:49","%","device",11,"location",3] 0.52ms]
- SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [11] 0.33ms]
- 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))
- ) [11,11,11,11,11,11,11,11] 0.71ms]
- #### End Alerts ####
- ./poller.php Smokeping 2022-01-13 12:20:49 - 1 devices polled in 3.084 secs
- SNMP [5/2.69s]: Snmpget[5/2.69s]
- SQL [29/0.10s]: Select[20/0.07s] Insert[1/0.00s] Update[8/0.02s]
- RRD [14/0.00s]: Other[7/0.00s] Update[7/0.00s]
- librenms@LibreNMS:~$
- ________________________________________________________________________________
- rrdtool graph /tmp/aptyyyTKhyRX6x77 --alt-autoscale-max --rigid -E --start 1641982500 --end 1642069134 --width 2559 --height 738 -c BACK\#EEEEEE00 -c SHADEA\#EEEEEE00 -c SHADEB\#EEEEEE00 -c CANVAS\#FFFFFF00 -c GRID\#292929 -c MGRID\#2f343e -c FRAME\#5e5e5e -c ARROW\#5e5e5e -R normal -c FONT\#bfc0c0 --font LEGEND:8:DejaVuSansMono --font AXIS:7:DejaVuSansMono --font-render-mode normal COMMENT:'Memory \(%\) Now Min Max Avg\\l' COMMENT:'\\l' DEF:mem_perc1=Smokeping/app-docker-23-smokeping.rrd:mem_perc:AVERAGE DEF:mem_perc1min=Smokeping/app-docker-23-smokeping.rrd:mem_perc:MIN DEF:mem_perc1max=Smokeping/app-docker-23-smokeping.rrd:mem_perc:MAX CDEF:mem_perc_cdef1=mem_perc1,100,/ CDEF:mem_perc_cdef1min=mem_perc1min,100,/ CDEF:mem_perc_cdef1max=mem_perc1max,100,/ LINE2:mem_perc_cdef1\#CC7CCC:'smokeping ' GPRINT:mem_perc_cdef1:LAST:%8.0lf%s GPRINT:mem_perc_cdef1min:MIN:%8.0lf%s GPRINT:mem_perc_cdef1max:MAX:%8.0lf%s GPRINT:mem_perc_cdef1:AVERAGE:'%8.0lf%s\\n' COMMENT:'\\n' --daemon unix:/var/run/rrdcached.sock
- _________________________________________________________________________________
- librenms@LibreNMS:~/rrd$ rrdtool graph /tmp/aptyyyTKhyRX6x77 --alt-autoscale-max --rigid -E --start 1641982500 --end 1642069134 --width 2559 --height 738 -c BACK\#EEEEEE00 -c SHADEA\#EEEEEE00 -c SHADEB\#EEEEEE00 -c CANVAS\#FFFFFF00 -c GRID\#292929 -c MGRID\#2f343e -c FRAME\#5e5e5e -c ARROW\#5e5e5e -R normal -c FONT\#bfc0c0 --font LEGEND:8:DejaVuSansMono --font AXIS:7:DejaVuSansMono --font-render-mode normal COMMENT:'Memory \(%\) Now Min Max Avg\\l' COMMENT:'\\l' DEF:mem_perc1=Smokeping/app-docker-23-smokeping.rrd:mem_perc:AVERAGE DEF:mem_perc1min=Smokeping/app-docker-23-smokeping.rrd:mem_perc:MIN DEF:mem_perc1max=Smokeping/app-docker-23-smokeping.rrd:mem_perc:MAX CDEF:mem_perc_cdef1=mem_perc1,100,/ CDEF:mem_perc_cdef1min=mem_perc1min,100,/ CDEF:mem_perc_cdef1max=mem_perc1max,100,/ LINE2:mem_perc_cdef1\#CC7CCC:'smokeping ' GPRINT:mem_perc_cdef1:LAST:%8.0lf%s GPRINT:mem_perc_cdef1min:MIN:%8.0lf%s GPRINT:mem_perc_cdef1max:MAX:%8.0lf%s GPRINT:mem_perc_cdef1:AVERAGE:'%8.0lf%s\\n' COMMENT:'\\n' --daemon unix:/var/run/rrdcached.sock
- 2640x835