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]