LibreNMS Poller
SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.17ms] 
  
SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.12ms] 
  
SQL[[1;33mSELECT version() [0;33m[][0m 0.13ms] 
  
===================================
Version info:
Commit SHA: 83a53d7cd588a099d78b3b2bec2914e7b3b25008
Commit Date: 1548776598
DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
PHP: 7.2.14-1+ubuntu14.04.1+deb.sury.org+1
MySQL: 5.5.62-0ubuntu0.14.04.1
RRDTool: 1.4.7
SNMP: NET-SNMP 5.7.2
==================================DEBUG!
Updating os_def.cache...  
Done  
Override poller modules: sensors  
Starting polling run:

SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'ro-labbet4500.gavlenet.com' ORDER BY `device_id` ASC [0;33m[][0m 0.44ms] 
  
SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[781][0m 0.18ms] 
  
Hostname: ro-labbet4500.gavlenet.com
Device ID: 781
OS: iosxe (cisco)

[FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 ro-labbet4500.gavlenet.com  
array (
  'xmt' => '3',
  'rcv' => '3',
  'loss' => '0',
  'min' => '0.92',
  'max' => '1.13',
  'avg' => '1.01',
  'exitcode' => 0,
)  
SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`)  VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) [0;33m{"xmt":"3","rcv":"3","loss":"0","min":"0.92","max":"1.13","avg":"1.01","device_id":781,"debug":"[]"}[0m 7.75ms] 
  
SNMP Check response code: 0  
Modules status: Global+  
OS  
Device  

#### Load poller module core ####
SNMP[[0;36m'/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'[0m]
.*.*.0 = 365318793
.*.*.0 = [60.681426,17.156229]
.*.*.0 = noc@gavlenet.com
.*.*.0 = ro-labbet4500.gavlenet.com
.*.*.0 = .*.*.875
.*.*.0 = Cisco IOS Software, IOS-XE Software, Catalyst 4500 L3 Switch  Software (cat4500es8-UNIVERSALK9-M), Version 03.08.06.E RELEASE SOFTWARE (fc4)
Technical Support: http://www.cisco.com/techsupport
Copyright (c) 1986-2018 by Cisco Systems, Inc.
Compiled Thu  
  
SNMP[[0;36m'/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'[0m]
snmpEngineTime.0 = 3653099
hrSystemUptime.0 = No Such Object available on this agent at this OID  
  
Uptime seconds: 3653188  
RRD[[0;32mupdate /opt/librenms/rrd/ro-labbet4500.gavlenet.com/uptime.rrd N:3653188[0m]
Uptime: 42 days, 6h 46m 28s
SQL[[1;33mselect * from `locations` where (`location` = ?) limit 1 [0;33m["[60.681426,17.156229]"][0m 0.23ms] 
  

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

RRD[[0;32mupdate /opt/librenms/rrd/ro-labbet4500.gavlenet.com/poller-perf-core.rrd N:0.03397798538208[0m]
Modules status: Global+  
OS  
Device  

#### Load poller module sensors ####
SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[781][0m 0.37ms] 
  

>> Runtime for poller module 'sensors': 0.0005 seconds with 1464 bytes
>> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [1/0.00s]
#### Unload poller module sensors ####

RRD[[0;32mupdate /opt/librenms/rrd/ro-labbet4500.gavlenet.com/poller-perf-sensors.rrd N:0.0005490779876709[0m]
### Start Device Groups ###  
SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.15ms] 
  
SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[781][0m 0.11ms] 
  
Groups Added:  
Groups Removed:  
### End Device Groups ###  
RRD[[0;32mupdate /opt/librenms/rrd/ro-labbet4500.gavlenet.com/ping-perf.rrd N:1.01[0m]
RRD[[0;32mupdate /opt/librenms/rrd/ro-labbet4500.gavlenet.com/poller-perf.rrd N:1.063[0m]
SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=? WHERE `device_id` = ? [0;33m[3653188,"1.01",781][0m 5.37ms] 
  
Updating ro-labbet4500.gavlenet.com  

Polled in 1.063 seconds
#### Start Alerts ####
SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[781][0m 0.38ms] 
  
SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[781][0m 0.26ms] 
  
SQL[[1;33mselect exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = ? and `start` <= NOW() and `end` >= NOW()) or (`recurring` = ? and (`start_recurring_dt` <= date_format(NOW(), '[1;33m-[0;35m-%d') and (`end_recurring_dt` >= date_format(NOW(), '[1;33m-[0;35m-%d') or `end_recurring_dt` is null or `end_recurring_dt` = ? or `end_recurring_dt` = ?)) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), '[0;37m'), '%') or `recurring_day` is null or `recurring_day` = ?))) and ((`alert_schedulable_type` = ? and `alert_schedulable_id` = ?) or (`alert_schedulable_type` = ? and 0 = 1))) as `exists` [0;33m[0,1,"0000-00-00","","","device",781,"device_group"][0m 0.44ms] 
  
SQL[[1;33mSELECT 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=?) [0;33m[781,781][0m 0.2ms] 
  
#### End Alerts ####
SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"poll","doing":"ro-labbet4500.gavlenet.com","start":1548850619.078366,"duration":"1.186","devices":1,"poller":"nms"}[0m 9.23ms] 
  
./poller.php ro-labbet4500.gavlenet.com 2019-01-30 13:17:00 - 1 devices polled in 1.186 secs  
SNMP [3/0.04s]: Get[3/0.04s] Getnext[0/0.00s] Walk[0/0.00s]
MySQL [8/0.03s]: Cell[1/0.00s] Row[-1/-0.00s] Rows[4/0.00s] Column[1/0.00s] Update[1/0.01s] Insert[2/0.02s] Delete[0/0.00s]
RRD [5/0.00s]: Update[5/0.00s] Create [0/0.00s] Other[0/0.00s]