Add VMG1312 POLLER

From Loic69, 5 Years ago, written in Plain Text.
URL https://p.libren.ms/view/243c436b
Embed
Download Paste or View Raw
  1. LibreNMS Poller
  2. SQL[select `version` from `dbSchema` order by `version` desc limit 1 [] 0.4ms]
  3. SQL[SELECT version() [] 0.35ms]
  4. ===================================
  5. Version info:
  6. Commit SHA: 5aacb03a307a42f528d6f8fd86f8427158d48a02
  7. Commit Date: 1537550027
  8. DB Schema: 268
  9. PHP: 7.0.27-0+deb9u1
  10. MySQL: 10.1.26-MariaDB-0+deb9u1
  11. RRDTool: 1.6.0
  12. SNMP: NET-SNMP 5.7.3
  13. ==================================DEBUG!
  14. Updating os_def.cache...
  15. Warning: file_put_contents(/opt/librenms/cache/os_defs.cache): failed to open stream: Permission denied in /opt/librenms/includes/common.php on line 1651
  16. Done
  17. Starting polling run:
  18.  
  19. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '185.195.248.255' ORDER BY `device_id` ASC [] 0.99ms]
  20. SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [36] 0.27ms]
  21. Hostname: 185.195.248.255
  22. Device ID: 36
  23. OS: generic
  24. Warning: inet_pton(): Unrecognized address  in /opt/librenms/includes/polling/functions.inc.php on line 248
  25.  
  26.  
  27. [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 185.195.248.255
  28. Array
  29. (
  30.     [xmt] => 3
  31.     [rcv] => 3
  32.     [loss] => 0
  33.     [min] => 18.5
  34.     [max] => 222
  35.     [avg] => 87.6
  36.     [exitcode] => 0
  37. )
  38. SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW()) {"xmt":"3","rcv":"3","loss":"0","min":"18.5","max":"222","avg":"87.6","device_id":36} 169.09ms]
  39. SNMP Check response code: 1
  40. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysObjectID.0]
  41.  
  42. SNMP Unreachable#### Start Alerts ####
  43. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [36] 0.51ms]
  44. 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 = ? ) && ((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 [36] 0.8ms]
  45. SQL[SELECT DISTINCT a.* FROM alert_rules a
  46.   LEFT JOIN alert_device_map d ON a.id=d.rule_id
  47.   LEFT JOIN alert_group_map g ON a.id=g.rule_id
  48.   LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
  49.   WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [36,36] 0.53ms]
  50. Rule #1 (Devices up/down):
  51. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [36] 0.79ms]
  52. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,36] 0.44ms]
  53. Status: NOCHGSQL[SELECT alert_log.id, alert_log.details FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = ? && alert_log.rule_id = ? && alert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1 [36,1] 1.27ms]
  54. SQL[UPDATE `alert_log` set `details`=? WHERE id = ?  3.42ms]
  55.  
  56. Rule #2 (Device rebooted):
  57. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed details`=? xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed bgpPeers.bgpPeerState = "established" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [36] 3.16ms]
  58. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [6,36] 0.48ms]
  59. Status: NOCHG
  60. Rule #7 (Sensor over limit - Check Device Health Settings):
  61. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > "sensors.sensor_limit" AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [36] 1.1ms]
  62. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [7,36] 0.44ms]
  63. Status: NOCHG
  64. Rule #8 (Sensor under limit - Check Device Health Settings):
  65. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < "sensors.sensor_limit_low" AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [36] 3.22ms]
  66. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [8,36] 0.44ms]
  67. Status: NOCHG
  68. Rule #9 (Service up/down):
  69. SQL[SELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [36] 1.03ms]
  70. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [9,36] 0.43ms]
  71. Status: NOCHG
  72. Rule #10 (Wireless Sensor over limit):
  73. SQL[SELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current >= "wireless_sensors.sensor_limit" AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [36] 0.72ms]
  74. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [10,36] 0.43ms]
  75. Status: NOCHG
  76. Rule #11 (Wireless Sensor under limit):
  77. SQL[SELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current <= "wireless_sensors.sensor_limit_low" AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [36] 3.36ms]
  78. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [11,36] 0.48ms]
  79. Status: NOCHG
  80. Rule #12 (State Sensor Critical):
  81. SQL[SELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 [36] 1.11ms]
  82. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [12,36] 0.58ms]
  83. Status: NOCHG
  84. #### End Alerts ####
  85. SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"185.195.248.255","start":1537629147.4208,"duration":"13.53","devices":1,"poller":"librenms"} 1.94ms]
  86. /opt/librenms/poller.php 185.195.248.255 2018-09-22 17:12:40 - 1 devices polled in 13.53 secs
  87. SNMP [2/12.03s]: Get[2/12.03s] Getnext[0/0.00s] Walk[0/0.00s]
  88. MySQL [21/0.20s]: Cell[14/0.01s] Row[-12/-0.01s] Rows[14/0.02s] Column[1/0.00s] Update[2/0.01s] Insert[2/0.17s] Delete[0/0.00s]
  89. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]


Reply to "Add VMG1312 POLLER"