1. LibreNMS Poller
2. SQL[[0;33mSELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1[0m]
3. SQL[[0;33mSELECT version()[0m]
4. ===================================
5. Version info:
6. Commit SHA: 703e90fbc21de2eb1d9f1445b202346d47b747e3
7. Commit Date: 1533413232
8. DB Schema: 257
9. PHP: 7.0.30-0ubuntu0.16.04.1
10. MySQL: 10.0.34-MariaDB-0ubuntu0.16.04.1
11. RRDTool: 1.5.5
12. SNMP: NET-SNMP 5.7.3
13. ==================================DEBUG!
14. Updating os_def.cache... Done
15. Starting polling run:
16.  
17. SQL[[0;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'switch6' ORDER BY `device_id` ASC[0m]
18. SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '43'[0m]
19. Hostname: switch6
20. Device ID: 43
21. OS: ciscosb
22.  
23. SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','1.86','2.98','2.51','43',NOW())[0m]
24. ### Start Device Groups ###
25. SQL[[0;33mSELECT * FROM device_groups ORDER BY name[0m]
26. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='43'[0m]
27. Groups Added:
28. Groups Removed:
29. ### End Device Groups ###
30. RRD[[0;32mupdate /opt/librenms/rrd/switch6/ping-perf.rrd N:2.51[0m]
31. [[0;31mRRD Disabled[0m]RRD[[0;32mupdate /opt/librenms/rrd/switch6/poller-perf.rrd N:1.17[0m]
32. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `devices` set `last_ping` =NOW(),`last_ping_timetaken` ='2.51',`last_polled` =NOW(),`last_polled_timetaken` ='1.17' WHERE `device_id` = '43'[0m]
33. Updating switch6
34.  
35. Polled in 1.17 seconds
36. #### Start Alerts ####
37. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='43'[0m]
38. SQL[[0;33mSELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '43' ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '[1;33m-[0;35m-%d') AND (end_recurring_dt >= date_format(NOW(), '[1;33m-[0;35m-%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), '[0;37m'),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1[0m]
39. SQL[[0;33mSELECT DISTINCT a.* FROM alert_rules a  LEFT JOIN alert_device_map d ON a.id=d.rule_id  LEFT JOIN alert_group_map g ON a.id=g.rule_id  LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id  WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id='43' OR dg.device_id='43')[0m]
40. Rule [0;35m#2 (Device rebooted):[0m
41. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '2' && device_id = '43' ORDER BY id DESC LIMIT 1[0m]
42. SQL[[0;33mSELECT * FROM devices WHERE (devices.device_id = '43') && (devices.uptime < "300"  &&  ((devices.disabled = 0  &&  devices.ignore = 0)) = "1")[0m]
43. Status: [0;34mNOCHG[0m
44. Rule [0;35m#12 (State Sensor Critical):[0m
45. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '12' && device_id = '43' ORDER BY id DESC LIMIT 1[0m]
46. SQL[[0;33mSELECT * FROM sensors,state_translations,sensors_to_state_indexes WHERE (( state_translations.state_index_id = sensors_to_state_indexes.state_index_id && sensors_to_state_indexes.sensor_id = sensors.sensor_id && sensors.device_id = sensors.device_id ) && sensors.device_id = '43') && ((sensors.sensor_current = state_translations.state_value  &&  state_translations.state_generic_value = 2))[0m]
47. Status: [0;34mNOCHG[0m
48. #### End Alerts ####
49. SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','switch6','1535051057.4445','1.355','1','home-ct-librenms')[0m]
50. ./poller.php switch6 2018-08-23 21:04:18 - 1 devices polled in 1.355 secs
51. MySQL [18/0.30s]: Cell[3/0.00s] Row[2/0.00s] Rows[8/0.00s] Column[2/0.00s] Update[1/0.05s] Insert[2/0.24s] Delete[0/0.00s]
52.