- LibreNMS Poller
- ===================================
- Version info:
- Commit SHA: 9001b19ab92eee821f36276158368126a5602843
- Commit Date: 1521195733
- DB Schema: 245
- PHP: 7.0.25-0ubuntu0.16.04.1
- MySQL: 5.7.21-0ubuntu0.16.04.1
- RRDTool: 1.5.5
- SNMP: NET-SNMP 5.7.3
- ==================================DEBUG!
- Updating os_def.cache... Done
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'nec01-shw01-env.network' ORDER BY `device_id` ASC]
- SQL[SELECT * FROM devices_attribs WHERE `device_id` = '9']
- Hostname: nec01-shw01-env.network
- Device ID: 9
- OS: custom (akcp)
- SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','10.8','11.4','11.1','9',NOW())]
- 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 udp:HOSTNAME:16100 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0]
- .*.*.0 = 26365796
- .*.*.0 = Walliswood
- .*.*.0 = Rob Fitzgerald
- .*.*.0 = nec01-shw01-env
- .*.*.0 = .*.4.1.3854
- .*.*.0 = SP2+ 1.0.4080 Jan 19 2018 13:04:45
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 snmpEngineTime.0 hrSystemUptime.0]
- Uptime seconds: 263658
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/uptime.rrd N:263658]
- [RRD Disabled]Uptime: 3 days, 1h 14m 18s
- SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`='Walliswood' LIMIT 1]
- Using cached lat/lng from other device
- >> Runtime for poller module 'core': 0.0594 seconds with 16592 bytes
- >> SNMP: [2/0.06s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module core ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-core.rrd N:0.059412956237793]
- [RRD Disabled]Modules status: Global- OS Device Module [ unix-agent ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module os ####
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQv udp:HOSTNAME:16100 1.3.6.1.4.1.3854.1.1.6.0]
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQv udp:HOSTNAME:16100 1.3.6.1.4.1.3854.1.1.8.0]
- Hardware:
- Version:
- Features:
- Serial:
- >> Runtime for poller module 'os': 0.0330 seconds with 1888 bytes
- >> SNMP: [2/0.03s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module os ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-os.rrd N:0.032989025115967]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ipmi ####
- SQL[SELECT * FROM sensors WHERE device_id = '9' AND poller_type='ipmi']
- Array
- (
- )
- >> Runtime for poller module 'ipmi': 0.0007 seconds with 2464 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module ipmi ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-ipmi.rrd N:0.00073003768920898]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module sensors ####
- SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = '9' GROUP BY `sensor_class`]
- >> Runtime for poller module 'sensors': 0.0003 seconds with 1336 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module sensors ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-sensors.rrd N:0.00034308433532715]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module processors ####
- Attempting to initialize OS: custom
- Attempting to initialize OS: akcp
- OS initilized as Generic
- SQL[SELECT * FROM processors WHERE device_id='9']
- >> Runtime for poller module 'processors': 0.0018 seconds with 155656 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module processors ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-processors.rrd N:0.0017859935760498]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module mempools ####
- SQL[SELECT * FROM mempools WHERE device_id = '9']
- >> Runtime for poller module 'mempools': 0.0005 seconds with 1760 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module mempools ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-mempools.rrd N:0.00048398971557617]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module storage ####
- SQL[SELECT * FROM storage WHERE device_id = '9']
- >> Runtime for poller module 'storage': 0.0004 seconds with 1824 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module storage ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-storage.rrd N:0.00038313865661621]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module netstats ####
- IPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 IP-MIB::ipForwDatagrams.0 IP-MIB::ipInDelivers.0 IP-MIB::ipInReceives.0 IP-MIB::ipOutRequests.0 IP-MIB::ipInDiscards.0 IP-MIB::ipOutDiscards.0 IP-MIB::ipOutNoRoutes.0 IP-MIB::ipReasmReqds.0 IP-MIB::ipReasmOKs.0 IP-MIB::ipReasmFails.0 IP-MIB::ipFragOKs.0 IP-MIB::ipFragFails.0 IP-MIB::ipFragCreates.0 IP-MIB::ipInUnknownProtos.0 IP-MIB::ipInHdrErrors.0 IP-MIB::ipInAddrErrors.0]
- ipForwDatagrams.0 = 0
- ipInDelivers.0 = 250833
- ipInReceives.0 = 250836
- ipOutRequests.0 = 286428
- ipInDiscards.0 = 3
- ipOutDiscards.0 = 0
- ipOutNoRoutes.0 = 0
- ipReasmReqds.0 = 0
- ipReasmOKs.0 = 0
- ipReasmFails.0 = 0
- ipFragOKs.0 = 0
- ipFragFails.0 = 0
- ipFragCreates.0 = 0
- ipInUnknownProtos.0 = 0
- ipInHdrErrors.0 = 0
- ipInAddrErrors.0 = 3
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/netstats-ip.rrd N:0:250833:250836:286428:3:0:0:0:0:0:0:0:0:0:0:3]
- [RRD Disabled] TCPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m TCP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 TCP-MIB::tcpActiveOpens.0 TCP-MIB::tcpPassiveOpens.0 TCP-MIB::tcpAttemptFails.0 TCP-MIB::tcpEstabResets.0 TCP-MIB::tcpCurrEstab.0 TCP-MIB::tcpInSegs.0 TCP-MIB::tcpOutSegs.0 TCP-MIB::tcpRetransSegs.0 TCP-MIB::tcpInErrs.0 TCP-MIB::tcpOutRsts.0 tcpHCInSegs.0 tcpHCOutSegs.0]
- tcpActiveOpens.0 = 27
- tcpPassiveOpens.0 = 8159
- tcpAttemptFails.0 = 0
- tcpEstabResets.0 = 8175
- tcpCurrEstab.0 = 6
- tcpInSegs.0 = 107258
- tcpOutSegs.0 = 129789
- tcpRetransSegs.0 = 9
- tcpInErrs.0 = 0
- tcpOutRsts.0 = 2959
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/netstats-tcp.rrd N:27:8159:0:8175:6:107258:129789:9:0:2959]
- [RRD Disabled] UDPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UDP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 UDP-MIB::udpInDatagrams.0 UDP-MIB::udpOutDatagrams.0 UDP-MIB::udpInErrors.0 UDP-MIB::udpNoPorts.0]
- udpInDatagrams.0 = 132642
- udpOutDatagrams.0 = 132671
- udpInErrors.0 = 0
- udpNoPorts.0 = 49
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/netstats-udp.rrd N:132642:132671:0:49]
- [RRD Disabled] ICMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 icmp]
- icmpInMsgs.0 = 6378
- icmpInErrors.0 = 0
- icmpInDestUnreachs.0 = 0
- icmpInTimeExcds.0 = 0
- icmpInParmProbs.0 = 0
- icmpInSrcQuenchs.0 = 0
- icmpInRedirects.0 = 0
- icmpInEchos.0 = 0
- icmpInEchoReps.0 = 0
- icmpInTimestamps.0 = 0
- icmpInTimestampReps.0 = 0
- icmpInAddrMasks.0 = 0
- icmpInAddrMaskReps.0 = 0
- icmpOutMsgs.0 = 6427
- icmpOutErrors.0 = 0
- icmpOutDestUnreachs.0 = 0
- icmpOutTimeExcds.0 = 49
- icmpOutParmProbs.0 = 0
- icmpOutSrcQuenchs.0 = 0
- icmpOutRedirects.0 = 0
- icmpOutEchos.0 = 0
- icmpOutEchoReps.0 = 6378
- icmpOutTimestamps.0 = 0
- icmpOutTimestampReps.0 = 0
- icmpOutAddrMasks.0 = 0
- icmpOutAddrMaskReps.0 = 0
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/netstats-icmp.rrd N:6378:6427:0:0:0:0:0:6378:0:0:0:0:0:0:0:0:0:0:49:0:0:0:0:0:0:0]
- [RRD Disabled] SNMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 snmp]
- snmpInPkts.0 = 130826
- snmpOutPkts.0 = 130777
- snmpInBadVersions.0 = 0
- snmpInBadCommunityNames.0 = 48
- snmpInBadCommunityUses.0 = 0
- snmpInASNParseErrs.0 = 261652
- snmpInTooBigs.0 = 0
- snmpInNoSuchNames.0 = 0
- snmpInBadValues.0 = 0
- snmpInReadOnlys.0 = 0
- snmpInGenErrs.0 = 0
- snmpInTotalReqVars.0 = 309074
- snmpInTotalSetVars.0 = 0
- snmpInGetRequests.0 = 64554
- snmpInGetNexts.0 = 34
- snmpInSetRequests.0 = 0
- snmpInGetResponses.0 = 0
- snmpInTraps.0 = 0
- snmpOutTooBigs.0 = 0
- snmpOutNoSuchNames.0 = 54314
- snmpOutBadValues.0 = 0
- snmpOutGenErrs.0 = 0
- snmpOutGetRequests.0 = 0
- snmpOutGetNexts.0 = 0
- snmpOutSetRequests.0 = 0
- snmpOutGetResponses.0 = 130779
- snmpOutTraps.0 = 0
- snmpEnableAuthenTraps.0 = disabled
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/netstats-snmp.rrd N:130826:130777:0:48:0:261652:0:0:0:0:0:309074:0:64554:34:0:0:0:0:54314:0:0:0:0:0:130779:0:U:U]
- [RRD Disabled] IP-FORWARDSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQv -M /opt/librenms/mibs udp:HOSTNAME:16100 IP-FORWARD-MIB::ipCidrRouteNumber.0]
- >> Runtime for poller module 'netstats': 0.2075 seconds with 15144 bytes
- >> SNMP: [6/0.21s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module netstats ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-netstats.rrd N:0.2075400352478]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module hr-mib ####
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 hrSystemProcesses.0 hrSystemNumUsers.0]
- >> Runtime for poller module 'hr-mib': 0.0345 seconds with 1584 bytes
- >> SNMP: [1/0.03s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module hr-mib ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-hr-mib.rrd N:0.034524917602539]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ucd-mib ####
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 systemStats]
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 memTotalSwap.0 memAvailSwap.0 memTotalReal.0 memAvailReal.0 memTotalFree.0 memShared.0 memBuffer.0 memCached.0]
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 laLoadInt.1 laLoadInt.2 laLoadInt.3]
- >> Runtime for poller module 'ucd-mib': 0.1732 seconds with 2832 bytes
- >> SNMP: [3/0.17s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module ucd-mib ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-ucd-mib.rrd N:0.17321491241455]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ipSystemStats ####
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 ipSystemStats]
- >> Runtime for poller module 'ipSystemStats': 0.0363 seconds with 1920 bytes
- >> SNMP: [1/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module ipSystemStats ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-ipSystemStats.rrd N:0.036272048950195]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ports ####
- Caching Oids: SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 ifXEntry]
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 ifEntry]
- ifIndex.1 = 1
- ifIndex.2.1 = "st"
- ifDescr.1 = st
- ifDescr.3.1 = 0
- ifType.1 = 0
- ifType.4.1 = 1500
- ifMtu.1 = 1500
- ifMtu.5.1 = 0
- ifSpeed.1 = 0
- ifSpeed.6.1 = "00 0B DC 01 35 E7 "
- ifPhysAddress.1 = 0:b:dc:1:35:e7
- ifPhysAddress.7.1 = 1
- ifAdminStatus.1 = up
- ifAdminStatus.8.1 = up
- ifOperStatus.1 = up
- ifOperStatus.9.1 = 119627
- ifLastChange.1 = 119627
- ifLastChange.10.1 = 0
- ifInOctets.1 = 0
- ifInOctets.11.1 = 0
- ifInUcastPkts.1 = 0
- ifInUcastPkts.12.1 = 0
- ifInNUcastPkts.1 = 0
- ifInNUcastPkts.13.1 = 0
- ifInDiscards.1 = 0
- ifInDiscards.14.1 = 0
- ifInErrors.1 = 0
- ifInErrors.15.1 = 0
- ifInUnknownProtos.1 = 0
- ifInUnknownProtos.16.1 = 0
- ifOutOctets.1 = 0
- ifOutOctets.17.1 = 0
- ifOutUcastPkts.1 = 0
- ifOutUcastPkts.18.1 = 0
- ifOutNUcastPkts.1 = 0
- ifOutNUcastPkts.19.1 = 0
- ifOutDiscards.1 = 0
- ifOutDiscards.20.1 = 0
- ifOutErrors.1 = 0
- ifOutErrors.21.1 = 0
- ifOutQLen.1 = 0
- ifOutQLen.22.1 = zeroDotZero
- ifSpecific.1 = zeroDotZero
- dot3StatsDuplexStatusSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 dot3StatsDuplexStatus]
- SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '9' AND `ifType` = 'adsl']
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 dot1qPvid]
- Array
- (
- [1] => Array
- (
- [ifIndex] => 1
- [ifDescr] => st
- [ifType] => 0
- [ifMtu] => 1500
- [ifSpeed] => 0
- [ifPhysAddress] => 0:b:dc:1:35:e7
- [ifAdminStatus] => up
- [ifOperStatus] => up
- [ifLastChange] => 119627
- [ifInOctets] => 0
- [ifInUcastPkts] => 0
- [ifInNUcastPkts] => 0
- [ifInDiscards] => 0
- [ifInErrors] => 0
- [ifInUnknownProtos] => 0
- [ifOutOctets] => 0
- [ifOutUcastPkts] => 0
- [ifOutNUcastPkts] => 0
- [ifOutDiscards] => 0
- [ifOutErrors] => 0
- [ifOutQLen] => 0
- [ifSpecific] => zeroDotZero
- )
- [2.1] => Array
- (
- [ifIndex] => st
- )
- [3.1] => Array
- (
- [ifDescr] => 0
- )
- [4.1] => Array
- (
- [ifType] => 1500
- )
- [5.1] => Array
- (
- [ifMtu] => 0
- )
- [6.1] => Array
- (
- [ifSpeed] => 00 0B DC 01 35 E7
- )
- [7.1] => Array
- (
- [ifPhysAddress] => 1
- )
- [8.1] => Array
- (
- [ifAdminStatus] => up
- )
- [9.1] => Array
- (
- [ifOperStatus] => 119627
- )
- [10.1] => Array
- (
- [ifLastChange] => 0
- )
- [11.1] => Array
- (
- [ifInOctets] => 0
- )
- [12.1] => Array
- (
- [ifInUcastPkts] => 0
- )
- [13.1] => Array
- (
- [ifInNUcastPkts] => 0
- )
- [14.1] => Array
- (
- [ifInDiscards] => 0
- )
- [15.1] => Array
- (
- [ifInErrors] => 0
- )
- [16.1] => Array
- (
- [ifInUnknownProtos] => 0
- )
- [17.1] => Array
- (
- [ifOutOctets] => 0
- )
- [18.1] => Array
- (
- [ifOutUcastPkts] => 0
- )
- [19.1] => Array
- (
- [ifOutNUcastPkts] => 0
- )
- [20.1] => Array
- (
- [ifOutDiscards] => 0
- )
- [21.1] => Array
- (
- [ifOutErrors] => 0
- )
- [22.1] => Array
- (
- [ifOutQLen] => zeroDotZero
- )
- )
- SQL[SELECT `name` FROM `port_association_mode` WHERE pom_id = '1']
- SQL[SELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = '9' ORDER BY ports.port_id]
- validSQL[UPDATE `ports` set `deleted` ='1' WHERE `port_id` = '']
- Port st: st (1 / #111) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN == Using ifDescr as ifAliasUsing ifDescr as ifNamest
- ifInOctets (0 B) 0 Bps 88 secs
- ifOutOctets (0 B) 0 Bps 88 secs
- ifInErrors (0 B) 0 Bps 88 secs
- ifOutErrors (0 B) 0 Bps 88 secs
- ifInUcastPkts (0 B) 0 Bps 88 secs
- ifOutUcastPkts (0 B) 0 Bps 88 secs
- ifInNUcastPkts (0 B) 0 Bps 88 secs
- ifOutNUcastPkts (0 B) 0 Bps 88 secs
- ifInDiscards (0 B) 0 Bps 88 secs
- ifOutDiscards (0 B) 0 Bps 88 secs
- ifInUnknownProtos (0 B) 0 Bps 88 secs
- ifInBroadcastPkts (0 B) 0 Bps 88 secs
- ifOutBroadcastPkts (0 B) 0 Bps 88 secs
- ifInMulticastPkts (0 B) 0 Bps 88 secs
- ifOutMulticastPkts (0 B) 0 Bps 88 secs
- bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[update /opt/librenms/rrd/nec01-shw01-env.network/port-id111.rrd N:0:0:0:0:0:0:0:0:0:0:0:U:U:U:U]
- [RRD Disabled]SQL[UPDATE `ports` set `poll_time` ='1521216931',`poll_prev` ='1521216843',`poll_period` ='88',`ifLastChange` ='119627',`ifInOctets` ='0',`ifInOctets_prev` ='0',`ifInOctets_rate` ='0',`ifInOctets_delta` ='0',`ifOutOctets` ='0',`ifOutOctets_prev` ='0',`ifOutOctets_rate` ='0',`ifOutOctets_delta` ='0',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='0',`ifInUcastPkts_prev` ='0',`ifInUcastPkts_rate` ='0',`ifInUcastPkts_delta` ='0',`ifOutUcastPkts` ='0',`ifOutUcastPkts_prev` ='0',`ifOutUcastPkts_rate` ='0',`ifOutUcastPkts_delta` ='0' WHERE `port_id` = '111']
- SQL[UPDATE `ports_statistics` set `ifInNUcastPkts` ='0',`ifInNUcastPkts_prev` ='0',`ifInNUcastPkts_rate` ='0',`ifInNUcastPkts_delta` ='0',`ifOutNUcastPkts` ='0',`ifOutNUcastPkts_prev` ='0',`ifOutNUcastPkts_rate` ='0',`ifOutNUcastPkts_delta` ='0',`ifInDiscards` ='0',`ifInDiscards_prev` ='0',`ifInDiscards_rate` ='0',`ifInDiscards_delta` ='0',`ifOutDiscards` ='0',`ifOutDiscards_prev` ='0',`ifOutDiscards_rate` ='0',`ifOutDiscards_delta` ='0',`ifInUnknownProtos` ='0',`ifInUnknownProtos_prev` ='0',`ifInUnknownProtos_rate` ='0',`ifInUnknownProtos_delta` ='0',`ifInBroadcastPkts` ='0',`ifInBroadcastPkts_prev` ='0',`ifInBroadcastPkts_rate` ='0',`ifInBroadcastPkts_delta` ='0',`ifOutBroadcastPkts` ='0',`ifOutBroadcastPkts_prev` ='0',`ifOutBroadcastPkts_rate` ='0',`ifOutBroadcastPkts_delta` ='0',`ifInMulticastPkts` ='0',`ifInMulticastPkts_prev` ='0',`ifInMulticastPkts_rate` ='0',`ifInMulticastPkts_delta` ='0',`ifOutMulticastPkts` ='0',`ifOutMulticastPkts_prev` ='0',`ifOutMulticastPkts_rate` ='0',`ifOutMulticastPkts
- _delta` ='0' WHERE `port_id` = '111']
- 1 updated
- >> Runtime for poller module 'ports': 0.1819 seconds with 38472 bytes
- >> SNMP: [4/0.18s] MySQL: [6/0.00s] RRD: [0/0.00s]
- #### Unload poller module ports ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-ports.rrd N:0.18191003799438]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module bgp-peers ####
- SQL[SELECT * FROM bgpPeers WHERE device_id = '9']
- >> Runtime for poller module 'bgp-peers': 0.0010 seconds with 13312 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module bgp-peers ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-bgp-peers.rrd N:0.00099301338195801]
- [RRD Disabled]Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally.
- Modules status: Global- OS Device Module [ toner ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module ucd-diskio ####
- SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '9']
- >> Runtime for poller module 'ucd-diskio': 0.0003 seconds with 1856 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module ucd-diskio ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-ucd-diskio.rrd N:0.00032401084899902]
- [RRD Disabled]Modules status: Global- OS Device Module [ wifi ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module wireless ####
- Attempting to initialize OS: custom
- Attempting to initialize OS: akcp
- OS initilized as Generic
- SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = '9']
- >> Runtime for poller module 'wireless': 0.0012 seconds with 98760 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module wireless ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-wireless.rrd N:0.0012388229370117]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ospf ####
- Processes: SQL[SELECT * FROM `ospf_instances` WHERE `device_id` = '9' AND `context_name` = '']
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 OSPF-MIB::ospfGeneralGroup]
- Polled: Array
- (
- )
- Database: Areas: SQL[SELECT * FROM `ospf_areas` WHERE `device_id` = '9' AND `context_name`= '']
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 OSPF-MIB::ospfAreaEntry]
- Polled: Array
- (
- )
- Database: Ports: SQL[SELECT * FROM `ospf_ports` WHERE `device_id` = '9' AND `context_name` = '']
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 OSPF-MIB::ospfIfEntry]
- Polled: Array
- (
- )
- Database: Neighbours: SQL[SELECT * FROM `ospf_nbrs` WHERE `device_id` = '9' AND `context_name` = '']
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 OSPF-MIB::ospfNbrEntry]
- Polled: Array
- (
- )
- Database:
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/ospf-statistics.rrd N:0:0:0:0]
- [RRD Disabled]
- >> Runtime for poller module 'ospf': 0.1391 seconds with 6976 bytes
- >> SNMP: [4/0.14s] MySQL: [4/0.00s] RRD: [0/0.00s]
- #### Unload poller module ospf ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-ospf.rrd N:0.13912010192871]
- [RRD Disabled]Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-cef ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-sla ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally.
- Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-voice ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-otv ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally.
- Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally.
- Modules status: Global- OS Device Module [ aruba-controller ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module entity-physical ####
- SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = '9']
- >> Runtime for poller module 'entity-physical': 0.0006 seconds with 2072 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module entity-physical ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-entity-physical.rrd N:0.00061798095703125]
- [RRD Disabled]Modules status: Global- OS Device Module [ entity-state ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module applications ####
- SQL[SELECT * FROM `applications` WHERE `device_id` = '9']
- >> Runtime for poller module 'applications': 0.0004 seconds with 1496 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module applications ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-applications.rrd N:0.00036215782165527]
- [RRD Disabled]Modules status: Global- OS Device Module [ mib ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module stp ####
- SQL[SELECT * FROM `stp` WHERE `device_id` = '9']
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 dot1dStpProtocolSpecification.0]
- >> Runtime for poller module 'stp': 0.0210 seconds with 5360 bytes
- >> SNMP: [1/0.02s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module stp ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-stp.rrd N:0.021038055419922]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ntp ####
- >> Runtime for poller module 'ntp': 0.0001 seconds with 192 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module ntp ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-ntp.rrd N:9.0122222900391E-5]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module services ####
- >> Runtime for poller module 'services': 0.0000 seconds with 0 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module services ####
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf-services.rrd N:4.6968460083008E-5]
- [RRD Disabled]Modules status: Global- OS Device Module [ loadbalancers ] disabled globally.
- Modules status: Global- OS Device Module [ mef ] disabled globally.
- ### Start Device Groups ###
- SQL[SELECT * FROM device_groups ORDER BY name]
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='9']
- Groups Added:
- Groups Removed:
- ### End Device Groups ###
- SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = '9']
- uptime netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt
- RRD[update /opt/librenms/rrd/nec01-shw01-env.network/ping-perf.rrd N:11.1]
- [RRD Disabled]RRD[update /opt/librenms/rrd/nec01-shw01-env.network/poller-perf.rrd N:1.939]
- [RRD Disabled]Polled in 1.939 seconds
- Updating nec01-shw01-env.network
- SQL[UPDATE `devices` set `uptime` ='263658',`last_ping` =NOW(),`last_ping_timetaken` ='11.1',`last_polled` =NOW(),`last_polled_timetaken` ='1.939' WHERE `device_id` = '9']
- UPDATED!
- #### Start Alerts ####
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='9']
- SQL[SELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '9' ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.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 = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), ''),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1]
- 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='9' OR dg.device_id='9')]
- Rule #1 (Devices up/down):
- SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices WHERE (devices.device_id = '9') && (((devices.status = 0 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
- Status: NOCHG
- Rule #2 (Device rebooted):
- SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices WHERE (devices.device_id = '9') && (devices.uptime < "300" && ((devices.disabled = 0 && devices.ignore = 0)) = "1")]
- Status: NOCHG
- Rule #3 (BGP Session down):
- SQL[SELECT state FROM alerts WHERE rule_id = '3' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '9') && (bgpPeers.bgpPeerState != "established" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
- Status: NOCHG
- Rule #4 (BGP Session established):
- SQL[SELECT state FROM alerts WHERE rule_id = '4' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '9') && (bgpPeers.bgpPeerFsmEstablishedTime < "300" && bgpPeers.bgpPeerState = "established" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
- Status: NOCHG
- Rule #5 (Port status up/down):
- SQL[SELECT state FROM alerts WHERE rule_id = '5' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '9') && (((ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && ((ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)))) = "1")]
- Status: NOCHG
- Rule #6 (Port utilisation over threshold):
- SQL[SELECT state FROM alerts WHERE rule_id = '6' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '9') && ((((ports.ifInOctets_rate*8) / ports.ifSpeed)*100) >= "80" && ((ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && ((ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)))) = "1" && ((ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = "1")]
- Status: NOCHG
- Rule #7 (Sensor over limit - Check Device Health Settings):
- SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '9') && (sensors.sensor_current > sensors.sensor_limit && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
- Status: NOCHG
- Rule #8 (Sensor under limit - Check Device Health Settings):
- SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '9') && (sensors.sensor_current < sensors sensors.sensor_alert = "1" xss=removed xss=removed xss=removed rule_id = '9' device_id = '9' xss=removed services.device_id = '9' xss=removed xss=removed xss=removed rule_id = '10' device_id = '9' xss=removed wireless_sensors.device_id = '9'>= wireless_sensors.sensor_limit && wireless_sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
- Status: NOCHG
- Rule #11 (Wireless Sensor under limit):
- SQL[SELECT state FROM alerts WHERE rule_id = '11' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM wireless_sensors,devices WHERE (( devices.device_id = wireless_sensors.device_id ) && wireless_sensors.device_id = '9') && (wireless_sensors.sensor_current <= wireless_sensors.sensor_limit_low && wireless_sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
- Status: NOCHG
- Rule #12 (State Sensor Critical):
- SQL[SELECT state FROM alerts WHERE rule_id = '12' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM sensors WHERE (sensors.device_id = '9') && ((sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2))]
- Status: NOCHG
- #### End Alerts ####
- SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','nec01-shw01-env.network','1521216930.012','2.076','1','librenms')]
- /opt/librenms/poller.php nec01-shw01-env.network 2018-03-16 16:15:32 - 1 devices polled in 2.076 secs
- SNMP [25/0.89s]: Get[13/0.41s] Getnext[0/0.00s] Walk[12/0.48s]
- MySQL [61/0.03s]: Cell[5/0.00s] Row[14/0.00s] Rows[34/0.01s] Column[2/0.00s] Update[4/0.01s] Insert[2/0.00s] Delete[0/0.00s]
- RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]