From root, 2 Years ago, written in Plain Text.
Embed
  1. LibreNMS Poller
  2. ===================================
  3. Version info:
  4. Commit SHA: e3d44c54d2493a842d4ddf1c2f57e7080f8a8011
  5. Commit Date: 1520882871
  6. DB Schema: 240
  7. PHP: 7.0.19-1
  8. MySQL: 10.1.26-MariaDB-0+deb9u1
  9. RRDTool: 1.6.0
  10. SNMP: NET-SNMP 5.7.3
  11. ==================================DEBUG!
  12. Updating os_def.cache... Done
  13. Starting polling run:
  14.  
  15. SQL[[0;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = 53 ORDER BY `device_id` ASC[0m]
  16. SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '53'[0m]
  17. Hostname: 192.168.120.142
  18. Device ID: 53
  19. OS: ping
  20.  
  21. SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','0.99','1.52','1.17','53',NOW())[0m]
  22. ### Start Device Groups ###
  23. SQL[[0;33mSELECT * FROM device_groups ORDER BY name[0m]
  24. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='53'[0m]
  25. Groups Added:
  26. Groups Removed:
  27. ### End Device Groups ###
  28. SQL[[0;33mSELECT `graph` FROM `device_graphs` WHERE `device_id` = '53'[0m]
  29.  
  30. RRD[[0;32mupdate /opt/librenms/rrd/192.168.120.142/ping-perf.rrd N:1.17[0m]
  31. [[0;31mRRD Disabled[0m]RRD[[0;32mupdate /opt/librenms/rrd/192.168.120.142/poller-perf.rrd N:1.01[0m]
  32. [[0;31mRRD Disabled[0m]Polled in 1.01 seconds
  33. Updating 192.168.120.142
  34. SQL[[0;33mUPDATE `devices` set `last_ping` =NOW(),`last_ping_timetaken` ='1.17',`last_polled` =NOW(),`last_polled_timetaken` ='1.01' WHERE `device_id` = '53'[0m]
  35. UPDATED!
  36. #### Start Alerts ####
  37. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='53'[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 = '53' ) && ((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 `device_group_id` FROM `device_group_device` WHERE `device_id`='53'[0m]
  40. SQL[[0;33mSELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE alert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = '53' ) || alert_map.target = '53'  )[0m]
  41. #### End Alerts ####
  42. SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','53','1520886611.3101','1.204','1','libreNMS')[0m]
  43. ./poller.php 53 2018-03-12 15:30:12 - 1 devices polled in 1.204 secs
  44. SNMP [0/0.00s]: Get[0/0.00s] Getnext[0/0.00s] Walk[0/0.00s]
  45. MySQL [16/0.01s]: Cell[3/0.00s] Row[0/-0.00s] Rows[7/0.00s] Column[3/0.00s] Update[1/0.01s] Insert[2/0.01s] Delete[0/0.00s]
  46. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  47.