LibreNMS Poller
SQL[select `version` from `dbSchema` order by `version` desc limit 1 [] 0.4ms] 
SQL[SELECT version() [] 0.35ms] 
===================================
Version info:
Commit SHA: 5aacb03a307a42f528d6f8fd86f8427158d48a02
Commit Date: 1537550027
DB Schema: 268
PHP: 7.0.27-0+deb9u1
MySQL: 10.1.26-MariaDB-0+deb9u1
RRDTool: 1.6.0
SNMP: NET-SNMP 5.7.3
==================================DEBUG!
Updating os_def.cache... 
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
Done
Starting polling run:

SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '185.195.248.255' ORDER BY `device_id` ASC [] 0.99ms] 
SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [36] 0.27ms] 
Hostname: 185.195.248.255
Device ID: 36
OS: generic
Warning: inet_pton(): Unrecognized address  in /opt/librenms/includes/polling/functions.inc.php on line 248


[FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 185.195.248.255
Array
(
    [xmt] => 3
    [rcv] => 3
    [loss] => 0
    [min] => 18.5
    [max] => 222
    [avg] => 87.6
    [exitcode] => 0
)
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] 
SNMP Check response code: 1
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysObjectID.0]

SNMP Unreachable#### Start Alerts ####
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [36] 0.51ms] 
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] 
SQL[SELECT 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=? OR dg.device_id=?) [36,36] 0.53ms] 
Rule #1 (Devices up/down): 
SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [36] 0.79ms] 
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,36] 0.44ms] 
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] 
SQL[UPDATE `alert_log` set `details`=? WHERE id = ?  3.42ms] 

Rule #2 (Device rebooted): 
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] 
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [6,36] 0.48ms] 
Status: NOCHG
Rule #7 (Sensor over limit - Check Device Health Settings): 
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] 
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [7,36] 0.44ms] 
Status: NOCHG
Rule #8 (Sensor under limit - Check Device Health Settings): 
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] 
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [8,36] 0.44ms] 
Status: NOCHG
Rule #9 (Service up/down): 
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] 
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [9,36] 0.43ms] 
Status: NOCHG
Rule #10 (Wireless Sensor over limit): 
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] 
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [10,36] 0.43ms] 
Status: NOCHG
Rule #11 (Wireless Sensor under limit): 
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] 
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [11,36] 0.48ms] 
Status: NOCHG
Rule #12 (State Sensor Critical): 
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] 
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [12,36] 0.58ms] 
Status: NOCHG
#### End Alerts ####
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] 
/opt/librenms/poller.php 185.195.248.255 2018-09-22 17:12:40 - 1 devices polled in 13.53 secs
SNMP [2/12.03s]: Get[2/12.03s] Getnext[0/0.00s] Walk[0/0.00s]
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]
RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]