- LibreNMS Poller
- ===================================
- Version info:
- Commit SHA: 34ed39c1f9a0aa9c21fe4d0859c7f3ac3678a976
- Commit Date: 1514928991
- DB Schema: 227
- PHP: 5.6.30-0+deb8u1
- MySQL: 10.0.32-MariaDB-0+deb8u1
- RRDTool: 1.4.8
- SNMP: NET-SNMP 5.7.2.1
- ==================================DEBUG!
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.0.10.4' ORDER BY `device_id` ASC]
- SQL[SELECT * FROM devices_attribs WHERE `device_id` = '35']
- Hostname: 10.0.10.4
- Device ID: 35
- OS: generex-ups
- SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','3.81','3.95','3.86','35',NOW())]
- SNMP Check response code: 0
- SQL[UPDATE `devices` set `status` ='1',`status_reason` ='' WHERE device_id='35']
- SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('35','35','NULL','up',NOW(),'2','Device status changed to Up from snmp check.','')]
- Modules status: Global+ OS Device
- #### Load poller module core ####
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0]
- sysUpTime.0 = 1198477104
- sysLocation.0 = moja pisarna
- sysContact.0 = jaz
- sysName.0 = UPS_SIMTEL
- sysObjectID.0 = mib-2.33
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysDescr.0]
- CS121 v 5.40.59
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0]
- Uptime seconds: 11984771
- RRD[update /opt/librenms/rrd/10.0.10.4/uptime.rrd N:11984771]
- [RRD Disabled]Uptime: 138 days, 17h 6m 11s
- SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`='moja pisarna' LIMIT 1]
- Using cached lat/lng from other device
- >> Runtime for poller module 'core': 0.0432 seconds with 25176 bytes
- >> SNMP: [3/0.04s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module core ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-core.rrd N:0.043248176574707]
- [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 -OQUs -m UPS-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 upsIdentManufacturer.0 upsIdentModel.0 upsIdentAgentSoftwareVersion.0]
- upsIdentManufacturer.0 = Alpha
- upsIdentModel.0 = Continuity 3000
- upsIdentAgentSoftwareVersion.0 = CS121 v 5.40.59
- Array
- (
- [0] => Array
- (
- [upsIdentManufacturer] => Alpha
- [upsIdentModel] => Continuity 3000
- [upsIdentAgentSoftwareVersion] => CS121 v 5.40.59
- )
- )
- Hardware: Alpha - Continuity 3000
- Version: CS121 v 5.40.59
- Features:
- Serial:
- >> Runtime for poller module 'os': 0.2441 seconds with 3440 bytes
- >> SNMP: [1/0.24s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module os ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-os.rrd N:0.24405002593994]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ipmi ####
- SQL[SELECT * FROM sensors WHERE device_id = '35' AND poller_type='ipmi']
- Array
- (
- )
- >> Runtime for poller module 'ipmi': 0.0007 seconds with 2736 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module ipmi ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-ipmi.rrd N:0.00066089630126953]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module sensors ####
- SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = '35' GROUP BY `sensor_class`]
- SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '35']
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.33.1.2.6.0 .1.3.6.1.2.1.33.1.4.4.1.3.1]
- .*.*.2.6.0 = 0
- .*.*.*.1 = 0
- Checking (snmp) current Battery...
- Checking (snmp) current Output...
- 0
- RRD[update /opt/librenms/rrd/10.0.10.4/sensor-current-rfc1628-500.rrd N:0]
- [RRD Disabled]0
- RRD[update /opt/librenms/rrd/10.0.10.4/sensor-current-rfc1628-1.rrd N:0]
- [RRD Disabled]SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '35']
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.33.1.2.5.0 .1.3.6.1.2.1.33.1.4.4.1.2.1]
- .*.*.2.5.0 = 820
- .*.*.*.1 = 230
- Checking (snmp) voltage Battery...
- Checking (snmp) voltage Output...
- 82
- RRD[update /opt/librenms/rrd/10.0.10.4/sensor-voltage-rfc1628-1.2.5.0.rrd N:82]
- [RRD Disabled]230
- RRD[update /opt/librenms/rrd/10.0.10.4/sensor-voltage-rfc1628-1.rrd N:230]
- [RRD Disabled]
- >> Runtime for poller module 'sensors': 0.4896 seconds with 3928 bytes
- >> SNMP: [2/0.49s] MySQL: [3/0.00s] RRD: [0/0.00s]
- #### Unload poller module sensors ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-sensors.rrd N:0.48959803581238]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module processors ####
- SQL[SELECT * FROM processors WHERE device_id = '35']
- >> Runtime for poller module 'processors': 0.0005 seconds with 2144 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module processors ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-processors.rrd N:0.00049495697021484]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module mempools ####
- SQL[SELECT * FROM mempools WHERE device_id = '35']
- >> Runtime for poller module 'mempools': 0.0004 seconds with 2128 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module mempools ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-mempools.rrd N:0.00037217140197754]
- [RRD Disabled]Modules status: Global+ OS- Device Module [ storage ] disabled on os.
- 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:161 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 = 21731383
- ipInReceives.0 = 31505054
- ipOutRequests.0 = 21728573
- ipInDiscards.0 = 0
- ipOutDiscards.0 = 2
- 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 = 0
- RRD[update /opt/librenms/rrd/10.0.10.4/netstats-ip.rrd N:0:21731383:31505054:21728573:0:2:0:0:0:0:0:0:0:0:0:0]
- [RRD Disabled] TCPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m TCP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 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 = 60
- tcpPassiveOpens.0 = 606025
- tcpAttemptFails.0 = 116
- tcpEstabResets.0 = 11
- tcpCurrEstab.0 = 0
- tcpInSegs.0 = 4263002
- tcpOutSegs.0 = 4266551
- tcpRetransSegs.0 = 6309
- tcpInErrs.0 = 0
- tcpOutRsts.0 = 163
- RRD[update /opt/librenms/rrd/10.0.10.4/netstats-tcp.rrd N:60:606025:116:11:0:4263002:4266551:6309:0:163]
- [RRD Disabled] UDPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UDP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 UDP-MIB::udpInDatagrams.0 UDP-MIB::udpOutDatagrams.0 UDP-MIB::udpInErrors.0 UDP-MIB::udpNoPorts.0]
- udpInDatagrams.0 = 16207499
- udpOutDatagrams.0 = 16207339
- udpInErrors.0 = 0
- udpNoPorts.0 = 133
- RRD[update /opt/librenms/rrd/10.0.10.4/netstats-udp.rrd N:16207499:16207339:0:133]
- [RRD Disabled] ICMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 icmp]
- icmpInMsgs.0 = 1260885
- icmpInErrors.0 = 0
- icmpInDestUnreachs.0 = 12641
- icmpInTimeExcds.0 = 0
- icmpInParmProbs.0 = 0
- icmpInSrcQuenchs.0 = 0
- icmpInRedirects.0 = 0
- icmpInEchos.0 = 1248244
- icmpInEchoReps.0 = 0
- icmpInTimestamps.0 = 0
- icmpInTimestampReps.0 = 0
- icmpInAddrMasks.0 = 0
- icmpInAddrMaskReps.0 = 0
- icmpOutMsgs.0 = 1248377
- icmpOutErrors.0 = 2
- icmpOutDestUnreachs.0 = 133
- icmpOutTimeExcds.0 = 0
- icmpOutParmProbs.0 = 0
- icmpOutSrcQuenchs.0 = 0
- icmpOutRedirects.0 = 0
- icmpOutEchos.0 = 0
- icmpOutEchoReps.0 = 1248244
- icmpOutTimestamps.0 = 0
- icmpOutTimestampReps.0 = 0
- icmpOutAddrMasks.0 = 0
- icmpOutAddrMaskReps.0 = 0
- RRD[update /opt/librenms/rrd/10.0.10.4/netstats-icmp.rrd N:1260885:1248377:0:2:1248244:0:0:1248244:12641:133:0:0:0:0:0:0:0:0:0: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:161 snmp]
- snmpInPkts.0 = 16206602
- snmpOutPkts.0 = 16206601
- snmpInBadVersions.0 = 0
- snmpInBadCommunityNames.0 = 0
- snmpInBadCommunityUses.0 = 0
- snmpInASNParseErrs.0 = 0
- snmpInTooBigs.0 = 0
- snmpInNoSuchNames.0 = 0
- snmpInBadValues.0 = 0
- snmpInReadOnlys.0 = 0
- snmpInGenErrs.0 = 0
- snmpInTotalReqVars.0 = 16349904
- snmpInTotalSetVars.0 = 0
- snmpInGetRequests.0 = 16115930
- snmpInGetNexts.0 = 0
- snmpInSetRequests.0 = 0
- snmpInGetResponses.0 = 0
- snmpInTraps.0 = 0
- snmpOutTooBigs.0 = 0
- snmpOutNoSuchNames.0 = 0
- snmpOutBadValues.0 = 0
- snmpOutGenErrs.0 = 0
- snmpOutGetRequests.0 = 0
- snmpOutGetNexts.0 = 0
- snmpOutSetRequests.0 = 0
- snmpOutGetResponses.0 = 16115930
- snmpOutTraps.0 = 0
- snmpEnableAuthenTraps.0 = disabled
- snmpSilentDrops.0 = 0
- snmpProxyDrops.0 = 0
- RRD[update /opt/librenms/rrd/10.0.10.4/netstats-snmp.rrd N:16206602:16206601:0:0:0:0:0:0:0:0:0:16349904:0:16115930:0:0:0:0:0:0:0:0:0:0:0:16115930:0:0:0]
- [RRD Disabled] IP-FORWARDSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQv -M /opt/librenms/mibs udp:HOSTNAME:161 IP-FORWARD-MIB::ipCidrRouteNumber.0]
- >> Runtime for poller module 'netstats': 0.9659 seconds with 6976 bytes
- >> SNMP: [6/0.96s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module netstats ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-netstats.rrd N:0.96586799621582]
- [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:161 hrSystemProcesses.0 hrSystemNumUsers.0]
- >> Runtime for poller module 'hr-mib': 0.0127 seconds with 1424 bytes
- >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module hr-mib ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-hr-mib.rrd N:0.01269006729126]
- [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:161 systemStats]
- systemStats = No more variables left in this MIB View (It is past the end of the MIB tree)
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 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:161 laLoadInt.1 laLoadInt.2 laLoadInt.3]
- >> Runtime for poller module 'ucd-mib': 0.0348 seconds with 1520 bytes
- >> SNMP: [3/0.03s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module ucd-mib ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-ucd-mib.rrd N:0.034755945205688]
- [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:161 ipSystemStats]
- >> Runtime for poller module 'ipSystemStats': 0.0239 seconds with 1448 bytes
- >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module ipSystemStats ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-ipSystemStats.rrd N:0.023936986923218]
- [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:161 ifXEntry]
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifEntry]
- ifIndex.1 = 1
- ifDescr.1 = CS121 Ethernet
- ifType.1 = ethernetCsmacd
- ifMtu.1 = 1500
- ifSpeed.1 = 100000000
- ifPhysAddress.1 = 0:3:5:1c:d8:b5
- ifAdminStatus.1 = up
- ifOperStatus.1 = up
- ifLastChange.1 = 0
- ifInOctets.1 = 2523560923
- ifInUcastPkts.1 = 31505075
- ifInNUcastPkts.1 = 0
- ifInDiscards.1 = 0
- ifInErrors.1 = 0
- ifInUnknownProtos.1 = 0
- ifOutOctets.1 = 3071171344
- ifOutUcastPkts.1 = 22687476
- ifOutNUcastPkts.1 = 2355
- ifOutDiscards.1 = 0
- ifOutErrors.1 = 2
- ifOutQLen.1 = 0
- ifSpecific.1 = internet
- dot3StatsDuplexStatusSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot3StatsDuplexStatus]
- SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '35' AND `ifType` = 'adsl']
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1qPvid]
- Array
- (
- [1] => Array
- (
- [ifIndex] => 1
- [ifDescr] => CS121 Ethernet
- [ifType] => ethernetCsmacd
- [ifMtu] => 1500
- [ifSpeed] => 100000000
- [ifPhysAddress] => 0:3:5:1c:d8:b5
- [ifAdminStatus] => up
- [ifOperStatus] => up
- [ifLastChange] => 0
- [ifInOctets] => 2523560923
- [ifInUcastPkts] => 31505075
- [ifInNUcastPkts] => 0
- [ifInDiscards] => 0
- [ifInErrors] => 0
- [ifInUnknownProtos] => 0
- [ifOutOctets] => 3071171344
- [ifOutUcastPkts] => 22687476
- [ifOutNUcastPkts] => 2355
- [ifOutDiscards] => 0
- [ifOutErrors] => 2
- [ifOutQLen] => 0
- [ifSpecific] => internet
- )
- )
- 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` = '35' ORDER BY ports.port_id]
- valid
- Port CS121 Ethernet: CS121 Ethernet (1 / #2543) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN == Using ifDescr as ifAliasUsing ifDescr as ifNameCS121 Ethernet
- ifInOctets (49073 B) 103.52953586498 Bps 474 secs
- ifOutOctets (39217 B) 82.736286919831 Bps 474 secs
- ifInErrors (0 B) 0 Bps 474 secs
- ifOutErrors (0 B) 0 Bps 474 secs
- ifInUcastPkts (329 B) 0.69409282700422 Bps 474 secs
- ifOutUcastPkts (204 B) 0.43037974683544 Bps 474 secs
- ifInNUcastPkts (0 B) 0 Bps 474 secs
- ifOutNUcastPkts (0 B) 0 Bps 474 secs
- ifInDiscards (0 B) 0 Bps 474 secs
- ifOutDiscards (0 B) 0 Bps 474 secs
- ifInUnknownProtos (0 B) 0 Bps 474 secs
- ifInBroadcastPkts (0 B) 0 Bps 474 secs
- ifOutBroadcastPkts (0 B) 0 Bps 474 secs
- ifInMulticastPkts (0 B) 0 Bps 474 secs
- ifOutMulticastPkts (0 B) 0 Bps 474 secs
- bps(828.000bps/662.000bps)bytes(47.920kB/38.300kB)pkts(0.690pps/0.430pps)RRD[update /opt/librenms/rrd/10.0.10.4/port-id2543.rrd N:2523560923:3071171344:0:2:31505075:22687476:0:2355:0:0:0:U:U:U:U]
- [RRD Disabled]SQL[UPDATE `ports` set `poll_time` ='1514975580',`poll_prev` ='1514975106',`poll_period` ='474',`ifLastChange` ='0',`ifInOctets` ='2523560923',`ifInOctets_prev` ='2523511850',`ifInOctets_rate` ='103.52953586498',`ifInOctets_delta` ='49073',`ifOutOctets` ='3071171344',`ifOutOctets_prev` ='3071132127',`ifOutOctets_rate` ='82.736286919831',`ifOutOctets_delta` ='39217',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='2',`ifOutErrors_prev` ='2',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='31505075',`ifInUcastPkts_prev` ='31504746',`ifInUcastPkts_rate` ='0.69409282700422',`ifInUcastPkts_delta` ='329',`ifOutUcastPkts` ='22687476',`ifOutUcastPkts_prev` ='22687272',`ifOutUcastPkts_rate` ='0.43037974683544',`ifOutUcastPkts_delta` ='204' WHERE `port_id` = '2543']
- SQL[UPDATE `ports_statistics` set `ifInNUcastPkts` ='0',`ifInNUcastPkts_prev` ='0',`ifInNUcastPkts_rate` ='0',`ifInNUcastPkts_delta` ='0',`ifOutNUcastPkts` ='2355',`ifOutNUcastPkts_prev` ='2355',`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',`ifOutMultica
- stPkts_delta` ='0' WHERE `port_id` = '2543']
- 1 updated
- >> Runtime for poller module 'ports': 1.7343 seconds with 42712 bytes
- >> SNMP: [4/1.72s] MySQL: [5/0.01s] RRD: [0/0.00s]
- #### Unload poller module ports ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-ports.rrd N:1.7342529296875]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module bgp-peers ####
- SQL[SELECT * FROM bgpPeers WHERE device_id = '35']
- >> Runtime for poller module 'bgp-peers': 0.0010 seconds with 1136 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module bgp-peers ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-bgp-peers.rrd N:0.00098085403442383]
- [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` = '35']
- >> Runtime for poller module 'ucd-diskio': 0.0002 seconds with 2160 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module ucd-diskio ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-ucd-diskio.rrd N:0.00021910667419434]
- [RRD Disabled]Modules status: Global- OS Device Module [ wifi ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module wireless ####
- Attempting to initialize OS: generex-ups
- SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = '35']
- >> Runtime for poller module 'wireless': 0.0013 seconds with 179264 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module wireless ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-wireless.rrd N:0.0013058185577393]
- [RRD Disabled]Modules status: Global+ OS- Device Module [ ospf ] disabled on os.
- 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` = '35']
- >> Runtime for poller module 'entity-physical': 0.0003 seconds with 2568 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module entity-physical ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-entity-physical.rrd N:0.0002589225769043]
- [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` = '35']
- >> Runtime for poller module 'applications': 0.0002 seconds with 2144 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module applications ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-applications.rrd N:0.00018811225891113]
- [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` = '35']
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dStpProtocolSpecification.0]
- >> Runtime for poller module 'stp': 0.0132 seconds with 3176 bytes
- >> SNMP: [1/0.01s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module stp ####
- RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf-stp.rrd N:0.013240098953247]
- [RRD Disabled]Modules status: Global+ OS- Device Module [ ntp ] disabled on os.
- Modules status: Global+ OS- Device Module [ services ] disabled on os.
- 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`='35']
- Groups Added:
- Groups Removed:
- ### End Device Groups ###
- SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = '35']
- 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/10.0.10.4/ping-perf.rrd N:3.86]
- [RRD Disabled]RRD[update /opt/librenms/rrd/10.0.10.4/poller-perf.rrd N:4.599]
- [RRD Disabled]Polled in 4.599 seconds
- Updating 10.0.10.4
- SQL[UPDATE `devices` set `uptime` ='11984771',`last_ping` =NOW(),`last_ping_timetaken` ='3.86',`last_polled` =NOW(),`last_polled_timetaken` ='4.599' WHERE `device_id` = '35']
- UPDATED!
- #### Start Alerts ####
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='35']
- 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 = '35' ) && ((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 `device_group_id` FROM `device_group_device` WHERE `device_id`='35']
- SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE alert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = '35' ) || alert_map.target = '35' )]
- Rule #1 (Devices up/down):
- SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '35' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices WHERE (devices.device_id = '35') && (((devices.status = 0 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
- SQL[INSERT INTO `alert_log` (`state`,`device_id`,`rule_id`) VALUES ('0','35','1')]
- SQL[UPDATE `alerts` set `state` ='0',`open` ='1' WHERE device_id = '35' && rule_id = '1']
- Status: OK
- Rule #2 (Device rebooted):
- SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '35' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices WHERE (devices.device_id = '35') && (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 = '35' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '35') && (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 = '35' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '35') && (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 = '35' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '35') && (((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 = '35' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '35') && ((((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):
- SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '35' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '35') && (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):
- SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '35' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '35') && (sensors.sensor_current < sensors sensors.sensor_alert = "1" xss=removed xss=removed xss=removed rule_id = '9' device_id = '35' xss=removed services.device_id = '35' xss=removed xss=removed xss=removed rule_id = '10' device_id = '35' xss=removed wireless_sensors.device_id = '35'>= 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 = '35' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM wireless_sensors,devices WHERE (( devices.device_id = wireless_sensors.device_id ) && wireless_sensors.device_id = '35') && (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
- #### End Alerts ####
- SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','10.0.10.4','1514975575.9131','4.641','1','NMS')]
- /opt/librenms/poller.php 10.0.10.4 2018-01-03 11:33:00 - 1 devices polled in 4.641 secs
- SNMP [23/3.56s]: Get[15/0.91s] Getnext[0/0.00s] Walk[8/2.65s]
- MySQL [60/0.04s]: Cell[5/0.00s] Row[13/0.00s] Rows[30/0.01s] Column[3/0.00s] Update[5/0.01s] Insert[4/0.01s] Delete[0/0.00s]
- RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]