LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.4ms] SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.25ms] SQL[[1;33mselect version() [0;33m[][0m 0.22ms] =========================================== Component | Version --------- | ------- LibreNMS | 22.10.0 (2022-10-25T09:03:21-07:00) DB Schema | 2022_08_15_084507_add_rrd_type_to_wireless_sensors_table (249) PHP | 8.1.2 Python | 3.10.6 Database | MariaDB 10.6.7-MariaDB-2ubuntu1.1 RRDTool | 1.7.2 SNMP | 5.9.1 =========================================== DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.100.100.188' ORDER BY `device_id` ASC [0;33m[][0m 0.78ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[601][0m 0.55ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[601][0m 0.56ms] Attempting to initialize OS: sentry3 OS initialized as Generic Hostname: 10.100.100.188 Device ID: 601 OS: sentry3 [FPING] '/usr/bin/fping' '-e' '-q' '-c' '2' '-p' '300' '-t' '300' '-O' '0' '10.100.100.188' response: xmt/rcv/%loss = 2/2/0%, min/avg/max = 1.61/1.95/2.28 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.1718.3 SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[1.61,2.28,1.95,2,2,0,601,"2022-11-02 09:09:17"][0m 0.28ms] SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[1.95,601][0m 0.22ms] RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/ping-perf.rrd N:1.95[0m] SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[601][0m 0.36ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m] .*.*.0 = Sentry Remote Power Manager .*.*.0 = .*.4.1.1718.3 .*.*.0 = 4211649855 .*.*.0 = Snile#2 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = No Such Object available on this agent at this OID HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 42116499 RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/uptime.rrd N:42116499[0m] Uptime: 1 year 122 days 11 hours 1 minute 39 seconds SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[42116499,601][0m 0.32ms] >> Runtime for poller module 'core': 0.0463 seconds with 78144 bytes >> [0;36mSNMP[0m: [2/0.04s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module core #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-core.rrd N:0.046265125274658[0m] Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[78][0m 0.32ms] Location: South Nile Hardware: OS Version: 5.3q OS Features: Serial: >> Runtime for poller module 'os': 0.0030 seconds with 186664 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module os #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-os.rrd N:0.0030198097229004[0m] Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[601][0m 0.32ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[601][0m 0.25ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[601,1667318957][0m 1.14ms] RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/availability-86400.rrd N:100[0m] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,2277][0m 0.25ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[601,1666800557][0m 0.29ms] RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/availability-604800.rrd N:100[0m] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,2278][0m 0.25ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[601,1664813357][0m 0.28ms] RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/availability-2592000.rrd N:100[0m] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,2279][0m 0.22ms] 30 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[601,1635869357][0m 0.22ms] RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/availability-31536000.rrd N:100[0m] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,2280][0m 0.18ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0062 seconds with 18696 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.03s] [0;32mRRD[0m: [5/0.00s] #### Unload poller module availability #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-availability.rrd N:0.0061740875244141[0m] Modules status: Global- OS Device Module [ ipmi ] disabled globally. 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[601][0m 0.44ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["current",601][0m 0.34ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQntea' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.1' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.2' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.3' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.4' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.5' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.6' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.1' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.2' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.3' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.4'[0m] .*.4.1.17*.*.1 = 0 .*.4.1.17*.*.2 = 0 .*.4.1.17*.*.3 = 0 .*.4.1.17*.*.4 = 150 .*.4.1.17*.*.5 = 0 .*.4.1.17*.*.6 = 0 .*.4.1.17*.*.1 = 125 .*.4.1.17*.*.2 = 0 .*.4.1.17*.*.3 = 0 .*.4.1.17*.*.4 = 0 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQntea' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.5' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.6'[0m] .*.4.1.17*.*.5 = 0 .*.4.1.17*.*.6 = 0 Checking (snmp) current Outlet AA1... Checking (snmp) current Outlet AA2... Checking (snmp) current Outlet AA3... Checking (snmp) current Outlet AA4... Checking (snmp) current Outlet AA5... Checking (snmp) current Outlet AA6... Checking (snmp) current Outlet AB1... Checking (snmp) current Outlet AB2... Checking (snmp) current Outlet AB3... Checking (snmp) current Outlet AB4... Checking (snmp) current Outlet AB5... Checking (snmp) current Outlet AB6... 0 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.1.rrd N:0[0m] 0 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.2.rrd N:0[0m] 0 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.3.rrd N:0[0m] 1.5 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.4.rrd N:1.5[0m] 0 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.5.rrd N:0[0m] 0 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.6.rrd N:0[0m] 1.25 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.1.rrd N:1.25[0m] 0 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.2.rrd N:0[0m] 0 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.3.rrd N:0[0m] 0 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.4.rrd N:0[0m] 0 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.5.rrd N:0[0m] 0 A RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.6.rrd N:0[0m] >> Runtime for poller module 'sensors': 0.0499 seconds with 1824 bytes >> [0;36mSNMP[0m: [2/0.04s] [1;33mMySQL[0m: [2/0.01s] [0;32mRRD[0m: [13/0.00s] #### Unload poller module sensors #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-sensors.rrd N:0.049906015396118[0m] Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: sentry3 OS initialized as Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[601][0m 0.5ms] >> Runtime for poller module 'processors': 0.0031 seconds with 59360 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module processors #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-processors.rrd N:0.0030829906463623[0m] 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[601][0m 0.41ms] >> Runtime for poller module 'mempools': 0.0028 seconds with 79824 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module mempools #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-mempools.rrd N:0.0028159618377686[0m] Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[601][0m 0.46ms] >> Runtime for poller module 'storage': 0.0011 seconds with 1328 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module storage #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-storage.rrd N:0.0011270046234131[0m] Modules status: Global+ OS Device #### Load poller module netstats #### icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m] IP-MIB::icmpInMsgs.0 = 12378 IP-MIB::icmpOutMsgs.0 = 2942 IP-MIB::icmpInErrors.0 = 0 IP-MIB::icmpOutErrors.0 = 0 IP-MIB::icmpInEchos.0 = 2934 IP-MIB::icmpOutEchos.0 = 0 IP-MIB::icmpInEchoReps.0 = 0 IP-MIB::icmpOutEchoReps.0 = 2934 IP-MIB::icmpInDestUnreachs.0 = 9442 IP-MIB::icmpOutDestUnreachs.0 = 6 IP-MIB::icmpInParmProbs.0 = 0 IP-MIB::icmpInTimeExcds.0 = 0 IP-MIB::icmpInSrcQuenchs.0 = 0 IP-MIB::icmpInRedirects.0 = 0 IP-MIB::icmpInTimestamps.0 = 2 IP-MIB::icmpInTimestampReps.0 = 0 IP-MIB::icmpInAddrMasks.0 = 0 IP-MIB::icmpInAddrMaskReps.0 = 0 IP-MIB::icmpOutTimeExcds.0 = 0 IP-MIB::icmpOutParmProbs.0 = 0 IP-MIB::icmpOutSrcQuenchs.0 = 0 IP-MIB::icmpOutRedirects.0 = 0 IP-MIB::icmpOutTimestamps.0 = 0 IP-MIB::icmpOutTimestampReps.0 = 2 IP-MIB::icmpOutAddrMasks.0 = 0 IP-MIB::icmpOutAddrMaskReps.0 = 0 RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/netstats-icmp.rrd N:12378:2942:0:0:2934:0:0:2934:9442:6:0:0:0:0:2:0:0:0:0:0:0:0:0:2:0:0[0m] ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m] IP-MIB::ipForwDatagrams.0 = 0 IP-MIB::ipInDelivers.0 = 39190507 IP-MIB::ipInReceives.0 = 41462143 IP-MIB::ipOutRequests.0 = 11689127 IP-MIB::ipInDiscards.0 = 0 IP-MIB::ipOutDiscards.0 = 0 IP-MIB::ipOutNoRoutes.0 = 0 IP-MIB::ipReasmReqds.0 = 0 IP-MIB::ipReasmOKs.0 = 0 IP-MIB::ipReasmFails.0 = 0 IP-MIB::ipFragOKs.0 = 0 IP-MIB::ipFragFails.0 = 0 IP-MIB::ipFragCreates.0 = 0 IP-MIB::ipInUnknownProtos.0 = 0 IP-MIB::ipInHdrErrors.0 = 18 IP-MIB::ipInAddrErrors.0 = 2271618 RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/netstats-ip.rrd N:0:39190507:41462143:11689127:0:0:0:0:0:0:0:0:0:0:18:2271618[0m] ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m] SNMPv2-MIB::snmpInPkts.0 = 11685992 SNMPv2-MIB::snmpOutPkts.0 = 11685952 SNMPv2-MIB::snmpInBadVersions.0 = 0 SNMPv2-MIB::snmpInBadCommunityNames.0 = 39 SNMPv2-MIB::snmpInBadCommunityUses.0 = 39 SNMPv2-MIB::snmpInASNParseErrs.0 = 0 SNMPv2-MIB::snmpInTooBigs.0 = 0 SNMPv2-MIB::snmpInNoSuchNames.0 = 0 SNMPv2-MIB::snmpInBadValues.0 = 0 SNMPv2-MIB::snmpInReadOnlys.0 = 0 SNMPv2-MIB::snmpInGenErrs.0 = 0 SNMPv2-MIB::snmpInTotalReqVars.0 = 80421599 SNMPv2-MIB::snmpInTotalSetVars.0 = 0 SNMPv2-MIB::snmpInGetRequests.0 = 5495081 SNMPv2-MIB::snmpInGetNexts.0 = 983560 SNMPv2-MIB::snmpInSetRequests.0 = 0 SNMPv2-MIB::snmpInGetResponses.0 = 0 SNMPv2-MIB::snmpInTraps.0 = 0 SNMPv2-MIB::snmpOutTooBigs.0 = 0 SNMPv2-MIB::snmpOutNoSuchNames.0 = 5353195 SNMPv2-MIB::snmpOutBadValues.0 = 0 SNMPv2-MIB::snmpOutGenErrs.0 = 0 SNMPv2-MIB::snmpOutGetRequests.0 = 0 SNMPv2-MIB::snmpOutGetNexts.0 = 0 SNMPv2-MIB::snmpOutSetRequests.0 = 0 SNMPv2-MIB::snmpOutGetResponses.0 = 11685952 SNMPv2-MIB::snmpOutTraps.0 = 1 SNMPv2-MIB::snmpSilentDrops.0 = 0 SNMPv2-MIB::snmpProxyDrops.0 = 0 RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/netstats-snmp.rrd N:11685992:11685952:0:39:39:0:0:0:0:0:0:80421599:0:5495081:983560:0:0:0:0:5353195:0:0:0:0:0:11685952:1:0:0[0m] udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m] UDP-MIB::udpInDatagrams.0 = 38286721 UDP-MIB::udpOutDatagrams.0 = 11685954 UDP-MIB::udpInErrors.0 = 20297256 UDP-MIB::udpNoPorts.0 = 6303472 RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/netstats-udp.rrd N:38286721:11685954:20297256:6303472[0m] tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m] TCP-MIB::tcpActiveOpens.0 = 0 TCP-MIB::tcpPassiveOpens.0 = 10 TCP-MIB::tcpAttemptFails.0 = 2 TCP-MIB::tcpEstabResets.0 = 0 TCP-MIB::tcpCurrEstab.0 = 0 TCP-MIB::tcpInSegs.0 = 212 TCP-MIB::tcpOutSegs.0 = 234 TCP-MIB::tcpRetransSegs.0 = 0 TCP-MIB::tcpInErrs.0 = 0 TCP-MIB::tcpOutRsts.0 = 5 RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/netstats-tcp.rrd N:0:10:2:0:0:212:234:0:0:5[0m] >> Runtime for poller module 'netstats': 0.2462 seconds with 23320 bytes >> [0;36mSNMP[0m: [6/0.24s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [6/0.00s] #### Unload poller module netstats #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-netstats.rrd N:0.24623084068298[0m] Modules status: Global- OS Device Module [ hr-mib ] disabled globally. Modules status: Global- OS Device Module [ ucd-mib ] disabled globally. 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:/opt/librenms/mibs/sentry' '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.0362 seconds with 968 bytes >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module ipSystemStats #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-ipSystemStats.rrd N:0.036240100860596[0m] 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[601][0m 0.77ms] Caching Oids: Full ports polling Reporting disabled by user setting SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifXEntry = No Such Object available on this agent at this OID Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifIndex.1 = 1 ifIndex.2 = 2 ifDescr.1 = lo ifDescr.2 = eth0 ifType.1 = other ifType.2 = iso88023Csmacd ifMtu.1 = 1500 ifMtu.2 = 1500 ifSpeed.1 = 0 ifSpeed.2 = 100000000 ifPhysAddress.1 = 0 ifPhysAddress.2 = 0:a:9c:10:86:19 ifAdminStatus.1 = up ifAdminStatus.2 = up ifOperStatus.1 = up ifOperStatus.2 = up ifLastChange.1 = 0 ifLastChange.2 = 0 ifInOctets.1 = 0 ifInOctets.2 = 3213957923 ifInUcastPkts.1 = 0 ifInUcastPkts.2 = 11698598 ifInNUcastPkts.1 = 0 ifInNUcastPkts.2 = 1223436876 ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifInErrors.1 = 0 ifInErrors.2 = 0 ifInUnknownProtos.1 = 0 ifInUnknownProtos.2 = 0 ifOutOctets.1 = 0 ifOutOctets.2 = 2288495111 ifOutUcastPkts.1 = 0 ifOutUcastPkts.2 = 11689139 ifOutNUcastPkts.1 = 0 ifOutNUcastPkts.2 = 144802 ifOutDiscards.1 = 0 ifOutDiscards.2 = 0 ifOutErrors.1 = 0 ifOutErrors.2 = 0 ifOutQLen.1 = 0 ifOutQLen.2 = 0 ifSpecific.1 = zeroDotZero ifSpecific.2 = zeroDotZero dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID array ( 1 => array ( 'ifIndex' => '1', 'ifDescr' => 'lo', 'ifType' => 'other', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '0', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 2 => array ( 'ifIndex' => '2', 'ifDescr' => 'eth0', 'ifType' => 'iso88023Csmacd', 'ifMtu' => '1500', 'ifSpeed' => '100000000', 'ifPhysAddress' => '0:a:9c:10:86:19', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '3213957923', 'ifInUcastPkts' => '11698598', 'ifInNUcastPkts' => '1223436876', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '2288495111', 'ifOutUcastPkts' => '11689139', 'ifOutNUcastPkts' => '144802', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), ) valid valid Port lo: lo (1 / #27819) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = ? Using ifDescr as ifAlias Using ifDescr as ifName lo ifInOctets (0 B) 0 Bps 13 secs ifOutOctets (0 B) 0 Bps 13 secs ifInErrors (0 B) 0 Bps 13 secs ifOutErrors (0 B) 0 Bps 13 secs ifInUcastPkts (0 B) 0 Bps 13 secs ifOutUcastPkts (0 B) 0 Bps 13 secs ifInNUcastPkts (0 B) 0 Bps 13 secs ifOutNUcastPkts (0 B) 0 Bps 13 secs ifInDiscards (0 B) 0 Bps 13 secs ifOutDiscards (0 B) 0 Bps 13 secs ifInUnknownProtos (0 B) 0 Bps 13 secs ifInBroadcastPkts (0 B) 0 Bps 13 secs ifOutBroadcastPkts (0 B) 0 Bps 13 secs ifInMulticastPkts (0 B) 0 Bps 13 secs ifOutMulticastPkts (0 B) 0 Bps 13 secs bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD warning: unused data sent ifInUcastPkts_rate RRD warning: unused data sent ifOutUcastPkts_rate RRD warning: unused data sent ifInErrors_rate RRD warning: unused data sent ifOutErrors_rate RRD warning: unused data sent ifInOctets_rate RRD warning: unused data sent ifOutOctets_rate RRD warning: unused data sent ifInBits_rate RRD warning: unused data sent ifOutBits_rate RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/port-id27819.rrd N:0:0:0:0:0:0:0:0:0:0:0:U:U:U:U[0m] SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["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,1667405358,1667405345,13,27819][0m 0.73ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,27819][0m 0.49ms] 1 updated Port eth0: eth0 (2 / #27820) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (100000000) VLAN = ? Using ifDescr as ifAlias Using ifDescr as ifName eth0 ifInOctets (15494 B) 1191.8461538462 Bps 13 secs ifOutOctets (10748 B) 826.76923076923 Bps 13 secs ifInErrors (0 B) 0 Bps 13 secs ifOutErrors (0 B) 0 Bps 13 secs ifInUcastPkts (51 B) 3.9230769230769 Bps 13 secs ifOutUcastPkts (50 B) 3.8461538461538 Bps 13 secs ifInNUcastPkts (125 B) 9.6153846153846 Bps 13 secs ifOutNUcastPkts (0 B) 0 Bps 13 secs ifInDiscards (0 B) 0 Bps 13 secs ifOutDiscards (0 B) 0 Bps 13 secs ifInUnknownProtos (0 B) 0 Bps 13 secs ifInBroadcastPkts (0 B) 0 Bps 13 secs ifOutBroadcastPkts (0 B) 0 Bps 13 secs ifInMulticastPkts (0 B) 0 Bps 13 secs ifOutMulticastPkts (0 B) 0 Bps 13 secs bps(9.54 kbps/6.61 kbps)bytes(15.13 KiB/10.5 KiB)pkts(3.92 pps/3.85 pps)RRD warning: unused data sent ifInUcastPkts_rate RRD warning: unused data sent ifOutUcastPkts_rate RRD warning: unused data sent ifInErrors_rate RRD warning: unused data sent ifOutErrors_rate RRD warning: unused data sent ifInOctets_rate RRD warning: unused data sent ifOutOctets_rate RRD warning: unused data sent ifInBits_rate RRD warning: unused data sent ifOutBits_rate RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/port-id27820.rrd N:3213957923:2288495111:0:0:11698598:11689139:1223436876:144802:0:0:0:U:U:U:U[0m] 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["3213957923",3213942429,1191.8461538461538,15494,"2288495111",2288484363,826.7692307692307,10748,"0",0,0,0,"0",0,0,0,"11698598",11698547,3.923076923076923,51,"11689139",11689089,3.8461538461538463,50,1667405358,1667405345,13,27820][0m 0.52ms] 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["1223436876",1223436751,9.615384615384615,125,"144802",144802,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,27820][0m 0.69ms] 2 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1667405358,1667405345,null][0m 0.22ms] 0 updated >> Runtime for poller module 'ports': 0.2088 seconds with 59096 bytes >> [0;36mSNMP[0m: [4/0.20s] [1;33mMySQL[0m: [6/0.03s] [0;32mRRD[0m: [3/0.00s] #### Unload poller module ports #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-ports.rrd N:0.2087550163269[0m] Modules status: Global- OS Device Module [ xdsl ] disabled globally. Modules status: Global+ OS Device #### Load poller module customoid #### SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[601][0m 0.58ms] >> Runtime for poller module 'customoid': 0.0009 seconds with 1744 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module customoid #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-customoid.rrd N:0.00085306167602539[0m] Modules status: Global- OS- Device Module [ bgp-peers ] disabled on os. 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 Module [ ucd-diskio ] disabled globally. Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global- OS- Device Module [ wireless ] disabled on os. Modules status: Global- OS- Device Module [ ospf ] disabled on os. Modules status: Global- OS Device Module [ isis ] disabled globally. Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ slas ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-qfp ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ nac ] disabled globally. Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally. Modules status: Global- OS Device Module [ aruba-controller ] disabled globally. Modules status: Global+ OS Device #### Load poller module entity-physical #### >> Runtime for poller module 'entity-physical': 0.0001 seconds with 392 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module entity-physical #### RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-entity-physical.rrd N:6.9141387939453E-5[0m] Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global- OS Device Module [ applications ] disabled globally. Modules status: Global- OS- Device Module [ stp ] disabled on os. Modules status: Global- OS Device Module [ ntp ] disabled globally. Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global- OS Device Module [ mpls ] disabled globally. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf.rrd N:0.961[0m] Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[601][0m 0.5ms] SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[0.961,601][0m 0.45ms] Updating 10.100.100.188 Polled in 0.961 seconds ### Start Device Groups ### SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.41ms] 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 (2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) [0;33m[][0m 3.15ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.1916.2.202",601][0m 0.43ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.1916.2.93",601][0m 0.33ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.738.1.5.100.1.1.7",601][0m 0.36ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.1991.1.16.1",601][0m 0.36ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.33.100.1.2.1.11",601][0m 0.35ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.1991.1.3.48.3.1",601][0m 0.34ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["V2224G-OP",601][0m 0.34ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["V2224G",601][0m 0.37ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ? OR `devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.318.1.3.4.5",".1.3.6.1.4.1.318.1.3.4.6",601][0m 0.37ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.33.8.1.%",601][0m 0.35ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.23465",601][0m 0.34ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.39145.10",601][0m 0.34ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.5504.1.2.10.2.2",601][0m 0.34ms] SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `bill_ports` on `ports`.`port_id` = `bill_ports`.`port_id` left join `bills` on `bill_ports`.`bill_id` = `bills`.`bill_id` where (`bills`.`bill_name` != ?) and `devices`.`device_id` = ?) as `exists` [0;33m["",601][0m 0.51ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%.1.3.6.1.4.1.10002.1%",601][0m 0.3ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.14988.1",601][0m 0.27ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.52642.2.1.45.103",601][0m 0.27ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysDescr` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%V2724GG%",601][0m 0.27ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.52642.1.1.10.1.793",601][0m 0.29ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.1916.2.214",601][0m 0.28ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.7309.4",601][0m 0.27ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.534.1",601][0m 0.51ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`inserted` > ?) and `devices`.`device_id` = ?) as `exists` [0;33m["100",601][0m 0.43ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.52642.1.458.0",601][0m 0.39ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[601][0m 0.45ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0324s ### #### Start Alerts #### SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[601][0m 0.58ms] 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(`start`) <= ? or time(`end`) > ?))) 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 `device_groups` inner join `alert_schedulables` on `device_groups`.`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` in (25)) 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["2022-11-02T16:09:18.267353Z","2022-11-02T16:09:18.267353Z",0,1,"16:09:18","16:09:18","16:09:18","16:09:18","[43m%","device",601,"device_group","location",78][0m 1.28ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[601][0m 0.52ms] 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 devices ld ON l.location_id=ld.location_id AND ld.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 AND l.location_id IS NULL) OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.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) AND (ld.device_id != ? OR ld.device_id IS NULL)) ) [0;33m[601,601,601,601,601,601,601,601,601,601,601][0m 2.84ms] Rule [0;35m#2 (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 xss=removed>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 65 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[601][0m 1.17ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,601][0m 0.39ms] Status: [0;34mNOCHG[0m Rule [0;35m#15 (Port utilisation over threshold Warning 80 percent):[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[601][0m 0.81ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,601][0m 0.24ms] Status: [0;34mNOCHG[0m Rule [0;35m#18 (Billing Usage at 2 TB):[0m SQL[[1;33mSELECT * FROM devices,ports,bill_ports,bills WHERE (devices.device_id = ? AND devices.device_id = ports.device_id AND ports.port_id = bill_ports.port_id AND bill_ports.bill_id = bills.bill_id) AND (((bills.total_data / bills.bill_quota)*100 > 40) && bills.bill_type = "quota") = 1 [0;33m[601][0m 0.82ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[18,601][0m 0.24ms] Status: [0;34mNOCHG[0m Rule [0;35m#19 (Billing usage at 4 TB):[0m SQL[[1;33mSELECT * FROM devices,ports,bill_ports,bills WHERE (devices.device_id = ? AND devices.device_id = ports.device_id AND ports.port_id = bill_ports.port_id AND bill_ports.bill_id = bills.bill_id) AND (((bills.total_data / bills.bill_quota)*100 > 80) && bills.bill_type = "quota") = 1 [0;33m[601][0m 0.77ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[19,601][0m 0.24ms] Status: [0;34mNOCHG[0m Rule [0;35m#20 (Billing usage exceeded 5 TB):[0m SQL[[1;33mSELECT * FROM devices,ports,bill_ports,bills WHERE (devices.device_id = ? AND devices.device_id = ports.device_id AND ports.port_id = bill_ports.port_id AND bill_ports.bill_id = bills.bill_id) AND (((bills.total_data / bills.bill_quota)*100 > 100) && bills.bill_type = "quota") = 1 [0;33m[601][0m 0.91ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[20,601][0m 0.53ms] Status: [0;34mNOCHG[0m Rule [0;35m#21 (Blown fuse):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_type LIKE '[5muse%' AND sensors.sensor_alert = "OPEN" [0;33m[601][0m 0.97ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[21,601][0m 0.42ms] Status: [0;34mNOCHG[0m #### End Alerts #### ./poller.php 10.100.100.188 2022-11-02 09:09:18 - 1 devices polled in 1.194 secs [0;36mSNMP[0m [16/0.58s]: Snmpget[11/0.35s] Snmpwalk[5/0.23s] [1;33mSQL[0m [81/0.41s]: Select[68/0.36s] Insert[1/0.00s] Update[12/0.05s] [0;32mRRD[0m [38/0.01s]: Update[38/0.01s]