From tslytsly, 6 Years ago, written in Plain Text.
This paste is a reply to Untitled from librenms - view diff
Embed
  1. LibreNMS Poller
  2. ===================================
  3. Version info:
  4. Commit SHA: 701fbbc29b7a25e215032a6435fac72c06094976
  5. Commit Date: 1499057076
  6. DB Schema: 198
  7. PHP: 7.0.18-0ubuntu0.16.04.1
  8. MySQL: 10.0.29-MariaDB-0ubuntu0.16.04.1
  9. RRDTool: 1.5.5
  10. SNMP: NET-SNMP 5.7.3
  11. ==================================DEBUG!
  12. Starting polling run:
  13.  
  14. SQL[[0;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'ups' ORDER BY `device_id` ASC[0m]
  15. SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '44'[0m]
  16. Hostname: ups
  17. Device ID: 44
  18. OS: powerwalker
  19.  
  20. SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','0.79','1.01','0.93','44',NOW())[0m]
  21. SNMP Check response code: 0
  22. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0[0m]
  23. sysUpTime.0 = 3053816711
  24. sysLocation.0 = Office
  25. sysContact.0 = Technical Support Center
  26. sysName.0 = NMC
  27. sysObjectID.0 = enterprises.935.10.1
  28.  
  29. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysDescr.0[0m]
  30. Network Management Card for UPS
  31.  
  32. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0[0m]
  33. snmpEngineTime.0 = 30538167
  34. hrSystemUptime.0 = No Such Object available on this agent at this OID
  35.  
  36. Uptime seconds: 30538167
  37. RRD[[0;32mlast ups/uptime.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  38. RRD[[0;32mupdate ups/uptime.rrd N:30538167 --daemon unix:/var/run/rrdcached.sock[0m]
  39. [[0;31mRRD Disabled[0m]Uptime: 353 days, 10h 49m 27s
  40. SQL[[0;33mSELECT `lat`,`lng` FROM `locations` WHERE `location`='Office' LIMIT 1[0m]
  41. Using cached lat/lng from other device
  42. Modules status: Global- OS  Device  Module [ unix-agent ] disabled globally.
  43.  
  44. Modules status: Global+ OS  Device  
  45. #### Load poller module os ####
  46. Generic :(
  47. Hardware:
  48. Version:
  49. Features:
  50. Serial:
  51.  
  52. >> Runtime for poller module 'os': 0.0002 seconds with 568 bytes
  53. #### Unload poller module os ####
  54.  
  55. RRD[[0;32mlast ups/poller-perf-os.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  56. RRD[[0;32mupdate ups/poller-perf-os.rrd N:0.0001828670501709 --daemon unix:/var/run/rrdcached.sock[0m]
  57. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  58. #### Load poller module ipmi ####
  59. SQL[[0;33mSELECT * FROM sensors WHERE device_id = '44' AND poller_type='ipmi'[0m]
  60. Array
  61. (
  62. )
  63.  
  64. >> Runtime for poller module 'ipmi': 0.0006 seconds with 1352 bytes
  65. #### Unload poller module ipmi ####
  66.  
  67. RRD[[0;32mlast ups/poller-perf-ipmi.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  68. RRD[[0;32mupdate ups/poller-perf-ipmi.rrd N:0.00064706802368164 --daemon unix:/var/run/rrdcached.sock[0m]
  69. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  70. #### Load poller module sensors ####
  71. SQL[[0;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = '44' GROUP BY `sensor_class`[0m]
  72. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'charge' AND `device_id` = '44'[0m]
  73. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.33.1.2.4.0[0m]
  74. .*.*.2.4.0 = 100
  75.  
  76. Checking (snmp) charge Battery charge remaining...
  77. 100 %
  78. RRD[[0;32mlast ups/sensor-charge-powerwalker-1.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  79. RRD[[0;32mupdate ups/sensor-charge-powerwalker-1.rrd N:100 --daemon unix:/var/run/rrdcached.sock[0m]
  80. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='100',`sensor_prev` ='99',`lastupdate` =NOW() WHERE `sensor_class` = 'charge' AND `sensor_id` = '904'[0m]
  81. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '44'[0m]
  82. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.33.1.2.6.0 .1.3.6.1.2.1.33.1.3.3.1.4.1.0 .1.3.6.1.2.1.33.1.4.4.1.3.1.0[0m]
  83. .*.*.2.6.0 = -1
  84. .*.*.*.1.0 = No Such Instance currently exists at this OID
  85. .*.*.*.1.0 = No Such Instance currently exists at this OID
  86.  
  87. Checking (snmp) current Battery Current...
  88. Checking (snmp) current Input Voltage...
  89. Checking (snmp) current Output Voltage...
  90. -1 A
  91. RRD[[0;32mlast ups/sensor-current-powerwalker-1.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  92. RRD[[0;32mupdate ups/sensor-current-powerwalker-1.rrd N:-1 --daemon unix:/var/run/rrdcached.sock[0m]
  93. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='-1',`sensor_prev` ='-1',`lastupdate` =NOW() WHERE `sensor_class` = 'current' AND `sensor_id` = '903'[0m]
  94. 0 A
  95. RRD[[0;32mlast ups/sensor-current-powerwalker-2.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  96. RRD[[0;32mupdate ups/sensor-current-powerwalker-2.rrd N:0 --daemon unix:/var/run/rrdcached.sock[0m]
  97. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'current' AND `sensor_id` = '1045'[0m]
  98. 0 A
  99. RRD[[0;32mlast ups/sensor-current-powerwalker-3.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  100. RRD[[0;32mupdate ups/sensor-current-powerwalker-3.rrd N:0 --daemon unix:/var/run/rrdcached.sock[0m]
  101. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'current' AND `sensor_id` = '1046'[0m]
  102. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '44'[0m]
  103. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.33.1.3.3.1.2.1[0m]
  104. .*.*.*.1 = 500
  105.  
  106. Checking (snmp) frequency Input Voltage...
  107. 500 Hz
  108. RRD[[0;32mlast ups/sensor-frequency-powerwalker-2.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  109. RRD[[0;32mupdate ups/sensor-frequency-powerwalker-2.rrd N:500 --daemon unix:/var/run/rrdcached.sock[0m]
  110. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='500',`sensor_prev` ='500',`lastupdate` =NOW() WHERE `sensor_class` = 'frequency' AND `sensor_id` = '1047'[0m]
  111. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'runtime' AND `device_id` = '44'[0m]
  112. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.33.1.2.3.0[0m]
  113. .*.*.2.3.0 = 39
  114.  
  115. Checking (snmp) runtime Battery time remaining...
  116. 39 Min
  117. RRD[[0;32mlast ups/sensor-runtime-powerwalker-1.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  118. RRD[[0;32mupdate ups/sensor-runtime-powerwalker-1.rrd N:39 --daemon unix:/var/run/rrdcached.sock[0m]
  119. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='39',`sensor_prev` ='36',`lastupdate` =NOW() WHERE `sensor_class` = 'runtime' AND `sensor_id` = '905'[0m]
  120. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '44'[0m]
  121. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.33.1.2.1.0[0m]
  122. .*.*.2.1.0 = 2
  123.  
  124. Checking (snmp) state Battery Status...
  125. 2 #
  126. RRD[[0;32mlast ups/sensor-state-upsBatteryStatus-0.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  127. RRD[[0;32mupdate ups/sensor-state-upsBatteryStatus-0.rrd N:2 --daemon unix:/var/run/rrdcached.sock[0m]
  128. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='2',`sensor_prev` ='2',`lastupdate` =NOW() WHERE `sensor_class` = 'state' AND `sensor_id` = '790'[0m]
  129. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '44'[0m]
  130. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.33.1.2.7.0[0m]
  131. .*.*.2.7.0 = 28
  132.  
  133. Checking (snmp) temperature Ambient Temperature...
  134. 28 C
  135. RRD[[0;32mlast ups/sensor-temperature-powerwalker-1.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  136. RRD[[0;32mupdate ups/sensor-temperature-powerwalker-1.rrd N:28 --daemon unix:/var/run/rrdcached.sock[0m]
  137. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='28',`sensor_prev` ='28',`lastupdate` =NOW() WHERE `sensor_class` = 'temperature' AND `sensor_id` = '780'[0m]
  138. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '44'[0m]
  139. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.33.1.2.5.0 .1.3.6.1.2.1.33.1.3.3.1.3.1 .1.3.6.1.2.1.33.1.4.4.1.2.1[0m]
  140. .*.*.2.5.0 = 2054
  141. .*.*.*.1 = 243
  142. .*.*.*.1 = 230
  143.  
  144. Checking (snmp) voltage Battery Voltage...
  145. Checking (snmp) voltage Input Voltage...
  146. Checking (snmp) voltage Output Voltage...
  147. 2054 V
  148. RRD[[0;32mlast ups/sensor-voltage-powerwalker-1.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  149. RRD[[0;32mupdate ups/sensor-voltage-powerwalker-1.rrd N:2054 --daemon unix:/var/run/rrdcached.sock[0m]
  150. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='2054',`sensor_prev` ='2052',`lastupdate` =NOW() WHERE `sensor_class` = 'voltage' AND `sensor_id` = '781'[0m]
  151. 243 V
  152. RRD[[0;32mlast ups/sensor-voltage-powerwalker-2.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  153. RRD[[0;32mupdate ups/sensor-voltage-powerwalker-2.rrd N:243 --daemon unix:/var/run/rrdcached.sock[0m]
  154. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='243',`sensor_prev` ='243',`lastupdate` =NOW() WHERE `sensor_class` = 'voltage' AND `sensor_id` = '1048'[0m]
  155. 230 V
  156. RRD[[0;32mlast ups/sensor-voltage-powerwalker-3.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  157. RRD[[0;32mupdate ups/sensor-voltage-powerwalker-3.rrd N:230 --daemon unix:/var/run/rrdcached.sock[0m]
  158. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `sensors` set `sensor_current` ='230',`sensor_prev` ='230',`lastupdate` =NOW() WHERE `sensor_class` = 'voltage' AND `sensor_id` = '1049'[0m]
  159.  
  160. >> Runtime for poller module 'sensors': 0.1942 seconds with 312 bytes
  161. #### Unload poller module sensors ####
  162.  
  163. RRD[[0;32mlast ups/poller-perf-sensors.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  164. RRD[[0;32mupdate ups/poller-perf-sensors.rrd N:0.19416499137878 --daemon unix:/var/run/rrdcached.sock[0m]
  165. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  166. #### Load poller module processors ####
  167. SQL[[0;33mSELECT * FROM processors WHERE device_id = '44'[0m]
  168.  
  169. >> Runtime for poller module 'processors': 0.0005 seconds with 520 bytes
  170. #### Unload poller module processors ####
  171.  
  172. RRD[[0;32mlast ups/poller-perf-processors.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  173. RRD[[0;32mupdate ups/poller-perf-processors.rrd N:0.00053811073303223 --daemon unix:/var/run/rrdcached.sock[0m]
  174. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  175. #### Load poller module mempools ####
  176. SQL[[0;33mSELECT * FROM mempools WHERE device_id = '44'[0m]
  177.  
  178. >> Runtime for poller module 'mempools': 0.0004 seconds with 600 bytes
  179. #### Unload poller module mempools ####
  180.  
  181. RRD[[0;32mlast ups/poller-perf-mempools.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  182. RRD[[0;32mupdate ups/poller-perf-mempools.rrd N:0.0004270076751709 --daemon unix:/var/run/rrdcached.sock[0m]
  183. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  184. #### Load poller module storage ####
  185. SQL[[0;33mSELECT * FROM storage WHERE device_id = '44'[0m]
  186.  
  187. >> Runtime for poller module 'storage': 0.0004 seconds with 752 bytes
  188. #### Unload poller module storage ####
  189.  
  190. RRD[[0;32mlast ups/poller-perf-storage.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  191. RRD[[0;32mupdate ups/poller-perf-storage.rrd N:0.00041294097900391 --daemon unix:/var/run/rrdcached.sock[0m]
  192. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  193. #### Load poller module netstats ####
  194.  IPSNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs 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]
  195. ipForwDatagrams.0 = 0
  196. ipInDelivers.0 = 19228272
  197. ipInReceives.0 = 31196021
  198. ipOutRequests.0 = 7113318
  199. ipInDiscards.0 = 0
  200. ipOutDiscards.0 = 0
  201. ipOutNoRoutes.0 = 2
  202. ipReasmReqds.0 = 0
  203. ipReasmOKs.0 = 0
  204. ipReasmFails.0 = 0
  205. ipFragOKs.0 = 0
  206. ipFragFails.0 = 0
  207. ipFragCreates.0 = 0
  208. ipInUnknownProtos.0 = 0
  209. ipInHdrErrors.0 = 61
  210. ipInAddrErrors.0 = 250945
  211.  
  212. RRD[[0;32mlast ups/netstats-ip.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  213. RRD[[0;32mupdate ups/netstats-ip.rrd N:0:19228272:31196021:7113318:0:0:2:0:0:0:0:0:0:0:61:250945 --daemon unix:/var/run/rrdcached.sock[0m]
  214. [[0;31mRRD Disabled[0m] TCPSNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m TCP-MIB -M /opt/librenms/mibs 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 tcpHCInSegs.0 tcpHCOutSegs.0[0m]
  215. tcpActiveOpens.0 = 902
  216. tcpPassiveOpens.0 = 24
  217. tcpAttemptFails.0 = 3
  218. tcpEstabResets.0 = 4
  219. tcpCurrEstab.0 = 0
  220. tcpInSegs.0 = 160542
  221. tcpOutSegs.0 = 272447
  222. tcpRetransSegs.0 = 79
  223. tcpInErrs.0 = 0
  224. tcpOutRsts.0 = 11
  225. tcpHCInSegs.0 = 160542
  226. tcpHCOutSegs.0 = 272447
  227.  
  228. RRD[[0;32mlast ups/netstats-tcp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  229. RRD[[0;32mupdate ups/netstats-tcp.rrd N:902:24:3:4:0:160542:272447:79:0:11 --daemon unix:/var/run/rrdcached.sock[0m]
  230. [[0;31mRRD Disabled[0m] UDPSNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UDP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161  UDP-MIB::udpInDatagrams.0 UDP-MIB::udpOutDatagrams.0 UDP-MIB::udpInErrors.0 UDP-MIB::udpNoPorts.0[0m]
  231. udpInDatagrams.0 = 5131008
  232. udpOutDatagrams.0 = 5323758
  233. udpInErrors.0 = 166
  234. udpNoPorts.0 = 12166655
  235.  
  236. RRD[[0;32mlast ups/netstats-udp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  237. RRD[[0;32mupdate ups/netstats-udp.rrd N:5131008:5323758:166:12166655 --daemon unix:/var/run/rrdcached.sock[0m]
  238. [[0;31mRRD Disabled[0m] ICMPSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 icmp[0m]
  239. icmpInMsgs.0 = 1778222
  240. icmpInErrors.0 = 0
  241. icmpInDestUnreachs.0 = 0
  242. icmpInTimeExcds.0 = 0
  243. icmpInParmProbs.0 = 0
  244. icmpInSrcQuenchs.0 = 0
  245. icmpInRedirects.0 = 0
  246. icmpInEchos.0 = 1778221
  247. icmpInEchoReps.0 = 0
  248. icmpInTimestamps.0 = 0
  249. icmpInTimestampReps.0 = 0
  250. icmpInAddrMasks.0 = 0
  251. icmpInAddrMaskReps.0 = 0
  252. icmpOutMsgs.0 = 1781219
  253. icmpOutErrors.0 = 0
  254. icmpOutDestUnreachs.0 = 2998
  255. icmpOutTimeExcds.0 = 0
  256. icmpOutParmProbs.0 = 0
  257. icmpOutSrcQuenchs.0 = 0
  258. icmpOutRedirects.0 = 0
  259. icmpOutEchos.0 = 0
  260. icmpOutEchoReps.0 = 1778221
  261. icmpOutTimestamps.0 = 0
  262. icmpOutTimestampReps.0 = 0
  263. icmpOutAddrMasks.0 = 0
  264. icmpOutAddrMaskReps.0 = 0
  265. icmp.* = 1778222
  266. icmp.* = 3331
  267. icmp.* = 0
  268. icmp.* = 0
  269. icmp.* = 1781219
  270. icmp.* = 3135
  271. icmp.* = 0
  272. icmp.* = 0
  273. icmp.*.0 = 0
  274. icmp.*.3 = 0
  275. icmp.*.4 = 0
  276. icmp.*.5 = 0
  277. icmp.*.8 = 1778221
  278. icmp.*.9 = 0
  279. icmp.*.10 = 0
  280. icmp.*.11 = 0
  281. icmp.*.12 = 0
  282. icmp.*.13 = 0
  283. icmp.*.14 = 0
  284. icmp.*.15 = 0
  285. icmp.*.16 = 0
  286. icmp.*.17 = 0
  287. icmp.*.18 = 0
  288. icmp.*.1 = 3133
  289. icmp.*.2 = 0
  290. icmp.*.3 = 0
  291. icmp.*.4 = 0
  292. icmp.*.128 = 0
  293. icmp.*.129 = 0
  294. icmp.*.130 = 0
  295. icmp.*.131 = 0
  296. icmp.*.132 = 0
  297. icmp.*.133 = 0
  298. icmp.*.134 = 0
  299. icmp.*.135 = 0
  300. icmp.*.136 = 198
  301. icmp.*.137 = 0
  302. icmp.*.0 = 1778221
  303. icmp.*.3 = 2998
  304. icmp.*.4 = 0
  305. icmp.*.5 = 0
  306. icmp.*.8 = 0
  307. icmp.*.9 = 0
  308. icmp.*.10 = 0
  309. icmp.*.11 = 0
  310. icmp.*.12 = 0
  311. icmp.*.13 = 0
  312. icmp.*.14 = 0
  313. icmp.*.15 = 0
  314. icmp.*.16 = 0
  315. icmp.*.17 = 0
  316. icmp.*.18 = 0
  317. icmp.*.1 = 0
  318. icmp.*.2 = 0
  319. icmp.*.3 = 0
  320. icmp.*.4 = 0
  321. icmp.*.128 = 0
  322. icmp.*.129 = 0
  323. icmp.*.130 = 0
  324. icmp.*.131 = 2
  325. icmp.*.132 = 0
  326. icmp.*.133 = 0
  327. icmp.*.134 = 0
  328. icmp.*.135 = 0
  329. icmp.*.136 = 0
  330. icmp.*.137 = 0
  331.  
  332. RRD[[0;32mlast ups/netstats-icmp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  333. RRD[[0;32mupdate ups/netstats-icmp.rrd N:1778222:1781219:0:0:1778221:0:0:1778221:0:2998:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  334. [[0;31mRRD Disabled[0m] SNMPSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 snmp[0m]
  335. snmpInPkts.0 = 5052090
  336. snmpOutPkts.0 = 5043826
  337. snmpInBadVersions.0 = 0
  338. snmpInBadCommunityNames.0 = 3132
  339. snmpInBadCommunityUses.0 = 2830
  340. snmpInASNParseErrs.0 = 0
  341. snmpInTooBigs.0 = 0
  342. snmpInNoSuchNames.0 = 0
  343. snmpInBadValues.0 = 0
  344. snmpInReadOnlys.0 = 0
  345. snmpInGenErrs.0 = 0
  346. snmpInTotalReqVars.0 = 5292159
  347. snmpInTotalSetVars.0 = 0
  348. snmpInGetRequests.0 = 1860395
  349. snmpInGetNexts.0 = 944
  350. snmpInSetRequests.0 = 0
  351. snmpInGetResponses.0 = 0
  352. snmpInTraps.0 = 0
  353. snmpOutTooBigs.0 = 0
  354. snmpOutNoSuchNames.0 = 2830
  355. snmpOutBadValues.0 = 0
  356. snmpOutGenErrs.0 = 0
  357. snmpOutGetRequests.0 = 0
  358. snmpOutGetNexts.0 = 0
  359. snmpOutSetRequests.0 = 0
  360. snmpOutGetResponses.0 = 5043828
  361. snmpOutTraps.0 = 28196
  362. snmpEnableAuthenTraps.0 = enabled
  363. snmpSilentDrops.0 = 0
  364. snmpProxyDrops.0 = 0
  365.  
  366. RRD[[0;32mlast ups/netstats-snmp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  367. RRD[[0;32mupdate ups/netstats-snmp.rrd N:5052090:5043826:0:3132:2830:0:0:0:0:0:0:5292159:0:1860395:944:0:0:0:0:2830:0:0:0:0:0:5043828:28196:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  368. [[0;31mRRD Disabled[0m] IP-FORWARDSNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQv -M /opt/librenms/mibs udp:HOSTNAME:161 IP-FORWARD-MIB::ipCidrRouteNumber.0[0m]
  369. No Such Object available on this agent at this OID
  370.  
  371.  
  372.  
  373. >> Runtime for poller module 'netstats': 1.0358 seconds with 14072 bytes
  374. #### Unload poller module netstats ####
  375.  
  376. RRD[[0;32mlast ups/poller-perf-netstats.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  377. RRD[[0;32mupdate ups/poller-perf-netstats.rrd N:1.0358469486237 --daemon unix:/var/run/rrdcached.sock[0m]
  378. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  379. #### Load poller module hr-mib ####
  380. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 hrSystemProcesses.0 hrSystemNumUsers.0[0m]
  381. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  382. hrSystemNumUsers.0 = No Such Object available on this agent at this OID
  383.  
  384.  
  385.  
  386. >> Runtime for poller module 'hr-mib': 0.0445 seconds with 496 bytes
  387. #### Unload poller module hr-mib ####
  388.  
  389. RRD[[0;32mlast ups/poller-perf-hr-mib.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  390. RRD[[0;32mupdate ups/poller-perf-hr-mib.rrd N:0.044543027877808 --daemon unix:/var/run/rrdcached.sock[0m]
  391. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  392. #### Load poller module ucd-mib ####
  393. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 systemStats[0m]
  394. systemStats = No Such Object available on this agent at this OID
  395.  
  396. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 memTotalSwap.0 memAvailSwap.0 memTotalReal.0 memAvailReal.0 memTotalFree.0 memShared.0 memBuffer.0 memCached.0[0m]
  397. memTotalSwap.0 = No Such Object available on this agent at this OID
  398. memAvailSwap.0 = No Such Object available on this agent at this OID
  399. memTotalReal.0 = No Such Object available on this agent at this OID
  400. memAvailReal.0 = No Such Object available on this agent at this OID
  401. memTotalFree.0 = No Such Object available on this agent at this OID
  402. memShared.0 = No Such Object available on this agent at this OID
  403. memBuffer.0 = No Such Object available on this agent at this OID
  404. memCached.0 = No Such Object available on this agent at this OID
  405.  
  406. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 laLoadInt.1 laLoadInt.2 laLoadInt.3[0m]
  407. laLoadInt.1 = No Such Object available on this agent at this OID
  408. laLoadInt.2 = No Such Object available on this agent at this OID
  409. laLoadInt.3 = No Such Object available on this agent at this OID
  410.  
  411.  
  412. >> Runtime for poller module 'ucd-mib': 0.1668 seconds with 1696 bytes
  413. #### Unload poller module ucd-mib ####
  414.  
  415. RRD[[0;32mlast ups/poller-perf-ucd-mib.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  416. RRD[[0;32mupdate ups/poller-perf-ucd-mib.rrd N:0.1667799949646 --daemon unix:/var/run/rrdcached.sock[0m]
  417. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  418. #### Load poller module ipSystemStats ####
  419. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipSystemStats[0m]
  420. ipSystemStatsInReceives.ipv4 = 0
  421. ipSystemStatsInReceives.ipv6 = 7544847
  422. ipSystemStatsHCInReceives.ipv4 = 0
  423. ipSystemStatsHCInReceives.ipv6 = 7544847
  424. ipSystemStatsInOctets.ipv4 = 130444113
  425. ipSystemStatsInOctets.ipv6 = 0
  426. ipSystemStatsHCInOctets.ipv4 = 13015346001
  427. ipSystemStatsHCInOctets.ipv6 = 0
  428. ipSystemStatsInHdrErrors.ipv4 = 0
  429. ipSystemStatsInHdrErrors.ipv6 = 0
  430. ipSystemStatsInNoRoutes.ipv4 = 0
  431. ipSystemStatsInNoRoutes.ipv6 = 0
  432. ipSystemStatsInAddrErrors.ipv4 = 0
  433. ipSystemStatsInAddrErrors.ipv6 = 2
  434. ipSystemStatsInUnknownProtos.ipv4 = 1067379
  435. ipSystemStatsInUnknownProtos.ipv6 = 0
  436. ipSystemStatsInTruncatedPkts.ipv4 = 0
  437. ipSystemStatsInTruncatedPkts.ipv6 = 0
  438. ipSystemStatsInForwDatagrams.ipv4 = 0
  439. ipSystemStatsInForwDatagrams.ipv6 = 0
  440. ipSystemStatsHCInForwDatagrams.ipv4 = 0
  441. ipSystemStatsHCInForwDatagrams.ipv6 = 0
  442. ipSystemStatsReasmReqds.ipv4 = 0
  443. ipSystemStatsReasmReqds.ipv6 = 0
  444. ipSystemStatsReasmOKs.ipv4 = 0
  445. ipSystemStatsReasmOKs.ipv6 = 0
  446. ipSystemStatsReasmFails.ipv4 = 0
  447. ipSystemStatsReasmFails.ipv6 = 0
  448. ipSystemStatsInDiscards.ipv4 = 0
  449. ipSystemStatsInDiscards.ipv6 = 15875
  450. ipSystemStatsInDelivers.ipv4 = 0
  451. ipSystemStatsInDelivers.ipv6 = 270163
  452. ipSystemStatsHCInDelivers.ipv4 = 0
  453. ipSystemStatsHCInDelivers.ipv6 = 0
  454. ipSystemStatsOutRequests.ipv4 = 0
  455. ipSystemStatsOutRequests.ipv6 = 0
  456. ipSystemStatsHCOutRequests.ipv4 = 0
  457. ipSystemStatsHCOutRequests.ipv6 = 0
  458. ipSystemStatsOutNoRoutes.ipv4 = 0
  459. ipSystemStatsOutNoRoutes.ipv6 = 0
  460. ipSystemStatsOutForwDatagrams.ipv4 = 0
  461. ipSystemStatsOutForwDatagrams.ipv6 = 0
  462. ipSystemStatsHCOutForwDatagrams.ipv4 = 0
  463. ipSystemStatsHCOutForwDatagrams.ipv6 = 0
  464. ipSystemStatsOutDiscards.ipv4 = 0
  465. ipSystemStatsOutDiscards.ipv6 = 0
  466. ipSystemStatsOutFragReqds.ipv4 = 0
  467. ipSystemStatsOutFragReqds.ipv6 = 0
  468. ipSystemStatsOutFragOKs.ipv4 = 0
  469. ipSystemStatsOutFragOKs.ipv6 = 0
  470. ipSystemStatsOutFragFails.ipv4 = 1639324279
  471. ipSystemStatsOutFragFails.ipv6 = 0
  472. ipSystemStatsOutFragCreates.ipv4 = 1639324279
  473. ipSystemStatsOutFragCreates.ipv6 = 0
  474. ipSystemStatsOutTransmits.ipv4 = 19250157
  475. ipSystemStatsOutTransmits.ipv6 = 210
  476. ipSystemStatsHCOutTransmits.ipv4 = 19250157
  477. ipSystemStatsHCOutTransmits.ipv6 = 210
  478. ipSystemStatsOutOctets.ipv4 = 0
  479. ipSystemStatsOutOctets.ipv6 = 0
  480. ipSystemStatsHCOutOctets.ipv4 = 0
  481. ipSystemStatsHCOutOctets.ipv6 = 0
  482. ipSystemStatsInMcastPkts.ipv4 = 2
  483. ipSystemStatsInMcastPkts.ipv6 = 254498
  484. ipSystemStatsHCInMcastPkts.ipv4 = 2
  485. ipSystemStatsHCInMcastPkts.ipv6 = 254498
  486. ipSystemStatsInMcastOctets.ipv4 = 0
  487. ipSystemStatsInMcastOctets.ipv6 = 0
  488. ipSystemStatsHCInMcastOctets.ipv4 = 0
  489. ipSystemStatsHCInMcastOctets.ipv6 = 0
  490. ipSystemStatsOutMcastPkts.ipv4 = 112286740
  491. ipSystemStatsOutMcastPkts.ipv6 = 0
  492. ipSystemStatsHCOutMcastPkts.ipv4 = 112286740
  493. ipSystemStatsHCOutMcastPkts.ipv6 = 0
  494. ipSystemStatsOutMcastOctets.ipv4 = 1579
  495. ipSystemStatsOutMcastOctets.ipv6 = 0
  496. ipSystemStatsHCOutMcastOctets.ipv4 = 1579
  497. ipSystemStatsHCOutMcastOctets.ipv6 = 0
  498. ipSystemStatsInBcastPkts.ipv4 = 0:0:00:00.00
  499. ipSystemStatsInBcastPkts.ipv6 = 0:0:00:00.00
  500. ipSystemStatsHCInBcastPkts.ipv4 = 0
  501. ipSystemStatsHCInBcastPkts.ipv6 = 0
  502.  
  503. ipv4 RRD[[0;32mlast ups/ipSystemStats-ipv4.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  504. RRD[[0;32mupdate ups/ipSystemStats-ipv4.rrd N:0:0:0:1067379:0:0:0:0:0:0:0:0:0:1639324279:1639324279:0 --daemon unix:/var/run/rrdcached.sock[0m]
  505. [[0;31mRRD Disabled[0m]ipv6 RRD[[0;32mlast ups/ipSystemStats-ipv6.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  506. RRD[[0;32mupdate ups/ipSystemStats-ipv6.rrd N:7544847:0:2:0:0:0:0:0:15875:0:0:0:0:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  507. [[0;31mRRD Disabled[0m]
  508.  
  509. >> Runtime for poller module 'ipSystemStats': 0.5583 seconds with 16760 bytes
  510. #### Unload poller module ipSystemStats ####
  511.  
  512. RRD[[0;32mlast ups/poller-perf-ipSystemStats.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  513. RRD[[0;32mupdate ups/poller-perf-ipSystemStats.rrd N:0.55827283859253 --daemon unix:/var/run/rrdcached.sock[0m]
  514. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  515. #### Load poller module ports ####
  516. Caching Oids: SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifXEntry[0m]
  517. ifXEntry = No Such Object available on this agent at this OID
  518.  
  519. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifEntry[0m]
  520. ifIndex.1 = 1
  521. ifIndex.2 = 2
  522. ifDescr.1 = eth0
  523. ifDescr.2 = LOOPBACK
  524. ifType.1 = softwareLoopback
  525. ifType.2 = ethernetCsmacd
  526. ifMtu.1 = 1500
  527. ifMtu.2 = 1500
  528. ifSpeed.1 = 0
  529. ifSpeed.2 = 100000000
  530. ifPhysAddress.1 =
  531. ifPhysAddress.2 = 0:20:85:f7:5c:e
  532. ifAdminStatus.1 = up
  533. ifAdminStatus.2 = up
  534. ifOperStatus.1 = up
  535. ifOperStatus.2 = up
  536. ifLastChange.1 = 0
  537. ifLastChange.2 = 989
  538. ifInOctets.1 = 3912698
  539. ifInOctets.2 = 126532679
  540. ifInUcastPkts.1 = 28197
  541. ifInUcastPkts.2 = 8213622
  542. ifInNUcastPkts.1 = 0
  543. ifInNUcastPkts.2 = 131536898
  544. ifInDiscards.1 = 0
  545. ifInDiscards.2 = 0
  546. ifInErrors.1 = 0
  547. ifInErrors.2 = 0
  548. ifInUnknownProtos.1 = 0
  549. ifInUnknownProtos.2 = 1067379
  550. ifOutOctets.1 = 3912698
  551. ifOutOctets.2 = 1635413737
  552. ifOutUcastPkts.1 = 28197
  553. ifOutUcastPkts.2 = 7515148
  554. ifOutNUcastPkts.1 = 0
  555. ifOutNUcastPkts.2 = 1581
  556. ifOutDiscards.1 = 0
  557. ifOutDiscards.2 = 0
  558. ifOutErrors.1 = 0
  559. ifOutErrors.2 = 0
  560. ifOutQLen.1 = 0
  561. ifOutQLen.2 = 0
  562. ifSpecific.1 = zeroDotZero
  563. ifSpecific.2 = zeroDotZero
  564.  
  565. dot3StatsDuplexStatusSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot3StatsIndex[0m]
  566. dot3StatsIndex = No Such Object available on this agent at this OID
  567.  
  568. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot3StatsDuplexStatus[0m]
  569. dot3StatsDuplexStatus = No Such Object available on this agent at this OID
  570.  
  571. SQL[[0;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = '44' AND `ifType` = 'adsl'[0m]
  572. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m POWER-ETHERNET-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 pethPsePortEntry[0m]
  573. pethPsePortEntry = No Such Object available on this agent at this OID
  574.  
  575. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m CISCO-POWER-ETHERNET-EXT-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 cpeExtPsePortEntry[0m]
  576. cpeExtPsePortEntry = No Such Object available on this agent at this OID
  577.  
  578. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1qPvid[0m]
  579. dot1qPvid = No Such Object available on this agent at this OID
  580.  
  581. Array
  582. (
  583.     [1] => Array
  584.         (
  585.             [ifIndex] => 1
  586.             [ifDescr] => eth0
  587.             [ifType] => softwareLoopback
  588.             [ifMtu] => 1500
  589.             [ifSpeed] => 0
  590.             [ifPhysAddress] =>
  591.             [ifAdminStatus] => up
  592.             [ifOperStatus] => up
  593.             [ifLastChange] => 0
  594.             [ifInOctets] => 3912698
  595.             [ifInUcastPkts] => 28197
  596.             [ifInNUcastPkts] => 0
  597.             [ifInDiscards] => 0
  598.             [ifInErrors] => 0
  599.             [ifInUnknownProtos] => 0
  600.             [ifOutOctets] => 3912698
  601.             [ifOutUcastPkts] => 28197
  602.             [ifOutNUcastPkts] => 0
  603.             [ifOutDiscards] => 0
  604.             [ifOutErrors] => 0
  605.             [ifOutQLen] => 0
  606.             [ifSpecific] => zeroDotZero
  607.         )
  608.  
  609.     [2] => Array
  610.         (
  611.             [ifIndex] => 2
  612.             [ifDescr] => LOOPBACK
  613.             [ifType] => ethernetCsmacd
  614.             [ifMtu] => 1500
  615.             [ifSpeed] => 100000000
  616.             [ifPhysAddress] => 0:20:85:f7:5c:e
  617.             [ifAdminStatus] => up
  618.             [ifOperStatus] => up
  619.             [ifLastChange] => 989
  620.             [ifInOctets] => 126532679
  621.             [ifInUcastPkts] => 8213622
  622.             [ifInNUcastPkts] => 131536898
  623.             [ifInDiscards] => 0
  624.             [ifInErrors] => 0
  625.             [ifInUnknownProtos] => 1067379
  626.             [ifOutOctets] => 1635413737
  627.             [ifOutUcastPkts] => 7515148
  628.             [ifOutNUcastPkts] => 1581
  629.             [ifOutDiscards] => 0
  630.             [ifOutErrors] => 0
  631.             [ifOutQLen] => 0
  632.             [ifSpecific] => zeroDotZero
  633.         )
  634.  
  635. )
  636. SQL[[0;33mSELECT `name` FROM `port_association_mode` WHERE pom_id = '1'[0m]
  637. SQL[[0;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` = '44' ORDER BY ports.port_id[0m]
  638. validvalid
  639. Port eth0: eth0 (1 / #783) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN == Using ifDescr as ifAliasUsing ifDescr as ifNameeth0
  640.  ifInOctets (0 B) 0 Bps 142 secs
  641.  
  642.  ifOutOctets (0 B) 0 Bps 142 secs
  643.  
  644.  ifInErrors (0 B) 0 Bps 142 secs
  645.  
  646.  ifOutErrors (0 B) 0 Bps 142 secs
  647.  
  648.  ifInUcastPkts (0 B) 0 Bps 142 secs
  649.  
  650.  ifOutUcastPkts (0 B) 0 Bps 142 secs
  651.  
  652.  ifInNUcastPkts (0 B) 0 Bps 142 secs
  653.  
  654.  ifOutNUcastPkts (0 B) 0 Bps 142 secs
  655.  
  656.  ifInDiscards (0 B) 0 Bps 142 secs
  657.  
  658.  ifOutDiscards (0 B) 0 Bps 142 secs
  659.  
  660.  ifInUnknownProtos (0 B) 0 Bps 142 secs
  661.  
  662.  ifInBroadcastPkts (0 B) 0 Bps 142 secs
  663.  
  664.  ifOutBroadcastPkts (0 B) 0 Bps 142 secs
  665.  
  666.  ifInMulticastPkts (0 B) 0 Bps 142 secs
  667.  
  668.  ifOutMulticastPkts (0 B) 0 Bps 142 secs
  669. bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[[0;32mlast ups/port-id783.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  670. RRD[[0;32mupdate ups/port-id783.rrd N:3912698:3912698:0:0:28197:28197:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  671. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `ports` set `poll_time` ='1499075043',`poll_prev` ='1499074901',`poll_period` ='142',`ifLastChange` ='0',`ifInOctets` ='3912698',`ifInOctets_prev` ='3912698',`ifInOctets_rate` ='0',`ifInOctets_delta` ='0',`ifOutOctets` ='3912698',`ifOutOctets_prev` ='3912698',`ifOutOctets_rate` ='0',`ifOutOctets_delta` ='0',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='28197',`ifInUcastPkts_prev` ='28197',`ifInUcastPkts_rate` ='0',`ifInUcastPkts_delta` ='0',`ifOutUcastPkts` ='28197',`ifOutUcastPkts_prev` ='28197',`ifOutUcastPkts_rate` ='0',`ifOutUcastPkts_delta` ='0' WHERE `port_id` = '783'[0m]
  672. SQL[[0;33mUPDATE `ports_statistics` set `ifInNUcastPkts` ='0',`ifInNUcastPkts_prev` ='0',`ifInNUcastPkts_rate` ='0',`ifInNUcastPkts_delta` ='0',`ifOutNUcastPkts` ='0',`ifOutNUcastPkts_prev` ='0',`ifOutNUcastPkts_rate` ='0',`ifOutNUcastPkts_delta` ='0',`ifInDiscards` ='0',`ifInDiscards_prev` ='0',`ifInDiscards_rate` ='0',`ifInDiscards_delta` ='0',`ifOutDiscards` ='0',`ifOutDiscards_prev` ='0',`ifOutDiscards_rate` ='0',`ifOutDiscards_delta` ='0',`ifInUnknownProtos` ='0',`ifInUnknownProtos_prev` ='0',`ifInUnknownProtos_rate` ='0',`ifInUnknownProtos_delta` ='0',`ifInBroadcastPkts` ='0',`ifInBroadcastPkts_prev` ='0',`ifInBroadcastPkts_rate` ='0',`ifInBroadcastPkts_delta` ='0',`ifOutBroadcastPkts` ='0',`ifOutBroadcastPkts_prev` ='0',`ifOutBroadcastPkts_rate` ='0',`ifOutBroadcastPkts_delta` ='0',`ifInMulticastPkts` ='0',`ifInMulticastPkts_prev` ='0',`ifInMulticastPkts_rate` ='0',`ifInMulticastPkts_delta` ='0',`ifOutMulticastPkts` ='0',`ifOutMulticastPkts_prev` ='0',`ifOutMulticastPkts_rate` ='0',`ifOutMulticastPkts_delta` ='0' WHERE `port_id` = '783'[0m]
  673. 1 updated
  674. Port LOOPBACK: LOOPBACK (2 / #784) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN == Using ifDescr as ifAliasUsing ifDescr as ifNameLOOPBACK
  675.  ifInOctets (60239 B) 424.21830985915 Bps 142 secs
  676.  
  677.  ifOutOctets (27329 B) 192.45774647887 Bps 142 secs
  678.  
  679.  ifInErrors (0 B) 0 Bps 142 secs
  680.  
  681.  ifOutErrors (0 B) 0 Bps 142 secs
  682.  
  683.  ifInUcastPkts (159 B) 1.1197183098592 Bps 142 secs
  684.  
  685.  ifOutUcastPkts (153 B) 1.0774647887324 Bps 142 secs
  686.  
  687.  ifInNUcastPkts (422 B) 2.9718309859155 Bps 142 secs
  688.  
  689.  ifOutNUcastPkts (0 B) 0 Bps 142 secs
  690.  
  691.  ifInDiscards (0 B) 0 Bps 142 secs
  692.  
  693.  ifOutDiscards (0 B) 0 Bps 142 secs
  694.  
  695.  ifInUnknownProtos (7 B) 0.049295774647887 Bps 142 secs
  696.  
  697.  ifInBroadcastPkts (0 B) 0 Bps 142 secs
  698.  
  699.  ifOutBroadcastPkts (0 B) 0 Bps 142 secs
  700.  
  701.  ifInMulticastPkts (0 B) 0 Bps 142 secs
  702.  
  703.  ifOutMulticastPkts (0 B) 0 Bps 142 secs
  704. bps(3.390kbps/1.540kbps)bytes(58.830kB/26.690kB)pkts(1.120pps/1.080pps)RRD[[0;32mlast ups/port-id784.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  705. RRD[[0;32mupdate ups/port-id784.rrd N:126532679:1635413737:0:0:8213622:7515148:131536898:1581:0:0:1067379:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  706. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `ports` set `poll_time` ='1499075043',`poll_prev` ='1499074901',`poll_period` ='142',`ifLastChange` ='989',`ifInOctets` ='126532679',`ifInOctets_prev` ='126472440',`ifInOctets_rate` ='424.21830985915',`ifInOctets_delta` ='60239',`ifOutOctets` ='1635413737',`ifOutOctets_prev` ='1635386408',`ifOutOctets_rate` ='192.45774647887',`ifOutOctets_delta` ='27329',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='8213622',`ifInUcastPkts_prev` ='8213463',`ifInUcastPkts_rate` ='1.1197183098592',`ifInUcastPkts_delta` ='159',`ifOutUcastPkts` ='7515148',`ifOutUcastPkts_prev` ='7514995',`ifOutUcastPkts_rate` ='1.0774647887324',`ifOutUcastPkts_delta` ='153' WHERE `port_id` = '784'[0m]
  707. SQL[[0;33mUPDATE `ports_statistics` set `ifInNUcastPkts` ='131536898',`ifInNUcastPkts_prev` ='131536476',`ifInNUcastPkts_rate` ='2.9718309859155',`ifInNUcastPkts_delta` ='422',`ifOutNUcastPkts` ='1581',`ifOutNUcastPkts_prev` ='1581',`ifOutNUcastPkts_rate` ='0',`ifOutNUcastPkts_delta` ='0',`ifInDiscards` ='0',`ifInDiscards_prev` ='0',`ifInDiscards_rate` ='0',`ifInDiscards_delta` ='0',`ifOutDiscards` ='0',`ifOutDiscards_prev` ='0',`ifOutDiscards_rate` ='0',`ifOutDiscards_delta` ='0',`ifInUnknownProtos` ='1067379',`ifInUnknownProtos_prev` ='1067372',`ifInUnknownProtos_rate` ='0.049295774647887',`ifInUnknownProtos_delta` ='7',`ifInBroadcastPkts` ='0',`ifInBroadcastPkts_prev` ='0',`ifInBroadcastPkts_rate` ='0',`ifInBroadcastPkts_delta` ='0',`ifOutBroadcastPkts` ='0',`ifOutBroadcastPkts_prev` ='0',`ifOutBroadcastPkts_rate` ='0',`ifOutBroadcastPkts_delta` ='0',`ifInMulticastPkts` ='0',`ifInMulticastPkts_prev` ='0',`ifInMulticastPkts_rate` ='0',`ifInMulticastPkts_delta` ='0',`ifOutMulticastPkts` ='0',`ifOutMulticastPkts_prev` ='0',`ifOutMulticastPkts_rate` ='0',`ifOutMulticastPkts_delta` ='0' WHERE `port_id` = '784'[0m]
  708. 2 updated
  709.  
  710. >> Runtime for poller module 'ports': 0.9786 seconds with 35760 bytes
  711. #### Unload poller module ports ####
  712.  
  713. RRD[[0;32mlast ups/poller-perf-ports.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  714. RRD[[0;32mupdate ups/poller-perf-ports.rrd N:0.97858595848083 --daemon unix:/var/run/rrdcached.sock[0m]
  715. [[0;31mRRD Disabled[0m]Modules status: Global- OS  Device  Module [ bgp-peers ] disabled globally.
  716.  
  717. Modules status: Global- OS  Device  Module [ junose-atm-vp ] disabled globally.
  718.  
  719. Modules status: Global- OS  Device  Module [ toner ] disabled globally.
  720.  
  721. Modules status: Global+ OS  Device  
  722. #### Load poller module ucd-diskio ####
  723. SQL[[0;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = '44'[0m]
  724.  
  725. >> Runtime for poller module 'ucd-diskio': 0.0006 seconds with -472 bytes
  726. #### Unload poller module ucd-diskio ####
  727.  
  728. RRD[[0;32mlast ups/poller-perf-ucd-diskio.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  729. RRD[[0;32mupdate ups/poller-perf-ucd-diskio.rrd N:0.00057411193847656 --daemon unix:/var/run/rrdcached.sock[0m]
  730. [[0;31mRRD Disabled[0m]Modules status: Global- OS  Device  Module [ wifi ] disabled globally.
  731.  
  732. Modules status: Global+ OS  Device  
  733. #### Load poller module wireless ####
  734. Attempting to initialize OS: powerwalker
  735. SQL[[0;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = '44'[0m]
  736.  
  737. >> Runtime for poller module 'wireless': 0.0018 seconds with 110592 bytes
  738. #### Unload poller module wireless ####
  739.  
  740. RRD[[0;32mlast ups/poller-perf-wireless.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  741. RRD[[0;32mupdate ups/poller-perf-wireless.rrd N:0.0017640590667725 --daemon unix:/var/run/rrdcached.sock[0m]
  742. [[0;31mRRD Disabled[0m]Modules status: Global- OS  Device  Module [ ospf ] disabled globally.
  743.  
  744. Modules status: Global- OS  Device  Module [ cisco-ipsec-flow-monitor ] disabled globally.
  745.  
  746. Modules status: Global- OS  Device  Module [ cisco-remote-access-monitor ] disabled globally.
  747.  
  748. Modules status: Global- OS  Device  Module [ cisco-cef ] disabled globally.
  749.  
  750. Modules status: Global- OS  Device  Module [ cisco-sla ] disabled globally.
  751.  
  752. Modules status: Global- OS  Device  Module [ cisco-mac-accounting ] disabled globally.
  753.  
  754. Modules status: Global- OS  Device  Module [ cipsec-tunnels ] disabled globally.
  755.  
  756. Modules status: Global- OS  Device  Module [ cisco-ace-loadbalancer ] disabled globally.
  757.  
  758. Modules status: Global- OS  Device  Module [ cisco-ace-serverfarms ] disabled globally.
  759.  
  760. Modules status: Global- OS  Device  Module [ cisco-asa-firewall ] disabled globally.
  761.  
  762. Modules status: Global- OS  Device  Module [ cisco-voice ] disabled globally.
  763.  
  764. Modules status: Global- OS  Device  Module [ cisco-cbqos ] disabled globally.
  765.  
  766. Modules status: Global- OS  Device  Module [ cisco-otv ] disabled globally.
  767.  
  768. Modules status: Global- OS  Device  Module [ cisco-vpdn ] disabled globally.
  769.  
  770. Modules status: Global- OS  Device  Module [ netscaler-vsvr ] disabled globally.
  771.  
  772. Modules status: Global- OS  Device  Module [ aruba-controller ] disabled globally.
  773.  
  774. Modules status: Global+ OS  Device  
  775. #### Load poller module entity-physical ####
  776. SQL[[0;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = '44'[0m]
  777.  
  778. >> Runtime for poller module 'entity-physical': 0.0006 seconds with 960 bytes
  779. #### Unload poller module entity-physical ####
  780.  
  781. RRD[[0;32mlast ups/poller-perf-entity-physical.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  782. RRD[[0;32mupdate ups/poller-perf-entity-physical.rrd N:0.00059103965759277 --daemon unix:/var/run/rrdcached.sock[0m]
  783. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  784. #### Load poller module applications ####
  785. SQL[[0;33mSELECT * FROM `applications` WHERE `device_id`  = '44'[0m]
  786. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.8072.1.3.2.3.1.2.10.117.112.115.45.97.112.99.117.112.115[0m]
  787. No Such Object available on this agent at this OID
  788.  
  789. SQL[[0;33mUPDATE `applications` set `app_state` ='UNKNOWN',`app_status` ='',`timestamp` =NOW() WHERE `app_id` = '14'[0m]
  790.  ups-apcupsRRD[[0;32mlast ups/app-ups-apcups-14.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  791. RRD[[0;32mupdate ups/app-ups-apcups-14.rrd N:U:U:U:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  792. [[0;31mRRD Disabled[0m]SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.8072.1.3.2.3.1.2.7.117.112.115.45.110.117.116[0m]
  793. No Such Object available on this agent at this OID
  794.  
  795. SQL[[0;33mUPDATE `applications` set `app_state` ='UNKNOWN',`app_status` ='',`timestamp` =NOW() WHERE `app_id` = '3'[0m]
  796. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.2.101[0m]
  797. No Such Object available on this agent at this OID
  798.  
  799.  ups-nutRRD[[0;32mlast ups/app-ups-nut-3.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  800. RRD[[0;32mupdate ups/app-ups-nut-3.rrd N:U:U:0:U:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  801. [[0;31mRRD Disabled[0m]
  802.  
  803. >> Runtime for poller module 'applications': 0.1186 seconds with 8096 bytes
  804. #### Unload poller module applications ####
  805.  
  806. RRD[[0;32mlast ups/poller-perf-applications.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  807. RRD[[0;32mupdate ups/poller-perf-applications.rrd N:0.11861896514893 --daemon unix:/var/run/rrdcached.sock[0m]
  808. [[0;31mRRD Disabled[0m]Modules status: Global- OS  Device  Module [ mib ] disabled globally.
  809.  
  810. Modules status: Global+ OS  Device  
  811. #### Load poller module stp ####
  812. SQL[[0;33mSELECT * FROM `stp` WHERE `device_id` = '44'[0m]
  813. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dStpProtocolSpecification.0[0m]
  814. No Such Object available on this agent at this OID
  815.  
  816.  
  817.  
  818. >> Runtime for poller module 'stp': 0.0291 seconds with 3400 bytes
  819. #### Unload poller module stp ####
  820.  
  821. RRD[[0;32mlast ups/poller-perf-stp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  822. RRD[[0;32mupdate ups/poller-perf-stp.rrd N:0.029082059860229 --daemon unix:/var/run/rrdcached.sock[0m]
  823. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  824. #### Load poller module ntp ####
  825.  
  826. >> Runtime for poller module 'ntp': 0.0001 seconds with 192 bytes
  827. #### Unload poller module ntp ####
  828.  
  829. RRD[[0;32mlast ups/poller-perf-ntp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  830. RRD[[0;32mupdate ups/poller-perf-ntp.rrd N:9.0122222900391E-5 --daemon unix:/var/run/rrdcached.sock[0m]
  831. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  832. #### Load poller module services ####
  833.  
  834. >> Runtime for poller module 'services': 0.0000 seconds with 104 bytes
  835. #### Unload poller module services ####
  836.  
  837. RRD[[0;32mlast ups/poller-perf-services.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  838. RRD[[0;32mupdate ups/poller-perf-services.rrd N:2.6941299438477E-5 --daemon unix:/var/run/rrdcached.sock[0m]
  839. [[0;31mRRD Disabled[0m]Modules status: Global- OS  Device  Module [ loadbalancers ] disabled globally.
  840.  
  841. Modules status: Global- OS  Device  Module [ mef ] disabled globally.
  842.  
  843. Modules status: Global- OS  Device  Module [ tnms-nbi ] disabled globally.
  844.  
  845. ### Start Device Groups ###
  846. SQL[[0;33mSELECT * FROM device_groups ORDER BY name[0m]
  847. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysName REGEXP "affinity" ) LIMIT 1[0m]
  848. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysDescr REGEXP "Ethernet Routing Switch" ) LIMIT 1[0m]
  849. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.hostname REGEXP "^esr-" ) LIMIT 1[0m]
  850. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysName REGEXP "^nt-harlow" ) LIMIT 1[0m]
  851. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysName REGEXP "^hb-"  ) LIMIT 1[0m]
  852. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysName REGEXP "impact" ) LIMIT 1[0m]
  853. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysDescr REGEXP "^IP 500") LIMIT 1[0m]
  854. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.hostname REGEXP "^lg-" ) LIMIT 1[0m]
  855. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.os REGEXP "Linux" ) LIMIT 1[0m]
  856. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysDescr REGEXP "nt-netmon" || devices.sysDescr REGEXP "nt-network-monitor" ) LIMIT 1[0m]
  857. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysObjectID REGEXP "enterprises.6889.1.69.5.1") LIMIT 1[0m]
  858. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.location REGEXP "^NT Office") LIMIT 1[0m]
  859. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysName REGEXP "^nt-" && devices.sysName REGEXP "-gw." ) LIMIT 1[0m]
  860. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysName REGEXP "^nt-" && devices.sysName REGEXP "-sw." ) LIMIT 1[0m]
  861. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysName REGEXP "^nt-pearcesign" ) LIMIT 1[0m]
  862. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysObjectID REGEXP "enterprises.14988.1") LIMIT 1[0m]
  863. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysName REGEXP "^nt-sorby" ) LIMIT 1[0m]
  864. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.sysObjectID REGEXP "^enterprises.10002" ) LIMIT 1[0m]
  865. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='44' AND (devices.hostname REGEXP "^v1-" ) LIMIT 1[0m]
  866. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='44'[0m]
  867. Groups Added:
  868. Groups Removed:
  869. ### End Device Groups ###
  870. SQL[[0;33mSELECT `graph` FROM `device_graphs` WHERE `device_id` = '44'[0m]
  871. uptime netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt ipsystemstats_ipv4 ipsystemstats_ipv4_frag ipsystemstats_ipv6 ipsystemstats_ipv6_frag RRD[[0;32mlast ups/poller-perf.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  872. RRD[[0;32mupdate ups/poller-perf.rrd N:3.669 --daemon unix:/var/run/rrdcached.sock[0m]
  873. [[0;31mRRD Disabled[0m]RRD[[0;32mlast ups/ping-perf.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  874. RRD[[0;32mupdate ups/ping-perf.rrd N:0.93 --daemon unix:/var/run/rrdcached.sock[0m]
  875. [[0;31mRRD Disabled[0m]Polled in 3.669 seconds
  876. Updating ups
  877. SQL[[0;33mUPDATE `devices` set `uptime` ='30538167',`last_ping` =NOW(),`last_ping_timetaken` ='0.93',`last_polled` =NOW(),`last_polled_timetaken` ='3.669' WHERE `device_id` = '44'[0m]
  878. UPDATED!
  879. #### Start Alerts ####
  880. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='44'[0m]
  881. SQL[[0;33mSELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '44' ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '[1;33m-[0;35m-%d') AND (end_recurring_dt >= date_format(NOW(), '[1;33m-[0;35m-%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), '[0;37m'),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1[0m]
  882. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='44'[0m]
  883. SQL[[0;33mSELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE alert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = '44' ) || alert_map.target = '44'  )[0m]
  884. Rule [0;35m#1 (Devices up/down):[0m
  885. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '1' && device_id = '44' ORDER BY id DESC LIMIT 1[0m]
  886. SQL[[0;33mSELECT * FROM devices WHERE (devices.device_id = '44') && (((devices.status = 0  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"    )[0m]
  887. Status: [0;34mNOCHG[0m
  888. Rule [0;35m#2 (Device rebooted):[0m
  889. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '2' && device_id = '44' ORDER BY id DESC LIMIT 1[0m]
  890. SQL[[0;33mSELECT * FROM devices WHERE (devices.device_id = '44') && (devices.uptime < "300"  &&  ((devices.disabled = 0  &&  devices.ignore = 0)) = "1")[0m]
  891. Status: [0;34mNOCHG[0m
  892. Rule [0;35m#5 (Port status up/down):[0m
  893. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '5' && device_id = '44' ORDER BY id DESC LIMIT 1[0m]
  894. SQL[[0;33mSELECT * FROM ports WHERE (ports.device_id = '44') && (((ports.ifOperStatus = "down"  &&  ports.ifAdminStatus != "down"  &&  ((ports.deleted = 0  &&  ports.ignore = 0  &&  ports.disabled = 0)))) = "1")[0m]
  895. Status: [0;34mNOCHG[0m
  896. Rule [0;35m#6 (Port utilisation over threshold):[0m
  897. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '6' && device_id = '44' ORDER BY id DESC LIMIT 1[0m]
  898. SQL[[0;33mSELECT * FROM ports WHERE (ports.device_id = '44') && (((ports.ifOperStatus = "up"  &&  ports.ifAdminStatus = "up"  &&  ((ports.deleted = 0  &&  ports.ignore = 0  &&  ports.disabled = 0)))) = "1"  &&  ((ports.deleted = 0  &&  ports.ignore = 0  &&  ports.disabled = 0)) = "1"     &&  (((ports.ifInOctets_rate*8) / ports.ifSpeed)*100) > "95" )[0m]
  899. Status: [0;34mNOCHG[0m
  900. Rule [0;35m#7 (Sensor over limit):[0m
  901. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '7' && device_id = '44' ORDER BY id DESC LIMIT 1[0m]
  902. SQL[[0;33mSELECT * FROM sensors WHERE (sensors.device_id = '44') && (sensors.sensor_current > sensors.sensor_limit  &&  sensors.sensor_alert = "1"    )[0m]
  903. Status: [0;34mNOCHG[0m
  904. Rule [0;35m#8 (Sensor under limit):[0m
  905. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '8' && device_id = '44' ORDER BY id DESC LIMIT 1[0m]
  906. SQL[[0;33mSELECT * FROM sensors WHERE (sensors.device_id = '44') && (sensors.sensor_current < sensors sensors.sensor_alert = "1" rule_id = '12' device_id = '44' xss=removed syslog.device_id = '44'>= (DATE_SUB(NOW(),INTERVAL 5 MINUTE))  &&  syslog.msg REGEXP ".*failed.*"    &&  syslog.program REGEXP ".*TRP|LOGON.*"      &&  devices.hostname != "ipo-midlandaero" )[0m]
  907. Status: [0;34mNOCHG[0m
  908. Rule [0;35m#15 (IPSec tunnels down):[0m
  909. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '15' && device_id = '44' ORDER BY id DESC LIMIT 1[0m]
  910. SQL[[0;33mSELECT * FROM ipsec_tunnels,devices WHERE (( devices.device_id = ipsec_tunnels.device_id ) && ipsec_tunnels.device_id = '44') && (ipsec_tunnels.tunnel_status != "active"  &&  ((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"  )[0m]
  911. Status: [0;34mNOCHG[0m
  912. Rule [0;35m#16 (packet loss over 10%in last 5m):[0m
  913. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '16' && device_id = '44' ORDER BY id DESC LIMIT 1[0m]
  914. SQL[[0;33mSELECT * FROM device_perf,devices WHERE (( devices.device_id = device_perf.device_id ) && device_perf.device_id = '44') && ((((DATE_SUB(NOW(),INTERVAL 5 MINUTE))  &&  device_perf.loss)) >= "10"    &&  ((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"   )[0m]
  915. Status: [0;34mNOCHG[0m
  916. Rule [0;35m#18 (CPU High):[0m
  917. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '18' && device_id = '44' ORDER BY id DESC LIMIT 1[0m]
  918. SQL[[0;33m[0m]
  919. Status: [0;34mNOCHG[0m
  920. Rule [0;35m#19 (Storage over 90%):[0m
  921. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '19' && device_id = '44' ORDER BY id DESC LIMIT 1[0m]
  922. SQL[[0;33mSELECT * FROM devices,storage WHERE (( storage.device_id = devices.device_id ) && devices.device_id = '44') && (((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"  &&  storage.storage_perc > "90"    &&  devices.os != "junos" )[0m]
  923. Status: [0;34mNOCHG[0m
  924. #### End Alerts ####
  925. SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','ups','1499075040.2846','3.722','1','librenms\n')[0m]
  926. ./poller.php ups 2017-07-03 10:44:04 - 1 devices polled in 3.722 secs
  927. SNMP: Get[21/0.73s] Walk [12/2.46s]
  928. MySQL: Cell[23/0.01s] Row[14/0.00s] Rows[35/0.02s] Column[3/0.00s] Update[18/0.01s] Insert[2/0.00s] Delete[0/0.00s]
  929.