1. LibreNMS Poller
2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.32ms]
3.  
4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.28ms]
5.  
6. SQL[[1;33mselect version() [0;33m[][0m 0.12ms]
7.  
8. ===================================
9. Version info:
10. Commit SHA: 785b0bae537cd7fa6bcabee67b27bd8d4f35704f
11. Commit Date: 1641303027
12. DB Schema: 2021_11_29_165436_improve_ports_search_index (229)
13. PHP: 7.4.6
14. MySQL: 10.3.28-MariaDB
15. RRDTool: 1.7.0
16. SNMP: 5.8
17. ==================================DEBUG!
18. Updating os_def.cache  
19. Starting polling run:
20.  
21. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.240.254.136' ORDER BY `device_id` ASC [0;33m[][0m 0.73ms]
22.  
23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[784][0m 0.38ms]
24.  
25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[784][0m 0.25ms]
26.  
27. Attempting to initialize OS: linux  
28. Attempting to initialize Group OS: unix  
29. OS initialized: LibreNMS\OS\Shared\Unix  
30. Hostname:    10.240.254.136
31. Device ID:   784
32. OS:          linux
33.  (unix)
34.  
35. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '10.240.254.136'
36.  
37. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.62/0.63/0.64  
38. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
39. SNMPv2-MIB::sysObjectID.0 = NET-SNMP-MIB::netSnmpAgentOIDs.10
40.  
41.  
42. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.62,0.64,0.63,3,3,0,784,"2022-01-19 13:56:20"][0m 0.61ms]
43.  
44. SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[784][0m 0.38ms]
45.  
46. Modules status: Global+  
47. OS  
48. Device  
49.  
50. #### Load poller module core ####
51. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m]  
52. .*.*.0 = Linux MCU3000 4.19.100 #1 SMP Thu Nov 4 11:17:12 UTC 2021 armv7l
53. .*.*.0 = .*.4.1.8*
54. .*.*.0 = 276490
55. .*.*.0 = sysName
56.  
57.  
58. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
59. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 2765
60. HOST-RESOURCES-MIB::hrSystemUptime.0 = 354294115
61.  
62.  
63. Uptime seconds: 3542941
64.  
65. Uptime:  41 days 9 minutes 1 second
66. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[3542941,784][0m 0.62ms]
67.  
68.  
69. >> Runtime for poller module 'core': 0.1015 seconds with 57912 bytes
70. >> [0;36mSNMP[0m: [2/0.10s] [1;33mMySQL[0m: [1/0.01s]  
71. #### Unload poller module core ####
72.  
73. Modules status: Global-  
74. OS  
75. Device  
76. Module [ unix-agent ] disabled globally.
77.  
78. Modules status: Global+  
79. OS  
80. Device  
81.  
82. #### Load poller module os ####
83. Generic :(
84. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[475][0m 0.44ms]
85.  
86. Location: sysLocation
87. Hardware: Generic ARMv7
88. OS Version: 4.19.100
89. OS Features:
90. Serial:
91.  
92. >> Runtime for poller module 'os': 0.0022 seconds with 173576 bytes
93. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
94. #### Unload poller module os ####
95.  
96. Modules status: Global+  
97. OS  
98. Device  
99.  
100. #### Load poller module availability ####
101. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[784][0m 0.4ms]
102.  
103. Availability:
104. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[784][0m 0.38ms]
105.  
106. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[784,1642510581][0m 0.45ms]
107.  
108. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,3041][0m 0.24ms]
109.  
110. 1 day : 100%
111. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[784,1641992181][0m 0.4ms]
112.  
113. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,3042][0m 0.19ms]
114.  
115. 7 days : 100%
116. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[784,1640004981][0m 0.19ms]
117.  
118. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,3043][0m 0.12ms]
119.  
120. 30 days : 100%
121. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[784,1611060981][0m 0.2ms]
122.  
123. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,3044][0m 0.11ms]
124.  
125. 365 days : 100%
126.  
127. >> Runtime for poller module 'availability': 0.0046 seconds with 12328 bytes
128. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.03s]  
129. #### Unload poller module availability ####
130.  
131. Modules status: Global+  
132. OS  
133. Device  
134.  
135. #### Load poller module ipmi ####
136. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[784][0m 0.27ms]
137.  
138. array (
139. )  
140.  
141. >> Runtime for poller module 'ipmi': 0.0006 seconds with 1456 bytes
142. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
143. #### Unload poller module ipmi ####
144.  
145. Modules status: Global+  
146. OS  
147. Device  
148.  
149. #### Load poller module sensors ####
150. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[784][0m 0.21ms]
151.  
152.  
153. >> Runtime for poller module 'sensors': 0.0004 seconds with 456 bytes
154. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
155. #### Unload poller module sensors ####
156.  
157. Modules status: Global+  
158. OS  
159. Device  
160.  
161. #### Load poller module processors ####
162. Attempting to initialize OS: linux  
163. Attempting to initialize Group OS: unix  
164. OS initialized: LibreNMS\OS\Shared\Unix  
165. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[784][0m 0.28ms]
166.  
167. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OUQn' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.3.3.1.2.196608' '.1.3.6.1.2.1.25.3.3.1.2.196609'[0m]
168. .*.*.*608 = 35
169. .*.*.*609 = 32  
170.  
171. array (
172.   '.1.3.6.1.2.1.25.3.3.1.2.196608' => '35',
173.   '.1.3.6.1.2.1.25.3.3.1.2.196609' => '32',
174. )  
175. Processor: 35%
176. SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[35,2540][0m 0.61ms]
177.  
178. Processor: 32%
179. SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[32,2541][0m 0.36ms]
180.  
181.  
182. >> Runtime for poller module 'processors': 0.0556 seconds with 59672 bytes
183. >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [3/0.01s]  
184. #### Unload poller module processors ####
185.  
186. Modules status: Global+  
187. OS  
188. Device  
189.  
190. #### Load poller module mempools ####
191. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[784][0m 0.81ms]
192.  
193. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OUQn' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.2.3.1.6.1' '.1.3.6.1.2.1.25.2.3.1.6.3' '.1.3.6.1.2.1.25.2.3.1.6.6' '.1.3.6.1.2.1.25.2.3.1.6.7' '.1.3.6.1.2.1.25.2.3.1.6.8'[0m]
194. .*.*.* = 597420
195. .*.*.* = 597420
196. .*.*.* = 24544
197. .*.*.* = 352916
198. .*.*.* = 188128  
199.  
200. Free memory adjusted by availability calculation: 415.75 MiB -> 784.36 MiB
201.  
202. hrstorage [system]: Physical memory: 21!4.8 MiB / 999.17 MiB
203. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[225239040,822464512,3946][0m 0.45ms]
204.  
205. hrstorage [virtual]: Virtual memory: 58X3.42 MiB / 999.17 MiB
206. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[611758080,435945472,3947][0m 0.33ms]
207.  
208. hrstorage [buffers]: Memory buffers: 2#.97 MiB / 999.17 MiB
209. hrstorage [cached]: Cached memory: 3444.64 MiB / 999.17 MiB
210. SQL[[1;33mupdate `mempools` set `mempool_perc` = ?, `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[34,361385984,686317568,3949][0m 0.31ms]
211.  
212. hrstorage [shared]: Shared memory: 183.72 MiB / 999.17 MiB
213. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[192643072,855060480,3950][0m 0.28ms]
214.  
215.  
216. >> Runtime for poller module 'mempools': 0.0606 seconds with 110464 bytes
217. >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [5/0.02s]  
218. #### Unload poller module mempools ####
219.  
220. Modules status: Global+  
221. OS  
222. Device  
223.  
224. #### Load poller module storage ####
225. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[784][0m 0.36ms]
226.  
227. Storage /: hrstorage
228.  
229.  
230.  
231. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m]
232. hrStorageIndex.1 = 1
233. hrStorageIndex.3 = 3
234. hrStorageIndex.6 = 6
235. hrStorageIndex.7 = 7
236. hrStorageIndex.8 = 8
237. hrStorageIndex.10 = 10
238. hrStorageIndex.31 = 31
239. hrStorageIndex.36 = 36
240. hrStorageIndex.37 = 37
241. hrStorageIndex.38 = 38
242. hrStorageIndex.39 = 39
243. hrStorageIndex.40 = 40
244. hrStorageIndex.41 = 41
245. hrStorageType.1 = hrStorageRam
246. hrStorageType.3 = hrStorageVirtualMemory
247. hrStorageType.6 = hrStorageOther
248. hrStorageType.7 = hrStorageOther
249. hrStorageType.8 = hrStorageOther
250. hrStorageType.10 = hrStorageVirtualMemory
251. hrStorageType.31 = hrStorageFixedDisk
252. hrStorageType.36 = hrStorageFixedDisk
253. hrStorageType.37 = hrStorageFixedDisk
254. hrStorageType.38 = hrStorageFixedDisk
255. hrStorageType.39 = hrStorageFixedDisk
256. hrStorageType.40 = hrStorageFixedDisk
257. hrStorageType.41 = hrStorageFixedDisk
258. hrStorageDescr.1 = Physical memory
259. hrStorageDescr.3 = Virtual memory
260. hrStorageDescr.6 = Memory buffers
261. hrStorageDescr.7 = Cached memory
262. hrStorageDescr.8 = Shared memory
263. hrStorageDescr.10 = Swap space
264. hrStorageDescr.31 = /
265. hrStorageDescr.36 = /run
266. hrStorageDescr.37 = /var/volatile
267. hrStorageDescr.38 = /tmp
268. hrStorageDescr.39 = /cache
269. hrStorageDescr.40 = /data
270. hrStorageDescr.41 = /dev/shm
271. hrStorageAllocationUnits.1 = 1024
272. hrStorageAllocationUnits.3 = 1024
273. hrStorageAllocationUnits.6 = 1024
274. hrStorageAllocationUnits.7 = 1024
275. hrStorageAllocationUnits.8 = 1024
276. hrStorageAllocationUnits.10 = 1024
277. hrStorageAllocationUnits.31 = 4096
278. hrStorageAllocationUnits.36 = 4096
279. hrStorageAllocationUnits.37 = 4096
280. hrStorageAllocationUnits.38 = 4096
281. hrStorageAllocationUnits.39 = 1024
282. hrStorageAllocationUnits.40 = 4096
283. hrStorageAllocationUnits.41 = 4096
284. hrStorageSize.1 = 1023148
285. hrStorageSize.3 = 1023148
286. hrStorageSize.6 = 1023148
287. hrStorageSize.7 = 352916
288. hrStorageSize.8 = 188128
289. hrStorageSize.10 = 0
290. hrStorageSize.31 = 124914
291. hrStorageSize.36 = 127893
292. hrStorageSize.37 = 157168
293. hrStorageSize.38 = 65536
294. hrStorageSize.39 = 245679
295. hrStorageSize.40 = 157168
296. hrStorageSize.41 = 127893
297. hrStorageUsed.1 = 597420
298. hrStorageUsed.3 = 597420
299. hrStorageUsed.6 = 24544
300. hrStorageUsed.7 = 352916
301. hrStorageUsed.8 = 188128
302. hrStorageUsed.10 = 0
303. hrStorageUsed.31 = 82383
304. hrStorageUsed.36 = 48
305. hrStorageUsed.37 = 30338
306. hrStorageUsed.38 = 23670
307. hrStorageUsed.39 = 2052
308. hrStorageUsed.40 = 30338
309. hrStorageUsed.41 = 2529  
310.  
311. array (
312.   'hrstorage' =>
313.   array (
314.     1 =>
315.     array (
316.       'hrStorageIndex' => '1',
317.       'hrStorageType' => 'hrStorageRam',
318.       'hrStorageDescr' => 'Physical memory',
319.       'hrStorageAllocationUnits' => '1024',
320.       'hrStorageSize' => '1023148',
321.       'hrStorageUsed' => '597420',
322.     ),
323.     3 =>
324.     array (
325.       'hrStorageIndex' => '3',
326.       'hrStorageType' => 'hrStorageVirtualMemory',
327.       'hrStorageDescr' => 'Virtual memory',
328.       'hrStorageAllocationUnits' => '1024',
329.       'hrStorageSize' => '1023148',
330.       'hrStorageUsed' => '597420',
331.     ),
332.     6 =>
333.     array (
334.       'hrStorageIndex' => '6',
335.       'hrStorageType' => 'hrStorageOther',
336.       'hrStorageDescr' => 'Memory buffers',
337.       'hrStorageAllocationUnits' => '1024',
338.       'hrStorageSize' => '1023148',
339.       'hrStorageUsed' => '24544',
340.     ),
341.     7 =>
342.     array (
343.       'hrStorageIndex' => '7',
344.       'hrStorageType' => 'hrStorageOther',
345.       'hrStorageDescr' => 'Cached memory',
346.       'hrStorageAllocationUnits' => '1024',
347.       'hrStorageSize' => '352916',
348.       'hrStorageUsed' => '352916',
349.     ),
350.     8 =>
351.     array (
352.       'hrStorageIndex' => '8',
353.       'hrStorageType' => 'hrStorageOther',
354.       'hrStorageDescr' => 'Shared memory',
355.       'hrStorageAllocationUnits' => '1024',
356.       'hrStorageSize' => '188128',
357.       'hrStorageUsed' => '188128',
358.     ),
359.     10 =>
360.     array (
361.       'hrStorageIndex' => '10',
362.       'hrStorageType' => 'hrStorageVirtualMemory',
363.       'hrStorageDescr' => 'Swap space',
364.       'hrStorageAllocationUnits' => '1024',
365.       'hrStorageSize' => '0',
366.       'hrStorageUsed' => '0',
367.     ),
368.     31 =>
369.     array (
370.       'hrStorageIndex' => '31',
371.       'hrStorageType' => 'hrStorageFixedDisk',
372.       'hrStorageDescr' => '/',
373.       'hrStorageAllocationUnits' => '4096',
374.       'hrStorageSize' => '124914',
375.       'hrStorageUsed' => '82383',
376.     ),
377.     36 =>
378.     array (
379.       'hrStorageIndex' => '36',
380.       'hrStorageType' => 'hrStorageFixedDisk',
381.       'hrStorageDescr' => '/run',
382.       'hrStorageAllocationUnits' => '4096',
383.       'hrStorageSize' => '127893',
384.       'hrStorageUsed' => '48',
385.     ),
386.     37 =>
387.     array (
388.       'hrStorageIndex' => '37',
389.       'hrStorageType' => 'hrStorageFixedDisk',
390.       'hrStorageDescr' => '/var/volatile',
391.       'hrStorageAllocationUnits' => '4096',
392.       'hrStorageSize' => '157168',
393.       'hrStorageUsed' => '30338',
394.     ),
395.     38 =>
396.     array (
397.       'hrStorageIndex' => '38',
398.       'hrStorageType' => 'hrStorageFixedDisk',
399.       'hrStorageDescr' => '/tmp',
400.       'hrStorageAllocationUnits' => '4096',
401.       'hrStorageSize' => '65536',
402.       'hrStorageUsed' => '23670',
403.     ),
404.     39 =>
405.     array (
406.       'hrStorageIndex' => '39',
407.       'hrStorageType' => 'hrStorageFixedDisk',
408.       'hrStorageDescr' => '/cache',
409.       'hrStorageAllocationUnits' => '1024',
410.       'hrStorageSize' => '245679',
411.       'hrStorageUsed' => '2052',
412.     ),
413.     40 =>
414.     array (
415.       'hrStorageIndex' => '40',
416.       'hrStorageType' => 'hrStorageFixedDisk',
417.       'hrStorageDescr' => '/data',
418.       'hrStorageAllocationUnits' => '4096',
419.       'hrStorageSize' => '157168',
420.       'hrStorageUsed' => '30338',
421.     ),
422.     41 =>
423.     array (
424.       'hrStorageIndex' => '41',
425.       'hrStorageType' => 'hrStorageFixedDisk',
426.       'hrStorageDescr' => '/dev/shm',
427.       'hrStorageAllocationUnits' => '4096',
428.       'hrStorageSize' => '127893',
429.       'hrStorageUsed' => '2529',
430.     ),
431.   ),
432. )  
433. array (
434.   'storage_id' => 1082,
435.   'device_id' => 784,
436.   'storage_mib' => 'hrstorage',
437.   'storage_index' => '31',
438.   'storage_type' => 'hrStorageFixedDisk',
439.   'storage_descr' => '/',
440.   'storage_size' => 511647744,
441.   'storage_units' => 4096,
442.   'storage_used' => 337440768,
443.   'storage_free' => 174206976,
444.   'storage_perc' => 66,
445.   'storage_perc_warn' => 60,
446.   'storage_deleted' => 0,
447.   'units' => '4096',
448.   'used' => 337440768,
449.   'size' => 511647744,
450.   'free' => 174206976,
451. )  
452. 66% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["337440768","174206976","511647744",4096,66,1082][0m 0.49ms]
453.  
454.  
455. Storage /run: hrstorage
456.  
457.  
458.  
459. array (
460.   'storage_id' => 1083,
461.   'device_id' => 784,
462.   'storage_mib' => 'hrstorage',
463.   'storage_index' => '36',
464.   'storage_type' => 'hrStorageFixedDisk',
465.   'storage_descr' => '/run',
466.   'storage_size' => 523849728,
467.   'storage_units' => 4096,
468.   'storage_used' => 196608,
469.   'storage_free' => 523653120,
470.   'storage_perc' => 0,
471.   'storage_perc_warn' => 60,
472.   'storage_deleted' => 0,
473.   'units' => '4096',
474.   'used' => 196608,
475.   'size' => 523849728,
476.   'free' => 523653120,
477. )  
478. 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["196608","523653120","523849728",4096,0,1083][0m 0.55ms]
479.  
480.  
481. Storage /var/volatile: hrstorage
482.  
483.  
484.  
485. array (
486.   'storage_id' => 1084,
487.   'device_id' => 784,
488.   'storage_mib' => 'hrstorage',
489.   'storage_index' => '37',
490.   'storage_type' => 'hrStorageFixedDisk',
491.   'storage_descr' => '/var/volatile',
492.   'storage_size' => 643760128,
493.   'storage_units' => 4096,
494.   'storage_used' => 124264448,
495.   'storage_free' => 519495680,
496.   'storage_perc' => 19,
497.   'storage_perc_warn' => 60,
498.   'storage_deleted' => 0,
499.   'units' => '4096',
500.   'used' => 124264448,
501.   'size' => 643760128,
502.   'free' => 519495680,
503. )  
504. 19% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["124264448","519495680","643760128",4096,19,1084][0m 0.55ms]
505.  
506.  
507. Storage /tmp: hrstorage
508.  
509.  
510.  
511. array (
512.   'storage_id' => 1085,
513.   'device_id' => 784,
514.   'storage_mib' => 'hrstorage',
515.   'storage_index' => '38',
516.   'storage_type' => 'hrStorageFixedDisk',
517.   'storage_descr' => '/tmp',
518.   'storage_size' => 268435456,
519.   'storage_units' => 4096,
520.   'storage_used' => 96952320,
521.   'storage_free' => 171483136,
522.   'storage_perc' => 36,
523.   'storage_perc_warn' => 60,
524.   'storage_deleted' => 0,
525.   'units' => '4096',
526.   'used' => 96952320,
527.   'size' => 268435456,
528.   'free' => 171483136,
529. )  
530. 36% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["96952320","171483136","268435456",4096,36,1085][0m 0.53ms]
531.  
532.  
533. Storage /cache: hrstorage
534.  
535.  
536.  
537. array (
538.   'storage_id' => 1086,
539.   'device_id' => 784,
540.   'storage_mib' => 'hrstorage',
541.   'storage_index' => '39',
542.   'storage_type' => 'hrStorageFixedDisk',
543.   'storage_descr' => '/cache',
544.   'storage_size' => 251575296,
545.   'storage_units' => 1024,
546.   'storage_used' => 2101248,
547.   'storage_free' => 249474048,
548.   'storage_perc' => 1,
549.   'storage_perc_warn' => 60,
550.   'storage_deleted' => 0,
551.   'units' => '1024',
552.   'used' => 2101248,
553.   'size' => 251575296,
554.   'free' => 249474048,
555. )  
556. 1% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["2101248","249474048","251575296",1024,1,1086][0m 0.44ms]
557.  
558.  
559. Storage /data: hrstorage
560.  
561.  
562.  
563. array (
564.   'storage_id' => 1087,
565.   'device_id' => 784,
566.   'storage_mib' => 'hrstorage',
567.   'storage_index' => '40',
568.   'storage_type' => 'hrStorageFixedDisk',
569.   'storage_descr' => '/data',
570.   'storage_size' => 643760128,
571.   'storage_units' => 4096,
572.   'storage_used' => 124264448,
573.   'storage_free' => 519495680,
574.   'storage_perc' => 19,
575.   'storage_perc_warn' => 60,
576.   'storage_deleted' => 0,
577.   'units' => '4096',
578.   'used' => 124264448,
579.   'size' => 643760128,
580.   'free' => 519495680,
581. )  
582. 19% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["124264448","519495680","643760128",4096,19,1087][0m 0.36ms]
583.  
584.  
585. Storage /dev/shm: hrstorage
586.  
587.  
588.  
589. array (
590.   'storage_id' => 1088,
591.   'device_id' => 784,
592.   'storage_mib' => 'hrstorage',
593.   'storage_index' => '41',
594.   'storage_type' => 'hrStorageFixedDisk',
595.   'storage_descr' => '/dev/shm',
596.   'storage_size' => 523849728,
597.   'storage_units' => 4096,
598.   'storage_used' => 10358784,
599.   'storage_free' => 513490944,
600.   'storage_perc' => 2,
601.   'storage_perc_warn' => 60,
602.   'storage_deleted' => 0,
603.   'units' => '4096',
604.   'used' => 10358784,
605.   'size' => 523849728,
606.   'free' => 513490944,
607. )  
608. 2% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["10358784","513490944","523849728",4096,2,1088][0m 0.31ms]
609.  
610.  
611.  
612. >> Runtime for poller module 'storage': 0.0756 seconds with 15072 bytes
613. >> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [8/0.04s]  
614. #### Unload poller module storage ####
615.  
616. Modules status: Global+  
617. OS  
618. Device  
619.  
620. #### Load poller module netstats ####
621. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m]  
622. IP-MIB::icmpInMsgs.0 = 254
623. IP-MIB::icmpOutMsgs.0 = 254
624. IP-MIB::icmpInErrors.0 = 0
625. IP-MIB::icmpOutErrors.0 = 0
626. IP-MIB::icmpInEchos.0 = 250
627. IP-MIB::icmpOutEchos.0 = 0
628. IP-MIB::icmpInEchoReps.0 = 0
629. IP-MIB::icmpOutEchoReps.0 = 250
630. IP-MIB::icmpInDestUnreachs.0 = 4
631. IP-MIB::icmpOutDestUnreachs.0 = 4
632. IP-MIB::icmpInParmProbs.0 = 0
633. IP-MIB::icmpInTimeExcds.0 = 0
634. IP-MIB::icmpInSrcQuenchs.0 = 0
635. IP-MIB::icmpInRedirects.0 = 0
636. IP-MIB::icmpInTimestamps.0 = 0
637. IP-MIB::icmpInTimestampReps.0 = 0
638. IP-MIB::icmpInAddrMasks.0 = 0
639. IP-MIB::icmpInAddrMaskReps.0 = 0
640. IP-MIB::icmpOutTimeExcds.0 = 0
641. IP-MIB::icmpOutParmProbs.0 = 0
642. IP-MIB::icmpOutSrcQuenchs.0 = 0
643. IP-MIB::icmpOutRedirects.0 = 0
644. IP-MIB::icmpOutTimestamps.0 = 0
645. IP-MIB::icmpOutTimestampReps.0 = 0
646. IP-MIB::icmpOutAddrMasks.0 = 0
647. IP-MIB::icmpOutAddrMaskReps.0 = 0
648.  
649.  
650. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m]  
651. IP-MIB::ipForwDatagrams.0 = 0
652. IP-MIB::ipInDelivers.0 = 178233513
653. IP-MIB::ipInReceives.0 = 178233763
654. IP-MIB::ipOutRequests.0 = 178218631
655. IP-MIB::ipInDiscards.0 = 0
656. IP-MIB::ipOutDiscards.0 = 0
657. IP-MIB::ipOutNoRoutes.0 = 0
658. IP-MIB::ipReasmReqds.0 = 0
659. IP-MIB::ipReasmOKs.0 = 0
660. IP-MIB::ipReasmFails.0 = 0
661. IP-MIB::ipFragOKs.0 = 0
662. IP-MIB::ipFragFails.0 = 0
663. IP-MIB::ipFragCreates.0 = 0
664. IP-MIB::ipInUnknownProtos.0 = 0
665. IP-MIB::ipInHdrErrors.0 = 0
666. IP-MIB::ipInAddrErrors.0 = 250
667.  
668.  
669. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
670. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
671.  
672.  
673. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m]  
674. SNMPv2-MIB::snmpInPkts.0 = 1941
675. SNMPv2-MIB::snmpOutPkts.0 = 1327
676. SNMPv2-MIB::snmpInBadVersions.0 = 0
677. SNMPv2-MIB::snmpInBadCommunityNames.0 = 0
678. SNMPv2-MIB::snmpInBadCommunityUses.0 = 0
679. SNMPv2-MIB::snmpInASNParseErrs.0 = 0
680. SNMPv2-MIB::snmpInTooBigs.0 = 0
681. SNMPv2-MIB::snmpInNoSuchNames.0 = 0
682. SNMPv2-MIB::snmpInBadValues.0 = 0
683. SNMPv2-MIB::snmpInReadOnlys.0 = 0
684. SNMPv2-MIB::snmpInGenErrs.0 = 0
685. SNMPv2-MIB::snmpInTotalReqVars.0 = 10254
686. SNMPv2-MIB::snmpInTotalSetVars.0 = 0
687. SNMPv2-MIB::snmpInGetRequests.0 = 429
688. SNMPv2-MIB::snmpInGetNexts.0 = 0
689. SNMPv2-MIB::snmpInSetRequests.0 = 0
690. SNMPv2-MIB::snmpInGetResponses.0 = 0
691. SNMPv2-MIB::snmpInTraps.0 = 0
692. SNMPv2-MIB::snmpOutTooBigs.0 = 0
693. SNMPv2-MIB::snmpOutNoSuchNames.0 = 0
694. SNMPv2-MIB::snmpOutBadValues.0 = 0
695. SNMPv2-MIB::snmpOutGenErrs.0 = 0
696. SNMPv2-MIB::snmpOutGetRequests.0 = 0
697. SNMPv2-MIB::snmpOutGetNexts.0 = 0
698. SNMPv2-MIB::snmpOutSetRequests.0 = 0
699. SNMPv2-MIB::snmpOutGetResponses.0 = 1319
700. SNMPv2-MIB::snmpOutTraps.0 = 0
701. SNMPv2-MIB::snmpSilentDrops.0 = 0
702. SNMPv2-MIB::snmpProxyDrops.0 = 0
703.  
704.  
705. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
706. UDP-MIB::udpInDatagrams.0 = 15694996
707. UDP-MIB::udpOutDatagrams.0 = 15694995
708. UDP-MIB::udpInErrors.0 = 0
709. UDP-MIB::udpNoPorts.0 = 0
710.  
711.  
712. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m]  
713. TCP-MIB::tcpActiveOpens.0 = 16236
714. TCP-MIB::tcpPassiveOpens.0 = 16443
715. TCP-MIB::tcpAttemptFails.0 = 4
716. TCP-MIB::tcpEstabResets.0 = 798
717. TCP-MIB::tcpCurrEstab.0 = 18
718. TCP-MIB::tcpInSegs.0 = 162538156
719. TCP-MIB::tcpOutSegs.0 = 162557843
720. TCP-MIB::tcpRetransSegs.0 = 300
721. TCP-MIB::tcpInErrs.0 = 0
722. TCP-MIB::tcpOutRsts.0 = 1800
723.  
724.  
725.  
726.  
727. >> Runtime for poller module 'netstats': 0.3006 seconds with 23624 bytes
728. >> [0;36mSNMP[0m: [6/0.30s] [1;33mMySQL[0m: [0/0.00s]  
729. #### Unload poller module netstats ####
730.  
731. Modules status: Global+  
732. OS  
733. Device  
734.  
735. #### Load poller module hr-mib ####
736. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
737. hrSystemMaxProcesses.0 = 0
738. hrSystemProcesses.0 = 106
739. hrSystemNumUsers.0 = 0  
740.  
741.  ProcessesSQL[[1;33mselect * from `hrSystem` where (`device_id` = ?) limit 1 [0;33m[784][0m 0.44ms]
742.  
743. SQL[[1;33mupdate `hrSystem` set `hrSystemProcesses` = ? where `hrSystem_id` = ? [0;33m["106",31][0m 0.36ms]
744.  
745.  Users
746.  
747. >> Runtime for poller module 'hr-mib': 0.0404 seconds with 33424 bytes
748. >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [2/0.01s]  
749. #### Unload poller module hr-mib ####
750.  
751. Modules status: Global+  
752. OS  
753. Device  
754.  
755. #### Load poller module ucd-mib ####
756. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m]
757. ssIndex.0 = 1
758. ssErrorName.0 = systemStats
759. ssSwapIn.0 = 0
760. ssSwapOut.0 = 0
761. ssIOSent.0 = 9
762. ssIOReceive.0 = 0
763. ssSysInterrupts.0 = 626
764. ssSysContext.0 = 916
765. ssCpuUser.0 = 28
766. ssCpuSystem.0 = 4
767. ssCpuIdle.0 = 67
768. ssCpuRawUser.0 = 190456620
769. ssCpuRawNice.0 = 302
770. ssCpuRawSystem.0 = 29519856
771. ssCpuRawIdle.0 = 477111477
772. ssCpuRawWait.0 = 105437
773. ssCpuRawKernel.0 = 0
774. ssCpuRawInterrupt.0 = 0
775. ssIORawSent.0 = 24203090
776. ssIORawReceived.0 = 356074
777. ssRawInterrupts.0 = 2206887318
778. ssRawContexts.0 = 3233694453
779. ssCpuRawSoftIRQ.0 = 950828
780. ssRawSwapIn.0 = 0
781. ssRawSwapOut.0 = 0
782. ssCpuRawSteal.0 = 0
783. ssCpuRawGuest.0 = 0
784. ssCpuRawGuestNice.0 = 0
785. ssCpuNumCpus.0 = 2  
786.  
787. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
788. laLoadInt.1 = 105
789. laLoadInt.2 = 70
790. laLoadInt.3 = 73  
791.  
792.  
793. >> Runtime for poller module 'ucd-mib': 0.0811 seconds with 2672 bytes
794. >> [0;36mSNMP[0m: [2/0.08s] [1;33mMySQL[0m: [0/0.00s]  
795. #### Unload poller module ucd-mib ####
796.  
797. Modules status: Global+  
798. OS  
799. Device  
800.  
801. #### Load poller module ipSystemStats ####
802. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
803. ipSystemStatsInReceives.ipv4 = 178233563
804. ipSystemStatsInReceives.ipv6 = 0
805. ipSystemStatsHCInReceives.ipv4 = 178233563
806. ipSystemStatsHCInReceives.ipv6 = 0
807. ipSystemStatsInOctets.ipv4 = 4208530181
808. ipSystemStatsInOctets.ipv6 = 0
809. ipSystemStatsHCInOctets.ipv4 = 42863235845
810. ipSystemStatsHCInOctets.ipv6 = 0
811. ipSystemStatsInHdrErrors.ipv4 = 0
812. ipSystemStatsInHdrErrors.ipv6 = 0
813. ipSystemStatsInNoRoutes.ipv4 = 0
814. ipSystemStatsInNoRoutes.ipv6 = 0
815. ipSystemStatsInAddrErrors.ipv4 = 250
816. ipSystemStatsInAddrErrors.ipv6 = 0
817. ipSystemStatsInUnknownProtos.ipv4 = 0
818. ipSystemStatsInUnknownProtos.ipv6 = 0
819. ipSystemStatsInTruncatedPkts.ipv4 = 0
820. ipSystemStatsInTruncatedPkts.ipv6 = 0
821. ipSystemStatsInForwDatagrams.ipv4 = 0
822. ipSystemStatsInForwDatagrams.ipv6 = 0
823. ipSystemStatsHCInForwDatagrams.ipv4 = 0
824. ipSystemStatsHCInForwDatagrams.ipv6 = 0
825. ipSystemStatsReasmReqds.ipv4 = 0
826. ipSystemStatsReasmReqds.ipv6 = 0
827. ipSystemStatsReasmOKs.ipv4 = 0
828. ipSystemStatsReasmOKs.ipv6 = 0
829. ipSystemStatsReasmFails.ipv4 = 0
830. ipSystemStatsReasmFails.ipv6 = 0
831. ipSystemStatsInDiscards.ipv4 = 0
832. ipSystemStatsInDiscards.ipv6 = 0
833. ipSystemStatsInDelivers.ipv4 = 178233313
834. ipSystemStatsInDelivers.ipv6 = 0
835. ipSystemStatsHCInDelivers.ipv4 = 178233313
836. ipSystemStatsHCInDelivers.ipv6 = 0
837. ipSystemStatsOutRequests.ipv4 = 178218432
838. ipSystemStatsOutRequests.ipv6 = 0
839. ipSystemStatsHCOutRequests.ipv4 = 178218432
840. ipSystemStatsHCOutRequests.ipv6 = 0
841. ipSystemStatsOutNoRoutes.ipv4 = 0
842. ipSystemStatsOutNoRoutes.ipv6 = 0
843. ipSystemStatsOutForwDatagrams.ipv4 = 0
844. ipSystemStatsOutForwDatagrams.ipv6 = 0
845. ipSystemStatsHCOutForwDatagrams.ipv4 = 0
846. ipSystemStatsHCOutForwDatagrams.ipv6 = 0
847. ipSystemStatsOutDiscards.ipv4 = 0
848. ipSystemStatsOutDiscards.ipv6 = 0
849. ipSystemStatsOutFragReqds.ipv4 = 0
850. ipSystemStatsOutFragReqds.ipv6 = 0
851. ipSystemStatsOutFragOKs.ipv4 = 0
852. ipSystemStatsOutFragOKs.ipv6 = 0
853. ipSystemStatsOutFragFails.ipv4 = 0
854. ipSystemStatsOutFragFails.ipv6 = 0
855. ipSystemStatsOutFragCreates.ipv4 = 0
856. ipSystemStatsOutFragCreates.ipv6 = 0
857. ipSystemStatsOutTransmits.ipv4 = 178218432
858. ipSystemStatsOutTransmits.ipv6 = 0
859. ipSystemStatsHCOutTransmits.ipv4 = 178218432
860. ipSystemStatsHCOutTransmits.ipv6 = 0
861. ipSystemStatsOutOctets.ipv4 = 4267580579
862. ipSystemStatsOutOctets.ipv6 = 0
863. ipSystemStatsHCOutOctets.ipv4 = 42922286243
864. ipSystemStatsHCOutOctets.ipv6 = 0
865. ipSystemStatsInMcastPkts.ipv4 = 0
866. ipSystemStatsInMcastPkts.ipv6 = 0
867. ipSystemStatsHCInMcastPkts.ipv4 = 0
868. ipSystemStatsHCInMcastPkts.ipv6 = 0
869. ipSystemStatsInMcastOctets.ipv4 = 0
870. ipSystemStatsInMcastOctets.ipv6 = 0
871. ipSystemStatsHCInMcastOctets.ipv4 = 0
872. ipSystemStatsHCInMcastOctets.ipv6 = 0
873. ipSystemStatsOutMcastPkts.ipv4 = 0
874. ipSystemStatsOutMcastPkts.ipv6 = 0
875. ipSystemStatsHCOutMcastPkts.ipv4 = 0
876. ipSystemStatsHCOutMcastPkts.ipv6 = 0
877. ipSystemStatsOutMcastOctets.ipv4 = 0
878. ipSystemStatsOutMcastOctets.ipv6 = 0
879. ipSystemStatsHCOutMcastOctets.ipv4 = 0
880. ipSystemStatsHCOutMcastOctets.ipv6 = 0
881. ipSystemStatsInBcastPkts.ipv4 = 123
882. ipSystemStatsHCInBcastPkts.ipv4 = 123
883. ipSystemStatsOutBcastPkts.ipv4 = 0
884. ipSystemStatsHCOutBcastPkts.ipv4 = 0
885. ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00
886. ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00
887. ipSystemStatsRefreshRate.ipv4 = 60000
888. ipSystemStatsRefreshRate.ipv6 = 60000  
889.  
890. ipv4 ipv6
891.  
892. >> Runtime for poller module 'ipSystemStats': 0.1267 seconds with 16064 bytes
893. >> [0;36mSNMP[0m: [1/0.13s] [1;33mMySQL[0m: [0/0.00s]  
894. #### Unload poller module ipSystemStats ####
895.  
896. Modules status: Global+  
897. OS  
898. Device  
899.  
900. #### Load poller module ports ####
901. 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[784][0m 0.83ms]
902.  
903. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
904. ifName.1 = lo
905. ifName.2 = eth0
906. ifName.3 = sit0
907. ifInMulticastPkts.1 = 0
908. ifInMulticastPkts.2 = 0
909. ifInMulticastPkts.3 = 0
910. ifInBroadcastPkts.1 = 0
911. ifInBroadcastPkts.2 = 0
912. ifInBroadcastPkts.3 = 0
913. ifOutMulticastPkts.1 = 0
914. ifOutMulticastPkts.2 = 0
915. ifOutMulticastPkts.3 = 0
916. ifOutBroadcastPkts.1 = 0
917. ifOutBroadcastPkts.2 = 0
918. ifOutBroadcastPkts.3 = 0
919. ifHCInOctets.1 = 42859881055
920. ifHCInOctets.2 = 4049624
921. ifHCInOctets.3 = 0
922. ifHCInUcastPkts.1 = 178203894
923. ifHCInUcastPkts.2 = 30675
924. ifHCInUcastPkts.3 = 0
925. ifHCInMulticastPkts.1 = 0
926. ifHCInMulticastPkts.2 = 0
927. ifHCInMulticastPkts.3 = 0
928. ifHCInBroadcastPkts.1 = 0
929. ifHCInBroadcastPkts.2 = 0
930. ifHCInBroadcastPkts.3 = 0
931. ifHCOutOctets.1 = 42859881055
932. ifHCOutOctets.2 = 62639058
933. ifHCOutOctets.3 = 0
934. ifHCOutUcastPkts.1 = 178203894
935. ifHCOutUcastPkts.2 = 14717
936. ifHCOutUcastPkts.3 = 0
937. ifHCOutMulticastPkts.1 = 0
938. ifHCOutMulticastPkts.2 = 0
939. ifHCOutMulticastPkts.3 = 0
940. ifHCOutBroadcastPkts.1 = 0
941. ifHCOutBroadcastPkts.2 = 0
942. ifHCOutBroadcastPkts.3 = 0
943. ifHighSpeed.1 = 10
944. ifHighSpeed.2 = 100
945. ifHighSpeed.3 = 0
946. ifPromiscuousMode.1 = false
947. ifPromiscuousMode.2 = false
948. ifPromiscuousMode.3 = false
949. ifConnectorPresent.1 = false
950. ifConnectorPresent.2 = true
951. ifConnectorPresent.3 = true
952. ifAlias.1 =
953. ifAlias.2 =
954. ifAlias.3 =
955. ifCounterDiscontinuityTime.1 = 0:0:00:00.00
956. ifCounterDiscontinuityTime.2 = 0:0:00:00.00
957. ifCounterDiscontinuityTime.3 = 0:0:00:00.00  
958.  
959. ifDescr SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifDescr'[0m]
960. ifDescr.1 = lo
961. ifDescr.2 = eth0
962. ifDescr.3 = sit0  
963.  
964. ifAdminStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifAdminStatus'[0m]
965. ifAdminStatus.1 = up
966. ifAdminStatus.2 = up
967. ifAdminStatus.3 = down  
968.  
969. ifOperStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifOperStatus'[0m]
970. ifOperStatus.1 = up
971. ifOperStatus.2 = up
972. ifOperStatus.3 = down  
973.  
974. ifLastChange SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifLastChange'[0m]
975. ifLastChange.1 = 0
976. ifLastChange.2 = 0
977. ifLastChange.3 = 0  
978.  
979. ifType SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifType'[0m]
980. ifType.1 = softwareLoopback
981. ifType.2 = ethernetCsmacd
982. ifType.3 = tunnel  
983.  
984. ifPhysAddress SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifPhysAddress'[0m]
985. ifPhysAddress.1 =
986. ifPhysAddress.2 = 50:2d:f4:1e:2:d1
987. ifPhysAddress.3 =  
988.  
989. ifMtu SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifMtu'[0m]
990. ifMtu.1 = 65536
991. ifMtu.2 = 1500
992. ifMtu.3 = 1480  
993.  
994. ifInErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifInErrors'[0m]
995. ifInErrors.1 = 0
996. ifInErrors.2 = 0
997. ifInErrors.3 = 0  
998.  
999. ifOutErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifOutErrors'[0m]
1000. ifOutErrors.1 = 0
1001. ifOutErrors.2 = 0
1002. ifOutErrors.3 = 0  
1003.  
1004. ifInDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifInDiscards'[0m]
1005. ifInDiscards.1 = 0
1006. ifInDiscards.2 = 0
1007. ifInDiscards.3 = 0  
1008.  
1009. ifOutDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifOutDiscards'[0m]
1010. ifOutDiscards.1 = 0
1011. ifOutDiscards.2 = 0
1012. ifOutDiscards.3 = 0  
1013.  
1014. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
1015. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
1016.  
1017. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
1018. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
1019. dot1qPvid = No Such Object available on this agent at this OID  
1020.  
1021. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
1022. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl','vdsl2') [0;33m[784][0m 0.44ms]
1023.  
1024. array (
1025.   1 =>
1026.   array (
1027.     'ifName' => 'lo',
1028.     'ifInMulticastPkts' => '0',
1029.     'ifInBroadcastPkts' => '0',
1030.     'ifOutMulticastPkts' => '0',
1031.     'ifOutBroadcastPkts' => '0',
1032.     'ifHCInOctets' => '42859881055',
1033.     'ifHCInUcastPkts' => '178203894',
1034.     'ifHCInMulticastPkts' => '0',
1035.     'ifHCInBroadcastPkts' => '0',
1036.     'ifHCOutOctets' => '42859881055',
1037.     'ifHCOutUcastPkts' => '178203894',
1038.     'ifHCOutMulticastPkts' => '0',
1039.     'ifHCOutBroadcastPkts' => '0',
1040.     'ifHighSpeed' => '10',
1041.     'ifPromiscuousMode' => 'false',
1042.     'ifConnectorPresent' => 'false',
1043.     'ifAlias' => '',
1044.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
1045.     'ifDescr' => 'lo',
1046.     'ifAdminStatus' => 'up',
1047.     'ifOperStatus' => 'up',
1048.     'ifLastChange' => '0',
1049.     'ifType' => 'softwareLoopback',
1050.     'ifPhysAddress' => '',
1051.     'ifMtu' => '65536',
1052.     'ifInErrors' => '0',
1053.     'ifOutErrors' => '0',
1054.     'ifInDiscards' => '0',
1055.     'ifOutDiscards' => '0',
1056.   ),
1057.   2 =>
1058.   array (
1059.     'ifName' => 'eth0',
1060.     'ifInMulticastPkts' => '0',
1061.     'ifInBroadcastPkts' => '0',
1062.     'ifOutMulticastPkts' => '0',
1063.     'ifOutBroadcastPkts' => '0',
1064.     'ifHCInOctets' => '4049624',
1065.     'ifHCInUcastPkts' => '30675',
1066.     'ifHCInMulticastPkts' => '0',
1067.     'ifHCInBroadcastPkts' => '0',
1068.     'ifHCOutOctets' => '62639058',
1069.     'ifHCOutUcastPkts' => '14717',
1070.     'ifHCOutMulticastPkts' => '0',
1071.     'ifHCOutBroadcastPkts' => '0',
1072.     'ifHighSpeed' => '100',
1073.     'ifPromiscuousMode' => 'false',
1074.     'ifConnectorPresent' => 'true',
1075.     'ifAlias' => '',
1076.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
1077.     'ifDescr' => 'eth0',
1078.     'ifAdminStatus' => 'up',
1079.     'ifOperStatus' => 'up',
1080.     'ifLastChange' => '0',
1081.     'ifType' => 'ethernetCsmacd',
1082.     'ifPhysAddress' => '50:2d:f4:1e:2:d1',
1083.     'ifMtu' => '1500',
1084.     'ifInErrors' => '0',
1085.     'ifOutErrors' => '0',
1086.     'ifInDiscards' => '0',
1087.     'ifOutDiscards' => '0',
1088.   ),
1089.   3 =>
1090.   array (
1091.     'ifName' => 'sit0',
1092.     'ifInMulticastPkts' => '0',
1093.     'ifInBroadcastPkts' => '0',
1094.     'ifOutMulticastPkts' => '0',
1095.     'ifOutBroadcastPkts' => '0',
1096.     'ifHCInOctets' => '0',
1097.     'ifHCInUcastPkts' => '0',
1098.     'ifHCInMulticastPkts' => '0',
1099.     'ifHCInBroadcastPkts' => '0',
1100.     'ifHCOutOctets' => '0',
1101.     'ifHCOutUcastPkts' => '0',
1102.     'ifHCOutMulticastPkts' => '0',
1103.     'ifHCOutBroadcastPkts' => '0',
1104.     'ifHighSpeed' => '0',
1105.     'ifPromiscuousMode' => 'false',
1106.     'ifConnectorPresent' => 'true',
1107.     'ifAlias' => '',
1108.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
1109.     'ifDescr' => 'sit0',
1110.     'ifAdminStatus' => 'down',
1111.     'ifOperStatus' => 'down',
1112.     'ifLastChange' => '0',
1113.     'ifType' => 'tunnel',
1114.     'ifPhysAddress' => '',
1115.     'ifMtu' => '1480',
1116.     'ifInErrors' => '0',
1117.     'ifOutErrors' => '0',
1118.     'ifInDiscards' => '0',
1119.     'ifOutDiscards' => '0',
1120.   ),
1121. )  
1122.  valid  
1123.  valid  
1124.  valid  
1125.  
1126. Port lo: lo (1 / #2105985) ifHCInOctets  
1127. ifHCOutOctets  
1128. ifHCInUcastPkts  
1129. ifHCOutUcastPkts  
1130. ifInBroadcastPkts  
1131. ifOutBroadcastPkts  
1132. ifInMulticastPkts  
1133. ifOutMulticastPkts  
1134. ifHighSpeed (10)  
1135. VLAN =   Using ifDescr as ifAlias  
1136. lo
1137.  ifInOctets (1059091 B) 11899.898876404 Bps 89 secs  
1138.  
1139.  ifOutOctets (1059091 B) 11899.898876404 Bps 89 secs  
1140.  
1141.  ifInErrors (0 B) 0 Bps 89 secs  
1142.  
1143.  ifOutErrors (0 B) 0 Bps 89 secs  
1144.  
1145.  ifInUcastPkts (4478 B) 50.314606741573 Bps 89 secs  
1146.  
1147.  ifOutUcastPkts (4478 B) 50.314606741573 Bps 89 secs  
1148.  
1149.  ifInNUcastPkts (0 B) 0 Bps 89 secs  
1150.  
1151.  ifOutNUcastPkts (0 B) 0 Bps 89 secs  
1152.  
1153.  ifInDiscards (0 B) 0 Bps 89 secs  
1154.  
1155.  ifOutDiscards (0 B) 0 Bps 89 secs  
1156.  
1157.  ifInUnknownProtos (0 B) 0 Bps 89 secs  
1158.  
1159.  ifInBroadcastPkts (0 B) 0 Bps 89 secs  
1160.  
1161.  ifOutBroadcastPkts (0 B) 0 Bps 89 secs  
1162.  
1163.  ifInMulticastPkts (0 B) 0 Bps 89 secs  
1164.  
1165.  ifOutMulticastPkts (0 B) 0 Bps 89 secs  
1166. bps(95.2 Kbps/95.2 Kbps)bytes(1.01 MiB/1.01 MiB)pkts(50.31 pps/50.31 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["42859881055",42858821964,11899.898876404495,1059091,"42859881055",42858821964,11899.898876404495,1059091,"0",0,0,0,"0",0,0,0,"178203894",178199416,50.31460674157304,4478,"178203894",178199416,50.31460674157304,4478,1642596982,1642596893,89,2105985][0m 0.55ms]
1167.  
1168. 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,2105985][0m 0.31ms]
1169.  
1170. 1 updated  
1171.  
1172. Port eth0: eth0 (2 / #2105986) ifHCInOctets  
1173. ifHCOutOctets  
1174. ifHCInUcastPkts  
1175. ifHCOutUcastPkts  
1176. ifInBroadcastPkts  
1177. ifOutBroadcastPkts  
1178. ifInMulticastPkts  
1179. ifOutMulticastPkts  
1180. ifHighSpeed (100)  
1181. VLAN =   Using ifDescr as ifAlias  
1182. eth0
1183.  ifInOctets (134227 B) 1508.1685393258 Bps 89 secs  
1184.  
1185.  ifOutOctets (243283 B) 2733.5168539326 Bps 89 secs  
1186.  
1187.  ifInErrors (0 B) 0 Bps 89 secs  
1188.  
1189.  ifOutErrors (0 B) 0 Bps 89 secs  
1190.  
1191.  ifInUcastPkts (799 B) 8.9775280898876 Bps 89 secs  
1192.  
1193.  ifOutUcastPkts (709 B) 7.9662921348315 Bps 89 secs  
1194.  
1195.  ifInNUcastPkts (0 B) 0 Bps 89 secs  
1196.  
1197.  ifOutNUcastPkts (0 B) 0 Bps 89 secs  
1198.  
1199.  ifInDiscards (0 B) 0 Bps 89 secs  
1200.  
1201.  ifOutDiscards (0 B) 0 Bps 89 secs  
1202.  
1203.  ifInUnknownProtos (0 B) 0 Bps 89 secs  
1204.  
1205.  ifInBroadcastPkts (0 B) 0 Bps 89 secs  
1206.  
1207.  ifOutBroadcastPkts (0 B) 0 Bps 89 secs  
1208.  
1209.  ifInMulticastPkts (0 B) 0 Bps 89 secs  
1210.  
1211.  ifOutMulticastPkts (0 B) 0 Bps 89 secs  
1212. bps(12.07 Kbps/21.87 Kbps)bytes(131.08 KiB/237.58 KiB)pkts(8.98 pps/7.97 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["4049624",3915397,1508.1685393258426,134227,"62639058",62395775,2733.516853932584,243283,"0",0,0,0,"0",0,0,0,"30675",29876,8.97752808988764,799,"14717",14008,7.966292134831461,709,1642596982,1642596893,89,2105986][0m 0.44ms]
1213.  
1214. 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,2105986][0m 0.28ms]
1215.  
1216. 1 updated  
1217.  
1218. Port sit0: sit0 (3 / #2105987) ifInOctets  
1219. ifOutOctets  
1220. ifInUcastPkts  
1221. ifOutUcastPkts  
1222. ifInBroadcastPkts  
1223. ifOutBroadcastPkts  
1224. ifInMulticastPkts  
1225. ifOutMulticastPkts  
1226. ifHighSpeed (0)  
1227. VLAN =   Using ifDescr as ifAlias  
1228. sit02105987 skipped because port is still down since last polling.  
1229. SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0000000",1642596982,1642596893,89,2105987][0m 0.29ms]
1230.  
1231. 1 updated  
1232.  
1233. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1642596982,1642596893,null][0m 0.13ms]
1234.  
1235. 0 updated  
1236.  
1237. >> Runtime for poller module 'ports': 0.6502 seconds with 37472 bytes
1238. >> [0;36mSNMP[0m: [14/0.64s] [1;33mMySQL[0m: [8/0.03s]  
1239. #### Unload poller module ports ####
1240.  
1241. Modules status: Global+  
1242. OS  
1243. Device  
1244.  
1245. #### Load poller module customoid ####
1246. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[784][0m 0.3ms]
1247.  
1248.  
1249. >> Runtime for poller module 'customoid': 0.0007 seconds with 1320 bytes
1250. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
1251. #### Unload poller module customoid ####
1252.  
1253. Modules status: Global+  
1254. OS-  
1255. Device  
1256. Module [ bgp-peers ] disabled on os.
1257.  
1258. Modules status: Global-  
1259. OS  
1260. Device  
1261. Module [ junose-atm-vp ] disabled globally.
1262.  
1263. Modules status: Global-  
1264. OS  
1265. Device  
1266. Module [ printer-supplies ] disabled globally.
1267.  
1268. Modules status: Global+  
1269. OS  
1270. Device  
1271.  
1272. #### Load poller module ucd-diskio ####
1273. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[784][0m 0.18ms]
1274.  
1275.  
1276. >> Runtime for poller module 'ucd-diskio': 0.0004 seconds with 816 bytes
1277. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
1278. #### Unload poller module ucd-diskio ####
1279.  
1280. Modules status: Global+  
1281. OS  
1282. Device  
1283.  
1284. #### Load poller module wifi ####
1285.  
1286. >> Runtime for poller module 'wifi': 0.0001 seconds with 560 bytes
1287. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
1288. #### Unload poller module wifi ####
1289.  
1290. Modules status: Global+  
1291. OS  
1292. Device  
1293.  
1294. #### Load poller module wireless ####
1295. Attempting to initialize OS: linux  
1296. Attempting to initialize Group OS: unix  
1297. OS initialized: LibreNMS\OS\Shared\Unix  
1298. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[784][0m 0.21ms]
1299.  
1300.  
1301. >> Runtime for poller module 'wireless': 0.0014 seconds with 103120 bytes
1302. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
1303. #### Unload poller module wireless ####
1304.  
1305. Modules status: Global+  
1306. OS-  
1307. Device  
1308. Module [ ospf ] disabled on os.
1309.  
1310. Modules status: Global-  
1311. OS  
1312. Device  
1313. Module [ isis ] disabled globally.
1314.  
1315. Modules status: Global-  
1316. OS  
1317. Device  
1318. Module [ cisco-ipsec-flow-monitor ] disabled globally.
1319.  
1320. Modules status: Global-  
1321. OS  
1322. Device  
1323. Module [ cisco-remote-access-monitor ] disabled globally.
1324.  
1325. Modules status: Global-  
1326. OS  
1327. Device  
1328. Module [ cisco-cef ] disabled globally.
1329.  
1330. Modules status: Global-  
1331. OS  
1332. Device  
1333. Module [ slas ] disabled globally.
1334.  
1335. Modules status: Global-  
1336. OS  
1337. Device  
1338. Module [ cisco-mac-accounting ] disabled globally.
1339.  
1340. Modules status: Global-  
1341. OS  
1342. Device  
1343. Module [ cipsec-tunnels ] disabled globally.
1344.  
1345. Modules status: Global-  
1346. OS  
1347. Device  
1348. Module [ cisco-ace-loadbalancer ] disabled globally.
1349.  
1350. Modules status: Global-  
1351. OS  
1352. Device  
1353. Module [ cisco-ace-serverfarms ] disabled globally.
1354.  
1355. Modules status: Global-  
1356. OS  
1357. Device  
1358. Module [ cisco-asa-firewall ] disabled globally.
1359.  
1360. Modules status: Global-  
1361. OS  
1362. Device  
1363. Module [ cisco-voice ] disabled globally.
1364.  
1365. Modules status: Global-  
1366. OS  
1367. Device  
1368. Module [ cisco-cbqos ] disabled globally.
1369.  
1370. Modules status: Global-  
1371. OS  
1372. Device  
1373. Module [ cisco-otv ] disabled globally.
1374.  
1375. Modules status: Global-  
1376. OS  
1377. Device  
1378. Module [ cisco-qfp ] disabled globally.
1379.  
1380. Modules status: Global-  
1381. OS  
1382. Device  
1383. Module [ cisco-vpdn ] disabled globally.
1384.  
1385. Modules status: Global-  
1386. OS  
1387. Device  
1388. Module [ nac ] disabled globally.
1389.  
1390. Modules status: Global-  
1391. OS  
1392. Device  
1393. Module [ netscaler-vsvr ] disabled globally.
1394.  
1395. Modules status: Global-  
1396. OS  
1397. Device  
1398. Module [ aruba-controller ] disabled globally.
1399.  
1400. Modules status: Global+  
1401. OS  
1402. Device  
1403.  
1404. #### Load poller module entity-physical ####
1405.  
1406. >> Runtime for poller module 'entity-physical': 0.0001 seconds with 520 bytes
1407. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
1408. #### Unload poller module entity-physical ####
1409.  
1410. Modules status: Global-  
1411. OS  
1412. Device  
1413. Module [ entity-state ] disabled globally.
1414.  
1415. Modules status: Global+  
1416. OS  
1417. Device  
1418.  
1419. #### Load poller module applications ####
1420. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[784][0m 0.17ms]
1421.  
1422.  
1423. >> Runtime for poller module 'applications': 0.0003 seconds with 464 bytes
1424. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
1425. #### Unload poller module applications ####
1426.  
1427. Modules status: Global+  
1428. OS  
1429. Device  
1430.  
1431. #### Load poller module mib ####
1432.  
1433. Warning: include(includes/polling/mib.inc.php): failed to open stream: No such file or directory in /opt/nms/includes/polling/functions.inc.php on line 329
1434.  
1435. Warning: include(): Failed opening 'includes/polling/mib.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /opt/nms/includes/polling/functions.inc.php on line 329
1436.  
1437. >> Runtime for poller module 'mib': 0.0000 seconds with 0 bytes
1438. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
1439. #### Unload poller module mib ####
1440.  
1441. Modules status: Global+  
1442. OS-  
1443. Device  
1444. Module [ stp ] disabled on os.
1445.  
1446. Modules status: Global+  
1447. OS  
1448. Device  
1449.  
1450. #### Load poller module ntp ####
1451.  
1452. >> Runtime for poller module 'ntp': 0.0001 seconds with 368 bytes
1453. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
1454. #### Unload poller module ntp ####
1455.  
1456. Modules status: Global-  
1457. OS  
1458. Device  
1459. Module [ loadbalancers ] disabled globally.
1460.  
1461. Modules status: Global-  
1462. OS  
1463. Device  
1464. Module [ mef ] disabled globally.
1465.  
1466. Modules status: Global+  
1467. OS  
1468. Device  
1469.  
1470. #### Load poller module mpls ####
1471.  
1472. >> Runtime for poller module 'mpls': 0.0002 seconds with 24080 bytes
1473. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
1474. #### Unload poller module mpls ####
1475.  
1476. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[784][0m 0.28ms]
1477.  
1478.  
1479. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[2.598,784][0m 0.33ms]
1480.  
1481. Updating 10.240.254.136  
1482.  
1483. Polled in 2.598 seconds
1484. ### Start Device Groups ###
1485. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.21ms]
1486.  
1487. 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, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 23) [0;33m[][0m 2.51ms]
1488.  
1489. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%Verw%",784][0m 0.23ms]
1490.  
1491. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;36mpe%",784][0m 0.13ms]
1492.  
1493. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["pfsense",784][0m 0.2ms]
1494.  
1495. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["gaia",784][0m 0.13ms]
1496.  
1497. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["linux",784][0m 0.13ms]
1498.  
1499. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["junos",784][0m 0.12ms]
1500.  
1501. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["sonicwall",784][0m 0.14ms]
1502.  
1503. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["netscaler",784][0m 0.13ms]
1504.  
1505. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["adva%",784][0m 0.12ms]
1506.  
1507. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["qnap",784][0m 0.13ms]
1508.  
1509. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%enexus%",784][0m 0.12ms]
1510.  
1511. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0mCS-55A2%",784][0m 0.13ms]
1512.  
1513. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;37mlc%",784][0m 0.17ms]
1514.  
1515. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[784][0m 0.25ms]
1516.  
1517. Groups Added:  
1518. Groups Removed:  
1519. ### End Device Groups, runtime: 0.0244s ###
1520.  
1521. #### Start Alerts ####
1522. 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[784][0m 0.28ms]
1523.  
1524. 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 `device_groups` inner join `alert_schedulables` on `device_groups`.`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` in (?)) 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["2022-01-19T12:56:22.467432Z","2022-01-19T12:56:22.467432Z",0,1,"12:56:22","12:56:22","12:56:22","12:56:22","[43m%","device",784,"device_group",14,"location",475][0m 0.64ms]
1525.  
1526. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[784][0m 0.33ms]
1527.  
1528. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
1529.         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 = ?)
1530.         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 = ?))
1531.         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 = ?))
1532.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
1533.         WHERE a.disabled = 0 AND (
1534.             (d.device_id IS NULL AND g.group_id IS NULL)
1535.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
1536.             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))
1537.         ) [0;33m[784,784,784,784,784,784,784,784][0m 1.39ms]
1538.  
1539. Rule [0;35m#1 (Devices up/down ):[0m  
1540.  
1541. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.sysName NOT LIKE 'cpe%' AND devices.sysName NOT LIKE '%sdz216004%' AND devices.sysName NOT LIKE '[0mas0b92ca%' AND devices.sysName NOT LIKE 'rt%' [0;33m[784][0m 0.33ms]
1542.  
1543. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,784][0m 0.15ms]
1544.  
1545. Status: [0;34mNOCHG[0m  
1546. Rule [0;35m#2 (Device rebooted):[0m  
1547.  
1548. 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 xss=removed xss=removed xss=removed xss=removed>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0) = 1 [0;33m[784][0m 0.66ms]
1549.  
1550. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,784][0m 0.24ms]
1551.  
1552. Status: [0;34mNOCHG[0m  
1553. Rule [0;35m#7 (Sensor over limit):[0m  
1554.  
1555. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[784][0m 0.36ms]
1556.  
1557. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,784][0m 0.12ms]
1558.  
1559. Status: [0;34mNOCHG[0m  
1560. Rule [0;35m#8 (Sensor under limit):[0m  
1561.  
1562. 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 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 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 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 45 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifName = "TenGigE0/0/0/0" [0;33m[784][0m 0.57ms]
1563.  
1564. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[18,784][0m 0.13ms]
1565.  
1566. Status: [0;34mNOCHG[0m  
1567. Rule [0;35m#19 (Port utilisation over threshold DDOS RT1-FRA):[0m  
1568.  
1569. SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 45 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifName = "TenGigE0/0/0/0" [0;33m[784][0m 0.54ms]
1570.  
1571. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[19,784][0m 0.15ms]
1572.  
1573. Status: [0;34mNOCHG[0m  
1574. Rule [0;35m#20 (Port utilisation over threshold DDOS RT2-FRA):[0m  
1575.  
1576. SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 45 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifName = "TenGigE0/0/0/0" [0;33m[784][0m 0.55ms]
1577.  
1578. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[20,784][0m 0.15ms]
1579.  
1580. Status: [0;34mNOCHG[0m  
1581. Rule [0;35m#21 (Port utilisation over threshold DDOS RT1-DUE):[0m  
1582.  
1583. SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 45 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifName = "TenGigE0/0/0/0" [0;33m[784][0m 0.55ms]
1584.  
1585. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[21,784][0m 0.12ms]
1586.  
1587. Status: [0;34mNOCHG[0m  
1588. Rule [0;35m#22 (Interface error rate over limit):[0m  
1589.  
1590. SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND ports.ifInErrors_rate >= 150 [0;33m[784][0m 0.44ms]
1591.  
1592. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[22,784][0m 0.12ms]
1593.  
1594. Status: [0;34mNOCHG[0m  
1595. #### End Alerts ####
1596.  
1597. ./poller.php 10.240.254.136 2022-01-19 13:56:22 - 1 devices polled in 2.868 secs  
1598.  
1599. [0;36mSNMP[0m [30/1.50s]: Snmpget[13/0.63s] Snmpwalk[17/0.87s]  
1600. [1;33mSQL[0m [117/0.41s]: Select[87/0.30s] Delete[3/0.01s] Insert[1/0.01s] Update[26/0.10s]  
1601.