LibreNMS Poller SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.81ms] SQL[select count(*) as aggregate from `migrations` [] 0.58ms] SQL[select version() [] 0.64ms] =========================================== Component | Version --------- | ------- LibreNMS | 23.2.0-17-g2a53c49a5 (2023-03-08T17:23:31-05:00) DB Schema | 2022_09_03_091314_update_ports_adsl_table_with_defaults (248) PHP | 8.1.12 Python | 3.10.6 Database | MariaDB 10.6.12-MariaDB-0ubuntu0.22.04.1 RRDTool | 1.7.2 SNMP | 5.9.1 =========================================== DEBUG! Updating os_def.cache Starting polling run: SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.4.2' ORDER BY `device_id` ASC [] 0.94ms] SQL[select * from `devices` where `device_id` = ? limit 1 [226] 0.47ms] SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [226] 0.28ms] Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic Hostname: 192.168.4.2 Device ID: 226 OS: generic [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '60' '-t' '60' '-O' '0' '192.168.4.2' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.36/0.367/0.377 SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.20916 SQL[insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [0.36,0.377,0.367,3,3,0,"{\"poller_name\":\"sctc-librenms\"}",226,"2023-03-09 15:27:49"] 1.51ms] SQL[update `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0.367,226] 1.13ms] SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [226] 0.95ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'] .*.*.0 = 335353 SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'] SNMP-FRAMEWORK-MIB::snmpEngineTime.0.0 = No Such Object available on this agent at this OID HOST-RESOURCES-MIB::hrSystemUptime.0.0 = No Such Object available on this agent at this OID Uptime seconds: 3354 Uptime: 55 minutes 54 seconds SQL[update `devices` set `uptime` = ? where `device_id` = ? [3354,226] 1.48ms] >> Runtime for poller module 'core': 0.1041 seconds with 180168 bytes >> SNMP: [2/0.10s] MySQL: [1/0.01s] #### Unload poller module core #### Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( SQL[select * from `locations` where `locations`.`id` = ? limit 1 [21] 0.65ms] Location: Mechanical Room Hardware: OS Version: OS Features: Serial: >> Runtime for poller module 'os': 0.0060 seconds with 120488 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[SELECT duration FROM availability WHERE device_id = ? [226] 0.9ms] Availability: SQL[SELECT * FROM availability WHERE device_id = ? [226] 0.77ms] SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [226,1678307270] 0.93ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,897] 0.51ms] 1 day : 100% SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [226,1677788870] 0.76ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,898] 0.52ms] 1 week : 100% SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [226,1675801670] 0.76ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,899] 0.52ms] 1 month : 100% SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [226,1646857670] 0.77ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,900] 0.5ms] 1 year : 100% >> Runtime for poller module 'availability': 0.0138 seconds with 18840 bytes >> SNMP: [0/0.00s] MySQL: [10/0.07s] #### Unload poller module availability #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [226] 1.11ms] array ( ) >> Runtime for poller module 'ipmi': 0.0021 seconds with 1984 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module ipmi #### Modules status: Global+ OS Device #### Load poller module sensors #### SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [226] 0.83ms] >> Runtime for poller module 'sensors': 0.0014 seconds with 992 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic SQL[SELECT * FROM processors WHERE device_id=? [226] 0.8ms] >> Runtime for poller module 'processors': 0.0033 seconds with 59360 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module processors #### Modules status: Global+ OS Device #### Load poller module mempools #### SQL[select * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [226] 0.64ms] >> Runtime for poller module 'mempools': 0.0031 seconds with 79824 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[SELECT * FROM storage WHERE device_id = ? [226] 0.79ms] >> Runtime for poller module 'storage': 0.0014 seconds with 1328 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### icmp SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'] IP-MIB::icmpInMsgs.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutMsgs.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInErrors.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutErrors.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInEchos.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutEchos.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInEchoReps.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutEchoReps.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInDestUnreachs.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutDestUnreachs.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInParmProbs.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimeExcds.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInSrcQuenchs.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInRedirects.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimestamps.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInTimestampReps.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInAddrMasks.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpInAddrMaskReps.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimeExcds.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutParmProbs.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutSrcQuenchs.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutRedirects.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimestamps.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutTimestampReps.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutAddrMasks.0.0 = No Such Object available on this agent at this OID IP-MIB::icmpOutAddrMaskReps.0.0 = No Such Object available on this agent at this OID ip SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'] IP-MIB::ipForwDatagrams.0.0 = No Such Object available on this agent at this OID IP-MIB::ipInDelivers.0.0 = No Such Object available on this agent at this OID IP-MIB::ipInReceives.0.0 = No Such Object available on this agent at this OID IP-MIB::ipOutRequests.0.0 = No Such Object available on this agent at this OID IP-MIB::ipInDiscards.0.0 = No Such Object available on this agent at this OID IP-MIB::ipOutDiscards.0.0 = No Such Object available on this agent at this OID IP-MIB::ipOutNoRoutes.0.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmReqds.0.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmOKs.0.0 = No Such Object available on this agent at this OID IP-MIB::ipReasmFails.0.0 = No Such Object available on this agent at this OID IP-MIB::ipFragOKs.0.0 = No Such Object available on this agent at this OID IP-MIB::ipFragFails.0.0 = No Such Object available on this agent at this OID IP-MIB::ipFragCreates.0.0 = No Such Object available on this agent at this OID IP-MIB::ipInUnknownProtos.0.0 = No Such Object available on this agent at this OID IP-MIB::ipInHdrErrors.0.0 = No Such Object available on this agent at this OID IP-MIB::ipInAddrErrors.0.0 = No Such Object available on this agent at this OID ip_forward SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'] IP-FORWARD-MIB::ipCidrRouteNumber.0.0 = No Such Object available on this agent at this OID snmp SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'] Exitcode: 1 ["Timeout: No Response from udp:192.168.4.2:161.\n"] Timeout: No Response from udp:192.168.4.2:161. udp SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'] UDP-MIB::udpInDatagrams.0.0 = No Such Object available on this agent at this OID UDP-MIB::udpOutDatagrams.0.0 = No Such Object available on this agent at this OID UDP-MIB::udpInErrors.0.0 = No Such Object available on this agent at this OID UDP-MIB::udpNoPorts.0.0 = No Such Object available on this agent at this OID tcp SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'] TCP-MIB::tcpActiveOpens.0.0 = No Such Object available on this agent at this OID TCP-MIB::tcpPassiveOpens.0.0 = No Such Object available on this agent at this OID TCP-MIB::tcpAttemptFails.0.0 = No Such Object available on this agent at this OID TCP-MIB::tcpEstabResets.0.0 = No Such Object available on this agent at this OID TCP-MIB::tcpCurrEstab.0.0 = No Such Object available on this agent at this OID TCP-MIB::tcpInSegs.0.0 = No Such Object available on this agent at this OID TCP-MIB::tcpOutSegs.0.0 = No Such Object available on this agent at this OID TCP-MIB::tcpRetransSegs.0.0 = No Such Object available on this agent at this OID TCP-MIB::tcpInErrs.0.0 = No Such Object available on this agent at this OID TCP-MIB::tcpOutRsts.0.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'netstats': 6.3169 seconds with 23520 bytes >> SNMP: [6/6.31s] MySQL: [0/0.00s] #### Unload poller module netstats #### Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'] hrSystemMaxProcesses.0.0 = No Such Object available on this agent at this OID hrSystemProcesses.0.0 = No Such Object available on this agent at this OID hrSystemNumUsers.0.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'hr-mib': 0.0510 seconds with 544 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['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'] systemStats.0 = No Such Object available on this agent at this OID Invalid snmp_walk() data = systemStats.0 = No Such Object available on this agent at this OID SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'] laLoadInt.1.0 = No Such Object available on this agent at this OID laLoadInt.2.0 = No Such Object available on this agent at this OID laLoadInt.3.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'ucd-mib': 0.1013 seconds with 32 bytes >> SNMP: [2/0.10s] MySQL: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'] ipSystemStatsTable.0 = No Such Object available on this agent at this OID Invalid snmp_walk() data = ipSystemStatsTable.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.0619 seconds with 808 bytes >> SNMP: [1/0.06s] MySQL: [0/0.00s] #### Unload poller module ipSystemStats #### Modules status: Global+ OS Device #### Load poller module ports #### SQL[SELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [226] 2.83ms] Caching Oids: Full ports polling Reporting disabled by user setting SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'] ifXEntry.0 = No Such Object available on this agent at this OID Invalid snmp_walk() data = ifXEntry.0 = No Such Object available on this agent at this OID SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'] ifEntry.0 = No Such Object available on this agent at this OID Invalid snmp_walk() data = ifEntry.0 = No Such Object available on this agent at this OID dot3StatsDuplexStatus SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'] dot3StatsDuplexStatus.0 = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot3StatsDuplexStatus.0 = No Such Object available on this agent at this OID SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'] dot1qPvid.0 = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot1qPvid.0 = No Such Object available on this agent at this OID array ( ) SQL[update `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [1678393676,null,1678393676] 0.85ms] 0 updated >> Runtime for poller module 'ports': 0.2458 seconds with 35512 bytes >> SNMP: [4/0.23s] MySQL: [2/0.04s] #### Unload poller module ports #### Modules status: Global- OS Device Module [ xdsl ] disabled globally. Modules status: Global+ OS Device #### Load poller module customoid #### SQL[SELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [226] 0.74ms] >> Runtime for poller module 'customoid': 0.0019 seconds with 1784 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module customoid #### Modules status: Global+ OS Device #### Load poller module bgp-peers #### SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [226] 0.75ms] >> Runtime for poller module 'bgp-peers': 0.0048 seconds with 13448 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module bgp-peers #### Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = ? [226] 0.54ms] >> Runtime for poller module 'ucd-diskio': 0.0014 seconds with 1208 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module ucd-diskio #### Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [226] 0.93ms] >> Runtime for poller module 'wireless': 0.0044 seconds with 170264 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module wireless #### Modules status: Global+ OS Device #### Load poller module ospf #### SQL[select * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [226] 0.59ms] Processes: SNMP['/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'] ospfGeneralGroup.0 = No Such Object available on this agent at this OID SQL[delete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [226,""] 0.94ms] 0 >> Runtime for poller module 'ospf': 0.0657 seconds with 100776 bytes >> SNMP: [1/0.06s] MySQL: [2/0.02s] #### Unload poller module ospf #### Modules status: Global- OS Device Module [ isis ] disabled globally. Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ slas ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-qfp ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ nac ] disabled globally. Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally. Modules status: Global- OS Device Module [ aruba-controller ] disabled globally. Modules status: Global+ OS Device #### Load poller module entity-physical #### >> Runtime for poller module 'entity-physical': 0.0004 seconds with 392 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module entity-physical #### Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[select * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null [226] 1.04ms] >> Runtime for poller module 'applications': 0.0031 seconds with 28360 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] #### Unload poller module applications #### Modules status: Global+ OS Device #### Load poller module stp #### Instances: SQL[select * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [226] 0.67ms] Ports: SQL[select * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [226] 0.57ms] >> Runtime for poller module 'stp': 0.0052 seconds with 84616 bytes >> SNMP: [0/0.00s] MySQL: [2/0.01s] #### Unload poller module stp #### Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0003 seconds with 320 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.0011 seconds with 36712 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module mpls #### Enabling graphs: SQL[select * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [226] 0.76ms] SQL[UPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [7.259,226] 1.29ms] Updating 192.168.4.2 Polled in 7.259 seconds ### Start Device Groups ### SQL[select * from `device_groups` [] 0.68ms] SQL[select `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) [] 2.29ms] SQL[select exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ?) and `devices`.`device_id` = ?) as `exists` ["192.168.35.%",226] 1.14ms] SQL[select exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` ["10.1.80%","%.1",226] 0.87ms] SQL[select exists(select * from `devices` where (`devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` ["%HALO%",226] 0.75ms] SQL[select exists(select * from `devices` where (`devices`.`hardware` = ?) and `devices`.`device_id` = ?) as `exists` ["eDIC32",226] 0.73ms] SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [226] 0.52ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0363s ### #### Start Alerts #### SQL[select `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [226] 0.6ms] SQL[select exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`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 `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` ["2023-03-09T20:27:57.050546Z","2023-03-09T20:27:57.050546Z",0,1,"20:27:57","20:27:57","20:27:57","20:27:57","%","device",226,"location",21] 1.76ms] SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [226] 1.02ms] SQL[SELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?) LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?)) LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?)) LEFT JOIN 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)) ) [226,226,226,226,226,226,226,226,226,226,226] 2.96ms] #### End Alerts #### /opt/librenms/poller.php 192.168.4.2 2023-03-09 15:27:57 - 1 devices polled in 7.751 secs SNMP [18/6.96s]: Snmpget[11/6.56s] Snmpwalk[7/0.41s] SQL [51/0.47s]: Select[41/0.38s] Insert[1/0.02s] Update[8/0.07s] Delete[1/0.01s]