1. LibreNMS Poller
2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.17ms]
3.  
4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.12ms]
5.  
6. SQL[[1;33mSELECT version() [0;33m[][0m 0.13ms]
7.  
8. ===================================
9. Version info:
10. Commit SHA: 83a53d7cd588a099d78b3b2bec2914e7b3b25008
11. Commit Date: 1548776598
12. DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
13. PHP: 7.2.14-1+ubuntu14.04.1+deb.sury.org+1
14. MySQL: 5.5.62-0ubuntu0.14.04.1
15. RRDTool: 1.4.7
16. SNMP: NET-SNMP 5.7.2
17. ==================================DEBUG!
18. Updating os_def.cache...  
19. Done  
20. Override poller modules: sensors  
21. Starting polling run:
22.  
23. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'ro-labbet4500.gavlenet.com' ORDER BY `device_id` ASC [0;33m[][0m 0.44ms]
24.  
25. SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[781][0m 0.18ms]
26.  
27. Hostname: ro-labbet4500.gavlenet.com
28. Device ID: 781
29. OS: iosxe (cisco)
30.  
31. [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 ro-labbet4500.gavlenet.com  
32. array (
33.   'xmt' => '3',
34.   'rcv' => '3',
35.   'loss' => '0',
36.   'min' => '0.92',
37.   'max' => '1.13',
38.   'avg' => '1.01',
39.   'exitcode' => 0,
40. )  
41. 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]
42.  
43. SNMP Check response code: 0  
44. Modules status: Global+  
45. OS  
46. Device  
47.  
48. #### Load poller module core ####
49. 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]
50. .*.*.0 = 365318793
51. .*.*.0 = [60.681426,17.156229]
52. .*.*.0 = noc@gavlenet.com
53. .*.*.0 = ro-labbet4500.gavlenet.com
54. .*.*.0 = .*.*.875
55. .*.*.0 = Cisco IOS Software, IOS-XE Software, Catalyst 4500 L3 Switch  Software (cat4500es8-UNIVERSALK9-M), Version 03.08.06.E RELEASE SOFTWARE (fc4)
56. Technical Support: http://www.cisco.com/techsupport
57. Copyright (c) 1986-2018 by Cisco Systems, Inc.
58. Compiled Thu  
59.  
60. 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]
61. snmpEngineTime.0 = 3653099
62. hrSystemUptime.0 = No Such Object available on this agent at this OID  
63.  
64. Uptime seconds: 3653188  
65. RRD[[0;32mupdate /opt/librenms/rrd/ro-labbet4500.gavlenet.com/uptime.rrd N:3653188[0m]
66. Uptime: 42 days, 6h 46m 28s
67. SQL[[1;33mselect * from `locations` where (`location` = ?) limit 1 [0;33m["[60.681426,17.156229]"][0m 0.23ms]
68.  
69.  
70. >> Runtime for poller module 'core': 0.0340 seconds with 62848 bytes
71. >> SNMP: [2/0.03s] MySQL: [0/0.00s] RRD: [1/0.00s]
72. #### Unload poller module core ####
73.  
74. RRD[[0;32mupdate /opt/librenms/rrd/ro-labbet4500.gavlenet.com/poller-perf-core.rrd N:0.03397798538208[0m]
75. Modules status: Global+  
76. OS  
77. Device  
78.  
79. #### Load poller module sensors ####
80. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[781][0m 0.37ms]
81.  
82.  
83. >> Runtime for poller module 'sensors': 0.0005 seconds with 1464 bytes
84. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [1/0.00s]
85. #### Unload poller module sensors ####
86.  
87. RRD[[0;32mupdate /opt/librenms/rrd/ro-labbet4500.gavlenet.com/poller-perf-sensors.rrd N:0.0005490779876709[0m]
88. ### Start Device Groups ###  
89. SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.15ms]
90.  
91. SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[781][0m 0.11ms]
92.  
93. Groups Added:  
94. Groups Removed:  
95. ### End Device Groups ###  
96. RRD[[0;32mupdate /opt/librenms/rrd/ro-labbet4500.gavlenet.com/ping-perf.rrd N:1.01[0m]
97. RRD[[0;32mupdate /opt/librenms/rrd/ro-labbet4500.gavlenet.com/poller-perf.rrd N:1.063[0m]
98. SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=? WHERE `device_id` = ? [0;33m[3653188,"1.01",781][0m 5.37ms]
99.  
100. Updating ro-labbet4500.gavlenet.com  
101.  
102. Polled in 1.063 seconds
103. #### Start Alerts ####
104. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[781][0m 0.38ms]
105.  
106. 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]
107.  
108. 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]
109.  
110. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
111.   LEFT JOIN alert_device_map d ON a.id=d.rule_id
112.   LEFT JOIN alert_group_map g ON a.id=g.rule_id
113.   LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
114.   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]
115.  
116. #### End Alerts ####
117. 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]
118.  
119. ./poller.php ro-labbet4500.gavlenet.com 2019-01-30 13:17:00 - 1 devices polled in 1.186 secs  
120. SNMP [3/0.04s]: Get[3/0.04s] Getnext[0/0.00s] Walk[0/0.00s]
121. 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]
122. RRD [5/0.00s]: Update[5/0.00s] Create [0/0.00s] Other[0/0.00s]
123.