LibreNMS Poller
===================================
Version info:
Commit SHA: 052b9d1ace3b4b7c89890e28da80e4d104f3efaa
Commit Date: 1523977651
DB Schema: 247
PHP: 7.1.10
MySQL: 5.6.38
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
==================================DEBUG!
Updating os_def.cache... Done
Starting polling run:

SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'lab-3850-48t' ORDER BY `device_id` ASC]
SQL[SELECT * FROM devices_attribs WHERE `device_id` = '1130']
Hostname: lab-3850-48t
Device ID: 1130
OS: iosxe (cisco)

SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','1.39','1.71','1.58','1130',NOW())]
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:/opt/librenms/mibs/cisco udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0]
.*.*.0 = 24413836
.*.*.0 =
.*.*.0 =
.*.*.0 = LAB-3850-48T
.*.*.0 = .*.*.1745
.*.*.0 = Cisco IOS Software [Denali], Catalyst L3 Switch Software (CAT3K_CAA-UNIVERSALK9-M), Version 16.3.6, RELEASE SOFTWARE (fc3)
Technical Support: http://www.cisco.com/techsupport
Copyright (c) 1986-2018 by Cisco Systems, Inc.
Compiled Wed 28-Feb-18 15:23 b

SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/cisco udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0]
snmpEngineTime.0 = 244093
hrSystemUptime.0 = No Such Object available on this agent at this OID

Uptime seconds: 244138
RRD[update ip/uptime.rrd N:244138 --daemon unix:/run/rrdcached.sock]
Uptime: 2 days, 19h 48m 58s

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

RRD[update /poller-perf-core.rrd N:0.034547090530396 --daemon unix:/run/rrdcached.sock]
### Start Device Groups ###
SQL[SELECT * FROM device_groups ORDER BY name]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "" ) LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "" ) LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "" || devices.location REGEXP "" || devices.location REGEXP "" || devices.location REGEXP "" ) LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "" || devices.location REGEXP "CPWT" ) LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP ""  ) LIMIT 1]
SQL[SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv4_addresses' && COLUMN_NAME LIKE "%\_id"]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv4s' && COLUMN_NAME = 'device_id']
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv4s' && COLUMN_NAME = 'device_id']
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ports' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices,ipv4_addresses,ports WHERE (( ipv4_addresses.port_id = ports.port_id && ports.device_id = devices.device_id )) && devices.device_id='1130' AND (devices.os REGEXP "ios"  && ipv4_addresses.ipv4_address REGEXP "10.0.3..*" ) LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "" ) LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "" ) LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.hostname REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv4_addresses' && COLUMN_NAME = 'device_id']
SQL[SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv4_addresses' && COLUMN_NAME LIKE "%\_id"]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv4s' && COLUMN_NAME = 'device_id']
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv4s' && COLUMN_NAME = 'device_id']
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ports' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices,ipv4_addresses,ports WHERE (( ipv4_addresses.port_id = ports.port_id && ports.device_id = devices.device_id )) && devices.device_id='1130' AND (ipv4_addresses.ipv4_address REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.os REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1130' AND (devices.location REGEXP "") LIMIT 1]
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='1130']
Groups Added:
Groups Removed:
### End Device Groups ###
RRD[update /ping-perf.rrd N:1.58 --daemon unix:/run/rrdcached.sock]
RRD[update /poller-perf.rrd N:1.115 --daemon unix:/run/rrdcached.sock]
Polled in 1.115 seconds
Updating
SQL[UPDATE `devices` set `uptime` ='244138',`last_ping` =NOW(),`last_ping_timetaken` ='1.58',`last_polled` =NOW(),`last_polled_timetaken` ='1.115' WHERE `device_id` = '1130']
UPDATED!
#### Start Alerts ####
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='1130']
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 = '1130' ) && ((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]
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='1130' OR dg.device_id='1130')]
Rule #1 (Devices up/down):
SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '1130' ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM devices WHERE (devices.device_id = '1130') && (((devices.status = 0  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"  )]
Status: NOCHG
Rule #2 (Device rebooted):
SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '1130' ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM devices WHERE (devices.device_id = '1130') && (devices.uptime < "300"  &&  ((devices.disabled = 0  &&  devices.ignore = 0)) = "1")]
Status: NOCHG
Rule #30 (APC UPS Switched to Battery Power):
SQL[SELECT state FROM alerts WHERE rule_id = '30' && device_id = '1130' ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM sensors WHERE (sensors.device_id = '1130') && (sensors.sensor_current = "3"  &&  sensors.sensor_type = "upsBasicOutputStatus"      )]
Status: NOCHG
#### End Alerts ####
SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','','1532963879.8001','1.408','1','librenms.example.net')]
./poller.php  2018-07-30 10:18:01 - 1 devices polled in 1.408 secs
SNMP [3/0.08s]: Get[3/0.08s] Getnext[0/0.00s] Walk[0/0.00s]
MySQL [57/0.03s]: Cell[36/0.02s] Row[3/0.00s] Rows[11/0.01s] Column[2/0.00s] Update[3/0.00s] Insert[2/0.00s] Delete[0/0.00s]
RRD [4/0.00s]: Update[4/0.00s] Create [0/0.00s] Other[0/0.00s]