LibreNMS Poller =================================== Version info: Commit SHA: 386fea0321a86b197d302629a04d20d480828d6d Commit Date: 1525034560 DB Schema: 249 PHP: 7.0.28-0ubuntu0.16.04.1 MySQL: 10.0.34-MariaDB-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` = '10.115.0.32' ORDER BY `device_id` ASC] SQL[SELECT * FROM devices_attribs WHERE `device_id` = '1430'] Hostname: 10.115.0.32 Device ID: 1430 OS: generic SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('5','5','0','0.69','0.87','0.78','1430',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 -t 2 -r 5 udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0] .*.*.0 = 50748596 .*.*.0 = .*.*.0 = .*.*.0 = FortiWeb .*.*.0 = .*.4.1.123*007 .*.*.0 = FortiwebAz SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0] snmpEngineTime.0 = No Such Object available on this agent at this OID hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 507486 RRD[update /opt/librenms/rrd/10.115.0.32/uptime.rrd N:507486] [RRD Disabled]Uptime: 5 days, 20h 58m 6s >> Runtime for poller module 'core': 0.0218 seconds with 15560 bytes >> SNMP: [2/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module core #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-core.rrd N:0.021833896636963] [RRD Disabled]Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( Hardware: Version: Features: Serial: >> Runtime for poller module 'os': 0.0002 seconds with 512 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module os #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-os.rrd N:0.00018310546875] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[SELECT * FROM sensors WHERE device_id = '1430' AND poller_type='ipmi'] Array ( ) >> Runtime for poller module 'ipmi': 0.0004 seconds with 2384 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ipmi #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ipmi.rrd N:0.00038003921508789] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module sensors #### SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = '1430' GROUP BY `sensor_class`] >> Runtime for poller module 'sensors': 0.0002 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/10.115.0.32/poller-perf-sensors.rrd N:0.00018620491027832] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic SQL[SELECT * FROM processors WHERE device_id='1430'] >> Runtime for poller module 'processors': 0.0015 seconds with 155008 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module processors #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-processors.rrd N:0.0015389919281006] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module mempools #### SQL[SELECT * FROM mempools WHERE device_id = '1430'] >> Runtime for poller module 'mempools': 0.0003 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/10.115.0.32/poller-perf-mempools.rrd N:0.00030398368835449] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module storage #### SQL[SELECT * FROM storage WHERE device_id = '1430'] >> Runtime for poller module 'storage': 0.0003 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/10.115.0.32/poller-perf-storage.rrd N:0.0002751350402832] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module netstats #### ICMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 icmp] icmpInMsgs.0 = 164 icmpInErrors.0 = 0 icmpInDestUnreachs.0 = 0 icmpInTimeExcds.0 = 118 icmpInParmProbs.0 = 0 icmpInSrcQuenchs.0 = 0 icmpInRedirects.0 = 0 icmpInEchos.0 = 0 icmpInEchoReps.0 = 46 icmpInTimestamps.0 = 0 icmpInTimestampReps.0 = 0 icmpInAddrMasks.0 = 0 icmpInAddrMaskReps.0 = 0 icmpOutMsgs.0 = 0 icmpOutErrors.0 = 56 icmpOutDestUnreachs.0 = 0 icmpOutTimeExcds.0 = 10 icmpOutParmProbs.0 = 0 icmpOutSrcQuenchs.0 = 0 icmpOutRedirects.0 = 0 icmpOutEchos.0 = 0 icmpOutEchoReps.0 = 0 icmpOutTimestamps.0 = 46 icmpOutTimestampReps.0 = 0 icmpOutAddrMasks.0 = 0 icmpOutAddrMaskReps.0 = 0 RRD[update /opt/librenms/rrd/10.115.0.32/netstats-icmp.rrd N:164:0:0:56:0:0:46:0:0:0:0:118:0:0:0:0:0:0:10:0:0:0:46:0:0:0] [RRD Disabled] IPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs -t 2 -r 5 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 = 6271831 ipInReceives.0 = 6271831 ipOutRequests.0 = 4661948 ipInDiscards.0 = 0 ipOutDiscards.0 = 0 ipOutNoRoutes.0 = 16 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.115.0.32/netstats-ip.rrd N:0:6271831:6271831:4661948:0:0:16:0:0:0:0:0:0:0:0:0] [RRD Disabled] IP-FORWARDSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQv -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 IP-FORWARD-MIB::ipCidrRouteNumber.0] No Such Instance currently exists at this OID SNMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m SNMPv2-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 snmp] snmp = No Such Object available on this agent at this OID TCPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m TCP-MIB -M /opt/librenms/mibs -t 2 -r 5 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 = 276654 tcpPassiveOpens.0 = 19240 tcpAttemptFails.0 = 203057 tcpEstabResets.0 = 4598 tcpCurrEstab.0 = 43 tcpInSegs.0 = 6192322 tcpOutSegs.0 = 5692835 tcpRetransSegs.0 = 63477 tcpInErrs.0 = 0 tcpOutRsts.0 = 204393 tcpHCInSegs.0 = No Such Object available on this agent at this OID tcpHCOutSegs.0 = No Such Object available on this agent at this OID RRD[update /opt/librenms/rrd/10.115.0.32/netstats-tcp.rrd N:276654:19240:203057:4598:43:6192322:5692835:63477:0:204393] [RRD Disabled] UDPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UDP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 UDP-MIB::udpInDatagrams.0 UDP-MIB::udpOutDatagrams.0 UDP-MIB::udpInErrors.0 UDP-MIB::udpNoPorts.0] udpInDatagrams.0 = 83568 udpOutDatagrams.0 = 83631 udpInErrors.0 = 0 udpNoPorts.0 = 10 RRD[update /opt/librenms/rrd/10.115.0.32/netstats-udp.rrd N:83568:83631:0:10] [RRD Disabled] >> Runtime for poller module 'netstats': 0.1186 seconds with 14888 bytes >> SNMP: [6/0.12s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module netstats #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-netstats.rrd N:0.11859703063965] [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 -t 2 -r 5 udp:HOSTNAME:161 hrSystemProcesses.0 hrSystemNumUsers.0] hrSystemProcesses.0 = No Such Object available on this agent at this OID hrSystemNumUsers.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'hr-mib': 0.0108 seconds with 1584 bytes >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module hr-mib #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-hr-mib.rrd N:0.010780096054077] [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 -t 2 -r 5 udp:HOSTNAME:161 systemStats] systemStats = No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 memTotalSwap.0 memAvailSwap.0 memTotalReal.0 memAvailReal.0 memTotalFree.0 memShared.0 memBuffer.0 memCached.0] memTotalSwap.0 = No Such Object available on this agent at this OID memAvailSwap.0 = No Such Object available on this agent at this OID memTotalReal.0 = No Such Object available on this agent at this OID memAvailReal.0 = No Such Object available on this agent at this OID memTotalFree.0 = No Such Object available on this agent at this OID memShared.0 = No Such Object available on this agent at this OID memBuffer.0 = No Such Object available on this agent at this OID memCached.0 = No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 laLoadInt.1 laLoadInt.2 laLoadInt.3] laLoadInt.1 = No Such Object available on this agent at this OID laLoadInt.2 = No Such Object available on this agent at this OID laLoadInt.3 = No Such Object available on this agent at this OID >> Runtime for poller module 'ucd-mib': 0.0366 seconds with 2792 bytes >> SNMP: [3/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-mib #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ucd-mib.rrd N:0.036607980728149] [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 -t 2 -r 5 udp:HOSTNAME:161 ipSystemStats] ipSystemStatsTable = No Such Instance currently exists at this OID >> Runtime for poller module 'ipSystemStats': 0.0143 seconds with 1920 bytes >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ipSystemStats #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ipSystemStats.rrd N:0.014273166656494] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ports #### Caching Oids: Select ports pollingSQL[SELECT * FROM `ports` where `device_id` = '1430' AND `deleted` = 0 AND `disabled` = 0] SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 ifName.1 ifAlias.1 ifDescr.1 ifHighSpeed.1 ifOperStatus.1 ifAdminStatus.1] ifName.1 = port1 ifAlias.1 = port1 ifDescr.1 = port1 ifHighSpeed.1 = 0 ifOperStatus.1 = up ifAdminStatus.1 = up validSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 ifSpeed.1 ifInOctets.1 ifInUcastPkts.1 ifInUnknownProtos.1 ifOutOctets.1 ifOutUcastPkts.1 ifInErrors.1 ifOutErrors.1 ifInNUcastPkts.1 ifOutNUcastPkts.1 ifInDiscards.1 ifOutDiscards.1 ifPhysAddress.1 ifLastChange.1 ifType.1 ifMtu.1] ifSpeed.1 = 1048576000 ifInOctets.1 = 288574448 ifInUcastPkts.1 = 5467853 ifInUnknownProtos.1 = 0 ifOutOctets.1 = 4170045242 ifOutUcastPkts.1 = 3931974 ifInErrors.1 = 0 ifOutErrors.1 = 0 ifInNUcastPkts.1 = 0 ifOutNUcastPkts.1 = 0 ifInDiscards.1 = 0 ifOutDiscards.1 = 0 ifPhysAddress.1 = 0:d:3a:37:ee:ad ifLastChange.1 = 0 ifType.1 = ethernetCsmacd ifMtu.1 = 1500 SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m EtherLike-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 dot3StatsIndex.1 dot3StatsDuplexStatus.1] dot3StatsIndex.1 = 1 dot3StatsDuplexStatus.1 = 0 SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 ifName.2 ifAlias.2 ifDescr.2 ifHighSpeed.2 ifOperStatus.2 ifAdminStatus.2] ifName.2 = port2 ifAlias.2 = port2 ifDescr.2 = port2 ifHighSpeed.2 = 0 ifOperStatus.2 = up ifAdminStatus.2 = up validSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 ifSpeed.2 ifInOctets.2 ifInUcastPkts.2 ifInUnknownProtos.2 ifOutOctets.2 ifOutUcastPkts.2 ifInErrors.2 ifOutErrors.2 ifInNUcastPkts.2 ifOutNUcastPkts.2 ifInDiscards.2 ifOutDiscards.2 ifPhysAddress.2 ifLastChange.2 ifType.2 ifMtu.2] ifSpeed.2 = 1048576000 ifInOctets.2 = 45163874 ifInUcastPkts.2 = 409537 ifInUnknownProtos.2 = 0 ifOutOctets.2 = 326357125 ifOutUcastPkts.2 = 335675 ifInErrors.2 = 0 ifOutErrors.2 = 0 ifInNUcastPkts.2 = 0 ifOutNUcastPkts.2 = 0 ifInDiscards.2 = 12 ifOutDiscards.2 = 0 ifPhysAddress.2 = 0:d:3a:38:28:5c ifLastChange.2 = 0 ifType.2 = ethernetCsmacd ifMtu.2 = 1500 SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m EtherLike-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 dot3StatsIndex.2 dot3StatsDuplexStatus.2] dot3StatsIndex.2 = 2 dot3StatsDuplexStatus.2 = 0 SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '1430' AND `ifType` = 'adsl'] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 dot1qPvid] dot1qPvid = No Such Object available on this agent at this OID Array ( [1] => Array ( [ifName] => port1 [ifAlias] => port1 [ifDescr] => port1 [ifHighSpeed] => 0 [ifOperStatus] => up [ifAdminStatus] => up [ifSpeed] => 1048576000 [ifInOctets] => 288574448 [ifInUcastPkts] => 5467853 [ifInUnknownProtos] => 0 [ifOutOctets] => 4170045242 [ifOutUcastPkts] => 3931974 [ifInErrors] => 0 [ifOutErrors] => 0 [ifInNUcastPkts] => 0 [ifOutNUcastPkts] => 0 [ifInDiscards] => 0 [ifOutDiscards] => 0 [ifPhysAddress] => 0:d:3a:37:ee:ad [ifLastChange] => 0 [ifType] => ethernetCsmacd [ifMtu] => 1500 [dot3StatsIndex] => 1 [dot3StatsDuplexStatus] => 0 ) [2] => Array ( [ifName] => port2 [ifAlias] => port2 [ifDescr] => port2 [ifHighSpeed] => 0 [ifOperStatus] => up [ifAdminStatus] => up [ifSpeed] => 1048576000 [ifInOctets] => 45163874 [ifInUcastPkts] => 409537 [ifInUnknownProtos] => 0 [ifOutOctets] => 326357125 [ifOutUcastPkts] => 335675 [ifInErrors] => 0 [ifOutErrors] => 0 [ifInNUcastPkts] => 0 [ifOutNUcastPkts] => 0 [ifInDiscards] => 12 [ifOutDiscards] => 0 [ifPhysAddress] => 0:d:3a:38:28:5c [ifLastChange] => 0 [ifType] => ethernetCsmacd [ifMtu] => 1500 [dot3StatsIndex] => 2 [dot3StatsDuplexStatus] => 0 ) ) 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` = '1430' ORDER BY ports.port_id] validvalid Port port1: port1 (1 / #8790) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed dot3Duplex VLAN == port1 ifInOctets (0 B) 0 Bps 11 secs ifOutOctets (0 B) 0 Bps 11 secs ifInErrors (0 B) 0 Bps 11 secs ifOutErrors (0 B) 0 Bps 11 secs ifInUcastPkts (0 B) 0 Bps 11 secs ifOutUcastPkts (0 B) 0 Bps 11 secs ifInNUcastPkts (0 B) 0 Bps 11 secs ifOutNUcastPkts (0 B) 0 Bps 11 secs ifInDiscards (0 B) 0 Bps 11 secs ifOutDiscards (0 B) 0 Bps 11 secs ifInUnknownProtos (0 B) 0 Bps 11 secs ifInBroadcastPkts (0 B) 0 Bps 11 secs ifOutBroadcastPkts (0 B) 0 Bps 11 secs ifInMulticastPkts (0 B) 0 Bps 11 secs ifOutMulticastPkts (0 B) 0 Bps 11 secs bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[update /opt/librenms/rrd/10.115.0.32/port-id8790.rrd N:288574448:4170045242:0:0:5467853:3931974:0:0:0:0:0:U:U:U:U] [RRD Disabled]SQL[UPDATE `ports` set `poll_time` ='1525274351',`poll_prev` ='1525274340',`poll_period` ='11',`ifLastChange` ='0',`ifInOctets` ='288574448',`ifInOctets_prev` ='288574448',`ifInOctets_rate` ='0',`ifInOctets_delta` ='0',`ifOutOctets` ='4170045242',`ifOutOctets_prev` ='4170045242',`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` ='5467853',`ifInUcastPkts_prev` ='5467853',`ifInUcastPkts_rate` ='0',`ifInUcastPkts_delta` ='0',`ifOutUcastPkts` ='3931974',`ifOutUcastPkts_prev` ='3931974',`ifOutUcastPkts_rate` ='0',`ifOutUcastPkts_delta` ='0' WHERE `port_id` = '8790'] 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` = '8790'] 1 updated Port port2: port2 (2 / #8791) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed dot3Duplex VLAN == port2 ifInOctets (19723 B) 1793 Bps 11 secs ifOutOctets (42567 B) 3869.7272727273 Bps 11 secs ifInErrors (0 B) 0 Bps 11 secs ifOutErrors (0 B) 0 Bps 11 secs ifInUcastPkts (200 B) 18.181818181818 Bps 11 secs ifOutUcastPkts (200 B) 18.181818181818 Bps 11 secs ifInNUcastPkts (0 B) 0 Bps 11 secs ifOutNUcastPkts (0 B) 0 Bps 11 secs ifInDiscards (0 B) 0 Bps 11 secs ifOutDiscards (0 B) 0 Bps 11 secs ifInUnknownProtos (0 B) 0 Bps 11 secs ifInBroadcastPkts (0 B) 0 Bps 11 secs ifOutBroadcastPkts (0 B) 0 Bps 11 secs ifInMulticastPkts (0 B) 0 Bps 11 secs ifOutMulticastPkts (0 B) 0 Bps 11 secs bps(14.340kbps/30.960kbps)bytes(19.260kB/41.570kB)pkts(18.180pps/18.180pps)RRD[update /opt/librenms/rrd/10.115.0.32/port-id8791.rrd N:45163874:326357125:0:0:409537:335675:0:0:12:0:0:U:U:U:U] [RRD Disabled]SQL[UPDATE `ports` set `poll_time` ='1525274351',`poll_prev` ='1525274340',`poll_period` ='11',`ifLastChange` ='0',`ifInOctets` ='45163874',`ifInOctets_prev` ='45144151',`ifInOctets_rate` ='1793',`ifInOctets_delta` ='19723',`ifOutOctets` ='326357125',`ifOutOctets_prev` ='326314558',`ifOutOctets_rate` ='3869.7272727273',`ifOutOctets_delta` ='42567',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='409537',`ifInUcastPkts_prev` ='409337',`ifInUcastPkts_rate` ='18.181818181818',`ifInUcastPkts_delta` ='200',`ifOutUcastPkts` ='335675',`ifOutUcastPkts_prev` ='335475',`ifOutUcastPkts_rate` ='18.181818181818',`ifOutUcastPkts_delta` ='200' WHERE `port_id` = '8791'] 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` ='12',`ifInDiscards_prev` ='12',`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',`ifOutMulticastPk ts_delta` ='0' WHERE `port_id` = '8791'] 1 updated >> Runtime for poller module 'ports': 0.1177 seconds with 67424 bytes >> SNMP: [7/0.08s] MySQL: [8/0.03s] RRD: [0/0.00s] #### Unload poller module ports #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ports.rrd N:0.11772203445435] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module bgp-peers #### SQL[SELECT * FROM bgpPeers WHERE device_id = '1430'] >> Runtime for poller module 'bgp-peers': 0.0008 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/10.115.0.32/poller-perf-bgp-peers.rrd N:0.00084805488586426] [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` = '1430'] >> 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/10.115.0.32/poller-perf-ucd-diskio.rrd N:0.00028109550476074] [RRD Disabled]Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = '1430'] >> Runtime for poller module 'wireless': 0.0010 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/10.115.0.32/poller-perf-wireless.rrd N:0.0010440349578857] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ospf #### Processes: SQL[SELECT * FROM `ospf_instances` WHERE `device_id` = '1430' AND `context_name` = ''] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 OSPF-MIB::ospfGeneralGroup] ospfGeneralGroup = No Such Object available on this agent at this OID Polled: Array ( ) Database: Areas: SQL[SELECT * FROM `ospf_areas` WHERE `device_id` = '1430' AND `context_name`= ''] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 OSPF-MIB::ospfAreaEntry] ospfAreaEntry = No Such Object available on this agent at this OID Polled: Array ( ) Database: Ports: SQL[SELECT * FROM `ospf_ports` WHERE `device_id` = '1430' AND `context_name` = ''] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 OSPF-MIB::ospfIfEntry] ospfIfEntry = No Such Object available on this agent at this OID Polled: Array ( ) Database: Neighbours: SQL[SELECT * FROM `ospf_nbrs` WHERE `device_id` = '1430' AND `context_name` = ''] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 OSPF-MIB::ospfNbrEntry] ospfNbrEntry = No Such Object available on this agent at this OID Polled: Array ( ) Database: RRD[update /opt/librenms/rrd/10.115.0.32/ospf-statistics.rrd N:0:0:0:0] [RRD Disabled] >> Runtime for poller module 'ospf': 0.0513 seconds with 6992 bytes >> SNMP: [4/0.05s] MySQL: [4/0.00s] RRD: [0/0.00s] #### Unload poller module ospf #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ospf.rrd N:0.051262140274048] [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` = '1430'] >> Runtime for poller module 'entity-physical': 0.0004 seconds with 1944 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module entity-physical #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-entity-physical.rrd N:0.00040698051452637] [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` = '1430'] >> Runtime for poller module 'applications': 0.0003 seconds with 1512 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module applications #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-applications.rrd N:0.00027203559875488] [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` = '1430'] SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 dot1dStpProtocolSpecification.0] No Such Object available on this agent at this OID >> Runtime for poller module 'stp': 0.0109 seconds with 5720 bytes >> SNMP: [1/0.01s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module stp #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-stp.rrd N:0.010910034179688] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 176 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ntp #### RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ntp.rrd N:9.2983245849609E-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/10.115.0.32/poller-perf-services.rrd N:3.6001205444336E-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 DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-aa" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "pti-ach" || devices.sysName REGEXP "civ-ach" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "pti-anz" || devices.sysName REGEXP "civ-anz" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "pti-at-" || devices.sysName REGEXP "civ-at-" || devices.sysName REGEXP "civ-ath-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName = "civeo-austin-mpls.civeo.local" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName = "civeo-bellechase-mpls.civeo.local" || devices.sysName REGEXP "civ-bel-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-bog" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "pti-br" || devices.sysName REGEXP "civ-brp-" || devices.sysName REGEXP "pti-brp-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-bne-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "pti-clg" || devices.sysName REGEXP "civ-clg" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-hou-cl49" || devices.sysName REGEXP "civeo-houston-mpls.civeo.local" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysname REGEXP "pti-ckl" || devices.sysName REGEXP "civ-ckl" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-cbl-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-da" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-dic-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-dys-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "pti-edm" || devices.sysName REGEXP "civ-edm-co-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-kam" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-kar-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "PTI-KID-" || devices.sysName REGEXP "pti-kid-" || devices.sysName REGEXP "civ-kid-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-scr-" || devices.sysName REGEXP "civeo-longmont-mpls.civeo.local" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-mrl" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "pti-mcl" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-mnt" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-mbh" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-nbi" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-neb" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-nsl" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-sea-" || devices.sysName REGEXP "civeo-mpls-telus" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-syd" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-bdr" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-ver-ut-" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "pti-wpe" || devices.sysName REGEXP "civ-wpe" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "pti-wpm" || devices.sysName REGEXP "civ-wpm" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysname REGEXP "pti-wpw" || devices.sysName REGEXP "civ-wpw" ) LIMIT 1] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='1430' AND (devices.sysName REGEXP "civ-pc-" ) LIMIT 1] SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='1430'] Groups Added: Groups Removed: ### End Device Groups ### SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = '1430'] uptime netstat_icmp netstat_icmp_info netstat_ip netstat_ip_frag netstat_tcp netstat_udp RRD[update /opt/librenms/rrd/10.115.0.32/ping-perf.rrd N:0.78] [RRD Disabled]RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf.rrd N:4.867] [RRD Disabled]Polled in 4.867 seconds Updating 10.115.0.32 SQL[UPDATE `devices` set `uptime` ='507486',`last_ping` =NOW(),`last_ping_timetaken` ='0.78',`last_polled` =NOW(),`last_polled_timetaken` ='4.867' WHERE `device_id` = '1430'] UPDATED! #### Start Alerts #### SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='1430'] 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 = '1430' ) && ((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='1430' OR dg.device_id='1430')] Rule #1 (Device Down): SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '1430' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices WHERE (devices.device_id = '1430') AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1] Status: NOCHG Rule #3 (APC UPS Switched to Battery Power): SQL[SELECT state FROM alerts WHERE rule_id = '3' && device_id = '1430' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '1430' AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 3 AND sensors.sensor_type = "upsBasicOutputStatus"] Status: NOCHG Rule #4 (Cisco PSU status failed): SQL[SELECT state FROM alerts WHERE rule_id = '4' && device_id = '1430' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '1430' AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 8 AND sensors.sensor_oid = ".1.3.6.1.4.1.9.9.13.1.5.1.3"] Status: NOCHG Rule #5 (APC UPS Battery Needs Replacement): SQL[SELECT state FROM alerts WHERE rule_id = '5' && device_id = '1430' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '1430' AND devices.device_id = sensors.device_id) AND sensors.sensor_type = "upsAdvBatteryReplaceIndicator" AND sensors.sensor_current = 2] Status: NOCHG Rule #6 (APC UPS in Hardware Failure Bypass Mode): SQL[SELECT state FROM alerts WHERE rule_id = '6' && device_id = '1430' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '1430' AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 10 AND sensors.sensor_type = "upsBasicOutputStatus"] Status: NOCHG Rule #7 (Device rebooted): SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '1430' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices WHERE (devices.device_id = '1430') AND devices.uptime < 300 AND (devices.disabled = 0 && devices.ignore = 0) = 1] Status: NOCHG Rule #8 (Cisco Fan Status failed ): SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '1430' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '1430' AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 9 AND sensors.sensor_oid = ".1.3.6.1.4.1.9.9.13.1.4.1.3"] Status: NOCHG #### End Alerts #### SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','10.115.0.32','1525274346.3448','5.004','1','AzPrdLibreNMS01')] /opt/librenms/poller.php 10.115.0.32 2018-05-02 09:19:11 - 1 devices polled in 5.004 secs SNMP [26/0.79s]: Get[17/0.67s] Getnext[0/0.00s] Walk[9/0.12s] MySQL [90/0.08s]: Cell[42/0.01s] Row[8/0.00s] Rows[30/0.01s] Column[2/0.00s] Update[6/0.05s] Insert[2/0.02s] Delete[0/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]