LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.52ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.45ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.29ms] =================================== Version info: Commit SHA: 37ac9dffbed58a434a446893d84b4d33ad1d83c0 Commit Date: 1620283571 DB Schema: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208) PHP: 7.4.3 MySQL: 10.3.25-MariaDB-0ubuntu0.20.04.1 RRDTool: 1.7.2 SNMP: NET-SNMP 5.8 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.140.254' ORDER BY `device_id` ASC [0;33m[][0m 0.88ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[24][0m 0.88ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[24][0m 0.24ms] Attempting to initialize OS: bintec OS initialized as Generic Hostname: 192.168.140.254 Device ID: 24 OS: bintec SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["192.168.140.254"][0m 0.63ms] [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '192.168.140.254' response: {"xmt":3,"rcv":3,"loss":0,"min":16.7,"max":26.9,"avg":20.1,"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[24][0m 0.5ms] SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[15][0m 0.36ms] SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2021-05-06T13:35:36.701336Z","2021-05-06T13:35:36.701336Z",0,1,"13:35:36","13:35:36","13:35:36","13:35:36","[44m%","device",24,"location",15][0m 1.35ms] 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":16.7,"max":26.9,"avg":20.1,"device_id":24,"debug":"[]"}[0m 4.6ms] SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-05-06 15:35:36",20.1,24][0m 3.71ms] 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 = 736408763 .*.*.0 = P1 NS Plein Tilburg .*.*.0 = .*.4.1.2*.*.0 .*.*.0 = RS353a 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] Exitcode: 2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemUptime.0 snmpEngineTime.0 = 7364087 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemUptime.0 Uptime seconds: 7364088 Uptime: 85 days 5 hours 34 minutes 48 seconds >> Runtime for poller module 'core': 0.1122 seconds with 25496 bytes >> SNMP: [2/0.11s] 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[24][0m 0.7ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[24][0m 0.5ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[24,1620221736][0m 0.78ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,89][0m 0.42ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[24,1619703336][0m 1.1ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,90][0m 0.37ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[24,1617716136][0m 1.1ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.931,91][0m 0.29ms] 30 days : 99.931% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[24,1588772136][0m 0.4ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.993,92][0m 0.26ms] 365 days : 99.993% >> Runtime for poller module 'availability': 0.0148 seconds with 39264 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: NS Plein 14. Tilburg Hardware: OS Version: OS Features: Serial: >> Runtime for poller module 'os': 0.0021 seconds with 93248 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[24][0m 0.66ms] array ( ) >> Runtime for poller module 'ipmi': 0.0013 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[24][0m 1.08ms] >> Runtime for poller module 'sensors': 0.0013 seconds with 1584 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: bintec OS initialized as Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[24][0m 0.91ms] >> Runtime for poller module 'processors': 0.0022 seconds with 126008 bytes >> SNMP: [0/0.00s] 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[24][0m 0.84ms] >> Runtime for poller module 'mempools': 0.0019 seconds with 75032 bytes >> SNMP: [0/0.00s] 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[24][0m 0.88ms] >> Runtime for poller module 'storage': 0.0011 seconds with 2032 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/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'icmp'[0m] icmpInMsgs.0 = 225004 icmpInErrors.0 = 5 icmpInDestUnreachs.0 = 5199 icmpInTimeExcds.0 = 3221 icmpInParmProbs.0 = 0 icmpInSrcQuenchs.0 = 0 icmpInRedirects.0 = 0 icmpInEchos.0 = 206714 icmpInEchoReps.0 = 9865 icmpInTimestamps.0 = 0 icmpInTimestampReps.0 = 0 icmpInAddrMasks.0 = 0 icmpInAddrMaskReps.0 = 0 icmpOutMsgs.0 = 339361 icmpOutErrors.0 = 0 icmpOutDestUnreachs.0 = 936 icmpOutTimeExcds.0 = 89509 icmpOutParmProbs.0 = 0 icmpOutSrcQuenchs.0 = 0 icmpOutRedirects.0 = 0 icmpOutEchos.0 = 42202 icmpOutEchoReps.0 = 206714 icmpOutTimestamps.0 = 0 icmpOutTimestampReps.0 = 0 icmpOutAddrMasks.0 = 0 icmpOutAddrMaskReps.0 = 0 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 = 1077485185 ipInDelivers.0 = 4787625 ipInReceives.0 = 1127331874 ipOutRequests.0 = 4627597 ipInDiscards.0 = 4088 ipOutDiscards.0 = 280348 ipOutNoRoutes.0 = 261 ipReasmReqds.0 = 3957 ipReasmOKs.0 = 1881 ipReasmFails.0 = 177 ipFragOKs.0 = 1871 ipFragFails.0 = 0 ipFragCreates.0 = 3760 ipInUnknownProtos.0 = 0 ipInHdrErrors.0 = 0 ipInAddrErrors.0 = 843667 IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] Exitcode: 2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: IP-FORWARD-MIB::ipCidrRouteNumber.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: IP-FORWARD-MIB::ipCidrRouteNumber.0 SNMPSNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmp'[0m] snmpInPkts.0 = 2346713 snmpOutPkts.0 = 2345873 snmpInBadVersions.0 = 0 snmpInBadCommunityNames.0 = 156 snmpInBadCommunityUses.0 = 0 snmpInASNParseErrs.0 = 840 snmpInTooBigs.0 = 0 snmpInNoSuchNames.0 = 0 snmpInBadValues.0 = 0 snmpInReadOnlys.0 = 0 snmpInGenErrs.0 = 0 snmpInTotalReqVars.0 = 2661581 snmpInTotalSetVars.0 = 0 snmpInGetRequests.0 = 280809 snmpInGetNexts.0 = 2065078 snmpInSetRequests.0 = 0 snmpInGetResponses.0 = 0 snmpInTraps.0 = 0 snmpOutTooBigs.0 = 0 snmpOutNoSuchNames.0 = 228187 snmpOutBadValues.0 = 0 snmpOutGenErrs.0 = 0 snmpOutGetRequests.0 = 2345894 snmpOutGetNexts.0 = 0 snmpOutSetRequests.0 = 0 snmpOutGetResponses.0 = 0 snmpOutTraps.0 = 0 snmpEnableAuthenTraps.0 = enabled snmpSilentDrops.0 = 0 snmpProxyDrops.0 = 0 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] tcpActiveOpens.0 = 0 tcpPassiveOpens.0 = 125864 tcpAttemptFails.0 = 0 tcpEstabResets.0 = 392 tcpCurrEstab.0 = 5 tcpInSegs.0 = 535952 tcpOutSegs.0 = 305702 tcpRetransSegs.0 = 655 tcpInErrs.0 = 0 tcpOutRsts.0 = 2204 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] tcpListenerTable.0 = 60 tcpListenerTable.0 = 60 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] udpInDatagrams.0 = 4161716 udpOutDatagrams.0 = 4279728 udpInErrors.0 = 786 udpNoPorts.0 = 89206 >> Runtime for poller module 'netstats': 1.3076 seconds with 4176 bytes >> SNMP: [7/1.30s] 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] Exitcode: 2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemProcesses.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemNumUsers.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemProcesses.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemNumUsers.0 >> Runtime for poller module 'hr-mib': 0.0518 seconds with 1640 bytes >> SNMP: [1/0.05s] MySQL: [0/0.00s] #### Unload poller module hr-mib #### Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m] 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] Exitcode: 2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.1 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.3 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.1 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.3 >> Runtime for poller module 'ucd-mib': 0.1306 seconds with 1936 bytes >> SNMP: [2/0.13s] MySQL: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsIPVersion.ipv6.0 = unknown ipSystemStatsInReceives.ipv6.0 = 0 ipSystemStatsHCInReceives.ipv6.0 = 0 ipSystemStatsInOctets.ipv6.0 = 0 ipSystemStatsHCInOctets.ipv6.0 = 0 ipSystemStatsInHdrErrors.ipv6.0 = 0 ipSystemStatsInNoRoutes.ipv6.0 = 0 ipSystemStatsInAddrErrors.ipv6.0 = 0 ipSystemStatsInUnknownProtos.ipv6.0 = 0 ipSystemStatsInTruncatedPkts.ipv6.0 = 0 ipSystemStatsInForwDatagrams.ipv6.0 = 0 ipSystemStatsHCInForwDatagrams.ipv6.0 = 0 ipSystemStatsReasmReqds.ipv6.0 = 0 ipSystemStatsReasmOKs.ipv6.0 = 0 ipSystemStatsReasmFails.ipv6.0 = 0 ipSystemStatsInDiscards.ipv6.0 = 0 ipSystemStatsInDelivers.ipv6.0 = 0 ipSystemStatsHCInDelivers.ipv6.0 = 0 ipSystemStatsOutRequests.ipv6.0 = 0 ipSystemStatsHCOutRequests.ipv6.0 = 0 ipSystemStatsOutNoRoutes.ipv6.0 = 0 ipSystemStatsOutForwDatagrams.ipv6.0 = 0 ipSystemStatsHCOutForwDatagrams.ipv6.0 = 0 ipSystemStatsOutDiscards.ipv6.0 = 0 ipSystemStatsOutFragReqds.ipv6.0 = 0 ipSystemStatsOutFragOKs.ipv6.0 = 0 ipSystemStatsOutFragFails.ipv6.0 = 0 ipSystemStatsOutFragCreates.ipv6.0 = 0 ipSystemStatsOutTransmits.ipv6.0 = 0 ipSystemStatsHCOutTransmits.ipv6.0 = 0 ipSystemStatsOutOctets.ipv6.0 = 0 ipSystemStatsHCOutOctets.ipv6.0 = 0 ipSystemStatsInMcastPkts.ipv6.0 = 0 ipSystemStatsHCInMcastPkts.ipv6.0 = 0 ipSystemStatsInMcastOctets.ipv6.0 = 0 ipSystemStatsHCInMcastOctets.ipv6.0 = 0 ipSystemStatsOutMcastPkts.ipv6.0 = 0 ipSystemStatsHCOutMcastPkts.ipv6.0 = 0 ipSystemStatsOutMcastOctets.ipv6.0 = 0 ipSystemStatsHCOutMcastOctets.ipv6.0 = 0 ipSystemStatsInBcastPkts.ipv6.0 = 0 ipSystemStatsHCInBcastPkts.ipv6.0 = 0 ipSystemStatsOutBcastPkts.ipv6.0 = 0 ipSystemStatsHCOutBcastPkts.ipv6.0 = 0 ipSystemStatsDiscontinuityTime.ipv6.0 = 85:5:34:50.03 ipSystemStatsRefreshRate.ipv6.0 = 0 ipv6.0 >> Runtime for poller module 'ipSystemStats': 0.8416 seconds with 17472 bytes >> SNMP: [1/0.84s] 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[24][0m 3.17ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m] SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m] Exitcode: 1 Error: OID not increasing: ifIndex.35600000 >= ifIndex.30010001 ifIndex.0 = 0 ifIndex.1 = 1 ifIndex.2 = 2 ifIndex.1000000 = 1000000 ifIndex.1040000 = 1040000 ifIndex.35600000 = 35600000 ifIndex.30010001 = 30010001 Error: OID not increasing: ifIndex.35600000 >= ifIndex.30010001 dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[24][0m 1.56ms] array ( 0 => array ( 'ifIndex' => '0', ), 1 => array ( 'ifIndex' => '1', ), 2 => array ( 'ifIndex' => '2', ), 1000000 => array ( 'ifIndex' => '1000000', ), 1040000 => array ( 'ifIndex' => '1040000', ), 35600000 => array ( 'ifIndex' => '35600000', ), 30010001 => array ( 'ifIndex' => '30010001', ), ) 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 SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1620308139,null,1620308139][0m 0.56ms] 0 updated >> Runtime for poller module 'ports': 0.3271 seconds with 40800 bytes >> SNMP: [4/0.31s] MySQL: [1/0.00s] #### 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[24][0m 0.59ms] >> Runtime for poller module 'customoid': 0.0015 seconds with 2112 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[24][0m 0.61ms] >> Runtime for poller module 'bgp-peers': 0.0038 seconds with 15320 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[24][0m 0.51ms] >> Runtime for poller module 'ucd-diskio': 0.0010 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: bintec OS initialized as Generic SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[24][0m 0.99ms] >> Runtime for poller module 'wireless': 0.0034 seconds with 104168 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/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m] array ( ) SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[24][0m 1.09ms] 0 >> Runtime for poller module 'ospf': 0.0591 seconds with 31752 bytes >> SNMP: [1/0.06s] 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[24][0m 0.61ms] >> Runtime for poller module 'entity-physical': 0.0017 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[24][0m 0.43ms] >> 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[24][0m 1.05ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m] Exitcode: 2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: BRIDGE-MIB::dot1dStpProtocolSpecification.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: BRIDGE-MIB::dot1dStpProtocolSpecification.0 >> Runtime for poller module 'stp': 0.0387 seconds with -7552 bytes >> SNMP: [1/0.04s] MySQL: [1/0.00s] #### Unload poller module stp #### Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0003 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.0012 seconds with 24080 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[24][0m 0.8ms] SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[7364088,20.1,4.035,24][0m 5.1ms] Updating 192.168.140.254 Polled in 4.035 seconds ### Start Device Groups ### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[24][0m 1.29ms] SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.26ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[24][0m 0.28ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0032s ### #### 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` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2021-05-06T13:35:39.698311Z","2021-05-06T13:35:39.698311Z",0,1,"13:35:39","13:35:39","13:35:39","13:35:39","[44m%","device",24,"location",15][0m 1.95ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[24][0m 0.54ms] 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[24,24,24,24,24,24,24,24][0m 2.55ms] #### End Alerts #### ./poller.php 192.168.140.254 2021-05-06 15:35:39 - 1 devices polled in 4.261 secs SNMP [20/2.87s]: Get[7/0.35s] Getnext[4/0.15s] Walk[9/2.37s] MySQL [22/0.04s]: Cell[2/0.00s] Row[-1/-0.00s] Rows[13/0.02s] Column[1/0.00s] Update[6/0.01s] Insert[1/0.01s] Delete[0/0.00s]