From root, 1 Year ago, written in Plain Text.
Embed
  1. LibreNMS Poller
  2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.4ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.25ms]
  5.  
  6. SQL[[1;33mselect version() [0;33m[][0m 0.22ms]
  7.  
  8. ===========================================
  9. Component | Version
  10. --------- | -------
  11. LibreNMS  | 22.10.0 (2022-10-25T09:03:21-07:00)
  12. DB Schema | 2022_08_15_084507_add_rrd_type_to_wireless_sensors_table (249)
  13. PHP       | 8.1.2
  14. Python    | 3.10.6
  15. Database  | MariaDB 10.6.7-MariaDB-2ubuntu1.1
  16. RRDTool   | 1.7.2
  17. SNMP      | 5.9.1
  18. ===========================================
  19. DEBUG!
  20. Updating os_def.cache  
  21. Starting polling run:
  22.  
  23. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.100.100.188' ORDER BY `device_id` ASC [0;33m[][0m 0.78ms]
  24.  
  25. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[601][0m 0.55ms]
  26.  
  27. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[601][0m 0.56ms]
  28.  
  29. Attempting to initialize OS: sentry3  
  30. OS initialized as Generic  
  31. Hostname:    10.100.100.188
  32. Device ID:   601
  33. OS:          sentry3
  34.  
  35.  
  36. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '2' '-p' '300' '-t' '300' '-O' '0' '10.100.100.188'
  37.  
  38. response: xmt/rcv/%loss = 2/2/0%, min/avg/max = 1.61/1.95/2.28  
  39. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
  40. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.1718.3
  41.  
  42.  
  43. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[1.61,2.28,1.95,2,2,0,601,"2022-11-02 09:09:17"][0m 0.28ms]
  44.  
  45. SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[1.95,601][0m 0.22ms]
  46.  
  47. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/ping-perf.rrd N:1.95[0m]  
  48. 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[601][0m 0.36ms]
  49.  
  50. Modules status: Global+  
  51. OS  
  52. Device  
  53.  
  54. #### Load poller module core ####
  55. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m]  
  56. .*.*.0 = Sentry Remote Power Manager
  57. .*.*.0 = .*.4.1.1718.3
  58. .*.*.0 = 4211649855
  59. .*.*.0 = Snile#2
  60.  
  61.  
  62. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
  63. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = No Such Object available on this agent at this OID
  64. HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
  65.  
  66.  
  67. Uptime seconds: 42116499
  68.  
  69. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/uptime.rrd N:42116499[0m]  
  70. Uptime:  1 year 122 days 11 hours 1 minute 39 seconds
  71. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[42116499,601][0m 0.32ms]
  72.  
  73.  
  74. >> Runtime for poller module 'core': 0.0463 seconds with 78144 bytes
  75. >> [0;36mSNMP[0m: [2/0.04s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
  76. #### Unload poller module core ####
  77.  
  78. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-core.rrd N:0.046265125274658[0m]  
  79. Modules status: Global-  
  80. OS  
  81. Device  
  82. Module [ unix-agent ] disabled globally.
  83.  
  84. Modules status: Global+  
  85. OS  
  86. Device  
  87.  
  88. #### Load poller module os ####
  89. Generic :(
  90. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[78][0m 0.32ms]
  91.  
  92. Location: South Nile
  93. Hardware:
  94. OS Version: 5.3q
  95. OS Features:
  96. Serial:
  97.  
  98. >> Runtime for poller module 'os': 0.0030 seconds with 186664 bytes
  99. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
  100. #### Unload poller module os ####
  101.  
  102. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-os.rrd N:0.0030198097229004[0m]  
  103. Modules status: Global+  
  104. OS  
  105. Device  
  106.  
  107. #### Load poller module availability ####
  108. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[601][0m 0.32ms]
  109.  
  110. Availability:
  111. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[601][0m 0.25ms]
  112.  
  113. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[601,1667318957][0m 1.14ms]
  114.  
  115. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/availability-86400.rrd N:100[0m]  
  116. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,2277][0m 0.25ms]
  117.  
  118. 1 day : 100%
  119. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[601,1666800557][0m 0.29ms]
  120.  
  121. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/availability-604800.rrd N:100[0m]  
  122. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,2278][0m 0.25ms]
  123.  
  124. 7 days : 100%
  125. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[601,1664813357][0m 0.28ms]
  126.  
  127. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/availability-2592000.rrd N:100[0m]  
  128. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,2279][0m 0.22ms]
  129.  
  130. 30 days : 100%
  131. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[601,1635869357][0m 0.22ms]
  132.  
  133. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/availability-31536000.rrd N:100[0m]  
  134. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,2280][0m 0.18ms]
  135.  
  136. 365 days : 100%
  137.  
  138. >> Runtime for poller module 'availability': 0.0062 seconds with 18696 bytes
  139. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.03s] [0;32mRRD[0m: [5/0.00s]  
  140. #### Unload poller module availability ####
  141.  
  142. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-availability.rrd N:0.0061740875244141[0m]  
  143. Modules status: Global-  
  144. OS  
  145. Device  
  146. Module [ ipmi ] disabled globally.
  147.  
  148. Modules status: Global+  
  149. OS  
  150. Device  
  151.  
  152. #### Load poller module sensors ####
  153. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[601][0m 0.44ms]
  154.  
  155. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["current",601][0m 0.34ms]
  156.  
  157. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQntea' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.1' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.2' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.3' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.4' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.5' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.1.6' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.1' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.2' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.3' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.4'[0m]
  158. .*.4.1.17*.*.1 = 0
  159. .*.4.1.17*.*.2 = 0
  160. .*.4.1.17*.*.3 = 0
  161. .*.4.1.17*.*.4 = 150
  162. .*.4.1.17*.*.5 = 0
  163. .*.4.1.17*.*.6 = 0
  164. .*.4.1.17*.*.1 = 125
  165. .*.4.1.17*.*.2 = 0
  166. .*.4.1.17*.*.3 = 0
  167. .*.4.1.17*.*.4 = 0  
  168.  
  169. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQntea' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.5' '.1.3.6.1.4.1.1718.3.2.3.1.7.1.2.6'[0m]
  170. .*.4.1.17*.*.5 = 0
  171. .*.4.1.17*.*.6 = 0  
  172.  
  173. Checking (snmp) current Outlet AA1...
  174. Checking (snmp) current Outlet AA2...
  175. Checking (snmp) current Outlet AA3...
  176. Checking (snmp) current Outlet AA4...
  177. Checking (snmp) current Outlet AA5...
  178. Checking (snmp) current Outlet AA6...
  179. Checking (snmp) current Outlet AB1...
  180. Checking (snmp) current Outlet AB2...
  181. Checking (snmp) current Outlet AB3...
  182. Checking (snmp) current Outlet AB4...
  183. Checking (snmp) current Outlet AB5...
  184. Checking (snmp) current Outlet AB6...
  185. 0 A
  186. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.1.rrd N:0[0m]  
  187. 0 A
  188. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.2.rrd N:0[0m]  
  189. 0 A
  190. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.3.rrd N:0[0m]  
  191. 1.5 A
  192. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.4.rrd N:1.5[0m]  
  193. 0 A
  194. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.5.rrd N:0[0m]  
  195. 0 A
  196. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.1.6.rrd N:0[0m]  
  197. 1.25 A
  198. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.1.rrd N:1.25[0m]  
  199. 0 A
  200. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.2.rrd N:0[0m]  
  201. 0 A
  202. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.3.rrd N:0[0m]  
  203. 0 A
  204. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.4.rrd N:0[0m]  
  205. 0 A
  206. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.5.rrd N:0[0m]  
  207. 0 A
  208. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/sensor-current-sentry3-outletID.1.2.6.rrd N:0[0m]  
  209.  
  210. >> Runtime for poller module 'sensors': 0.0499 seconds with 1824 bytes
  211. >> [0;36mSNMP[0m: [2/0.04s] [1;33mMySQL[0m: [2/0.01s] [0;32mRRD[0m: [13/0.00s]  
  212. #### Unload poller module sensors ####
  213.  
  214. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-sensors.rrd N:0.049906015396118[0m]  
  215. Modules status: Global+  
  216. OS  
  217. Device  
  218.  
  219. #### Load poller module processors ####
  220. Attempting to initialize OS: sentry3  
  221. OS initialized as Generic  
  222. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[601][0m 0.5ms]
  223.  
  224.  
  225. >> Runtime for poller module 'processors': 0.0031 seconds with 59360 bytes
  226. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s]  
  227. #### Unload poller module processors ####
  228.  
  229. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-processors.rrd N:0.0030829906463623[0m]  
  230. Modules status: Global+  
  231. OS  
  232. Device  
  233.  
  234. #### Load poller module mempools ####
  235. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[601][0m 0.41ms]
  236.  
  237.  
  238. >> Runtime for poller module 'mempools': 0.0028 seconds with 79824 bytes
  239. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
  240. #### Unload poller module mempools ####
  241.  
  242. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-mempools.rrd N:0.0028159618377686[0m]  
  243. Modules status: Global+  
  244. OS  
  245. Device  
  246.  
  247. #### Load poller module storage ####
  248. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[601][0m 0.46ms]
  249.  
  250.  
  251. >> Runtime for poller module 'storage': 0.0011 seconds with 1328 bytes
  252. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
  253. #### Unload poller module storage ####
  254.  
  255. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-storage.rrd N:0.0011270046234131[0m]  
  256. Modules status: Global+  
  257. OS  
  258. Device  
  259.  
  260. #### Load poller module netstats ####
  261. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-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]  
  262. IP-MIB::icmpInMsgs.0 = 12378
  263. IP-MIB::icmpOutMsgs.0 = 2942
  264. IP-MIB::icmpInErrors.0 = 0
  265. IP-MIB::icmpOutErrors.0 = 0
  266. IP-MIB::icmpInEchos.0 = 2934
  267. IP-MIB::icmpOutEchos.0 = 0
  268. IP-MIB::icmpInEchoReps.0 = 0
  269. IP-MIB::icmpOutEchoReps.0 = 2934
  270. IP-MIB::icmpInDestUnreachs.0 = 9442
  271. IP-MIB::icmpOutDestUnreachs.0 = 6
  272. IP-MIB::icmpInParmProbs.0 = 0
  273. IP-MIB::icmpInTimeExcds.0 = 0
  274. IP-MIB::icmpInSrcQuenchs.0 = 0
  275. IP-MIB::icmpInRedirects.0 = 0
  276. IP-MIB::icmpInTimestamps.0 = 2
  277. IP-MIB::icmpInTimestampReps.0 = 0
  278. IP-MIB::icmpInAddrMasks.0 = 0
  279. IP-MIB::icmpInAddrMaskReps.0 = 0
  280. IP-MIB::icmpOutTimeExcds.0 = 0
  281. IP-MIB::icmpOutParmProbs.0 = 0
  282. IP-MIB::icmpOutSrcQuenchs.0 = 0
  283. IP-MIB::icmpOutRedirects.0 = 0
  284. IP-MIB::icmpOutTimestamps.0 = 0
  285. IP-MIB::icmpOutTimestampReps.0 = 2
  286. IP-MIB::icmpOutAddrMasks.0 = 0
  287. IP-MIB::icmpOutAddrMaskReps.0 = 0
  288.  
  289.  
  290. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/netstats-icmp.rrd N:12378:2942:0:0:2934:0:0:2934:9442:6:0:0:0:0:2:0:0:0:0:0:0:0:0:2:0:0[0m]  
  291. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-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]  
  292. IP-MIB::ipForwDatagrams.0 = 0
  293. IP-MIB::ipInDelivers.0 = 39190507
  294. IP-MIB::ipInReceives.0 = 41462143
  295. IP-MIB::ipOutRequests.0 = 11689127
  296. IP-MIB::ipInDiscards.0 = 0
  297. IP-MIB::ipOutDiscards.0 = 0
  298. IP-MIB::ipOutNoRoutes.0 = 0
  299. IP-MIB::ipReasmReqds.0 = 0
  300. IP-MIB::ipReasmOKs.0 = 0
  301. IP-MIB::ipReasmFails.0 = 0
  302. IP-MIB::ipFragOKs.0 = 0
  303. IP-MIB::ipFragFails.0 = 0
  304. IP-MIB::ipFragCreates.0 = 0
  305. IP-MIB::ipInUnknownProtos.0 = 0
  306. IP-MIB::ipInHdrErrors.0 = 18
  307. IP-MIB::ipInAddrErrors.0 = 2271618
  308.  
  309.  
  310. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/netstats-ip.rrd N:0:39190507:41462143:11689127:0:0:0:0:0:0:0:0:0:0:18:2271618[0m]  
  311. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
  312. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
  313.  
  314.  
  315. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-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]  
  316. SNMPv2-MIB::snmpInPkts.0 = 11685992
  317. SNMPv2-MIB::snmpOutPkts.0 = 11685952
  318. SNMPv2-MIB::snmpInBadVersions.0 = 0
  319. SNMPv2-MIB::snmpInBadCommunityNames.0 = 39
  320. SNMPv2-MIB::snmpInBadCommunityUses.0 = 39
  321. SNMPv2-MIB::snmpInASNParseErrs.0 = 0
  322. SNMPv2-MIB::snmpInTooBigs.0 = 0
  323. SNMPv2-MIB::snmpInNoSuchNames.0 = 0
  324. SNMPv2-MIB::snmpInBadValues.0 = 0
  325. SNMPv2-MIB::snmpInReadOnlys.0 = 0
  326. SNMPv2-MIB::snmpInGenErrs.0 = 0
  327. SNMPv2-MIB::snmpInTotalReqVars.0 = 80421599
  328. SNMPv2-MIB::snmpInTotalSetVars.0 = 0
  329. SNMPv2-MIB::snmpInGetRequests.0 = 5495081
  330. SNMPv2-MIB::snmpInGetNexts.0 = 983560
  331. SNMPv2-MIB::snmpInSetRequests.0 = 0
  332. SNMPv2-MIB::snmpInGetResponses.0 = 0
  333. SNMPv2-MIB::snmpInTraps.0 = 0
  334. SNMPv2-MIB::snmpOutTooBigs.0 = 0
  335. SNMPv2-MIB::snmpOutNoSuchNames.0 = 5353195
  336. SNMPv2-MIB::snmpOutBadValues.0 = 0
  337. SNMPv2-MIB::snmpOutGenErrs.0 = 0
  338. SNMPv2-MIB::snmpOutGetRequests.0 = 0
  339. SNMPv2-MIB::snmpOutGetNexts.0 = 0
  340. SNMPv2-MIB::snmpOutSetRequests.0 = 0
  341. SNMPv2-MIB::snmpOutGetResponses.0 = 11685952
  342. SNMPv2-MIB::snmpOutTraps.0 = 1
  343. SNMPv2-MIB::snmpSilentDrops.0 = 0
  344. SNMPv2-MIB::snmpProxyDrops.0 = 0
  345.  
  346.  
  347. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/netstats-snmp.rrd N:11685992:11685952:0:39:39:0:0:0:0:0:0:80421599:0:5495081:983560:0:0:0:0:5353195:0:0:0:0:0:11685952:1:0:0[0m]  
  348. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
  349. UDP-MIB::udpInDatagrams.0 = 38286721
  350. UDP-MIB::udpOutDatagrams.0 = 11685954
  351. UDP-MIB::udpInErrors.0 = 20297256
  352. UDP-MIB::udpNoPorts.0 = 6303472
  353.  
  354.  
  355. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/netstats-udp.rrd N:38286721:11685954:20297256:6303472[0m]  
  356. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' '-v2c' '-c' 'COMMUNITY' '-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]  
  357. TCP-MIB::tcpActiveOpens.0 = 0
  358. TCP-MIB::tcpPassiveOpens.0 = 10
  359. TCP-MIB::tcpAttemptFails.0 = 2
  360. TCP-MIB::tcpEstabResets.0 = 0
  361. TCP-MIB::tcpCurrEstab.0 = 0
  362. TCP-MIB::tcpInSegs.0 = 212
  363. TCP-MIB::tcpOutSegs.0 = 234
  364. TCP-MIB::tcpRetransSegs.0 = 0
  365. TCP-MIB::tcpInErrs.0 = 0
  366. TCP-MIB::tcpOutRsts.0 = 5
  367.  
  368.  
  369. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/netstats-tcp.rrd N:0:10:2:0:0:212:234:0:0:5[0m]  
  370.  
  371.  
  372. >> Runtime for poller module 'netstats': 0.2462 seconds with 23320 bytes
  373. >> [0;36mSNMP[0m: [6/0.24s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [6/0.00s]  
  374. #### Unload poller module netstats ####
  375.  
  376. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-netstats.rrd N:0.24623084068298[0m]  
  377. Modules status: Global-  
  378. OS  
  379. Device  
  380. Module [ hr-mib ] disabled globally.
  381.  
  382. Modules status: Global-  
  383. OS  
  384. Device  
  385. Module [ ucd-mib ] disabled globally.
  386.  
  387. Modules status: Global+  
  388. OS  
  389. Device  
  390.  
  391. #### Load poller module ipSystemStats ####
  392. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  393. ipSystemStatsTable = No Such Object available on this agent at this OID  
  394.  
  395. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
  396.  
  397.  
  398. >> Runtime for poller module 'ipSystemStats': 0.0362 seconds with 968 bytes
  399. >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s]  
  400. #### Unload poller module ipSystemStats ####
  401.  
  402. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-ipSystemStats.rrd N:0.036240100860596[0m]  
  403. Modules status: Global+  
  404. OS  
  405. Device  
  406.  
  407. #### Load poller module ports ####
  408. 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[601][0m 0.77ms]
  409.  
  410. Caching Oids: Full ports polling Reporting disabled by user setting  
  411. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  412. ifXEntry = No Such Object available on this agent at this OID  
  413.  
  414. Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
  415. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' 'ifEntry'[0m]
  416. ifIndex.1 = 1
  417. ifIndex.2 = 2
  418. ifDescr.1 = lo
  419. ifDescr.2 = eth0
  420. ifType.1 = other
  421. ifType.2 = iso88023Csmacd
  422. ifMtu.1 = 1500
  423. ifMtu.2 = 1500
  424. ifSpeed.1 = 0
  425. ifSpeed.2 = 100000000
  426. ifPhysAddress.1 = 0
  427. ifPhysAddress.2 = 0:a:9c:10:86:19
  428. ifAdminStatus.1 = up
  429. ifAdminStatus.2 = up
  430. ifOperStatus.1 = up
  431. ifOperStatus.2 = up
  432. ifLastChange.1 = 0
  433. ifLastChange.2 = 0
  434. ifInOctets.1 = 0
  435. ifInOctets.2 = 3213957923
  436. ifInUcastPkts.1 = 0
  437. ifInUcastPkts.2 = 11698598
  438. ifInNUcastPkts.1 = 0
  439. ifInNUcastPkts.2 = 1223436876
  440. ifInDiscards.1 = 0
  441. ifInDiscards.2 = 0
  442. ifInErrors.1 = 0
  443. ifInErrors.2 = 0
  444. ifInUnknownProtos.1 = 0
  445. ifInUnknownProtos.2 = 0
  446. ifOutOctets.1 = 0
  447. ifOutOctets.2 = 2288495111
  448. ifOutUcastPkts.1 = 0
  449. ifOutUcastPkts.2 = 11689139
  450. ifOutNUcastPkts.1 = 0
  451. ifOutNUcastPkts.2 = 144802
  452. ifOutDiscards.1 = 0
  453. ifOutDiscards.2 = 0
  454. ifOutErrors.1 = 0
  455. ifOutErrors.2 = 0
  456. ifOutQLen.1 = 0
  457. ifOutQLen.2 = 0
  458. ifSpecific.1 = zeroDotZero
  459. ifSpecific.2 = zeroDotZero  
  460.  
  461. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  462. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  463.  
  464. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  465. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sentry' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  466. dot1qPvid = No Such Object available on this agent at this OID  
  467.  
  468. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
  469. array (
  470.   1 =>
  471.   array (
  472.     'ifIndex' => '1',
  473.     'ifDescr' => 'lo',
  474.     'ifType' => 'other',
  475.     'ifMtu' => '1500',
  476.     'ifSpeed' => '0',
  477.     'ifPhysAddress' => '0',
  478.     'ifAdminStatus' => 'up',
  479.     'ifOperStatus' => 'up',
  480.     'ifLastChange' => '0',
  481.     'ifInOctets' => '0',
  482.     'ifInUcastPkts' => '0',
  483.     'ifInNUcastPkts' => '0',
  484.     'ifInDiscards' => '0',
  485.     'ifInErrors' => '0',
  486.     'ifInUnknownProtos' => '0',
  487.     'ifOutOctets' => '0',
  488.     'ifOutUcastPkts' => '0',
  489.     'ifOutNUcastPkts' => '0',
  490.     'ifOutDiscards' => '0',
  491.     'ifOutErrors' => '0',
  492.     'ifOutQLen' => '0',
  493.     'ifSpecific' => 'zeroDotZero',
  494.   ),
  495.   2 =>
  496.   array (
  497.     'ifIndex' => '2',
  498.     'ifDescr' => 'eth0',
  499.     'ifType' => 'iso88023Csmacd',
  500.     'ifMtu' => '1500',
  501.     'ifSpeed' => '100000000',
  502.     'ifPhysAddress' => '0:a:9c:10:86:19',
  503.     'ifAdminStatus' => 'up',
  504.     'ifOperStatus' => 'up',
  505.     'ifLastChange' => '0',
  506.     'ifInOctets' => '3213957923',
  507.     'ifInUcastPkts' => '11698598',
  508.     'ifInNUcastPkts' => '1223436876',
  509.     'ifInDiscards' => '0',
  510.     'ifInErrors' => '0',
  511.     'ifInUnknownProtos' => '0',
  512.     'ifOutOctets' => '2288495111',
  513.     'ifOutUcastPkts' => '11689139',
  514.     'ifOutNUcastPkts' => '144802',
  515.     'ifOutDiscards' => '0',
  516.     'ifOutErrors' => '0',
  517.     'ifOutQLen' => '0',
  518.     'ifSpecific' => 'zeroDotZero',
  519.   ),
  520. )  
  521.  valid  
  522.  valid  
  523.  
  524. Port lo: lo (1 / #27819) ifInOctets  
  525. ifOutOctets  
  526. ifInUcastPkts  
  527. ifOutUcastPkts  
  528. ifInBroadcastPkts  
  529. ifOutBroadcastPkts  
  530. ifInMulticastPkts  
  531. ifOutMulticastPkts  
  532. ifSpeed (0)  
  533. VLAN = ?  Using ifDescr as ifAlias  
  534.  Using ifDescr as ifName  
  535. lo
  536.  ifInOctets (0 B) 0 Bps 13 secs  
  537.  
  538.  ifOutOctets (0 B) 0 Bps 13 secs  
  539.  
  540.  ifInErrors (0 B) 0 Bps 13 secs  
  541.  
  542.  ifOutErrors (0 B) 0 Bps 13 secs  
  543.  
  544.  ifInUcastPkts (0 B) 0 Bps 13 secs  
  545.  
  546.  ifOutUcastPkts (0 B) 0 Bps 13 secs  
  547.  
  548.  ifInNUcastPkts (0 B) 0 Bps 13 secs  
  549.  
  550.  ifOutNUcastPkts (0 B) 0 Bps 13 secs  
  551.  
  552.  ifInDiscards (0 B) 0 Bps 13 secs  
  553.  
  554.  ifOutDiscards (0 B) 0 Bps 13 secs  
  555.  
  556.  ifInUnknownProtos (0 B) 0 Bps 13 secs  
  557.  
  558.  ifInBroadcastPkts (0 B) 0 Bps 13 secs  
  559.  
  560.  ifOutBroadcastPkts (0 B) 0 Bps 13 secs  
  561.  
  562.  ifInMulticastPkts (0 B) 0 Bps 13 secs  
  563.  
  564.  ifOutMulticastPkts (0 B) 0 Bps 13 secs  
  565. bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD warning: unused data sent ifInUcastPkts_rate  
  566. RRD warning: unused data sent ifOutUcastPkts_rate  
  567. RRD warning: unused data sent ifInErrors_rate  
  568. RRD warning: unused data sent ifOutErrors_rate  
  569. RRD warning: unused data sent ifInOctets_rate  
  570. RRD warning: unused data sent ifOutOctets_rate  
  571. RRD warning: unused data sent ifInBits_rate  
  572. RRD warning: unused data sent ifOutBits_rate  
  573. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/port-id27819.rrd N:0:0:0:0:0:0:0:0:0:0:0:U:U:U:U[0m]  
  574. 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,1667405358,1667405345,13,27819][0m 0.73ms]
  575.  
  576. 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,27819][0m 0.49ms]
  577.  
  578. 1 updated  
  579.  
  580. Port eth0: eth0 (2 / #27820) ifInOctets  
  581. ifOutOctets  
  582. ifInUcastPkts  
  583. ifOutUcastPkts  
  584. ifInBroadcastPkts  
  585. ifOutBroadcastPkts  
  586. ifInMulticastPkts  
  587. ifOutMulticastPkts  
  588. ifSpeed (100000000)  
  589. VLAN = ?  Using ifDescr as ifAlias  
  590.  Using ifDescr as ifName  
  591. eth0
  592.  ifInOctets (15494 B) 1191.8461538462 Bps 13 secs  
  593.  
  594.  ifOutOctets (10748 B) 826.76923076923 Bps 13 secs  
  595.  
  596.  ifInErrors (0 B) 0 Bps 13 secs  
  597.  
  598.  ifOutErrors (0 B) 0 Bps 13 secs  
  599.  
  600.  ifInUcastPkts (51 B) 3.9230769230769 Bps 13 secs  
  601.  
  602.  ifOutUcastPkts (50 B) 3.8461538461538 Bps 13 secs  
  603.  
  604.  ifInNUcastPkts (125 B) 9.6153846153846 Bps 13 secs  
  605.  
  606.  ifOutNUcastPkts (0 B) 0 Bps 13 secs  
  607.  
  608.  ifInDiscards (0 B) 0 Bps 13 secs  
  609.  
  610.  ifOutDiscards (0 B) 0 Bps 13 secs  
  611.  
  612.  ifInUnknownProtos (0 B) 0 Bps 13 secs  
  613.  
  614.  ifInBroadcastPkts (0 B) 0 Bps 13 secs  
  615.  
  616.  ifOutBroadcastPkts (0 B) 0 Bps 13 secs  
  617.  
  618.  ifInMulticastPkts (0 B) 0 Bps 13 secs  
  619.  
  620.  ifOutMulticastPkts (0 B) 0 Bps 13 secs  
  621. bps(9.54 kbps/6.61 kbps)bytes(15.13 KiB/10.5 KiB)pkts(3.92 pps/3.85 pps)RRD warning: unused data sent ifInUcastPkts_rate  
  622. RRD warning: unused data sent ifOutUcastPkts_rate  
  623. RRD warning: unused data sent ifInErrors_rate  
  624. RRD warning: unused data sent ifOutErrors_rate  
  625. RRD warning: unused data sent ifInOctets_rate  
  626. RRD warning: unused data sent ifOutOctets_rate  
  627. RRD warning: unused data sent ifInBits_rate  
  628. RRD warning: unused data sent ifOutBits_rate  
  629. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/port-id27820.rrd N:3213957923:2288495111:0:0:11698598:11689139:1223436876:144802:0:0:0:U:U:U:U[0m]  
  630. 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["3213957923",3213942429,1191.8461538461538,15494,"2288495111",2288484363,826.7692307692307,10748,"0",0,0,0,"0",0,0,0,"11698598",11698547,3.923076923076923,51,"11689139",11689089,3.8461538461538463,50,1667405358,1667405345,13,27820][0m 0.52ms]
  631.  
  632. 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["1223436876",1223436751,9.615384615384615,125,"144802",144802,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,27820][0m 0.69ms]
  633.  
  634. 2 updated  
  635.  
  636. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1667405358,1667405345,null][0m 0.22ms]
  637.  
  638. 0 updated  
  639.  
  640. >> Runtime for poller module 'ports': 0.2088 seconds with 59096 bytes
  641. >> [0;36mSNMP[0m: [4/0.20s] [1;33mMySQL[0m: [6/0.03s] [0;32mRRD[0m: [3/0.00s]  
  642. #### Unload poller module ports ####
  643.  
  644. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-ports.rrd N:0.2087550163269[0m]  
  645. Modules status: Global-  
  646. OS  
  647. Device  
  648. Module [ xdsl ] disabled globally.
  649.  
  650. Modules status: Global+  
  651. OS  
  652. Device  
  653.  
  654. #### Load poller module customoid ####
  655. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[601][0m 0.58ms]
  656.  
  657.  
  658. >> Runtime for poller module 'customoid': 0.0009 seconds with 1744 bytes
  659. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s]  
  660. #### Unload poller module customoid ####
  661.  
  662. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-customoid.rrd N:0.00085306167602539[0m]  
  663. Modules status: Global-  
  664. OS-  
  665. Device  
  666. Module [ bgp-peers ] disabled on os.
  667.  
  668. Modules status: Global-  
  669. OS  
  670. Device  
  671. Module [ junose-atm-vp ] disabled globally.
  672.  
  673. Modules status: Global-  
  674. OS  
  675. Device  
  676. Module [ printer-supplies ] disabled globally.
  677.  
  678. Modules status: Global-  
  679. OS  
  680. Device  
  681. Module [ ucd-diskio ] disabled globally.
  682.  
  683. Modules status: Global-  
  684. OS  
  685. Device  
  686. Module [ wifi ] disabled globally.
  687.  
  688. Modules status: Global-  
  689. OS-  
  690. Device  
  691. Module [ wireless ] disabled on os.
  692.  
  693. Modules status: Global-  
  694. OS-  
  695. Device  
  696. Module [ ospf ] disabled on os.
  697.  
  698. Modules status: Global-  
  699. OS  
  700. Device  
  701. Module [ isis ] disabled globally.
  702.  
  703. Modules status: Global-  
  704. OS  
  705. Device  
  706. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  707.  
  708. Modules status: Global-  
  709. OS  
  710. Device  
  711. Module [ cisco-remote-access-monitor ] disabled globally.
  712.  
  713. Modules status: Global-  
  714. OS  
  715. Device  
  716. Module [ cisco-cef ] disabled globally.
  717.  
  718. Modules status: Global-  
  719. OS  
  720. Device  
  721. Module [ slas ] disabled globally.
  722.  
  723. Modules status: Global-  
  724. OS  
  725. Device  
  726. Module [ cisco-mac-accounting ] disabled globally.
  727.  
  728. Modules status: Global-  
  729. OS  
  730. Device  
  731. Module [ cipsec-tunnels ] disabled globally.
  732.  
  733. Modules status: Global-  
  734. OS  
  735. Device  
  736. Module [ cisco-ace-loadbalancer ] disabled globally.
  737.  
  738. Modules status: Global-  
  739. OS  
  740. Device  
  741. Module [ cisco-ace-serverfarms ] disabled globally.
  742.  
  743. Modules status: Global-  
  744. OS  
  745. Device  
  746. Module [ cisco-asa-firewall ] disabled globally.
  747.  
  748. Modules status: Global-  
  749. OS  
  750. Device  
  751. Module [ cisco-voice ] disabled globally.
  752.  
  753. Modules status: Global-  
  754. OS  
  755. Device  
  756. Module [ cisco-cbqos ] disabled globally.
  757.  
  758. Modules status: Global-  
  759. OS  
  760. Device  
  761. Module [ cisco-otv ] disabled globally.
  762.  
  763. Modules status: Global-  
  764. OS  
  765. Device  
  766. Module [ cisco-qfp ] disabled globally.
  767.  
  768. Modules status: Global-  
  769. OS  
  770. Device  
  771. Module [ cisco-vpdn ] disabled globally.
  772.  
  773. Modules status: Global-  
  774. OS  
  775. Device  
  776. Module [ nac ] disabled globally.
  777.  
  778. Modules status: Global-  
  779. OS  
  780. Device  
  781. Module [ netscaler-vsvr ] disabled globally.
  782.  
  783. Modules status: Global-  
  784. OS  
  785. Device  
  786. Module [ aruba-controller ] disabled globally.
  787.  
  788. Modules status: Global+  
  789. OS  
  790. Device  
  791.  
  792. #### Load poller module entity-physical ####
  793.  
  794. >> Runtime for poller module 'entity-physical': 0.0001 seconds with 392 bytes
  795. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s]  
  796. #### Unload poller module entity-physical ####
  797.  
  798. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf-entity-physical.rrd N:6.9141387939453E-5[0m]  
  799. Modules status: Global-  
  800. OS  
  801. Device  
  802. Module [ entity-state ] disabled globally.
  803.  
  804. Modules status: Global-  
  805. OS  
  806. Device  
  807. Module [ applications ] disabled globally.
  808.  
  809. Modules status: Global-  
  810. OS-  
  811. Device  
  812. Module [ stp ] disabled on os.
  813.  
  814. Modules status: Global-  
  815. OS  
  816. Device  
  817. Module [ ntp ] disabled globally.
  818.  
  819. Modules status: Global-  
  820. OS  
  821. Device  
  822. Module [ loadbalancers ] disabled globally.
  823.  
  824. Modules status: Global-  
  825. OS  
  826. Device  
  827. Module [ mef ] disabled globally.
  828.  
  829. Modules status: Global-  
  830. OS  
  831. Device  
  832. Module [ mpls ] disabled globally.
  833.  
  834. RRD[[0;32mupdate /opt/librenms/rrd/10.100.100.188/poller-perf.rrd N:0.961[0m]  
  835. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[601][0m 0.5ms]
  836.  
  837.  
  838. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[0.961,601][0m 0.45ms]
  839.  
  840. Updating 10.100.100.188  
  841.  
  842. Polled in 0.961 seconds
  843. ### Start Device Groups ###
  844. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.41ms]
  845.  
  846. 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, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) [0;33m[][0m 3.15ms]
  847.  
  848. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.1916.2.202",601][0m 0.43ms]
  849.  
  850. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.1916.2.93",601][0m 0.33ms]
  851.  
  852. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.738.1.5.100.1.1.7",601][0m 0.36ms]
  853.  
  854. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.1991.1.16.1",601][0m 0.36ms]
  855.  
  856. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.33.100.1.2.1.11",601][0m 0.35ms]
  857.  
  858. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.1991.1.3.48.3.1",601][0m 0.34ms]
  859.  
  860. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["V2224G-OP",601][0m 0.34ms]
  861.  
  862. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["V2224G",601][0m 0.37ms]
  863.  
  864. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ? OR `devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.318.1.3.4.5",".1.3.6.1.4.1.318.1.3.4.6",601][0m 0.37ms]
  865.  
  866. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.33.8.1.%",601][0m 0.35ms]
  867.  
  868. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.23465",601][0m 0.34ms]
  869.  
  870. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.39145.10",601][0m 0.34ms]
  871.  
  872. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.5504.1.2.10.2.2",601][0m 0.34ms]
  873.  
  874. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `bill_ports` on `ports`.`port_id` = `bill_ports`.`port_id` left join `bills` on `bill_ports`.`bill_id` = `bills`.`bill_id` where (`bills`.`bill_name` != ?) and `devices`.`device_id` = ?) as `exists` [0;33m["",601][0m 0.51ms]
  875.  
  876. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%.1.3.6.1.4.1.10002.1%",601][0m 0.3ms]
  877.  
  878. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.14988.1",601][0m 0.27ms]
  879.  
  880. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.52642.2.1.45.103",601][0m 0.27ms]
  881.  
  882. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysDescr` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%V2724GG%",601][0m 0.27ms]
  883.  
  884. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.52642.1.1.10.1.793",601][0m 0.29ms]
  885.  
  886. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.1916.2.214",601][0m 0.28ms]
  887.  
  888. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.7309.4",601][0m 0.27ms]
  889.  
  890. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.534.1",601][0m 0.51ms]
  891.  
  892. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`inserted` > ?) and `devices`.`device_id` = ?) as `exists` [0;33m["100",601][0m 0.43ms]
  893.  
  894. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.52642.1.458.0",601][0m 0.39ms]
  895.  
  896. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[601][0m 0.45ms]
  897.  
  898. Groups Added:  
  899. Groups Removed:  
  900. ### End Device Groups, runtime: 0.0324s ###
  901.  
  902. #### Start Alerts ####
  903. 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[601][0m 0.58ms]
  904.  
  905. 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(`start`) &lt;= ? or time(`end`) > ?))) 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 (25)) 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-11-02T16:09:18.267353Z","2022-11-02T16:09:18.267353Z",0,1,"16:09:18","16:09:18","16:09:18","16:09:18","[43m%","device",601,"device_group","location",78][0m 1.28ms]
  906.  
  907. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[601][0m 0.52ms]
  908.  
  909. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  910.         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 = ?)
  911.         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 = ?))
  912.         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 = ?))
  913.         LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ?
  914.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  915.         WHERE a.disabled = 0 AND (
  916.             (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL)
  917.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?))
  918.             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) AND (ld.device_id != ? OR ld.device_id IS NULL))
  919.         ) [0;33m[601,601,601,601,601,601,601,601,601,601,601][0m 2.84ms]
  920.  
  921. Rule [0;35m#2 (Device rebooted):[0m  
  922.  
  923. 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>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 65 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[601][0m 1.17ms]
  924.  
  925. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,601][0m 0.39ms]
  926.  
  927. Status: [0;34mNOCHG[0m  
  928. Rule [0;35m#15 (Port utilisation over threshold Warning 80 percent):[0m  
  929.  
  930. 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) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[601][0m 0.81ms]
  931.  
  932. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,601][0m 0.24ms]
  933.  
  934. Status: [0;34mNOCHG[0m  
  935. Rule [0;35m#18 (Billing Usage at 2 TB):[0m  
  936.  
  937. SQL[[1;33mSELECT * FROM devices,ports,bill_ports,bills WHERE (devices.device_id = ? AND devices.device_id = ports.device_id AND ports.port_id = bill_ports.port_id AND bill_ports.bill_id = bills.bill_id) AND (((bills.total_data / bills.bill_quota)*100 > 40) && bills.bill_type = "quota") = 1 [0;33m[601][0m 0.82ms]
  938.  
  939. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[18,601][0m 0.24ms]
  940.  
  941. Status: [0;34mNOCHG[0m  
  942. Rule [0;35m#19 (Billing usage at 4 TB):[0m  
  943.  
  944. SQL[[1;33mSELECT * FROM devices,ports,bill_ports,bills WHERE (devices.device_id = ? AND devices.device_id = ports.device_id AND ports.port_id = bill_ports.port_id AND bill_ports.bill_id = bills.bill_id) AND (((bills.total_data / bills.bill_quota)*100 > 80) && bills.bill_type = "quota") = 1 [0;33m[601][0m 0.77ms]
  945.  
  946. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[19,601][0m 0.24ms]
  947.  
  948. Status: [0;34mNOCHG[0m  
  949. Rule [0;35m#20 (Billing usage exceeded 5 TB):[0m  
  950.  
  951. SQL[[1;33mSELECT * FROM devices,ports,bill_ports,bills WHERE (devices.device_id = ? AND devices.device_id = ports.device_id AND ports.port_id = bill_ports.port_id AND bill_ports.bill_id = bills.bill_id) AND (((bills.total_data / bills.bill_quota)*100 > 100) && bills.bill_type = "quota") = 1 [0;33m[601][0m 0.91ms]
  952.  
  953. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[20,601][0m 0.53ms]
  954.  
  955. Status: [0;34mNOCHG[0m  
  956. Rule [0;35m#21 (Blown fuse):[0m  
  957.  
  958. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_type LIKE '[5muse%' AND sensors.sensor_alert = "OPEN" [0;33m[601][0m 0.97ms]
  959.  
  960. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[21,601][0m 0.42ms]
  961.  
  962. Status: [0;34mNOCHG[0m  
  963. #### End Alerts ####
  964. ./poller.php 10.100.100.188 2022-11-02 09:09:18 - 1 devices polled in 1.194 secs  
  965.  
  966. [0;36mSNMP[0m [16/0.58s]: Snmpget[11/0.35s] Snmpwalk[5/0.23s]  
  967. [1;33mSQL[0m [81/0.41s]: Select[68/0.36s] Insert[1/0.00s] Update[12/0.05s]  
  968. [0;32mRRD[0m [38/0.01s]: Update[38/0.01s]  
  969.