LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.22ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.18ms] SQL[[1;33mselect version() [0;33m[][0m 0.19ms] =================================== Version info: Commit SHA: Commit Date: DB Schema: 2021_10_20_224207_increase_length_of_attrib_type_column (224) PHP: 7.4.25 MySQL: 10.4.22-MariaDB-1:10.4.22+maria~focal RRDTool: 1.7.2 SNMP: NET-SNMP 5.9 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'ap-1.weil-st.net' ORDER BY `device_id` ASC [0;33m[][0m 0.59ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[14][0m 0.4ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[14][0m 0.23ms] Attempting to initialize OS: tplink-eap OS initialized as Generic Hostname: ap-1.weil-st.net Device ID: 14 OS: tplink-eap Resolved IP: 192.168.10.245 [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' 'ap-1.weil-st.net' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.417/0.466/0.514 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.118* SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.417,0.514,0.466,3,3,0,14,"2021-12-03 20:52:00"][0m 3.81ms] SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[0.466,14][0m 0.51ms] SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[14][0m 0.44ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m] .*.*.0 = Linux EAP660 HD 4.4.60 #1 SMP PREEMPT Thu Jul 29 17:20:23 CST 2021 aarch64 .*.*.0 = .*.4.1.118* .*.*.0 = 2214034 .*.*.0 = EAP660 HD SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 22140 HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 22140 Uptime: 6 hours 9 minutes SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[22140,14][0m 3.86ms] >> Runtime for poller module 'core': 0.0530 seconds with 4552 bytes >> [0;36mSNMP[0m: [2/0.05s] [1;33mMySQL[0m: [1/0.04s] #### Unload poller module core #### Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[9][0m 0.42ms] Location: Unknown Hardware: OS Version: OS Features: Serial: >> Runtime for poller module 'os': 0.0044 seconds with 35072 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[14][0m 0.47ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[14][0m 0.44ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[14,1638499920][0m 0.49ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,45][0m 0.38ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[14,1637981520][0m 0.44ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,46][0m 0.29ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[14,1635994320][0m 0.49ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,47][0m 0.39ms] 30 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[14,1607050320][0m 0.42ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,48][0m 0.28ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0072 seconds with 3168 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.04s] #### Unload poller module availability #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[14][0m 0.48ms] array ( ) >> Runtime for poller module 'ipmi': 0.0013 seconds with 88 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module ipmi #### Modules status: Global+ OS Device #### Load poller module sensors #### SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[14][0m 0.43ms] >> Runtime for poller module 'sensors': 0.0008 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: tplink-eap OS initialized as Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[14][0m 0.4ms] >> Runtime for poller module 'processors': 0.0028 seconds with 2744 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module processors #### Modules status: Global+ OS Device #### Load poller module mempools #### SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[14][0m 0.41ms] >> Runtime for poller module 'mempools': 0.0024 seconds with 25424 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[14][0m 0.36ms] >> Runtime for poller module 'storage': 0.0007 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m] IP-MIB::icmpInMsgs.0 = 266 IP-MIB::icmpOutMsgs.0 = 0 IP-MIB::icmpInErrors.0 = 0 IP-MIB::icmpOutErrors.0 = 266 IP-MIB::icmpInEchos.0 = 0 IP-MIB::icmpOutEchos.0 = 0 IP-MIB::icmpInEchoReps.0 = 264 IP-MIB::icmpOutEchoReps.0 = 0 IP-MIB::icmpInDestUnreachs.0 = 0 IP-MIB::icmpOutDestUnreachs.0 = 0 IP-MIB::icmpInParmProbs.0 = 0 IP-MIB::icmpInTimeExcds.0 = 2 IP-MIB::icmpInSrcQuenchs.0 = 0 IP-MIB::icmpInRedirects.0 = 0 IP-MIB::icmpInTimestamps.0 = 0 IP-MIB::icmpInTimestampReps.0 = 0 IP-MIB::icmpInAddrMasks.0 = 0 IP-MIB::icmpInAddrMaskReps.0 = 0 IP-MIB::icmpOutTimeExcds.0 = 2 IP-MIB::icmpOutParmProbs.0 = 0 IP-MIB::icmpOutSrcQuenchs.0 = 0 IP-MIB::icmpOutRedirects.0 = 0 IP-MIB::icmpOutTimestamps.0 = 264 IP-MIB::icmpOutTimestampReps.0 = 0 IP-MIB::icmpOutAddrMasks.0 = 0 IP-MIB::icmpOutAddrMaskReps.0 = 0 ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m] IP-MIB::ipForwDatagrams.0 = 0 IP-MIB::ipInDelivers.0 = 15762 IP-MIB::ipInReceives.0 = 138472 IP-MIB::ipOutRequests.0 = 11712 IP-MIB::ipInDiscards.0 = 0 IP-MIB::ipOutDiscards.0 = 0 IP-MIB::ipOutNoRoutes.0 = 0 IP-MIB::ipReasmReqds.0 = 0 IP-MIB::ipReasmOKs.0 = 0 IP-MIB::ipReasmFails.0 = 0 IP-MIB::ipFragOKs.0 = 0 IP-MIB::ipFragFails.0 = 0 IP-MIB::ipFragCreates.0 = 0 IP-MIB::ipInUnknownProtos.0 = 0 IP-MIB::ipInHdrErrors.0 = 0 IP-MIB::ipInAddrErrors.0 = 0 ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m] SNMPv2-MIB::snmpInPkts.0 = 4501 SNMPv2-MIB::snmpOutPkts.0 = 4500 SNMPv2-MIB::snmpInBadVersions.0 = 0 SNMPv2-MIB::snmpInBadCommunityNames.0 = 0 SNMPv2-MIB::snmpInBadCommunityUses.0 = 0 SNMPv2-MIB::snmpInASNParseErrs.0 = 0 SNMPv2-MIB::snmpInTooBigs.0 = 0 SNMPv2-MIB::snmpInNoSuchNames.0 = 0 SNMPv2-MIB::snmpInBadValues.0 = 0 SNMPv2-MIB::snmpInReadOnlys.0 = 0 SNMPv2-MIB::snmpInGenErrs.0 = 0 SNMPv2-MIB::snmpInTotalReqVars.0 = 35765 SNMPv2-MIB::snmpInTotalSetVars.0 = 0 SNMPv2-MIB::snmpInGetRequests.0 = 1764 SNMPv2-MIB::snmpInGetNexts.0 = 11 SNMPv2-MIB::snmpInSetRequests.0 = 0 SNMPv2-MIB::snmpInGetResponses.0 = 0 SNMPv2-MIB::snmpInTraps.0 = 0 SNMPv2-MIB::snmpOutTooBigs.0 = 0 SNMPv2-MIB::snmpOutNoSuchNames.0 = 0 SNMPv2-MIB::snmpOutBadValues.0 = 0 SNMPv2-MIB::snmpOutGenErrs.0 = 0 SNMPv2-MIB::snmpOutGetRequests.0 = 0 SNMPv2-MIB::snmpOutGetNexts.0 = 0 SNMPv2-MIB::snmpOutSetRequests.0 = 0 SNMPv2-MIB::snmpOutGetResponses.0 = 4500 SNMPv2-MIB::snmpOutTraps.0 = 0 SNMPv2-MIB::snmpSilentDrops.0 = 0 SNMPv2-MIB::snmpProxyDrops.0 = 0 udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m] UDP-MIB::udpInDatagrams.0 = 4518 UDP-MIB::udpOutDatagrams.0 = 4516 UDP-MIB::udpInErrors.0 = 0 UDP-MIB::udpNoPorts.0 = 0 tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m] TCP-MIB::tcpActiveOpens.0 = 2 TCP-MIB::tcpPassiveOpens.0 = 0 TCP-MIB::tcpAttemptFails.0 = 0 TCP-MIB::tcpEstabResets.0 = 0 TCP-MIB::tcpCurrEstab.0 = 1 TCP-MIB::tcpInSegs.0 = 3673 TCP-MIB::tcpOutSegs.0 = 6935 TCP-MIB::tcpRetransSegs.0 = 0 TCP-MIB::tcpInErrs.0 = 0 TCP-MIB::tcpOutRsts.0 = 0 >> Runtime for poller module 'netstats': 0.1255 seconds with 1696 bytes >> [0;36mSNMP[0m: [6/0.12s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module netstats #### Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] hrSystemMaxProcesses.0 = No Such Object available on this agent at this OID hrSystemProcesses.0 = No Such Object available on this agent at this OID hrSystemNumUsers.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'hr-mib': 0.0089 seconds with 80 bytes >> [0;36mSNMP[0m: [1/0.01s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module hr-mib #### Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m] systemStats = No Such Object available on this agent at this OID Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m] laLoadInt.1 = No Such Object available on this agent at this OID laLoadInt.2 = No Such Object available on this agent at this OID laLoadInt.3 = No Such Object available on this agent at this OID >> Runtime for poller module 'ucd-mib': 0.0294 seconds with 89144 bytes >> [0;36mSNMP[0m: [2/0.03s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsTable = No Such Object available on this agent at this OID Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.0307 seconds with 80 bytes >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ipSystemStats #### Modules status: Global+ OS Device #### Load poller module ports #### SQL[[1;33mSELECT *, `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 [0;33m[14][0m 0.79ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifXEntry = No Such Object available on this agent at this OID Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifIndex.1 = 1 ifIndex.2 = 2 ifIndex.3 = 3 ifIndex.4 = 4 ifIndex.5 = 5 ifIndex.6 = 6 ifIndex.7 = 7 ifIndex.14 = 14 ifIndex.15 = 15 ifIndex.16 = 16 ifDescr.1 = lo ifDescr.2 = miireg ifDescr.3 = eth0 ifDescr.4 = br0 ifDescr.5 = wifi0 ifDescr.6 = wifi1 ifDescr.7 = soc0 ifDescr.14 = ath0 ifDescr.15 = ath10 ifDescr.16 = ath1 ifType.1 = softwareLoopback ifType.2 = other ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd ifType.5 = other ifType.6 = other ifType.7 = other ifType.14 = ethernetCsmacd ifType.15 = ethernetCsmacd ifType.16 = ethernetCsmacd ifMtu.1 = 65536 ifMtu.2 = 0 ifMtu.3 = 1500 ifMtu.4 = 1500 ifMtu.5 = 1500 ifMtu.6 = 1500 ifMtu.7 = 0 ifMtu.14 = 1500 ifMtu.15 = 1500 ifMtu.16 = 1500 ifSpeed.1 = 10000000 ifSpeed.2 = 0 ifSpeed.3 = 1000000000 ifSpeed.4 = 0 ifSpeed.5 = 0 ifSpeed.6 = 0 ifSpeed.7 = 0 ifSpeed.14 = 0 ifSpeed.15 = 0 ifSpeed.16 = 0 ifPhysAddress.1 = ifPhysAddress.2 = ifPhysAddress.3 = 10:27:f5:97:de:fc ifPhysAddress.4 = 10:27:f5:97:de:fc ifPhysAddress.5 = 10:27:f5:97:de:fd ifPhysAddress.6 = 10:27:f5:97:de:fc ifPhysAddress.7 = ifPhysAddress.14 = 10:27:f5:97:de:fc ifPhysAddress.15 = 10:27:f5:97:de:fd ifPhysAddress.16 = 16:27:f5:97:de:fc ifAdminStatus.1 = up ifAdminStatus.2 = down ifAdminStatus.3 = up ifAdminStatus.4 = up ifAdminStatus.5 = up ifAdminStatus.6 = up ifAdminStatus.7 = down ifAdminStatus.14 = up ifAdminStatus.15 = up ifAdminStatus.16 = up ifOperStatus.1 = up ifOperStatus.2 = down ifOperStatus.3 = up ifOperStatus.4 = up ifOperStatus.5 = up ifOperStatus.6 = up ifOperStatus.7 = down ifOperStatus.14 = up ifOperStatus.15 = up ifOperStatus.16 = up ifLastChange.1 = 0 ifLastChange.2 = 0 ifLastChange.3 = 300 ifLastChange.4 = 0 ifLastChange.5 = 9009 ifLastChange.6 = 8708 ifLastChange.7 = 1201 ifLastChange.14 = 424594 ifLastChange.15 = 424894 ifLastChange.16 = 425795 ifInOctets.1 = 174 ifInOctets.2 = 0 ifInOctets.3 = 1283084559 ifInOctets.4 = 89825830 ifInOctets.5 = 556376515 ifInOctets.6 = 3462998232 ifInOctets.7 = 0 ifInOctets.14 = 224724505 ifInOctets.15 = 274041183 ifInOctets.16 = 2626053842 ifInUcastPkts.1 = 2 ifInUcastPkts.2 = 0 ifInUcastPkts.3 = 5994057 ifInUcastPkts.4 = 210161 ifInUcastPkts.5 = 995043 ifInUcastPkts.6 = 5876775 ifInUcastPkts.7 = 0 ifInUcastPkts.14 = 3101263 ifInUcastPkts.15 = 548251 ifInUcastPkts.16 = 2254495 ifInNUcastPkts.1 = 0 ifInNUcastPkts.2 = 0 ifInNUcastPkts.3 = 194737 ifInNUcastPkts.4 = 0 ifInNUcastPkts.5 = 0 ifInNUcastPkts.6 = 0 ifInNUcastPkts.7 = 0 ifInNUcastPkts.14 = 0 ifInNUcastPkts.15 = 0 ifInNUcastPkts.16 = 0 ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifInDiscards.3 = 730 ifInDiscards.4 = 51350 ifInDiscards.5 = 33844 ifInDiscards.6 = 228821 ifInDiscards.7 = 0 ifInDiscards.14 = 10 ifInDiscards.15 = 15 ifInDiscards.16 = 0 ifInErrors.1 = 0 ifInErrors.2 = 0 ifInErrors.3 = 0 ifInErrors.4 = 0 ifInErrors.5 = 33844 ifInErrors.6 = 228821 ifInErrors.7 = 0 ifInErrors.14 = 10 ifInErrors.15 = 15 ifInErrors.16 = 0 ifInUnknownProtos.1 = 0 ifInUnknownProtos.2 = 0 ifInUnknownProtos.3 = 0 ifInUnknownProtos.4 = 0 ifInUnknownProtos.5 = 0 ifInUnknownProtos.6 = 0 ifInUnknownProtos.7 = 0 ifInUnknownProtos.14 = 0 ifInUnknownProtos.15 = 0 ifInUnknownProtos.16 = 0 ifOutOctets.1 = 174 ifOutOctets.2 = 0 ifOutOctets.3 = 4048290781 ifOutOctets.4 = 4466589 ifOutOctets.5 = 924592485 ifOutOctets.6 = 588738008 ifOutOctets.7 = 0 ifOutOctets.14 = 487363627 ifOutOctets.15 = 537772409 ifOutOctets.16 = 166748708 ifOutUcastPkts.1 = 2 ifOutUcastPkts.2 = 0 ifOutUcastPkts.3 = 6851714 ifOutUcastPkts.4 = 12149 ifOutUcastPkts.5 = 1672694 ifOutUcastPkts.6 = 5272524 ifOutUcastPkts.7 = 0 ifOutUcastPkts.14 = 3529442 ifOutUcastPkts.15 = 1262334 ifOutUcastPkts.16 = 1573921 ifOutNUcastPkts.1 = 0 ifOutNUcastPkts.2 = 0 ifOutNUcastPkts.3 = 0 ifOutNUcastPkts.4 = 0 ifOutNUcastPkts.5 = 0 ifOutNUcastPkts.6 = 0 ifOutNUcastPkts.7 = 0 ifOutNUcastPkts.14 = 0 ifOutNUcastPkts.15 = 0 ifOutNUcastPkts.16 = 0 ifOutDiscards.1 = 0 ifOutDiscards.2 = 0 ifOutDiscards.3 = 0 ifOutDiscards.4 = 0 ifOutDiscards.5 = 466840 ifOutDiscards.6 = 597979 ifOutDiscards.7 = 0 ifOutDiscards.14 = 0 ifOutDiscards.15 = 0 ifOutDiscards.16 = 0 ifOutErrors.1 = 0 ifOutErrors.2 = 0 ifOutErrors.3 = 0 ifOutErrors.4 = 0 ifOutErrors.5 = 466840 ifOutErrors.6 = 597979 ifOutErrors.7 = 0 ifOutErrors.14 = 0 ifOutErrors.15 = 0 ifOutErrors.16 = 0 ifOutQLen.1 = 0 ifOutQLen.2 = 0 ifOutQLen.3 = 0 ifOutQLen.4 = 0 ifOutQLen.5 = 0 ifOutQLen.6 = 0 ifOutQLen.7 = 0 ifOutQLen.14 = 0 ifOutQLen.15 = 0 ifOutQLen.16 = 0 ifSpecific.1 = zeroDotZero ifSpecific.2 = zeroDotZero ifSpecific.3 = zeroDotZero ifSpecific.4 = zeroDotZero ifSpecific.5 = zeroDotZero ifSpecific.6 = zeroDotZero ifSpecific.7 = zeroDotZero ifSpecific.14 = zeroDotZero ifSpecific.15 = zeroDotZero ifSpecific.16 = zeroDotZero dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsIndex'[0m] dot3StatsIndex = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot3StatsIndex = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl','vdsl2') [0;33m[14][0m 0.59ms] array ( 1 => array ( 'ifIndex' => '1', 'ifDescr' => 'lo', 'ifType' => 'softwareLoopback', 'ifMtu' => '65536', 'ifSpeed' => '10000000', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '174', 'ifInUcastPkts' => '2', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '174', 'ifOutUcastPkts' => '2', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 2 => array ( 'ifIndex' => '2', 'ifDescr' => 'miireg', 'ifType' => 'other', 'ifMtu' => '0', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 3 => array ( 'ifIndex' => '3', 'ifDescr' => 'eth0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '1000000000', 'ifPhysAddress' => '10:27:f5:97:de:fc', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '300', 'ifInOctets' => '1283084559', 'ifInUcastPkts' => '5994057', 'ifInNUcastPkts' => '194737', 'ifInDiscards' => '730', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '4048290781', 'ifOutUcastPkts' => '6851714', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 4 => array ( 'ifIndex' => '4', 'ifDescr' => 'br0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '10:27:f5:97:de:fc', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '89825830', 'ifInUcastPkts' => '210161', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '51350', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '4466589', 'ifOutUcastPkts' => '12149', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 5 => array ( 'ifIndex' => '5', 'ifDescr' => 'wifi0', 'ifType' => 'other', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '10:27:f5:97:de:fd', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '9009', 'ifInOctets' => '556376515', 'ifInUcastPkts' => '995043', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '33844', 'ifInErrors' => '33844', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '924592485', 'ifOutUcastPkts' => '1672694', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '466840', 'ifOutErrors' => '466840', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 6 => array ( 'ifIndex' => '6', 'ifDescr' => 'wifi1', 'ifType' => 'other', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '10:27:f5:97:de:fc', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '8708', 'ifInOctets' => '3462998232', 'ifInUcastPkts' => '5876775', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '228821', 'ifInErrors' => '228821', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '588738008', 'ifOutUcastPkts' => '5272524', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '597979', 'ifOutErrors' => '597979', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 7 => array ( 'ifIndex' => '7', 'ifDescr' => 'soc0', 'ifType' => 'other', 'ifMtu' => '0', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '1201', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 14 => array ( 'ifIndex' => '14', 'ifDescr' => 'ath0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '10:27:f5:97:de:fc', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '424594', 'ifInOctets' => '224724505', 'ifInUcastPkts' => '3101263', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '10', 'ifInErrors' => '10', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '487363627', 'ifOutUcastPkts' => '3529442', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 15 => array ( 'ifIndex' => '15', 'ifDescr' => 'ath10', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '10:27:f5:97:de:fd', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '424894', 'ifInOctets' => '274041183', 'ifInUcastPkts' => '548251', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '15', 'ifInErrors' => '15', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '537772409', 'ifOutUcastPkts' => '1262334', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 16 => array ( 'ifIndex' => '16', 'ifDescr' => 'ath1', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '16:27:f5:97:de:fc', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '425795', 'ifInOctets' => '2626053842', 'ifInUcastPkts' => '2254495', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '166748708', 'ifOutUcastPkts' => '1573921', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), ) valid valid valid valid valid valid valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":6291}[0m 3.71ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":6292}[0m 6.45ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":6293}[0m 6.95ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":6294}[0m 3.61ms] Port lo: lo (1 / #6285) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (10000000) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName lo ifInOctets (0 B) 0 Bps 261 secs ifOutOctets (0 B) 0 Bps 261 secs ifInErrors (0 B) 0 Bps 261 secs ifOutErrors (0 B) 0 Bps 261 secs ifInUcastPkts (0 B) 0 Bps 261 secs ifOutUcastPkts (0 B) 0 Bps 261 secs ifInNUcastPkts (0 B) 0 Bps 261 secs ifOutNUcastPkts (0 B) 0 Bps 261 secs ifInDiscards (0 B) 0 Bps 261 secs ifOutDiscards (0 B) 0 Bps 261 secs ifInUnknownProtos (0 B) 0 Bps 261 secs ifInBroadcastPkts (0 B) 0 Bps 261 secs ifOutBroadcastPkts (0 B) 0 Bps 261 secs ifInMulticastPkts (0 B) 0 Bps 261 secs ifOutMulticastPkts (0 B) 0 Bps 261 secs bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus_prev`=?,`ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","10000000","174",174,0,0,"174",174,0,0,"0",0,0,0,"0",0,0,0,"2",2,0,0,"2",2,0,0,1638586320,1638586059,261,6285][0m 4.01ms] SQL[[1;33mUPDATE `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;33m["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,6285][0m 3.95ms] 2 updated Port miireg: miireg (2 / #6286) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName miireg6286 skipped because port is still down since last polling. SQL[[1;33mUPDATE `ports` set `ifAdminStatus_prev`=?,`ifSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","0",1638586320,1638586059,261,6286][0m 3.97ms] 1 updated Port eth0: eth0 (3 / #6287) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (1000000000) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName eth0 ifInOctets (8056969 B) 30869.61302682 Bps 261 secs ifOutOctets (43258173 B) 165740.12643678 Bps 261 secs ifInErrors (0 B) 0 Bps 261 secs ifOutErrors (0 B) 0 Bps 261 secs ifInUcastPkts (69582 B) 266.59770114943 Bps 261 secs ifOutUcastPkts (81613 B) 312.69348659004 Bps 261 secs ifInNUcastPkts (2176 B) 8.3371647509579 Bps 261 secs ifOutNUcastPkts (0 B) 0 Bps 261 secs ifInDiscards (8 B) 0.030651340996169 Bps 261 secs ifOutDiscards (0 B) 0 Bps 261 secs ifInUnknownProtos (0 B) 0 Bps 261 secs ifInBroadcastPkts (0 B) 0 Bps 261 secs ifOutBroadcastPkts (0 B) 0 Bps 261 secs ifInMulticastPkts (0 B) 0 Bps 261 secs ifOutMulticastPkts (0 B) 0 Bps 261 secs bps(246.96 Kbps/1.33 Mbps)bytes(7.68 MiB/41.25 MiB)pkts(266.6 pps/312.69 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus_prev`=?,`ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","1000000000","1283084559",1275027590,30869.613026819923,8056969,"4048290781",4005032608,165740.1264367816,43258173,"0",0,0,0,"0",0,0,0,"5994057",5924475,266.5977011494253,69582,"6851714",6770101,312.69348659003833,81613,1638586320,1638586059,261,6287][0m 3.64ms] SQL[[1;33mUPDATE `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;33m["194737",192561,8.337164750957854,2176,"0",0,0,0,"730",722,0.03065134099616858,8,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6287][0m 2.82ms] 2 updated Port br0: br0 (4 / #6288) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName br0 ifInOctets (1007669 B) 3860.8007662835 Bps 261 secs ifOutOctets (74190 B) 284.25287356322 Bps 261 secs ifInErrors (0 B) 0 Bps 261 secs ifOutErrors (0 B) 0 Bps 261 secs ifInUcastPkts (2420 B) 9.272030651341 Bps 261 secs ifOutUcastPkts (252 B) 0.96551724137931 Bps 261 secs ifInNUcastPkts (0 B) 0 Bps 261 secs ifOutNUcastPkts (0 B) 0 Bps 261 secs ifInDiscards (529 B) 2.0268199233716 Bps 261 secs ifOutDiscards (0 B) 0 Bps 261 secs ifInUnknownProtos (0 B) 0 Bps 261 secs ifInBroadcastPkts (0 B) 0 Bps 261 secs ifOutBroadcastPkts (0 B) 0 Bps 261 secs ifInMulticastPkts (0 B) 0 Bps 261 secs ifOutMulticastPkts (0 B) 0 Bps 261 secs bps(30.89 Kbps/2.27 Kbps)bytes(984.05 KiB/72.45 KiB)pkts(9.27 pps/0.97 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus_prev`=?,`ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","0","89825830",88818161,3860.800766283525,1007669,"4466589",4392399,284.2528735632184,74190,"0",0,0,0,"0",0,0,0,"210161",207741,9.272030651340996,2420,"12149",11897,0.9655172413793104,252,1638586320,1638586059,261,6288][0m 4.05ms] SQL[[1;33mUPDATE `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;33m["0",0,0,0,"0",0,0,0,"51350",50821,2.0268199233716473,529,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6288][0m 3.79ms] 2 updated Port wifi0: wifi0 (5 / #6289) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName wifi0 ifInOctets (1393242 B) 5338.091954023 Bps 261 secs ifOutOctets (2858953 B) 10953.842911877 Bps 261 secs ifInErrors (95 B) 0.3639846743295 Bps 261 secs ifOutErrors (4189 B) 16.049808429119 Bps 261 secs ifInUcastPkts (7847 B) 30.065134099617 Bps 261 secs ifOutUcastPkts (10576 B) 40.521072796935 Bps 261 secs ifInNUcastPkts (0 B) 0 Bps 261 secs ifOutNUcastPkts (0 B) 0 Bps 261 secs ifInDiscards (95 B) 0.3639846743295 Bps 261 secs ifOutDiscards (4189 B) 16.049808429119 Bps 261 secs ifInUnknownProtos (0 B) 0 Bps 261 secs ifInBroadcastPkts (0 B) 0 Bps 261 secs ifOutBroadcastPkts (0 B) 0 Bps 261 secs ifInMulticastPkts (0 B) 0 Bps 261 secs ifOutMulticastPkts (0 B) 0 Bps 261 secs bps(42.71 Kbps/87.63 Kbps)bytes(1.33 MiB/2.73 MiB)pkts(30.07 pps/40.52 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus_prev`=?,`ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","0","556376515",554983273,5338.091954022989,1393242,"924592485",921733532,10953.842911877395,2858953,"33844",33749,0.36398467432950193,95,"466840",462651,16.049808429118773,4189,"995043",987196,30.06513409961686,7847,"1672694",1662118,40.52107279693487,10576,1638586320,1638586059,261,6289][0m 3.8ms] SQL[[1;33mUPDATE `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;33m["0",0,0,0,"0",0,0,0,"33844",33749,0.36398467432950193,95,"466840",462651,16.049808429118773,4189,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6289][0m 3.93ms] 2 updated Port wifi1: wifi1 (6 / #6290) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName wifi1 ifInOctets (41455280 B) 158832.49042146 Bps 261 secs ifOutOctets (7157828 B) 27424.62835249 Bps 261 secs ifInErrors (3567 B) 13.666666666667 Bps 261 secs ifOutErrors (6534 B) 25.034482758621 Bps 261 secs ifInUcastPkts (73530 B) 281.72413793103 Bps 261 secs ifOutUcastPkts (65849 B) 252.29501915709 Bps 261 secs ifInNUcastPkts (0 B) 0 Bps 261 secs ifOutNUcastPkts (0 B) 0 Bps 261 secs ifInDiscards (3567 B) 13.666666666667 Bps 261 secs ifOutDiscards (6534 B) 25.034482758621 Bps 261 secs ifInUnknownProtos (0 B) 0 Bps 261 secs ifInBroadcastPkts (0 B) 0 Bps 261 secs ifOutBroadcastPkts (0 B) 0 Bps 261 secs ifInMulticastPkts (0 B) 0 Bps 261 secs ifOutMulticastPkts (0 B) 0 Bps 261 secs bps(1.27 Mbps/219.4 Kbps)bytes(39.53 MiB/6.83 MiB)pkts(281.72 pps/252.3 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus_prev`=?,`ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","0","3462998232",3421542952,158832.49042145594,41455280,"588738008",581580180,27424.62835249042,7157828,"228821",225254,13.666666666666666,3567,"597979",591445,25.03448275862069,6534,"5876775",5803245,281.7241379310345,73530,"5272524",5206675,252.29501915708812,65849,1638586320,1638586059,261,6290][0m 3.99ms] SQL[[1;33mUPDATE `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;33m["0",0,0,0,"0",0,0,0,"228821",225254,13.666666666666666,3567,"597979",591445,25.03448275862069,6534,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6290][0m 3.8ms] 2 updated Port soc0: soc0 (7 / #6291) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6291,"interface","2021-12-03 20:52:00",3,"ifAdminStatus: -> down",""][0m 3.89ms] ifAdminStatus: -> down SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6291,"interface","2021-12-03 20:52:00",3,"ifMtu: -> 0",""][0m 4ms] ifMtu: -> 0 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6291,"interface","2021-12-03 20:52:00",3,"ifSpeed: 0 bps -> 0 bps",""][0m 3.99ms] ifSpeed: 0 bps -> 0 bps soc0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1201","down","down","0","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1638586320,null,1638586320,6291][0m 3.95ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,6291][0m 3.79ms] 2 updated Port ath0: ath0 (14 / #6292) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6292,"interface","2021-12-03 20:52:00",3,"ifAdminStatus: -> up",""][0m 3.95ms] ifAdminStatus: -> up SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6292,"interface","2021-12-03 20:52:00",3,"ifMtu: -> 1500",""][0m 3.93ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6292,"interface","2021-12-03 20:52:00",3,"ifSpeed: 0 bps -> 0 bps",""][0m 4.05ms] ifSpeed: 0 bps -> 0 bps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6292,"interface","2021-12-03 20:52:00",3,"ifPhysAddress: -> 1027f597defc",""][0m 4.06ms] ifPhysAddress: -> 1027f597defc ath0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["424594","up","up","1500","0","1027f597defc","224724505",0,"487363627",0,"10",0,"0",0,"3101263",0,"3529442",0,1638586320,null,1638586320,6292][0m 3.76ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"10",0,"0",0,"0",0,0,0,0,0,0,0,0,0,6292][0m 3.75ms] 2 updated Port ath10: ath10 (15 / #6293) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6293,"interface","2021-12-03 20:52:00",3,"ifAdminStatus: -> up",""][0m 3.79ms] ifAdminStatus: -> up SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6293,"interface","2021-12-03 20:52:00",3,"ifMtu: -> 1500",""][0m 3.81ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6293,"interface","2021-12-03 20:52:00",3,"ifSpeed: 0 bps -> 0 bps",""][0m 3.7ms] ifSpeed: 0 bps -> 0 bps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6293,"interface","2021-12-03 20:52:00",3,"ifPhysAddress: -> 1027f597defd",""][0m 3.67ms] ifPhysAddress: -> 1027f597defd ath10bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["424894","up","up","1500","0","1027f597defd","274041183",0,"537772409",0,"15",0,"0",0,"548251",0,"1262334",0,1638586320,null,1638586320,6293][0m 3.93ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"15",0,"0",0,"0",0,0,0,0,0,0,0,0,0,6293][0m 3.87ms] 2 updated Port ath1: ath1 (16 / #6294) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6294,"interface","2021-12-03 20:52:00",3,"ifAdminStatus: -> up",""][0m 3.96ms] ifAdminStatus: -> up SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6294,"interface","2021-12-03 20:52:00",3,"ifMtu: -> 1500",""][0m 3.99ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6294,"interface","2021-12-03 20:52:00",3,"ifSpeed: 0 bps -> 0 bps",""][0m 3.77ms] ifSpeed: 0 bps -> 0 bps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[14,6294,"interface","2021-12-03 20:52:00",3,"ifPhysAddress: -> 1627f597defc",""][0m 3.77ms] ifPhysAddress: -> 1627f597defc ath1bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["425795","up","up","1500","0","1627f597defc","2626053842",0,"166748708",0,"0",0,"0",0,"2254495",0,"1573921",0,1638586320,null,1638586320,6294][0m 4.11ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,6294][0m 4.05ms] 2 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1638586320,1638586059,null][0m 0.24ms] 0 updated >> Runtime for poller module 'ports': 0.2813 seconds with 151768 bytes >> [0;36mSNMP[0m: [5/0.10s] [1;33mMySQL[0m: [41/1.54s] #### Unload poller module ports #### Modules status: Global+ OS Device #### Load poller module customoid #### SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[14][0m 0.37ms] >> Runtime for poller module 'customoid': 0.0008 seconds with 40 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module customoid #### Modules status: Global+ OS Device #### Load poller module bgp-peers #### SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[14][0m 0.48ms] >> Runtime for poller module 'bgp-peers': 0.0028 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module bgp-peers #### Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[14][0m 0.25ms] >> Runtime for poller module 'ucd-diskio': 0.0007 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module ucd-diskio #### Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: tplink-eap OS initialized as Generic SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[14][0m 0.39ms] >> Runtime for poller module 'wireless': 0.0030 seconds with 7504 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module wireless #### Modules status: Global+ OS Device #### Load poller module ospf #### SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[14][0m 0.29ms] Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m] ospfGeneralGroup = No Such Object available on this agent at this OID Invalid snmp_walk() data = ospfGeneralGroup = No Such Object available on this agent at this OID array ( ) SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` = ?) and 1 = 1 [0;33m[14,""][0m 0.44ms] 0 >> Runtime for poller module 'ospf': 0.0198 seconds with 50576 bytes >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [2/0.01s] #### Unload poller module ospf #### Modules status: Global- OS Device Module [ isis ] disabled globally. Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ slas ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-qfp ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ nac ] disabled globally. Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally. Modules status: Global- OS Device Module [ aruba-controller ] disabled globally. Modules status: Global+ OS Device #### Load poller module entity-physical #### >> Runtime for poller module 'entity-physical': 0.0001 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module entity-physical #### Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[[1;33mSELECT * FROM `applications` WHERE `device_id` = ? [0;33m[14][0m 0.37ms] >> Runtime for poller module 'applications': 0.0006 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module applications #### Modules status: Global- OS Device Module [ mib ] disabled globally. Modules status: Global+ OS Device #### Load poller module stp #### SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[14][0m 0.25ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m] No Such Object available on this agent at this OID >> Runtime for poller module 'stp': 0.0139 seconds with 112 bytes >> [0;36mSNMP[0m: [1/0.01s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module stp #### Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0002 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ntp #### Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device #### Load poller module mpls #### >> Runtime for poller module 'mpls': 0.0006 seconds with 488 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module mpls #### Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[14][0m 0.44ms] SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[1.654,14][0m 3.82ms] Updating ap-1.weil-st.net Polled in 1.654 seconds ### Start Device Groups ### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[14][0m 7.05ms] SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.39ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[14][0m 0.44ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0165s ### #### Start Alerts #### SQL[[1;33mselect `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` = ? [0;33m[14][0m 0.33ms] SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2021-12-04T02:52:00.794459Z","2021-12-04T02:52:00.794459Z",0,1,"02:52:00","02:52:00","02:52:00","02:52:00","[46m%","device",14,"location",9][0m 0.78ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[14][0m 0.41ms] SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?) LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?)) LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?)) LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ? WHERE a.disabled = 0 AND ( (d.device_id IS NULL AND g.group_id IS NULL) OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?)) OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL)) ) [0;33m[14,14,14,14,14,14,14,14][0m 1.08ms] #### End Alerts #### ./poller.php ap-1.weil-st.net 2021-12-03 20:52:00 - 1 devices polled in 1.822 secs [0;36mSNMP[0m [20/0.39s]: Snmpget[12/0.23s] Snmpwalk[8/0.16s] [1;33mSQL[0m [87/1.91s]: Select[39/0.25s] Insert[20/0.83s] Update[27/0.83s] Delete[1/0.00s]