From Tom Sealey, 1 Year ago, written in Plain Text.
This paste is a reply to from - go back
Embed
Viewing differences between and UCP100 Poller
  1. LibreNMS Poller
  2. Version info:
  3. Commit SHA: 75d62aa068944e17948253781b3805140a98f813
  4. Commit Date: 1492617392
  5. DB Schema: 186
  6. PHP: 7.0.15-0ubuntu0.16.04.4
  7. MySQL: 10.0.29-MariaDB-0ubuntu0.16.04.1
  8. RRDTool: 1.5.5
  9. SNMP: NET-SNMP 5.7.3
  10. DEBUG!
  11. Starting polling run:
  12.  
  13. SQL[[0;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'lg-testucp' ORDER BY `device_id` ASC[0m]
  14. SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '49'[0m]
  15. Hostname: lg-testucp
  16. Device ID: 49
  17. OS: ELG-UCP100
  18.  
  19. SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','0.62','0.76','0.67','49',NOW())[0m]
  20. SNMP Check response code: 0
  21. 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]
  22. sysUpTime.0 = 15710664
  23. sysLocation.0 = NTVD Demo
  24. sysContact.0 = www.ipecs.com
  25. sysName.0 = OpenWrt
  26. sysObjectID.0 = enterprises.572.16838
  27.  
  28. 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]
  29. Ericsson-LG,UCP100,UCP-R2.0.16&Boot Version-1.0Da JAN/16
  30.  
  31. 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]
  32. snmpEngineTime.0 = No Such Object available on this agent at this OID
  33. hrSystemUptime.0 = No Such Object available on this agent at this OID
  34.  
  35. Using SNMP Agent Uptime (157106s)
  36.   RRD[[0;32mlast lg-testucp/uptime.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  37. RRD[[0;32mupdate lg-testucp/uptime.rrd N:157106 --daemon unix:/var/run/rrdcached.sock[0m]
  38. [[0;31mRRD Disabled[0m]Uptime: 1 day, 19h 38m 26s
  39. SQL[[0;33mSELECT `lat`,`lng` FROM `locations` WHERE `location`='NTVD Demo' LIMIT 1[0m]
  40. Google geocode engine being used
  41. Bad lat / lng received
  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 520 bytes
  53. #### Unload poller module os ####
  54.  
  55. RRD[[0;32mlast lg-testucp/poller-perf-os.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  56. RRD[[0;32mupdate lg-testucp/poller-perf-os.rrd N:0.00023984909057617 --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 = '49' AND poller_type='ipmi'[0m]
  60. Array
  61. (
  62. )
  63.  
  64. >> Runtime for poller module 'ipmi': 0.0008 seconds with 1280 bytes
  65. #### Unload poller module ipmi ####
  66.  
  67. RRD[[0;32mlast lg-testucp/poller-perf-ipmi.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  68. RRD[[0;32mupdate lg-testucp/poller-perf-ipmi.rrd N:0.00075006484985352 --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` = '49' GROUP BY `sensor_class`[0m]
  72.  
  73. >> Runtime for poller module 'sensors': 0.0004 seconds with 208 bytes
  74. #### Unload poller module sensors ####
  75.  
  76. RRD[[0;32mlast lg-testucp/poller-perf-sensors.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  77. RRD[[0;32mupdate lg-testucp/poller-perf-sensors.rrd N:0.00044798851013184 --daemon unix:/var/run/rrdcached.sock[0m]
  78. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  79. #### Load poller module processors ####
  80. SQL[[0;33mSELECT * FROM processors WHERE device_id = '49'[0m]
  81.  
  82. >> Runtime for poller module 'processors': 0.0004 seconds with 600 bytes
  83. #### Unload poller module processors ####
  84.  
  85. RRD[[0;32mlast lg-testucp/poller-perf-processors.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  86. RRD[[0;32mupdate lg-testucp/poller-perf-processors.rrd N:0.00039410591125488 --daemon unix:/var/run/rrdcached.sock[0m]
  87. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  88. #### Load poller module mempools ####
  89. SQL[[0;33mSELECT * FROM mempools WHERE device_id = '49'[0m]
  90.  
  91. >> Runtime for poller module 'mempools': 0.0005 seconds with 632 bytes
  92. #### Unload poller module mempools ####
  93.  
  94. RRD[[0;32mlast lg-testucp/poller-perf-mempools.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  95. RRD[[0;32mupdate lg-testucp/poller-perf-mempools.rrd N:0.00046300888061523 --daemon unix:/var/run/rrdcached.sock[0m]
  96. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  97. #### Load poller module storage ####
  98. SQL[[0;33mSELECT * FROM storage WHERE device_id = '49'[0m]
  99.  
  100. >> Runtime for poller module 'storage': 0.0005 seconds with 752 bytes
  101. #### Unload poller module storage ####
  102.  
  103. RRD[[0;32mlast lg-testucp/poller-perf-storage.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  104. RRD[[0;32mupdate lg-testucp/poller-perf-storage.rrd N:0.00052905082702637 --daemon unix:/var/run/rrdcached.sock[0m]
  105. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  106. #### Load poller module netstats ####
  107.  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]
  108. ipForwDatagrams.0 = 0
  109. ipInDelivers.0 = 291989
  110. ipInReceives.0 = 291989
  111. ipOutRequests.0 = 207833
  112. ipInDiscards.0 = 0
  113. ipOutDiscards.0 = 0
  114. ipOutNoRoutes.0 = 0
  115. ipReasmReqds.0 = 0
  116. ipReasmOKs.0 = 0
  117. ipReasmFails.0 = 0
  118. ipFragOKs.0 = 0
  119. ipFragFails.0 = 0
  120. ipFragCreates.0 = 0
  121. ipInUnknownProtos.0 = 0
  122. ipInHdrErrors.0 = 0
  123. ipInAddrErrors.0 = 0
  124.  
  125. RRD[[0;32mlast lg-testucp/netstats-ip.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  126. RRD[[0;32mupdate lg-testucp/netstats-ip.rrd N:0:291989:291989:207833:0:0:0:0:0:0:0:0:0:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  127. [[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]
  128. tcpActiveOpens.0 = 0
  129. tcpPassiveOpens.0 = 0
  130. tcpAttemptFails.0 = 0
  131. tcpEstabResets.0 = 0
  132. tcpCurrEstab.0 = 0
  133. tcpInSegs.0 = 0
  134. tcpOutSegs.0 = 0
  135. tcpRetransSegs.0 = 0
  136. tcpInErrs.0 = 0
  137. tcpOutRsts.0 = 0
  138. tcpHCInSegs.0 = No Such Object available on this agent at this OID
  139. tcpHCOutSegs.0 = No Such Object available on this agent at this OID
  140.  
  141. RRD[[0;32mlast lg-testucp/netstats-tcp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  142. RRD[[0;32mupdate lg-testucp/netstats-tcp.rrd N:0:0:0:0:0:0:0:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  143. [[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]
  144. udpInDatagrams.0 = 246408
  145. udpOutDatagrams.0 = 183852
  146. udpInErrors.0 = 0
  147. udpNoPorts.0 = 0
  148.  
  149. RRD[[0;32mlast lg-testucp/netstats-udp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  150. RRD[[0;32mupdate lg-testucp/netstats-udp.rrd N:246408:183852:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  151. [[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]
  152. icmpInMsgs.0 = 10885
  153. icmpInErrors.0 = 0
  154. icmpInDestUnreachs.0 = 215
  155. icmpInTimeExcds.0 = 0
  156. icmpInParmProbs.0 = 0
  157. icmpInSrcQuenchs.0 = 0
  158. icmpInRedirects.0 = 0
  159. icmpInEchos.0 = 10670
  160. icmpInEchoReps.0 = 0
  161. icmpInTimestamps.0 = 0
  162. icmpInTimestampReps.0 = 0
  163. icmpInAddrMasks.0 = 0
  164. icmpInAddrMaskReps.0 = 0
  165. icmpOutMsgs.0 = 10670
  166. icmpOutErrors.0 = 0
  167. icmpOutDestUnreachs.0 = 0
  168. icmpOutTimeExcds.0 = 0
  169. icmpOutParmProbs.0 = 0
  170. icmpOutSrcQuenchs.0 = 0
  171. icmpOutRedirects.0 = 0
  172. icmpOutEchos.0 = 0
  173. icmpOutEchoReps.0 = 10670
  174. icmpOutTimestamps.0 = 0
  175. icmpOutTimestampReps.0 = 0
  176. icmpOutAddrMasks.0 = 0
  177. icmpOutAddrMaskReps.0 = 0
  178.  
  179. RRD[[0;32mlast lg-testucp/netstats-icmp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  180. RRD[[0;32mupdate lg-testucp/netstats-icmp.rrd N:10885:10670:0:0:10670:0:0:10670:215:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  181. [[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]
  182. snmpInPkts.0 = 28914
  183. snmpOutPkts.0 = 28913
  184. snmpInBadVersions.0 = 0
  185. snmpInBadCommunityNames.0 = 0
  186. snmpInBadCommunityUses.0 = 0
  187. snmpInASNParseErrs.0 = 0
  188. snmpInTooBigs.0 = 0
  189. snmpInNoSuchNames.0 = 0
  190. snmpInBadValues.0 = 0
  191. snmpInReadOnlys.0 = 0
  192. snmpInGenErrs.0 = 0
  193. snmpInTotalReqVars.0 = 232207
  194. snmpInTotalSetVars.0 = 0
  195. snmpInGetRequests.0 = 8412
  196. snmpInGetNexts.0 = 0
  197. snmpInSetRequests.0 = 0
  198. snmpInGetResponses.0 = 0
  199. snmpInTraps.0 = 0
  200. snmpOutTooBigs.0 = 0
  201. snmpOutNoSuchNames.0 = 0
  202. snmpOutBadValues.0 = 0
  203. snmpOutGenErrs.0 = 0
  204. snmpOutGetRequests.0 = 0
  205. snmpOutGetNexts.0 = 0
  206. snmpOutSetRequests.0 = 0
  207. snmpOutGetResponses.0 = 28915
  208. snmpOutTraps.0 = 0
  209. snmpEnableAuthenTraps.0 = enabled
  210. snmpSilentDrops.0 = 0
  211. snmpProxyDrops.0 = 0
  212.  
  213. RRD[[0;32mlast lg-testucp/netstats-snmp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  214. RRD[[0;32mupdate lg-testucp/netstats-snmp.rrd N:28914:28913:0:0:0:0:0:0:0:0:0:232207:0:8412:0:0:0:0:0:0:0:0:0:0:0:28915:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  215. [[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]
  216. No Such Object available on this agent at this OID
  217.  
  218.  
  219.  
  220. >> Runtime for poller module 'netstats': 0.1150 seconds with 2800 bytes
  221. #### Unload poller module netstats ####
  222.  
  223. RRD[[0;32mlast lg-testucp/poller-perf-netstats.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  224. RRD[[0;32mupdate lg-testucp/poller-perf-netstats.rrd N:0.11499309539795 --daemon unix:/var/run/rrdcached.sock[0m]
  225. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  226. #### Load poller module hr-mib ####
  227. 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]
  228. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  229. hrSystemNumUsers.0 = No Such Object available on this agent at this OID
  230.  
  231.  
  232.  
  233. >> Runtime for poller module 'hr-mib': 0.0177 seconds with 11760 bytes
  234. #### Unload poller module hr-mib ####
  235.  
  236. RRD[[0;32mlast lg-testucp/poller-perf-hr-mib.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  237. RRD[[0;32mupdate lg-testucp/poller-perf-hr-mib.rrd N:0.017748117446899 --daemon unix:/var/run/rrdcached.sock[0m]
  238. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  239. #### Load poller module ucd-mib ####
  240. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 systemStats[0m]
  241. systemStats = No Such Object available on this agent at this OID
  242.  
  243. 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]
  244. memTotalSwap.0 = No Such Object available on this agent at this OID
  245. memAvailSwap.0 = No Such Object available on this agent at this OID
  246. memTotalReal.0 = No Such Object available on this agent at this OID
  247. memAvailReal.0 = No Such Object available on this agent at this OID
  248. memTotalFree.0 = No Such Object available on this agent at this OID
  249. memShared.0 = No Such Object available on this agent at this OID
  250. memBuffer.0 = No Such Object available on this agent at this OID
  251. memCached.0 = No Such Object available on this agent at this OID
  252.  
  253. 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]
  254. laLoadInt.1 = No Such Object available on this agent at this OID
  255. laLoadInt.2 = No Such Object available on this agent at this OID
  256. laLoadInt.3 = No Such Object available on this agent at this OID
  257.  
  258.  
  259. >> Runtime for poller module 'ucd-mib': 0.0469 seconds with 912 bytes
  260. #### Unload poller module ucd-mib ####
  261.  
  262. RRD[[0;32mlast lg-testucp/poller-perf-ucd-mib.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  263. RRD[[0;32mupdate lg-testucp/poller-perf-ucd-mib.rrd N:0.046940088272095 --daemon unix:/var/run/rrdcached.sock[0m]
  264. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  265. #### Load poller module ipSystemStats ####
  266. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ipSystemStats[0m]
  267. ipSystemStatsTable = No Such Object available on this agent at this OID
  268.  
  269.  
  270.  
  271. >> Runtime for poller module 'ipSystemStats': 0.0200 seconds with 760 bytes
  272. #### Unload poller module ipSystemStats ####
  273.  
  274. RRD[[0;32mlast lg-testucp/poller-perf-ipSystemStats.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  275. RRD[[0;32mupdate lg-testucp/poller-perf-ipSystemStats.rrd N:0.020015001296997 --daemon unix:/var/run/rrdcached.sock[0m]
  276. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  277. #### Load poller module ports ####
  278. Caching Oids: SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifXEntry[0m]
  279. ifName.1 = lo
  280. ifName.2 = eth1
  281. ifName.3 = eth0
  282. ifName.4 = eth2
  283. ifName.5 = gre0
  284. ifName.6 = sit0
  285. ifName.7 = ip6tnl0
  286. ifName.8 = ethipip6tnl0
  287. ifName.9 = ippp0
  288. ifInMulticastPkts.1 = 0
  289. ifInMulticastPkts.2 = 0
  290. ifInMulticastPkts.3 = 0
  291. ifInMulticastPkts.4 = 0
  292. ifInMulticastPkts.5 = 0
  293. ifInMulticastPkts.6 = 0
  294. ifInMulticastPkts.7 = 0
  295. ifInMulticastPkts.8 = 0
  296. ifInMulticastPkts.9 = 0
  297. ifInBroadcastPkts.1 = 0
  298. ifInBroadcastPkts.2 = 0
  299. ifInBroadcastPkts.3 = 0
  300. ifInBroadcastPkts.4 = 0
  301. ifInBroadcastPkts.5 = 0
  302. ifInBroadcastPkts.6 = 0
  303. ifInBroadcastPkts.7 = 0
  304. ifInBroadcastPkts.8 = 0
  305. ifInBroadcastPkts.9 = 0
  306. ifOutMulticastPkts.1 = 0
  307. ifOutMulticastPkts.2 = 0
  308. ifOutMulticastPkts.3 = 0
  309. ifOutMulticastPkts.4 = 0
  310. ifOutMulticastPkts.5 = 0
  311. ifOutMulticastPkts.6 = 0
  312. ifOutMulticastPkts.7 = 0
  313. ifOutMulticastPkts.8 = 0
  314. ifOutMulticastPkts.9 = 0
  315. ifOutBroadcastPkts.1 = 0
  316. ifOutBroadcastPkts.2 = 0
  317. ifOutBroadcastPkts.3 = 0
  318. ifOutBroadcastPkts.4 = 0
  319. ifOutBroadcastPkts.5 = 0
  320. ifOutBroadcastPkts.6 = 0
  321. ifOutBroadcastPkts.7 = 0
  322. ifOutBroadcastPkts.8 = 0
  323. ifOutBroadcastPkts.9 = 0
  324. ifHCInOctets.1 = 0
  325. ifHCInOctets.2 = 3200
  326. ifHCInOctets.3 = 32403999
  327. ifHCInOctets.4 = 0
  328. ifHCInOctets.5 = 0
  329. ifHCInOctets.6 = 0
  330. ifHCInOctets.7 = 0
  331. ifHCInOctets.8 = 0
  332. ifHCInOctets.9 = 0
  333. ifHCInUcastPkts.1 = 0
  334. ifHCInUcastPkts.2 = 119
  335. ifHCInUcastPkts.3 = 378580
  336. ifHCInUcastPkts.4 = 0
  337. ifHCInUcastPkts.5 = 0
  338. ifHCInUcastPkts.6 = 0
  339. ifHCInUcastPkts.7 = 0
  340. ifHCInUcastPkts.8 = 0
  341. ifHCInUcastPkts.9 = 0
  342. ifHCInMulticastPkts.1 = 0
  343. ifHCInMulticastPkts.2 = 0
  344. ifHCInMulticastPkts.3 = 0
  345. ifHCInMulticastPkts.4 = 0
  346. ifHCInMulticastPkts.5 = 0
  347. ifHCInMulticastPkts.6 = 0
  348. ifHCInMulticastPkts.7 = 0
  349. ifHCInMulticastPkts.8 = 0
  350. ifHCInMulticastPkts.9 = 0
  351. ifHCInBroadcastPkts.1 = 0
  352. ifHCInBroadcastPkts.2 = 0
  353. ifHCInBroadcastPkts.3 = 0
  354. ifHCInBroadcastPkts.4 = 0
  355. ifHCInBroadcastPkts.5 = 0
  356. ifHCInBroadcastPkts.6 = 0
  357. ifHCInBroadcastPkts.7 = 0
  358. ifHCInBroadcastPkts.8 = 0
  359. ifHCInBroadcastPkts.9 = 0
  360. ifHCOutOctets.1 = 0
  361. ifHCOutOctets.2 = 2504
  362. ifHCOutOctets.3 = 25776951
  363. ifHCOutOctets.4 = 0
  364. ifHCOutOctets.5 = 0
  365. ifHCOutOctets.6 = 0
  366. ifHCOutOctets.7 = 0
  367. ifHCOutOctets.8 = 0
  368. ifHCOutOctets.9 = 0
  369. ifHCOutUcastPkts.1 = 0
  370. ifHCOutUcastPkts.2 = 59
  371. ifHCOutUcastPkts.3 = 221197
  372. ifHCOutUcastPkts.4 = 0
  373. ifHCOutUcastPkts.5 = 0
  374. ifHCOutUcastPkts.6 = 0
  375. ifHCOutUcastPkts.7 = 0
  376. ifHCOutUcastPkts.8 = 0
  377. ifHCOutUcastPkts.9 = 0
  378. ifHCOutMulticastPkts.1 = 0
  379. ifHCOutMulticastPkts.2 = 0
  380. ifHCOutMulticastPkts.3 = 0
  381. ifHCOutMulticastPkts.4 = 0
  382. ifHCOutMulticastPkts.5 = 0
  383. ifHCOutMulticastPkts.6 = 0
  384. ifHCOutMulticastPkts.7 = 0
  385. ifHCOutMulticastPkts.8 = 0
  386. ifHCOutMulticastPkts.9 = 0
  387. ifHCOutBroadcastPkts.1 = 0
  388. ifHCOutBroadcastPkts.2 = 0
  389. ifHCOutBroadcastPkts.3 = 0
  390. ifHCOutBroadcastPkts.4 = 0
  391. ifHCOutBroadcastPkts.5 = 0
  392. ifHCOutBroadcastPkts.6 = 0
  393. ifHCOutBroadcastPkts.7 = 0
  394. ifHCOutBroadcastPkts.8 = 0
  395. ifHCOutBroadcastPkts.9 = 0
  396. ifHighSpeed.1 = 10
  397. ifHighSpeed.2 = 100
  398. ifHighSpeed.3 = 100
  399. ifHighSpeed.4 = 100
  400. ifHighSpeed.5 = 0
  401. ifHighSpeed.6 = 0
  402. ifHighSpeed.7 = 0
  403. ifHighSpeed.8 = 100
  404. ifHighSpeed.9 = 0
  405. ifPromiscuousMode.1 = false
  406. ifPromiscuousMode.2 = false
  407. ifPromiscuousMode.3 = false
  408. ifPromiscuousMode.4 = false
  409. ifPromiscuousMode.5 = false
  410. ifPromiscuousMode.6 = false
  411. ifPromiscuousMode.7 = false
  412. ifPromiscuousMode.8 = false
  413. ifPromiscuousMode.9 = false
  414. ifConnectorPresent.2 = true
  415. ifConnectorPresent.3 = true
  416. ifConnectorPresent.4 = true
  417. ifConnectorPresent.5 = true
  418. ifConnectorPresent.6 = true
  419. ifConnectorPresent.7 = true
  420. ifConnectorPresent.8 = true
  421. ifConnectorPresent.9 = true
  422. ifAlias.1 =
  423. ifAlias.2 =
  424. ifAlias.3 =
  425. ifAlias.4 =
  426. ifAlias.5 =
  427. ifAlias.6 =
  428. ifAlias.7 =
  429. ifAlias.8 =
  430. ifAlias.9 =
  431. ifCounterDiscontinuityTime.1 = 0:0:00:00.00
  432. ifCounterDiscontinuityTime.2 = 0:0:00:00.00
  433. ifCounterDiscontinuityTime.3 = 0:0:00:00.00
  434. ifCounterDiscontinuityTime.4 = 0:0:00:00.00
  435. ifCounterDiscontinuityTime.5 = 0:0:00:00.00
  436. ifCounterDiscontinuityTime.6 = 0:0:00:00.00
  437. ifCounterDiscontinuityTime.7 = 0:0:00:00.00
  438. ifCounterDiscontinuityTime.8 = 0:0:00:00.00
  439. ifCounterDiscontinuityTime.9 = 0:0:00:00.00
  440.  
  441. ifDescr SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifDescr[0m]
  442. ifDescr.1 = lo
  443. ifDescr.2 = eth1
  444. ifDescr.3 = eth0
  445. ifDescr.4 = eth2
  446. ifDescr.5 = gre0
  447. ifDescr.6 = sit0
  448. ifDescr.7 = ip6tnl0
  449. ifDescr.8 = ethipip6tnl0
  450. ifDescr.9 = ippp0
  451.  
  452. ifAdminStatus SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifAdminStatus[0m]
  453. ifAdminStatus.1 = up
  454. ifAdminStatus.2 = up
  455. ifAdminStatus.3 = up
  456. ifAdminStatus.4 = down
  457. ifAdminStatus.5 = down
  458. ifAdminStatus.6 = down
  459. ifAdminStatus.7 = down
  460. ifAdminStatus.8 = down
  461. ifAdminStatus.9 = up
  462.  
  463. ifOperStatus SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifOperStatus[0m]
  464. ifOperStatus.1 = up
  465. ifOperStatus.2 = up
  466. ifOperStatus.3 = up
  467. ifOperStatus.4 = down
  468. ifOperStatus.5 = down
  469. ifOperStatus.6 = down
  470. ifOperStatus.7 = down
  471. ifOperStatus.8 = down
  472. ifOperStatus.9 = down
  473.  
  474. ifLastChange SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifLastChange[0m]
  475. ifLastChange.1 = 0
  476. ifLastChange.2 = 0
  477. ifLastChange.3 = 0
  478. ifLastChange.4 = 0
  479. ifLastChange.5 = 0
  480. ifLastChange.6 = 0
  481. ifLastChange.7 = 0
  482. ifLastChange.8 = 0
  483. ifLastChange.9 = 0
  484.  
  485. ifType SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifType[0m]
  486. ifType.1 = softwareLoopback
  487. ifType.2 = ethernetCsmacd
  488. ifType.3 = ethernetCsmacd
  489. ifType.4 = ethernetCsmacd
  490. ifType.5 = tunnel
  491. ifType.6 = tunnel
  492. ifType.7 = tunnel
  493. ifType.8 = ethernetCsmacd
  494. ifType.9 = ppp
  495.  
  496. ifPhysAddress SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifPhysAddress[0m]
  497. ifPhysAddress.1 =
  498. ifPhysAddress.2 = 0:aa:bb:cc:dd:ee
  499. ifPhysAddress.3 = b0:61:c7:1:f9:66
  500. ifPhysAddress.4 = 0:40:5a:0:0:1
  501. ifPhysAddress.5 =
  502. ifPhysAddress.6 =
  503. ifPhysAddress.7 =
  504. ifPhysAddress.8 = 2:0:0:0:0:0
  505. ifPhysAddress.9 =
  506.  
  507. ifMtu SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifMtu[0m]
  508. ifMtu.1 = 16436
  509. ifMtu.2 = 1500
  510. ifMtu.3 = 1500
  511. ifMtu.4 = 1500
  512. ifMtu.5 = 1476
  513. ifMtu.6 = 1480
  514. ifMtu.7 = 1452
  515. ifMtu.8 = 1444
  516. ifMtu.9 = 1500
  517.  
  518. ifInErrors SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifInErrors[0m]
  519. ifInErrors.1 = 0
  520. ifInErrors.2 = 0
  521. ifInErrors.3 = 0
  522. ifInErrors.4 = 0
  523. ifInErrors.5 = 0
  524. ifInErrors.6 = 0
  525. ifInErrors.7 = 0
  526. ifInErrors.8 = 0
  527. ifInErrors.9 = 0
  528.  
  529. ifOutErrors SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifOutErrors[0m]
  530. ifOutErrors.1 = 0
  531. ifOutErrors.2 = 0
  532. ifOutErrors.3 = 0
  533. ifOutErrors.4 = 0
  534. ifOutErrors.5 = 0
  535. ifOutErrors.6 = 0
  536. ifOutErrors.7 = 0
  537. ifOutErrors.8 = 0
  538. ifOutErrors.9 = 0
  539.  
  540. ifInDiscards SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifInDiscards[0m]
  541. ifInDiscards.1 = 0
  542. ifInDiscards.2 = 0
  543. ifInDiscards.3 = 0
  544. ifInDiscards.4 = 0
  545. ifInDiscards.5 = 0
  546. ifInDiscards.6 = 0
  547. ifInDiscards.7 = 0
  548. ifInDiscards.8 = 0
  549. ifInDiscards.9 = 0
  550.  
  551. ifOutDiscards SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifOutDiscards[0m]
  552. ifOutDiscards.1 = 0
  553. ifOutDiscards.2 = 0
  554. ifOutDiscards.3 = 0
  555. ifOutDiscards.4 = 0
  556. ifOutDiscards.5 = 0
  557. ifOutDiscards.6 = 0
  558. ifOutDiscards.7 = 0
  559. ifOutDiscards.8 = 0
  560. ifOutDiscards.9 = 0
  561.  
  562. dot3StatsDuplexStatusSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot3StatsDuplexStatus[0m]
  563. dot3StatsDuplexStatus = No Such Object available on this agent at this OID
  564.  
  565. SQL[[0;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = '49' AND `ifType` = 'adsl'[0m]
  566. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1qPvid[0m]
  567. dot1qPvid = No Such Object available on this agent at this OID
  568.  
  569. Array
  570. (
  571.     [1] => Array
  572.         (
  573.             [ifName] => lo
  574.             [ifInMulticastPkts] => 0
  575.             [ifInBroadcastPkts] => 0
  576.             [ifOutMulticastPkts] => 0
  577.             [ifOutBroadcastPkts] => 0
  578.             [ifHCInOctets] => 0
  579.             [ifHCInUcastPkts] => 0
  580.             [ifHCInMulticastPkts] => 0
  581.             [ifHCInBroadcastPkts] => 0
  582.             [ifHCOutOctets] => 0
  583.             [ifHCOutUcastPkts] => 0
  584.             [ifHCOutMulticastPkts] => 0
  585.             [ifHCOutBroadcastPkts] => 0
  586.             [ifHighSpeed] => 10
  587.             [ifPromiscuousMode] => false
  588.             [ifAlias] =>
  589.             [ifCounterDiscontinuityTime] => 0:0:00:00.00
  590.             [ifDescr] => lo
  591.             [ifAdminStatus] => up
  592.             [ifOperStatus] => up
  593.             [ifLastChange] => 0
  594.             [ifType] => softwareLoopback
  595.             [ifPhysAddress] =>
  596.             [ifMtu] => 16436
  597.             [ifInErrors] => 0
  598.             [ifOutErrors] => 0
  599.             [ifInDiscards] => 0
  600.             [ifOutDiscards] => 0
  601.         )
  602.  
  603.     [2] => Array
  604.         (
  605.             [ifName] => eth1
  606.             [ifInMulticastPkts] => 0
  607.             [ifInBroadcastPkts] => 0
  608.             [ifOutMulticastPkts] => 0
  609.             [ifOutBroadcastPkts] => 0
  610.             [ifHCInOctets] => 3200
  611.             [ifHCInUcastPkts] => 119
  612.             [ifHCInMulticastPkts] => 0
  613.             [ifHCInBroadcastPkts] => 0
  614.             [ifHCOutOctets] => 2504
  615.             [ifHCOutUcastPkts] => 59
  616.             [ifHCOutMulticastPkts] => 0
  617.             [ifHCOutBroadcastPkts] => 0
  618.             [ifHighSpeed] => 100
  619.             [ifPromiscuousMode] => false
  620.             [ifConnectorPresent] => true
  621.             [ifAlias] =>
  622.             [ifCounterDiscontinuityTime] => 0:0:00:00.00
  623.             [ifDescr] => eth1
  624.             [ifAdminStatus] => up
  625.             [ifOperStatus] => up
  626.             [ifLastChange] => 0
  627.             [ifType] => ethernetCsmacd
  628.             [ifPhysAddress] => 0:aa:bb:cc:dd:ee
  629.             [ifMtu] => 1500
  630.             [ifInErrors] => 0
  631.             [ifOutErrors] => 0
  632.             [ifInDiscards] => 0
  633.             [ifOutDiscards] => 0
  634.         )
  635.  
  636.     [3] => Array
  637.         (
  638.             [ifName] => eth0
  639.             [ifInMulticastPkts] => 0
  640.             [ifInBroadcastPkts] => 0
  641.             [ifOutMulticastPkts] => 0
  642.             [ifOutBroadcastPkts] => 0
  643.             [ifHCInOctets] => 32403999
  644.             [ifHCInUcastPkts] => 378580
  645.             [ifHCInMulticastPkts] => 0
  646.             [ifHCInBroadcastPkts] => 0
  647.             [ifHCOutOctets] => 25776951
  648.             [ifHCOutUcastPkts] => 221197
  649.             [ifHCOutMulticastPkts] => 0
  650.             [ifHCOutBroadcastPkts] => 0
  651.             [ifHighSpeed] => 100
  652.             [ifPromiscuousMode] => false
  653.             [ifConnectorPresent] => true
  654.             [ifAlias] =>
  655.             [ifCounterDiscontinuityTime] => 0:0:00:00.00
  656.             [ifDescr] => eth0
  657.             [ifAdminStatus] => up
  658.             [ifOperStatus] => up
  659.             [ifLastChange] => 0
  660.             [ifType] => ethernetCsmacd
  661.             [ifPhysAddress] => b0:61:c7:1:f9:66
  662.             [ifMtu] => 1500
  663.             [ifInErrors] => 0
  664.             [ifOutErrors] => 0
  665.             [ifInDiscards] => 0
  666.             [ifOutDiscards] => 0
  667.         )
  668.  
  669.     [4] => Array
  670.         (
  671.             [ifName] => eth2
  672.             [ifInMulticastPkts] => 0
  673.             [ifInBroadcastPkts] => 0
  674.             [ifOutMulticastPkts] => 0
  675.             [ifOutBroadcastPkts] => 0
  676.             [ifHCInOctets] => 0
  677.             [ifHCInUcastPkts] => 0
  678.             [ifHCInMulticastPkts] => 0
  679.             [ifHCInBroadcastPkts] => 0
  680.             [ifHCOutOctets] => 0
  681.             [ifHCOutUcastPkts] => 0
  682.             [ifHCOutMulticastPkts] => 0
  683.             [ifHCOutBroadcastPkts] => 0
  684.             [ifHighSpeed] => 100
  685.             [ifPromiscuousMode] => false
  686.             [ifConnectorPresent] => true
  687.             [ifAlias] =>
  688.             [ifCounterDiscontinuityTime] => 0:0:00:00.00
  689.             [ifDescr] => eth2
  690.             [ifAdminStatus] => down
  691.             [ifOperStatus] => down
  692.             [ifLastChange] => 0
  693.             [ifType] => ethernetCsmacd
  694.             [ifPhysAddress] => 0:40:5a:0:0:1
  695.             [ifMtu] => 1500
  696.             [ifInErrors] => 0
  697.             [ifOutErrors] => 0
  698.             [ifInDiscards] => 0
  699.             [ifOutDiscards] => 0
  700.         )
  701.  
  702.     [5] => Array
  703.         (
  704.             [ifName] => gre0
  705.             [ifInMulticastPkts] => 0
  706.             [ifInBroadcastPkts] => 0
  707.             [ifOutMulticastPkts] => 0
  708.             [ifOutBroadcastPkts] => 0
  709.             [ifHCInOctets] => 0
  710.             [ifHCInUcastPkts] => 0
  711.             [ifHCInMulticastPkts] => 0
  712.             [ifHCInBroadcastPkts] => 0
  713.             [ifHCOutOctets] => 0
  714.             [ifHCOutUcastPkts] => 0
  715.             [ifHCOutMulticastPkts] => 0
  716.             [ifHCOutBroadcastPkts] => 0
  717.             [ifHighSpeed] => 0
  718.             [ifPromiscuousMode] => false
  719.             [ifConnectorPresent] => true
  720.             [ifAlias] =>
  721.             [ifCounterDiscontinuityTime] => 0:0:00:00.00
  722.             [ifDescr] => gre0
  723.             [ifAdminStatus] => down
  724.             [ifOperStatus] => down
  725.             [ifLastChange] => 0
  726.             [ifType] => tunnel
  727.             [ifPhysAddress] =>
  728.             [ifMtu] => 1476
  729.             [ifInErrors] => 0
  730.             [ifOutErrors] => 0
  731.             [ifInDiscards] => 0
  732.             [ifOutDiscards] => 0
  733.         )
  734.  
  735.     [6] => Array
  736.         (
  737.             [ifName] => sit0
  738.             [ifInMulticastPkts] => 0
  739.             [ifInBroadcastPkts] => 0
  740.             [ifOutMulticastPkts] => 0
  741.             [ifOutBroadcastPkts] => 0
  742.             [ifHCInOctets] => 0
  743.             [ifHCInUcastPkts] => 0
  744.             [ifHCInMulticastPkts] => 0
  745.             [ifHCInBroadcastPkts] => 0
  746.             [ifHCOutOctets] => 0
  747.             [ifHCOutUcastPkts] => 0
  748.             [ifHCOutMulticastPkts] => 0
  749.             [ifHCOutBroadcastPkts] => 0
  750.             [ifHighSpeed] => 0
  751.             [ifPromiscuousMode] => false
  752.             [ifConnectorPresent] => true
  753.             [ifAlias] =>
  754.             [ifCounterDiscontinuityTime] => 0:0:00:00.00
  755.             [ifDescr] => sit0
  756.             [ifAdminStatus] => down
  757.             [ifOperStatus] => down
  758.             [ifLastChange] => 0
  759.             [ifType] => tunnel
  760.             [ifPhysAddress] =>
  761.             [ifMtu] => 1480
  762.             [ifInErrors] => 0
  763.             [ifOutErrors] => 0
  764.             [ifInDiscards] => 0
  765.             [ifOutDiscards] => 0
  766.         )
  767.  
  768.     [7] => Array
  769.         (
  770.             [ifName] => ip6tnl0
  771.             [ifInMulticastPkts] => 0
  772.             [ifInBroadcastPkts] => 0
  773.             [ifOutMulticastPkts] => 0
  774.             [ifOutBroadcastPkts] => 0
  775.             [ifHCInOctets] => 0
  776.             [ifHCInUcastPkts] => 0
  777.             [ifHCInMulticastPkts] => 0
  778.             [ifHCInBroadcastPkts] => 0
  779.             [ifHCOutOctets] => 0
  780.             [ifHCOutUcastPkts] => 0
  781.             [ifHCOutMulticastPkts] => 0
  782.             [ifHCOutBroadcastPkts] => 0
  783.             [ifHighSpeed] => 0
  784.             [ifPromiscuousMode] => false
  785.             [ifConnectorPresent] => true
  786.             [ifAlias] =>
  787.             [ifCounterDiscontinuityTime] => 0:0:00:00.00
  788.             [ifDescr] => ip6tnl0
  789.             [ifAdminStatus] => down
  790.             [ifOperStatus] => down
  791.             [ifLastChange] => 0
  792.             [ifType] => tunnel
  793.             [ifPhysAddress] =>
  794.             [ifMtu] => 1452
  795.             [ifInErrors] => 0
  796.             [ifOutErrors] => 0
  797.             [ifInDiscards] => 0
  798.             [ifOutDiscards] => 0
  799.         )
  800.  
  801.     [8] => Array
  802.         (
  803.             [ifName] => ethipip6tnl0
  804.             [ifInMulticastPkts] => 0
  805.             [ifInBroadcastPkts] => 0
  806.             [ifOutMulticastPkts] => 0
  807.             [ifOutBroadcastPkts] => 0
  808.             [ifHCInOctets] => 0
  809.             [ifHCInUcastPkts] => 0
  810.             [ifHCInMulticastPkts] => 0
  811.             [ifHCInBroadcastPkts] => 0
  812.             [ifHCOutOctets] => 0
  813.             [ifHCOutUcastPkts] => 0
  814.             [ifHCOutMulticastPkts] => 0
  815.             [ifHCOutBroadcastPkts] => 0
  816.             [ifHighSpeed] => 100
  817.             [ifPromiscuousMode] => false
  818.             [ifConnectorPresent] => true
  819.             [ifAlias] =>
  820.             [ifCounterDiscontinuityTime] => 0:0:00:00.00
  821.             [ifDescr] => ethipip6tnl0
  822.             [ifAdminStatus] => down
  823.             [ifOperStatus] => down
  824.             [ifLastChange] => 0
  825.             [ifType] => ethernetCsmacd
  826.             [ifPhysAddress] => 2:0:0:0:0:0
  827.             [ifMtu] => 1444
  828.             [ifInErrors] => 0
  829.             [ifOutErrors] => 0
  830.             [ifInDiscards] => 0
  831.             [ifOutDiscards] => 0
  832.         )
  833.  
  834.     [9] => Array
  835.         (
  836.             [ifName] => ippp0
  837.             [ifInMulticastPkts] => 0
  838.             [ifInBroadcastPkts] => 0
  839.             [ifOutMulticastPkts] => 0
  840.             [ifOutBroadcastPkts] => 0
  841.             [ifHCInOctets] => 0
  842.             [ifHCInUcastPkts] => 0
  843.             [ifHCInMulticastPkts] => 0
  844.             [ifHCInBroadcastPkts] => 0
  845.             [ifHCOutOctets] => 0
  846.             [ifHCOutUcastPkts] => 0
  847.             [ifHCOutMulticastPkts] => 0
  848.             [ifHCOutBroadcastPkts] => 0
  849.             [ifHighSpeed] => 0
  850.             [ifPromiscuousMode] => false
  851.             [ifConnectorPresent] => true
  852.             [ifAlias] =>
  853.             [ifCounterDiscontinuityTime] => 0:0:00:00.00
  854.             [ifDescr] => ippp0
  855.             [ifAdminStatus] => up
  856.             [ifOperStatus] => down
  857.             [ifLastChange] => 0
  858.             [ifType] => ppp
  859.             [ifPhysAddress] =>
  860.             [ifMtu] => 1500
  861.             [ifInErrors] => 0
  862.             [ifOutErrors] => 0
  863.             [ifInDiscards] => 0
  864.             [ifOutDiscards] => 0
  865.         )
  866.  
  867. )
  868. SQL[[0;33mSELECT `name` FROM `port_association_mode` WHERE pom_id = '1'[0m]
  869. 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` = '49' ORDER BY ports.port_id[0m]
  870. validvalidvalidvalidvalidvalidvalidvalidvalid
  871. Port lo: lo (1 / #829)  disabled.
  872. Port eth1: eth1 (2 / #830) HC HC HighSpeed VLAN == Using ifDescr as ifAliaseth1
  873.  ifInOctets (0 B) 0 Bps 200 secs
  874.  
  875.  ifOutOctets (0 B) 0 Bps 200 secs
  876.  
  877.  ifInErrors (0 B) 0 Bps 200 secs
  878.  
  879.  ifOutErrors (0 B) 0 Bps 200 secs
  880.  
  881.  ifInUcastPkts (0 B) 0 Bps 200 secs
  882.  
  883.  ifOutUcastPkts (0 B) 0 Bps 200 secs
  884.  
  885.  ifInNUcastPkts (0 B) 0 Bps 200 secs
  886.  
  887.  ifOutNUcastPkts (0 B) 0 Bps 200 secs
  888.  
  889.  ifInDiscards (0 B) 0 Bps 200 secs
  890.  
  891.  ifOutDiscards (0 B) 0 Bps 200 secs
  892.  
  893.  ifInUnknownProtos (0 B) 0 Bps 200 secs
  894.  
  895.  ifInBroadcastPkts (0 B) 0 Bps 200 secs
  896.  
  897.  ifOutBroadcastPkts (0 B) 0 Bps 200 secs
  898.  
  899.  ifInMulticastPkts (0 B) 0 Bps 200 secs
  900.  
  901.  ifOutMulticastPkts (0 B) 0 Bps 200 secs
  902. bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[[0;32mlast lg-testucp/port-id830.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  903. RRD[[0;32mupdate lg-testucp/port-id830.rrd N:3200:2504:0:0:119:59:U:U:0:0:U:0:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  904. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `ports` set `poll_time` ='1492671658',`poll_prev` ='1492671458',`poll_period` ='200',`ifLastChange` ='0',`ifInOctets` ='3200',`ifInOctets_prev` ='3200',`ifInOctets_rate` ='0',`ifInOctets_delta` ='0',`ifOutOctets` ='2504',`ifOutOctets_prev` ='2504',`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` ='119',`ifInUcastPkts_prev` ='119',`ifInUcastPkts_rate` ='0',`ifInUcastPkts_delta` ='0',`ifOutUcastPkts` ='59',`ifOutUcastPkts_prev` ='59',`ifOutUcastPkts_rate` ='0',`ifOutUcastPkts_delta` ='0' WHERE `port_id` = '830'[0m]
  905. 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` = '830'[0m]
  906. 1 updated
  907. Port eth0: eth0 (3 / #831) HC HC HighSpeed VLAN == Using ifDescr as ifAliaseth0
  908.  ifInOctets (83987 B) 419.935 Bps 200 secs
  909.  
  910.  ifOutOctets (56163 B) 280.815 Bps 200 secs
  911.  
  912.  ifInErrors (0 B) 0 Bps 200 secs
  913.  
  914.  ifOutErrors (0 B) 0 Bps 200 secs
  915.  
  916.  ifInUcastPkts (1145 B) 5.725 Bps 200 secs
  917.  
  918.  ifOutUcastPkts (384 B) 1.92 Bps 200 secs
  919.  
  920.  ifInNUcastPkts (0 B) 0 Bps 200 secs
  921.  
  922.  ifOutNUcastPkts (0 B) 0 Bps 200 secs
  923.  
  924.  ifInDiscards (0 B) 0 Bps 200 secs
  925.  
  926.  ifOutDiscards (0 B) 0 Bps 200 secs
  927.  
  928.  ifInUnknownProtos (0 B) 0 Bps 200 secs
  929.  
  930.  ifInBroadcastPkts (0 B) 0 Bps 200 secs
  931.  
  932.  ifOutBroadcastPkts (0 B) 0 Bps 200 secs
  933.  
  934.  ifInMulticastPkts (0 B) 0 Bps 200 secs
  935.  
  936.  ifOutMulticastPkts (0 B) 0 Bps 200 secs
  937. bps(3.360kbps/2.250kbps)bytes(82.020kB/54.850kB)pkts(5.730pps/1.920pps)RRD[[0;32mlast lg-testucp/port-id831.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  938. RRD[[0;32mupdate lg-testucp/port-id831.rrd N:32403999:25776951:0:0:378580:221197:U:U:0:0:U:0:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  939. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `ports` set `poll_time` ='1492671658',`poll_prev` ='1492671458',`poll_period` ='200',`ifLastChange` ='0',`ifInOctets` ='32403999',`ifInOctets_prev` ='32320012',`ifInOctets_rate` ='419.935',`ifInOctets_delta` ='83987',`ifOutOctets` ='25776951',`ifOutOctets_prev` ='25720788',`ifOutOctets_rate` ='280.815',`ifOutOctets_delta` ='56163',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='378580',`ifInUcastPkts_prev` ='377435',`ifInUcastPkts_rate` ='5.725',`ifInUcastPkts_delta` ='1145',`ifOutUcastPkts` ='221197',`ifOutUcastPkts_prev` ='220813',`ifOutUcastPkts_rate` ='1.92',`ifOutUcastPkts_delta` ='384' WHERE `port_id` = '831'[0m]
  940. 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` = '831'[0m]
  941. 1 updated
  942. Port eth2: eth2 (4 / #832)  disabled.
  943. Port gre0: gre0 (5 / #833)  disabled.
  944. Port sit0: sit0 (6 / #834)  disabled.
  945. Port ip6tnl0: ip6tnl0 (7 / #835)  disabled.
  946. Port ethipip6tnl0: ethipip6tnl0 (8 / #836)  disabled.
  947. Port ippp0: ippp0 (9 / #837)  disabled.
  948.  
  949. >> Runtime for poller module 'ports': 0.2790 seconds with 53672 bytes
  950. #### Unload poller module ports ####
  951.  
  952. RRD[[0;32mlast lg-testucp/poller-perf-ports.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  953. RRD[[0;32mupdate lg-testucp/poller-perf-ports.rrd N:0.27897906303406 --daemon unix:/var/run/rrdcached.sock[0m]
  954. [[0;31mRRD Disabled[0m]Modules status: Global- OS  Device  Module [ bgp-peers ] disabled globally.
  955.  
  956. Modules status: Global- OS  Device  Module [ junose-atm-vp ] disabled globally.
  957.  
  958. Modules status: Global- OS  Device  Module [ toner ] disabled globally.
  959.  
  960. Modules status: Global+ OS  Device  
  961. #### Load poller module ucd-diskio ####
  962. SQL[[0;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = '49'[0m]
  963.  
  964. >> Runtime for poller module 'ucd-diskio': 0.0004 seconds with -472 bytes
  965. #### Unload poller module ucd-diskio ####
  966.  
  967. RRD[[0;32mlast lg-testucp/poller-perf-ucd-diskio.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  968. RRD[[0;32mupdate lg-testucp/poller-perf-ucd-diskio.rrd N:0.00042295455932617 --daemon unix:/var/run/rrdcached.sock[0m]
  969. [[0;31mRRD Disabled[0m]Modules status: Global- OS  Device  Module [ wifi ] disabled globally.
  970.  
  971. Modules status: Global- OS  Device  Module [ ospf ] disabled globally.
  972.  
  973. Modules status: Global- OS  Device  Module [ cisco-ipsec-flow-monitor ] disabled globally.
  974.  
  975. Modules status: Global- OS  Device  Module [ cisco-remote-access-monitor ] disabled globally.
  976.  
  977. Modules status: Global- OS  Device  Module [ cisco-cef ] disabled globally.
  978.  
  979. Modules status: Global- OS  Device  Module [ cisco-sla ] disabled globally.
  980.  
  981. Modules status: Global- OS  Device  Module [ cisco-mac-accounting ] disabled globally.
  982.  
  983. Modules status: Global- OS  Device  Module [ cipsec-tunnels ] disabled globally.
  984.  
  985. Modules status: Global- OS  Device  Module [ cisco-ace-loadbalancer ] disabled globally.
  986.  
  987. Modules status: Global- OS  Device  Module [ cisco-ace-serverfarms ] disabled globally.
  988.  
  989. Modules status: Global- OS  Device  Module [ cisco-asa-firewall ] disabled globally.
  990.  
  991. Modules status: Global- OS  Device  Module [ cisco-voice ] disabled globally.
  992.  
  993. Modules status: Global- OS  Device  Module [ cisco-cbqos ] disabled globally.
  994.  
  995. Modules status: Global- OS  Device  Module [ cisco-otv ] disabled globally.
  996.  
  997. Modules status: Global- OS  Device  Module [ cisco-vpdn ] disabled globally.
  998.  
  999. Modules status: Global- OS  Device  Module [ netscaler-vsvr ] disabled globally.
  1000.  
  1001. Modules status: Global- OS  Device  Module [ aruba-controller ] disabled globally.
  1002.  
  1003. Modules status: Global- OS  Device  Module [ entity-physical ] disabled globally.
  1004.  
  1005. Modules status: Global+ OS  Device  
  1006. #### Load poller module applications ####
  1007. SQL[[0;33mSELECT * FROM `applications` WHERE `device_id`  = '49'[0m]
  1008.  
  1009. >> Runtime for poller module 'applications': 0.0004 seconds with 384 bytes
  1010. #### Unload poller module applications ####
  1011.  
  1012. RRD[[0;32mlast lg-testucp/poller-perf-applications.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  1013. RRD[[0;32mupdate lg-testucp/poller-perf-applications.rrd N:0.0004122257232666 --daemon unix:/var/run/rrdcached.sock[0m]
  1014. [[0;31mRRD Disabled[0m]Modules status: Global- OS  Device  Module [ mib ] disabled globally.
  1015.  
  1016. Modules status: Global+ OS  Device  
  1017. #### Load poller module stp ####
  1018. SQL[[0;33mSELECT * FROM `stp` WHERE `device_id` = '49'[0m]
  1019. SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1dStpProtocolSpecification.0[0m]
  1020. No Such Object available on this agent at this OID
  1021.  
  1022.  
  1023.  
  1024. >> Runtime for poller module 'stp': 0.0158 seconds with -11024 bytes
  1025. #### Unload poller module stp ####
  1026.  
  1027. RRD[[0;32mlast lg-testucp/poller-perf-stp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  1028. RRD[[0;32mupdate lg-testucp/poller-perf-stp.rrd N:0.01581597328186 --daemon unix:/var/run/rrdcached.sock[0m]
  1029. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  1030. #### Load poller module ntp ####
  1031.  
  1032. >> Runtime for poller module 'ntp': 0.0001 seconds with 192 bytes
  1033. #### Unload poller module ntp ####
  1034.  
  1035. RRD[[0;32mlast lg-testucp/poller-perf-ntp.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  1036. RRD[[0;32mupdate lg-testucp/poller-perf-ntp.rrd N:0.00010800361633301 --daemon unix:/var/run/rrdcached.sock[0m]
  1037. [[0;31mRRD Disabled[0m]Modules status: Global+ OS  Device  
  1038. #### Load poller module services ####
  1039.  
  1040. >> Runtime for poller module 'services': 0.0000 seconds with 104 bytes
  1041. #### Unload poller module services ####
  1042.  
  1043. RRD[[0;32mlast lg-testucp/poller-perf-services.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  1044. RRD[[0;32mupdate lg-testucp/poller-perf-services.rrd N:4.1961669921875E-5 --daemon unix:/var/run/rrdcached.sock[0m]
  1045. [[0;31mRRD Disabled[0m]Modules status: Global- OS  Device  Module [ loadbalancers ] disabled globally.
  1046.  
  1047. Modules status: Global- OS  Device  Module [ mef ] disabled globally.
  1048.  
  1049. Modules status: Global- OS  Device  Module [ tnms-nbi ] disabled globally.
  1050.  
  1051. ### Start Device Groups ###
  1052. SQL[[0;33mSELECT * FROM device_groups ORDER BY name[0m]
  1053. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysName REGEXP "affinity" ) LIMIT 1[0m]
  1054. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysDescr REGEXP "Ethernet Routing Switch" ) LIMIT 1[0m]
  1055. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.hostname REGEXP "^esr-" ) LIMIT 1[0m]
  1056. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysName REGEXP "^nt-harlow" ) LIMIT 1[0m]
  1057. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysName REGEXP "^hb-"  ) LIMIT 1[0m]
  1058. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysDescr REGEXP "^IP 500") LIMIT 1[0m]
  1059. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.os REGEXP "Linux" ) LIMIT 1[0m]
  1060. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysDescr REGEXP "nt-netmon" || devices.sysDescr REGEXP "nt-network-monitor" ) LIMIT 1[0m]
  1061. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysObjectID REGEXP "enterprises.6889.1.69.5.1") LIMIT 1[0m]
  1062. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.location REGEXP "^NT Office") LIMIT 1[0m]
  1063. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysName REGEXP "^nt-" && devices.sysName REGEXP "-gw." ) LIMIT 1[0m]
  1064. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysName REGEXP "^nt-" && devices.sysName REGEXP "-sw." ) LIMIT 1[0m]
  1065. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysName REGEXP "^nt-pearcesign" ) LIMIT 1[0m]
  1066. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysObjectID REGEXP "enterprises.14988.1") LIMIT 1[0m]
  1067. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysName REGEXP "^nt-sorby" ) LIMIT 1[0m]
  1068. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='49' AND (devices.sysObjectID REGEXP "^enterprises.10002" ) LIMIT 1[0m]
  1069. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='49'[0m]
  1070. Groups Added:
  1071. Groups Removed:
  1072. ### End Device Groups ###
  1073. SQL[[0;33mSELECT `graph` FROM `device_graphs` WHERE `device_id` = '49'[0m]
  1074. uptime netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt RRD[[0;32mlast lg-testucp/poller-perf.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  1075. RRD[[0;32mupdate lg-testucp/poller-perf.rrd N:1.239 --daemon unix:/var/run/rrdcached.sock[0m]
  1076. [[0;31mRRD Disabled[0m]RRD[[0;32mlast lg-testucp/ping-perf.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  1077. RRD[[0;32mupdate lg-testucp/ping-perf.rrd N:0.67 --daemon unix:/var/run/rrdcached.sock[0m]
  1078. [[0;31mRRD Disabled[0m]Polled in 1.239 seconds
  1079. Updating lg-testucp
  1080. SQL[[0;33mUPDATE `devices` set `uptime` ='157106',`last_ping` =NOW(),`last_ping_timetaken` ='0.67',`last_polled` =NOW(),`last_polled_timetaken` ='1.239' WHERE `device_id` = '49'[0m]
  1081. UPDATED!
  1082. #### Start Alerts ####
  1083. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='49'[0m]
  1084. 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 = '49' ) && ((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]
  1085. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='49'[0m]
  1086. 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 = '49' ) || alert_map.target = '49'  )[0m]
  1087. Rule [0;35m#1 (Devices up/down):[0m
  1088. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '1' && device_id = '49' ORDER BY id DESC LIMIT 1[0m]
  1089. SQL[[0;33mSELECT * FROM devices WHERE (devices.device_id = '49') && ( (  ( devices.status = 0  &&   (  ( devices.disabled = 0  &&  devices.ignore = 0 )  )  )  )  = "1"    )[0m]
  1090. Status: [0;34mNOCHG[0m
  1091. Rule [0;35m#2 (Device rebooted):[0m
  1092. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '2' && device_id = '49' ORDER BY id DESC LIMIT 1[0m]
  1093. SQL[[0;33mSELECT * FROM devices WHERE (devices.device_id = '49') && (devices.uptime < "300"  &&   (  ( devices.disabled = 0  &&  devices.ignore = 0 )  )  = "1")[0m]
  1094. Status: [0;34mNOCHG[0m
  1095. Rule [0;35m#5 (Port status up/down):[0m
  1096. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '5' && device_id = '49' ORDER BY id DESC LIMIT 1[0m]
  1097. SQL[[0;33mSELECT * FROM ports WHERE (ports.device_id = '49') && ( (  ( ports.ifOperStatus = "down"  &&  ports.ifAdminStatus != "down"  &&   (  ( ports.deleted = 0  &&  ports.ignore = 0  &&  ports.disabled = 0 )  )  )  )  = "1")[0m]
  1098. Status: [0;34mNOCHG[0m
  1099. Rule [0;35m#6 (Port utilisation over threshold):[0m
  1100. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '6' && device_id = '49' ORDER BY id DESC LIMIT 1[0m]
  1101. SQL[[0;33mSELECT * FROM ports WHERE (ports.device_id = '49') && ( (  ( 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]
  1102. Status: [0;34mNOCHG[0m
  1103. Rule [0;35m#12 (Authentication failure):[0m
  1104. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '12' && device_id = '49' ORDER BY id DESC LIMIT 1[0m]
  1105. SQL[[0;33mSELECT * FROM syslog WHERE (syslog.device_id = '49') && (syslog.timestamp >=  ( DATE_SUB( NOW() ,INTERVAL 5 MINUTE )  )   &&  syslog.msg REGEXP ".*failed.*"    &&  syslog.program REGEXP ".*TRP|LOGON.*"   )[0m]
  1106. Status: [0;34mNOCHG[0m
  1107. Rule [0;35m#15 (IPSec tunnels down):[0m
  1108. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '15' && device_id = '49' ORDER BY id DESC LIMIT 1[0m]
  1109. SQL[[0;33mSELECT * FROM ipsec_tunnels,devices WHERE (( devices.device_id = ipsec_tunnels.device_id ) && ipsec_tunnels.device_id = '49') && (ipsec_tunnels.tunnel_status != "active"  &&   (  ( devices.status = 1  &&   (  ( devices.disabled = 0  &&  devices.ignore = 0 )  )  )  )  = "1"  )[0m]
  1110. Status: [0;34mNOCHG[0m
  1111. Rule [0;35m#16 (packet loss over 10%in last 5m):[0m
  1112. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '16' && device_id = '49' ORDER BY id DESC LIMIT 1[0m]
  1113. SQL[[0;33mSELECT * FROM device_perf,devices WHERE (( devices.device_id = device_perf.device_id ) && device_perf.device_id = '49') && ( (  (  ( DATE_SUB( NOW() ,INTERVAL 5 MINUTE )  )   &&  device_perf.loss )  )  >= "10"    &&   (  ( devices.status = 1  &&   (  ( devices.disabled = 0  &&  devices.ignore = 0 )  )  )  )  = "1"   )[0m]
  1114. Status: [0;34mNOCHG[0m
  1115. #### End Alerts ####
  1116. SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','lg-testucp','1492671657.0937','1.286','1','librenms
  1117. ')[0m]
  1118. ./poller.php lg-testucp 2017-04-20 08:00:58 - 1 devices polled in 1.286 secs
  1119. SNMP: Get[12/0.19s] Walk [18/0.34s]
  1120. MySQL: Cell[20/0.01s] Row[10/0.00s] Rows[22/0.01s] Column[3/0.00s] Update[5/0.00s] Insert[2/0.00s] Delete[0/0.00s]
  1121.