LibreNMS Poller
Version info:
Commit SHA: 49b5844346bdfe54616a0e838a7ef634b0e7bdd1
Commit Date: 1487117160
DB Schema: 164
PHP: 5.5.9-1ubuntu4.21
MySQL: 5.5.53-0ubuntu0.14.04.1
RRDTool: 1.4.7
SNMP: NET-SNMP 5.7.2
DEBUG!
Starting polling run:

SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'yuzuki.agari.co' ORDER BY `device_id` ASC]
SQL[SELECT * FROM devices_attribs WHERE `device_id` = '2']
Hostname: yuzuki.agari.co
Device ID: 2
OS: linux (unix)

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

SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0]
sysUpTime.0 = 72642
sysName.0 = yuzuki
sysObjectID.0 = enterprises.8*

SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 sysDescr.0]
Linux yuzuki 4.4.35-2-pve #1 SMP Mon Jan 9 10:21:44 CET 2017 x86_64

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

Using hrSystemUptime (57868s)
RRD[update yuzuki.agari.co/uptime.rrd N:57868 --daemon unix:/var/run/rrdcached.sock]
[RRD Disabled]Uptime: 16h 4m 28s
SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`='3 Hill Quays, Manchester' LIMIT 1]
Using cached lat/lng from other device
Modules status: Global+ OS  Device+
#### Load poller module applications ####
SQL[SELECT * FROM `applications` WHERE `device_id`  = '2']
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -O qv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 .1.3.6.1.4.1.8072.1.3.2.3.1.2.7.112.114.111.120.109.111.120]
** snip **
>> Runtime for poller module 'applications': 1.1749 seconds with 11952 bytes
#### Unload poller module applications ####

RRD[update yuzuki.agari.co/poller-perf-applications.rrd N:1.1749410629272 --daemon unix:/var/run/rrdcached.sock]
[RRD Disabled]Modules status: Global+ OS  Device+
#### Load poller module unix-agent ####
LibreNMS UNIX Agent: SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '2' AND `attrib_type` = 'override_Unixagent_port' ]
execution time: 645msRRD[update yuzuki.agari.co/agent.rrd N:645 --daemon unix:/var/run/rrdcached.sock]
[RRD Disabled]Array
(
    [] =>
    [Observium] => Version: 1.0.1
AgentOS: linux
PluginsDirectory: /usr/lib/observium_agent/plugins
LocalDirectory: /usr/lib/observium_agent/local
AgentDirectory: /etc/observium
OnlyFrom:

    [hddtemp] => |/dev/sda|ST3160815AS|36|C||/dev/sdb|WDC WD30EFRX-68EUZN0|32|C||/dev/sdc|WDC WD30EFRX-68EUZN0|31|C||/dev/sdd|WDC WD30EFRX-68EUZN0|36|C||/dev/sde|WDC WD30EFRX-68EUZN0|31|C||/dev/sdf|WDC WD30EFRX-68EUZN0|32|C||/dev/sdg|WDC WD30EFRX-68EUZN0|31|C||/dev/sdh|WDC WD30EFRX-68EUZN0|32|C|
)

Including: unix-agent/hddtemp.inc.phphddtemp: Discover sensor: , 1, hddtemp, /dev/sda: ST3160815AS, agent, ,
SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'agent' AND `sensor_class` = 'temperature' AND `device_id` = '2' AND sensor_type = 'hddtemp' AND `sensor_index` = '1']
SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '2' AND `sensor_type` = 'hddtemp' AND `sensor_index` = '1']
.Discover sensor: , 2, hddtemp, /dev/sdb: WDC WD30EFRX-68EUZN0, agent, ,
SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'agent' AND `sensor_class` = 'temperature' AND `device_id` = '2' AND sensor_type = 'hddtemp' AND `sensor_index` = '2']
SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '2' AND `sensor_type` = 'hddtemp' AND `sensor_index` = '2']
.Discover sensor: , 3, hddtemp, /dev/sdc: WDC WD30EFRX-68EUZN0, agent, ,
SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'agent' AND `sensor_class` = 'temperature' AND `device_id` = '2' AND sensor_type = 'hddtemp' AND `sensor_index` = '3']
SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '2' AND `sensor_type` = 'hddtemp' AND `sensor_index` = '3']
.Discover sensor: , 4, hddtemp, /dev/sdd: WDC WD30EFRX-68EUZN0, agent, ,
SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'agent' AND `sensor_class` = 'temperature' AND `device_id` = '2' AND sensor_type = 'hddtemp' AND `sensor_index` = '4']
SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '2' AND `sensor_type` = 'hddtemp' AND `sensor_index` = '4']
.Discover sensor: , 5, hddtemp, /dev/sde: WDC WD30EFRX-68EUZN0, agent, ,
SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'agent' AND `sensor_class` = 'temperature' AND `device_id` = '2' AND sensor_type = 'hddtemp' AND `sensor_index` = '5']
SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '2' AND `sensor_type` = 'hddtemp' AND `sensor_index` = '5']
.Discover sensor: , 6, hddtemp, /dev/sdf: WDC WD30EFRX-68EUZN0, agent, ,
SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'agent' AND `sensor_class` = 'temperature' AND `device_id` = '2' AND sensor_type = 'hddtemp' AND `sensor_index` = '6']
SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '2' AND `sensor_type` = 'hddtemp' AND `sensor_index` = '6']
.Discover sensor: , 7, hddtemp, /dev/sdg: WDC WD30EFRX-68EUZN0, agent, ,
SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'agent' AND `sensor_class` = 'temperature' AND `device_id` = '2' AND sensor_type = 'hddtemp' AND `sensor_index` = '7']
SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '2' AND `sensor_type` = 'hddtemp' AND `sensor_index` = '7']
.Discover sensor: , 8, hddtemp, /dev/sdh: WDC WD30EFRX-68EUZN0, agent, ,
SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'agent' AND `sensor_class` = 'temperature' AND `device_id` = '2' AND sensor_type = 'hddtemp' AND `sensor_index` = '8']
SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '2' AND `sensor_type` = 'hddtemp' AND `sensor_index` = '8']
.
Processes: SQL[DELETE FROM `processes` WHERE device_id = '2']

Sensors: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '2' AND S.poller_type = 'agent']
1 -> hddtemp
2 -> hddtemp
3 -> hddtemp
4 -> hddtemp
5 -> hddtemp
6 -> hddtemp
7 -> hddtemp
8 -> hddtemp



>> Runtime for poller module 'unix-agent': 0.6651 seconds with 320632 bytes
#### Unload poller module unix-agent ####

RRD[update yuzuki.agari.co/poller-perf-unix-agent.rrd N:0.66512298583984 --daemon unix:/var/run/rrdcached.sock]
[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`='2']
Groups Added:
Groups Removed:
### End Device Groups ###
SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = '2']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'netstat_ip']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'netstat_ip_frag']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'netstat_tcp']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'netstat_udp']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'netstat_icmp']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'netstat_icmp_info']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'netstat_snmp']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'netstat_snmp_pkt']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ucd_cpu']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ucd_swap_io']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ucd_io']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ucd_contexts']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ucd_interrupts']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ucd_memory']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ucd_load']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ipsystemstats_ipv4']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ipsystemstats_ipv4_frag']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ipsystemstats_ipv6']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'ipsystemstats_ipv6_frag']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'hr_processes']
SQL[DELETE FROM `device_graphs` WHERE `device_id` = '2' AND `graph` = 'hr_users']
uptime agent RRD[update yuzuki.agari.co/poller-perf.rrd N:2.377 --daemon unix:/var/run/rrdcached.sock]
[RRD Disabled]RRD[update yuzuki.agari.co/ping-perf.rrd N:7.28 --daemon unix:/var/run/rrdcached.sock]
[RRD Disabled]Polled in 2.377 seconds
Updating yuzuki.agari.co
SQL[UPDATE `devices` set `uptime` ='57868',`last_ping` =NOW(),`last_ping_timetaken` ='7.28',`last_polled` =NOW(),`last_polled_timetaken` ='2.377' WHERE `device_id` = '2']
UPDATED!
#### Start Alerts ####
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='2']
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 = '2' ) && ((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 `device_group_id` FROM `device_group_device` WHERE `device_id`='2']
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 = '2' ) || alert_map.target = '2'  )]
#### End Alerts ####
SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','yuzuki.agari.co','1487155706.9077','2.405','1','obs\n')]
./poller.php yuzuki.agari.co 2017-02-15 10:48:29 - 1 devices polled in 2.405 secs
SNMP: Get[5/1.13s] Walk [0/0.00s]
MySQL: Cell[11/0.00s] Row[43/0.10s] Rows[9/0.01s] Column[3/0.00s] Update[48/0.02s] Insert[2/0.00s] Delete[22/0.04s]