1. LibreNMS Poller
2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.25ms]
3.  
4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.4ms]
5.  
6. SQL[[1;33mSELECT version() [0;33m[][0m 0.3ms]
7.  
8. ===================================
9. Version info:
10. Commit SHA:
11. Commit Date:
12. DB Schema: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208)
13. PHP: 7.4.19
14. MySQL: 10.6.0-MariaDB-1:10.6.0+maria~focal
15. RRDTool: 1.7.2
16. SNMP: NET-SNMP 5.9
17. ==================================DEBUG!
18. Updating os_def.cache  
19.  
20. Warning: file_put_contents(/opt/librenms/cache/os_defs.cache): failed to open stream: Permission denied in /opt/librenms/LibreNMS/Util/OS.php on line 108
21. Starting polling run:
22.  
23. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'inrows1s2.hq.nerd.lan' ORDER BY `device_id` ASC [0;33m[][0m 0.6ms]
24.  
25. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[300][0m 0.63ms]
26.  
27. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[300][0m 0.34ms]
28.  
29. Attempting to initialize OS: apc  
30. OS initialized: LibreNMS\OS\Apc  
31. Hostname:    inrows1s2.hq.nerd.lan
32. Device ID:   300
33. OS:          apc
34. Resolved IP: 10.40.249.20
35.  
36.  
37. SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["inrows1s2.hq.nerd.lan"][0m 0.41ms]
38.  
39. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'inrows1s2.hq.nerd.lan'
40.  
41. response:  {"xmt":3,"rcv":3,"loss":0,"min":0.661,"max":0.73,"avg":0.696,"dup":0,"exitcode":0}
42. 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[300][0m 0.56ms]
43.  
44. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[67][0m 0.28ms]
45.  
46. SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` &lt;= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) &lt;= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2021-07-22T09:56:05.718317Z","2021-07-22T09:56:05.718317Z",0,1,"09:56:05","09:56:05","09:56:05","09:56:05","[44m%","device",300,"location",67][0m 0.62ms]
47.  
48. 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.661,"max":0.73,"avg":0.696,"device_id":300,"debug":"[]"}[0m 0.58ms]
49.  
50. SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-07-22 11:56:05",0.696,300][0m 0.4ms]
51.  
52. SNMP Check response code: 0  
53. Modules status: Global+  
54. OS  
55. Device  
56.  
57. #### Load poller module core ####
58. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
59. .*.*.0 = 59706860
60. .*.*.0 = inrows1s2.hq
61. .*.*.0 = .*.4.1.3*.23
62. .*.*.0 = APC InRow DX 300mm (MB:v4.1.0 PF:v6.9.6 PN:apc_hw06_aos_696.bin AF1:v6.7.0 AN1:apc_hw06_rd3xx_670.bin MN:0N-9580AC HR:06 SN: JK2048002640 MD:11/20/2020)  
63.  
64. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m]
65. snmpEngineTime.0 = 597068
66. hrSystemUptime.0 = No Such Object available on this agent at this OID  
67.  
68. Uptime seconds: 597069  
69. Uptime:  6 days 21 hours 51 minutes 9 seconds
70.  
71. >> Runtime for poller module 'core': 0.0396 seconds with 4360 bytes
72. >> SNMP: [2/0.04s] MySQL: [0/0.00s]
73. #### Unload poller module core ####
74.  
75. Modules status: Global+  
76. OS  
77. Device  
78.  
79. #### Load poller module availability ####
80. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[300][0m 0.5ms]
81.  
82. Availability:
83. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[300][0m 0.47ms]
84.  
85. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[300,1626861365][0m 0.37ms]
86.  
87. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,545][0m 0.29ms]
88.  
89. 1 day : 100%
90. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[300,1626342965][0m 0.33ms]
91.  
92. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.855,546][0m 0.27ms]
93.  
94. 7 days : 99.855%
95. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[300,1624355765][0m 0.3ms]
96.  
97. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.957,547][0m 0.28ms]
98.  
99. 30 days : 99.957%
100. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[300,1595411765][0m 0.34ms]
101.  
102. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.996,548][0m 0.23ms]
103.  
104. 365 days : 99.996%
105.  
106. >> Runtime for poller module 'availability': 0.0060 seconds with 29952 bytes
107. >> SNMP: [0/0.00s] MySQL: [5/0.00s]
108. #### Unload poller module availability ####
109.  
110. Modules status: Global+  
111. OS  
112. Device  
113.  
114. #### Load poller module unix-agent ####
115.  
116. >> Runtime for poller module 'unix-agent': 0.0006 seconds with 5712 bytes
117. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
118. #### Unload poller module unix-agent ####
119.  
120. Modules status: Global+  
121. OS  
122. Device  
123.  
124. #### Load poller module os ####
125. Generic :(
126. Location: Salle NERD-HQ
127. Hardware: InRow DX 300mm
128. OS Version: AOS v6.9.6 / App v6.7.0
129. OS Features:
130. Serial:
131.  
132. >> Runtime for poller module 'os': 0.0023 seconds with 5024 bytes
133. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
134. #### Unload poller module os ####
135.  
136. Modules status: Global+  
137. OS  
138. Device  
139.  
140. #### Load poller module ipmi ####
141. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[300][0m 0.39ms]
142.  
143. array (
144. )  
145.  
146. >> Runtime for poller module 'ipmi': 0.0009 seconds with 1592 bytes
147. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
148. #### Unload poller module ipmi ####
149.  
150. Modules status: Global+  
151. OS  
152. Device  
153.  
154. #### Load poller module sensors ####
155. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[300][0m 0.37ms]
156.  
157. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["airflow",300][0m 0.35ms]
158.  
159. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.6' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.21'[0m]
160. .*.4.1.3*.*.* = 1606
161. .*.4.1.3*.*.* = 0  
162.  
163. Checking (snmp) airflow Total Airflow...
164. Checking (snmp) airflow Airflow...
165. 1606 cfm
166. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[1606,1609,"airflow",104873][0m 0.72ms]
167.  
168. 0 cfm
169. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["fanspeed",300][0m 0.54ms]
170.  
171. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.66'[0m]
172. .*.4.1.3*.*.* = 0  
173.  
174. Checking (snmp) fanspeed Condenser Fan Speed...
175. 0 rpm
176. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["power",300][0m 0.65ms]
177.  
178. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.7' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.8' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.24' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.25'[0m]
179. .*.4.1.3*.*.* = 109
180. .*.4.1.3*.*.* = 117
181. .*.4.1.3*.*.* = 0
182. .*.4.1.3*.*.* = 0  
183.  
184. Checking (snmp) power Total Air Side Cooling Demand...
185. Checking (snmp) power Total Sensible Cooling Power...
186. Checking (snmp) power Cool Demand...
187. Checking (snmp) power Cool Output...
188. 10.9 W
189. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[10.9,11.1,"power",104876][0m 0.71ms]
190.  
191. 11.7 W
192. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[11.7,10.1,"power",104877][0m 0.38ms]
193.  
194. 0 W
195. 0 W
196. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["state",300][0m 0.48ms]
197.  
198. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.1' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.2' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.3' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.4' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.5' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.6' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.7' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.8'[0m]
199. .*.4.1.3*.*.* = 4
200. .*.4.1.3*.*.* = 3
201. .*.4.1.3*.*.* = 0
202. .*.4.1.3*.*.* = 0
203. .*.4.1.3*.*.* = 0
204. .*.4.1.3*.*.* = 0
205. .*.4.1.3*.*.* = 0
206. .*.4.1.3*.*.* = 0  
207.  
208. Checking (snmp) state Active Flow Control Status...
209. Checking (snmp) state Mode...
210. Checking (snmp) state Shutdown Input State...
211. Checking (snmp) state Alarm Relay 1...
212. Checking (snmp) state Alarm Relay 2...
213. Checking (snmp) state Alarm Relay 3...
214. Checking (snmp) state Alarm Relay 4...
215. Checking (snmp) state Active Power Source...
216. 4 #
217. 3 #
218. 0 #
219. 0 #
220. 0 #
221. 0 #
222. 0 #
223. 0 #
224. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["temperature",300][0m 0.8ms]
225.  
226. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.1' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.3' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.9' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.11' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.13' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.16' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.18' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.26' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.28' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.30'[0m]
227. .*.4.1.3*.*.* = 215
228. .*.4.1.3*.*.* = 236
229. .*.4.1.3*.*.* = 254
230. .*.4.1.3*.*.* = 229
231. .*.4.1.3*.*.* = 309
232. .*.4.1.3*.*.* = No Such Instance currently exists at this OID
233. .*.4.1.3*.*.* = No Such Instance currently exists at this OID
234. .*.4.1.3*.*.* = 288
235. .*.4.1.3*.*.* = 220
236. .*.4.1.3*.*.* = 350  
237.  
238. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.32' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.34' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.36' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.38' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.40' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.50' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.52'[0m]
239. .*.4.1.3*.*.* = 267
240. .*.4.1.3*.*.* = No Such Instance currently exists at this OID
241. .*.4.1.3*.*.* = No Such Instance currently exists at this OID
242. .*.4.1.3*.*.* = No Such Instance currently exists at this OID
243. .*.4.1.3*.*.* = 229
244. .*.4.1.3*.*.* = 236
245. .*.4.1.3*.*.* = 293  
246.  
247. Checking (snmp) temperature Group Minimum Rack Temperature...
248. Checking (snmp) temperature Group Maximum Rack Temperature...
249. Checking (snmp) temperature Supply Temperature...
250. Checking (snmp) temperature Maximum Rack Inlet Temperature...
251. Checking (snmp) temperature Return Temperature...
252. Checking (snmp) temperature Room Temperature...
253. Checking (snmp) temperature Dew Point Temperature...
254. Checking (snmp) temperature Upper Supply Temperature...
255. Checking (snmp) temperature Lower Supply Temperature...
256. Checking (snmp) temperature Upper Return Temperature...
257. Checking (snmp) temperature Lower Return Temperature...
258. Checking (snmp) temperature Rack Inlet Temperature 1...
259. Checking (snmp) temperature Rack Inlet Temperature 2...
260. Checking (snmp) temperature Rack Inlet Temperature 3...
261. Checking (snmp) temperature Rack Inlet Temperature 4...
262. Checking (snmp) temperature Inlet Evap Coil Temperature...
263. Checking (snmp) temperature Outlet Evap Coil Temperature...
264. 21.5 C
265. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[21.5,22.4,"temperature",104888][0m 0.99ms]
266.  
267. 23.6 C
268. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[23.6,23.9,"temperature",104889][0m 0.41ms]
269.  
270. 25.4 C
271. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[25.4,25.6,"temperature",104890][0m 0.37ms]
272.  
273. 22.9 C
274. 30.9 C
275. 0 C
276. 0 C
277. 28.8 C
278. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[28.8,29,"temperature",104895][0m 0.37ms]
279.  
280. 22 C
281. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[22,22.2,"temperature",104896][0m 0.36ms]
282.  
283. 35 C
284. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[35,35.1,"temperature",104897][0m 0.44ms]
285.  
286. 26.7 C
287. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[26.7,26.8,"temperature",104898][0m 0.36ms]
288.  
289. 0 C
290. 0 C
291. 0 C
292. 22.9 C
293. 23.6 C
294. 29.3 C
295.  
296. >> Runtime for poller module 'sensors': 0.4965 seconds with 2512 bytes
297. >> SNMP: [6/0.48s] MySQL: [16/0.01s]
298. #### Unload poller module sensors ####
299.  
300. Modules status: Global+  
301. OS  
302. Device  
303.  
304. #### Load poller module processors ####
305. Attempting to initialize OS: apc  
306. OS initialized: LibreNMS\OS\Apc  
307. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[300][0m 0.35ms]
308.  
309.  
310. >> Runtime for poller module 'processors': 0.0021 seconds with 3824 bytes
311. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
312. #### Unload poller module processors ####
313.  
314. Modules status: Global+  
315. OS  
316. Device  
317.  
318. #### Load poller module mempools ####
319. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[300][0m 0.32ms]
320.  
321.  
322. >> Runtime for poller module 'mempools': 0.0018 seconds with 25192 bytes
323. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
324. #### Unload poller module mempools ####
325.  
326. Modules status: Global+  
327. OS  
328. Device  
329.  
330. #### Load poller module storage ####
331. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[300][0m 0.43ms]
332.  
333.  
334. >> Runtime for poller module 'storage': 0.0007 seconds with 1208 bytes
335. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
336. #### Unload poller module storage ####
337.  
338. Modules status: Global+  
339. OS  
340. Device  
341.  
342. #### Load poller module netstats ####
343.  ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'icmp'[0m]
344. icmpInMsgs.0 = 38150
345. icmpInErrors.0 = 0
346. icmpInDestUnreachs.0 = 10
347. icmpInTimeExcds.0 = 0
348. icmpInParmProbs.0 = 0
349. icmpInSrcQuenchs.0 = 0
350. icmpInRedirects.0 = 0
351. icmpInEchos.0 = 35927
352. icmpInEchoReps.0 = 2209
353. icmpInTimestamps.0 = 0
354. icmpInTimestampReps.0 = 0
355. icmpInAddrMasks.0 = 3
356. icmpInAddrMaskReps.0 = 0
357. icmpOutMsgs.0 = 38242
358. icmpOutErrors.0 = 0
359. icmpOutDestUnreachs.0 = 106
360. icmpOutTimeExcds.0 = 0
361. icmpOutParmProbs.0 = 0
362. icmpOutSrcQuenchs.0 = 0
363. icmpOutRedirects.0 = 0
364. icmpOutEchos.0 = 2209
365. icmpOutEchoReps.0 = 35927
366. icmpOutTimestamps.0 = 0
367. icmpOutTimestampReps.0 = 0
368. icmpOutAddrMasks.0 = 0
369. icmpOutAddrMaskReps.0 = 0
370. icmpStatsInMsgs.ipv4 = 38150
371. icmpStatsInMsgs.ipv6 = 888
372. icmpStatsInErrors.ipv4 = 0
373. icmpStatsInErrors.ipv6 = 0
374. icmpStatsOutMsgs.ipv4 = 38242
375. icmpStatsOutMsgs.ipv6 = 4
376. icmpStatsOutErrors.ipv4 = 0
377. icmpStatsOutErrors.ipv6 = 0
378. icmpMsgStatsInPkts.ipv4.0 = 2209
379. icmpMsgStatsInPkts.ipv4.3 = 10
380. icmpMsgStatsInPkts.ipv4.4 = 0
381. icmpMsgStatsInPkts.ipv4.5 = 0
382. icmpMsgStatsInPkts.ipv4.8 = 35927
383. icmpMsgStatsInPkts.ipv4.9 = 0
384. icmpMsgStatsInPkts.ipv4.10 = 0
385. icmpMsgStatsInPkts.ipv4.11 = 0
386. icmpMsgStatsInPkts.ipv4.12 = 0
387. icmpMsgStatsInPkts.ipv4.13 = 0
388. icmpMsgStatsInPkts.ipv4.14 = 0
389. icmpMsgStatsInPkts.ipv4.15 = 0
390. icmpMsgStatsInPkts.ipv4.16 = 0
391. icmpMsgStatsInPkts.ipv4.17 = 3
392. icmpMsgStatsInPkts.ipv4.18 = 0
393. icmpMsgStatsInPkts.ipv6.1 = 0
394. icmpMsgStatsInPkts.ipv6.2 = 0
395. icmpMsgStatsInPkts.ipv6.3 = 0
396. icmpMsgStatsInPkts.ipv6.4 = 0
397. icmpMsgStatsInPkts.ipv6.128 = 0
398. icmpMsgStatsInPkts.ipv6.129 = 0
399. icmpMsgStatsInPkts.ipv6.130 = 0
400. icmpMsgStatsInPkts.ipv6.131 = 0
401. icmpMsgStatsInPkts.ipv6.132 = 0
402. icmpMsgStatsInPkts.ipv6.133 = 0
403. icmpMsgStatsInPkts.ipv6.134 = 0
404. icmpMsgStatsInPkts.ipv6.135 = 426
405. icmpMsgStatsInPkts.ipv6.136 = 462
406. icmpMsgStatsInPkts.ipv6.137 = 0
407. icmpMsgStatsOutPkts.ipv4.0 = 35927
408. icmpMsgStatsOutPkts.ipv4.3 = 106
409. icmpMsgStatsOutPkts.ipv4.4 = 0
410. icmpMsgStatsOutPkts.ipv4.5 = 0
411. icmpMsgStatsOutPkts.ipv4.8 = 2209
412. icmpMsgStatsOutPkts.ipv4.9 = 0
413. icmpMsgStatsOutPkts.ipv4.10 = 0
414. icmpMsgStatsOutPkts.ipv4.11 = 0
415. icmpMsgStatsOutPkts.ipv4.12 = 0
416. icmpMsgStatsOutPkts.ipv4.13 = 0
417. icmpMsgStatsOutPkts.ipv4.14 = 0
418. icmpMsgStatsOutPkts.ipv4.15 = 0
419. icmpMsgStatsOutPkts.ipv4.16 = 0
420. icmpMsgStatsOutPkts.ipv4.17 = 0
421. icmpMsgStatsOutPkts.ipv4.18 = 0
422. icmpMsgStatsOutPkts.ipv6.1 = 0
423. icmpMsgStatsOutPkts.ipv6.2 = 0
424. icmpMsgStatsOutPkts.ipv6.3 = 0
425. icmpMsgStatsOutPkts.ipv6.4 = 0
426. icmpMsgStatsOutPkts.ipv6.128 = 0
427. icmpMsgStatsOutPkts.ipv6.129 = 0
428. icmpMsgStatsOutPkts.ipv6.130 = 0
429. icmpMsgStatsOutPkts.ipv6.131 = 4
430. icmpMsgStatsOutPkts.ipv6.132 = 0
431. icmpMsgStatsOutPkts.ipv6.133 = 0
432. icmpMsgStatsOutPkts.ipv6.134 = 0
433. icmpMsgStatsOutPkts.ipv6.135 = 0
434. icmpMsgStatsOutPkts.ipv6.136 = 0
435. icmpMsgStatsOutPkts.ipv6.137 = 0  
436.  
437.  IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m]
438. ipForwDatagrams.0 = 0
439. ipInDelivers.0 = 227113
440. ipInReceives.0 = 352656
441. ipOutRequests.0 = 166704
442. ipInDiscards.0 = 0
443. ipOutDiscards.0 = 0
444. ipOutNoRoutes.0 = 0
445. ipReasmReqds.0 = 0
446. ipReasmOKs.0 = 0
447. ipReasmFails.0 = 0
448. ipFragOKs.0 = 0
449. ipFragFails.0 = 0
450. ipFragCreates.0 = 0
451. ipInUnknownProtos.0 = 0
452. ipInHdrErrors.0 = 0
453. ipInAddrErrors.0 = 125540  
454.  
455.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
456. No Such Object available on this agent at this OID  
457.  
458.  SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'snmp'[0m]
459. snmpInPkts.0 = 123703
460. snmpOutPkts.0 = 123702
461. snmpInBadVersions.0 = 0
462. snmpInBadCommunityNames.0 = 0
463. snmpInBadCommunityUses.0 = 46
464. snmpInASNParseErrs.0 = 0
465. snmpInTooBigs.0 = 0
466. snmpInNoSuchNames.0 = 0
467. snmpInBadValues.0 = 0
468. snmpInReadOnlys.0 = 0
469. snmpInGenErrs.0 = 0
470. snmpInTotalReqVars.0 = 175788
471. snmpInTotalSetVars.0 = 0
472. snmpInGetRequests.0 = 36364
473. snmpInGetNexts.0 = 17043
474. snmpInSetRequests.0 = 0
475. snmpInGetResponses.0 = 0
476. snmpInTraps.0 = 0
477. snmpOutTooBigs.0 = 0
478. snmpOutNoSuchNames.0 = 16
479. snmpOutBadValues.0 = 0
480. snmpOutGenErrs.0 = 0
481. snmpOutGetRequests.0 = 0
482. snmpOutGetNexts.0 = 0
483. snmpOutSetRequests.0 = 0
484. snmpOutGetResponses.0 = 123704
485. snmpOutTraps.0 = 0
486. snmpEnableAuthenTraps.0 = enabled
487. snmpSilentDrops.0 = 0
488. snmpProxyDrops.0 = 0  
489.  
490.  TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m]
491. tcpActiveOpens.0 = 0
492. tcpPassiveOpens.0 = 874
493. tcpAttemptFails.0 = 3
494. tcpEstabResets.0 = 767
495. tcpCurrEstab.0 = 0
496. tcpInSegs.0 = 6125
497. tcpOutSegs.0 = 2981
498. tcpRetransSegs.0 = 0
499. tcpInErrs.0 = 0
500. tcpOutRsts.0 = 974  
501.  
502.  TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m]
503. tcpHCOutSegs.0 = 2981
504. mib-* = 123738  
505.  
506.  UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m]
507. udpInDatagrams.0 = 123739
508. udpOutDatagrams.0 = 128720
509. udpInErrors.0 = 0
510. udpNoPorts.0 = 536195  
511.  
512.  
513.  
514. >> Runtime for poller module 'netstats': 0.5185 seconds with 1544 bytes
515. >> SNMP: [7/0.52s] MySQL: [0/0.00s]
516. #### Unload poller module netstats ####
517.  
518. Modules status: Global+  
519. OS  
520. Device  
521.  
522. #### Load poller module hr-mib ####
523. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
524. hrSystemProcesses.0 = No Such Object available on this agent at this OID
525. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
526.  
527.  
528.  
529. >> Runtime for poller module 'hr-mib': 0.0178 seconds with 1208 bytes
530. >> SNMP: [1/0.02s] MySQL: [0/0.00s]
531. #### Unload poller module hr-mib ####
532.  
533. Modules status: Global+  
534. OS  
535. Device  
536.  
537. #### Load poller module ucd-mib ####
538. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'systemStats'[0m]
539. systemStats = No Such Object available on this agent at this OID  
540.  
541. Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID  
542. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
543. laLoadInt.1 = No Such Object available on this agent at this OID
544. laLoadInt.2 = No Such Object available on this agent at this OID
545. laLoadInt.3 = No Such Object available on this agent at this OID  
546.  
547.  
548. >> Runtime for poller module 'ucd-mib': 0.0734 seconds with 832 bytes
549. >> SNMP: [2/0.07s] MySQL: [0/0.00s]
550. #### Unload poller module ucd-mib ####
551.  
552. Modules status: Global+  
553. OS  
554. Device  
555.  
556. #### Load poller module ipSystemStats ####
557. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
558. ipSystemStatsInReceives.ipv4 = 0
559. ipSystemStatsInReceives.ipv6 = 491655
560. ipSystemStatsHCInReceives.ipv4 = 0
561. ipSystemStatsHCInReceives.ipv6 = 491655
562. ipSystemStatsInOctets.ipv4 = 124488621
563. ipSystemStatsInOctets.ipv6 = 0
564. ipSystemStatsHCInOctets.ipv4 = 124488621
565. ipSystemStatsHCInOctets.ipv6 = 0
566. ipSystemStatsInHdrErrors.ipv4 = 0
567. ipSystemStatsInHdrErrors.ipv6 = 0
568. ipSystemStatsInNoRoutes.ipv4 = 0
569. ipSystemStatsInNoRoutes.ipv6 = 0
570. ipSystemStatsInAddrErrors.ipv4 = 0
571. ipSystemStatsInAddrErrors.ipv6 = 0
572. ipSystemStatsInUnknownProtos.ipv4 = 0
573. ipSystemStatsInUnknownProtos.ipv6 = 0
574. ipSystemStatsInTruncatedPkts.ipv4 = 0
575. ipSystemStatsInTruncatedPkts.ipv6 = 0
576. ipSystemStatsInForwDatagrams.ipv4 = 0
577. ipSystemStatsInForwDatagrams.ipv6 = 0
578. ipSystemStatsHCInForwDatagrams.ipv4 = 0
579. ipSystemStatsHCInForwDatagrams.ipv6 = 0
580. ipSystemStatsReasmReqds.ipv4 = 0
581. ipSystemStatsReasmReqds.ipv6 = 0
582. ipSystemStatsReasmOKs.ipv4 = 0
583. ipSystemStatsReasmOKs.ipv6 = 0
584. ipSystemStatsReasmFails.ipv4 = 0
585. ipSystemStatsReasmFails.ipv6 = 0
586. ipSystemStatsInDiscards.ipv4 = 0
587. ipSystemStatsInDiscards.ipv6 = 0
588. ipSystemStatsInDelivers.ipv4 = 227129
589. ipSystemStatsInDelivers.ipv6 = 477976
590. ipSystemStatsHCInDelivers.ipv4 = 0
591. ipSystemStatsHCInDelivers.ipv6 = 491655
592. ipSystemStatsOutRequests.ipv4 = 166720
593. ipSystemStatsOutRequests.ipv6 = 5832
594. ipSystemStatsHCOutRequests.ipv4 = 166720
595. ipSystemStatsHCOutRequests.ipv6 = 5832
596. ipSystemStatsOutNoRoutes.ipv4 = 0
597. ipSystemStatsOutNoRoutes.ipv6 = 0
598. ipSystemStatsOutForwDatagrams.ipv4 = 0
599. ipSystemStatsOutForwDatagrams.ipv6 = 0
600. ipSystemStatsHCOutForwDatagrams.ipv4 = 0
601. ipSystemStatsHCOutForwDatagrams.ipv6 = 0
602. ipSystemStatsOutDiscards.ipv4 = 0
603. ipSystemStatsOutDiscards.ipv6 = 0
604. ipSystemStatsOutFragReqds.ipv4 = 0
605. ipSystemStatsOutFragReqds.ipv6 = 0
606. ipSystemStatsOutFragOKs.ipv4 = 0
607. ipSystemStatsOutFragOKs.ipv6 = 0
608. ipSystemStatsOutFragFails.ipv4 = 0
609. ipSystemStatsOutFragFails.ipv6 = 0
610. ipSystemStatsOutFragCreates.ipv4 = 0
611. ipSystemStatsOutFragCreates.ipv6 = 0
612. ipSystemStatsOutTransmits.ipv4 = 0
613. ipSystemStatsOutTransmits.ipv6 = 0
614. ipSystemStatsHCOutTransmits.ipv4 = 0
615. ipSystemStatsHCOutTransmits.ipv6 = 0
616. ipSystemStatsOutOctets.ipv4 = 32660374
617. ipSystemStatsOutOctets.ipv6 = 0
618. ipSystemStatsHCOutOctets.ipv4 = 32660631
619. ipSystemStatsHCOutOctets.ipv6 = 0
620. ipSystemStatsInMcastPkts.ipv4 = 0
621. ipSystemStatsInMcastPkts.ipv6 = 477138
622. ipSystemStatsHCInMcastPkts.ipv4 = 0
623. ipSystemStatsHCInMcastPkts.ipv6 = 477138
624. ipSystemStatsInMcastOctets.ipv4 = 0
625. ipSystemStatsInMcastOctets.ipv6 = 0
626. ipSystemStatsHCInMcastOctets.ipv4 = 0
627. ipSystemStatsHCInMcastOctets.ipv6 = 0
628. ipSystemStatsOutMcastPkts.ipv4 = 2
629. ipSystemStatsOutMcastPkts.ipv6 = 4992
630. ipSystemStatsHCOutMcastPkts.ipv4 = 2
631. ipSystemStatsHCOutMcastPkts.ipv6 = 4992
632. ipSystemStatsOutMcastOctets.ipv4 = 0
633. ipSystemStatsOutMcastOctets.ipv6 = 0
634. ipSystemStatsHCOutMcastOctets.ipv4 = 0
635. ipSystemStatsHCOutMcastOctets.ipv6 = 0
636. ipSystemStatsInBcastPkts.ipv4 = 184535
637. ipSystemStatsInBcastPkts.ipv6 = 0
638. ipSystemStatsHCInBcastPkts.ipv4 = 184535
639. ipSystemStatsHCInBcastPkts.ipv6 = 0
640. ipSystemStatsOutBcastPkts.ipv4 = 6
641. ipSystemStatsOutBcastPkts.ipv6 = 0
642. ipSystemStatsHCOutBcastPkts.ipv4 = 6
643. ipSystemStatsHCOutBcastPkts.ipv6 = 0
644. ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00
645. ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00
646. ipSystemStatsRefreshRate.ipv4 = 0
647. ipSystemStatsRefreshRate.ipv6 = 0  
648.  
649. ipv4 ipv6
650.  
651. >> Runtime for poller module 'ipSystemStats': 0.3241 seconds with 16656 bytes
652. >> SNMP: [1/0.32s] MySQL: [0/0.00s]
653. #### Unload poller module ipSystemStats ####
654.  
655. Modules status: Global+  
656. OS  
657. Device  
658.  
659. #### Load poller module ports ####
660. SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[300][0m 0.95ms]
661.  
662. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
663. ifXEntry = No Such Object available on this agent at this OID  
664.  
665. Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
666. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'ifEntry'[0m]
667. ifIndex.1 = 1
668. ifIndex.2 = 2
669. ifDescr.1 = LOOPBACK
670. ifDescr.2 = vmac0
671. ifType.1 = softwareLoopback
672. ifType.2 = ethernetCsmacd
673. ifMtu.1 = 1500
674. ifMtu.2 = 1500
675. ifSpeed.1 = 0
676. ifSpeed.2 = 100000000
677. ifPhysAddress.1 =
678. ifPhysAddress.2 = 28:29:86:45:c6:6a
679. ifAdminStatus.1 = up
680. ifAdminStatus.2 = up
681. ifOperStatus.1 = up
682. ifOperStatus.2 = up
683. ifLastChange.1 = 0
684. ifLastChange.2 = 25
685. ifInOctets.1 = 0
686. ifInOctets.2 = 124489757
687. ifInUcastPkts.1 = 0
688. ifInUcastPkts.2 = 183182
689. ifInNUcastPkts.1 = 0
690. ifInNUcastPkts.2 = 184535
691. ifInDiscards.1 = 0
692. ifInDiscards.2 = 0
693. ifInErrors.1 = 0
694. ifInErrors.2 = 0
695. ifInUnknownProtos.1 = 0
696. ifInUnknownProtos.2 = 0
697. ifOutOctets.1 = 0
698. ifOutOctets.2 = 32662835
699. ifOutUcastPkts.1 = 0
700. ifOutUcastPkts.2 = 186791
701. ifOutNUcastPkts.1 = 0
702. ifOutNUcastPkts.2 = 8
703. ifOutDiscards.1 = 0
704. ifOutDiscards.2 = 0
705. ifOutErrors.1 = 0
706. ifOutErrors.2 = 0
707. ifOutQLen.1 = 0
708. ifOutQLen.2 = 0
709. ifSpecific.1 = zeroDotZero
710. ifSpecific.2 = zeroDotZero  
711.  
712. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
713. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
714.  
715. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
716. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
717. dot1qPvid = No Such Object available on this agent at this OID  
718.  
719. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
720. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[300][0m 0.64ms]
721.  
722. array (
723.   1 =>
724.   array (
725.     'ifIndex' => '1',
726.     'ifDescr' => 'LOOPBACK',
727.     'ifType' => 'softwareLoopback',
728.     'ifMtu' => '1500',
729.     'ifSpeed' => '0',
730.     'ifPhysAddress' => '',
731.     'ifAdminStatus' => 'up',
732.     'ifOperStatus' => 'up',
733.     'ifLastChange' => '0',
734.     'ifInOctets' => '0',
735.     'ifInUcastPkts' => '0',
736.     'ifInNUcastPkts' => '0',
737.     'ifInDiscards' => '0',
738.     'ifInErrors' => '0',
739.     'ifInUnknownProtos' => '0',
740.     'ifOutOctets' => '0',
741.     'ifOutUcastPkts' => '0',
742.     'ifOutNUcastPkts' => '0',
743.     'ifOutDiscards' => '0',
744.     'ifOutErrors' => '0',
745.     'ifOutQLen' => '0',
746.     'ifSpecific' => 'zeroDotZero',
747.   ),
748.   2 =>
749.   array (
750.     'ifIndex' => '2',
751.     'ifDescr' => 'vmac0',
752.     'ifType' => 'ethernetCsmacd',
753.     'ifMtu' => '1500',
754.     'ifSpeed' => '100000000',
755.     'ifPhysAddress' => '28:29:86:45:c6:6a',
756.     'ifAdminStatus' => 'up',
757.     'ifOperStatus' => 'up',
758.     'ifLastChange' => '25',
759.     'ifInOctets' => '124489757',
760.     'ifInUcastPkts' => '183182',
761.     'ifInNUcastPkts' => '184535',
762.     'ifInDiscards' => '0',
763.     'ifInErrors' => '0',
764.     'ifInUnknownProtos' => '0',
765.     'ifOutOctets' => '32662835',
766.     'ifOutUcastPkts' => '186791',
767.     'ifOutNUcastPkts' => '8',
768.     'ifOutDiscards' => '0',
769.     'ifOutErrors' => '0',
770.     'ifOutQLen' => '0',
771.     'ifSpecific' => 'zeroDotZero',
772.   ),
773. )  
774.  valid  
775.  valid  
776.  
777. Port LOOPBACK: LOOPBACK (1 / #1655326) ifInOctets  
778. ifOutOctets  
779. ifInUcastPkts  
780. ifOutUcastPkts  
781. ifInBroadcastPkts  
782. ifOutBroadcastPkts  
783. ifInMulticastPkts  
784. ifOutMulticastPkts  
785. ifSpeed  
786. VLAN =   Using ifDescr as ifAlias  
787.  Using ifDescr as ifName  
788. LOOPBACK
789.  ifInOctets (0 B) 0 Bps 282 secs  
790.  
791.  ifOutOctets (0 B) 0 Bps 282 secs  
792.  
793.  ifInErrors (0 B) 0 Bps 282 secs  
794.  
795.  ifOutErrors (0 B) 0 Bps 282 secs  
796.  
797.  ifInUcastPkts (0 B) 0 Bps 282 secs  
798.  
799.  ifOutUcastPkts (0 B) 0 Bps 282 secs  
800.  
801.  ifInNUcastPkts (0 B) 0 Bps 282 secs  
802.  
803.  ifOutNUcastPkts (0 B) 0 Bps 282 secs  
804.  
805.  ifInDiscards (0 B) 0 Bps 282 secs  
806.  
807.  ifOutDiscards (0 B) 0 Bps 282 secs  
808.  
809.  ifInUnknownProtos (0 B) 0 Bps 282 secs  
810.  
811.  ifInBroadcastPkts (0 B) 0 Bps 282 secs  
812.  
813.  ifOutBroadcastPkts (0 B) 0 Bps 282 secs  
814.  
815.  ifInMulticastPkts (0 B) 0 Bps 282 secs  
816.  
817.  ifOutMulticastPkts (0 B) 0 Bps 282 secs  
818. bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,1626947767,1626947485,282,1655326][0m 0.56ms]
819.  
820. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1655326][0m 0.31ms]
821.  
822. 1 updated  
823.  
824. Port vmac0: vmac0 (2 / #1655327) ifInOctets  
825. ifOutOctets  
826. ifInUcastPkts  
827. ifOutUcastPkts  
828. ifInBroadcastPkts  
829. ifOutBroadcastPkts  
830. ifInMulticastPkts  
831. ifOutMulticastPkts  
832. ifSpeed  
833. VLAN =   Using ifDescr as ifAlias  
834.  Using ifDescr as ifName  
835. vmac0
836.  ifInOctets (85287 B) 302.43617021277 Bps 282 secs  
837.  
838.  ifOutOctets (78605 B) 278.74113475177 Bps 282 secs  
839.  
840.  ifInErrors (0 B) 0 Bps 282 secs  
841.  
842.  ifOutErrors (0 B) 0 Bps 282 secs  
843.  
844.  ifInUcastPkts (373 B) 1.322695035461 Bps 282 secs  
845.  
846.  ifOutUcastPkts (375 B) 1.3297872340426 Bps 282 secs  
847.  
848.  ifInNUcastPkts (87 B) 0.30851063829787 Bps 282 secs  
849.  
850.  ifOutNUcastPkts (0 B) 0 Bps 282 secs  
851.  
852.  ifInDiscards (0 B) 0 Bps 282 secs  
853.  
854.  ifOutDiscards (0 B) 0 Bps 282 secs  
855.  
856.  ifInUnknownProtos (0 B) 0 Bps 282 secs  
857.  
858.  ifInBroadcastPkts (0 B) 0 Bps 282 secs  
859.  
860.  ifOutBroadcastPkts (0 B) 0 Bps 282 secs  
861.  
862.  ifInMulticastPkts (0 B) 0 Bps 282 secs  
863.  
864.  ifOutMulticastPkts (0 B) 0 Bps 282 secs  
865. bps(2.42 Kbps/2.23 Kbps)bytes(83.29 KiB/76.76 KiB)pkts(1.32 pps/1.33 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["124489757",124404470,302.43617021276594,85287,"32662835",32584230,278.7411347517731,78605,"0",0,0,0,"0",0,0,0,"183182",182809,1.322695035460993,373,"186791",186416,1.3297872340425532,375,1626947767,1626947485,282,1655327][0m 0.38ms]
866.  
867. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["184535",184448,0.30851063829787234,87,"8",8,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1655327][0m 0.42ms]
868.  
869. 2 updated  
870.  
871. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1626947767,1626947485,null][0m 0.27ms]
872.  
873. 0 updated  
874.  
875. >> Runtime for poller module 'ports': 0.3995 seconds with 9184 bytes
876. >> SNMP: [4/0.39s] MySQL: [5/0.00s]
877. #### Unload poller module ports ####
878.  
879. Modules status: Global+  
880. OS  
881. Device  
882.  
883. #### Load poller module customoid ####
884. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[300][0m 0.37ms]
885.  
886. array (
887.   'customoid_id' => 8,
888.   'device_id' => 300,
889.   'customoid_descr' => 'Superheat C°',
890.   'customoid_deleted' => 0,
891.   'customoid_current' => 5.7,
892.   'customoid_prev' => 5.7,
893.   'customoid_oid' => '1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.54',
894.   'customoid_datatype' => '',
895.   'customoid_unit' => 'C°',
896.   'customoid_divisor' => 10,
897.   'customoid_multiplier' => 1,
898.   'customoid_limit' => NULL,
899.   'customoid_limit_warn' => NULL,
900.   'customoid_limit_low' => 1.0,
901.   'customoid_limit_low_warn' => NULL,
902.   'customoid_alert' => 0,
903.   'customoid_passed' => 1,
904.   'lastupdate' => '2021-07-22 11:51:25',
905.   'user_func' => NULL,
906. )  
907. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.54'[0m]
908. 58  
909.  
910. Custom OID Superheat C°: 5.8 C°
911. SQL[[1;33mUPDATE `customoids` set `customoid_current`=?,`lastupdate`=NOW(),`customoid_prev`=? WHERE `customoid_id` = ? [0;33m[5.8,5.7,8][0m 0.59ms]
912.  
913.  
914. >> Runtime for poller module 'customoid': 0.0325 seconds with 2304 bytes
915. >> SNMP: [1/0.03s] MySQL: [2/0.00s]
916. #### Unload poller module customoid ####
917.  
918. Modules status: Global+  
919. OS  
920. Device-  
921. Module [ bgp-peers ] disabled on host.
922.  
923. Modules status: Global-  
924. OS  
925. Device  
926. Module [ junose-atm-vp ] disabled globally.
927.  
928. Modules status: Global-  
929. OS  
930. Device  
931. Module [ printer-supplies ] disabled globally.
932.  
933. Modules status: Global+  
934. OS  
935. Device  
936.  
937. #### Load poller module ucd-diskio ####
938. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[300][0m 0.3ms]
939.  
940.  
941. >> Runtime for poller module 'ucd-diskio': 0.0007 seconds with 1160 bytes
942. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
943. #### Unload poller module ucd-diskio ####
944.  
945. Modules status: Global-  
946. OS  
947. Device  
948. Module [ wifi ] disabled globally.
949.  
950. Modules status: Global+  
951. OS  
952. Device-  
953. Module [ wireless ] disabled on host.
954.  
955. Modules status: Global+  
956. OS  
957. Device-  
958. Module [ ospf ] disabled on host.
959.  
960. Modules status: Global-  
961. OS  
962. Device  
963. Module [ cisco-ipsec-flow-monitor ] disabled globally.
964.  
965. Modules status: Global-  
966. OS  
967. Device  
968. Module [ cisco-remote-access-monitor ] disabled globally.
969.  
970. Modules status: Global-  
971. OS  
972. Device  
973. Module [ cisco-cef ] disabled globally.
974.  
975. Modules status: Global-  
976. OS  
977. Device  
978. Module [ cisco-sla ] disabled globally.
979.  
980. Modules status: Global-  
981. OS  
982. Device  
983. Module [ cisco-mac-accounting ] disabled globally.
984.  
985. Modules status: Global-  
986. OS  
987. Device  
988. Module [ cipsec-tunnels ] disabled globally.
989.  
990. Modules status: Global-  
991. OS  
992. Device  
993. Module [ cisco-ace-loadbalancer ] disabled globally.
994.  
995. Modules status: Global-  
996. OS  
997. Device  
998. Module [ cisco-ace-serverfarms ] disabled globally.
999.  
1000. Modules status: Global-  
1001. OS  
1002. Device  
1003. Module [ cisco-asa-firewall ] disabled globally.
1004.  
1005. Modules status: Global-  
1006. OS  
1007. Device  
1008. Module [ cisco-voice ] disabled globally.
1009.  
1010. Modules status: Global-  
1011. OS  
1012. Device  
1013. Module [ cisco-cbqos ] disabled globally.
1014.  
1015. Modules status: Global-  
1016. OS  
1017. Device  
1018. Module [ cisco-otv ] disabled globally.
1019.  
1020. Modules status: Global-  
1021. OS  
1022. Device  
1023. Module [ cisco-qfp ] disabled globally.
1024.  
1025. Modules status: Global-  
1026. OS  
1027. Device  
1028. Module [ cisco-vpdn ] disabled globally.
1029.  
1030. Modules status: Global-  
1031. OS  
1032. Device  
1033. Module [ nac ] disabled globally.
1034.  
1035. Modules status: Global-  
1036. OS  
1037. Device  
1038. Module [ netscaler-vsvr ] disabled globally.
1039.  
1040. Modules status: Global+  
1041. OS  
1042. Device-  
1043. Module [ aruba-controller ] disabled on host.
1044.  
1045. Modules status: Global+  
1046. OS  
1047. Device  
1048.  
1049. #### Load poller module entity-physical ####
1050. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[300][0m 0.27ms]
1051.  
1052.  
1053. >> Runtime for poller module 'entity-physical': 0.0007 seconds with 1304 bytes
1054. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
1055. #### Unload poller module entity-physical ####
1056.  
1057. Modules status: Global-  
1058. OS  
1059. Device-  
1060. Module [ entity-state ] disabled on host.
1061.  
1062. Modules status: Global+  
1063. OS  
1064. Device-  
1065. Module [ applications ] disabled on host.
1066.  
1067. Modules status: Global+  
1068. OS  
1069. Device  
1070.  
1071. #### Load poller module mib ####
1072.  
1073. Warning: include(includes/polling/mib.inc.php): failed to open stream: No such file or directory in /opt/librenms/includes/polling/functions.inc.php on line 317
1074.  
1075. Warning: include(): Failed opening 'includes/polling/mib.inc.php' for inclusion (include_path='.:/usr/share/php7') in /opt/librenms/includes/polling/functions.inc.php on line 317
1076.  
1077. >> Runtime for poller module 'mib': 0.0000 seconds with 0 bytes
1078. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
1079. #### Unload poller module mib ####
1080.  
1081. Modules status: Global+  
1082. OS  
1083. Device-  
1084. Module [ stp ] disabled on host.
1085.  
1086. Modules status: Global+  
1087. OS  
1088. Device  
1089.  
1090. #### Load poller module ntp ####
1091.  
1092. >> Runtime for poller module 'ntp': 0.0001 seconds with 80 bytes
1093. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
1094. #### Unload poller module ntp ####
1095.  
1096. Modules status: Global-  
1097. OS  
1098. Device  
1099. Module [ loadbalancers ] disabled globally.
1100.  
1101. Modules status: Global-  
1102. OS  
1103. Device  
1104. Module [ mef ] disabled globally.
1105.  
1106. Modules status: Global+  
1107. OS  
1108. Device-  
1109. Module [ mpls ] disabled on host.
1110.  
1111. Modules status: Global-  
1112. OS  
1113. Device  
1114. Module [ toner ] disabled globally.
1115.  
1116. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[300][0m 0.37ms]
1117.  
1118.  
1119. SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[597069,0.696,2.971,300][0m 0.74ms]
1120.  
1121. Updating inrows1s2.hq.nerd.lan  
1122.  
1123. Polled in 2.971 seconds
1124. ### Start Device Groups ###
1125. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[300][0m 0.44ms]
1126.  
1127. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.26ms]
1128.  
1129. SQL[[1;33mselect `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (2, 3, 4) [0;33m[][0m 0.59ms]
1130.  
1131. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` REGEXP ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".*riv.*",300][0m 0.39ms]
1132.  
1133. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` REGEXP ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".*nik.*",300][0m 0.26ms]
1134.  
1135. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` REGEXP ? OR `devices`.`hostname` REGEXP ? OR `devices`.`hostname` REGEXP ? OR `devices`.`location_id` REGEXP ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".*tlc.*",".*tc.*",".*pa6.*",".*Waldeck.*",300][0m 0.26ms]
1136.  
1137. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[300][0m 0.26ms]
1138.  
1139. Groups Added:  
1140. Groups Removed:  
1141. ### End Device Groups, runtime: 0.0092s ###
1142.  
1143. #### Start Alerts ####
1144. SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` &lt;= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) &lt;= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2021-07-22T09:56:07.688412Z","2021-07-22T09:56:07.688412Z",0,1,"09:56:07","09:56:07","09:56:07","09:56:07","[44m%","device",300,"location",67][0m 0.59ms]
1145.  
1146. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[300][0m 0.35ms]
1147.  
1148. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
1149.         LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?)
1150.         LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?))
1151.         LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?))
1152.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
1153.         WHERE a.disabled = 0 AND (
1154.             (d.device_id IS NULL AND g.group_id IS NULL)
1155.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
1156.             OR (a.invert_map = 1  AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL))
1157.         ) [0;33m[300,300,300,300,300,300,300,300][0m 0.99ms]
1158.  
1159. Rule [0;35m#1 (Devices up/down):[0m  
1160. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[300][0m 0.32ms]
1161.  
1162. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,300][0m 0.3ms]
1163.  
1164. Status: [0;34mNOCHG[0m
1165. Rule [0;35m#2 (Device rebooted):[0m  
1166. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed bgpPeers.bgpPeerState = "established" xss=removed xss=removed xss=removed>= "85" ) [0;33m[300][0m 0.43ms]
1167.  
1168. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,300][0m 0.32ms]
1169.  
1170. Status: [0;34mNOCHG[0m
1171. Rule [0;35m#7 (Sensor over limit):[0m  
1172. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit [0;33m[300][0m 0.52ms]
1173.  
1174. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,300][0m 0.27ms]
1175.  
1176. Status: [0;34mNOCHG[0m
1177. Rule [0;35m#8 (Sensor under limit):[0m  
1178. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= 95 [0;33m[300][0m 0.52ms]
1179.  
1180. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,300][0m 0.3ms]
1181.  
1182. Status: [0;34mNOCHG[0m
1183. #### End Alerts ####
1184. ./poller.php inrows1s2.hq.nerd.lan 2021-07-22 11:56:07 - 1 devices polled in 3.160 secs  
1185. SNMP [25/1.90s]: Get[13/0.65s] Getnext[4/0.13s] Walk[8/1.12s]
1186. MySQL [46/0.03s]: Cell[10/0.00s] Row[-10/-0.00s] Rows[23/0.01s] Column[1/0.00s] Update[21/0.01s] Insert[1/0.00s] Delete[0/0.00s]
1187.