- LibreNMS Poller
- SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.74ms]
- SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.55ms]
- SQL[select version() [] 0.72ms]
- ===================================
- Version info:
- Commit SHA: 06c361c2b529b20dfa6750072a1c1ef7a0803d9b
- Commit Date: 1664425930
- DB Schema: 2022_09_03_091314_update_ports_adsl_table_with_defaults (246)
- PHP: 7.4.3
- Database: MariaDB 10.3.34-MariaDB-0ubuntu0.20.04.1
- RRDTool: 1.7.2
- SNMP: 5.8
- ==================================DEBUG!
- Updating os_def.cache
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.2.61' ORDER BY `device_id` ASC [] 0.9ms]
- SQL[select * from `devices` where `device_id` = ? limit 1 [120] 0.61ms]
- SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [120] 0.32ms]
- Attempting to initialize OS: fs-net-pdu
- Attempting to initialize Group OS: fs
- OS initialized as Generic
- Hostname: 192.168.2.61
- Device ID: 120
- OS: fs-net-pdu
- (fs)
- [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '192.168.2.61'
- response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.57/0.58/0.61
- SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' '-v1' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0']
- SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.30966
- SQL[insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0.57,0.61,0.58,3,3,0,120,"2022-11-12 20:26:39"] 1.34ms]
- SQL[update `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0.58,120] 1.38ms]
- SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [120] 0.88ms]
- Modules status: Global+
- OS
- Device
- #### Load poller module core ####
- SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0']
- .*.*.0 = net-pdu
- .*.*.0 = .*.4.1.30966
- .*.*.0 = 0
- .*.*.0 = IP-PDU
- SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' '-v1' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0']
- Exitcode: 2 ["Error in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMP-FRAMEWORK-MIB::snmpEngineTime.0\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: HOST-RESOURCES-MIB::hrSystemUptime.0\n\n"]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMP-FRAMEWORK-MIB::snmpEngineTime.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: HOST-RESOURCES-MIB::hrSystemUptime.0
- Uptime seconds: 0
- >> Runtime for poller module 'core': 0.0823 seconds with 64528 bytes
- >> SNMP: [2/0.08s] MySQL: [0/0.00s]
- #### Unload poller module core ####
- Modules status: Global-
- OS
- Device
- Module [ unix-agent ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module os ####
- Generic :(
- SQL[select * from `locations` where `locations`.`id` = ? limit 1 [29] 0.96ms]
- Location: location
- Hardware:
- OS Version:
- OS Features:
- Serial:
- >> Runtime for poller module 'os': 0.0083 seconds with 120624 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.01s]
- #### Unload poller module os ####
- Modules status: Global+
- OS
- Device
- #### Load poller module availability ####
- SQL[SELECT duration FROM availability WHERE device_id = ? [120] 0.6ms]
- Availability:
- SQL[SELECT * FROM availability WHERE device_id = ? [120] 0.65ms]
- SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [120,1668198399] 1.29ms]
- SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,421] 0.56ms]
- 1 day : 100%
- SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [120,1667679999] 1.12ms]
- SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,422] 0.46ms]
- 7 days : 100%
- SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [120,1665692799] 0.91ms]
- SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,423] 0.5ms]
- 30 days : 100%
- SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [120,1636748799] 0.82ms]
- SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,424] 0.45ms]
- 365 days : 100%
- >> Runtime for poller module 'availability': 0.0143 seconds with 27376 bytes
- >> SNMP: [0/0.00s] MySQL: [10/0.07s]
- #### Unload poller module availability ####
- Modules status: Global+
- OS
- Device
- #### Load poller module ipmi ####
- SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [120] 0.85ms]
- array (
- )
- >> Runtime for poller module 'ipmi': 0.0017 seconds with 2096 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.01s]
- #### Unload poller module ipmi ####
- Modules status: Global+
- OS
- Device
- #### Load poller module sensors ####
- SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [120] 0.82ms]
- SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["voltage",120] 0.83ms]
- SNMP['/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OUQntea' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.30966.10.3.2.1.0']
- .*.4.1.309*.1.0 = 232
- Checking (snmp) voltage Voltage...
- 232 V
- >> Runtime for poller module 'sensors': 0.0309 seconds with 1648 bytes
- >> SNMP: [1/0.03s] MySQL: [2/0.02s]
- #### Unload poller module sensors ####
- Modules status: Global+
- OS
- Device
- #### Load poller module processors ####
- Attempting to initialize OS: fs-net-pdu
- Attempting to initialize Group OS: fs
- OS initialized as Generic
- SQL[SELECT * FROM processors WHERE device_id=? [120] 1.33ms]
- >> Runtime for poller module 'processors': 0.0060 seconds with 125192 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.01s]
- #### Unload poller module processors ####
- Modules status: Global+
- OS
- Device
- #### Load poller module mempools ####
- SQL[select * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [120] 1.51ms]
- >> Runtime for poller module 'mempools': 0.0053 seconds with 81168 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.02s]
- #### Unload poller module mempools ####
- Modules status: Global+
- OS
- Device
- #### Load poller module storage ####
- SQL[SELECT * FROM storage WHERE device_id = ? [120] 1.09ms]
- >> Runtime for poller module 'storage': 0.0021 seconds with 1408 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.01s]
- #### Unload poller module storage ####
- Modules status: Global+
- OS
- Device
- #### Load poller module netstats ####
- icmp SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' '-v1' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0']
- IP-MIB::icmpInMsgs.0 = 3037
- IP-MIB::icmpOutMsgs.0 = 3037
- IP-MIB::icmpInErrors.0 = 0
- IP-MIB::icmpOutErrors.0 = 0
- IP-MIB::icmpInEchos.0 = 0
- IP-MIB::icmpOutEchos.0 = 0
- IP-MIB::icmpInEchoReps.0 = 0
- IP-MIB::icmpOutEchoReps.0 = 3037
- IP-MIB::icmpInDestUnreachs.0 = 0
- IP-MIB::icmpOutDestUnreachs.0 = 0
- IP-MIB::icmpInParmProbs.0 = 0
- IP-MIB::icmpInTimeExcds.0 = 0
- IP-MIB::icmpInSrcQuenchs.0 = 0
- IP-MIB::icmpInRedirects.0 = 0
- IP-MIB::icmpInTimestamps.0 = 0
- IP-MIB::icmpInTimestampReps.0 = 0
- IP-MIB::icmpInAddrMasks.0 = 0
- IP-MIB::icmpInAddrMaskReps.0 = 0
- IP-MIB::icmpOutTimeExcds.0 = 0
- IP-MIB::icmpOutParmProbs.0 = 0
- IP-MIB::icmpOutSrcQuenchs.0 = 0
- IP-MIB::icmpOutRedirects.0 = 0
- IP-MIB::icmpOutTimestamps.0 = 0
- IP-MIB::icmpOutTimestampReps.0 = 0
- IP-MIB::icmpOutAddrMasks.0 = 0
- IP-MIB::icmpOutAddrMaskReps.0 = 0
- ip SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' '-v1' '-c' 'COMMUNITY' '-OQXUte' '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']
- IP-MIB::ipForwDatagrams.0 = 0
- IP-MIB::ipInDelivers.0 = 61834
- IP-MIB::ipInReceives.0 = 61957
- IP-MIB::ipOutRequests.0 = 58287
- IP-MIB::ipInDiscards.0 = 113
- IP-MIB::ipOutDiscards.0 = 0
- IP-MIB::ipOutNoRoutes.0 = 0
- IP-MIB::ipReasmReqds.0 = 0
- IP-MIB::ipReasmOKs.0 = 0
- IP-MIB::ipReasmFails.0 = 0
- IP-MIB::ipFragOKs.0 = 0
- IP-MIB::ipFragFails.0 = 0
- IP-MIB::ipFragCreates.0 = 0
- IP-MIB::ipInUnknownProtos.0 = 10
- IP-MIB::ipInHdrErrors.0 = 0
- IP-MIB::ipInAddrErrors.0 = 113
- ip_forward SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' '-v1' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0']
- Exitcode: 2 ["Error in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: IP-FORWARD-MIB::ipCidrRouteNumber.0\n\n"]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-FORWARD-MIB::ipCidrRouteNumber.0
- snmp SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' '-v1' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0']
- Exitcode: 2 ["Error in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-MIB::snmpSilentDrops.0\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-SMI::zeroDotZero\n\nError in packet\nReason: (noSuchName) There is no such variable name in this MIB.\nFailed object: SNMPv2-MIB::snmpProxyDrops.0\n\n"]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-MIB::snmpSilentDrops.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-SMI::zeroDotZero
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMPv2-MIB::snmpProxyDrops.0
- udp SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' '-v1' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0']
- UDP-MIB::udpInDatagrams.0 = 53645
- UDP-MIB::udpOutDatagrams.0 = 53617
- UDP-MIB::udpInErrors.0 = 0
- UDP-MIB::udpNoPorts.0 = 0
- tcp SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' '-v1' '-c' 'COMMUNITY' '-OQXUte' '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']
- TCP-MIB::tcpActiveOpens.0 = 0
- TCP-MIB::tcpPassiveOpens.0 = 342
- TCP-MIB::tcpAttemptFails.0 = 0
- TCP-MIB::tcpEstabResets.0 = 341
- TCP-MIB::tcpCurrEstab.0 = 0
- TCP-MIB::tcpInSegs.0 = 2092
- TCP-MIB::tcpOutSegs.0 = 1235
- TCP-MIB::tcpRetransSegs.0 = 12
- TCP-MIB::tcpInErrs.0 = 0
- TCP-MIB::tcpOutRsts.0 = 17
- >> Runtime for poller module 'netstats': 0.3012 seconds with 23216 bytes
- >> SNMP: [6/0.30s] MySQL: [0/0.00s]
- #### Unload poller module netstats ####
- Modules status: Global+
- OS
- Device
- #### Load poller module hr-mib ####
- SNMP['/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0']
- Exitcode: 2
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemMaxProcesses.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemProcesses.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemNumUsers.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemMaxProcesses.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemProcesses.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemNumUsers.0
- >> Runtime for poller module 'hr-mib': 0.0393 seconds with 592 bytes
- >> SNMP: [1/0.04s] MySQL: [0/0.00s]
- #### Unload poller module hr-mib ####
- Modules status: Global+
- OS
- Device
- #### Load poller module ucd-mib ####
- SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' 'udp:HOSTNAME:161' 'systemStats']
- SNMP['/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3']
- Exitcode: 2
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.1
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.2
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.3
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.1
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.2
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.3
- >> Runtime for poller module 'ucd-mib': 0.0645 seconds with 144 bytes
- >> SNMP: [2/0.06s] MySQL: [0/0.00s]
- #### Unload poller module ucd-mib ####
- Modules status: Global+
- OS
- Device
- #### Load poller module ipSystemStats ####
- SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' 'udp:HOSTNAME:161' 'ipSystemStats']
- >> Runtime for poller module 'ipSystemStats': 0.0467 seconds with 888 bytes
- >> SNMP: [1/0.05s] MySQL: [0/0.00s]
- #### Unload poller module ipSystemStats ####
- Modules status: Global+
- OS
- Device
- #### Load poller module ports ####
- 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` = ? ORDER BY ports.port_id [120] 2.41ms]
- Caching Oids: Full ports polling SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' 'udp:HOSTNAME:161' 'ifXEntry']
- SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' 'udp:HOSTNAME:161' 'ifEntry']
- ifIndex.1 = 1
- ifDescr.1 = e0
- ifType.1 = 0
- ifMtu.1 = 1500
- ifSpeed.1 = 0
- ifPhysAddress.1 = 2c:26:5f:33:54:f3
- ifAdminStatus.1 = up
- ifOperStatus.1 = up
- ifLastChange.1 = 0
- ifInOctets.1 = 0
- ifInUcastPkts.1 = 0
- ifInNUcastPkts.1 = 0
- ifInDiscards.1 = 0
- ifInErrors.1 = 0
- ifInUnknownProtos.1 = 0
- ifOutOctets.1 = 0
- ifOutUcastPkts.1 = 0
- ifOutNUcastPkts.1 = 0
- ifOutDiscards.1 = 0
- ifOutErrors.1 = 0
- ifOutQLen.1 = 0
- ifSpecific.1 = zeroDotZero
- dot3StatsDuplexStatusSNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus']
- SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' 'udp:HOSTNAME:161' 'dot1qPvid']
- array (
- 1 =>
- array (
- 'ifIndex' => '1',
- 'ifDescr' => 'e0',
- 'ifType' => '0',
- 'ifMtu' => '1500',
- 'ifSpeed' => '0',
- 'ifPhysAddress' => '2c:26:5f:33:54:f3',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'up',
- 'ifLastChange' => '0',
- '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',
- ),
- )
- valid
- Port e0: e0 (1 / #1186083) ifInOctets
- ifOutOctets
- ifInUcastPkts
- ifOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- ifSpeed (0)
- VLAN = ? Using ifDescr as ifAlias
- Using ifDescr as ifName
- e0
- ifInOctets (0 B) 0 Bps 6 secs
- ifOutOctets (0 B) 0 Bps 6 secs
- ifInErrors (0 B) 0 Bps 6 secs
- ifOutErrors (0 B) 0 Bps 6 secs
- ifInUcastPkts (0 B) 0 Bps 6 secs
- ifOutUcastPkts (0 B) 0 Bps 6 secs
- ifInNUcastPkts (0 B) 0 Bps 6 secs
- ifOutNUcastPkts (0 B) 0 Bps 6 secs
- ifInDiscards (0 B) 0 Bps 6 secs
- ifOutDiscards (0 B) 0 Bps 6 secs
- ifInUnknownProtos (0 B) 0 Bps 6 secs
- ifInBroadcastPkts (0 B) 0 Bps 6 secs
- ifOutBroadcastPkts (0 B) 0 Bps 6 secs
- ifInMulticastPkts (0 B) 0 Bps 6 secs
- ifOutMulticastPkts (0 B) 0 Bps 6 secs
- bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? ["0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,1668284800,1668284794,6,1186083] 1.86ms]
- SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1186083] 1.4ms]
- 1 updated
- SQL[update `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [1668284800,1668284794,null] 0.52ms]
- 0 updated
- >> Runtime for poller module 'ports': 0.2148 seconds with 54016 bytes
- >> SNMP: [4/0.19s] MySQL: [4/0.06s]
- #### Unload poller module ports ####
- Modules status: Global-
- OS
- Device
- Module [ xdsl ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module customoid ####
- SQL[SELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [120] 7.82ms]
- >> Runtime for poller module 'customoid': 0.0093 seconds with 1824 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.08s]
- #### Unload poller module customoid ####
- Modules status: Global+
- OS
- Device
- #### Load poller module bgp-peers ####
- SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [120] 1.06ms]
- >> Runtime for poller module 'bgp-peers': 0.0073 seconds with 15856 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.01s]
- #### Unload poller module bgp-peers ####
- Modules status: Global-
- OS
- Device
- Module [ junose-atm-vp ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ printer-supplies ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module ucd-diskio ####
- SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = ? [120] 0.81ms]
- >> Runtime for poller module 'ucd-diskio': 0.0018 seconds with 1288 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.01s]
- #### Unload poller module ucd-diskio ####
- Modules status: Global-
- OS
- Device
- Module [ wifi ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module wireless ####
- Attempting to initialize OS: fs-net-pdu
- Attempting to initialize Group OS: fs
- OS initialized as Generic
- SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [120] 0.98ms]
- >> Runtime for poller module 'wireless': 0.0059 seconds with 103776 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.01s]
- #### Unload poller module wireless ####
- Modules status: Global+
- OS
- Device
- #### Load poller module ospf ####
- SQL[select * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [120] 0.84ms]
- Processes: SNMP['/usr/bin/snmpwalk' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/fs' '-v1' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup']
- SQL[delete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [120,""] 0.97ms]
- 0
- >> Runtime for poller module 'ospf': 0.0521 seconds with 101240 bytes
- >> SNMP: [1/0.04s] MySQL: [2/0.02s]
- #### Unload poller module ospf ####
- Modules status: Global-
- OS
- Device
- Module [ isis ] disabled globally.
- 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 [ slas ] 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-qfp ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-vpdn ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ nac ] 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 ####
- >> Runtime for poller module 'entity-physical': 0.0005 seconds with 472 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s]
- #### Unload poller module entity-physical ####
- Modules status: Global-
- OS
- Device
- Module [ entity-state ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module applications ####
- SQL[select * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null [120] 0.81ms]
- >> Runtime for poller module 'applications': 0.0031 seconds with 30216 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.01s]
- #### Unload poller module applications ####
- Modules status: Global+
- OS
- Device
- #### Load poller module stp ####
- Instances: SQL[select * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [120] 2.19ms]
- Ports: SQL[select * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [120] 0.89ms]
- >> Runtime for poller module 'stp': 0.0087 seconds with 77984 bytes
- >> SNMP: [0/0.00s] MySQL: [2/0.03s]
- #### Unload poller module stp ####
- Modules status: Global+
- OS
- Device
- #### Load poller module ntp ####
- >> Runtime for poller module 'ntp': 0.0004 seconds with 400 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s]
- #### Unload poller module ntp ####
- Modules status: Global-
- OS
- Device
- Module [ loadbalancers ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ mef ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module mpls ####
- >> Runtime for poller module 'mpls': 0.0039 seconds with 37192 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s]
- #### Unload poller module mpls ####
- Enabling graphs: SQL[select * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [120] 1.91ms]
- SQL[UPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [2.059,120] 1.28ms]
- Updating 192.168.2.61
- Polled in 2.059 seconds
- ### Start Device Groups ###
- SQL[select * from `device_groups` [] 0.89ms]
- SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [120] 0.71ms]
- Groups Added:
- Groups Removed:
- ### End Device Groups, runtime: 0.0191s ###
- #### Start Alerts ####
- SQL[select `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [120] 0.69ms]
- SQL[select exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`start`) <= ? or time(`end`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` ["2022-11-12T20:26:40.351337Z","2022-11-12T20:26:40.351337Z",0,1,"20:26:40","20:26:40","20:26:40","20:26:40","%","device",120,"location",29] 2.19ms]
- SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [120] 2.72ms]
- SQL[SELECT DISTINCT a.* FROM alert_rules a
- LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?)
- LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?))
- LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?))
- LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
- WHERE a.disabled = 0 AND (
- (d.device_id IS NULL AND g.group_id IS NULL)
- OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
- OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL))
- ) [120,120,120,120,120,120,120,120] 4.54ms]
- Rule #1 (Device Down! Due to no ICMP response.):
- SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [120] 2.46ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,120] 1.1ms]
- Status: NOCHG
- Rule #2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):
- SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [120] 1.52ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,120] 0.69ms]
- Status: NOCHG
- Rule #3 (Device rebooted):
- SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed> 25 [120] 1.29ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [5,120] 1.04ms]
- Status: NOCHG
- Rule #6 (Port utilisation over threshold):
- SQL[SELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 98 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifDescr NOT LIKE 'tap%' AND ports.ifDescr NOT LIKE 'fwbr%' AND ports.ifDescr NOT LIKE 'Vlan%' AND ports.ifDescr != "lo" [120] 2.5ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [6,120] 0.76ms]
- Status: NOCHG
- Rule #7 (Sensor over limit - Check Device Health Settings):
- SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [120] 1.8ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [7,120] 0.65ms]
- Status: NOCHG
- Rule #8 (Sensor under limit - Check Device Health Settings):
- SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= wireless_sensors.sensor_limit AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [120] 1.77ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [10,120] 0.61ms]
- Status: NOCHG
- Rule #11 (Wireless Sensor under limit):
- SQL[SELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current <= wireless_sensors.sensor_limit_low AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [120] 1.71ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [11,120] 0.63ms]
- Status: NOCHG
- Rule #12 (State Sensor Critical):
- SQL[SELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 AND sensors.sensor_alert = 1 [120] 2.36ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [12,120] 0.69ms]
- Status: NOCHG
- #### End Alerts ####
- /opt/librenms/poller.php 192.168.2.61 2022-11-12 20:26:40 - 1 devices polled in 2.824 secs
- SNMP [19/0.82s]: Snmpget[12/0.51s] Snmpwalk[7/0.31s]
- SQL [72/0.92s]: Select[61/0.81s] Insert[1/0.01s] Update[9/0.08s] Delete[1/0.01s]