LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.46ms] SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.42ms] SQL[[1;33mselect version() [0;33m[][0m 1.84ms] =========================================== Component | Version --------- | ------- LibreNMS | 22.10.0 (2022-10-22T02:25:22-05:00) DB Schema | 2022_09_03_091314_update_ports_adsl_table_with_defaults (246) PHP | 8.0.24 Python | 3.10.5 Database | MariaDB 10.9.3-MariaDB-1:10.9.3+maria~ubu2204 RRDTool | 1.7.2 SNMP | 5.9.3 =========================================== DEBUG! Updating os_def.cache Reporting disabled by user setting Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.100.1' ORDER BY `device_id` ASC [0;33m[][0m 2.81ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[12][0m 1.37ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[12][0m 1.11ms] Attempting to initialize OS: linux Attempting to initialize Group OS: unix OS initialized: LibreNMS\OS\Shared\Unix Hostname: 192.168.100.1 Device ID: 12 OS: linux (unix) [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '192.168.100.1' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.585/0.638/0.664 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = NET-SNMP-MIB::netSnmpAgentOIDs.10 SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.585,0.664,0.638,3,3,0,12,"2022-11-07 07:41:35"][0m 4.01ms] SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[0.638,12][0m 3.51ms] SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[12][0m 1.5ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m] .*.*.0 = Linux UDM-SE 4.19.152-ui-alpine #4.19.152 SMP Mon Aug 1 14:24:56 CST 2022 aarch64 .*.*.0 = .*.4.1.8* .*.*.0 = 50048552 .*.*.0 = UDM-SE SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = No Such Object available on this agent at this OID HOST-RESOURCES-MIB::hrSystemUptime.0 = 505619155 Uptime seconds: 5056192 Uptime: 58 days 12 hours 29 minutes 52 seconds SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[5056192,12][0m 4.55ms] >> Runtime for poller module 'core': 0.1532 seconds with 6272 bytes >> [0;36mSNMP[0m: [2/0.14s] [1;33mMySQL[0m: [1/0.05s] #### Unload poller module core #### Modules status: Global+ OS Device #### Load poller module unix-agent #### LibreNMS UNIX Agent: SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["192.168.100.1"][0m 1.62ms] Connection to UNIX agent failed on port 6556. >> Runtime for poller module 'unix-agent': 0.0056 seconds with 6808 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.02s] #### Unload poller module unix-agent #### Modules status: Global+ OS Device #### Load poller module os #### Generic :( SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[1][0m 1.21ms] Location: Jon's Office Hardware: Generic ARMv8 64-bit OS Version: 4.19.152-ui-alpine OS Features: Serial: >> Runtime for poller module 'os': 0.0102 seconds with 139008 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[12][0m 2.67ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[12][0m 1.49ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[12,1667742096][0m 1.36ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,41][0m 1.08ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[12,1667223696][0m 1.28ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,42][0m 0.91ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[12,1665236496][0m 1.22ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,43][0m 0.95ms] 30 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[12,1636292496][0m 1.25ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,44][0m 0.89ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0221 seconds with 9640 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.13s] #### Unload poller module availability #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[12][0m 1.23ms] array ( ) >> Runtime for poller module 'ipmi': 0.0032 seconds with 592 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### 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[12][0m 1.16ms] >> Runtime for poller module 'sensors': 0.0020 seconds with 696 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: linux Attempting to initialize Group OS: unix OS initialized: LibreNMS\OS\Shared\Unix SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[12][0m 0.93ms] >> Runtime for poller module 'processors': 0.0064 seconds with 3248 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### 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[12][0m 1ms] >> Runtime for poller module 'mempools': 0.0061 seconds with 26368 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[12][0m 0.95ms] >> Runtime for poller module 'storage': 0.0018 seconds with 584 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m] IP-MIB::icmpInMsgs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutMsgs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInErrors.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutErrors.0 = No Such Object available on this agent at this OID IP-MIB::icmpInEchos.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutEchos.0 = No Such Object available on this agent at this OID IP-MIB::icmpInEchoReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutEchoReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpInDestUnreachs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutDestUnreachs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInParmProbs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimeExcds.0 = No Such Object available on this agent at this OID IP-MIB::icmpInSrcQuenchs.0 = No Such Object available on this agent at this OID IP-MIB::icmpInRedirects.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimestamps.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimestampReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpInAddrMasks.0 = No Such Object available on this agent at this OID IP-MIB::icmpInAddrMaskReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimeExcds.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutParmProbs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutSrcQuenchs.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutRedirects.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimestamps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimestampReps.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutAddrMasks.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutAddrMaskReps.0 = No Such Object available on this agent at this OID ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m] IP-MIB::ipForwDatagrams.0 = No Such Object available on this agent at this OID IP-MIB::ipInDelivers.0 = No Such Object available on this agent at this OID IP-MIB::ipInReceives.0 = No Such Object available on this agent at this OID IP-MIB::ipOutRequests.0 = No Such Object available on this agent at this OID IP-MIB::ipInDiscards.0 = No Such Object available on this agent at this OID IP-MIB::ipOutDiscards.0 = No Such Object available on this agent at this OID IP-MIB::ipOutNoRoutes.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmReqds.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmOKs.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmFails.0 = No Such Object available on this agent at this OID IP-MIB::ipFragOKs.0 = No Such Object available on this agent at this OID IP-MIB::ipFragFails.0 = No Such Object available on this agent at this OID IP-MIB::ipFragCreates.0 = No Such Object available on this agent at this OID IP-MIB::ipInUnknownProtos.0 = No Such Object available on this agent at this OID IP-MIB::ipInHdrErrors.0 = No Such Object available on this agent at this OID IP-MIB::ipInAddrErrors.0 = No Such Object available on this agent at this OID ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m] SNMPv2-MIB::snmpInPkts.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutPkts.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInBadVersions.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInBadCommunityNames.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInBadCommunityUses.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInASNParseErrs.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInTooBigs.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInNoSuchNames.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInBadValues.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInReadOnlys.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInGenErrs.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInTotalReqVars.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInTotalSetVars.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInGetRequests.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInGetNexts.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInSetRequests.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInGetResponses.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpInTraps.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutTooBigs.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutNoSuchNames.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutBadValues.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutGenErrs.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutGetRequests.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutGetNexts.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutSetRequests.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutGetResponses.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpOutTraps.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpSilentDrops.0 = No Such Object available on this agent at this OID SNMPv2-MIB::snmpProxyDrops.0 = No Such Object available on this agent at this OID udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m] UDP-MIB::udpInDatagrams.0 = No Such Object available on this agent at this OID UDP-MIB::udpOutDatagrams.0 = No Such Object available on this agent at this OID UDP-MIB::udpInErrors.0 = No Such Object available on this agent at this OID UDP-MIB::udpNoPorts.0 = No Such Object available on this agent at this OID tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m] TCP-MIB::tcpActiveOpens.0 = No Such Object available on this agent at this OID TCP-MIB::tcpPassiveOpens.0 = No Such Object available on this agent at this OID TCP-MIB::tcpAttemptFails.0 = No Such Object available on this agent at this OID TCP-MIB::tcpEstabResets.0 = No Such Object available on this agent at this OID TCP-MIB::tcpCurrEstab.0 = No Such Object available on this agent at this OID TCP-MIB::tcpInSegs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpOutSegs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpRetransSegs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpInErrs.0 = No Such Object available on this agent at this OID TCP-MIB::tcpOutRsts.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'netstats': 0.4462 seconds with 1928 bytes >> [0;36mSNMP[0m: [6/0.44s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module netstats #### Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] hrSystemMaxProcesses.0 = 0 hrSystemProcesses.0 = 192 hrSystemNumUsers.0 = 0 ProcessesSQL[[1;33mselect * from `hrSystem` where (`device_id` = ?) limit 1 [0;33m[12][0m 2.23ms] SQL[[1;33mupdate `hrSystem` set `hrSystemProcesses` = ? where `hrSystem_id` = ? [0;33m["192",5][0m 3.76ms] Users >> Runtime for poller module 'hr-mib': 0.0428 seconds with 28568 bytes >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [2/0.06s] #### Unload poller module hr-mib #### Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m] systemStats = No more variables left in this MIB View (It is past the end of the MIB tree) SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m] laLoadInt.1 = No Such Object available on this agent at this OID laLoadInt.2 = No Such Object available on this agent at this OID laLoadInt.3 = No Such Object available on this agent at this OID >> Runtime for poller module 'ucd-mib': 0.0580 seconds with -928 bytes >> [0;36mSNMP[0m: [2/0.06s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsTable = No Such Object available on this agent at this OID Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.1072 seconds with 56 bytes >> [0;36mSNMP[0m: [1/0.11s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ipSystemStats #### Modules status: Global+ OS Device #### Load poller module ports #### SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[12][0m 3.28ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifXEntry = No more variables left in this MIB View (It is past the end of the MIB tree) SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifEntry = No Such Object available on this agent at this OID Invalid snmp_walk() data = ifEntry = No Such Object available on this agent at this OID dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID array ( ) SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1667828497,null,1667828497][0m 1.72ms] 0 updated >> Runtime for poller module 'ports': 0.1909 seconds with 5768 bytes >> [0;36mSNMP[0m: [4/0.17s] [1;33mMySQL[0m: [2/0.05s] #### Unload poller module ports #### 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[12][0m 1.85ms] >> Runtime for poller module 'customoid': 0.0030 seconds with 1864 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.02s] #### Unload poller module customoid #### 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 #### Load poller module ucd-diskio #### SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[12][0m 1.2ms] >> Runtime for poller module 'ucd-diskio': 0.0023 seconds with 584 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module ucd-diskio #### Modules status: Global+ OS Device #### Load poller module wifi #### >> Runtime for poller module 'wifi': 0.0003 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module wifi #### Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: linux Attempting to initialize Group OS: unix OS initialized: LibreNMS\OS\Shared\Unix SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[12][0m 1.11ms] >> Runtime for poller module 'wireless': 0.0094 seconds with 102296 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module wireless #### 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.0003 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module entity-physical #### Modules status: Global+ OS Device #### Load poller module entity-state #### SQL[[1;33mSELECT S.entity_state_id, S.entStateLastChanged, P.entPhysicalIndex FROM entityState AS S LEFT JOIN entPhysical AS P USING (entPhysical_id) WHERE S.device_id=? [0;33m[12][0m 1.13ms] >> Runtime for poller module 'entity-state': 0.0021 seconds with 584 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module entity-state #### Modules status: Global+ OS Device #### Load poller module applications #### SQL[[1;33mselect * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null [0;33m[12][0m 0.94ms] >> Runtime for poller module 'applications': 0.0034 seconds with 32376 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module applications #### Modules status: Global+ OS- Device Module [ stp ] disabled on os. Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0006 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ntp #### Modules status: Global+ OS Device #### Load poller module loadbalancers #### >> Runtime for poller module 'loadbalancers': 0.0005 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module loadbalancers #### Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device #### Load poller module mpls #### >> Runtime for poller module 'mpls': 0.0016 seconds with 488 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module mpls #### Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[12][0m 1.06ms] SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[2.286,12][0m 3.55ms] Updating 192.168.100.1 Polled in 2.286 seconds ### Start Device Groups ### SQL[[1;33mselect * from `device_groups` [0;33m[][0m 1.1ms] 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, 2, 3) [0;33m[][0m 1.62ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[12][0m 1.18ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0255s ### #### 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[12][0m 1.34ms] 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 (1)) 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-07T13:41:37.177581Z","2022-11-07T13:41:37.177581Z",0,1,"13:41:37","13:41:37","13:41:37","13:41:37","[41m%","device",12,"device_group","location",1][0m 2.78ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[12][0m 1.67ms] 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[12,12,12,12,12,12,12,12,12,12,12][0m 4.21ms] #### End Alerts #### ./poller.php 192.168.100.1 2022-11-07 07:41:37 - 1 devices polled in 2.929 secs [0;36mSNMP[0m [17/1.03s]: Snmpget[11/0.72s] Snmpwalk[6/0.31s] [1;33mSQL[0m [46/0.81s]: Select[36/0.56s] Insert[1/0.04s] Update[9/0.21s]