- LibreNMS Poller
- SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.66ms]
- SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.52ms]
- SQL[SELECT version() [] 0.43ms]
- ===================================
- Version info:
- Commit SHA: 411f36a9a1d6aaad47e8ae3ad3547715c58170ed
- Commit Date: 1551670633
- DB Schema: 2019_02_10_220000_add_dates_to_fdb (132)
- PHP: 7.3.2-3+ubuntu18.04.1+deb.sury.org+1
- MySQL: 5.6.42
- RRDTool: 1.7.0
- SNMP: NET-SNMP 5.7.3
- ==================================DEBUG!
- Updating os_def.cache...
- Done
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.71.12' ORDER BY `device_id` ASC [] 1ms]
- SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [3324] 0.56ms]
- Hostname: 192.168.71.12
- Device ID: 3324
- OS: airos-af-ltu (ubnt)
- [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 192.168.71.12
- array (
- 'xmt' => '3',
- 'rcv' => '3',
- 'loss' => '0',
- 'min' => '0.62',
- 'max' => '2.33',
- 'avg' => '1.23',
- '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":"0.62","max":"2.33","avg":"1.23","device_id":3324,"debug":"[]"} 10.55ms]
- 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:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0']
- .*.*.0 = 518851693
- .*.*.0 = Novelda
- .*.*.0 = daniel.cableworld@gmail.com
- .*.*.0 = EN-5HD-HORNA-CREVISA-AP
- .*.*.0 = .*.4.1.8*
- .*.*.0 = Linux EN-5HD-HORNA-CREVISA-AP 3.14.65 #1 SMP PREEMPT RT Fri Jan 11 10:30:10 UTC 2019 armv7l
- SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0']
- snmpEngineTime.0 = No Such Object available on this agent at this OID
- hrSystemUptime.0 = 34382672
- Uptime seconds: 5188517
- RRD[last 192.168.71.12/uptime.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/uptime.rrd N:5188517 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Uptime: 60 days, 1h 15m 17s
- SQL[select * from `locations` where (`location` = ?) limit 1 ["Novelda"] 0.77ms]
- >> Runtime for poller module 'core': 0.0255 seconds with 88744 bytes
- >> SNMP: [2/0.02s] MySQL: [0/0.00s] RRD: [2/0.00s]
- #### Unload poller module core ####
- RRD[last 192.168.71.12/poller-perf-core.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-core.rrd N:0.02554988861084 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Modules status: Global-
- OS
- Device
- Module [ unix-agent ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module os ####
- SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UBNT-AFLTU-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'afLTUDevModel.0' 'afLTUFirmwareVersion.0']
- afLTUDevModel.0 = airFiber 5XHD
- afLTUFirmwareVersion.0 = .v1.1.2
- Hardware: airFiber 5XHD
- Version: .v1.1.2
- Features:
- Serial:
- >> Runtime for poller module 'os': 0.5881 seconds with 115488 bytes
- >> SNMP: [1/0.59s] MySQL: [0/0.00s] RRD: [2/0.00s]
- #### Unload poller module os ####
- RRD[last 192.168.71.12/poller-perf-os.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-os.rrd N:0.58809804916382 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Modules status: Global+
- OS
- Device
- #### Load poller module ipmi ####
- SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [3324] 0.66ms]
- array (
- )
- >> Runtime for poller module 'ipmi': 0.0012 seconds with 2792 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [2/0.00s]
- #### Unload poller module ipmi ####
- RRD[last 192.168.71.12/poller-perf-ipmi.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-ipmi.rrd N:0.001244068145752 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Modules status: Global-
- OS
- Device
- Module [ sensors ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ processors ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ mempools ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ storage ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module netstats ####
- ICMPSNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'icmp']
- icmpInMsgs.0 = 16186
- icmpInErrors.0 = 0
- icmpInDestUnreachs.0 = 0
- icmpInTimeExcds.0 = 181
- icmpInParmProbs.0 = 0
- icmpInSrcQuenchs.0 = 0
- icmpInRedirects.0 = 0
- icmpInEchos.0 = 0
- icmpInEchoReps.0 = 13785
- icmpInTimestamps.0 = 2220
- icmpInTimestampReps.0 = 0
- icmpInAddrMasks.0 = 0
- icmpInAddrMaskReps.0 = 0
- icmpOutMsgs.0 = 0
- icmpOutErrors.0 = 13831
- icmpOutDestUnreachs.0 = 0
- icmpOutTimeExcds.0 = 0
- icmpOutParmProbs.0 = 0
- icmpOutSrcQuenchs.0 = 0
- icmpOutRedirects.0 = 0
- icmpOutEchos.0 = 0
- icmpOutEchoReps.0 = 46
- icmpOutTimestamps.0 = 13785
- icmpOutTimestampReps.0 = 0
- icmpOutAddrMasks.0 = 0
- icmpOutAddrMaskReps.0 = 0
- RRD[last 192.168.71.12/netstats-icmp.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/netstats-icmp.rrd N:16186:0:0:13831:0:0:13785:46:0:0:0:181:0:0:2220:0:0:0:0:0:0:0:13785:0:0:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- IPSNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' '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']
- : Unknown Object Identifier (Sub-id not found: (top) -> )
- IP-FORWARDSNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0']
- No Such Object available on this agent at this OID
- SNMPSNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'snmp']
- snmpInPkts.0 = 367406
- snmpOutPkts.0 = 367406
- snmpInBadVersions.0 = 0
- snmpInBadCommunityNames.0 = 0
- snmpInBadCommunityUses.0 = 0
- snmpInASNParseErrs.0 = 0
- snmpInTooBigs.0 = 0
- snmpInNoSuchNames.0 = 0
- snmpInBadValues.0 = 0
- snmpInReadOnlys.0 = 0
- snmpInGenErrs.0 = 0
- snmpInTotalReqVars.0 = 411377
- snmpInTotalSetVars.0 = 0
- snmpInGetRequests.0 = 15732
- snmpInGetNexts.0 = 351687
- snmpInSetRequests.0 = 0
- snmpInGetResponses.0 = 0
- snmpInTraps.0 = 0
- snmpOutTooBigs.0 = 0
- snmpOutNoSuchNames.0 = 1
- snmpOutBadValues.0 = 0
- snmpOutGenErrs.0 = 0
- snmpOutGetRequests.0 = 0
- snmpOutGetNexts.0 = 0
- snmpOutSetRequests.0 = 0
- snmpOutGetResponses.0 = 367430
- snmpOutTraps.0 = 0
- snmpEnableAuthenTraps.0 = disabled
- snmpSilentDrops.0 = 0
- snmpProxyDrops.0 = 0
- RRD[last 192.168.71.12/netstats-snmp.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/netstats-snmp.rrd N:367406:367406:0:0:0:0:0:0:0:0:0:411377:0:15732:351687:0:0:0:0:1:0:0:0:0:0:367430:0:0:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- TCPSNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' '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']
- : Unknown Object Identifier (Sub-id not found: (top) -> )
- UDPSNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' "" 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0']
- : Unknown Object Identifier (Sub-id not found: (top) -> )
- >> Runtime for poller module 'netstats': 0.1817 seconds with 4272 bytes
- >> SNMP: [6/0.18s] MySQL: [0/0.00s] RRD: [6/0.00s]
- #### Unload poller module netstats ####
- RRD[last 192.168.71.12/poller-perf-netstats.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-netstats.rrd N:0.18170404434204 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- 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:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0']
- hrSystemProcesses.0 = No Such Instance currently exists at this OID
- hrSystemNumUsers.0 = 0
- RRD[last 192.168.71.12/hr_users.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/hr_users.rrd N:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Users
- >> Runtime for poller module 'hr-mib': 0.0123 seconds with 3240 bytes
- >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [4/0.00s]
- #### Unload poller module hr-mib ####
- RRD[last 192.168.71.12/poller-perf-hr-mib.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-hr-mib.rrd N:0.012347936630249 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Modules status: Global+
- OS
- Device
- #### Load poller module ucd-mib ####
- SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'systemStats']
- ssIndex.0 = 1
- ssErrorName.0 = systemStats
- ssSwapIn.0 = 0
- ssSwapOut.0 = 0
- ssIOSent.0 = 0
- ssIOReceive.0 = 0
- ssSysInterrupts.0 = 4196
- ssSysContext.0 = 11590
- ssCpuUser.0 = 4
- ssCpuSystem.0 = 11
- ssCpuIdle.0 = 84
- ssCpuRawUser.0 = 3322846
- ssCpuRawNice.0 = 0
- ssCpuRawSystem.0 = 10459957
- ssCpuRawIdle.0 = 54964769
- ssCpuRawWait.0 = 997
- ssCpuRawKernel.0 = 0
- ssCpuRawInterrupt.0 = 0
- ssIORawSent.0 = 0
- ssIORawReceived.0 = 55270
- ssRawInterrupts.0 = 1565840563
- ssRawContexts.0 = 4280046470
- ssCpuRawSoftIRQ.0 = 16265
- ssRawSwapIn.0 = 0
- ssRawSwapOut.0 = 0
- RRD[last 192.168.71.12/ucd_cpu.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_cpu.rrd N:3322846:10459957:0:54964769 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssCpuRawUser.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssCpuRawUser.rrd N:3322846 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssCpuRawNice.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssCpuRawNice.rrd N:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssCpuRawSystem.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssCpuRawSystem.rrd N:10459957 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssCpuRawIdle.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssCpuRawIdle.rrd N:54964769 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssCpuRawInterrupt.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssCpuRawInterrupt.rrd N:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssCpuRawSoftIRQ.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssCpuRawSoftIRQ.rrd N:16265 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssCpuRawKernel.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssCpuRawKernel.rrd N:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssCpuRawWait.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssCpuRawWait.rrd N:997 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssIORawSent.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssIORawSent.rrd N:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssIORawReceived.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssIORawReceived.rrd N:55270 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssRawInterrupts.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssRawInterrupts.rrd N:1565840563 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssRawContexts.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssRawContexts.rrd N:4280046470 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssRawSwapIn.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssRawSwapIn.rrd N:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/ucd_ssRawSwapOut.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_ssRawSwapOut.rrd N:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'memTotalSwap.0' 'memAvailSwap.0' 'memTotalReal.0' 'memAvailReal.0' 'memTotalFree.0' 'memShared.0' 'memBuffer.0' 'memCached.0']
- memTotalSwap.0 = 0
- memAvailSwap.0 = 0
- memTotalReal.0 = 249744
- memAvailReal.0 = 45472
- memTotalFree.0 = 45472
- memShared.0 = 0
- memBuffer.0 = 9412
- memCached.0 = 23020
- RRD[last 192.168.71.12/ucd_mem.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_mem.rrd N:0:0:249744:45472:45472:0:9412:23020 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3']
- laLoadInt.1 = 386
- laLoadInt.2 = 348
- laLoadInt.3 = 355
- RRD[last 192.168.71.12/ucd_load.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ucd_load.rrd N:386:348:355 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- >> Runtime for poller module 'ucd-mib': 0.0726 seconds with 5312 bytes
- >> SNMP: [3/0.07s] MySQL: [0/0.00s] RRD: [36/0.01s]
- #### Unload poller module ucd-mib ####
- RRD[last 192.168.71.12/poller-perf-ucd-mib.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-ucd-mib.rrd N:0.072597980499268 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Modules status: Global+
- OS
- Device
- #### Load poller module ipSystemStats ####
- SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ipSystemStats']
- ipSystemStatsTable = No Such Object available on this agent at this OID
- >> Runtime for poller module 'ipSystemStats': 0.0156 seconds with 1968 bytes
- >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [2/0.00s]
- #### Unload poller module ipSystemStats ####
- RRD[last 192.168.71.12/poller-perf-ipSystemStats.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-ipSystemStats.rrd N:0.015629053115845 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- 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 [3324] 1.9ms]
- Caching Oids: Full ports polling SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifXEntry']
- ifName.1 = lo
- ifName.2 = eth0
- ifName.4 = ath0
- ifName.5 = ath0.71
- ifName.6 = br0
- ifName.7 = br2
- ifName.8 = br-mvlan
- ifInMulticastPkts.1 = 0
- ifInMulticastPkts.2 = 0
- ifInMulticastPkts.4 = 0
- ifInMulticastPkts.5 = 0
- ifInMulticastPkts.6 = 0
- ifInMulticastPkts.7 = 0
- ifInMulticastPkts.8 = 0
- ifInBroadcastPkts.1 = 0
- ifInBroadcastPkts.2 = 0
- ifInBroadcastPkts.4 = 0
- ifInBroadcastPkts.5 = 0
- ifInBroadcastPkts.6 = 0
- ifInBroadcastPkts.7 = 0
- ifInBroadcastPkts.8 = 0
- ifOutMulticastPkts.1 = 0
- ifOutMulticastPkts.2 = 0
- ifOutMulticastPkts.4 = 0
- ifOutMulticastPkts.5 = 0
- ifOutMulticastPkts.6 = 0
- ifOutMulticastPkts.7 = 0
- ifOutMulticastPkts.8 = 0
- ifOutBroadcastPkts.1 = 0
- ifOutBroadcastPkts.2 = 0
- ifOutBroadcastPkts.4 = 0
- ifOutBroadcastPkts.5 = 0
- ifOutBroadcastPkts.6 = 0
- ifOutBroadcastPkts.7 = 0
- ifOutBroadcastPkts.8 = 0
- ifHCInOctets.1 = 4297
- ifHCInOctets.2 = 0
- ifHCInOctets.4 = 301001760
- ifHCInOctets.5 = 75857718
- ifHCInOctets.6 = 189757938
- ifHCInOctets.7 = 0
- ifHCInOctets.8 = 75857718
- ifHCInUcastPkts.1 = 54
- ifHCInUcastPkts.2 = 0
- ifHCInUcastPkts.4 = 1997279
- ifHCInUcastPkts.5 = 599356
- ifHCInUcastPkts.6 = 1397907
- ifHCInUcastPkts.7 = 0
- ifHCInUcastPkts.8 = 599356
- ifHCInMulticastPkts.1 = 0
- ifHCInMulticastPkts.2 = 0
- ifHCInMulticastPkts.4 = 0
- ifHCInMulticastPkts.5 = 0
- ifHCInMulticastPkts.6 = 0
- ifHCInMulticastPkts.7 = 0
- ifHCInMulticastPkts.8 = 0
- ifHCInBroadcastPkts.1 = 0
- ifHCInBroadcastPkts.2 = 0
- ifHCInBroadcastPkts.4 = 0
- ifHCInBroadcastPkts.5 = 0
- ifHCInBroadcastPkts.6 = 0
- ifHCInBroadcastPkts.7 = 0
- ifHCInBroadcastPkts.8 = 0
- ifHCOutOctets.1 = 4297
- ifHCOutOctets.2 = 802
- ifHCOutOctets.4 = 163311068
- ifHCOutOctets.5 = 103804008
- ifHCOutOctets.6 = 398
- ifHCOutOctets.7 = 508
- ifHCOutOctets.8 = 103803946
- ifHCOutUcastPkts.1 = 54
- ifHCOutUcastPkts.2 = 9
- ifHCOutUcastPkts.4 = 669622
- ifHCOutUcastPkts.5 = 528139
- ifHCOutUcastPkts.6 = 5
- ifHCOutUcastPkts.7 = 6
- ifHCOutUcastPkts.8 = 528138
- ifHCOutMulticastPkts.1 = 0
- ifHCOutMulticastPkts.2 = 0
- ifHCOutMulticastPkts.4 = 0
- ifHCOutMulticastPkts.5 = 0
- ifHCOutMulticastPkts.6 = 0
- ifHCOutMulticastPkts.7 = 0
- ifHCOutMulticastPkts.8 = 0
- ifHCOutBroadcastPkts.1 = 0
- ifHCOutBroadcastPkts.2 = 0
- ifHCOutBroadcastPkts.4 = 0
- ifHCOutBroadcastPkts.5 = 0
- ifHCOutBroadcastPkts.6 = 0
- ifHCOutBroadcastPkts.7 = 0
- ifHCOutBroadcastPkts.8 = 0
- ifHighSpeed.1 = 10
- ifHighSpeed.2 = 10
- ifHighSpeed.4 = 1000
- ifHighSpeed.5 = 1000
- ifHighSpeed.6 = 0
- ifHighSpeed.7 = 0
- ifHighSpeed.8 = 0
- ifPromiscuousMode.1 = false
- ifPromiscuousMode.2 = false
- ifPromiscuousMode.4 = false
- ifPromiscuousMode.5 = false
- ifPromiscuousMode.6 = false
- ifPromiscuousMode.7 = false
- ifPromiscuousMode.8 = false
- ifConnectorPresent.2 = true
- ifConnectorPresent.4 = true
- ifConnectorPresent.5 = true
- ifConnectorPresent.6 = true
- ifConnectorPresent.7 = true
- ifConnectorPresent.8 = true
- ifAlias.1 =
- ifAlias.2 =
- ifAlias.4 =
- ifAlias.5 =
- ifAlias.6 =
- ifAlias.7 =
- ifAlias.8 =
- ifCounterDiscontinuityTime.1 = 0:0:00:00.00
- ifCounterDiscontinuityTime.2 = 0:0:00:00.00
- ifCounterDiscontinuityTime.4 = 0:0:00:00.00
- ifCounterDiscontinuityTime.5 = 0:0:00:00.00
- ifCounterDiscontinuityTime.6 = 0:0:00:00.00
- ifCounterDiscontinuityTime.7 = 0:0:00:00.00
- ifCounterDiscontinuityTime.8 = 0:0:00:00.00
- ifDescr SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifDescr']
- ifDescr.1 = lo
- ifDescr.2 = eth0
- ifDescr.4 = ath0
- ifDescr.5 = ath0.71
- ifDescr.6 = br0
- ifDescr.7 = br2
- ifDescr.8 = br-mvlan
- ifAdminStatus SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifAdminStatus']
- ifAdminStatus.1 = up
- ifAdminStatus.2 = up
- ifAdminStatus.4 = up
- ifAdminStatus.5 = up
- ifAdminStatus.6 = up
- ifAdminStatus.7 = up
- ifAdminStatus.8 = up
- ifOperStatus SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifOperStatus']
- ifOperStatus.1 = up
- ifOperStatus.2 = down
- ifOperStatus.4 = up
- ifOperStatus.5 = up
- ifOperStatus.6 = up
- ifOperStatus.7 = down
- ifOperStatus.8 = up
- ifLastChange SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifLastChange']
- ifLastChange.1 = 0
- ifLastChange.2 = 0
- ifLastChange.4 = 484472069
- ifLastChange.5 = 484472069
- ifLastChange.6 = 484472069
- ifLastChange.7 = 484472069
- ifLastChange.8 = 484472069
- ifType SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifType']
- ifType.1 = softwareLoopback
- ifType.2 = ethernetCsmacd
- ifType.4 = ethernetCsmacd
- ifType.5 = ethernetCsmacd
- ifType.6 = ethernetCsmacd
- ifType.7 = ethernetCsmacd
- ifType.8 = ethernetCsmacd
- ifPhysAddress SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifPhysAddress']
- ifPhysAddress.1 =
- ifPhysAddress.2 = 7a:8a:20:5f:ae:0
- ifPhysAddress.4 = 78:8a:20:5f:ae:0
- ifPhysAddress.5 = 78:8a:20:5f:ae:0
- ifPhysAddress.6 = 78:8a:20:5f:ae:0
- ifPhysAddress.7 = 7a:8a:20:5f:ae:0
- ifPhysAddress.8 = 78:8a:20:5f:ae:0
- ifMtu SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifMtu']
- ifMtu.1 = 65536
- ifMtu.2 = 1500
- ifMtu.4 = 1500
- ifMtu.5 = 1500
- ifMtu.6 = 1500
- ifMtu.7 = 1500
- ifMtu.8 = 1500
- ifInErrors SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifInErrors']
- ifInErrors.1 = 0
- ifInErrors.2 = 0
- ifInErrors.4 = 0
- ifInErrors.5 = 0
- ifInErrors.6 = 0
- ifInErrors.7 = 0
- ifInErrors.8 = 0
- ifOutErrors SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifOutErrors']
- ifOutErrors.1 = 0
- ifOutErrors.2 = 0
- ifOutErrors.4 = 0
- ifOutErrors.5 = 0
- ifOutErrors.6 = 0
- ifOutErrors.7 = 0
- ifOutErrors.8 = 0
- ifInDiscards SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifInDiscards']
- ifInDiscards.1 = 0
- ifInDiscards.2 = 0
- ifInDiscards.4 = 0
- ifInDiscards.5 = 0
- ifInDiscards.6 = 18052
- ifInDiscards.7 = 0
- ifInDiscards.8 = 116
- ifOutDiscards SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'ifOutDiscards']
- ifOutDiscards.1 = 0
- ifOutDiscards.2 = 0
- ifOutDiscards.4 = 0
- ifOutDiscards.5 = 0
- ifOutDiscards.6 = 0
- ifOutDiscards.7 = 0
- ifOutDiscards.8 = 0
- dot3StatsDuplexStatusSNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus']
- dot3StatsDuplexStatus = No Such Object available on this agent at this OID
- SNMP['/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ubnt' 'udp:HOSTNAME:161' 'dot1qPvid']
- dot1qPvid = No Such Object available on this agent at this OID
- SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [3324] 0.76ms]
- array (
- 1 =>
- array (
- 'ifName' => 'lo',
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifOutMulticastPkts' => '0',
- 'ifOutBroadcastPkts' => '0',
- 'ifHCInOctets' => '4297',
- 'ifHCInUcastPkts' => '54',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '4297',
- 'ifHCOutUcastPkts' => '54',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '10',
- 'ifPromiscuousMode' => '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' => '0',
- 'ifHCInUcastPkts' => '0',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '802',
- 'ifHCOutUcastPkts' => '9',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '10',
- 'ifPromiscuousMode' => 'false',
- 'ifConnectorPresent' => 'true',
- 'ifAlias' => '',
- 'ifCounterDiscontinuityTime' => '0:0:00:00.00',
- 'ifDescr' => 'eth0',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'down',
- 'ifLastChange' => '0',
- 'ifType' => 'ethernetCsmacd',
- 'ifPhysAddress' => '7a:8a:20:5f:ae:0',
- 'ifMtu' => '1500',
- 'ifInErrors' => '0',
- 'ifOutErrors' => '0',
- 'ifInDiscards' => '0',
- 'ifOutDiscards' => '0',
- ),
- 4 =>
- array (
- 'ifName' => 'ath0',
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifOutMulticastPkts' => '0',
- 'ifOutBroadcastPkts' => '0',
- 'ifHCInOctets' => '301001760',
- 'ifHCInUcastPkts' => '1997279',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '163311068',
- 'ifHCOutUcastPkts' => '669622',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '1000',
- 'ifPromiscuousMode' => 'false',
- 'ifConnectorPresent' => 'true',
- 'ifAlias' => '',
- 'ifCounterDiscontinuityTime' => '0:0:00:00.00',
- 'ifDescr' => 'ath0',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'up',
- 'ifLastChange' => '484472069',
- 'ifType' => 'ethernetCsmacd',
- 'ifPhysAddress' => '78:8a:20:5f:ae:0',
- 'ifMtu' => '1500',
- 'ifInErrors' => '0',
- 'ifOutErrors' => '0',
- 'ifInDiscards' => '0',
- 'ifOutDiscards' => '0',
- ),
- 5 =>
- array (
- 'ifName' => 'ath0.71',
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifOutMulticastPkts' => '0',
- 'ifOutBroadcastPkts' => '0',
- 'ifHCInOctets' => '75857718',
- 'ifHCInUcastPkts' => '599356',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '103804008',
- 'ifHCOutUcastPkts' => '528139',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '1000',
- 'ifPromiscuousMode' => 'false',
- 'ifConnectorPresent' => 'true',
- 'ifAlias' => '',
- 'ifCounterDiscontinuityTime' => '0:0:00:00.00',
- 'ifDescr' => 'ath0.71',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'up',
- 'ifLastChange' => '484472069',
- 'ifType' => 'ethernetCsmacd',
- 'ifPhysAddress' => '78:8a:20:5f:ae:0',
- 'ifMtu' => '1500',
- 'ifInErrors' => '0',
- 'ifOutErrors' => '0',
- 'ifInDiscards' => '0',
- 'ifOutDiscards' => '0',
- ),
- 6 =>
- array (
- 'ifName' => 'br0',
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifOutMulticastPkts' => '0',
- 'ifOutBroadcastPkts' => '0',
- 'ifHCInOctets' => '189757938',
- 'ifHCInUcastPkts' => '1397907',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '398',
- 'ifHCOutUcastPkts' => '5',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '0',
- 'ifPromiscuousMode' => 'false',
- 'ifConnectorPresent' => 'true',
- 'ifAlias' => '',
- 'ifCounterDiscontinuityTime' => '0:0:00:00.00',
- 'ifDescr' => 'br0',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'up',
- 'ifLastChange' => '484472069',
- 'ifType' => 'ethernetCsmacd',
- 'ifPhysAddress' => '78:8a:20:5f:ae:0',
- 'ifMtu' => '1500',
- 'ifInErrors' => '0',
- 'ifOutErrors' => '0',
- 'ifInDiscards' => '18052',
- 'ifOutDiscards' => '0',
- ),
- 7 =>
- array (
- 'ifName' => 'br2',
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifOutMulticastPkts' => '0',
- 'ifOutBroadcastPkts' => '0',
- 'ifHCInOctets' => '0',
- 'ifHCInUcastPkts' => '0',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '508',
- 'ifHCOutUcastPkts' => '6',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '0',
- 'ifPromiscuousMode' => 'false',
- 'ifConnectorPresent' => 'true',
- 'ifAlias' => '',
- 'ifCounterDiscontinuityTime' => '0:0:00:00.00',
- 'ifDescr' => 'br2',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'down',
- 'ifLastChange' => '484472069',
- 'ifType' => 'ethernetCsmacd',
- 'ifPhysAddress' => '7a:8a:20:5f:ae:0',
- 'ifMtu' => '1500',
- 'ifInErrors' => '0',
- 'ifOutErrors' => '0',
- 'ifInDiscards' => '0',
- 'ifOutDiscards' => '0',
- ),
- 8 =>
- array (
- 'ifName' => 'br-mvlan',
- 'ifInMulticastPkts' => '0',
- 'ifInBroadcastPkts' => '0',
- 'ifOutMulticastPkts' => '0',
- 'ifOutBroadcastPkts' => '0',
- 'ifHCInOctets' => '75857718',
- 'ifHCInUcastPkts' => '599356',
- 'ifHCInMulticastPkts' => '0',
- 'ifHCInBroadcastPkts' => '0',
- 'ifHCOutOctets' => '103803946',
- 'ifHCOutUcastPkts' => '528138',
- 'ifHCOutMulticastPkts' => '0',
- 'ifHCOutBroadcastPkts' => '0',
- 'ifHighSpeed' => '0',
- 'ifPromiscuousMode' => 'false',
- 'ifConnectorPresent' => 'true',
- 'ifAlias' => '',
- 'ifCounterDiscontinuityTime' => '0:0:00:00.00',
- 'ifDescr' => 'br-mvlan',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'up',
- 'ifLastChange' => '484472069',
- 'ifType' => 'ethernetCsmacd',
- 'ifPhysAddress' => '78:8a:20:5f:ae:0',
- 'ifMtu' => '1500',
- 'ifInErrors' => '0',
- 'ifOutErrors' => '0',
- 'ifInDiscards' => '116',
- 'ifOutDiscards' => '0',
- ),
- )
- valid
- valid
- valid
- valid
- valid
- valid
- valid
- Port lo: lo (1 / #42848) disabled.
- Port eth0: eth0 (2 / #42849) disabled.
- Port ath0: ath0 (4 / #42850) ifHCInOctets
- ifHCOutOctets
- ifHCInUcastPkts
- ifHCOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- ifHighSpeed
- VLAN = Using ifDescr as ifAlias
- ath0
- ifInOctets (84386 B) 1430.2711864407 Bps 59 secs
- ifOutOctets (60085 B) 1018.3898305085 Bps 59 secs
- ifInErrors (0 B) 0 Bps 59 secs
- ifOutErrors (0 B) 0 Bps 59 secs
- ifInUcastPkts (671 B) 11.372881355932 Bps 59 secs
- ifOutUcastPkts (532 B) 9.0169491525424 Bps 59 secs
- ifInNUcastPkts (0 B) 0 Bps 59 secs
- ifOutNUcastPkts (0 B) 0 Bps 59 secs
- ifInDiscards (0 B) 0 Bps 59 secs
- ifOutDiscards (0 B) 0 Bps 59 secs
- ifInUnknownProtos (0 B) 0 Bps 59 secs
- ifInBroadcastPkts (0 B) 0 Bps 59 secs
- ifOutBroadcastPkts (0 B) 0 Bps 59 secs
- ifInMulticastPkts (0 B) 0 Bps 59 secs
- ifOutMulticastPkts (0 B) 0 Bps 59 secs
- bps(11.44 kbps/8.15 kbps)bytes(82.41 kB/58.68 kB)pkts(11.37 pps/9.02 pps)RRD[last 192.168.71.12/port-id42850.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/port-id42850.rrd N:301001760:163311068:0:0:1997279:669622:U:U:0:0:U:0:0:0:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`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`=? WHERE `port_id` = ? [1552390477,1552390418,59,"484472069","301001760",300917374,1430.2711864406779,84386,"163311068",163250983,1018.3898305084746,60085,"0",0,0,0,"0",0,0,0,"1997279",1996608,11.372881355932204,671,"669622",669090,9.016949152542374,532,42850] 13.29ms]
- 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,42850] 16.42ms]
- 1 updated
- Port ath0.71: ath0.71 (5 / #42851) ifHCInOctets
- ifHCOutOctets
- ifHCInUcastPkts
- ifHCOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- ifHighSpeed
- VLAN = Using ifDescr as ifAlias
- ath0.71
- ifInOctets (41957 B) 711.13559322034 Bps 59 secs
- ifOutOctets (47251 B) 800.86440677966 Bps 59 secs
- ifInErrors (0 B) 0 Bps 59 secs
- ifOutErrors (0 B) 0 Bps 59 secs
- ifInUcastPkts (511 B) 8.6610169491525 Bps 59 secs
- ifOutUcastPkts (505 B) 8.5593220338983 Bps 59 secs
- ifInNUcastPkts (0 B) 0 Bps 59 secs
- ifOutNUcastPkts (0 B) 0 Bps 59 secs
- ifInDiscards (0 B) 0 Bps 59 secs
- ifOutDiscards (0 B) 0 Bps 59 secs
- ifInUnknownProtos (0 B) 0 Bps 59 secs
- ifInBroadcastPkts (0 B) 0 Bps 59 secs
- ifOutBroadcastPkts (0 B) 0 Bps 59 secs
- ifInMulticastPkts (0 B) 0 Bps 59 secs
- ifOutMulticastPkts (0 B) 0 Bps 59 secs
- bps(5.69 kbps/6.41 kbps)bytes(40.97 kB/46.14 kB)pkts(8.66 pps/8.56 pps)RRD[last 192.168.71.12/port-id42851.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/port-id42851.rrd N:75857718:103804008:0:0:599356:528139:U:U:0:0:U:0:0:0:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`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`=? WHERE `port_id` = ? [1552390477,1552390418,59,"484472069","75857718",75815761,711.1355932203389,41957,"103804008",103756757,800.8644067796611,47251,"0",0,0,0,"0",0,0,0,"599356",598845,8.661016949152541,511,"528139",527634,8.559322033898304,505,42851] 13.06ms]
- 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,42851] 16.23ms]
- 1 updated
- Port br0: br0 (6 / #42852) disabled.
- Port br2: br2 (7 / #42853) disabled.
- Port br-mvlan: br-mvlan (8 / #42854) disabled.
- >> Runtime for poller module 'ports': 0.5493 seconds with 59064 bytes
- >> SNMP: [14/0.47s] MySQL: [5/0.06s] RRD: [6/0.00s]
- #### Unload poller module ports ####
- RRD[last 192.168.71.12/poller-perf-ports.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-ports.rrd N:0.54934597015381 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Modules status: Global-
- OS
- Device
- Module [ bgp-peers ] disabled globally.
- 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
- Module [ ucd-diskio ] disabled globally.
- Modules status: Global-
- OS+
- Device
- #### Load poller module wifi ####
- >> Runtime for poller module 'wifi': 0.0001 seconds with 552 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [2/0.00s]
- #### Unload poller module wifi ####
- RRD[last 192.168.71.12/poller-perf-wifi.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-wifi.rrd N:9.7990036010742E-5 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Modules status: Global+
- OS
- Device
- #### Load poller module wireless ####
- Attempting to initialize OS: airos-af-ltu
- Attempting to initialize OS: ubnt
- OS initialized as Generic
- SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [3324] 0.48ms]
- >> Runtime for poller module 'wireless': 0.0031 seconds with 144448 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [2/0.00s]
- #### Unload poller module wireless ####
- RRD[last 192.168.71.12/poller-perf-wireless.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-wireless.rrd N:0.0030770301818848 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Modules status: Global-
- OS
- Device
- Module [ ospf ] 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 [ 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 [ 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 ####
- SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = ? [3324] 0.43ms]
- >> Runtime for poller module 'entity-physical': 0.0008 seconds with 2104 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [2/0.00s]
- #### Unload poller module entity-physical ####
- RRD[last 192.168.71.12/poller-perf-entity-physical.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-entity-physical.rrd N:0.00083804130554199 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- 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` = ? [3324] 0.41ms]
- >> Runtime for poller module 'applications': 0.0008 seconds with 1632 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [2/0.00s]
- #### Unload poller module applications ####
- RRD[last 192.168.71.12/poller-perf-applications.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf-applications.rrd N:0.00075006484985352 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- Modules status: Global-
- OS
- Device
- Module [ mib ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ stp ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ ntp ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ loadbalancers ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ mef ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ services ] disabled globally.
- ### Start Device Groups ###
- SQL[SELECT * FROM device_groups ORDER BY name [] 0.69ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hardware = "WS-12-250-DC") LIMIT 1 [3324] 0.51ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hardware = "WS-12-DC") LIMIT 1 [3324] 0.45ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP "220v*") LIMIT 1 [3324] 0.51ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hardware = "WS-24-400A") LIMIT 1 [3324] 0.45ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hardware = "WS-26-400-AC") LIMIT 1 [3324] 0.45ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hardware = "WS-26-500-DC") LIMIT 1 [3324] 0.31ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hardware = "WS-8-150-DC" ) LIMIT 1 [3324] 0.31ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hardware = "WS-8-250-AC") LIMIT 1 [3324] 0.33ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP "en-af-*") LIMIT 1 [3324] 0.35ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP "ap-*" || devices.sysName REGEXP "ap/*" ) LIMIT 1 [3324] 0.35ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP "en-[^a][^f]*") LIMIT 1 [3324] 0.48ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP "192.168.15.*") LIMIT 1 [3324] 0.44ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP "^[0-9]{5}" && devices.sysName REGEXP "^[0-9]{4}" ) LIMIT 1 [3324] 0.46ms]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP "sw-" || devices.os = "netonix" ) LIMIT 1 [3324] 0.52ms]
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [3324] 0.5ms]
- Groups Added:
- Groups Removed:
- ### End Device Groups ###
- Enabling graphs: SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [3324] 0.43ms]
- uptime netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_users ucd_cpu ucd_swap_io ucd_io ucd_contexts ucd_interrupts ucd_memory ucd_load
- RRD[last 192.168.71.12/ping-perf.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/ping-perf.rrd N:1.23 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[last 192.168.71.12/poller-perf.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
- RRD[update 192.168.71.12/poller-perf.rrd N:2.508 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [5188517,"1.23",2.508,3324] 9.3ms]
- Updating 192.168.71.12
- Polled in 2.508 seconds
- #### Start Alerts ####
- SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [3324] 0.9ms]
- 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` = ? [3324] 0.48ms]
- 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 (?, ?)))) as `exists` [0,1,"0000-00-00","","","device",3324,"device_group",4,6] 0.7ms]
- 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=? OR dg.device_id=?) [3324,3324] 1.15ms]
- #### End Alerts ####
- SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"192.168.71.12","start":1552390475.170842,"duration":"2.784","devices":1,"poller":"librenms"} 9.97ms]
- ./poller.php 192.168.71.12 2019-03-12 11:34:37 - 1 devices polled in 2.784 secs
- SNMP [29/1.36s]: Get[11/0.69s] Getnext[0/0.00s] Walk[18/0.68s]
- MySQL [17/0.10s]: Cell[16/0.01s] Row[-16/-0.01s] Rows[9/0.01s] Column[1/0.00s] Update[5/0.07s] Insert[2/0.02s] Delete[0/0.00s]
- RRD [74/0.01s]: Update[37/0.00s] Create [0/0.00s] Other[37/0.01s]