S5840cdn Poller

LibreNMS Poller
SQL[select `version` from `dbSchema` order by `version` desc limit 1 [] 0.57ms]
SQL[SELECT version() [] 0.48ms]
===================================
Version info:
Commit SHA: 54de88415ba75d92a8e054883c5f053d93be78bd
Commit Date: 1538502485
DB Schema: 268
PHP: 7.0.32-0ubuntu0.16.04.1
MySQL: 10.0.36-MariaDB-0ubuntu0.16.04.1
RRDTool: 1.5.5
SNMP: NET-SNMP 5.7.3
==================================DEBUG!
Updating os_def.cache... Done
Override poller modules: os
Starting polling run:

SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'doccenter-dell-prnt.teamnorthwoods.com' ORDER BY `device_id` ASC [] 1.66ms]
SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [72] 0.62ms]
Hostname: doccenter-dell-prnt.teamnorthwoods.com
Device ID: 72
OS: generic

[FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 doccenter-dell-prnt.teamnorthwoods.com
Array
(
    [xmt] => 3
    [rcv] => 3
    [loss] => 0
    [min] => 1.01
    [max] => 1.11
    [avg] => 1.06
    [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":"1.01","max":"1.11","avg":"1.06","device_id":72} 4.33ms]
SNMP Check response code: 0
Modules status: Global+ OS  Device
#### Load poller module core ####
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUt -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0]
.*.*.0 = 36243526
.*.*.0 = DocCenter
.*.*.0 = 404
.*.*.0 = DocCenter-Dell-Color
.*.*.0 = .*.4.1.674.108*.51.1094474005
.*.*.0 = Dell S5840cdn version CB.021.04701 kernel 3.18.7-yocto-standard-cf1f23aab8def585f45d81985c7cbad4 All-N-1

SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0]
snmpEngineTime.0 = 362435
hrSystemUptime.0 = 36241605

Uptime seconds: 362435
RRD[update doccenter-dell-prnt.teamnorthwoods.com/uptime.rrd N:362435 --daemon unix:/var/run/rrdcached.sock]
[RRD Disabled]Uptime: 4 days, 4h 40m 35s
SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`=? LIMIT 1 ["WIC - Doc Center"] 0.89ms]
Google geocode engine being used
Bad lat / lng received

>> Runtime for poller module 'core': 0.1966 seconds with 16704 bytes
>> SNMP: [2/0.04s] MySQL: [1/0.00s] RRD: [0/0.00s]
#### Unload poller module core ####

RRD[update doccenter-dell-prnt.teamnorthwoods.com/poller-perf-core.rrd N:0.19658398628235 --daemon unix:/var/run/rrdcached.sock]
[RRD Disabled]Modules status: Global+ OS  Device
#### Load poller module os ####
Generic :(
Hardware:
Version:
Features:
Serial:

>> Runtime for poller module 'os': 0.0004 seconds with 488 bytes
>> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
#### Unload poller module os ####

RRD[update doccenter-dell-prnt.teamnorthwoods.com/poller-perf-os.rrd N:0.00040698051452637 --daemon unix:/var/run/rrdcached.sock]
[RRD Disabled]### Start Device Groups ###
SQL[SELECT * FROM device_groups ORDER BY name [] 0.9ms]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.sysName REGEXP ".*nws.*") LIMIT 1 [72] 1.06ms]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.type = "appliance" ) LIMIT 1 [72] 0.79ms]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.type = "server" && devices.sysName != "ntnx-16sm6c520011-c-cvm" && devices.sysName != "nwsgraylog1" && devices.hostname != "ipminwsntnh1.teamnorthwoods.com" ) LIMIT 1 [72] 0.8ms]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.type = "network" || devices.type = "wireless" || devices.type = "firewall" ) LIMIT 1 [72] 0.79ms]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.type = "server" ) LIMIT 1 [72] 0.81ms]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.type = "power") LIMIT 1 [72] 0.84ms]
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [72] 0.55ms]
Groups Added:
Groups Removed:
### End Device Groups ###
RRD[update doccenter-dell-prnt.teamnorthwoods.com/ping-perf.rrd N:1.06 --daemon unix:/var/run/rrdcached.sock]
[RRD Disabled]RRD[update doccenter-dell-prnt.teamnorthwoods.com/poller-perf.rrd N:1.239 --daemon unix:/var/run/rrdcached.sock]
[RRD Disabled]SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=? WHERE `device_id` = ? [362435,"1.06",72] 4.01ms]
Updating doccenter-dell-prnt.teamnorthwoods.com

Polled in 1.239 seconds
#### Start Alerts ####
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [72] 0.56ms]
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 [72] 1.36ms]
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=?) [72,72] 0.79ms]
Rule #1 (Connectivity Lost):
SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [72] 1.24ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,72] 0.73ms]
Status: NOCHG
Rule #23 (Aggregate CPU utilization over 95%):
SQL Error! SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'edit this rule!)' at line 1 (SQL: SELECT * FROM devices WHERE (devices.device_id = 72) && (Do not edit this rule!)) (SQL: SELECT * FROM devices WHERE (devices.device_id = 72) && (Do not edit this rule!))
  /opt/librenms/includes/alerts.inc.php:190
  /opt/librenms/poller.php:160
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [23,72] 0.68ms]
Status: NOCHG
Rule #26 (Wireless Access Point Down):
SQL[SELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND (services.service_desc = "Admin Wireless Access Point" OR services.service_desc = "Grizzly Wireless Access Point" OR services.service_desc = "NSC Wireless Access Point" OR services.service_desc = "Ohio Room Wireless Access Point" OR services.service_desc = "PD Wireless Access Point" OR services.service_desc = "Tech Comm Wireless Access Point") AND services.service_status != 0 [72] 1.61ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [26,72] 1.22ms]
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":"doccenter-dell-prnt.teamnorthwoods.com","start":1538754111.1699,"duration":"1.547","devices":1,"poller":"nwsNetworkMonitor"} 3.64ms]
./poller.php doccenter-dell-prnt.teamnorthwoods.com 2018-10-05 11:41:52 - 1 devices polled in 1.547 secs
SNMP [3/0.06s]: Get[3/0.06s] Getnext[0/0.00s] Walk[0/0.00s]
MySQL [10/0.02s]: Cell[11/0.01s] Row[-10/-0.01s] Rows[4/0.01s] Column[2/0.00s] Update[1/0.00s] Insert[2/0.01s] Delete[0/0.00s]
RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]