From Kedearian, 1 Year ago, written in Plain Text.
Embed
  1. LibreNMS Poller
  2. ===================================
  3. Version info:
  4. Commit SHA: f7aed1e2036b20c12d8eaf58aaba2adb6aebc026
  5. Commit Date: 1512569071
  6. DB Schema: 221
  7. PHP: 7.0.25
  8. MySQL: 5.5.56-MariaDB
  9. RRDTool: 1.6.0
  10. SNMP: NET-SNMP 5.7.2
  11. ==================================DEBUG!
  12. Starting polling run:
  13.  
  14. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'crpkvm01' ORDER BY `device_id` ASC]
  15. SQL[SELECT * FROM devices_attribs WHERE `device_id` = '159']
  16. Hostname: crpkvm01
  17. Device ID: 159
  18. OS: raritan
  19.  
  20. SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('0','0','0','0','0','0','159',NOW())]
  21. UnpingableSQL[UPDATE `devices` set `status` ='0',`status_reason` ='icmp' WHERE device_id='159']
  22. SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`)  VALUES ('159','159','NULL','down',NOW(),'2','Device status changed to Down from icmp check.','')]
  23. #### Start Alerts ####
  24. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='159']
  25. SQL[SELECT 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 = '159' ) && ((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(), '--%d') AND (end_recurring_dt >= date_format(NOW(), '--%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(), ''),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1]
  26. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='159']
  27. SQL[SELECT 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 = '159' ) || alert_map.target = '159'  )]
  28. Rule #8 (Storage usage exceeded threshold):
  29. SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '159' ORDER BY id DESC LIMIT 1]
  30. SQL[SELECT * FROM storage WHERE (storage.device_id = '159') && (storage.storage_perc > storage.storage_perc_warn        &&  storage.storage_descr NOT REGEXP "/boot" )]
  31. Status: NOCHG
  32. #### End Alerts ####
  33. SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','crpkvm01','1512574821.9746','0.062','1','crplibrenms')]
  34. /opt/librenms/poller.php crpkvm01 2017-12-06 09:40:22 - 1 devices polled in 0.062 secs
  35. SNMP [0/0.00s]: Get[0/0.00s] Getnext[0/0.00s] Walk[0/0.00s]
  36. MySQL [16/0.00s]: Cell[3/0.00s] Row[1/0.00s] Rows[6/0.00s] Column[2/0.00s] Update[1/0.00s] Insert[3/0.00s] Delete[0/0.00s]
  37. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  38.  
  39.