LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.27ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.33ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.19ms] =================================== Version info: Commit SHA: fff8b8e8321e64057588ed34f13e4364cf4da3a7 Commit Date: 1620676608 DB Schema: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208) PHP: 7.3.27-1~deb10u1 MySQL: 10.3.27-MariaDB-0+deb10u1 RRDTool: 1.7.1 SNMP: NET-SNMP 5.7.3 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'dsaw1917.infra.wobcom.de' ORDER BY `device_id` ASC [0;33m[][0m 0.63ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[84][0m 0.37ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[84][0m 0.18ms] Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic Hostname: dsaw1917.infra.wobcom.de Device ID: 84 OS: generic Resolved IP: 10.120.18.231 SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["dsaw1917.infra.wobcom.de"][0m 0.41ms] [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'dsaw1917.infra.wobcom.de' response: {"xmt":3,"rcv":3,"loss":0,"min":2.4,"max":4.38,"avg":3.25,"dup":0,"exitcode":0} 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[84][0m 0.31ms] 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` = ?))) as `exists` [0;33m["2021-05-11T13:35:13.073148Z","2021-05-11T13:35:13.073148Z",0,1,"13:35:13","13:35:13","13:35:13","13:35:13","[42m%","device",84][0m 0.56ms] SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) [0;33m{"xmt":3,"rcv":3,"loss":0,"min":2.4,"max":4.38,"avg":3.25,"device_id":84,"debug":"[]"}[0m 5.89ms] SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-05-11 15:35:13",3.25,84][0m 11.44ms] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = 2288928508 .*.*.0 = DSAW1917 .*.*.0 = .*.4.1.3181.10.6 .*.*.0 = MICROSENS G6 Micro-Switch SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m] snmpEngineTime.0 = 108834877 hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 108834877 Uptime: 3 years 164 days 15 hours 54 minutes 37 seconds >> Runtime for poller module 'core': 2.3374 seconds with 25256 bytes >> SNMP: [2/2.34s] MySQL: [0/0.00s] #### Unload poller module core #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[84][0m 3.75ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[84][0m 0.27ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[84,1620653716][0m 0.27ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.877,333][0m 0.19ms] 1 day : 99.877% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[84,1620135316][0m 0.22ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.982,334][0m 0.17ms] 7 days : 99.982% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[84,1618148116][0m 0.26ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.996,335][0m 0.16ms] 30 days : 99.996% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[84,1589204116][0m 0.21ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,336][0m 0.16ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0081 seconds with 39504 bytes >> SNMP: [0/0.00s] MySQL: [5/0.00s] #### Unload poller module availability #### 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.0012 seconds with 93088 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[84][0m 0.31ms] array ( ) >> Runtime for poller module 'ipmi': 0.0006 seconds with 2992 bytes >> SNMP: [0/0.00s] MySQL: [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[84][0m 0.25ms] >> Runtime for poller module 'sensors': 0.0004 seconds with 1544 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[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[84][0m 0.28ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.2021.11.11.0'[0m] .*.4.1.2* = 68 array ( '.1.3.6.1.4.1.2021.11.11.0' => '68', ) CPU: 32% >> Runtime for poller module 'processors': 0.9049 seconds with 62432 bytes >> SNMP: [1/0.90s] MySQL: [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[84][0m 0.44ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.2021.4.6.0' '.1.3.6.1.4.1.2021.4.14.0' '.1.3.6.1.4.1.2021.4.15.0'[0m] .*.4.1.2* = 89648 .*.4.1.2* = 68184 .*.4.1.2* = 64348 Free memory adjusted by availability calculation: 87.55 MiiB -> 216.97 MiiB ucd [system]: Physical memory: 131.42 MiiB / 248.39 MiiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[32948224,227512320,168][0m 14.07ms] ucd [buffers]: Memory buffers: 27f.59 MiiB / 248.39 MiiB ucd [cached]: Cached memory: 25b.84 MiiB / 248.39 MiiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[65892352,194568192,170][0m 16.78ms] >> Runtime for poller module 'mempools': 0.0971 seconds with 106904 bytes >> SNMP: [1/0.06s] MySQL: [0/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[84][0m 0.38ms] >> Runtime for poller module 'storage': 0.0007 seconds with 1984 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'icmp'[0m] icmp = No Such Object available on this agent at this OID Invalid snmp_walk() data = icmp = No Such Object available on this agent at this OID IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m] ipForwDatagrams.0 = 0 ipInDelivers.0 = 50157056 ipInReceives.0 = 61034886 ipOutRequests.0 = 36794474 ipInDiscards.0 = 0 ipOutDiscards.0 = 0 ipOutNoRoutes.0 = 0 ipReasmReqds.0 = 1099 ipReasmOKs.0 = 486 ipReasmFails.0 = 0 ipFragOKs.0 = 0 ipFragFails.0 = 0 ipFragCreates.0 = 0 ipInUnknownProtos.0 = 68 ipInHdrErrors.0 = 0 ipInAddrErrors.0 = 2070351 IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] No Such Object available on this agent at this OID SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmp'[0m] snmp = No Such Object available on this agent at this OID Invalid snmp_walk() data = snmp = No Such Object available on this agent at this OID TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m] transmission.*.101 = 101 transmission.*.101 = 101 transmission.*.101 = 101 transmission.*.101 = 101 transmission.*.101 = 101 transmission.*.101 = 101 transmission.*.101 = 101 transmission.*.101 = 101 transmission.*.101 = 101 transmission.*.101 = 101 TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m] transmission.*.101 = 101 transmission.*.101 = 101 UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m] transmission.*.101 = 101 transmission.*.101 = 101 transmission.*.101 = 101 transmission.*.101 = 101 >> Runtime for poller module 'netstats': 2.2578 seconds with 3704 bytes >> SNMP: [7/2.26s] MySQL: [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' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] 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.0158 seconds with 1640 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[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m] ssIndex.0 = 1 ssErrorName.0 = systemStats ssSwapIn.0 = 0 ssSwapOut.0 = 0 ssIOSent.0 = 0 ssIOReceive.0 = 1 ssSysInterrupts.0 = 2 ssSysContext.0 = 1 ssCpuUser.0 = 5 ssCpuSystem.0 = 25 ssCpuIdle.0 = 68 ssCpuRawUser.0 = 125239172 ssCpuRawNice.0 = 0 ssCpuRawSystem.0 = 591821914 ssCpuRawIdle.0 = 1574032430 ssCpuRawWait.0 = 44745 ssCpuRawKernel.0 = 590996779 ssCpuRawInterrupt.0 = 295925 ssIORawSent.0 = 27986726 ssIORawReceived.0 = 129482 ssRawInterrupts.0 = 2447989166 ssRawContexts.0 = 3280946129 ssCpuRawSoftIRQ.0 = 529210 ssRawSwapIn.0 = 0 ssRawSwapOut.0 = 0 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 = 115 laLoadInt.2 = 129 laLoadInt.3 = 124 >> Runtime for poller module 'ucd-mib': 0.0428 seconds with 4688 bytes >> SNMP: [2/0.04s] MySQL: [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.4638 seconds with 1976 bytes >> SNMP: [1/0.46s] MySQL: [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[84][0m 0.87ms] 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] ifAlias.101 = Port 1 ifAlias.102 = Port 2 ifAlias.103 = Port 3 ifAlias.104 = Port 4 ifAlias.105 = Downlink (Port 5) ifAlias.106 = Uplink (Port 6) SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifIndex.101 = 101 ifIndex.102 = 102 ifIndex.103 = 103 ifIndex.104 = 104 ifIndex.105 = 105 ifIndex.106 = 106 ifDescr.101 = Port 1 ifDescr.102 = Port 2 ifDescr.103 = Port 3 ifDescr.104 = Port 4 ifDescr.105 = Downlink (Port 5) ifDescr.106 = Uplink (Port 6) ifType.101 = ethernetCsmacd ifType.102 = ethernetCsmacd ifType.103 = ethernetCsmacd ifType.104 = ethernetCsmacd ifType.105 = ethernetCsmacd ifType.106 = ethernetCsmacd ifMtu.101 = 10240 ifMtu.102 = 10240 ifMtu.103 = 10240 ifMtu.104 = 10240 ifMtu.105 = 10240 ifMtu.106 = 10240 ifSpeed.101 = 1000000000 ifSpeed.102 = 0 ifSpeed.103 = 100000000 ifSpeed.104 = 100000000 ifSpeed.105 = 1000000000 ifSpeed.106 = 0 ifPhysAddress.101 = ifPhysAddress.102 = ifPhysAddress.103 = ifPhysAddress.104 = ifPhysAddress.105 = ifPhysAddress.106 = ifAdminStatus.101 = up ifAdminStatus.102 = up ifAdminStatus.103 = up ifAdminStatus.104 = up ifAdminStatus.105 = up ifAdminStatus.106 = up ifOperStatus.101 = up ifOperStatus.102 = down ifOperStatus.103 = up ifOperStatus.104 = up ifOperStatus.105 = up ifOperStatus.106 = down ifLastChange.101 = 2233361008 ifLastChange.102 = 13514408 ifLastChange.103 = 2098141408 ifLastChange.104 = 2098141508 ifLastChange.105 = 2106415808 ifLastChange.106 = 1900 ifInOctets.101 = 1963883910 ifInOctets.102 = 1821648028 ifInOctets.103 = 3495314758 ifInOctets.104 = 3698532465 ifInOctets.105 = 1555748845 ifInOctets.106 = 0 ifInUcastPkts.101 = 172855918 ifInUcastPkts.102 = 10415362 ifInUcastPkts.103 = 9347666 ifInUcastPkts.104 = 3339920040 ifInUcastPkts.105 = 2341237490 ifInUcastPkts.106 = 0 ifInNUcastPkts.101 = 6282051 ifInNUcastPkts.102 = 106270 ifInNUcastPkts.103 = 263491 ifInNUcastPkts.104 = 6941508 ifInNUcastPkts.105 = 3869241846 ifInNUcastPkts.106 = 0 ifInDiscards.101 = 0 ifInDiscards.102 = 0 ifInDiscards.103 = 0 ifInDiscards.104 = 0 ifInDiscards.105 = 2 ifInDiscards.106 = 0 ifInErrors.101 = 0 ifInErrors.102 = 0 ifInErrors.103 = 0 ifInErrors.104 = 0 ifInErrors.105 = 0 ifInErrors.106 = 0 ifInUnknownProtos.101 = 0 ifInUnknownProtos.102 = 0 ifInUnknownProtos.103 = 0 ifInUnknownProtos.104 = 0 ifInUnknownProtos.105 = 0 ifInUnknownProtos.106 = 0 ifOutOctets.101 = 462797961 ifOutOctets.102 = 1071003252 ifOutOctets.103 = 1864893987 ifOutOctets.104 = 2827779130 ifOutOctets.105 = 2631265536 ifOutOctets.106 = 1047 ifOutUcastPkts.101 = 344900451 ifOutUcastPkts.102 = 37563177 ifOutUcastPkts.103 = 23871092 ifOutUcastPkts.104 = 1686992408 ifOutUcastPkts.105 = 3563424653 ifOutUcastPkts.106 = 3 ifOutNUcastPkts.101 = 2460027866 ifOutNUcastPkts.102 = 93770398 ifOutNUcastPkts.103 = 177100246 ifOutNUcastPkts.104 = 181376804 ifOutNUcastPkts.105 = 10167345 ifOutNUcastPkts.106 = 4 ifOutDiscards.101 = 0 ifOutDiscards.102 = 0 ifOutDiscards.103 = 0 ifOutDiscards.104 = 0 ifOutDiscards.105 = 0 ifOutDiscards.106 = 0 ifOutErrors.101 = 0 ifOutErrors.102 = 0 ifOutErrors.103 = 0 ifOutErrors.104 = 0 ifOutErrors.105 = 0 ifOutErrors.106 = 0 ifOutQLen.101 = 0 ifOutQLen.102 = 0 ifOutQLen.103 = 0 ifOutQLen.104 = 0 ifOutQLen.105 = 0 ifOutQLen.106 = 0 ifSpecific.101 = zeroDotZero ifSpecific.102 = zeroDotZero ifSpecific.103 = zeroDotZero ifSpecific.104 = zeroDotZero ifSpecific.105 = zeroDotZero ifSpecific.106 = zeroDotZero dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus.101 = fullDuplex dot3StatsDuplexStatus.102 = unknown dot3StatsDuplexStatus.103 = fullDuplex dot3StatsDuplexStatus.104 = fullDuplex dot3StatsDuplexStatus.105 = fullDuplex dot3StatsDuplexStatus.106 = unknown SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid.1 = 1 dot1qPvid.2 = 508 dot1qPvid.3 = 40 dot1qPvid.4 = 518 dot1qPvid.5 = 1 dot1qPvid.6 = 1 SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[84][0m 0.82ms] array ( 101 => array ( 'ifAlias' => 'Port 1', 'ifIndex' => '101', 'ifDescr' => 'Port 1', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '10240', 'ifSpeed' => '1000000000', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '2233361008', 'ifInOctets' => '1963883910', 'ifInUcastPkts' => '172855918', 'ifInNUcastPkts' => '6282051', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '462797961', 'ifOutUcastPkts' => '344900451', 'ifOutNUcastPkts' => '2460027866', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', 'dot3StatsDuplexStatus' => 'fullDuplex', ), 102 => array ( 'ifAlias' => 'Port 2', 'ifIndex' => '102', 'ifDescr' => 'Port 2', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '10240', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'down', 'ifLastChange' => '13514408', 'ifInOctets' => '1821648028', 'ifInUcastPkts' => '10415362', 'ifInNUcastPkts' => '106270', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1071003252', 'ifOutUcastPkts' => '37563177', 'ifOutNUcastPkts' => '93770398', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', 'dot3StatsDuplexStatus' => 'unknown', ), 103 => array ( 'ifAlias' => 'Port 3', 'ifIndex' => '103', 'ifDescr' => 'Port 3', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '10240', 'ifSpeed' => '100000000', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '2098141408', 'ifInOctets' => '3495314758', 'ifInUcastPkts' => '9347666', 'ifInNUcastPkts' => '263491', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1864893987', 'ifOutUcastPkts' => '23871092', 'ifOutNUcastPkts' => '177100246', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', 'dot3StatsDuplexStatus' => 'fullDuplex', ), 104 => array ( 'ifAlias' => 'Port 4', 'ifIndex' => '104', 'ifDescr' => 'Port 4', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '10240', 'ifSpeed' => '100000000', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '2098141508', 'ifInOctets' => '3698532465', 'ifInUcastPkts' => '3339920040', 'ifInNUcastPkts' => '6941508', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '2827779130', 'ifOutUcastPkts' => '1686992408', 'ifOutNUcastPkts' => '181376804', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', 'dot3StatsDuplexStatus' => 'fullDuplex', ), 105 => array ( 'ifAlias' => 'Downlink (Port 5)', 'ifIndex' => '105', 'ifDescr' => 'Downlink (Port 5)', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '10240', 'ifSpeed' => '1000000000', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '2106415808', 'ifInOctets' => '1555748845', 'ifInUcastPkts' => '2341237490', 'ifInNUcastPkts' => '3869241846', 'ifInDiscards' => '2', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '2631265536', 'ifOutUcastPkts' => '3563424653', 'ifOutNUcastPkts' => '10167345', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', 'dot3StatsDuplexStatus' => 'fullDuplex', ), 106 => array ( 'ifAlias' => 'Uplink (Port 6)', 'ifIndex' => '106', 'ifDescr' => 'Uplink (Port 6)', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '10240', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'down', 'ifLastChange' => '1900', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1047', 'ifOutUcastPkts' => '3', 'ifOutNUcastPkts' => '4', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', 'dot3StatsDuplexStatus' => 'unknown', ), 1 => array ( 'dot1qPvid' => '1', ), 2 => array ( 'dot1qPvid' => '508', ), 3 => array ( 'dot1qPvid' => '40', ), 4 => array ( 'dot1qPvid' => '518', ), 5 => array ( 'dot1qPvid' => '1', ), 6 => array ( 'dot1qPvid' => '1', ), ) valid valid valid valid valid valid ignored: empty ifDescr, ifAlias and ifName SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `port_id` = ? [0;33m["1",null][0m 0.36ms] 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 Port 1: Port 1 (101 / #4735) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed dot3Duplex VLAN = Using ifDescr as ifName Port 1 ifInOctets (2945 B) 210.35714285714 Bps 14 secs ifOutOctets (45885 B) 3277.5 Bps 14 secs ifInErrors (0 B) 0 Bps 14 secs ifOutErrors (0 B) 0 Bps 14 secs ifInUcastPkts (5 B) 0.35714285714286 Bps 14 secs ifOutUcastPkts (24 B) 1.7142857142857 Bps 14 secs ifInNUcastPkts (0 B) 0 Bps 14 secs ifOutNUcastPkts (383 B) 27.357142857143 Bps 14 secs ifInDiscards (0 B) 0 Bps 14 secs ifOutDiscards (0 B) 0 Bps 14 secs ifInUnknownProtos (0 B) 0 Bps 14 secs ifInBroadcastPkts (0 B) 0 Bps 14 secs ifOutBroadcastPkts (0 B) 0 Bps 14 secs ifInMulticastPkts (0 B) 0 Bps 14 secs ifOutMulticastPkts (0 B) 0 Bps 14 secs bps(1.68 Kbps/26.22 Kbps)bytes(2.88 KiB/44.81 KiB)pkts(0.36 pps/1.71 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1963883910",1963880965,210.35714285714286,2945,"462797961",462752076,3277.5,45885,"0",0,0,0,"0",0,0,0,"172855918",172855913,0.35714285714285715,5,"344900451",344900427,1.7142857142857142,24,1620740131,1620740117,14,4735][0m 6ms] 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["6282051",6282051,0,0,"2460027866",2460027483,27.357142857142858,383,"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,4735][0m 10.71ms] 2 updated Port Port 2: Port 2 (102 / #4736) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed dot3Duplex VLAN = Using ifDescr as ifName Port 24736 skipped because port is still down since last polling. SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0",1620740131,1620740117,14,4736][0m 13.45ms] 1 updated Port Port 3: Port 3 (103 / #4737) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed dot3Duplex VLAN = Using ifDescr as ifName Port 3 ifInOctets (0 B) 0 Bps 14 secs ifOutOctets (1556 B) 111.14285714286 Bps 14 secs ifInErrors (0 B) 0 Bps 14 secs ifOutErrors (0 B) 0 Bps 14 secs ifInUcastPkts (0 B) 0 Bps 14 secs ifOutUcastPkts (6 B) 0.42857142857143 Bps 14 secs ifInNUcastPkts (0 B) 0 Bps 14 secs ifOutNUcastPkts (14 B) 1 Bps 14 secs ifInDiscards (0 B) 0 Bps 14 secs ifOutDiscards (0 B) 0 Bps 14 secs ifInUnknownProtos (0 B) 0 Bps 14 secs ifInBroadcastPkts (0 B) 0 Bps 14 secs ifOutBroadcastPkts (0 B) 0 Bps 14 secs ifInMulticastPkts (0 B) 0 Bps 14 secs ifOutMulticastPkts (0 B) 0 Bps 14 secs bps(0 bps/889 bps)bytes(0 B/1.52 KiB)pkts(0 pps/0.43 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["3495314758",3495314758,0,0,"1864893987",1864892431,111.14285714285714,1556,"0",0,0,0,"0",0,0,0,"9347666",9347666,0,0,"23871092",23871086,0.42857142857142855,6,1620740131,1620740117,14,4737][0m 11.6ms] 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["263491",263491,0,0,"177100246",177100232,1,14,"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,4737][0m 9.83ms] 2 updated Port Port 4: Port 4 (104 / #4738) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed dot3Duplex VLAN = Using ifDescr as ifName Port 4 ifInOctets (39344 B) 2810.2857142857 Bps 14 secs ifOutOctets (122971 B) 8783.6428571429 Bps 14 secs ifInErrors (0 B) 0 Bps 14 secs ifOutErrors (0 B) 0 Bps 14 secs ifInUcastPkts (426 B) 30.428571428571 Bps 14 secs ifOutUcastPkts (214 B) 15.285714285714 Bps 14 secs ifInNUcastPkts (1 B) 0.071428571428571 Bps 14 secs ifOutNUcastPkts (18 B) 1.2857142857143 Bps 14 secs ifInDiscards (0 B) 0 Bps 14 secs ifOutDiscards (0 B) 0 Bps 14 secs ifInUnknownProtos (0 B) 0 Bps 14 secs ifInBroadcastPkts (0 B) 0 Bps 14 secs ifOutBroadcastPkts (0 B) 0 Bps 14 secs ifInMulticastPkts (0 B) 0 Bps 14 secs ifOutMulticastPkts (0 B) 0 Bps 14 secs bps(22.48 Kbps/70.27 Kbps)bytes(38.42 KiB/120.09 KiB)pkts(30.43 pps/15.29 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["3698532465",3698493121,2810.285714285714,39344,"2827779130",2827656159,8783.642857142857,122971,"0",0,0,0,"0",0,0,0,"3339920040",3339919614,30.428571428571427,426,"1686992408",1686992194,15.285714285714286,214,1620740131,1620740117,14,4738][0m 8.54ms] 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["6941508",6941507,0.07142857142857142,1,"181376804",181376786,1.2857142857142858,18,"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,4738][0m 11.27ms] 2 updated Port Downlink (Port 5): Downlink (Port 5) (105 / #4739) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed dot3Duplex VLAN = Using ifDescr as ifName Downlink (Port 5)array ( 'type' => 'downlink ', 'descr' => 'Port 5', 'circuit' => NULL, 'speed' => '', 'notes' => 'Port 5', ) ifInOctets (188795 B) 13485.357142857 Bps 14 secs ifOutOctets (51220 B) 3658.5714285714 Bps 14 secs ifInErrors (0 B) 0 Bps 14 secs ifOutErrors (0 B) 0 Bps 14 secs ifInUcastPkts (281 B) 20.071428571429 Bps 14 secs ifOutUcastPkts (471 B) 33.642857142857 Bps 14 secs ifInNUcastPkts (535 B) 38.214285714286 Bps 14 secs ifOutNUcastPkts (1 B) 0.071428571428571 Bps 14 secs ifInDiscards (0 B) 0 Bps 14 secs ifOutDiscards (0 B) 0 Bps 14 secs ifInUnknownProtos (0 B) 0 Bps 14 secs ifInBroadcastPkts (0 B) 0 Bps 14 secs ifOutBroadcastPkts (0 B) 0 Bps 14 secs ifInMulticastPkts (0 B) 0 Bps 14 secs ifOutMulticastPkts (0 B) 0 Bps 14 secs bps(107.88 Kbps/29.27 Kbps)bytes(184.37 KiB/50.02 KiB)pkts(20.07 pps/33.64 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1555748845",1555560050,13485.357142857143,188795,"2631265536",2631214316,3658.5714285714284,51220,"0",0,0,0,"0",0,0,0,"2341237490",2341237209,20.071428571428573,281,"3563424653",3563424182,33.642857142857146,471,1620740131,1620740117,14,4739][0m 10.26ms] 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["3869241846",3869241311,38.214285714285715,535,"10167345",10167344,0.07142857142857142,1,"2",2,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,4739][0m 12.38ms] 2 updated Port Uplink (Port 6): Uplink (Port 6) (106 / #4740) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed dot3Duplex VLAN = Using ifDescr as ifName Uplink (Port 6)array ( 'type' => 'uplink ', 'descr' => 'Port 6', 'circuit' => NULL, 'speed' => '', 'notes' => 'Port 6', ) 4740 skipped because port is still down since last polling. SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0",1620740131,1620740117,14,4740][0m 10.48ms] 1 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1620740131,1620740117,null][0m 0.18ms] 0 updated >> Runtime for poller module 'ports': 10.8491 seconds with 47488 bytes >> SNMP: [4/10.73s] MySQL: [12/0.11s] #### 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[84][0m 0.18ms] >> Runtime for poller module 'customoid': 0.0005 seconds with 2448 bytes >> SNMP: [0/0.00s] MySQL: [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[84][0m 0.33ms] >> Runtime for poller module 'bgp-peers': 0.0014 seconds with 15048 bytes >> SNMP: [0/0.00s] MySQL: [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[84][0m 0.15ms] >> Runtime for poller module 'ucd-diskio': 0.0003 seconds with 1944 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[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[84][0m 0.18ms] >> Runtime for poller module 'wireless': 0.0016 seconds with 103144 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module wireless #### Modules status: Global+ OS Device #### Load poller module ospf #### 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` is null) and 1 = 1 [0;33m[84][0m 0.34ms] 0 >> Runtime for poller module 'ospf': 0.4639 seconds with 31824 bytes >> SNMP: [1/0.46s] MySQL: [0/0.00s] #### Unload poller module ospf #### Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ cisco-sla ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-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 #### SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[84][0m 0.34ms] >> Runtime for poller module 'entity-physical': 0.0007 seconds with 2152 bytes >> SNMP: [0/0.00s] MySQL: [1/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[84][0m 0.51ms] >> Runtime for poller module 'applications': 0.0007 seconds with 1592 bytes >> SNMP: [0/0.00s] MySQL: [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[84][0m 0.3ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m] 0 >> Runtime for poller module 'stp': 0.0743 seconds with 5408 bytes >> SNMP: [1/0.07s] MySQL: [1/0.00s] #### 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.0003 seconds with 23880 bytes >> SNMP: [0/0.00s] MySQL: [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[84][0m 0.45ms] SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m["108834877",3.25,20.046,84][0m 9.78ms] Updating dsaw1917.infra.wobcom.de Polled in 20.046 seconds ### Start Device Groups ### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[84][0m 0.42ms] SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.14ms] SQL[[1;33mselect `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;33m[][0m 0.43ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["dsm%",84][0m 0.32ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[84][0m 0.13ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0047s ### #### Start Alerts #### 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` = ?))) as `exists` [0;33m["2021-05-11T13:35:32.113970Z","2021-05-11T13:35:32.113970Z",0,1,"13:35:32","13:35:32","13:35:32","13:35:32","[42m%","device",84][0m 0.53ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[84][0m 0.23ms] 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[84,84,84,84,84,84,84,84][0m 1.36ms] Rule [0;35m#1 (Device Down! Due to no ICMP response.):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [0;33m[84][0m 0.31ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,84][0m 0.21ms] Status: [0;34mNOCHG[0m Rule [0;35m#2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [0;33m[84][0m 0.32ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,84][0m 0.21ms] Status: [0;34mNOCHG[0m Rule [0;35m#3 (Device rebooted):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed> 20 [0;33m[84][0m 0.27ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,84][0m 0.13ms] Status: [0;34mNOCHG[0m Rule [0;35m#6 (Port utilisation over threshold):[0m SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[84][0m 1.11ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,84][0m 0.22ms] Status: [0;34mNOCHG[0m Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m SQL[[1;33mSELECT * FROM devices,sensors,ports WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND devices.device_id = ports.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND (ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 0 [0;33m[84][0m 0.9ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,84][0m 0.14ms] Status: [0;34mNOCHG[0m Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= wireless_sensors.sensor_limit AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[84][0m 0.72ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,84][0m 0.14ms] Status: [0;34mNOCHG[0m Rule [0;35m#11 (Wireless Sensor under limit):[0m SQL[[1;33mSELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current <= wireless_sensors.sensor_limit_low AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[84][0m 0.39ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,84][0m 0.13ms] Status: [0;34mNOCHG[0m Rule [0;35m#12 (State Sensor Critical):[0m SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 AND sensors.sensor_alert = 1 [0;33m[84][0m 0.47ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,84][0m 0.13ms] Status: [0;34mNOCHG[0m #### End Alerts #### ./poller.php dsaw1917.infra.wobcom.de 2021-05-11 15:35:32 - 1 devices polled in 20.25 secs SNMP [22/18.82s]: Get[9/4.92s] Getnext[4/0.78s] Walk[9/13.12s] MySQL [44/0.15s]: Cell[13/0.00s] Row[-12/-0.00s] Rows[24/0.01s] Column[1/0.00s] Update[17/0.13s] Insert[1/0.01s] Delete[0/0.00s]