poller-fsw

LibreNMS Poller
Version info:
Commit SHA: 49db00b8fd4bb4e524c6c1999a361fe2631e428b
Commit Date: 1477033155
DB Schema: 148
PHP: 5.5.9-1ubuntu4.20
MySQL: 5.5.52-MariaDB-1ubuntu0.14.04.1
RRDTool: 1.4.7
SNMP: NET-SNMP 5.7.2
DEBUG!
Starting polling run:

SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.40.70.1' ORDER BY `device_id` ASC]
SQL[SELECT * FROM `devices` WHERE `device_id` = 42]
SQL[SELECT * FROM devices_attribs WHERE `device_id` = '42']
Hostname: 10.40.70.1
Device ID: 42
OS: generic

SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','7.77','17.2','13.3','42',NOW())]
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysObjectID.0]
SNMPv2-SMI::enterprises.123*2

SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0]
sysUpTime.0 = 275566457
sysLocation.0 = 41866 Kalmia Street Murrieta, CA
sysContact.0 = tj.krause@springscs.org
sysName.0 = MSC-FS-01
sysObjectID.0 = enterprises.123*2

SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysDescr.0]


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 = No Such Object available on this agent at this OID
hrSystemUptime.0 = No Such Object available on this agent at this OID

Using SNMP Agent Uptime (2755664s)
  RRD[update /opt/librenms/rrd/10.40.70.1/uptime.rrd N:2755664]
[RRD Disabled]Uptime: 31 days, 21h 27m 44s
SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`='41866 Kalmia Street Murrieta, CA' LIMIT 1]
Using cached lat/lng from other device

#### Load poller module os ####
Generic :(
Hardware:
Version:
Features:
Serial:

>> Runtime for poller module 'os': 0.00072288513183594 seconds
#### Unload poller module os ####

RRD[update /opt/librenms/rrd/10.40.70.1/poller-perf-os.rrd N:0.00072288513183594]
[RRD Disabled]### Start Device Groups ###
SQL[SELECT * FROM device_groups ORDER BY name]
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='42']
Groups Added:
Groups Removed:
### End Device Groups ###
RRD[update /opt/librenms/rrd/10.40.70.1/poller-perf.rrd N:0.587]
[RRD Disabled]RRD[update /opt/librenms/rrd/10.40.70.1/ping-perf.rrd N:13.3]
[RRD Disabled]Polled in 0.587 seconds
Updating 10.40.70.1
SQL[UPDATE `devices` set `uptime` ='2755664',`last_ping` =NOW(),`last_ping_timetaken` ='13.3',`last_polled` =NOW(),`last_polled_timetaken` ='0.587' WHERE `device_id` = '42']
UPDATED!
#### Start Alerts ####
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='42']
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 = '42' ) && NOW() BETWEEN alert_schedule.start AND alert_schedule.end LIMIT 1]
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='42']
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 = '42' ) || alert_map.target = '42'  )]
Rule #1 (Device Down):
SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '42' ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM devices WHERE (devices.device_id = '42') && (devices.status != "1"        &&  devices.os != "airos"   )]
Status: NOCHG
Rule #5 (UPS Battery Draining):
SQL[SELECT state FROM alerts WHERE rule_id = '5' && device_id = '42' ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM devices,sensors WHERE (( sensors.device_id = devices.device_id ) && devices.device_id = '42') && (devices.type = "power"  &&  sensors.sensor_class = "charge"    &&  sensors.sensor_current < "100"       )]
Status: NOCHG
Rule #6 (ubiquiti):
SQL[SELECT state FROM alerts WHERE rule_id = '6' && device_id = '42' ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM devices WHERE (devices.device_id = '42') && (devices.status != "1"    &&  devices.os = "airos"   )]
Status: NOCHG
#### End Alerts ####
SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','10.40.70.1','1477079837.1323','0.627','1','nms\n')]
./poller.php 10.40.70.1 2016-10-21 12:57:17 - 1 devices polled in 0.627 secs

MySQL: Cell[1/0s] Row[8/0s] Rows[8/0s] Column[3/0s] Update[1/0s] Insert[2/0s] Delete[0/0s]