- LibreNMS Poller
- SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.52ms]
- SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.56ms]
- SQL[SELECT version() [] 0.41ms]
- ===================================
- Version info:
- Commit SHA:
- Commit Date:
- DB Schema: 2020_04_19_010532_eventlog_sensor_reference_cleanup (164)
- PHP: 7.3.14
- MySQL: 10.4.12-MariaDB-1:10.4.12+maria~bionic
- RRDTool: 1.7.2
- SNMP: NET-SNMP 5.8
- ==================================DEBUG!
- Updating os_def.cache...
- Warning: file_put_contents(/opt/librenms/cache/os_defs.cache): failed to open stream: Permission denied in /opt/librenms/includes/common.php on line 1448
- Done
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'erin-cd800.catgirls.dev' ORDER BY `device_id` ASC [] 1.3ms]
- SQL[select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE' ["librenms","migrations"] 1.2ms]
- SQL[select `migration` from `migrations` [] 1.41ms]
- SQL[select distinct `os` from `devices` [] 1.41ms]
- SQL[select * from `devices` where `device_id` = ? limit 1 [8] 1.09ms]
- SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [8] 0.65ms]
- Hostname: erin-cd800.catgirls.dev
- Device ID: 8
- OS: generic
- Resolved IP: 192.168.8.16
- SQL[select `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 ["erin-cd800.catgirls.dev"] 1.03ms]
- [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'erin-cd800.catgirls.dev'
- array (
- 'xmt' => 3,
- 'rcv' => 3,
- 'loss' => 0,
- 'min' => 47.1,
- 'max' => 276.0,
- 'avg' => 187.0,
- 'dup' => 0,
- 'exitcode' => 0,
- )
- SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) {"xmt":3,"rcv":3,"loss":0,"min":47.1,"max":276,"avg":187,"device_id":8,"debug":"[]"} 1.37ms]
- SQL[UPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? ["2020-05-11 16:57:29",187,8] 3.14ms]
- #### Load poller module core ####
- SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0']
- SNMP Check response code: 0
- Modules status: Global+
- OS
- Device
- .*.*.0 = 167765175
- .*.*.0 = Entrust Datacard
- .*.*.0 = Entrust Datacard
- .*.*.0 = Datacard Printer
- .*.*.0 = .*.*.3.9.1
- .*.*.0 = Datacard CD800 C42970
- 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: 19 days 10 hours 52 seconds
- snmpEngineTime.0 = 1677652
- hrSystemUptime.0 = No Such Object available on this agent at this OID
- Uptime seconds: 1677652
- >> Runtime for poller module 'core': 1.0981 seconds with 109152 bytes
- >> SNMP: [2/1.09s] MySQL: [0/0.00s]
- #### Unload poller module core ####
- SQL[select * from `locations` where `locations`.`id` = ? limit 1 [1] 1.23ms]
- Module [ unix-agent ] disabled globally.
- #### Load poller module os ####
- Generic :(
- Location:
- Hardware:
- Version:
- Features:
- Serial:
- >> Runtime for poller module 'os': 0.0032 seconds with 1456 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s]
- #### Unload poller module os ####
- #### Load poller module ipmi ####
- Modules status: Global-
- OS
- Device
- Modules status: Global+
- OS
- Device
- Modules status: Global+
- OS
- Device
- >> Runtime for poller module 'ipmi': 0.0024 seconds with 1640 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module ipmi ####
- #### Load poller module sensors ####
- SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [8] 1.29ms]
- array (
- )
- Modules status: Global+
- OS
- Device
- SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [8] 0.96ms]
- >> Runtime for poller module 'sensors': 0.0016 seconds with 1208 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module sensors ####
- #### Load poller module processors ####
- Modules status: Global+
- OS
- Device
- Attempting to initialize OS: generic
- OS initialized: LibreNMS\OS\Generic
- SQL[SELECT * FROM processors WHERE device_id=? [8] 1.09ms]
- SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.2021.11.11.0']
- 3%
- >> Runtime for poller module 'processors': 0.3407 seconds with 11128 bytes
- >> SNMP: [1/0.33s] MySQL: [1/0.00s]
- #### Unload poller module processors ####
- #### Load poller module mempools ####
- .*.4.1.2* = 97
- array (
- '.1.3.6.1.4.1.2021.11.11.0' => '97',
- )
- Modules status: Global+
- OS
- Device
- >> Runtime for poller module 'mempools': 0.0020 seconds with 1208 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module mempools ####
- #### Load poller module storage ####
- SQL[SELECT * FROM mempools WHERE device_id = ? [8] 1.15ms]
- Modules status: Global+
- OS
- Device
- >> Runtime for poller module 'storage': 0.0016 seconds with 1208 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module storage ####
- #### Load poller module netstats ####
- ICMPSNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'icmp']
- SQL[SELECT * FROM storage WHERE device_id = ? [8] 0.91ms]
- Modules status: Global+
- OS
- Device
- icmpInMsgs.0 = 32826
- icmpInErrors.0 = 0
- icmpInDestUnreachs.0 = 0
- icmpInTimeExcds.0 = 5660
- icmpInParmProbs.0 = 0
- icmpInSrcQuenchs.0 = 0
- icmpInRedirects.0 = 0
- icmpInEchos.0 = 0
- icmpInEchoReps.0 = 27166
- icmpInTimestamps.0 = 0
- icmpInTimestampReps.0 = 0
- icmpInAddrMasks.0 = 0
- icmpInAddrMaskReps.0 = 0
- icmpOutMsgs.0 = 0
- icmpOutErrors.0 = 27172
- icmpOutDestUnreachs.0 = 0
- icmpOutTimeExcds.0 = 6
- icmpOutParmProbs.0 = 0
- icmpOutSrcQuenchs.0 = 0
- icmpOutRedirects.0 = 0
- icmpOutEchos.0 = 0
- icmpOutEchoReps.0 = 0
- icmpOutTimestamps.0 = 27166
- icmpOutTimestampReps.0 = 0
- icmpOutAddrMasks.0 = 0
- icmpOutAddrMaskReps.0 = 0
- icmpStatsInMsgs.ipv4 = 32826
- icmpStatsInMsgs.ipv6 = 0
- icmpStatsInErrors.ipv4 = 0
- icmpStatsInErrors.ipv6 = 0
- icmpStatsOutMsgs.ipv4 = 0
- icmpStatsOutMsgs.ipv6 = 0
- icmpStatsOutErrors.ipv4 = 27172
- icmpStatsOutErrors.ipv6 = 0
- icmpMsgStatsInPkts.unknown.128 = 0
- icmpMsgStatsInPkts.unknown.130 = 0
- icmpMsgStatsInPkts.unknown.134 = 0
- icmpMsgStatsInPkts.ipv4.3 = 5660
- icmpMsgStatsInPkts.ipv4.8 = 27166
- icmpMsgStatsInPkts.ipv6.0 = 0
- icmpMsgStatsOutPkts.ipv4.0 = 27166
- icmpMsgStatsOutPkts.ipv4.3 = 6
- icmpMsgStatsOutPkts.ipv6.0 = 0
- IP
- SNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors']
- IP-FORWARDSNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0']
- ipForwDatagrams.0 = 0
- ipInDelivers.0 = 6596332
- ipInReceives.0 = 22972254
- ipOutRequests.0 = 6543771
- ipInDiscards.0 = 0
- ipOutDiscards.0 = 0
- ipOutNoRoutes.0 = 0
- ipReasmReqds.0 = 259
- ipReasmOKs.0 = 129
- ipReasmFails.0 = 1
- ipFragOKs.0 = 0
- ipFragFails.0 = 0
- ipFragCreates.0 = 0
- ipInUnknownProtos.0 = 0
- ipInHdrErrors.0 = 0
- ipInAddrErrors.0 = 1399
- SNMPSNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmp']
- No Such Object available on this agent at this OID
- TCPSNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts']
- snmpInPkts.0 = 568166
- snmpOutPkts.0 = 505955
- snmpInBadVersions.0 = 0
- snmpInBadCommunityNames.0 = 62208
- snmpInBadCommunityUses.0 = 0
- snmpInASNParseErrs.0 = 0
- snmpInTooBigs.0 = 0
- snmpInNoSuchNames.0 = 0
- snmpInBadValues.0 = 0
- snmpInReadOnlys.0 = 0
- snmpInGenErrs.0 = 0
- snmpInTotalReqVars.0 = 4216196
- snmpInTotalSetVars.0 = 0
- snmpInGetRequests.0 = 101486
- snmpInGetNexts.0 = 35978
- 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 = 505957
- snmpOutTraps.0 = 0
- snmpEnableAuthenTraps.0 = enabled
- snmpSilentDrops.0 = 0
- snmpProxyDrops.0 = 0
- tcpActiveOpens.0 = 537842
- tcpPassiveOpens.0 = 544208
- tcpAttemptFails.0 = 38
- tcpEstabResets.0 = 4
- tcpCurrEstab.0 = 4
- tcpInSegs.0 = 5992991
- tcpOutSegs.0 = 5986575
- tcpRetransSegs.0 = 10010
- tcpInErrs.0 = 0
- tcpOutRsts.0 = 44
- TCPHC
- SNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0']
- UDPSNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts']
- tcpConnectionState.ipv4."*".57256.ipv4."*".9100 = timeWait
- tcpConnectionState.ipv4."*".57256.ipv4."*".9100 = timeWait
- >> Runtime for poller module 'netstats': 1.8735 seconds with 2280 bytes
- >> SNMP: [7/1.87s] MySQL: [0/0.00s]
- #### Unload poller module netstats ####
- #### 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']
- udpInDatagrams.0 = 570681
- udpOutDatagrams.0 = 509492
- udpInErrors.0 = 0
- udpNoPorts.0 = 0
- Modules status: Global+
- OS
- Device
- >> Runtime for poller module 'hr-mib': 0.0475 seconds with 1208 bytes
- >> SNMP: [1/0.05s] MySQL: [0/0.00s]
- #### Unload poller module hr-mib ####
- #### 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']
- hrSystemProcesses.0 = No Such Object available on this agent at this OID
- hrSystemNumUsers.0 = No Such Object available on this agent at this OID
- Modules status: Global+
- OS
- Device
- 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']
- ssIndex.0 = 1
- ssErrorName.0 = systemStats
- ssSwapIn.0 = 0
- ssSwapOut.0 = 0
- ssIOSent.0 = 0
- ssIOReceive.0 = 0
- ssSysInterrupts.0 = 936
- ssSysContext.0 = 55
- ssCpuUser.0 = 1
- ssCpuSystem.0 = 0
- ssCpuIdle.0 = 97
- ssCpuRawUser.0 = 5316127
- ssCpuRawNice.0 = 0
- ssCpuRawSystem.0 = 2231842
- ssCpuRawIdle.0 = 350042124
- ssCpuRawWait.0 = 751
- ssCpuRawKernel.0 = 0
- ssCpuRawInterrupt.0 = 6798
- ssIORawSent.0 = 38104
- ssIORawReceived.0 = 159160
- ssRawInterrupts.0 = 3725701421
- ssRawContexts.0 = 203539782
- ssCpuRawSoftIRQ.0 = 129419
- ssRawSwapIn.0 = 0
- ssRawSwapOut.0 = 0
- ssCpuRawSteal.0 = 0
- ssCpuRawGuest.0 = 0
- ssCpuRawGuestNice.0 = 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']
- memTotalSwap.0 = 0
- memAvailSwap.0 = 0
- memTotalReal.0 = 246172
- memAvailReal.0 = 28652
- memTotalFree.0 = 28652
- memShared.0 = 23824
- memBuffer.0 = 38804
- memCached.0 = 135000
- >> Runtime for poller module 'ucd-mib': 0.3114 seconds with 4280 bytes
- >> SNMP: [3/0.31s] MySQL: [0/0.00s]
- #### Unload poller module ucd-mib ####
- #### Load poller module ipSystemStats ####
- SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats']
- laLoadInt.1 = 9
- laLoadInt.2 = 3
- laLoadInt.3 = 5
- Modules status: Global+
- OS
- Device
- ipv4 ipv6
- >> Runtime for poller module 'ipSystemStats': 0.3695 seconds with 16304 bytes
- >> SNMP: [1/0.37s] MySQL: [0/0.00s]
- #### Unload poller module ipSystemStats ####
- #### Load poller module ports ####
- ipSystemStatsInReceives.ipv4 = 22972093
- ipSystemStatsInReceives.ipv6 = 29041
- ipSystemStatsHCInReceives.ipv4 = 22972093
- ipSystemStatsHCInReceives.ipv6 = 29041
- ipSystemStatsInOctets.ipv6 = 3949760
- ipSystemStatsHCInOctets.ipv6 = 3949760
- ipSystemStatsInHdrErrors.ipv4 = 0
- ipSystemStatsInHdrErrors.ipv6 = 0
- ipSystemStatsInNoRoutes.ipv4 = 0
- ipSystemStatsInNoRoutes.ipv6 = 162
- ipSystemStatsInAddrErrors.ipv4 = 1399
- ipSystemStatsInAddrErrors.ipv6 = 0
- ipSystemStatsInUnknownProtos.ipv4 = 0
- ipSystemStatsInUnknownProtos.ipv6 = 0
- ipSystemStatsInTruncatedPkts.ipv4 = 0
- ipSystemStatsInTruncatedPkts.ipv6 = 0
- ipSystemStatsInForwDatagrams.ipv4 = 0
- ipSystemStatsInForwDatagrams.ipv6 = 162
- ipSystemStatsHCInForwDatagrams.ipv4 = 0
- ipSystemStatsHCInForwDatagrams.ipv6 = 162
- ipSystemStatsReasmReqds.ipv4 = 259
- ipSystemStatsReasmReqds.ipv6 = 0
- ipSystemStatsReasmOKs.ipv4 = 129
- ipSystemStatsReasmOKs.ipv6 = 0
- ipSystemStatsReasmFails.ipv4 = 1
- ipSystemStatsReasmFails.ipv6 = 0
- ipSystemStatsInDiscards.ipv4 = 0
- ipSystemStatsInDiscards.ipv6 = 28879
- ipSystemStatsInDelivers.ipv4 = 6596286
- ipSystemStatsInDelivers.ipv6 = 162
- ipSystemStatsHCInDelivers.ipv4 = 6596286
- ipSystemStatsHCInDelivers.ipv6 = 162
- ipSystemStatsOutRequests.ipv4 = 6543726
- ipSystemStatsOutRequests.ipv6 = 162
- ipSystemStatsHCOutRequests.ipv4 = 6543726
- ipSystemStatsHCOutRequests.ipv6 = 162
- ipSystemStatsOutNoRoutes.ipv4 = 0
- ipSystemStatsOutNoRoutes.ipv6 = 0
- ipSystemStatsOutForwDatagrams.ipv4 = 0
- ipSystemStatsOutForwDatagrams.ipv6 = 0
- ipSystemStatsHCOutForwDatagrams.ipv4 = 0
- ipSystemStatsHCOutForwDatagrams.ipv6 = 0
- ipSystemStatsOutDiscards.ipv4 = 0
- ipSystemStatsOutDiscards.ipv6 = 0
- ipSystemStatsOutFragReqds.ipv4 = 0
- ipSystemStatsOutFragReqds.ipv6 = 0
- ipSystemStatsOutFragOKs.ipv4 = 0
- ipSystemStatsOutFragOKs.ipv6 = 0
- ipSystemStatsOutFragFails.ipv4 = 0
- ipSystemStatsOutFragFails.ipv6 = 0
- ipSystemStatsOutFragCreates.ipv4 = 0
- ipSystemStatsOutFragCreates.ipv6 = 0
- ipSystemStatsOutTransmits.ipv4 = 6543726
- ipSystemStatsOutTransmits.ipv6 = 162
- ipSystemStatsHCOutTransmits.ipv4 = 6543726
- ipSystemStatsHCOutTransmits.ipv6 = 162
- ipSystemStatsOutOctets.ipv6 = 12078
- ipSystemStatsHCOutOctets.ipv6 = 12078
- ipSystemStatsInMcastPkts.ipv4 = 12385211
- ipSystemStatsInMcastPkts.ipv6 = 0
- ipSystemStatsHCInMcastPkts.ipv4 = 12385211
- ipSystemStatsHCInMcastPkts.ipv6 = 0
- ipSystemStatsInMcastOctets.ipv6 = 0
- ipSystemStatsHCInMcastOctets.ipv6 = 0
- ipSystemStatsOutMcastPkts.ipv4 = 239
- ipSystemStatsOutMcastPkts.ipv6 = 0
- ipSystemStatsHCOutMcastPkts.ipv4 = 239
- ipSystemStatsHCOutMcastPkts.ipv6 = 0
- ipSystemStatsOutMcastOctets.ipv6 = 0
- ipSystemStatsHCOutMcastOctets.ipv6 = 0
- ipSystemStatsInBcastPkts.ipv4 = 3985931
- ipSystemStatsHCInBcastPkts.ipv4 = 3985931
- ipSystemStatsOutBcastPkts.ipv4 = 0
- ipSystemStatsHCOutBcastPkts.ipv4 = 0
- ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00
- ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00
- ipSystemStatsRefreshRate.ipv4 = 60000
- ipSystemStatsRefreshRate.ipv6 = 60000
- Modules status: Global+
- OS
- Device
- Caching Oids: Full ports polling SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry']
- 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 [8] 3.98ms]
- ifName.1 = lo
- ifName.2 = eth0
- ifName.3 = eth1
- ifName.4 = usb0
- ifInMulticastPkts.1 = 0
- ifInMulticastPkts.2 = 0
- ifInMulticastPkts.3 = 0
- ifInMulticastPkts.4 = 0
- ifInBroadcastPkts.1 = 0
- ifInBroadcastPkts.2 = 0
- ifInBroadcastPkts.3 = 0
- ifInBroadcastPkts.4 = 0
- ifOutMulticastPkts.1 = 0
- ifOutMulticastPkts.2 = 0
- ifOutMulticastPkts.3 = 0
- ifOutMulticastPkts.4 = 0
- ifOutBroadcastPkts.1 = 0
- ifOutBroadcastPkts.2 = 0
- ifOutBroadcastPkts.3 = 0
- ifOutBroadcastPkts.4 = 0
- ifHCInOctets.1 = 17123197006
- ifHCInOctets.2 = 1274350204
- ifHCInOctets.3 = 0
- ifHCInOctets.4 = 0
- ifHCInUcastPkts.1 = 5913154
- ifHCInUcastPkts.2 = 26450586
- ifHCInUcastPkts.3 = 0
- ifHCInUcastPkts.4 = 0
- ifHCInMulticastPkts.1 = 0
- ifHCInMulticastPkts.2 = 0
- ifHCInMulticastPkts.3 = 0
- ifHCInMulticastPkts.4 = 0
- ifHCInBroadcastPkts.1 = 0
- ifHCInBroadcastPkts.2 = 0
- ifHCInBroadcastPkts.3 = 0
- ifHCInBroadcastPkts.4 = 0
- ifHCOutOctets.1 = 17123197006
- ifHCOutOctets.2 = 197057920
- ifHCOutOctets.3 = 0
- ifHCOutOctets.4 = 0
- ifHCOutUcastPkts.1 = 5913154
- ifHCOutUcastPkts.2 = 696736
- ifHCOutUcastPkts.3 = 0
- ifHCOutUcastPkts.4 = 0
- ifHCOutMulticastPkts.1 = 0
- ifHCOutMulticastPkts.2 = 0
- ifHCOutMulticastPkts.3 = 0
- ifHCOutMulticastPkts.4 = 0
- ifHCOutBroadcastPkts.1 = 0
- ifHCOutBroadcastPkts.2 = 0
- ifHCOutBroadcastPkts.3 = 0
- ifHCOutBroadcastPkts.4 = 0
- ifHighSpeed.1 = 10
- ifHighSpeed.2 = 100
- ifHighSpeed.3 = 10
- ifHighSpeed.4 = 0
- ifPromiscuousMode.1 = false
- ifPromiscuousMode.2 = false
- ifPromiscuousMode.3 = false
- ifPromiscuousMode.4 = false
- ifConnectorPresent.1 = false
- ifConnectorPresent.2 = true
- ifConnectorPresent.3 = true
- ifConnectorPresent.4 = true
- ifAlias.1 =
- ifAlias.2 =
- ifAlias.3 =
- ifAlias.4 =
- ifCounterDiscontinuityTime.1 = 0:0:00:00.00
- ifCounterDiscontinuityTime.2 = 0:0:00:00.00
- ifCounterDiscontinuityTime.3 = 0:0:00:00.00
- ifCounterDiscontinuityTime.4 = 0:0:00:00.00
- ifDescr SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifDescr']
- ifAdminStatus SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifAdminStatus']
- ifDescr.1 = lo
- ifDescr.2 = eth0
- ifDescr.3 = eth1
- ifDescr.4 = usb0
- ifAdminStatus.1 = up
- ifAdminStatus.2 = up
- ifAdminStatus.3 = up
- ifAdminStatus.4 = up
- ifOperStatus
- SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOperStatus']
- ifLastChange SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifLastChange']
- ifOperStatus.1 = up
- ifOperStatus.2 = up
- ifOperStatus.3 = down
- ifOperStatus.4 = down
- ifType SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifType']
- ifLastChange.1 = 0
- ifLastChange.2 = 0
- ifLastChange.3 = 0
- ifLastChange.4 = 0
- ifPhysAddress SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifPhysAddress']
- ifType.1 = softwareLoopback
- ifType.2 = ethernetCsmacd
- ifType.3 = ethernetCsmacd
- ifType.4 = ethernetCsmacd
- ifMtu SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifMtu']
- ifPhysAddress.1 =
- ifPhysAddress.2 = 0:2:4e:15:68:b6
- ifPhysAddress.3 = 0:2:4e:9:0:49
- ifPhysAddress.4 = 0:2:4e:16:68:b6
- ifInErrors SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInErrors']
- ifMtu.1 = 65536
- ifMtu.2 = 1500
- ifMtu.3 = 1500
- ifMtu.4 = 1500
- ifOutErrors SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutErrors']
- ifInErrors.1 = 0
- ifInErrors.2 = 0
- ifInErrors.3 = 0
- ifInErrors.4 = 0
- ifOutErrors.1 = 0
- ifOutErrors.2 = 0
- ifOutErrors.3 = 0
- ifOutErrors.4 = 0
- ifInDiscards
- SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInDiscards']
- ifInDiscards.1 = 0
- ifInDiscards.2 = 10413
- ifInDiscards.3 = 0
- ifInDiscards.4 = 0
- ifOutDiscards
- SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutDiscards']
- dot3StatsDuplexStatus
- ifOutDiscards.1 = 0
- ifOutDiscards.2 = 0
- ifOutDiscards.3 = 0
- ifOutDiscards.4 = 0
- SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus']
- SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid']
- dot3StatsDuplexStatus = No Such Object available on this agent at this OID
- Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID
- dot1qPvid = No Such Object available on this agent at this OID
- Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID
- SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [8] 2.8ms]
- array (
- 1 =>
- array (
- 'ifName' => 'lo',
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifOutMulticastPkts' => '0',
- 'ifOutBroadcastPkts' => '0',
- 'ifHCInOctets' => '17123197006',
- 'ifHCInUcastPkts' => '5913154',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '17123197006',
- 'ifHCOutUcastPkts' => '5913154',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '10',
- 'ifPromiscuousMode' => 'false',
- 'ifConnectorPresent' => 'false',
- 'ifAlias' => '',
- 'ifCounterDiscontinuityTime' => '0:0:00:00.00',
- 'ifDescr' => 'lo',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'up',
- 'ifLastChange' => '0',
- 'ifType' => 'softwareLoopback',
- 'ifPhysAddress' => '',
- 'ifMtu' => '65536',
- 'ifInErrors' => '0',
- 'ifOutErrors' => '0',
- 'ifInDiscards' => '0',
- 'ifOutDiscards' => '0',
- ),
- 2 =>
- array (
- 'ifName' => 'eth0',
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifOutMulticastPkts' => '0',
- 'ifOutBroadcastPkts' => '0',
- 'ifHCInOctets' => '1274350204',
- 'ifHCInUcastPkts' => '26450586',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '197057920',
- 'ifHCOutUcastPkts' => '696736',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '100',
- 'ifPromiscuousMode' => 'false',
- 'ifConnectorPresent' => 'true',
- 'ifAlias' => '',
- 'ifCounterDiscontinuityTime' => '0:0:00:00.00',
- 'ifDescr' => 'eth0',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'up',
- 'ifLastChange' => '0',
- 'ifType' => 'ethernetCsmacd',
- 'ifPhysAddress' => '0:2:4e:15:68:b6',
- 'ifMtu' => '1500',
- 'ifInErrors' => '0',
- 'ifOutErrors' => '0',
- 'ifInDiscards' => '10413',
- 'ifOutDiscards' => '0',
- ),
- 3 =>
- array (
- 'ifName' => 'eth1',
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifOutMulticastPkts' => '0',
- 'ifOutBroadcastPkts' => '0',
- 'ifHCInOctets' => '0',
- 'ifHCInUcastPkts' => '0',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '0',
- 'ifHCOutUcastPkts' => '0',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '10',
- 'ifPromiscuousMode' => 'false',
- 'ifConnectorPresent' => 'true',
- 'ifAlias' => '',
- 'ifCounterDiscontinuityTime' => '0:0:00:00.00',
- 'ifDescr' => 'eth1',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'down',
- 'ifLastChange' => '0',
- 'ifType' => 'ethernetCsmacd',
- 'ifPhysAddress' => '0:2:4e:9:0:49',
- 'ifMtu' => '1500',
- 'ifInErrors' => '0',
- 'ifOutErrors' => '0',
- 'ifInDiscards' => '0',
- 'ifOutDiscards' => '0',
- ),
- 4 =>
- array (
- 'ifName' => 'usb0',
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifOutMulticastPkts' => '0',
- 'ifOutBroadcastPkts' => '0',
- 'ifHCInOctets' => '0',
- 'ifHCInUcastPkts' => '0',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '0',
- 'ifHCOutUcastPkts' => '0',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '0',
- 'ifPromiscuousMode' => 'false',
- 'ifConnectorPresent' => 'true',
- 'ifAlias' => '',
- 'ifCounterDiscontinuityTime' => '0:0:00:00.00',
- 'ifDescr' => 'usb0',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'down',
- 'ifLastChange' => '0',
- 'ifType' => 'ethernetCsmacd',
- 'ifPhysAddress' => '0:2:4e:16:68:b6',
- 'ifMtu' => '1500',
- 'ifInErrors' => '0',
- 'ifOutErrors' => '0',
- 'ifInDiscards' => '0',
- 'ifOutDiscards' => '0',
- ),
- )
- valid
- valid
- valid
- valid
- Port lo: lo (1 / #230)
- ifHCInOctets
- ifHCOutOctets
- ifHCInUcastPkts
- ifHCOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- ifHighSpeed
- VLAN =
- Using ifDescr as ifAlias
- lo
- ifInOctets (92399 B) 3079.9666666667 Bps 30 secs
- ifOutOctets (92399 B) 3079.9666666667 Bps 30 secs
- bps(24.64 kbps/24.64 kbps)bytes(90.23 kB/90.23 kB)pkts(1.4 pps/1.4 pps)
- ifInErrors (0 B) 0 Bps 30 secs
- ifOutErrors (0 B) 0 Bps 30 secs
- ifInUcastPkts (42 B) 1.4 Bps 30 secs
- ifOutUcastPkts (42 B) 1.4 Bps 30 secs
- ifInNUcastPkts (0 B) 0 Bps 30 secs
- ifOutNUcastPkts (0 B) 0 Bps 30 secs
- ifInDiscards (0 B) 0 Bps 30 secs
- ifOutDiscards (0 B) 0 Bps 30 secs
- ifInUnknownProtos (0 B) 0 Bps 30 secs
- ifInBroadcastPkts (0 B) 0 Bps 30 secs
- ifOutBroadcastPkts (0 B) 0 Bps 30 secs
- ifInMulticastPkts (0 B) 0 Bps 30 secs
- ifOutMulticastPkts (0 B) 0 Bps 30 secs
- SQL[UPDATE `ports` set `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` = ? ["17123197006",17123104607,3079.9666666666667,92399,"17123197006",17123104607,3079.9666666666667,92399,"0",0,0,0,"0",0,0,0,"5913154",5913112,1.4,42,"5913154",5913112,1.4,42,1589216255,1589216225,30,230] 3.03ms]
- Port eth0: eth0 (2 / #231) VLAN = eth0bps(16.33 kbps/4.37 kbps)bytes(59.8 kB/15.98 kB)pkts(11.27 pps/2.5 pps)
- 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,230] 4.82ms]
- 1 updated
- ifHCInOctets
- ifHCOutOctets
- ifHCInUcastPkts
- ifHCOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- ifHighSpeed
- Using ifDescr as ifAlias
- ifInOctets (61238 B) 2041.2666666667 Bps 30 secs
- ifOutOctets (16367 B) 545.56666666667 Bps 30 secs
- ifInErrors (0 B) 0 Bps 30 secs
- ifOutErrors (0 B) 0 Bps 30 secs
- ifInUcastPkts (338 B) 11.266666666667 Bps 30 secs
- ifOutUcastPkts (75 B) 2.5 Bps 30 secs
- ifInNUcastPkts (0 B) 0 Bps 30 secs
- ifOutNUcastPkts (0 B) 0 Bps 30 secs
- ifInDiscards (0 B) 0 Bps 30 secs
- ifOutDiscards (0 B) 0 Bps 30 secs
- ifInUnknownProtos (0 B) 0 Bps 30 secs
- ifInBroadcastPkts (0 B) 0 Bps 30 secs
- ifOutBroadcastPkts (0 B) 0 Bps 30 secs
- ifInMulticastPkts (0 B) 0 Bps 30 secs
- ifOutMulticastPkts (0 B) 0 Bps 30 secs
- SQL[UPDATE `ports` set `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` = ? ["1274350204",1274288966,2041.2666666666667,61238,"197057920",197041553,545.5666666666667,16367,"0",0,0,0,"0",0,0,0,"26450586",26450248,11.266666666666667,338,"696736",696661,2.5,75,1589216255,1589216225,30,231] 3.43ms]
- Port eth1: eth1 (3 / #232) VLAN =
- 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,"10413",10413,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,231] 3.56ms]
- 1 updated
- ifInOctets
- ifOutOctets
- ifInUcastPkts
- ifOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- ifHighSpeed
- Using ifDescr as ifAlias
- eth1
- Port usb0: usb0 (4 / #233) VLAN = usb0
- 232 skipped because port is still down since last polling.
- ifInOctets
- ifOutOctets
- ifInUcastPkts
- ifOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- ifHighSpeed
- Using ifDescr as ifAlias
- 233 skipped because port is still down since last polling.
- SQL[UPDATE `ports` set `ifSpeed_prev`=?,`ifHighSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0,"0",1589216255,1589216225,30,233] 0.99ms]
- 1 updated
- >> Runtime for poller module 'ports': 1.5519 seconds with 14600 bytes
- >> SNMP: [14/1.51s] MySQL: [6/0.02s]
- #### Unload poller module ports ####
- #### Load poller module customoid ####
- >> Runtime for poller module 'customoid': 0.0013 seconds with 1120 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module customoid ####
- SQL[update `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where `port_id` in (?) [1589216255,1589216225,1589216255,232] 0.69ms]
- 1 updated
- Modules status: Global+
- OS
- Device
- SQL[SELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [8] 0.72ms]
- Modules status: Global+
- OS
- Device
- #### Load poller module bgp-peers ####
- >> Runtime for poller module 'bgp-peers': 0.0037 seconds with 1208 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module bgp-peers ####
- Module [ junose-atm-vp ] disabled globally.
- Module [ toner ] disabled globally.
- #### Load poller module ucd-diskio ####
- SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [8] 1.23ms]
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global+
- OS
- Device
- >> Runtime for poller module 'ucd-diskio': 0.0014 seconds with 1208 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module ucd-diskio ####
- Module [ wifi ] disabled globally.
- #### Load poller module wireless ####
- SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = ? [8] 0.66ms]
- Modules status: Global-
- OS
- Device
- Modules status: Global+
- OS
- Device
- Attempting to initialize OS: generic
- OS initialized: LibreNMS\OS\Generic
- >> Runtime for poller module 'wireless': 0.0118 seconds with 86408 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.01s]
- #### Unload poller module wireless ####
- Module [ ospf ] disabled on host.
- Module [ cisco-ipsec-flow-monitor ] disabled globally.
- Module [ cisco-remote-access-monitor ] disabled globally.
- Module [ cisco-cef ] disabled globally.
- Module [ cisco-sla ] disabled globally.
- Module [ cisco-mac-accounting ] disabled globally.
- Module [ cipsec-tunnels ] disabled globally.
- Module [ cisco-ace-loadbalancer ] disabled globally.
- Module [ cisco-ace-serverfarms ] disabled globally.
- Module [ cisco-asa-firewall ] disabled globally.
- Module [ cisco-voice ] disabled globally.
- Module [ cisco-cbqos ] disabled globally.
- Module [ cisco-otv ] disabled globally.
- Module [ cisco-qfp ] disabled globally.
- Module [ cisco-vpdn ] disabled globally.
- Module [ nac ] disabled globally.
- Module [ netscaler-vsvr ] disabled globally.
- Module [ aruba-controller ] disabled globally.
- #### Load poller module entity-physical ####
- SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [8] 6.52ms]
- Modules status: Global+
- OS
- Device-
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global+
- OS
- Device
- >> Runtime for poller module 'entity-physical': 0.0017 seconds with 1304 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module entity-physical ####
- Module [ entity-state ] disabled globally.
- #### Load poller module applications ####
- SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = ? [8] 0.73ms]
- Modules status: Global-
- OS
- Device
- Modules status: Global+
- OS
- Device
- >> Runtime for poller module 'applications': 0.0012 seconds with 1208 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module applications ####
- Module [ mib ] disabled globally.
- #### Load poller module stp ####
- SQL[SELECT * FROM `applications` WHERE `device_id` = ? [8] 0.77ms]
- Modules status: Global-
- OS
- Device
- Modules status: Global+
- OS
- Device
- SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0']
- SQL[SELECT * FROM `stp` WHERE `device_id` = ? [8] 0.93ms]
- >> Runtime for poller module 'stp': 0.2016 seconds with 2296 bytes
- >> SNMP: [1/0.20s] MySQL: [1/0.00s]
- #### Unload poller module stp ####
- No Such Object available on this agent at this OID
- Module [ ntp ] disabled on host.
- Module [ loadbalancers ] disabled globally.
- Module [ mef ] disabled globally.
- #### Load poller module mpls ####
- >> Runtime for poller module 'mpls': 0.0015 seconds with 1392 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s]
- #### Unload poller module mpls ####
- ### Start Device Groups ###
- Modules status: Global+
- OS
- Device-
- Modules status: Global-
- OS
- Device
- Modules status: Global-
- OS
- Device
- Modules status: Global+
- OS
- Device
- Attempting to initialize OS: generic
- OS initialized: LibreNMS\OS\Generic
- SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [8] 1.57ms]
- SQL[select * from `device_groups` [] 0.54ms]
- SQL[select `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2) [] 1.28ms]
- SQL[select exists(select * from `devices` left join `locations` on `locations`.`id` = `devices`.`location_id` where (`locations`.`location` LIKE ?) and `devices`.`device_id` = ?) as `exists` ["640 NE 20th%",8] 1.13ms]
- SQL[select exists(select * from `devices` left join `locations` on `locations`.`id` = `devices`.`location_id` where (`locations`.`location` LIKE ?) and `devices`.`device_id` = ?) as `exists` ["estin Building%",8] 0.85ms]
- SQL[select * from `device_group_device` where `device_id` = ? [8] 0.8ms]
- Groups Added:
- Groups Removed:
- ### End Device Groups, runtime: 0.024s ###
- Enabling graphs:
- uptime netstat_icmp netstat_icmp_info netstat_ip netstat_ip_frag netstat_snmp netstat_snmp_pkt netstat_tcp netstat_udp ucd_cpu ucd_swap_io ucd_io ucd_contexts ucd_interrupts ucd_io_wait ucd_cpu_steal ucd_memory ucd_load ipsystemstats_ipv4 ipsystemstats_ipv4_frag ipsystemstats_ipv6 ipsystemstats_ipv6_frag
- SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [8] 0.87ms]
- Polled in 7.012 seconds
- #### Start Alerts ####
- SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [1677652,187,7.012,8] 0.99ms]
- Updating erin-cd800.catgirls.dev
- SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [8] 1.37ms]
- 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` = ? [8] 6.39ms]
- SQL[select * from `locations` where `locations`.`id` = ? limit 1 [1] 1.01ms]
- SQL[select exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = ? and `start` <= NOW() and `end` >= NOW()) or (`recurring` = ? and (`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` = ? or `end_recurring_dt` = ?)) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), ''), '%') or `recurring_day` is null or `recurring_day` = ?))) and ((`alert_schedulable_type` = ? and `alert_schedulable_id` = ?) or (`alert_schedulable_type` = ? and `alert_schedulable_id` in (?)) or (`alert_schedulable_type` = ? and `alert_schedulable_id` = ?))) as `exists` [0,1,"0000-00-00","","","device",8,"device_group",1,"location",1] 1.24ms]
- SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [8] 0.94ms]
- Rule #1 (Device Down! Due to no ICMP response.):
- 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))
- ) [8,8,8,8,8,8,8,8] 3.47ms]
- SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [8] 1.07ms]
- Status: NOCHG
- Rule #2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,8] 0.68ms]
- SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [8] 1.09ms]
- Status: NOCHG
- Rule #3 (Device rebooted):
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,8] 0.62ms]
- SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 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 bgpPeers.bgpPeerState = "established" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [8] 1.83ms]
- Status: NOCHG
- Rule #9 (Sensor over limit - Check Device Health Settings):
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [8,8] 1.3ms]
- 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 [8] 1.54ms]
- Status: NOCHG
- Rule #10 (Sensor under limit - Check Device Health Settings):
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [9,8] 0.67ms]
- 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 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= customoids.customoid_limit AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [8] 1.31ms]
- Status: NOCHG
- Rule #16 (CustomOID under limit):
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [15,8] 0.59ms]
- SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current <= customoids.customoid_limit_low AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [8] 1.98ms]
- Status: NOCHG
- Rule #17 (CustomOID over warning limit):
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [16,8] 0.6ms]
- SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current >= customoids.customoid_limit_warn AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [8] 1.21ms]
- Status: NOCHG
- Rule #18 (CustomOID under warning limit):
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [17,8] 0.59ms]
- SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current <= customoids.customoid_limit_low_warn AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [8] 1.26ms]
- Status: NOCHG
- Rule #19 (Swap above 256MB):
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [18,8] 0.59ms]
- SQL[SELECT * FROM devices,mempools WHERE (devices.device_id = ? AND devices.device_id = mempools.device_id) AND mempools.mempool_descr = "Swap space" AND mempools.mempool_used >= 268435456 [8] 1.17ms]
- Status: NOCHG
- Rule #38 (Swap above 1GB):
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [19,8] 0.62ms]
- SQL[SELECT * FROM devices,mempools WHERE (devices.device_id = ? AND devices.device_id = mempools.device_id) AND mempools.mempool_descr = "Swap space" AND mempools.mempool_used >= 1073741824 [8] 0.96ms]
- Status: NOCHG
- #### End Alerts ####
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [38,8] 0.49ms]
- SNMP [31/5.79s]: Get[9/1.98s] Getnext[4/0.41s] Walk[18/3.39s]
- MySQL [41/0.08s]: Cell[18/0.02s] Row[-17/-0.02s] Rows[31/0.06s] Column[0/0.00s] Update[7/0.02s] Insert[2/0.00s] Delete[0/0.00s]
- SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"erin-cd800.catgirls.dev","start":1589216248.322053,"duration":"7.325","devices":1,"poller":"\/"} 0.65ms]
- /opt/librenms/poller.php erin-cd800.catgirls.dev 2020-05-11 16:57:35 - 1 devices polled in 7.325 secs