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