LibreNMS Poller SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.56ms] SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.49ms] SQL[select version() [] 0.38ms] =================================== Version info: Commit SHA: 1b06b257a2e2b21ead29b1c4e08e7f3a3ea9c549 Commit Date: 1657125283 DB Schema: 2022_05_30_084932_update-app-status-length (242) PHP: 7.4.28 MySQL: 10.5.15-MariaDB-0+deb11u1 RRDTool: 1.7.2 SNMP: 5.9 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.10.172.34' ORDER BY `device_id` ASC [] 0.97ms] SQL[select * from `devices` where `device_id` = ? limit 1 [24] 0.64ms] SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [24] 0.58ms] Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic Hostname: 10.xx.xx.xx Device ID: 24 OS: generic [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '10.10.172.34' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 1.26/1.48/1.84 SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.34168.2.3 SQL[insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [1.26,1.84,1.48,3,3,0,24,"2022-07-09 01:22:56"] 3.66ms] SQL[update `devices` set `last_ping_timetaken` = ? where `device_id` = ? [1.48,24] 3.11ms] SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [24] 0.65ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP['/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'] .*.*.0 = Richerlink Communication Co., Ltd. Internetwork Operating System Software SWITCH Series Software, Version 1.0.1(27724:27724)A .*.*.0 = .*.4.1.34168.2.3 .*.*.0 = 17202109 .*.*.0 = EPON_E_BLDG SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 17203452 HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 17203452 Uptime: 199 days 2 hours 44 minutes 12 seconds SQL[update `devices` set `uptime` = ? where `device_id` = ? [17203452,24] 2.09ms] >> Runtime for poller module 'core': 0.0425 seconds with 70568 bytes >> SNMP: [2/0.04s] MySQL: [1/0.02s] #### Unload poller module core #### Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( Location: Hardware: OS Version: OS Features: Serial: >> Runtime for poller module 'os': 0.0025 seconds with 114936 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[SELECT duration FROM availability WHERE device_id = ? [24] 0.59ms] Availability: SQL[SELECT * FROM availability WHERE device_id = ? [24] 0.38ms] SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [24,1657223576] 0.46ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,93] 0.27ms] 1 day : 100% SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [24,1656705176] 0.37ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [99.954,94] 0.24ms] 7 days : 99.954% SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [24,1654717976] 0.38ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [99.978,95] 0.22ms] 30 days : 99.978% SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [24,1625773976] 0.35ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [99.998,96] 0.23ms] 365 days : 99.998% >> Runtime for poller module 'availability': 0.0074 seconds with 13216 bytes >> SNMP: [0/0.00s] MySQL: [10/0.03s] #### Unload poller module availability #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [24] 0.5ms] array ( ) >> Runtime for poller module 'ipmi': 0.0011 seconds with 1592 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module ipmi #### Modules status: Global+ OS Device #### Load poller module sensors #### SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [24] 0.4ms] >> Runtime for poller module 'sensors': 0.0007 seconds with 456 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic SQL[SELECT * FROM processors WHERE device_id=? [24] 0.47ms] >> Runtime for poller module 'processors': 0.0020 seconds with 124592 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module processors #### Modules status: Global+ OS Device #### Load poller module mempools #### SQL[select * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [24] 0.56ms] >> Runtime for poller module 'mempools': 0.0022 seconds with 76976 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[SELECT * FROM storage WHERE device_id = ? [24] 0.41ms] >> Runtime for poller module 'storage': 0.0008 seconds with 904 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### icmp SNMP['/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'] IP-MIB::icmpInMsgs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutMsgs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInErrors.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutErrors.0 = No Such Object available on this agent at this OID IP-MIB::icmpInEchos.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutEchos.0 = No Such Object available on this agent at this OID IP-MIB::icmpInEchoReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutEchoReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpInDestUnreachs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutDestUnreachs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInParmProbs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimeExcds.0 = No Such Object available on this agent at this OID IP-MIB::icmpInSrcQuenchs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInRedirects.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimestamps.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimestampReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpInAddrMasks.0 = No Such Object available on this agent at this OID IP-MIB::icmpInAddrMaskReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimeExcds.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutParmProbs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutSrcQuenchs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutRedirects.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimestamps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimestampReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutAddrMasks.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutAddrMaskReps.0 = No Such Object available on this agent at this OID ip SNMP['/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'] IP-MIB::ipForwDatagrams.0 = No Such Object available on this agent at this OID IP-MIB::ipInDelivers.0 = No Such Object available on this agent at this OID IP-MIB::ipInReceives.0 = No Such Object available on this agent at this OID IP-MIB::ipOutRequests.0 = No Such Object available on this agent at this OID IP-MIB::ipInDiscards.0 = No Such Object available on this agent at this OID IP-MIB::ipOutDiscards.0 = No Such Object available on this agent at this OID IP-MIB::ipOutNoRoutes.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmReqds.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmOKs.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmFails.0 = No Such Object available on this agent at this OID IP-MIB::ipFragOKs.0 = No Such Object available on this agent at this OID IP-MIB::ipFragFails.0 = No Such Object available on this agent at this OID IP-MIB::ipFragCreates.0 = No Such Object available on this agent at this OID IP-MIB::ipInUnknownProtos.0 = No Such Object available on this agent at this OID IP-MIB::ipInHdrErrors.0 = No Such Object available on this agent at this OID IP-MIB::ipInAddrErrors.0 = No Such Object available on this agent at this OID ip_forward SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'] IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID snmp SNMP['/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'] SNMPv2-MIB::snmpInPkts.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutPkts.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInBadVersions.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInBadCommunityNames.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInBadCommunityUses.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInASNParseErrs.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInTooBigs.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInNoSuchNames.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInBadValues.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInReadOnlys.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInGenErrs.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInTotalReqVars.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInTotalSetVars.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInGetRequests.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInGetNexts.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInSetRequests.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInGetResponses.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInTraps.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutTooBigs.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutNoSuchNames.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutBadValues.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutGenErrs.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutGetRequests.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutGetNexts.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutSetRequests.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutGetResponses.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutTraps.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpSilentDrops.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpProxyDrops.0 = No Such Object available on this agent at this OID udp SNMP['/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'] UDP-MIB::udpInDatagrams.0 = No Such Object available on this agent at this OID UDP-MIB::udpOutDatagrams.0 = No Such Object available on this agent at this OID UDP-MIB::udpInErrors.0 = No Such Object available on this agent at this OID UDP-MIB::udpNoPorts.0 = No Such Object available on this agent at this OID tcp SNMP['/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'] TCP-MIB::tcpActiveOpens.0 = No Such Object available on this agent at this OID TCP-MIB::tcpPassiveOpens.0 = No Such Object available on this agent at this OID TCP-MIB::tcpAttemptFails.0 = No Such Object available on this agent at this OID TCP-MIB::tcpEstabResets.0 = No Such Object available on this agent at this OID TCP-MIB::tcpCurrEstab.0 = No Such Object available on this agent at this OID TCP-MIB::tcpInSegs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpOutSegs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpRetransSegs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpInErrs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpOutRsts.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'netstats': 0.1168 seconds with 23112 bytes >> SNMP: [6/0.12s] MySQL: [0/0.00s] #### Unload poller module netstats #### 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' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'] 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.0194 seconds with 640 bytes >> SNMP: [1/0.02s] MySQL: [0/0.00s] #### Unload poller module hr-mib #### Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'] 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['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'] 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.0516 seconds with 136 bytes >> SNMP: [2/0.05s] MySQL: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'] 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.0336 seconds with 912 bytes >> SNMP: [1/0.03s] MySQL: [0/0.00s] #### Unload poller module ipSystemStats #### Modules status: Global+ OS Device #### Load poller module ports #### SQL[SELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [24] 2.18ms] Caching Oids: Full ports polling SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'] Exitcode: 1 Error: OID not increasing: ifName.197120 >= ifName.70912 ifName.1 = lo ifName.6 = vlan1.1 ifName.7 = vlan1.50 ifName.5001 = epon1 ifName.5002 = epon2 ifName.5003 = epon3 ifName.5004 = epon4 ifName.5005 = ge1 ifName.5006 = ge2 ifName.5007 = ge3 ifName.5008 = ge4 ifName.5009 = ge5 ifName.5010 = ge6 ifName.5011 = xe1 ifName.5012 = xe2 ifName.65536 = epon1:0 ifName.65792 = epon1:1 ifName.66048 = epon1:2 ifName.66304 = epon1:3 ifName.66560 = epon1:4 ifName.66816 = epon1:5 ifName.67072 = epon1:6 ifName.67328 = epon1:7 ifName.67584 = epon1:8 ifName.67840 = epon1:9 ifName.68096 = epon1:10 ifName.68352 = epon1:11 ifName.68608 = epon1:12 ifName.68864 = epon1:13 ifName.69120 = epon1:14 ifName.69376 = epon1:15 ifName.69632 = epon1:16 ifName.69888 = epon1:17 ifName.70144 = epon1:18 ifName.70400 = epon1:19 ifName.70656 = epon1:20 ifName.131072 = epon2:0 ifName.196608 = epon3:0 ifName.196864 = epon3:1 ifName.197120 = epon3:2 ifName.197376 = epon3:3 ifName.70912 = epon1:21 ifInMulticastPkts.1 = 0 ifInMulticastPkts.6 = 38221005 ifInMulticastPkts.7 = 38220970 ifInMulticastPkts.5001 = 34791764 ifInMulticastPkts.5002 = 7 ifInMulticastPkts.5003 = 22359992 ifInMulticastPkts.5004 = 7 ifInMulticastPkts.5005 = 102841 Error: OID not increasing: ifName.197120 >= ifName.70912 SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'] Exitcode: 1 Error: OID not increasing: ifIndex.197120 >= ifIndex.70912 ifIndex.1 = 1 ifIndex.6 = 6 ifIndex.7 = 7 ifIndex.5001 = 5001 ifIndex.5002 = 5002 ifIndex.5003 = 5003 ifIndex.5004 = 5004 ifIndex.5005 = 5005 ifIndex.5006 = 5006 ifIndex.5007 = 5007 ifIndex.5008 = 5008 ifIndex.5009 = 5009 ifIndex.5010 = 5010 ifIndex.5011 = 5011 ifIndex.5012 = 5012 ifIndex.65536 = 65536 ifIndex.65792 = 65792 ifIndex.66048 = 66048 ifIndex.66304 = 66304 ifIndex.66560 = 66560 ifIndex.66816 = 66816 ifIndex.67072 = 67072 ifIndex.67328 = 67328 ifIndex.67584 = 67584 ifIndex.67840 = 67840 ifIndex.68096 = 68096 ifIndex.68352 = 68352 ifIndex.68608 = 68608 ifIndex.68864 = 68864 ifIndex.69120 = 69120 ifIndex.69376 = 69376 ifIndex.69632 = 69632 ifIndex.69888 = 69888 ifIndex.70144 = 70144 ifIndex.70400 = 70400 ifIndex.70656 = 70656 ifIndex.131072 = 131072 ifIndex.196608 = 196608 ifIndex.196864 = 196864 ifIndex.197120 = 197120 ifIndex.197376 = 197376 ifIndex.70912 = 70912 ifDescr.1 = lo ifDescr.6 = vlan1.1 ifDescr.7 = vlan1.50 ifDescr.5001 = epon1 ifDescr.5002 = epon2 ifDescr.5003 = epon3 ifDescr.5004 = epon4 ifDescr.5005 = ge1 Error: OID not increasing: ifIndex.197120 >= ifIndex.70912 dot3StatsDuplexStatus SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'] 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['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'] dot1qPvid.1 = 62 dot1qPvid.2 = 62 dot1qPvid.3 = 62 dot1qPvid.4 = 62 dot1qPvid.5 = 62 dot1qPvid.6 = 62 dot1qPvid.7 = 1 dot1qPvid.8 = 1 dot1qPvid.9 = 1 dot1qPvid.10 = 1 dot1qPvid.11 = 1 dot1qPvid.12 = 1 SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl','vdsl2') [24] 0.83ms] array ( 1 => array ( 'ifName' => 'lo', 'ifInMulticastPkts' => '0', 'ifIndex' => '1', 'ifDescr' => 'lo', 'dot1qPvid' => '62', ), 6 => array ( 'ifName' => 'vlan1.1', 'ifInMulticastPkts' => '38221005', 'ifIndex' => '6', 'ifDescr' => 'vlan1.1', 'dot1qPvid' => '62', ), 7 => array ( 'ifName' => 'vlan1.50', 'ifInMulticastPkts' => '38220970', 'ifIndex' => '7', 'ifDescr' => 'vlan1.50', 'dot1qPvid' => '1', ), 5001 => array ( 'ifName' => 'epon1', 'ifInMulticastPkts' => '34791764', 'ifIndex' => '5001', 'ifDescr' => 'epon1', ), 5002 => array ( 'ifName' => 'epon2', 'ifInMulticastPkts' => '7', 'ifIndex' => '5002', 'ifDescr' => 'epon2', ), 5003 => array ( 'ifName' => 'epon3', 'ifInMulticastPkts' => '22359992', 'ifIndex' => '5003', 'ifDescr' => 'epon3', ), 5004 => array ( 'ifName' => 'epon4', 'ifInMulticastPkts' => '7', 'ifIndex' => '5004', 'ifDescr' => 'epon4', ), 5005 => array ( 'ifName' => 'ge1', 'ifInMulticastPkts' => '102841', 'ifIndex' => '5005', 'ifDescr' => 'ge1', ), 5006 => array ( 'ifName' => 'ge2', 'ifIndex' => '5006', ), 5007 => array ( 'ifName' => 'ge3', 'ifIndex' => '5007', ), 5008 => array ( 'ifName' => 'ge4', 'ifIndex' => '5008', ), 5009 => array ( 'ifName' => 'ge5', 'ifIndex' => '5009', ), 5010 => array ( 'ifName' => 'ge6', 'ifIndex' => '5010', ), 5011 => array ( 'ifName' => 'xe1', 'ifIndex' => '5011', ), 5012 => array ( 'ifName' => 'xe2', 'ifIndex' => '5012', ), 65536 => array ( 'ifName' => 'epon1:0', 'ifIndex' => '65536', ), 65792 => array ( 'ifName' => 'epon1:1', 'ifIndex' => '65792', ), 66048 => array ( 'ifName' => 'epon1:2', 'ifIndex' => '66048', ), 66304 => array ( 'ifName' => 'epon1:3', 'ifIndex' => '66304', ), 66560 => array ( 'ifName' => 'epon1:4', 'ifIndex' => '66560', ), 66816 => array ( 'ifName' => 'epon1:5', 'ifIndex' => '66816', ), 67072 => array ( 'ifName' => 'epon1:6', 'ifIndex' => '67072', ), 67328 => array ( 'ifName' => 'epon1:7', 'ifIndex' => '67328', ), 67584 => array ( 'ifName' => 'epon1:8', 'ifIndex' => '67584', ), 67840 => array ( 'ifName' => 'epon1:9', 'ifIndex' => '67840', ), 68096 => array ( 'ifName' => 'epon1:10', 'ifIndex' => '68096', ), 68352 => array ( 'ifName' => 'epon1:11', 'ifIndex' => '68352', ), 68608 => array ( 'ifName' => 'epon1:12', 'ifIndex' => '68608', ), 68864 => array ( 'ifName' => 'epon1:13', 'ifIndex' => '68864', ), 69120 => array ( 'ifName' => 'epon1:14', 'ifIndex' => '69120', ), 69376 => array ( 'ifName' => 'epon1:15', 'ifIndex' => '69376', ), 69632 => array ( 'ifName' => 'epon1:16', 'ifIndex' => '69632', ), 69888 => array ( 'ifName' => 'epon1:17', 'ifIndex' => '69888', ), 70144 => array ( 'ifName' => 'epon1:18', 'ifIndex' => '70144', ), 70400 => array ( 'ifName' => 'epon1:19', 'ifIndex' => '70400', ), 70656 => array ( 'ifName' => 'epon1:20', 'ifIndex' => '70656', ), 131072 => array ( 'ifName' => 'epon2:0', 'ifIndex' => '131072', ), 196608 => array ( 'ifName' => 'epon3:0', 'ifIndex' => '196608', ), 196864 => array ( 'ifName' => 'epon3:1', 'ifIndex' => '196864', ), 197120 => array ( 'ifName' => 'epon3:2', 'ifIndex' => '197120', ), 197376 => array ( 'ifName' => 'epon3:3', 'ifIndex' => '197376', ), 70912 => array ( 'ifName' => 'epon1:21', 'ifIndex' => '70912', ), 2 => array ( 'dot1qPvid' => '62', ), 3 => array ( 'dot1qPvid' => '62', ), 4 => array ( 'dot1qPvid' => '62', ), 5 => array ( 'dot1qPvid' => '62', ), 8 => array ( 'dot1qPvid' => '1', ), 9 => array ( 'dot1qPvid' => '1', ), 10 => array ( 'dot1qPvid' => '1', ), 11 => array ( 'dot1qPvid' => '1', ), 12 => array ( 'dot1qPvid' => '1', ), ) valid valid valid valid valid valid valid valid ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2378] 4.3ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2379] 3.56ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2380] 3.72ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2381] 3.63ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2382] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2383] 3.67ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2384] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2385] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2386] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2387] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2388] 3.69ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2389] 3.71ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2390] 3.66ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2391] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2392] 3.7ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2393] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2394] 3.69ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2395] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2396] 3.69ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2397] 3.69ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2398] 3.69ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2399] 3.69ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2400] 3.69ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2401] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2402] 3.65ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2403] 3.73ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2404] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2405] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2406] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2407] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2408] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2409] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2410] 3.68ms] ignored: empty ifDescr SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",2411] 3.68ms] ignored: empty ifDescr, ifAlias and ifName SQL[UPDATE `ports` set `deleted`=? WHERE `port_id` = ? ["1",null] 0.17ms] ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName Port lo: lo (1 / #1157) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts No ifSpeed VLAN = 62 Using ifDescr as ifAlias SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1157,"interface","2022-07-09 01:22:57",4,"ifOperStatus: up -> NULL",""] 1.73ms] ifOperStatus: up -> NULL SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1157,"interface","2022-07-09 01:22:57",4,"ifType: softwareLoopback -> NULL",""] 3.29ms] ifType: softwareLoopback -> NULL lo ifInOctets (0 B) 0 Bps 142 secs ifOutOctets (0 B) 0 Bps 142 secs ifInErrors (0 B) 0 Bps 142 secs ifOutErrors (0 B) 0 Bps 142 secs ifInUcastPkts (0 B) 0 Bps 142 secs ifOutUcastPkts (0 B) 0 Bps 142 secs ifInNUcastPkts (0 B) 0 Bps 142 secs ifOutNUcastPkts (0 B) 0 Bps 142 secs ifInDiscards (0 B) 0 Bps 142 secs ifOutDiscards (0 B) 0 Bps 142 secs ifInUnknownProtos (0 B) 0 Bps 142 secs ifInBroadcastPkts (0 B) 0 Bps 142 secs ifOutBroadcastPkts (0 B) 0 Bps 142 secs ifInMulticastPkts (0 B) 0 Bps 142 secs ifOutMulticastPkts (0 B) 0 Bps 142 secs bps(0 bps/0 bps) bytes(0 B/0 B)pkts(0 pps/0 pps) SQL[UPDATE `ports` set `ifOperStatus`=NULL,`ifSpeed_prev`=?,`ifType`=NULL,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1657309976,1657309834,142,1157] 1.87ms] 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,1157] 0.38ms] 1 updated Port vlan1.1: vlan1.1 (6 / #1158) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts No ifSpeed VLAN = 62 Using ifDescr as ifAlias SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1158,"interface","2022-07-09 01:22:57",4,"ifOperStatus: up -> NULL",""] 2.17ms] ifOperStatus: up -> NULL SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1158,"interface","2022-07-09 01:22:57",4,"ifType: other -> NULL",""] 3.42ms] ifType: other -> NULL vlan1.1 ifInOctets (0 B) 0 Bps 142 secs ifOutOctets (0 B) 0 Bps 142 secs ifInErrors (0 B) 0 Bps 142 secs ifOutErrors (0 B) 0 Bps 142 secs ifInUcastPkts (0 B) 0 Bps 142 secs ifOutUcastPkts (0 B) 0 Bps 142 secs ifInNUcastPkts (0 B) 0 Bps 142 secs ifOutNUcastPkts (0 B) 0 Bps 142 secs ifInDiscards (0 B) 0 Bps 142 secs ifOutDiscards (0 B) 0 Bps 142 secs ifInUnknownProtos (0 B) 0 Bps 142 secs ifInBroadcastPkts (0 B) 0 Bps 142 secs ifOutBroadcastPkts (0 B) 0 Bps 142 secs ifInMulticastPkts (310 B) 2.1830985915493 Bps 142 secs ifOutMulticastPkts (0 B) 0 Bps 142 secs bps(0 bps/0 bps) bytes(0 B/0 B)pkts(0 pps/0 pps) SQL[UPDATE `ports` set `ifOperStatus`=NULL,`ifType`=NULL,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1657309976,1657309834,142,1158] 2.12ms] 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,"38221005",38220695,2.183098591549296,310,0,0,0,0,1158] 3.69ms] 2 updated Port vlan1.50: vlan1.50 (7 / #1159) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts No ifSpeed VLAN = 1 Using ifDescr as ifAlias SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1159,"interface","2022-07-09 01:22:57",4,"ifOperStatus: up -> NULL",""] 2.83ms] ifOperStatus: up -> NULL SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1159,"interface","2022-07-09 01:22:57",4,"ifType: other -> NULL",""] 3.43ms] ifType: other -> NULL vlan1.50 ifInOctets (0 B) 0 Bps 142 secs ifOutOctets (0 B) 0 Bps 142 secs ifInErrors (0 B) 0 Bps 142 secs ifOutErrors (0 B) 0 Bps 142 secs ifInUcastPkts (0 B) 0 Bps 142 secs ifOutUcastPkts (0 B) 0 Bps 142 secs ifInNUcastPkts (0 B) 0 Bps 142 secs ifOutNUcastPkts (0 B) 0 Bps 142 secs ifInDiscards (0 B) 0 Bps 142 secs ifOutDiscards (0 B) 0 Bps 142 secs ifInUnknownProtos (0 B) 0 Bps 142 secs ifInBroadcastPkts (0 B) 0 Bps 142 secs ifOutBroadcastPkts (0 B) 0 Bps 142 secs ifInMulticastPkts (310 B) 2.1830985915493 Bps 142 secs ifOutMulticastPkts (0 B) 0 Bps 142 secs bps(0 bps/0 bps)bytes(0 B/0 B) pkts(0 pps/0 pps) SQL[UPDATE `ports` set `ifOperStatus`=NULL,`ifType`=NULL,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1657309976,1657309834,142,1159] 2.22ms] 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,"38220970",38220660,2.183098591549296,310,0,0,0,0,1159] 3.66ms] 2 updated Port epon1: epon1 (5001 / #1160) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts No ifSpeed VLAN = Using ifDescr as ifAlias SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1160,"interface","2022-07-09 01:22:57",4,"ifOperStatus: up -> NULL",""] 2.87ms] ifOperStatus: up -> NULL SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1160,"interface","2022-07-09 01:22:57",4,"ifType: ethernetCsmacd -> NULL",""] 3.43ms] ifType: ethernetCsmacd -> NULL epon1 ifInOctets (0 B) 0 Bps 142 secs ifOutOctets (0 B) 0 Bps 142 secs ifInErrors (0 B) 0 Bps 142 secs ifOutErrors (0 B) 0 Bps 142 secs ifInUcastPkts (0 B) 0 Bps 142 secs ifOutUcastPkts (0 B) 0 Bps 142 secs ifInNUcastPkts (0 B) 0 Bps 142 secs ifOutNUcastPkts (0 B) 0 Bps 142 secs ifInDiscards (0 B) 0 Bps 142 secs ifOutDiscards (0 B) 0 Bps 142 secs ifInUnknownProtos (0 B) 0 Bps 142 secs ifInBroadcastPkts (0 B) 0 Bps 142 secs ifOutBroadcastPkts (0 B) 0 Bps 142 secs ifInMulticastPkts (277 B) 1.9507042253521 Bps 142 secs ifOutMulticastPkts (0 B) 0 Bps 142 secs bps(0 bps/0 bps)bytes(0 B/0 B) pkts(0 pps/0 pps) SQL[UPDATE `ports` set `ifOperStatus`=NULL,`ifSpeed_prev`=?,`ifType`=NULL,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1657309976,1657309834,142,1160] 2.2ms] 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,"34791764",34791487,1.9507042253521127,277,0,0,0,0,1160] 3.67ms] 2 updated Port epon2: epon2 (5002 / #1161) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts No ifSpeed VLAN = Using ifDescr as ifAlias SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1161,"interface","2022-07-09 01:22:57",4,"ifOperStatus: down -> NULL",""] 2.87ms] ifOperStatus: down -> NULL SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1161,"interface","2022-07-09 01:22:57",4,"ifType: ethernetCsmacd -> NULL",""] 3.42ms] ifType: ethernetCsmacd -> NULL epon2 ifInOctets (0 B) 0 Bps 142 secs ifOutOctets (0 B) 0 Bps 142 secs ifInErrors (0 B) 0 Bps 142 secs ifOutErrors (0 B) 0 Bps 142 secs ifInUcastPkts (0 B) 0 Bps 142 secs ifOutUcastPkts (0 B) 0 Bps 142 secs ifInNUcastPkts (0 B) 0 Bps 142 secs ifOutNUcastPkts (0 B) 0 Bps 142 secs ifInDiscards (0 B) 0 Bps 142 secs ifOutDiscards (0 B) 0 Bps 142 secs ifInUnknownProtos (0 B) 0 Bps 142 secs ifInBroadcastPkts (0 B) 0 Bps 142 secs ifOutBroadcastPkts (0 B) 0 Bps 142 secs ifInMulticastPkts (0 B) 0 Bps 142 secs ifOutMulticastPkts (0 B) 0 Bps 142 secs bps(0 bps/0 bps) bytes(0 B/0 B)pkts(0 pps/0 pps) SQL[UPDATE `ports` set `ifOperStatus`=NULL,`ifSpeed_prev`=?,`ifType`=NULL,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1657309976,1657309834,142,1161] 2.19ms] 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,"7",7,0,0,0,0,0,0,1161] 0.37ms] 1 updated Port epon3: epon3 (5003 / #1162) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts No ifSpeed VLAN = Using ifDescr as ifAlias SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1162,"interface","2022-07-09 01:22:57",4,"ifOperStatus: up -> NULL",""] 6.27ms] ifOperStatus: up -> NULL SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1162,"interface","2022-07-09 01:22:57",4,"ifType: ethernetCsmacd -> NULL",""] 3.42ms] ifType: ethernetCsmacd -> NULL epon3 ifInOctets (0 B) 0 Bps 142 secs ifOutOctets (0 B) 0 Bps 142 secs ifInErrors (0 B) 0 Bps 142 secs ifOutErrors (0 B) 0 Bps 142 secs ifInUcastPkts (0 B) 0 Bps 142 secs ifOutUcastPkts (0 B) 0 Bps 142 secs ifInNUcastPkts (0 B) 0 Bps 142 secs ifOutNUcastPkts (0 B) 0 Bps 142 secs ifInDiscards (0 B) 0 Bps 142 secs ifOutDiscards (0 B) 0 Bps 142 secs ifInUnknownProtos (0 B) 0 Bps 142 secs ifInBroadcastPkts (0 B) 0 Bps 142 secs ifOutBroadcastPkts (0 B) 0 Bps 142 secs ifInMulticastPkts (276 B) 1.943661971831 Bps 142 secs ifOutMulticastPkts (0 B) 0 Bps 142 secs bps(0 bps/0 bps)bytes(0 B/0 B) pkts(0 pps/0 pps) SQL[UPDATE `ports` set `ifOperStatus`=NULL,`ifType`=NULL,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1657309976,1657309834,142,1162] 2.18ms] 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,"22359992",22359716,1.943661971830986,276,0,0,0,0,1162] 3.7ms] 2 updated Port epon4: epon4 (5004 / #1163) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts No ifSpeed VLAN = Using ifDescr as ifAlias SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1163,"interface","2022-07-09 01:22:57",4,"ifOperStatus: down -> NULL",""] 2.87ms] ifOperStatus: down -> NULL SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1163,"interface","2022-07-09 01:22:57",4,"ifType: ethernetCsmacd -> NULL",""] 3.42ms] ifType: ethernetCsmacd -> NULL epon4 ifInOctets (0 B) 0 Bps 142 secs ifOutOctets (0 B) 0 Bps 142 secs ifInErrors (0 B) 0 Bps 142 secs ifOutErrors (0 B) 0 Bps 142 secs ifInUcastPkts (0 B) 0 Bps 142 secs ifOutUcastPkts (0 B) 0 Bps 142 secs ifInNUcastPkts (0 B) 0 Bps 142 secs ifOutNUcastPkts (0 B) 0 Bps 142 secs ifInDiscards (0 B) 0 Bps 142 secs ifOutDiscards (0 B) 0 Bps 142 secs ifInUnknownProtos (0 B) 0 Bps 142 secs ifInBroadcastPkts (0 B) 0 Bps 142 secs ifOutBroadcastPkts (0 B) 0 Bps 142 secs ifInMulticastPkts (0 B) 0 Bps 142 secs ifOutMulticastPkts (0 B) 0 Bps 142 secs bps(0 bps/0 bps)bytes(0 B/0 B) pkts(0 pps/0 pps) SQL[UPDATE `ports` set `ifOperStatus`=NULL,`ifType`=NULL,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1657309976,1657309834,142,1163] 2.18ms] 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,"7",7,0,0,0,0,0,0,1163] 0.37ms] 1 updated Port ge1: ge1 (5005 / #1164) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts No ifSpeed VLAN = Using ifDescr as ifAlias SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1164,"interface","2022-07-09 01:22:57",4,"ifOperStatus: down -> NULL",""] 2.25ms] ifOperStatus: down -> NULL SQL[insert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [24,1164,"interface","2022-07-09 01:22:57",4,"ifType: ethernetCsmacd -> NULL",""] 3.41ms] ifType: ethernetCsmacd -> NULL ge1 ifInOctets (0 B) 0 Bps 142 secs ifOutOctets (0 B) 0 Bps 142 secs ifInErrors (0 B) 0 Bps 142 secs ifOutErrors (0 B) 0 Bps 142 secs ifInUcastPkts (0 B) 0 Bps 142 secs ifOutUcastPkts (0 B) 0 Bps 142 secs ifInNUcastPkts (0 B) 0 Bps 142 secs ifOutNUcastPkts (0 B) 0 Bps 142 secs ifInDiscards (0 B) 0 Bps 142 secs ifOutDiscards (0 B) 0 Bps 142 secs ifInUnknownProtos (0 B) 0 Bps 142 secs ifInBroadcastPkts (0 B) 0 Bps 142 secs ifOutBroadcastPkts (0 B) 0 Bps 142 secs ifInMulticastPkts (0 B) 0 Bps 142 secs ifOutMulticastPkts (0 B) 0 Bps 142 secs bps(0 bps/0 bps)bytes(0 B/0 B) pkts(0 pps/0 pps) SQL[UPDATE `ports` set `ifOperStatus`=NULL,`ifSpeed_prev`=?,`ifType`=NULL,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1657309976,1657309834,142,1164] 2.19ms] 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,"102841",102841,0,0,0,0,0,0,1164] 0.36ms] 1 updated SQL[update `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [1657309976,1657309834,null] 0.16ms] 0 updated >> Runtime for poller module 'ports': 0.7893 seconds with 378264 bytes >> SNMP: [4/0.52s] MySQL: [70/2.14s] #### Unload poller module ports #### Modules status: Global+ OS Device #### Load poller module customoid #### SQL[SELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [24] 0.5ms] >> Runtime for poller module 'customoid': 0.0010 seconds with 1320 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module customoid #### Modules status: Global+ OS Device #### Load poller module bgp-peers #### SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [24] 0.59ms] >> Runtime for poller module 'bgp-peers': 0.0028 seconds with 14328 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module bgp-peers #### Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = ? [24] 0.33ms] >> Runtime for poller module 'ucd-diskio': 0.0008 seconds with 784 bytes >> SNMP: [0/0.00s] MySQL: [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: generic OS initialized: LibreNMS\OS\Generic SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [24] 0.49ms] >> Runtime for poller module 'wireless': 0.0022 seconds with 103192 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module wireless #### Modules status: Global+ OS Device #### Load poller module ospf #### SQL[select * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [24] 0.45ms] Processes: SNMP['/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'] ospfRouterId.0 = * ospfAdminStat.0 = disabled ospfVersionNumber.0 = version2 ospfAreaBdrRtrStatus.0 = false ospfASBdrRtrStatus.0 = false ospfExternLsaCount.0 = 0 ospfTOSSupport.0 = false ospfOriginateNewLsas.0 = 0 ospfRxNewLsas.0 = 0 ospfExtLsdbLimit.0 = -1 ospfMulticastExtensions.0 = 0 ospfExitOverflowInterval.0 = 0 ospfDemandExtensions.0 = false SQL[select * from `ospf_instances` where (`device_id` = ? and `ospf_instance_id` = ? and `context_name` = ?) limit 1 [24,0,""] 0.69ms] . SQL[delete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and `id` not in (?) [24,"",3] 0.36ms] 1 Areas: SNMP['/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfAreaTable'] ospfAreaTable = No Such Object available on this agent at this OID SNMP query failed. Exit Code: 0 Empty: false Bad String: No Such Object available on this agent at this OID SQL[delete from `ospf_areas` where `ospf_areas`.`device_id` = ? and `ospf_areas`.`device_id` is not null and `context_name` = ? and 1 = 1 [24,""] 0.44ms] 0 Ports: SNMP['/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfIfTable'] ospfIfTable = No Such Object available on this agent at this OID SNMP query failed. Exit Code: 0 Empty: false Bad String: No Such Object available on this agent at this OID SQL[delete from `ospf_ports` where `ospf_ports`.`device_id` = ? and `ospf_ports`.`device_id` is not null and `context_name` = ? and 1 = 1 [24,""] 0.47ms] 0 Neighbours: SNMP['/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfNbrTable'] ospfNbrTable = No Such Object available on this agent at this OID SNMP query failed. Exit Code: 0 Empty: false Bad String: No Such Object available on this agent at this OID SQL[delete from `ospf_nbrs` where `ospf_nbrs`.`device_id` = ? and `ospf_nbrs`.`device_id` is not null and `context_name` = ? and 1 = 1 [24,""] 0.43ms] 0 TOS Metrics: SNMP['/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfIfMetricTable'] ospfIfMetricTable = No Such Object available on this agent at this OID SNMP query failed. Exit Code: 0 Empty: false Bad String: No Such Object available on this agent at this OID 0 >> Runtime for poller module 'ospf': 0.2009 seconds with 228120 bytes >> SNMP: [5/0.19s] MySQL: [6/0.03s] #### 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.0002 seconds with 472 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module entity-physical #### Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[SELECT * FROM `applications` WHERE `device_id` = ? [24] 0.57ms] >> Runtime for poller module 'applications': 0.0010 seconds with 576 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module applications #### Modules status: Global+ OS Device #### Load poller module stp #### Instances: SQL[select * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [24] 0.5ms] SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' 'udp:HOSTNAME:161' 'BRIDGE-MIB::dot1dStpTimeSinceTopologyChange.0' 'BRIDGE-MIB::dot1dStpTopChanges.0' 'BRIDGE-MIB::dot1dStpDesignatedRoot.0'] BRIDGE-MIB::dot1dStpTimeSinceTopologyChange.0 = 2934 BRIDGE-MIB::dot1dStpTopChanges.0 = 50921 BRIDGE-MIB::dot1dStpDesignatedRoot.0 = "10 00 D4 94 E8 04 45 59 " . Ports: SQL[select * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [24] 0.71ms] . . . >> Runtime for poller module 'stp': 0.0246 seconds with 66440 bytes >> SNMP: [1/0.02s] MySQL: [2/0.01s] #### Unload poller module stp #### Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 400 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module ntp #### Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device #### Load poller module mpls #### >> Runtime for poller module 'mpls': 0.0004 seconds with 23656 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module mpls #### Modules status: Global+ OS Device #### Load poller module mib #### Warning: include(includes/polling/mib.inc.php): failed to open stream: No such file or directory in /opt/librenms/includes/polling/functions.inc.php on line 329 Warning: include(): Failed opening 'includes/polling/mib.inc.php' for inclusion (include_path='.:/usr/share/php') in /opt/librenms/includes/polling/functions.inc.php on line 329 >> Runtime for poller module 'mib': 0.0001 seconds with 0 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module mib #### Enabling graphs: SQL[select * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [24] 0.57ms] SQL[UPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [2.376,24] 2.01ms] Updating 10.10.172.34 Polled in 2.376 seconds ### Start Device Groups ### SQL[select * from `device_groups` [] 6.81ms] SQL[select `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1) [] 0.64ms] SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [24] 0.47ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.015s ### #### Start Alerts #### SQL[select `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [24] 0.63ms] SQL[select exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`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` = ?))) as `exists` ["2022-07-08T19:52:57.441196Z","2022-07-08T19:52:57.441196Z",0,1,"19:52:57","19:52:57","19:52:57","19:52:57","%","device",24] 0.81ms] SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [24] 0.72ms] SQL[SELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?) LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?)) LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?)) LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ? WHERE a.disabled = 0 AND ( (d.device_id IS NULL AND g.group_id IS NULL) OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?)) OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL)) ) [24,24,24,24,24,24,24,24] 1.66ms] Rule #1 (Devices up/down): SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [24] 0.58ms] SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,24] 0.29ms] Status: NOCHG Rule #2 (Port status up/down): SQL[SELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [24] 1.31ms] SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,24] 0.33ms] Status: NOCHG #### End Alerts #### /opt/librenms/poller.php 10.10.172.34 2022-07-09 01:22:57 - 1 devices polled in 2.768 secs SNMP [23/1.01s]: Snmpget[12/0.23s] Snmpwalk[11/0.78s] SQL [126/2.61s]: Select[45/0.36s] Delete[5/0.02s] Insert[17/0.55s] Update[59/1.68s]