[1;31mWarning: poller.php is deprecated![0m Use [1mlnms device:poll[0m instead. Override poller modules: unix-agent, core, os, availability, ipmi, sensors, processors, mempools, storage, netstats, hr-mib, ucd-mib, ipSystemStats, ports, xdsl, customoid, bgp-peers, junose-atm-vp, printer-supplies, ucd-diskio, vminfo, wifi, wireless, ospf, isis, cisco-ipsec-flow-monitor, cisco-remote-access-monitor, cisco-cef, slas, cisco-mac-accounting, cipsec-tunnels, cisco-ace-loadbalancer, cisco-ace-serverfarms, cisco-asa-firewall, cisco-voice, cisco-cbqos, cisco-otv, cisco-qfp, cisco-vpdn, nac, netscaler-vsvr, aruba-controller, entity-physical, entity-state, applications, stp, ntp, loadbalancers, mef, mpls SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.8ms] SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.49ms] SQL[[1;33mselect version() [0;33m[][0m 0.55ms] =========================================== Component | Version --------- | ------- LibreNMS | 24.8.1 (2024-08-22T02:50:00+00:00) DB Schema | 2024_07_19_120719_update_ports_stack_table (296) PHP | 8.1.2-1ubuntu2.18 Python | 3.10.12 Database | MariaDB 10.6.18-MariaDB-0ubuntu0.22.04.1 RRDTool | 1.7.2 SNMP | 5.9.1 =========================================== Updating os_def.cache Starting polling run: SQL[[1;33mselect `device_id` from `devices` where `hostname` = ? [0;33m["10.16.19.70"][0m 0.87ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[13][0m 0.71ms] Hostname: 10.16.19.70 ID: 13 OS: esphome IP: 10.16.19.70 Attempting to initialize OS: esphome OS initialized as Generic (esphome) SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[13][0m 1.04ms] [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '10.16.19.70' response: 10.16.19.70 : xmt/rcv/%loss = 3/3/0%, min/avg/max = 107/113/122 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::org.9999.32 SQL[[1;33mupdate `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? [0;33m["2024-09-27 02:27:21",113,13][0m 0.86ms] 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[13][0m 0.66ms] #### Load poller module core #### Module enabled: Global + | OS | Device | Manual SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m] .*.*.0 = 0 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '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 = 9038168 Uptime seconds: 90382 Uptime: 1 day 1 hour 6 minutes 22 seconds SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[90382,13][0m 0.71ms] >> [0;36mSNMP[0m: [3/0.35s] [1;33mMySQL[0m: [4/0.03s] >> Runtime for poller module 'core': 0.3095 seconds with 192648 bytes #### Unload poller module core #### #### Load poller module os #### Module enabled: Global + | OS | Device | Manual SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[3][0m 0.59ms] Location: Living Room Hardware: OS Version: OS Features: Serial: >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] >> Runtime for poller module 'os': 0.0062 seconds with 124272 bytes #### Unload poller module os #### #### Load poller module availability #### Module enabled: Global + | OS | Device | Manual SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[13,1727317641][0m 0.59ms] SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[13,86400][0m 0.47ms] SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,49][0m 0.43ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[13,1726799241][0m 0.48ms] SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[13,604800][0m 0.46ms] SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,50][0m 0.36ms] 1 week : 100% SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[13,1724812041][0m 0.48ms] SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[13,2592000][0m 0.44ms] SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,51][0m 0.36ms] 1 month : 100% SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[13,1695868041][0m 0.48ms] SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[13,31536000][0m 0.45ms] SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,52][0m 0.36ms] 1 year : 100% SQL[[1;33mdelete from `availability` where `availability`.`device_id` = ? and `availability`.`device_id` is not null and `availability_id` not in (?, ?, ?, ?) [0;33m[13,49,50,51,52][0m 0.42ms] >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [13/0.06s] >> Runtime for poller module 'availability': 0.0145 seconds with 71240 bytes #### Unload poller module availability #### #### Load poller module sensors #### Module enabled: Global + | OS + | Device | Manual SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[13][0m 0.55ms] >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] >> Runtime for poller module 'sensors': 0.0017 seconds with 1960 bytes #### Unload poller module sensors #### #### Load poller module storage #### Module enabled: Global + | OS | Device | Manual SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[13][0m 0.6ms] Storage FLASH: hrstorage SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m] hrStorageIndex.1 = 1 hrStorageIndex.2 = 2 hrStorageDescr.1 = FLASH hrStorageDescr.2 = SPI RAM hrStorageAllocationUnits.1 = 1 hrStorageAllocationUnits.2 = 1 hrStorageSize.1 = 4194304 hrStorageSize.2 = 0 hrStorageUsed.1 = 922048 hrStorageUsed.2 = 0 array ( 'hrstorage' => array ( 1 => array ( 'hrStorageIndex' => '1', 'hrStorageDescr' => 'FLASH', 'hrStorageAllocationUnits' => '1', 'hrStorageSize' => '4194304', 'hrStorageUsed' => '922048', ), 2 => array ( 'hrStorageIndex' => '2', 'hrStorageDescr' => 'SPI RAM', 'hrStorageAllocationUnits' => '1', 'hrStorageSize' => '0', 'hrStorageUsed' => '0', ), ), ) array ( 'storage_id' => 25, 'device_id' => 13, 'storage_mib' => 'hrstorage', 'storage_index' => '1', 'storage_type' => NULL, 'storage_descr' => 'FLASH', 'storage_size' => 4194304, 'storage_units' => 1, 'storage_used' => 922048, 'storage_free' => 3272256, 'storage_perc' => 22, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '1', 'used' => 922048, 'size' => 4194304, 'free' => 3272256, ) 22% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["922048","3272256","4194304",1,22,25][0m 0.75ms] >> [0;36mSNMP[0m: [1/1.68s] [1;33mMySQL[0m: [2/0.01s] >> Runtime for poller module 'storage': 1.6794 seconds with 54792 bytes #### Unload poller module storage #### SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[13][0m 0.71ms] Enabled graphs (5): uptime poller_modules_perf availability poller_perf ping_perf SQL[[1;33mupdate `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? [0;33m["2024-09-27 02:27:23",3.268385171890259,13][0m 1.91ms] #### 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[13][0m 0.7ms] 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 `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["2024-09-27T02:27:23.169008Z","2024-09-27T02:27:23.169008Z",0,1,"02:27:23","02:27:23","02:27:23","02:27:23","[45m%","device",13,"location",3][0m 1.1ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[13][0m 0.68ms] 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[13,13,13,13,13,13,13,13,13,13,13][0m 2.1ms] #### End Alerts (0.0163s) #### ### Start Device Groups ### SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.41ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[13][0m 0.45ms] Groups Added: Removed: ### End Device Groups (0.0022s) ### >>> Polled 10.16.19.70 (13) in 3.268 seconds <<< [0;36mSNMP[0m [4/2.03s]: Snmpget[3/0.35s] Snmpwalk[1/1.68s] [1;33mSQL[0m [35/0.24s]: Select[26/0.18s] Update[8/0.06s] Delete[1/0.00s]