LibreNMS Pastebin service

ℹ️ Your data is safe here... unless you make the SNIP gods angry. And let's just say they have a really bad sense of humor.

Untitled

From verw0007, 2 Years ago, written in Plain Text.
URL https://p.libren.ms/view/57e65f61
Embed Show code
Download Paste or View Raw
  1. LibreNMS Poller
  2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.27ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.16ms]
  5.  
  6. SQL[[1;33mselect version() [0;33m[][0m 0.17ms]
  7.  
  8. ===================================
  9. Version info:
  10. Commit SHA:
  11. Commit Date:
  12. DB Schema: 2022_07_19_081224_plugins_unique_index (243)
  13. PHP: 7.4.30
  14. MySQL: 10.5.16-MariaDB-1:10.5.16+maria~bionic
  15. RRDTool: 1.7.0
  16. SNMP: 5.7.3
  17. ==================================DEBUG!
  18. Updating os_def.cache  
  19. Starting polling run:
  20.  
  21. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'ups-vr1k2-b.myhz.nl' ORDER BY `device_id` ASC [0;33m[][0m 0.64ms]
  22.  
  23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[21][0m 0.33ms]
  24.  
  25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[21][0m 0.14ms]
  26.  
  27. Attempting to initialize OS: apc  
  28. OS initialized: LibreNMS\OS\Apc  
  29. Hostname:    ups-vr1k2-b.myhz.nl
  30. Device ID:   21
  31. OS:          apc
  32. Resolved IP: 145.19.127.73
  33.  
  34.  
  35. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' 'ups-vr1k2-b.myhz.nl'
  36.  
  37. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.49/0.55/0.6  
  38. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
  39. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.3*
  40.  
  41.  
  42. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.49,0.6,0.55,3,3,0,21,"2022-08-19 11:44:48"][0m 0.9ms]
  43.  
  44. SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[0.55,21][0m 0.69ms]
  45.  
  46. 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[21][0m 0.21ms]
  47.  
  48. Modules status: Global+  
  49. OS  
  50. Device  
  51.  
  52. #### Load poller module core ####
  53. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-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]  
  54. .*.*.0 = APC Web/SNMP Management Card (MB:v4.2.9 PF:v* PN:apc_hw21_aos_*.bin AF1:v* AN1:apc_hw21_su_*.bin MN:AP9641 HR:5 SN: 5A2111T33391 MD:03/17/2021) (Embedded PowerNet SNMP Agent SW v2.2 compatible)
  55. .*.*.0 = .*.4.1.3*
  56. .*.*.0 = 8829100
  57. .*.*.0 = ups-vr1k2-b
  58.  
  59.  
  60. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
  61. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 88291
  62. HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
  63.  
  64.  
  65. Uptime seconds: 88291
  66.  
  67. Uptime:  1 day 31 minutes 31 seconds
  68. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[88291,21][0m 0.82ms]
  69.  
  70.  
  71. >> Runtime for poller module 'core': 0.0212 seconds with 70544 bytes
  72. >> [0;36mSNMP[0m: [2/0.02s] [1;33mMySQL[0m: [1/0.01s]  
  73. #### Unload poller module core ####
  74.  
  75. Modules status: Global-  
  76. OS  
  77. Device  
  78. Module [ unix-agent ] disabled globally.
  79.  
  80. Modules status: Global+  
  81. OS  
  82. Device  
  83.  
  84. #### Load poller module os ####
  85. Generic :(
  86. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[30][0m 0.21ms]
  87.  
  88. Location: VR1K2, V110, Vlissingen
  89. Hardware: Smart-UPS 3000 UPS 09.3 (ID18)
  90. OS Version: AOS v2.2.0.1 / App v2.2.1.1
  91. OS Features:
  92. Serial: AS2111164239
  93.  
  94. >> Runtime for poller module 'os': 0.0027 seconds with 183304 bytes
  95. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  96. #### Unload poller module os ####
  97.  
  98. Modules status: Global+  
  99. OS  
  100. Device  
  101.  
  102. #### Load poller module availability ####
  103. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[21][0m 0.13ms]
  104.  
  105. Availability:
  106. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[21][0m 0.11ms]
  107.  
  108. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[21,1660815888][0m 0.35ms]
  109.  
  110. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,273][0m 0.15ms]
  111.  
  112. 1 day : 100%
  113. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[21,1660297488][0m 0.25ms]
  114.  
  115. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,274][0m 0.14ms]
  116.  
  117. 7 days : 100%
  118. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[21,1658310288][0m 0.24ms]
  119.  
  120. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.988,275][0m 0.13ms]
  121.  
  122. 30 days : 99.988%
  123. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[21,1629366288][0m 0.26ms]
  124.  
  125. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[95.481,276][0m 0.14ms]
  126.  
  127. 365 days : 95.481%
  128.  
  129. >> Runtime for poller module 'availability': 0.0041 seconds with 13264 bytes
  130. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.02s]  
  131. #### Unload poller module availability ####
  132.  
  133. Modules status: Global+  
  134. OS  
  135. Device  
  136.  
  137. #### Load poller module ipmi ####
  138. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[21][0m 0.35ms]
  139.  
  140. array (
  141. )  
  142.  
  143. >> Runtime for poller module 'ipmi': 0.0007 seconds with 1592 bytes
  144. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  145. #### Unload poller module ipmi ####
  146.  
  147. Modules status: Global+  
  148. OS  
  149. Device  
  150.  
  151. #### Load poller module sensors ####
  152. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[21][0m 0.29ms]
  153.  
  154. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["charge",21][0m 0.32ms]
  155.  
  156. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.2.3.1.0'[0m]
  157. .*.4.1.3*.* = 1000  
  158.  
  159. Checking (snmp) charge Battery Charge...
  160. 100 %
  161. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["current",21][0m 0.47ms]
  162.  
  163. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.4.3.4.0'[0m]
  164. .*.4.1.3*.* = 30  
  165.  
  166. Checking (snmp) current Phase 0 Output...
  167. 3 A
  168. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["frequency",21][0m 0.57ms]
  169.  
  170. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.3.3.4.0' '.1.3.6.1.4.1.318.1.1.1.4.3.2.0'[0m]
  171. .*.4.1.3*.* = 500
  172. .*.4.1.3*.* = 500  
  173.  
  174. Checking (snmp) frequency Input...
  175. Checking (snmp) frequency Output...
  176. 50 Hz
  177. 50 Hz
  178. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["load",21][0m 0.52ms]
  179.  
  180. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.4.3.3.0'[0m]
  181. .*.4.1.3*.* = 234  
  182.  
  183. Checking (snmp) load Load(VA)...
  184. 23.4 %
  185. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["runtime",21][0m 0.5ms]
  186.  
  187. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.2.2.3.0'[0m]
  188. .*.4.1.3*.* = 324000  
  189.  
  190. Checking (snmp) runtime Runtime...
  191. 54 Min
  192. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[54,52,"runtime",273][0m 0.96ms]
  193.  
  194. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["state",21][0m 0.48ms]
  195.  
  196. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.2.2.4.0' '.1.3.6.1.4.1.318.1.1.1.4.1.1.0'[0m]
  197. .*.4.1.3*.* = 1
  198. .*.4.1.3*.* = 2  
  199.  
  200. Checking (snmp) state UPS Battery Replacement Status...
  201. Checking (snmp) state Output Status...
  202. 1 #
  203. 2 #
  204. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["temperature",21][0m 0.58ms]
  205.  
  206. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.2.3.2.0'[0m]
  207. .*.4.1.3*.* = 266  
  208.  
  209. Checking (snmp) temperature Internal Temperature...
  210. 26.6 C
  211. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["voltage",21][0m 0.65ms]
  212.  
  213. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.1.2.3.4.0' '.1.3.6.1.4.1.318.1.1.1.3.3.1.0' '.1.3.6.1.4.1.318.1.1.1.4.3.1.0'[0m]
  214. .*.4.1.3*.* = 542
  215. .*.4.1.3*.* = 2289
  216. .*.4.1.3*.* = 2289  
  217.  
  218. Checking (snmp) voltage Battery Bus...
  219. Checking (snmp) voltage Input...
  220. Checking (snmp) voltage Output...
  221. 54.2 V
  222. 228.9 V
  223. 228.9 V
  224.  
  225. >> Runtime for poller module 'sensors': 0.0819 seconds with 520 bytes
  226. >> [0;36mSNMP[0m: [8/0.07s] [1;33mMySQL[0m: [10/0.05s]  
  227. #### Unload poller module sensors ####
  228.  
  229. Modules status: Global+  
  230. OS  
  231. Device  
  232.  
  233. #### Load poller module processors ####
  234. Attempting to initialize OS: apc  
  235. OS initialized: LibreNMS\OS\Apc  
  236. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[21][0m 0.41ms]
  237.  
  238.  
  239. >> Runtime for poller module 'processors': 0.0027 seconds with 59056 bytes
  240. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  241. #### Unload poller module processors ####
  242.  
  243. Modules status: Global+  
  244. OS  
  245. Device  
  246.  
  247. #### Load poller module mempools ####
  248. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[21][0m 0.31ms]
  249.  
  250.  
  251. >> Runtime for poller module 'mempools': 0.0024 seconds with 76976 bytes
  252. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  253. #### Unload poller module mempools ####
  254.  
  255. Modules status: Global+  
  256. OS  
  257. Device  
  258.  
  259. #### Load poller module storage ####
  260. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[21][0m 0.26ms]
  261.  
  262.  
  263. >> Runtime for poller module 'storage': 0.0008 seconds with 904 bytes
  264. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  265. #### Unload poller module storage ####
  266.  
  267. Modules status: Global+  
  268. OS  
  269. Device  
  270.  
  271. #### Load poller module netstats ####
  272. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-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]  
  273. IP-MIB::icmpInMsgs.0 = 1226
  274. IP-MIB::icmpOutMsgs.0 = 1226
  275. IP-MIB::icmpInErrors.0 = 0
  276. IP-MIB::icmpOutErrors.0 = 0
  277. IP-MIB::icmpInEchos.0 = 900
  278. IP-MIB::icmpOutEchos.0 = 326
  279. IP-MIB::icmpInEchoReps.0 = 326
  280. IP-MIB::icmpOutEchoReps.0 = 900
  281. IP-MIB::icmpInDestUnreachs.0 = 0
  282. IP-MIB::icmpOutDestUnreachs.0 = 0
  283. IP-MIB::icmpInParmProbs.0 = 0
  284. IP-MIB::icmpInTimeExcds.0 = 0
  285. IP-MIB::icmpInSrcQuenchs.0 = 0
  286. IP-MIB::icmpInRedirects.0 = 0
  287. IP-MIB::icmpInTimestamps.0 = 0
  288. IP-MIB::icmpInTimestampReps.0 = 0
  289. IP-MIB::icmpInAddrMasks.0 = 0
  290. IP-MIB::icmpInAddrMaskReps.0 = 0
  291. IP-MIB::icmpOutTimeExcds.0 = 0
  292. IP-MIB::icmpOutParmProbs.0 = 0
  293. IP-MIB::icmpOutSrcQuenchs.0 = 0
  294. IP-MIB::icmpOutRedirects.0 = 0
  295. IP-MIB::icmpOutTimestamps.0 = 0
  296. IP-MIB::icmpOutTimestampReps.0 = 0
  297. IP-MIB::icmpOutAddrMasks.0 = 0
  298. IP-MIB::icmpOutAddrMaskReps.0 = 0
  299.  
  300.  
  301. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-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]  
  302. IP-MIB::ipForwDatagrams.0 = 0
  303. IP-MIB::ipInDelivers.0 = 20812
  304. IP-MIB::ipInReceives.0 = 20812
  305. IP-MIB::ipOutRequests.0 = 18381
  306. IP-MIB::ipInDiscards.0 = 0
  307. IP-MIB::ipOutDiscards.0 = 0
  308. IP-MIB::ipOutNoRoutes.0 = 0
  309. IP-MIB::ipReasmReqds.0 = 0
  310. IP-MIB::ipReasmOKs.0 = 0
  311. IP-MIB::ipReasmFails.0 = 0
  312. IP-MIB::ipFragOKs.0 = 0
  313. IP-MIB::ipFragFails.0 = 0
  314. IP-MIB::ipFragCreates.0 = 0
  315. IP-MIB::ipInUnknownProtos.0 = 0
  316. IP-MIB::ipInHdrErrors.0 = 0
  317. IP-MIB::ipInAddrErrors.0 = 0
  318.  
  319.  
  320. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
  321. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
  322.  
  323.  
  324. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-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]  
  325. SNMPv2-MIB::snmpInPkts.0 = 15492
  326. SNMPv2-MIB::snmpOutPkts.0 = 15491
  327. SNMPv2-MIB::snmpInBadVersions.0 = 0
  328. SNMPv2-MIB::snmpInBadCommunityNames.0 = 0
  329. SNMPv2-MIB::snmpInBadCommunityUses.0 = 269
  330. SNMPv2-MIB::snmpInASNParseErrs.0 = 0
  331. SNMPv2-MIB::snmpInTooBigs.0 = 0
  332. SNMPv2-MIB::snmpInNoSuchNames.0 = 0
  333. SNMPv2-MIB::snmpInBadValues.0 = 0
  334. SNMPv2-MIB::snmpInReadOnlys.0 = 0
  335. SNMPv2-MIB::snmpInGenErrs.0 = 0
  336. SNMPv2-MIB::snmpInTotalReqVars.0 = 36710
  337. SNMPv2-MIB::snmpInTotalSetVars.0 = 0
  338. SNMPv2-MIB::snmpInGetRequests.0 = 8653
  339. SNMPv2-MIB::snmpInGetNexts.0 = 114
  340. SNMPv2-MIB::snmpInSetRequests.0 = 0
  341. SNMPv2-MIB::snmpInGetResponses.0 = 0
  342. SNMPv2-MIB::snmpInTraps.0 = 0
  343. SNMPv2-MIB::snmpOutTooBigs.0 = 0
  344. SNMPv2-MIB::snmpOutNoSuchNames.0 = 264
  345. SNMPv2-MIB::snmpOutBadValues.0 = 0
  346. SNMPv2-MIB::snmpOutGenErrs.0 = 0
  347. SNMPv2-MIB::snmpOutGetRequests.0 = 0
  348. SNMPv2-MIB::snmpOutGetNexts.0 = 0
  349. SNMPv2-MIB::snmpOutSetRequests.0 = 0
  350. SNMPv2-MIB::snmpOutGetResponses.0 = 15491
  351. SNMPv2-MIB::snmpOutTraps.0 = 0
  352. SNMPv2-MIB::snmpSilentDrops.0 = 0
  353. SNMPv2-MIB::snmpProxyDrops.0 = 0
  354.  
  355.  
  356. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
  357. UDP-MIB::udpInDatagrams.0 = 15500
  358. UDP-MIB::udpOutDatagrams.0 = 15512
  359. UDP-MIB::udpInErrors.0 = 0
  360. UDP-MIB::udpNoPorts.0 = 1866
  361.  
  362.  
  363. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-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]  
  364. TCP-MIB::tcpActiveOpens.0 = 4
  365. TCP-MIB::tcpPassiveOpens.0 = 299
  366. TCP-MIB::tcpAttemptFails.0 = 0
  367. TCP-MIB::tcpEstabResets.0 = 1
  368. TCP-MIB::tcpCurrEstab.0 = 0
  369. TCP-MIB::tcpInSegs.0 = 2223
  370. TCP-MIB::tcpOutSegs.0 = 1033
  371. TCP-MIB::tcpRetransSegs.0 = 0
  372. TCP-MIB::tcpInErrs.0 = 0
  373. TCP-MIB::tcpOutRsts.0 = 1
  374.  
  375.  
  376.  
  377.  
  378. >> Runtime for poller module 'netstats': 0.0542 seconds with 22920 bytes
  379. >> [0;36mSNMP[0m: [6/0.05s] [1;33mMySQL[0m: [0/0.00s]  
  380. #### Unload poller module netstats ####
  381.  
  382. Modules status: Global+  
  383. OS  
  384. Device  
  385.  
  386. #### Load poller module hr-mib ####
  387. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  388. hrSystemMaxProcesses.0 = No Such Object available on this agent at this OID
  389. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  390. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  391.  
  392.  
  393.  
  394. >> Runtime for poller module 'hr-mib': 0.0090 seconds with 576 bytes
  395. >> [0;36mSNMP[0m: [1/0.01s] [1;33mMySQL[0m: [0/0.00s]  
  396. #### Unload poller module hr-mib ####
  397.  
  398. Modules status: Global+  
  399. OS  
  400. Device  
  401.  
  402. #### Load poller module ucd-mib ####
  403. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'systemStats'[0m]
  404. systemStats = No Such Object available on this agent at this OID  
  405.  
  406. Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID  
  407. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  408. laLoadInt.1 = No Such Object available on this agent at this OID
  409. laLoadInt.2 = No Such Object available on this agent at this OID
  410. laLoadInt.3 = No Such Object available on this agent at this OID  
  411.  
  412.  
  413. >> Runtime for poller module 'ucd-mib': 0.0160 seconds with 136 bytes
  414. >> [0;36mSNMP[0m: [2/0.02s] [1;33mMySQL[0m: [0/0.00s]  
  415. #### Unload poller module ucd-mib ####
  416.  
  417. Modules status: Global+  
  418. OS  
  419. Device  
  420.  
  421. #### Load poller module ipSystemStats ####
  422. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  423. ipSystemStatsInReceives.ipv4 = 0
  424. ipSystemStatsInReceives.ipv6 = 1241
  425. ipSystemStatsHCInReceives.ipv4 = 0
  426. ipSystemStatsHCInReceives.ipv6 = 1241
  427. ipSystemStatsInOctets.ipv4 = 3042018
  428. ipSystemStatsInOctets.ipv6 = 0
  429. ipSystemStatsHCInOctets.ipv4 = 3042018
  430. ipSystemStatsHCInOctets.ipv6 = 0
  431. ipSystemStatsInHdrErrors.ipv4 = 0
  432. ipSystemStatsInHdrErrors.ipv6 = 0
  433. ipSystemStatsInNoRoutes.ipv4 = 0
  434. ipSystemStatsInNoRoutes.ipv6 = 0
  435. ipSystemStatsInAddrErrors.ipv4 = 0
  436. ipSystemStatsInAddrErrors.ipv6 = 0
  437. ipSystemStatsInUnknownProtos.ipv4 = 0
  438. ipSystemStatsInUnknownProtos.ipv6 = 0
  439. ipSystemStatsInTruncatedPkts.ipv4 = 0
  440. ipSystemStatsInTruncatedPkts.ipv6 = 0
  441. ipSystemStatsInForwDatagrams.ipv4 = 0
  442. ipSystemStatsInForwDatagrams.ipv6 = 0
  443. ipSystemStatsHCInForwDatagrams.ipv4 = 0
  444. ipSystemStatsHCInForwDatagrams.ipv6 = 0
  445. ipSystemStatsReasmReqds.ipv4 = 0
  446. ipSystemStatsReasmReqds.ipv6 = 0
  447. ipSystemStatsReasmOKs.ipv4 = 0
  448. ipSystemStatsReasmOKs.ipv6 = 0
  449. ipSystemStatsReasmFails.ipv4 = 0
  450. ipSystemStatsReasmFails.ipv6 = 0
  451. ipSystemStatsInDiscards.ipv4 = 0
  452. ipSystemStatsInDiscards.ipv6 = 0
  453. ipSystemStatsInDelivers.ipv4 = 20824
  454. ipSystemStatsInDelivers.ipv6 = 1241
  455. ipSystemStatsHCInDelivers.ipv4 = 0
  456. ipSystemStatsHCInDelivers.ipv6 = 1241
  457. ipSystemStatsOutRequests.ipv4 = 18393
  458. ipSystemStatsOutRequests.ipv6 = 717
  459. ipSystemStatsHCOutRequests.ipv4 = 18393
  460. ipSystemStatsHCOutRequests.ipv6 = 717
  461. ipSystemStatsOutNoRoutes.ipv4 = 0
  462. ipSystemStatsOutNoRoutes.ipv6 = 0
  463. ipSystemStatsOutForwDatagrams.ipv4 = 0
  464. ipSystemStatsOutForwDatagrams.ipv6 = 0
  465. ipSystemStatsHCOutForwDatagrams.ipv4 = 0
  466. ipSystemStatsHCOutForwDatagrams.ipv6 = 0
  467. ipSystemStatsOutDiscards.ipv4 = 0
  468. ipSystemStatsOutDiscards.ipv6 = 0
  469. ipSystemStatsOutFragReqds.ipv4 = 0
  470. ipSystemStatsOutFragReqds.ipv6 = 0
  471. ipSystemStatsOutFragOKs.ipv4 = 0
  472. ipSystemStatsOutFragOKs.ipv6 = 0
  473. ipSystemStatsOutFragFails.ipv4 = 0
  474. ipSystemStatsOutFragFails.ipv6 = 0
  475. ipSystemStatsOutFragCreates.ipv4 = 0
  476. ipSystemStatsOutFragCreates.ipv6 = 0
  477. ipSystemStatsOutTransmits.ipv4 = 0
  478. ipSystemStatsOutTransmits.ipv6 = 0
  479. ipSystemStatsHCOutTransmits.ipv4 = 0
  480. ipSystemStatsHCOutTransmits.ipv6 = 0
  481. ipSystemStatsOutOctets.ipv4 = 3862798
  482. ipSystemStatsOutOctets.ipv6 = 0
  483. ipSystemStatsHCOutOctets.ipv4 = 3863054
  484. ipSystemStatsHCOutOctets.ipv6 = 0
  485. ipSystemStatsInMcastPkts.ipv4 = 0
  486. ipSystemStatsInMcastPkts.ipv6 = 1241
  487. ipSystemStatsHCInMcastPkts.ipv4 = 0
  488. ipSystemStatsHCInMcastPkts.ipv6 = 1241
  489. ipSystemStatsInMcastOctets.ipv4 = 0
  490. ipSystemStatsInMcastOctets.ipv6 = 0
  491. ipSystemStatsHCInMcastOctets.ipv4 = 0
  492. ipSystemStatsHCInMcastOctets.ipv6 = 0
  493. ipSystemStatsOutMcastPkts.ipv4 = 0
  494. ipSystemStatsOutMcastPkts.ipv6 = 717
  495. ipSystemStatsHCOutMcastPkts.ipv4 = 0
  496. ipSystemStatsHCOutMcastPkts.ipv6 = 717
  497. ipSystemStatsOutMcastOctets.ipv4 = 0
  498. ipSystemStatsOutMcastOctets.ipv6 = 0
  499. ipSystemStatsHCOutMcastOctets.ipv4 = 0
  500. ipSystemStatsHCOutMcastOctets.ipv6 = 0
  501. ipSystemStatsInBcastPkts.ipv4 = 1866
  502. ipSystemStatsInBcastPkts.ipv6 = 0
  503. ipSystemStatsHCInBcastPkts.ipv4 = 1866
  504. ipSystemStatsHCInBcastPkts.ipv6 = 0
  505. ipSystemStatsOutBcastPkts.ipv4 = 4
  506. ipSystemStatsOutBcastPkts.ipv6 = 0
  507. ipSystemStatsHCOutBcastPkts.ipv4 = 4
  508. ipSystemStatsHCOutBcastPkts.ipv6 = 0
  509. ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00
  510. ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00
  511. ipSystemStatsRefreshRate.ipv4 = 0
  512. ipSystemStatsRefreshRate.ipv6 = 0  
  513.  
  514. ipv4 ipv6
  515.  
  516. >> Runtime for poller module 'ipSystemStats': 0.0205 seconds with 16448 bytes
  517. >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [0/0.00s]  
  518. #### Unload poller module ipSystemStats ####
  519.  
  520. Modules status: Global+  
  521. OS  
  522. Device  
  523.  
  524. #### Load poller module ports ####
  525. 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[21][0m 1.11ms]
  526.  
  527. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  528. ifXEntry = No Such Object available on this agent at this OID  
  529.  
  530. Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
  531. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'ifEntry'[0m]
  532. ifIndex.1 = 1
  533. ifIndex.2 = 2
  534. ifDescr.1 = LOOPBACK
  535. ifDescr.2 = vmac0
  536. ifType.1 = softwareLoopback
  537. ifType.2 = ethernetCsmacd
  538. ifMtu.1 = 1500
  539. ifMtu.2 = 1500
  540. ifSpeed.1 = 0
  541. ifSpeed.2 = 0
  542. ifPhysAddress.1 =
  543. ifPhysAddress.2 = 28:29:86:4d:a1:57
  544. ifAdminStatus.1 = up
  545. ifAdminStatus.2 = up
  546. ifOperStatus.1 = up
  547. ifOperStatus.2 = up
  548. ifLastChange.1 = 0
  549. ifLastChange.2 = 105
  550. ifInOctets.1 = 0
  551. ifInOctets.2 = 3043206
  552. ifInUcastPkts.1 = 0
  553. ifInUcastPkts.2 = 18975
  554. ifInNUcastPkts.1 = 0
  555. ifInNUcastPkts.2 = 1866
  556. ifInDiscards.1 = 0
  557. ifInDiscards.2 = 0
  558. ifInErrors.1 = 0
  559. ifInErrors.2 = 0
  560. ifInUnknownProtos.1 = 0
  561. ifInUnknownProtos.2 = 0
  562. ifOutOctets.1 = 0
  563. ifOutOctets.2 = 3865207
  564. ifOutUcastPkts.1 = 0
  565. ifOutUcastPkts.2 = 19127
  566. ifOutNUcastPkts.1 = 0
  567. ifOutNUcastPkts.2 = 4
  568. ifOutDiscards.1 = 0
  569. ifOutDiscards.2 = 0
  570. ifOutErrors.1 = 0
  571. ifOutErrors.2 = 0
  572. ifOutQLen.1 = 0
  573. ifOutQLen.2 = 0
  574. ifSpecific.1 = zeroDotZero
  575. ifSpecific.2 = zeroDotZero  
  576.  
  577. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  578. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  579.  
  580. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  581. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  582. dot1qPvid = No Such Object available on this agent at this OID  
  583.  
  584. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
  585. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl','vdsl2') [0;33m[21][0m 0.88ms]
  586.  
  587. array (
  588.   1 =>
  589.   array (
  590.     'ifIndex' => '1',
  591.     'ifDescr' => 'LOOPBACK',
  592.     'ifType' => 'softwareLoopback',
  593.     'ifMtu' => '1500',
  594.     'ifSpeed' => '0',
  595.     'ifPhysAddress' => '',
  596.     'ifAdminStatus' => 'up',
  597.     'ifOperStatus' => 'up',
  598.     'ifLastChange' => '0',
  599.     'ifInOctets' => '0',
  600.     'ifInUcastPkts' => '0',
  601.     'ifInNUcastPkts' => '0',
  602.     'ifInDiscards' => '0',
  603.     'ifInErrors' => '0',
  604.     'ifInUnknownProtos' => '0',
  605.     'ifOutOctets' => '0',
  606.     'ifOutUcastPkts' => '0',
  607.     'ifOutNUcastPkts' => '0',
  608.     'ifOutDiscards' => '0',
  609.     'ifOutErrors' => '0',
  610.     'ifOutQLen' => '0',
  611.     'ifSpecific' => 'zeroDotZero',
  612.   ),
  613.   2 =>
  614.   array (
  615.     'ifIndex' => '2',
  616.     'ifDescr' => 'vmac0',
  617.     'ifType' => 'ethernetCsmacd',
  618.     'ifMtu' => '1500',
  619.     'ifSpeed' => '0',
  620.     'ifPhysAddress' => '28:29:86:4d:a1:57',
  621.     'ifAdminStatus' => 'up',
  622.     'ifOperStatus' => 'up',
  623.     'ifLastChange' => '105',
  624.     'ifInOctets' => '3043206',
  625.     'ifInUcastPkts' => '18975',
  626.     'ifInNUcastPkts' => '1866',
  627.     'ifInDiscards' => '0',
  628.     'ifInErrors' => '0',
  629.     'ifInUnknownProtos' => '0',
  630.     'ifOutOctets' => '3865207',
  631.     'ifOutUcastPkts' => '19127',
  632.     'ifOutNUcastPkts' => '4',
  633.     'ifOutDiscards' => '0',
  634.     'ifOutErrors' => '0',
  635.     'ifOutQLen' => '0',
  636.     'ifSpecific' => 'zeroDotZero',
  637.   ),
  638. )  
  639.  valid  
  640.  valid  
  641.  
  642. Port LOOPBACK: LOOPBACK (1 / #137) ifInOctets  
  643. ifOutOctets  
  644. ifInUcastPkts  
  645. ifOutUcastPkts  
  646. ifInBroadcastPkts  
  647. ifOutBroadcastPkts  
  648. ifInMulticastPkts  
  649. ifOutMulticastPkts  
  650. ifSpeed (0)  
  651. VLAN =   Using ifDescr as ifAlias  
  652.  Using ifDescr as ifName  
  653. LOOPBACK
  654.  ifInOctets (0 B) 0 Bps 187 secs  
  655.  
  656.  ifOutOctets (0 B) 0 Bps 187 secs  
  657.  
  658.  ifInErrors (0 B) 0 Bps 187 secs  
  659.  
  660.  ifOutErrors (0 B) 0 Bps 187 secs  
  661.  
  662.  ifInUcastPkts (0 B) 0 Bps 187 secs  
  663.  
  664.  ifOutUcastPkts (0 B) 0 Bps 187 secs  
  665.  
  666.  ifInNUcastPkts (0 B) 0 Bps 187 secs  
  667.  
  668.  ifOutNUcastPkts (0 B) 0 Bps 187 secs  
  669.  
  670.  ifInDiscards (0 B) 0 Bps 187 secs  
  671.  
  672.  ifOutDiscards (0 B) 0 Bps 187 secs  
  673.  
  674.  ifInUnknownProtos (0 B) 0 Bps 187 secs  
  675.  
  676.  ifInBroadcastPkts (0 B) 0 Bps 187 secs  
  677.  
  678.  ifOutBroadcastPkts (0 B) 0 Bps 187 secs  
  679.  
  680.  ifInMulticastPkts (0 B) 0 Bps 187 secs  
  681.  
  682.  ifOutMulticastPkts (0 B) 0 Bps 187 secs  
  683. bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,1660902289,1660902102,187,137][0m 1.57ms]
  684.  
  685. 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,137][0m 0.54ms]
  686.  
  687. 1 updated  
  688.  
  689. Port vmac0: vmac0 (2 / #138) ifInOctets  
  690. ifOutOctets  
  691. ifInUcastPkts  
  692. ifOutUcastPkts  
  693. ifInBroadcastPkts  
  694. ifOutBroadcastPkts  
  695. ifInMulticastPkts  
  696. ifOutMulticastPkts  
  697. ifSpeed (0)  
  698. VLAN =   Using ifDescr as ifAlias  
  699.  Using ifDescr as ifName  
  700. vmac0
  701.  ifInOctets (42269 B) 226.03743315508 Bps 187 secs  
  702.  
  703.  ifOutOctets (82408 B) 440.68449197861 Bps 187 secs  
  704.  
  705.  ifInErrors (0 B) 0 Bps 187 secs  
  706.  
  707.  ifOutErrors (0 B) 0 Bps 187 secs  
  708.  
  709.  ifInUcastPkts (418 B) 2.2352941176471 Bps 187 secs  
  710.  
  711.  ifOutUcastPkts (419 B) 2.2406417112299 Bps 187 secs  
  712.  
  713.  ifInNUcastPkts (3 B) 0.016042780748663 Bps 187 secs  
  714.  
  715.  ifOutNUcastPkts (0 B) 0 Bps 187 secs  
  716.  
  717.  ifInDiscards (0 B) 0 Bps 187 secs  
  718.  
  719.  ifOutDiscards (0 B) 0 Bps 187 secs  
  720.  
  721.  ifInUnknownProtos (0 B) 0 Bps 187 secs  
  722.  
  723.  ifInBroadcastPkts (0 B) 0 Bps 187 secs  
  724.  
  725.  ifOutBroadcastPkts (0 B) 0 Bps 187 secs  
  726.  
  727.  ifInMulticastPkts (0 B) 0 Bps 187 secs  
  728.  
  729.  ifOutMulticastPkts (0 B) 0 Bps 187 secs  
  730. bps(1.81 kbps/3.53 kbps)bytes(41.28 KiB/80.48 KiB)pkts(2.24 pps/2.24 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["3043206",3000937,226.0374331550802,42269,"3865207",3782799,440.6844919786096,82408,"0",0,0,0,"0",0,0,0,"18975",18557,2.235294117647059,418,"19127",18708,2.2406417112299466,419,1660902289,1660902102,187,138][0m 0.56ms]
  731.  
  732. 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["1866",1863,0.016042780748663103,3,"4",4,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,138][0m 0.44ms]
  733.  
  734. 2 updated  
  735.  
  736. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1660902289,1660902102,null][0m 0.12ms]
  737.  
  738. 0 updated  
  739.  
  740. >> Runtime for poller module 'ports': 0.0602 seconds with 41352 bytes
  741. >> [0;36mSNMP[0m: [4/0.04s] [1;33mMySQL[0m: [7/0.05s]  
  742. #### Unload poller module ports ####
  743.  
  744. Modules status: Global+  
  745. OS  
  746. Device  
  747.  
  748. #### Load poller module customoid ####
  749. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[21][0m 0.22ms]
  750.  
  751.  
  752. >> Runtime for poller module 'customoid': 0.0005 seconds with 1320 bytes
  753. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  754. #### Unload poller module customoid ####
  755.  
  756. Modules status: Global+  
  757. OS  
  758. Device  
  759.  
  760. #### Load poller module bgp-peers ####
  761. SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[21][0m 0.22ms]
  762.  
  763.  
  764. >> Runtime for poller module 'bgp-peers': 0.0015 seconds with 14328 bytes
  765. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  766. #### Unload poller module bgp-peers ####
  767.  
  768. Modules status: Global-  
  769. OS  
  770. Device  
  771. Module [ junose-atm-vp ] disabled globally.
  772.  
  773. Modules status: Global-  
  774. OS  
  775. Device  
  776. Module [ printer-supplies ] disabled globally.
  777.  
  778. Modules status: Global+  
  779. OS  
  780. Device  
  781.  
  782. #### Load poller module ucd-diskio ####
  783. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[21][0m 0.13ms]
  784.  
  785.  
  786. >> Runtime for poller module 'ucd-diskio': 0.0003 seconds with 784 bytes
  787. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  788. #### Unload poller module ucd-diskio ####
  789.  
  790. Modules status: Global-  
  791. OS  
  792. Device  
  793. Module [ wifi ] disabled globally.
  794.  
  795. Modules status: Global+  
  796. OS  
  797. Device  
  798.  
  799. #### Load poller module wireless ####
  800. Attempting to initialize OS: apc  
  801. OS initialized: LibreNMS\OS\Apc  
  802. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[21][0m 0.15ms]
  803.  
  804.  
  805. >> Runtime for poller module 'wireless': 0.0012 seconds with 103192 bytes
  806. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  807. #### Unload poller module wireless ####
  808.  
  809. Modules status: Global+  
  810. OS  
  811. Device  
  812.  
  813. #### Load poller module ospf ####
  814. SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[21][0m 0.14ms]
  815.  
  816.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]  
  817. ospfGeneralGroup = No Such Object available on this agent at this OID
  818.  
  819.  
  820. SQL[[1;33mdelete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [0;33m[21,""][0m 0.31ms]
  821.  
  822. 0
  823. >> Runtime for poller module 'ospf': 0.0119 seconds with 93856 bytes
  824. >> [0;36mSNMP[0m: [1/0.01s] [1;33mMySQL[0m: [2/0.00s]  
  825. #### Unload poller module ospf ####
  826.  
  827. Modules status: Global-  
  828. OS  
  829. Device  
  830. Module [ isis ] disabled globally.
  831.  
  832. Modules status: Global-  
  833. OS  
  834. Device  
  835. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  836.  
  837. Modules status: Global-  
  838. OS  
  839. Device  
  840. Module [ cisco-remote-access-monitor ] disabled globally.
  841.  
  842. Modules status: Global-  
  843. OS  
  844. Device  
  845. Module [ cisco-cef ] disabled globally.
  846.  
  847. Modules status: Global-  
  848. OS  
  849. Device  
  850. Module [ slas ] disabled globally.
  851.  
  852. Modules status: Global-  
  853. OS  
  854. Device  
  855. Module [ cisco-mac-accounting ] disabled globally.
  856.  
  857. Modules status: Global-  
  858. OS  
  859. Device  
  860. Module [ cipsec-tunnels ] disabled globally.
  861.  
  862. Modules status: Global-  
  863. OS  
  864. Device  
  865. Module [ cisco-ace-loadbalancer ] disabled globally.
  866.  
  867. Modules status: Global-  
  868. OS  
  869. Device  
  870. Module [ cisco-ace-serverfarms ] disabled globally.
  871.  
  872. Modules status: Global-  
  873. OS  
  874. Device  
  875. Module [ cisco-asa-firewall ] disabled globally.
  876.  
  877. Modules status: Global-  
  878. OS  
  879. Device  
  880. Module [ cisco-voice ] disabled globally.
  881.  
  882. Modules status: Global-  
  883. OS  
  884. Device  
  885. Module [ cisco-cbqos ] disabled globally.
  886.  
  887. Modules status: Global-  
  888. OS  
  889. Device  
  890. Module [ cisco-otv ] disabled globally.
  891.  
  892. Modules status: Global-  
  893. OS  
  894. Device  
  895. Module [ cisco-qfp ] disabled globally.
  896.  
  897. Modules status: Global-  
  898. OS  
  899. Device  
  900. Module [ cisco-vpdn ] disabled globally.
  901.  
  902. Modules status: Global-  
  903. OS  
  904. Device  
  905. Module [ nac ] disabled globally.
  906.  
  907. Modules status: Global-  
  908. OS  
  909. Device  
  910. Module [ netscaler-vsvr ] disabled globally.
  911.  
  912. Modules status: Global-  
  913. OS  
  914. Device  
  915. Module [ aruba-controller ] disabled globally.
  916.  
  917. Modules status: Global+  
  918. OS  
  919. Device  
  920.  
  921. #### Load poller module entity-physical ####
  922.  
  923. >> Runtime for poller module 'entity-physical': 0.0001 seconds with 472 bytes
  924. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  925. #### Unload poller module entity-physical ####
  926.  
  927. Modules status: Global-  
  928. OS  
  929. Device  
  930. Module [ entity-state ] disabled globally.
  931.  
  932. Modules status: Global+  
  933. OS  
  934. Device  
  935.  
  936. #### Load poller module applications ####
  937. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[21][0m 0.17ms]
  938.  
  939.  
  940. >> Runtime for poller module 'applications': 0.0004 seconds with 576 bytes
  941. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  942. #### Unload poller module applications ####
  943.  
  944. Modules status: Global+  
  945. OS  
  946. Device  
  947.  
  948. #### Load poller module stp ####
  949. Instances: SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[21][0m 0.17ms]
  950.  
  951.  
  952. Ports: SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[21][0m 0.17ms]
  953.  
  954.  
  955. >> Runtime for poller module 'stp': 0.0015 seconds with 73088 bytes
  956. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.00s]  
  957. #### Unload poller module stp ####
  958.  
  959. Modules status: Global+  
  960. OS  
  961. Device  
  962.  
  963. #### Load poller module ntp ####
  964.  
  965. >> Runtime for poller module 'ntp': 0.0001 seconds with 400 bytes
  966. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  967. #### Unload poller module ntp ####
  968.  
  969. Modules status: Global-  
  970. OS  
  971. Device  
  972. Module [ loadbalancers ] disabled globally.
  973.  
  974. Modules status: Global-  
  975. OS  
  976. Device  
  977. Module [ mef ] disabled globally.
  978.  
  979. Modules status: Global+  
  980. OS  
  981. Device  
  982.  
  983. #### Load poller module mpls ####
  984.  
  985. >> Runtime for poller module 'mpls': 0.0002 seconds with 23656 bytes
  986. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  987. #### Unload poller module mpls ####
  988.  
  989. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[21][0m 0.16ms]
  990.  
  991.  
  992. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[1.343,21][0m 0.66ms]
  993.  
  995.  
  996. Polled in 1.343 seconds
  997. ### Start Device Groups ###
  998. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.15ms]
  999.  
  1000. 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 (1, 5, 6, 7, 8, 9, 10, 11, 12) [0;33m[][0m 0.72ms]
  1001.  
  1002. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%QNAP%",21][0m 0.23ms]
  1003.  
  1004. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%hpe-ilo%",21][0m 0.17ms]
  1005.  
  1006. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%Smart-UPS%",21][0m 0.17ms]
  1007.  
  1008. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`hardware` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%AP7851%","%apc-epdu%","%AP8858%",21][0m 0.19ms]
  1009.  
  1010. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ? OR `devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0mxos%","%ios%",21][0m 0.16ms]
  1011.  
  1012. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;34morderrouter%",21][0m 0.16ms]
  1013.  
  1014. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;31mouter%","[0;36more%",21][0m 0.16ms]
  1015.  
  1016. SQL[[1;33mselect exists(select * from `devices` left join `sensors` on `devices`.`device_id` = `sensors`.`device_id` where (`sensors`.`sensor_class` = ? AND `devices`.`type` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["humidity","power",21][0m 0.29ms]
  1017.  
  1018. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` where (`devices`.`type` = ? AND (`ports`.`ifAlias` LIKE ? OR `ports`.`ifAlias` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["server","%VPN%","[1;35mUBLIC%",21][0m 0.21ms]
  1019.  
  1020. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[21][0m 0.14ms]
  1021.  
  1022. Groups Added:  
  1023. Groups Removed:  
  1024. ### End Device Groups, runtime: 0.0128s ###
  1025.  
  1026. #### Start Alerts ####
  1027. 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[21][0m 0.17ms]
  1028.  
  1029. 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 (6)) 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-08-19T09:44:49.191004Z","2022-08-19T09:44:49.191004Z",0,1,"09:44:49","09:44:49","09:44:49","09:44:49","[45m%","device",21,"device_group","location",30][0m 0.71ms]
  1030.  
  1031. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[21][0m 0.32ms]
  1032.  
  1033. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  1034.         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 = ?)
  1035.         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 = ?))
  1036.         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 = ?))
  1037.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  1038.         WHERE a.disabled = 0 AND (
  1039.             (d.device_id IS NULL AND g.group_id IS NULL)
  1040.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
  1041.             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))
  1042.         ) [0;33m[21,21,21,21,21,21,21,21][0m 1.01ms]
  1043.  
  1044. Rule [0;35m#15 (APC UPS Battery Needs Replacement):[0m  
  1045.  
  1046. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_type = "upsAdvBatteryReplaceIndicator" AND sensors.sensor_current = 2 [0;33m[21][0m 0.44ms]
  1047.  
  1048. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,21][0m 0.18ms]
  1049.  
  1050. Status: [0;34mNOCHG[0m  
  1051. Rule [0;35m#16 (APC UPS Switched to Battery Power):[0m  
  1052.  
  1053. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 3 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[21][0m 0.44ms]
  1054.  
  1055. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[16,21][0m 0.16ms]
  1056.  
  1057. Status: [0;34mNOCHG[0m  
  1058. Rule [0;35m#17 (APC UPS in Hardware Failure Bypass Mode):[0m  
  1059.  
  1060. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 10 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[21][0m 0.38ms]
  1061.  
  1062. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[17,21][0m 0.15ms]
  1063.  
  1064. Status: [0;34mNOCHG[0m  
  1065. Rule [0;35m#18 (APC UPS in Emergency Static Bypass Mode):[0m  
  1066.  
  1067. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 16 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[21][0m 0.38ms]
  1068.  
  1069. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[18,21][0m 0.15ms]
  1070.  
  1071. Status: [0;34mNOCHG[0m  
  1072. Rule [0;35m#19 (APC UPS in Smart Trim Mode):[0m  
  1073.  
  1074. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 12 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[21][0m 0.38ms]
  1075.  
  1076. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[19,21][0m 0.15ms]
  1077.  
  1078. Status: [0;34mNOCHG[0m  
  1079. Rule [0;35m#26 (Devices up/down):[0m  
  1080.  
  1081. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[21][0m 0.25ms]
  1082.  
  1083. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[26,21][0m 0.15ms]
  1084.  
  1085. Status: [0;34mNOCHG[0m  
  1086. Rule [0;35m#45 (Network devices up/down):[0m  
  1087.  
  1088. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND (devices.type = "network" OR devices.type = "firewall" OR devices.type = "loadbalancer" OR devices.type = "wireless") [0;33m[21][0m 0.28ms]
  1089.  
  1090. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[45,21][0m 0.14ms]
  1091.  
  1092. Status: [0;34mNOCHG[0m  
  1093. #### End Alerts ####
  1094. ./poller.php ups-vr1k2-b.myhz.nl 2022-08-19 11:44:49 - 1 devices polled in 1.513 secs  
  1095.  
  1096. [0;36mSNMP[0m [26/0.25s]: Snmpget[19/0.17s] Snmpwalk[7/0.08s]  
  1097. [1;33mSQL[0m [86/0.31s]: Select[71/0.23s] Insert[1/0.01s] Update[13/0.07s] Delete[1/0.00s]  
  1098.  

Reply to "Untitled"

captcha