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]