Untitled

From qubic, 5 Years ago, written in Plain Text.
URL https://p.libren.ms/view/ff7d02d7
Embed
Download Paste or View Raw
  1. LibreNMS Poller
  2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.34ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 2.29ms]
  5.  
  6. SQL[[1;33mSELECT version() [0;33m[][0m 0.27ms]
  7.  
  8. ===================================
  9. Version info:
  10. Commit SHA: 21192a9cf2a3226e1a06bf69e5688242c5903dfa
  11. Commit Date: 1549635449
  12. DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
  13. PHP: 7.0.33-0ubuntu0.16.04.1
  14. MySQL: 10.0.38-MariaDB-0ubuntu0.16.04.1
  15. RRDTool: 1.5.5
  16. SNMP: NET-SNMP 5.7.3
  17. ==================================DEBUG!
  18. Updating os_def.cache...  
  19. Done  
  20. Starting polling run:
  21.  
  22. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.0.121' ORDER BY `device_id` ASC [0;33m[][0m 0.79ms]
  23.  
  24. SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[259][0m 0.28ms]
  25.  
  26. Hostname: 192.168.0.121
  27. Device ID: 259
  28. OS: drac
  29. Warning: inet_pton(): Unrecognized address  in /opt/librenms/includes/polling/functions.inc.php on line 249
  30.  
  31.  
  32. [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 192.168.0.121  
  33. array (
  34.   'xmt' => '3',
  35.   'rcv' => '3',
  36.   'loss' => '0',
  37.   'min' => '1.85',
  38.   'max' => '2.67',
  39.   'avg' => '2.39',
  40.   'exitcode' => 0,
  41. )  
  42. SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`)  VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) [0;33m{"xmt":"3","rcv":"3","loss":"0","min":"1.85","max":"2.67","avg":"2.39","device_id":259,"debug":"[]"}[0m 7.96ms]
  43.  
  44. SNMP Check response code: 0  
  45. Modules status: Global+  
  46. OS  
  47. Device  
  48.  
  49. #### Load poller module core ####
  50. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
  51. .*.*.0 = 1195575405
  52. .*.*.0 = Unknown
  53. .*.*.0 = root@
  54. .*.*.0 = iDRAC-DPJ115J
  55. .*.*.0 = .*.4.1.674.10892.2
  56. .*.*.0 = Linux iDRAC-DPJ115J 2.6.24-ami #1 Wed Jul 12 15:31:56 UTC 2017 armv5tejl  
  57.  
  58. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m]
  59. snmpEngineTime.0 = 11961771
  60. hrSystemUptime.0 = No Such Object available on this agent at this OID  
  61.  
  62. Uptime seconds: 11961771  
  63. RRD[[0;32mupdate 192.168.0.121/uptime.rrd N:11961771 --daemon unix:/var/run/rrdcached.sock[0m]
  64. [[0;31mRRD Disabled[0m]Uptime: 138 days, 10h 42m 51s
  65. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[227][0m 0.55ms]
  66.  
  67.  
  68. >> Runtime for poller module 'core': 0.0261 seconds with 45576 bytes
  69. >> SNMP: [2/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
  70. #### Unload poller module core ####
  71.  
  72. RRD[[0;32mupdate 192.168.0.121/poller-perf-core.rrd N:0.026050090789795 --daemon unix:/var/run/rrdcached.sock[0m]
  73. [[0;31mRRD Disabled[0m]Modules status: Global+  
  74. OS  
  75. Device  
  76.  
  77. #### Load poller module unix-agent ####
  78.  
  79. >> Runtime for poller module 'unix-agent': 0.0004 seconds with 8256 bytes
  80. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  81. #### Unload poller module unix-agent ####
  82.  
  83. RRD[[0;32mupdate 192.168.0.121/poller-perf-unix-agent.rrd N:0.00041985511779785 --daemon unix:/var/run/rrdcached.sock[0m]
  84. [[0;31mRRD Disabled[0m]Modules status: Global+  
  85. OS  
  86. Device  
  87.  
  88. #### Load poller module os ####
  89. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.674.10892.2.1.2.1.0'[0m]
  90. "3.85.03"  
  91.  
  92. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.674.10892.2.1.1.2.0'[0m]
  93. "iDRAC"  
  94.  
  95. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.674.10892.2.1.1.11.0'[0m]
  96. "DPJ115J"  
  97.  
  98. Hardware: iDRAC
  99. Version: 3.85.03
  100. Features:
  101. Serial: DPJ115J
  102.  
  103. >> Runtime for poller module 'os': 0.0261 seconds with 2024 bytes
  104. >> SNMP: [3/0.03s] MySQL: [0/0.00s] RRD: [0/0.00s]
  105. #### Unload poller module os ####
  106.  
  107. RRD[[0;32mupdate 192.168.0.121/poller-perf-os.rrd N:0.026082038879395 --daemon unix:/var/run/rrdcached.sock[0m]
  108. [[0;31mRRD Disabled[0m]Modules status: Global+  
  109. OS  
  110. Device  
  111.  
  112. #### Load poller module ipmi ####
  113. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[259][0m 0.49ms]
  114.  
  115. array (
  116. )  
  117.  
  118. >> Runtime for poller module 'ipmi': 0.0010 seconds with 2552 bytes
  119. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  120. #### Unload poller module ipmi ####
  121.  
  122. RRD[[0;32mupdate 192.168.0.121/poller-perf-ipmi.rrd N:0.00095510482788086 --daemon unix:/var/run/rrdcached.sock[0m]
  123. [[0;31mRRD Disabled[0m]Modules status: Global+  
  124. OS  
  125. Device  
  126.  
  127. #### Load poller module sensors ####
  128. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[259][0m 0.41ms]
  129.  
  130. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["state",259][0m 0.4ms]
  131.  
  132. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.674.10892.2.2.1.0'[0m]
  133. .*.4.1.674.108*.0 = 3  
  134.  
  135. Checking (snmp) state Global System Status...
  136. 3
  137. RRD[[0;32mupdate 192.168.0.121/sensor-state-drsGlobalSystemStatus-drsGlobalSystemStatus.0.rrd N:3 --daemon unix:/var/run/rrdcached.sock[0m]
  138. [[0;31mRRD Disabled[0m]
  139. >> Runtime for poller module 'sensors': 0.0094 seconds with 2680 bytes
  140. >> SNMP: [1/0.01s] MySQL: [2/0.00s] RRD: [0/0.00s]
  141. #### Unload poller module sensors ####
  142.  
  143. RRD[[0;32mupdate 192.168.0.121/poller-perf-sensors.rrd N:0.0094411373138428 --daemon unix:/var/run/rrdcached.sock[0m]
  144. [[0;31mRRD Disabled[0m]Modules status: Global+  
  145. OS  
  146. Device  
  147.  
  148. #### Load poller module processors ####
  149. Attempting to initialize OS: drac  
  150. OS initialized as Generic  
  151. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[259][0m 0.57ms]
  152.  
  153.  
  154. >> Runtime for poller module 'processors': 0.0023 seconds with 91392 bytes
  155. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  156. #### Unload poller module processors ####
  157.  
  158. RRD[[0;32mupdate 192.168.0.121/poller-perf-processors.rrd N:0.0022721290588379 --daemon unix:/var/run/rrdcached.sock[0m]
  159. [[0;31mRRD Disabled[0m]Modules status: Global+  
  160. OS  
  161. Device  
  162.  
  163. #### Load poller module mempools ####
  164. SQL[[1;33mSELECT * FROM mempools WHERE device_id = ? [0;33m[259][0m 0.35ms]
  165.  
  166.  
  167. >> Runtime for poller module 'mempools': 0.0006 seconds with 1720 bytes
  168. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  169. #### Unload poller module mempools ####
  170.  
  171. RRD[[0;32mupdate 192.168.0.121/poller-perf-mempools.rrd N:0.00063014030456543 --daemon unix:/var/run/rrdcached.sock[0m]
  172. [[0;31mRRD Disabled[0m]Modules status: Global+  
  173. OS  
  174. Device  
  175.  
  176. #### Load poller module storage ####
  177. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[259][0m 0.33ms]
  178.  
  179.  
  180. >> Runtime for poller module 'storage': 0.0006 seconds with 1704 bytes
  181. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  182. #### Unload poller module storage ####
  183.  
  184. RRD[[0;32mupdate 192.168.0.121/poller-perf-storage.rrd N:0.00055193901062012 --daemon unix:/var/run/rrdcached.sock[0m]
  185. [[0;31mRRD Disabled[0m]Modules status: Global+  
  186. OS  
  187. Device  
  188.  
  189. #### Load poller module netstats ####
  190.  ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'icmp'[0m]
  191. icmp = No Such Object available on this agent at this OID  
  192.  
  193.  IPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' '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]
  194.  
  195. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  196.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
  197. No Such Object available on this agent at this OID  
  198.  
  199.  SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'snmp'[0m]
  200. snmpInPkts.0 = 3635450
  201. snmpOutPkts.0 = 3635431
  202. snmpInBadVersions.0 = 0
  203. snmpInBadCommunityNames.0 = 18
  204. snmpInBadCommunityUses.0 = 0
  205. snmpInASNParseErrs.0 = 0
  206. snmpInTooBigs.0 = 0
  207. snmpInNoSuchNames.0 = 0
  208. snmpInBadValues.0 = 0
  209. snmpInReadOnlys.0 = 0
  210. snmpInGenErrs.0 = 0
  211. snmpInTotalReqVars.0 = 20194336
  212. snmpInTotalSetVars.0 = 0
  213. snmpInGetRequests.0 = 2498085
  214. snmpInGetNexts.0 = 521
  215. snmpInSetRequests.0 = 0
  216. snmpInGetResponses.0 = 0
  217. snmpInTraps.0 = 0
  218. snmpOutTooBigs.0 = 0
  219. snmpOutNoSuchNames.0 = 0
  220. snmpOutBadValues.0 = 0
  221. snmpOutGenErrs.0 = 0
  222. snmpOutGetRequests.0 = 0
  223. snmpOutGetNexts.0 = 0
  224. snmpOutSetRequests.0 = 0
  225. snmpOutGetResponses.0 = 3635433
  226. snmpOutTraps.0 = 0
  227. snmpEnableAuthenTraps.0 = disabled
  228. snmpSilentDrops.0 = 0
  229. snmpProxyDrops.0 = 0  
  230.  
  231. RRD[[0;32mupdate 192.168.0.121/netstats-snmp.rrd N:3635450:3635431:0:18:0:0:0:0:0:0:0:20194336:0:2498085:521:0:0:0:0:0:0:0:0:0:0:3635433:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  232. [[0;31mRRD Disabled[0m] TCPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' '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]
  233.  
  234. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  235.  UDPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]
  236.  
  237. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  238.  
  239.  
  240. >> Runtime for poller module 'netstats': 0.0983 seconds with 3528 bytes
  241. >> SNMP: [6/0.10s] MySQL: [0/0.00s] RRD: [0/0.00s]
  242. #### Unload poller module netstats ####
  243.  
  244. RRD[[0;32mupdate 192.168.0.121/poller-perf-netstats.rrd N:0.098346948623657 --daemon unix:/var/run/rrdcached.sock[0m]
  245. [[0;31mRRD Disabled[0m]Modules status: Global+  
  246. OS  
  247. Device  
  248.  
  249. #### Load poller module hr-mib ####
  250. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  251. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  252. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  253.  
  254.  
  255.  
  256. >> Runtime for poller module 'hr-mib': 0.0180 seconds with 1472 bytes
  257. >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
  258. #### Unload poller module hr-mib ####
  259.  
  260. RRD[[0;32mupdate 192.168.0.121/poller-perf-hr-mib.rrd N:0.017960071563721 --daemon unix:/var/run/rrdcached.sock[0m]
  261. [[0;31mRRD Disabled[0m]Modules status: Global+  
  262. OS  
  263. Device  
  264.  
  265. #### Load poller module ucd-mib ####
  266. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'systemStats'[0m]
  267. systemStats = No Such Object available on this agent at this OID  
  268.  
  269. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'memTotalSwap.0' 'memAvailSwap.0' 'memTotalReal.0' 'memAvailReal.0' 'memTotalFree.0' 'memShared.0' 'memBuffer.0' 'memCached.0'[0m]
  270. memTotalSwap.0 = No Such Object available on this agent at this OID
  271. memAvailSwap.0 = No Such Object available on this agent at this OID
  272. memTotalReal.0 = No Such Object available on this agent at this OID
  273. memAvailReal.0 = No Such Object available on this agent at this OID
  274. memTotalFree.0 = No Such Object available on this agent at this OID
  275. memShared.0 = No Such Object available on this agent at this OID
  276. memBuffer.0 = No Such Object available on this agent at this OID
  277. memCached.0 = No Such Object available on this agent at this OID  
  278.  
  279. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  280. laLoadInt.1 = No Such Object available on this agent at this OID
  281. laLoadInt.2 = No Such Object available on this agent at this OID
  282. laLoadInt.3 = No Such Object available on this agent at this OID  
  283.  
  284.  
  285. >> Runtime for poller module 'ucd-mib': 0.0348 seconds with 2496 bytes
  286. >> SNMP: [3/0.03s] MySQL: [0/0.00s] RRD: [0/0.00s]
  287. #### Unload poller module ucd-mib ####
  288.  
  289. RRD[[0;32mupdate 192.168.0.121/poller-perf-ucd-mib.rrd N:0.034847974777222 --daemon unix:/var/run/rrdcached.sock[0m]
  290. [[0;31mRRD Disabled[0m]Modules status: Global+  
  291. OS  
  292. Device  
  293.  
  294. #### Load poller module ipSystemStats ####
  295. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  296. ipSystemStatsTable = No Such Object available on this agent at this OID  
  297.  
  298.  
  299.  
  300. >> Runtime for poller module 'ipSystemStats': 0.0219 seconds with 1880 bytes
  301. >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
  302. #### Unload poller module ipSystemStats ####
  303.  
  304. RRD[[0;32mupdate 192.168.0.121/poller-perf-ipSystemStats.rrd N:0.021896123886108 --daemon unix:/var/run/rrdcached.sock[0m]
  305. [[0;31mRRD Disabled[0m]Modules status: Global+  
  306. OS  
  307. Device  
  308.  
  309. #### Load poller module ports ####
  310. SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[259][0m 1.28ms]
  311.  
  312. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  313. ifXEntry = No Such Object available on this agent at this OID  
  314.  
  315. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ifEntry'[0m]
  316. ifIndex.1 = 1
  317. ifIndex.2 = 2
  318. ifIndex.3 = 3
  319. ifIndex.4 = 4
  320. ifIndex.5 = 5
  321. ifIndex.6 = 6
  322. ifDescr.1 = lo
  323. ifDescr.2 = eth1
  324. ifDescr.3 = eth0
  325. ifDescr.4 = ncsi-eth2
  326. ifDescr.5 = ip6tnl0
  327. ifDescr.6 = eth1.4003
  328. ifType.1 = softwareLoopback
  329. ifType.2 = ethernetCsmacd
  330. ifType.3 = ethernetCsmacd
  331. ifType.4 = ethernetCsmacd
  332. ifType.5 = tunnel
  333. ifType.6 = ethernetCsmacd
  334. ifMtu.1 = 16436
  335. ifMtu.2 = 1500
  336. ifMtu.3 = 1500
  337. ifMtu.4 = 1500
  338. ifMtu.5 = 1460
  339. ifMtu.6 = 1500
  340. ifSpeed.1 = 10000000
  341. ifSpeed.2 = 10000000
  342. ifSpeed.3 = 10000000
  343. ifSpeed.4 = 10000000
  344. ifSpeed.5 = 0
  345. ifSpeed.6 = 10000000
  346. ifPhysAddress.1 =
  347. ifPhysAddress.2 = f0:4d:a2:da:2a:f
  348. ifPhysAddress.3 = f0:4d:a2:da:2a:f
  349. ifPhysAddress.4 = 30:3a:30:3a:30:3a
  350. ifPhysAddress.5 =
  351. ifPhysAddress.6 = f0:4d:a2:da:2a:f
  352. ifAdminStatus.1 = up
  353. ifAdminStatus.2 = up
  354. ifAdminStatus.3 = up
  355. ifAdminStatus.4 = down
  356. ifAdminStatus.5 = down
  357. ifAdminStatus.6 = up
  358. ifOperStatus.1 = up
  359. ifOperStatus.2 = up
  360. ifOperStatus.3 = up
  361. ifOperStatus.4 = down
  362. ifOperStatus.5 = down
  363. ifOperStatus.6 = up
  364. ifLastChange.1 = 0
  365. ifLastChange.2 = 0
  366. ifLastChange.3 = 0
  367. ifLastChange.4 = 0
  368. ifLastChange.5 = 0
  369. ifLastChange.6 = 0
  370. ifInOctets.1 = 3575725606
  371. ifInOctets.2 = 3283773052
  372. ifInOctets.3 = 3058424504
  373. ifInOctets.4 = 0
  374. ifInOctets.5 = 0
  375. ifInOctets.6 = 177672779
  376. ifInUcastPkts.1 = 100465555
  377. ifInUcastPkts.2 = 270975273
  378. ifInUcastPkts.3 = 267582210
  379. ifInUcastPkts.4 = 0
  380. ifInUcastPkts.5 = 0
  381. ifInUcastPkts.6 = 3390032
  382. ifInNUcastPkts.1 = 0
  383. ifInNUcastPkts.2 = 0
  384. ifInNUcastPkts.3 = 0
  385. ifInNUcastPkts.4 = 0
  386. ifInNUcastPkts.5 = 0
  387. ifInNUcastPkts.6 = 0
  388. ifInDiscards.1 = 0
  389. ifInDiscards.2 = 0
  390. ifInDiscards.3 = 0
  391. ifInDiscards.4 = 0
  392. ifInDiscards.5 = 0
  393. ifInDiscards.6 = 0
  394. ifInErrors.1 = 0
  395. ifInErrors.2 = 0
  396. ifInErrors.3 = 0
  397. ifInErrors.4 = 0
  398. ifInErrors.5 = 0
  399. ifInErrors.6 = 0
  400. ifInUnknownProtos.1 = 0
  401. ifInUnknownProtos.2 = 0
  402. ifInUnknownProtos.3 = 0
  403. ifInUnknownProtos.4 = 0
  404. ifInUnknownProtos.5 = 0
  405. ifInUnknownProtos.6 = 0
  406. ifOutOctets.1 = 3575725606
  407. ifOutOctets.2 = 0
  408. ifOutOctets.3 = 0
  409. ifOutOctets.4 = 0
  410. ifOutOctets.5 = 0
  411. ifOutOctets.6 = 226643152
  412. ifOutUcastPkts.1 = 100465555
  413. ifOutUcastPkts.2 = 10478429
  414. ifOutUcastPkts.3 = 0
  415. ifOutUcastPkts.4 = 0
  416. ifOutUcastPkts.5 = 0
  417. ifOutUcastPkts.6 = 3390059
  418. ifOutNUcastPkts.1 = 0
  419. ifOutNUcastPkts.2 = 0
  420. ifOutNUcastPkts.3 = 0
  421. ifOutNUcastPkts.4 = 0
  422. ifOutNUcastPkts.5 = 0
  423. ifOutNUcastPkts.6 = 0
  424. ifOutDiscards.1 = 0
  425. ifOutDiscards.2 = 0
  426. ifOutDiscards.3 = 0
  427. ifOutDiscards.4 = 0
  428. ifOutDiscards.5 = 0
  429. ifOutDiscards.6 = 0
  430. ifOutErrors.1 = 0
  431. ifOutErrors.2 = 0
  432. ifOutErrors.3 = 0
  433. ifOutErrors.4 = 0
  434. ifOutErrors.5 = 0
  435. ifOutErrors.6 = 0
  436. ifOutQLen.1 = 0
  437. ifOutQLen.2 = 0
  438. ifOutQLen.3 = 0
  439. ifOutQLen.4 = 0
  440. ifOutQLen.5 = 0
  441. ifOutQLen.6 = 0
  442. ifSpecific.1 = zeroDotZero
  443. ifSpecific.2 = zeroDotZero
  444. ifSpecific.3 = zeroDotZero
  445. ifSpecific.4 = zeroDotZero
  446. ifSpecific.5 = zeroDotZero
  447. ifSpecific.6 = zeroDotZero  
  448.  
  449. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  450. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  451.  
  452. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  453. dot1qPvid = No Such Object available on this agent at this OID  
  454.  
  455. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[259][0m 0.58ms]
  456.  
  457. array (
  458.   1 =>
  459.   array (
  460.     'ifIndex' => '1',
  461.     'ifDescr' => 'lo',
  462.     'ifType' => 'softwareLoopback',
  463.     'ifMtu' => '16436',
  464.     'ifSpeed' => '10000000',
  465.     'ifPhysAddress' => '',
  466.     'ifAdminStatus' => 'up',
  467.     'ifOperStatus' => 'up',
  468.     'ifLastChange' => '0',
  469.     'ifInOctets' => '3575725606',
  470.     'ifInUcastPkts' => '100465555',
  471.     'ifInNUcastPkts' => '0',
  472.     'ifInDiscards' => '0',
  473.     'ifInErrors' => '0',
  474.     'ifInUnknownProtos' => '0',
  475.     'ifOutOctets' => '3575725606',
  476.     'ifOutUcastPkts' => '100465555',
  477.     'ifOutNUcastPkts' => '0',
  478.     'ifOutDiscards' => '0',
  479.     'ifOutErrors' => '0',
  480.     'ifOutQLen' => '0',
  481.     'ifSpecific' => 'zeroDotZero',
  482.   ),
  483.   2 =>
  484.   array (
  485.     'ifIndex' => '2',
  486.     'ifDescr' => 'eth1',
  487.     'ifType' => 'ethernetCsmacd',
  488.     'ifMtu' => '1500',
  489.     'ifSpeed' => '10000000',
  490.     'ifPhysAddress' => 'f0:4d:a2:da:2a:f',
  491.     'ifAdminStatus' => 'up',
  492.     'ifOperStatus' => 'up',
  493.     'ifLastChange' => '0',
  494.     'ifInOctets' => '3283773052',
  495.     'ifInUcastPkts' => '270975273',
  496.     'ifInNUcastPkts' => '0',
  497.     'ifInDiscards' => '0',
  498.     'ifInErrors' => '0',
  499.     'ifInUnknownProtos' => '0',
  500.     'ifOutOctets' => '0',
  501.     'ifOutUcastPkts' => '10478429',
  502.     'ifOutNUcastPkts' => '0',
  503.     'ifOutDiscards' => '0',
  504.     'ifOutErrors' => '0',
  505.     'ifOutQLen' => '0',
  506.     'ifSpecific' => 'zeroDotZero',
  507.   ),
  508.   3 =>
  509.   array (
  510.     'ifIndex' => '3',
  511.     'ifDescr' => 'eth0',
  512.     'ifType' => 'ethernetCsmacd',
  513.     'ifMtu' => '1500',
  514.     'ifSpeed' => '10000000',
  515.     'ifPhysAddress' => 'f0:4d:a2:da:2a:f',
  516.     'ifAdminStatus' => 'up',
  517.     'ifOperStatus' => 'up',
  518.     'ifLastChange' => '0',
  519.     'ifInOctets' => '3058424504',
  520.     'ifInUcastPkts' => '267582210',
  521.     'ifInNUcastPkts' => '0',
  522.     'ifInDiscards' => '0',
  523.     'ifInErrors' => '0',
  524.     'ifInUnknownProtos' => '0',
  525.     'ifOutOctets' => '0',
  526.     'ifOutUcastPkts' => '0',
  527.     'ifOutNUcastPkts' => '0',
  528.     'ifOutDiscards' => '0',
  529.     'ifOutErrors' => '0',
  530.     'ifOutQLen' => '0',
  531.     'ifSpecific' => 'zeroDotZero',
  532.   ),
  533.   4 =>
  534.   array (
  535.     'ifIndex' => '4',
  536.     'ifDescr' => 'ncsi-eth2',
  537.     'ifType' => 'ethernetCsmacd',
  538.     'ifMtu' => '1500',
  539.     'ifSpeed' => '10000000',
  540.     'ifPhysAddress' => '30:3a:30:3a:30:3a',
  541.     'ifAdminStatus' => 'down',
  542.     'ifOperStatus' => 'down',
  543.     'ifLastChange' => '0',
  544.     'ifInOctets' => '0',
  545.     'ifInUcastPkts' => '0',
  546.     'ifInNUcastPkts' => '0',
  547.     'ifInDiscards' => '0',
  548.     'ifInErrors' => '0',
  549.     'ifInUnknownProtos' => '0',
  550.     'ifOutOctets' => '0',
  551.     'ifOutUcastPkts' => '0',
  552.     'ifOutNUcastPkts' => '0',
  553.     'ifOutDiscards' => '0',
  554.     'ifOutErrors' => '0',
  555.     'ifOutQLen' => '0',
  556.     'ifSpecific' => 'zeroDotZero',
  557.   ),
  558.   5 =>
  559.   array (
  560.     'ifIndex' => '5',
  561.     'ifDescr' => 'ip6tnl0',
  562.     'ifType' => 'tunnel',
  563.     'ifMtu' => '1460',
  564.     'ifSpeed' => '0',
  565.     'ifPhysAddress' => '',
  566.     'ifAdminStatus' => 'down',
  567.     'ifOperStatus' => 'down',
  568.     'ifLastChange' => '0',
  569.     'ifInOctets' => '0',
  570.     'ifInUcastPkts' => '0',
  571.     'ifInNUcastPkts' => '0',
  572.     'ifInDiscards' => '0',
  573.     'ifInErrors' => '0',
  574.     'ifInUnknownProtos' => '0',
  575.     'ifOutOctets' => '0',
  576.     'ifOutUcastPkts' => '0',
  577.     'ifOutNUcastPkts' => '0',
  578.     'ifOutDiscards' => '0',
  579.     'ifOutErrors' => '0',
  580.     'ifOutQLen' => '0',
  581.     'ifSpecific' => 'zeroDotZero',
  582.   ),
  583.   6 =>
  584.   array (
  585.     'ifIndex' => '6',
  586.     'ifDescr' => 'eth1.4003',
  587.     'ifType' => 'ethernetCsmacd',
  588.     'ifMtu' => '1500',
  589.     'ifSpeed' => '10000000',
  590.     'ifPhysAddress' => 'f0:4d:a2:da:2a:f',
  591.     'ifAdminStatus' => 'up',
  592.     'ifOperStatus' => 'up',
  593.     'ifLastChange' => '0',
  594.     'ifInOctets' => '177672779',
  595.     'ifInUcastPkts' => '3390032',
  596.     'ifInNUcastPkts' => '0',
  597.     'ifInDiscards' => '0',
  598.     'ifInErrors' => '0',
  599.     'ifInUnknownProtos' => '0',
  600.     'ifOutOctets' => '226643152',
  601.     'ifOutUcastPkts' => '3390059',
  602.     'ifOutNUcastPkts' => '0',
  603.     'ifOutDiscards' => '0',
  604.     'ifOutErrors' => '0',
  605.     'ifOutQLen' => '0',
  606.     'ifSpecific' => 'zeroDotZero',
  607.   ),
  608. )  
  609.  valid  
  610.  valid  
  611.  valid  
  612.  valid  
  613.  valid  
  614.  valid  
  615.  
  616. Port lo: lo (1 / #12548) ifInOctets  
  617. ifOutOctets  
  618. ifInUcastPkts  
  619. ifOutUcastPkts  
  620. ifInBroadcastPkts  
  621. ifOutBroadcastPkts  
  622. ifInMulticastPkts  
  623. ifOutMulticastPkts  
  624. ifSpeed  
  625. VLAN =   Using ifDescr as ifAlias  
  626.  Using ifDescr as ifName  
  627. lo
  628.  ifInOctets (137073 B) 662.1884057971 Bps 207 secs  
  629.  
  630.  ifOutOctets (137073 B) 662.1884057971 Bps 207 secs  
  631.  
  632.  ifInErrors (0 B) 0 Bps 207 secs  
  633.  
  634.  ifOutErrors (0 B) 0 Bps 207 secs  
  635.  
  636.  ifInUcastPkts (1749 B) 8.4492753623188 Bps 207 secs  
  637.  
  638.  ifOutUcastPkts (1749 B) 8.4492753623188 Bps 207 secs  
  639.  
  640.  ifInNUcastPkts (0 B) 0 Bps 207 secs  
  641.  
  642.  ifOutNUcastPkts (0 B) 0 Bps 207 secs  
  643.  
  644.  ifInDiscards (0 B) 0 Bps 207 secs  
  645.  
  646.  ifOutDiscards (0 B) 0 Bps 207 secs  
  647.  
  648.  ifInUnknownProtos (0 B) 0 Bps 207 secs  
  649.  
  650.  ifInBroadcastPkts (0 B) 0 Bps 207 secs  
  651.  
  652.  ifOutBroadcastPkts (0 B) 0 Bps 207 secs  
  653.  
  654.  ifInMulticastPkts (0 B) 0 Bps 207 secs  
  655.  
  656.  ifOutMulticastPkts (0 B) 0 Bps 207 secs  
  657. bps(5.3 kbps/5.3 kbps)bytes(133.86 kB/133.86 kB)pkts(8.45 pps/8.45 pps)RRD[[0;32mupdate 192.168.0.121/port-id12548.rrd N:3575725606:3575725606:0:0:100465555:100465555:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  658. [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [0;33m[1550745577,1550745370,207,"0","3575725606",3575588533,662.1884057971,137073,"3575725606",3575588533,662.1884057971,137073,"0",0,0,0,"0",0,0,0,"100465555",100463806,8.4492753623188,1749,"100465555",100463806,8.4492753623188,1749,12548][0m 7.51ms]
  659.  
  660. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12548][0m 7.01ms]
  661.  
  662. 1 updated  
  663.  
  664. Port eth1: eth1 (2 / #12549) ifInOctets  
  665. ifOutOctets  
  666. ifInUcastPkts  
  667. ifOutUcastPkts  
  668. ifInBroadcastPkts  
  669. ifOutBroadcastPkts  
  670. ifInMulticastPkts  
  671. ifOutMulticastPkts  
  672. ifSpeed  
  673. VLAN =   Using ifDescr as ifAlias  
  674.  Using ifDescr as ifName  
  675. eth1
  676.  ifInOctets (333500 B) 1611.1111111111 Bps 207 secs  
  677.  
  678.  ifOutOctets (0 B) 0 Bps 207 secs  
  679.  
  680.  ifInErrors (0 B) 0 Bps 207 secs  
  681.  
  682.  ifOutErrors (0 B) 0 Bps 207 secs  
  683.  
  684.  ifInUcastPkts (4441 B) 21.454106280193 Bps 207 secs  
  685.  
  686.  ifOutUcastPkts (289 B) 1.3961352657005 Bps 207 secs  
  687.  
  688.  ifInNUcastPkts (0 B) 0 Bps 207 secs  
  689.  
  690.  ifOutNUcastPkts (0 B) 0 Bps 207 secs  
  691.  
  692.  ifInDiscards (0 B) 0 Bps 207 secs  
  693.  
  694.  ifOutDiscards (0 B) 0 Bps 207 secs  
  695.  
  696.  ifInUnknownProtos (0 B) 0 Bps 207 secs  
  697.  
  698.  ifInBroadcastPkts (0 B) 0 Bps 207 secs  
  699.  
  700.  ifOutBroadcastPkts (0 B) 0 Bps 207 secs  
  701.  
  702.  ifInMulticastPkts (0 B) 0 Bps 207 secs  
  703.  
  704.  ifOutMulticastPkts (0 B) 0 Bps 207 secs  
  705. bps(12.89 kbps/0 bps)bytes(325.68 kB/0 B)pkts(21.45 pps/1.4 pps)RRD[[0;32mupdate 192.168.0.121/port-id12549.rrd N:3283773052:0:0:0:270975273:10478429:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  706. [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [0;33m[1550745577,1550745370,207,"0","3283773052",3283439552,1611.1111111111,333500,"0",0,0,0,"0",0,0,0,"0",0,0,0,"270975273",270970832,21.454106280193,4441,"10478429",10478140,1.3961352657005,289,12549][0m 12.22ms]
  707.  
  708. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12549][0m 8.77ms]
  709.  
  710. 1 updated  
  711.  
  712. Port eth0: eth0 (3 / #12550) ifInOctets  
  713. ifOutOctets  
  714. ifInUcastPkts  
  715. ifOutUcastPkts  
  716. ifInBroadcastPkts  
  717. ifOutBroadcastPkts  
  718. ifInMulticastPkts  
  719. ifOutMulticastPkts  
  720. ifSpeed  
  721. VLAN =   Using ifDescr as ifAlias  
  722.  Using ifDescr as ifName  
  723. eth0
  724.  ifInOctets (329517 B) 1591.8695652174 Bps 207 secs  
  725.  
  726.  ifOutOctets (0 B) 0 Bps 207 secs  
  727.  
  728.  ifInErrors (0 B) 0 Bps 207 secs  
  729.  
  730.  ifOutErrors (0 B) 0 Bps 207 secs  
  731.  
  732.  ifInUcastPkts (4381 B) 21.164251207729 Bps 207 secs  
  733.  
  734.  ifOutUcastPkts (0 B) 0 Bps 207 secs  
  735.  
  736.  ifInNUcastPkts (0 B) 0 Bps 207 secs  
  737.  
  738.  ifOutNUcastPkts (0 B) 0 Bps 207 secs  
  739.  
  740.  ifInDiscards (0 B) 0 Bps 207 secs  
  741.  
  742.  ifOutDiscards (0 B) 0 Bps 207 secs  
  743.  
  744.  ifInUnknownProtos (0 B) 0 Bps 207 secs  
  745.  
  746.  ifInBroadcastPkts (0 B) 0 Bps 207 secs  
  747.  
  748.  ifOutBroadcastPkts (0 B) 0 Bps 207 secs  
  749.  
  750.  ifInMulticastPkts (0 B) 0 Bps 207 secs  
  751.  
  752.  ifOutMulticastPkts (0 B) 0 Bps 207 secs  
  753. bps(12.74 kbps/0 bps)bytes(321.79 kB/0 B)pkts(21.16 pps/0 pps)RRD[[0;32mupdate 192.168.0.121/port-id12550.rrd N:3058424504:0:0:0:267582210:0:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  754. [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [0;33m[1550745577,1550745370,207,"0","3058424504",3058094987,1591.8695652174,329517,"0",0,0,0,"0",0,0,0,"0",0,0,0,"267582210",267577829,21.164251207729,4381,"0",0,0,0,12550][0m 8.25ms]
  755.  
  756. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12550][0m 4.48ms]
  757.  
  758. 1 updated  
  759.  
  760. Port ncsi-eth2: ncsi-eth2 (4 / #12551) ifInOctets  
  761. ifOutOctets  
  762. ifInUcastPkts  
  763. ifOutUcastPkts  
  764. ifInBroadcastPkts  
  765. ifOutBroadcastPkts  
  766. ifInMulticastPkts  
  767. ifOutMulticastPkts  
  768. ifSpeed  
  769. VLAN =   Using ifDescr as ifAlias  
  770.  Using ifDescr as ifName  
  771. ncsi-eth2
  772.  ifInOctets (0 B) 0 Bps 207 secs  
  773.  
  774.  ifOutOctets (0 B) 0 Bps 207 secs  
  775.  
  776.  ifInErrors (0 B) 0 Bps 207 secs  
  777.  
  778.  ifOutErrors (0 B) 0 Bps 207 secs  
  779.  
  780.  ifInUcastPkts (0 B) 0 Bps 207 secs  
  781.  
  782.  ifOutUcastPkts (0 B) 0 Bps 207 secs  
  783.  
  784.  ifInNUcastPkts (0 B) 0 Bps 207 secs  
  785.  
  786.  ifOutNUcastPkts (0 B) 0 Bps 207 secs  
  787.  
  788.  ifInDiscards (0 B) 0 Bps 207 secs  
  789.  
  790.  ifOutDiscards (0 B) 0 Bps 207 secs  
  791.  
  792.  ifInUnknownProtos (0 B) 0 Bps 207 secs  
  793.  
  794.  ifInBroadcastPkts (0 B) 0 Bps 207 secs  
  795.  
  796.  ifOutBroadcastPkts (0 B) 0 Bps 207 secs  
  797.  
  798.  ifInMulticastPkts (0 B) 0 Bps 207 secs  
  799.  
  800.  ifOutMulticastPkts (0 B) 0 Bps 207 secs  
  801. bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[[0;32mupdate 192.168.0.121/port-id12551.rrd N:0:0:0:0:0:0:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  802. [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [0;33m[1550745577,1550745370,207,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,12551][0m 4.44ms]
  803.  
  804. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12551][0m 4.36ms]
  805.  
  806. 1 updated  
  807.  
  808. Port ip6tnl0: ip6tnl0 (5 / #12552) ifInOctets  
  809. ifOutOctets  
  810. ifInUcastPkts  
  811. ifOutUcastPkts  
  812. ifInBroadcastPkts  
  813. ifOutBroadcastPkts  
  814. ifInMulticastPkts  
  815. ifOutMulticastPkts  
  816. ifSpeed  
  817. VLAN =   Using ifDescr as ifAlias  
  818.  Using ifDescr as ifName  
  819. ip6tnl0
  820.  ifInOctets (0 B) 0 Bps 207 secs  
  821.  
  822.  ifOutOctets (0 B) 0 Bps 207 secs  
  823.  
  824.  ifInErrors (0 B) 0 Bps 207 secs  
  825.  
  826.  ifOutErrors (0 B) 0 Bps 207 secs  
  827.  
  828.  ifInUcastPkts (0 B) 0 Bps 207 secs  
  829.  
  830.  ifOutUcastPkts (0 B) 0 Bps 207 secs  
  831.  
  832.  ifInNUcastPkts (0 B) 0 Bps 207 secs  
  833.  
  834.  ifOutNUcastPkts (0 B) 0 Bps 207 secs  
  835.  
  836.  ifInDiscards (0 B) 0 Bps 207 secs  
  837.  
  838.  ifOutDiscards (0 B) 0 Bps 207 secs  
  839.  
  840.  ifInUnknownProtos (0 B) 0 Bps 207 secs  
  841.  
  842.  ifInBroadcastPkts (0 B) 0 Bps 207 secs  
  843.  
  844.  ifOutBroadcastPkts (0 B) 0 Bps 207 secs  
  845.  
  846.  ifInMulticastPkts (0 B) 0 Bps 207 secs  
  847.  
  848.  ifOutMulticastPkts (0 B) 0 Bps 207 secs  
  849. bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[[0;32mupdate 192.168.0.121/port-id12552.rrd N:0:0:0:0:0:0:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  850. [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [0;33m[1550745577,1550745370,207,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,12552][0m 4.31ms]
  851.  
  852. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12552][0m 5.07ms]
  853.  
  854. 1 updated  
  855.  
  856. Port eth1.4003: eth1.4003 (6 / #12553) ifInOctets  
  857. ifOutOctets  
  858. ifInUcastPkts  
  859. ifOutUcastPkts  
  860. ifInBroadcastPkts  
  861. ifOutBroadcastPkts  
  862. ifInMulticastPkts  
  863. ifOutMulticastPkts  
  864. ifSpeed  
  865. VLAN =   Using ifDescr as ifAlias  
  866.  Using ifDescr as ifName  
  867. eth1.4003
  868.  ifInOctets (3143 B) 15.183574879227 Bps 207 secs  
  869.  
  870.  ifOutOctets (4025 B) 19.444444444444 Bps 207 secs  
  871.  
  872.  ifInErrors (0 B) 0 Bps 207 secs  
  873.  
  874.  ifOutErrors (0 B) 0 Bps 207 secs  
  875.  
  876.  ifInUcastPkts (60 B) 0.28985507246377 Bps 207 secs  
  877.  
  878.  ifOutUcastPkts (60 B) 0.28985507246377 Bps 207 secs  
  879.  
  880.  ifInNUcastPkts (0 B) 0 Bps 207 secs  
  881.  
  882.  ifOutNUcastPkts (0 B) 0 Bps 207 secs  
  883.  
  884.  ifInDiscards (0 B) 0 Bps 207 secs  
  885.  
  886.  ifOutDiscards (0 B) 0 Bps 207 secs  
  887.  
  888.  ifInUnknownProtos (0 B) 0 Bps 207 secs  
  889.  
  890.  ifInBroadcastPkts (0 B) 0 Bps 207 secs  
  891.  
  892.  ifOutBroadcastPkts (0 B) 0 Bps 207 secs  
  893.  
  894.  ifInMulticastPkts (0 B) 0 Bps 207 secs  
  895.  
  896.  ifOutMulticastPkts (0 B) 0 Bps 207 secs  
  897. bps(121 bps/156 bps)bytes(3.07 kB/3.93 kB)pkts(0.29 pps/0.29 pps)RRD[[0;32mupdate 192.168.0.121/port-id12553.rrd N:177672779:226643152:0:0:3390032:3390059:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  898. [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [0;33m[1550745577,1550745370,207,"0","177672779",177669636,15.183574879227,3143,"226643152",226639127,19.444444444444,4025,"0",0,0,0,"0",0,0,0,"3390032",3389972,0.28985507246377,60,"3390059",3389999,0.28985507246377,60,12553][0m 4.36ms]
  899.  
  900. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12553][0m 4.53ms]
  901.  
  902. 1 updated  
  903.  
  904.  
  905. >> Runtime for poller module 'ports': 0.3290 seconds with 38184 bytes
  906. >> SNMP: [4/0.23s] MySQL: [13/0.08s] RRD: [0/0.00s]
  907. #### Unload poller module ports ####
  908.  
  909. RRD[[0;32mupdate 192.168.0.121/poller-perf-ports.rrd N:0.32899188995361 --daemon unix:/var/run/rrdcached.sock[0m]
  910. [[0;31mRRD Disabled[0m]Modules status: Global+  
  911. OS  
  912. Device  
  913.  
  914. #### Load poller module bgp-peers ####
  915. SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[259][0m 0.59ms]
  916.  
  917.  
  918. >> Runtime for poller module 'bgp-peers': 0.0018 seconds with 11256 bytes
  919. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  920. #### Unload poller module bgp-peers ####
  921.  
  922. RRD[[0;32mupdate 192.168.0.121/poller-perf-bgp-peers.rrd N:0.0017540454864502 --daemon unix:/var/run/rrdcached.sock[0m]
  923. [[0;31mRRD Disabled[0m]Modules status: Global+  
  924. OS  
  925. Device  
  926.  
  927. #### Load poller module junose-atm-vp ####
  928. SQL[[1;33mSELECT * FROM `ports` AS P, `juniAtmVp` AS J WHERE P.`device_id` = ? AND J.port_id = P.port_id [0;33m[259][0m 0.62ms]
  929.  
  930.  
  931. >> Runtime for poller module 'junose-atm-vp': 0.0011 seconds with 2448 bytes
  932. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  933. #### Unload poller module junose-atm-vp ####
  934.  
  935. RRD[[0;32mupdate 192.168.0.121/poller-perf-junose-atm-vp.rrd N:0.0010569095611572 --daemon unix:/var/run/rrdcached.sock[0m]
  936. [[0;31mRRD Disabled[0m]Modules status: Global-  
  937. OS  
  938. Device  
  939. Module [ toner ] disabled globally.
  940.  
  941. Modules status: Global+  
  942. OS  
  943. Device  
  944.  
  945. #### Load poller module ucd-diskio ####
  946. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[259][0m 0.25ms]
  947.  
  948.  
  949. >> Runtime for poller module 'ucd-diskio': 0.0006 seconds with 1824 bytes
  950. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  951. #### Unload poller module ucd-diskio ####
  952.  
  953. RRD[[0;32mupdate 192.168.0.121/poller-perf-ucd-diskio.rrd N:0.00058817863464355 --daemon unix:/var/run/rrdcached.sock[0m]
  954. [[0;31mRRD Disabled[0m]Modules status: Global-  
  955. OS  
  956. Device  
  957. Module [ wifi ] disabled globally.
  958.  
  959. Modules status: Global+  
  960. OS  
  961. Device  
  962.  
  963. #### Load poller module wireless ####
  964. Attempting to initialize OS: drac  
  965. OS initialized as Generic  
  966. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[259][0m 0.37ms]
  967.  
  968.  
  969. >> Runtime for poller module 'wireless': 0.0019 seconds with 167904 bytes
  970. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  971. #### Unload poller module wireless ####
  972.  
  973. RRD[[0;32mupdate 192.168.0.121/poller-perf-wireless.rrd N:0.001924991607666 --daemon unix:/var/run/rrdcached.sock[0m]
  974. [[0;31mRRD Disabled[0m]Modules status: Global+  
  975. OS  
  976. Device  
  977.  
  978. #### Load poller module ospf ####
  979. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[259][0m 0.52ms]
  980.  
  981.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]
  982. ospfGeneralGroup = No Such Object available on this agent at this OID  
  983.  
  984. array (
  985. )  
  986. SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[259][0m 2.02ms]
  987.  
  988. 0
  989. >> Runtime for poller module 'ospf': 0.0354 seconds with 161024 bytes
  990. >> SNMP: [1/0.03s] MySQL: [0/0.00s] RRD: [0/0.00s]
  991. #### Unload poller module ospf ####
  992.  
  993. RRD[[0;32mupdate 192.168.0.121/poller-perf-ospf.rrd N:0.035355091094971 --daemon unix:/var/run/rrdcached.sock[0m]
  994. [[0;31mRRD Disabled[0m]Modules status: Global+  
  995. OS  
  996. Device  
  997.  
  998. #### Load poller module cisco-ipsec-flow-monitor ####
  999.  
  1000. >> Runtime for poller module 'cisco-ipsec-flow-monitor': 0.0003 seconds with 2368 bytes
  1001. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1002. #### Unload poller module cisco-ipsec-flow-monitor ####
  1003.  
  1004. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-ipsec-flow-monitor.rrd N:0.00025606155395508 --daemon unix:/var/run/rrdcached.sock[0m]
  1005. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1006. OS  
  1007. Device  
  1008.  
  1009. #### Load poller module cisco-remote-access-monitor ####
  1010.  
  1011. >> Runtime for poller module 'cisco-remote-access-monitor': 0.0001 seconds with 600 bytes
  1012. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1013. #### Unload poller module cisco-remote-access-monitor ####
  1014.  
  1015. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-remote-access-monitor.rrd N:0.00012612342834473 --daemon unix:/var/run/rrdcached.sock[0m]
  1016. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1017. OS  
  1018. Device  
  1019.  
  1020. #### Load poller module cisco-cef ####
  1021.  
  1022. >> Runtime for poller module 'cisco-cef': 0.0005 seconds with 2104 bytes
  1023. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1024. #### Unload poller module cisco-cef ####
  1025.  
  1026. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-cef.rrd N:0.0005190372467041 --daemon unix:/var/run/rrdcached.sock[0m]
  1027. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1028. OS  
  1029. Device  
  1030.  
  1031. #### Load poller module cisco-sla ####
  1032. SQL[[1;33mSELECT * FROM `slas` WHERE `device_id` = ? AND `deleted` = 0 [0;33m[259][0m 0.28ms]
  1033.  
  1034.  
  1035. >> Runtime for poller module 'cisco-sla': 0.0008 seconds with 4312 bytes
  1036. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  1037. #### Unload poller module cisco-sla ####
  1038.  
  1039. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-sla.rrd N:0.00082802772521973 --daemon unix:/var/run/rrdcached.sock[0m]
  1040. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1041. OS  
  1042. Device  
  1043.  
  1044. #### Load poller module cisco-mac-accounting ####
  1045.  
  1046. >> Runtime for poller module 'cisco-mac-accounting': 0.0002 seconds with 1064 bytes
  1047. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1048. #### Unload poller module cisco-mac-accounting ####
  1049.  
  1050. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-mac-accounting.rrd N:0.00021195411682129 --daemon unix:/var/run/rrdcached.sock[0m]
  1051. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1052. OS  
  1053. Device  
  1054.  
  1055. #### Load poller module cipsec-tunnels ####
  1056.  
  1057. >> Runtime for poller module 'cipsec-tunnels': 0.0003 seconds with 1728 bytes
  1058. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1059. #### Unload poller module cipsec-tunnels ####
  1060.  
  1061. RRD[[0;32mupdate 192.168.0.121/poller-perf-cipsec-tunnels.rrd N:0.00030994415283203 --daemon unix:/var/run/rrdcached.sock[0m]
  1062. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1063. OS  
  1064. Device  
  1065.  
  1066. #### Load poller module cisco-ace-loadbalancer ####
  1067.  
  1068. >> Runtime for poller module 'cisco-ace-loadbalancer': 0.0002 seconds with 968 bytes
  1069. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1070. #### Unload poller module cisco-ace-loadbalancer ####
  1071.  
  1072. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-ace-loadbalancer.rrd N:0.00020694732666016 --daemon unix:/var/run/rrdcached.sock[0m]
  1073. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1074. OS  
  1075. Device  
  1076.  
  1077. #### Load poller module cisco-ace-serverfarms ####
  1078.  
  1079. >> Runtime for poller module 'cisco-ace-serverfarms': 0.0002 seconds with 936 bytes
  1080. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1081. #### Unload poller module cisco-ace-serverfarms ####
  1082.  
  1083. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-ace-serverfarms.rrd N:0.00016188621520996 --daemon unix:/var/run/rrdcached.sock[0m]
  1084. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1085. OS  
  1086. Device  
  1087.  
  1088. #### Load poller module cisco-asa-firewall ####
  1089.  
  1090. >> Runtime for poller module 'cisco-asa-firewall': 0.0002 seconds with 648 bytes
  1091. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1092. #### Unload poller module cisco-asa-firewall ####
  1093.  
  1094. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-asa-firewall.rrd N:0.00015091896057129 --daemon unix:/var/run/rrdcached.sock[0m]
  1095. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1096. OS  
  1097. Device  
  1098.  
  1099. #### Load poller module cisco-voice ####
  1100.  
  1101. >> Runtime for poller module 'cisco-voice': 0.0001 seconds with 288 bytes
  1102. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1103. #### Unload poller module cisco-voice ####
  1104.  
  1105. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-voice.rrd N:7.8201293945312E-5 --daemon unix:/var/run/rrdcached.sock[0m]
  1106. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1107. OS  
  1108. Device  
  1109.  
  1110. #### Load poller module cisco-cbqos ####
  1111.  
  1112. >> Runtime for poller module 'cisco-cbqos': 0.0002 seconds with 1296 bytes
  1113. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1114. #### Unload poller module cisco-cbqos ####
  1115.  
  1116. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-cbqos.rrd N:0.00020694732666016 --daemon unix:/var/run/rrdcached.sock[0m]
  1117. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1118. OS  
  1119. Device  
  1120.  
  1121. #### Load poller module cisco-otv ####
  1122.  
  1123. >> Runtime for poller module 'cisco-otv': 0.0004 seconds with 4336 bytes
  1124. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1125. #### Unload poller module cisco-otv ####
  1126.  
  1127. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-otv.rrd N:0.00036787986755371 --daemon unix:/var/run/rrdcached.sock[0m]
  1128. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1129. OS  
  1130. Device  
  1131.  
  1132. #### Load poller module cisco-vpdn ####
  1133.  
  1134. >> Runtime for poller module 'cisco-vpdn': 0.0001 seconds with 520 bytes
  1135. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1136. #### Unload poller module cisco-vpdn ####
  1137.  
  1138. RRD[[0;32mupdate 192.168.0.121/poller-perf-cisco-vpdn.rrd N:0.00012493133544922 --daemon unix:/var/run/rrdcached.sock[0m]
  1139. [[0;31mRRD Disabled[0m]Modules status: Global-  
  1140. OS  
  1141. Device  
  1142. Module [ nac ] disabled globally.
  1143.  
  1144. Modules status: Global+  
  1145. OS  
  1146. Device  
  1147.  
  1148. #### Load poller module netscaler-vsvr ####
  1149.  
  1150. >> Runtime for poller module 'netscaler-vsvr': 0.0002 seconds with 1560 bytes
  1151. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1152. #### Unload poller module netscaler-vsvr ####
  1153.  
  1154. RRD[[0;32mupdate 192.168.0.121/poller-perf-netscaler-vsvr.rrd N:0.00022506713867188 --daemon unix:/var/run/rrdcached.sock[0m]
  1155. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1156. OS  
  1157. Device  
  1158.  
  1159. #### Load poller module aruba-controller ####
  1160.  
  1161. >> Runtime for poller module 'aruba-controller': 0.0003 seconds with 2616 bytes
  1162. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1163. #### Unload poller module aruba-controller ####
  1164.  
  1165. RRD[[0;32mupdate 192.168.0.121/poller-perf-aruba-controller.rrd N:0.00032997131347656 --daemon unix:/var/run/rrdcached.sock[0m]
  1166. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1167. OS  
  1168. Device  
  1169.  
  1170. #### Load poller module entity-physical ####
  1171. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[259][0m 0.37ms]
  1172.  
  1173.  
  1174. >> Runtime for poller module 'entity-physical': 0.0008 seconds with 1960 bytes
  1175. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  1176. #### Unload poller module entity-physical ####
  1177.  
  1178. RRD[[0;32mupdate 192.168.0.121/poller-perf-entity-physical.rrd N:0.00079798698425293 --daemon unix:/var/run/rrdcached.sock[0m]
  1179. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1180. OS  
  1181. Device  
  1182.  
  1183. #### Load poller module entity-state ####
  1184. SQL[[1;33mSELECT S.entity_state_id, S.entStateLastChanged, P.entPhysicalIndex FROM entityState AS S LEFT JOIN entPhysical AS P USING (entPhysical_id) WHERE S.device_id=? [0;33m[259][0m 0.3ms]
  1185.  
  1186.  
  1187. >> Runtime for poller module 'entity-state': 0.0007 seconds with 2224 bytes
  1188. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  1189. #### Unload poller module entity-state ####
  1190.  
  1191. RRD[[0;32mupdate 192.168.0.121/poller-perf-entity-state.rrd N:0.00069499015808105 --daemon unix:/var/run/rrdcached.sock[0m]
  1192. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1193. OS  
  1194. Device  
  1195.  
  1196. #### Load poller module applications ####
  1197. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[259][0m 0.36ms]
  1198.  
  1199.  
  1200. >> Runtime for poller module 'applications': 0.0007 seconds with 1472 bytes
  1201. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  1202. #### Unload poller module applications ####
  1203.  
  1204. RRD[[0;32mupdate 192.168.0.121/poller-perf-applications.rrd N:0.00066781044006348 --daemon unix:/var/run/rrdcached.sock[0m]
  1205. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1206. OS  
  1207. Device  
  1208.  
  1209. #### Load poller module mib ####
  1210. SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [0;33m[259,"poll_mib"][0m 0.21ms]
  1211.  
  1212. MIB: polling  
  1213. SQL[[1;33mSELECT `mib`, `module` FROM device_mibs WHERE device_id = ? [0;33m[259][0m 0.2ms]
  1214.  
  1215.  
  1216.  
  1217. >> Runtime for poller module 'mib': 0.0010 seconds with 1232 bytes
  1218. >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s]
  1219. #### Unload poller module mib ####
  1220.  
  1221. RRD[[0;32mupdate 192.168.0.121/poller-perf-mib.rrd N:0.00096702575683594 --daemon unix:/var/run/rrdcached.sock[0m]
  1222. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1223. OS  
  1224. Device  
  1225.  
  1226. #### Load poller module stp ####
  1227. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[259][0m 0.39ms]
  1228.  
  1229. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/drac:/opt/librenms/mibs/dell' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
  1230. No Such Object available on this agent at this OID  
  1231.  
  1232.  
  1233.  
  1234. >> Runtime for poller module 'stp': 0.0136 seconds with 5624 bytes
  1235. >> SNMP: [1/0.01s] MySQL: [1/0.00s] RRD: [0/0.00s]
  1236. #### Unload poller module stp ####
  1237.  
  1238. RRD[[0;32mupdate 192.168.0.121/poller-perf-stp.rrd N:0.013569831848145 --daemon unix:/var/run/rrdcached.sock[0m]
  1239. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1240. OS  
  1241. Device  
  1242.  
  1243. #### Load poller module ntp ####
  1244.  
  1245. >> Runtime for poller module 'ntp': 0.0002 seconds with 320 bytes
  1246. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1247. #### Unload poller module ntp ####
  1248.  
  1249. RRD[[0;32mupdate 192.168.0.121/poller-perf-ntp.rrd N:0.00017595291137695 --daemon unix:/var/run/rrdcached.sock[0m]
  1250. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1251. OS  
  1252. Device  
  1253.  
  1254. #### Load poller module loadbalancers ####
  1255.  
  1256. >> Runtime for poller module 'loadbalancers': 0.0001 seconds with 240 bytes
  1257. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1258. #### Unload poller module loadbalancers ####
  1259.  
  1260. RRD[[0;32mupdate 192.168.0.121/poller-perf-loadbalancers.rrd N:7.4148178100586E-5 --daemon unix:/var/run/rrdcached.sock[0m]
  1261. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1262. OS  
  1263. Device  
  1264.  
  1265. #### Load poller module mef ####
  1266. MEF Links: SQL[[1;33mSELECT id, mefID, mefType, mefIdent, mefMTU, mefAdmState, mefRowState FROM mefinfo WHERE device_id = ? [0;33m[259][0m 0.31ms]
  1267.  
  1268.  
  1269.  
  1270. >> Runtime for poller module 'mef': 0.0008 seconds with 2272 bytes
  1271. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  1272. #### Unload poller module mef ####
  1273.  
  1274. RRD[[0;32mupdate 192.168.0.121/poller-perf-mef.rrd N:0.00077390670776367 --daemon unix:/var/run/rrdcached.sock[0m]
  1275. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1276. OS  
  1277. Device  
  1278.  
  1279. #### Load poller module services ####
  1280.  
  1281. Warning: include(includes/polling/services.inc.php): failed to open stream: No such file or directory in /opt/librenms/includes/polling/functions.inc.php on line 303
  1282.  
  1283. Warning: include(): Failed opening 'includes/polling/services.inc.php' for inclusion (include_path='.:/usr/share/php') in /opt/librenms/includes/polling/functions.inc.php on line 303
  1284.  
  1285. >> Runtime for poller module 'services': 0.0001 seconds with 0 bytes
  1286. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1287. #### Unload poller module services ####
  1288.  
  1289. RRD[[0;32mupdate 192.168.0.121/poller-perf-services.rrd N:0.00010204315185547 --daemon unix:/var/run/rrdcached.sock[0m]
  1290. [[0;31mRRD Disabled[0m]### Start Device Groups ###  
  1291. SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.24ms]
  1292.  
  1293. SQL[[1;33mSELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME LIKE "%\_id" [0;33m["ports"][0m 1.49ms]
  1294.  
  1295. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,ports WHERE (( ports.device_id = devices.device_id )) && devices.device_id=? AND (devices.sysName REGEXP ".*adsl.*" || ports.portName REGEXP "adsl" ) LIMIT 1 [0;33m[259][0m 0.52ms]
  1296.  
  1297. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.sysDescr REGEXP ".*BT FTTP.*"  && devices.sysDescr REGEXP "BT FTTP" ) LIMIT 1 [0;33m[259][0m 0.52ms]
  1298.  
  1299. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.os = "IOS"  && devices.hostname != "5.159.210.4" ) LIMIT 1 [0;33m[259][0m 0.32ms]
  1300.  
  1301. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 0.93ms]
  1302.  
  1303. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*E14 9YY.*") LIMIT 1 [0;33m[259][0m 0.36ms]
  1304.  
  1305. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 0.84ms]
  1306.  
  1307. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*UB4 0SL.*") LIMIT 1 [0;33m[259][0m 0.35ms]
  1308.  
  1309. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 0.82ms]
  1310.  
  1311. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*SL1 4UF.*") LIMIT 1 [0;33m[259][0m 0.32ms]
  1312.  
  1313. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 0.76ms]
  1314.  
  1315. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*EC1V 0AB.*") LIMIT 1 [0;33m[259][0m 0.32ms]
  1316.  
  1317. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.hardware REGEXP ".*iDRAC.*") LIMIT 1 [0;33m[259][0m 0.28ms]
  1318.  
  1319. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.hostname NOT REGEXP "^5.159.208..*" && devices.hostname NOT REGEXP "^5.159.209..*" && devices.hostname NOT REGEXP "^5.159.210..*" && devices.hostname NOT REGEXP "^5.159.211..*" && devices.hostname NOT REGEXP "^5.159.212..*" && devices.hostname NOT REGEXP "^10.1.51..*" && devices.hostname NOT REGEXP "^5.159.215..*" && devices.hostname NOT REGEXP "^195.88.8..*" && devices.hostname NOT REGEXP "^195.88.9..*" && devices.hostname NOT REGEXP "^217.156.156..*" && devices.hostname NOT REGEXP "^217.156.209..*" && devices.hostname NOT REGEXP "^192.168..*" ) LIMIT 1 [0;33m[259][0m 0.47ms]
  1320.  
  1321. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.os = "pfSense") LIMIT 1 [0;33m[259][0m 0.31ms]
  1322.  
  1323. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.os = "IOS" && devices.hostname = "5.159.210.4" ) LIMIT 1 [0;33m[259][0m 0.33ms]
  1324.  
  1325. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.sysName REGEXP ".*rico.*" || devices.sysDescr REGEXP ".*rico.*" ) LIMIT 1 [0;33m[259][0m 0.31ms]
  1326.  
  1327. SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[259][0m 0.19ms]
  1328.  
  1329. Groups Added:  
  1330. Groups Removed:  
  1331. ### End Device Groups ###  
  1332. Enabling graphs: SQL[[1;33mSELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [0;33m[259][0m 0.18ms]
  1333.  
  1334. uptime netstat_snmp netstat_snmp_pkt
  1335. RRD[[0;32mupdate 192.168.0.121/ping-perf.rrd N:2.39 --daemon unix:/var/run/rrdcached.sock[0m]
  1336. [[0;31mRRD Disabled[0m]RRD[[0;32mupdate 192.168.0.121/poller-perf.rrd N:1.691 --daemon unix:/var/run/rrdcached.sock[0m]
  1337. [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m["11961771","2.39",1.691,259][0m 5.6ms]
  1338.  
  1339. Updating 192.168.0.121  
  1340.  
  1341. Polled in 1.691 seconds
  1342. #### Start Alerts ####
  1343. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[259][0m 0.51ms]
  1344.  
  1345. SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[259][0m 0.23ms]
  1346.  
  1347. SQL[[1;33mselect exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = ? and `start` <= NOW() and `end` >= NOW()) or (`recurring` = ? and (`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` = ? or `end_recurring_dt` = ?)) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), '[0;37m'), '%') or `recurring_day` is null or `recurring_day` = ?))) and ((`alert_schedulable_type` = ? and `alert_schedulable_id` = ?) or (`alert_schedulable_type` = ? and `alert_schedulable_id` in (?, ?)))) as `exists` [0;33m[0,1,"0000-00-00","","","device",259,"device_group",9,10][0m 0.73ms]
  1348.  
  1349. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  1350.   LEFT JOIN alert_device_map d ON a.id=d.rule_id
  1351.   LEFT JOIN alert_group_map g ON a.id=g.rule_id
  1352.   LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
  1353.   WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [0;33m[259,259][0m 0.28ms]
  1354.  
  1355. Rule [0;35m#1 (Devices up/down):[0m  
  1356. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[259][0m 0.38ms]
  1357.  
  1358. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,259][0m 0.24ms]
  1359.  
  1360. Status: [0;34mNOCHG[0m
  1361. Rule [0;35m#2 (Device rebooted):[0m  
  1362. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed bgpPeers.bgpPeerState = "established" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[259][0m 0.84ms]
  1363.  
  1364. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,259][0m 0.25ms]
  1365.  
  1366. Status: [0;34mNOCHG[0m
  1367. Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m  
  1368. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[259][0m 0.47ms]
  1369.  
  1370. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,259][0m 0.3ms]
  1371.  
  1372. Status: [0;34mNOCHG[0m
  1373. Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m  
  1374. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current &lt; sensors.sensor_limit_low AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[259][0m 0.62ms]
  1375.  
  1376. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,259][0m 0.24ms]
  1377.  
  1378. Status: [0;34mNOCHG[0m
  1379. Rule [0;35m#9 (Service up/down):[0m  
  1380. SQL[[1;33mSELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[259][0m 0.79ms]
  1381.  
  1382. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[9,259][0m 0.29ms]
  1383.  
  1384. Status: [0;34mNOCHG[0m
  1385. Rule [0;35m#12 (State Sensor Critical):[0m  
  1386. SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 [0;33m[259][0m 0.81ms]
  1387.  
  1388. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,259][0m 0.28ms]
  1389.  
  1390. Status: [0;34mNOCHG[0m
  1391. Rule [0;35m#13 (Device up down):[0m  
  1392. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.status = 1 [0;33m[259][0m 0.42ms]
  1393.  
  1394. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,259][0m 0.27ms]
  1395.  
  1396. Status: [0;34mNOCHGSQL[[1;33mSELECT alert_log.id, alert_log.details FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = ? && alert_log.rule_id = ? && alert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1 [0;33m[259,13][0m 0.4ms]
  1397.  
  1398. SQL[[1;33mUPDATE `alert_log` set `details`=? WHERE id = ? [0;33m[0m 8.54ms]
  1399.  
  1400. [0m
  1401. Rule [0;35m#15 (BGP Session down all):[0m  
  1402. SQL[[1;33mSELECT * FROM devices,bgpPeers WHERE (devices.device_id = ? AND devices.device_id = bgpPeers.device_id) AND bgpPeers.bgpPeerState != "established" AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[259][0m 0.55ms]
  1403.  
  1404. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,259][0m 0.4ms]
  1405.  
  1406. Status: [0;34mNOCHG[0m
  1407. #### End Alerts ####
  1408. SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"poll","doing":"192.168.0.121","start":1550745575.876,"duration":"1.939","devices":1,"poller":"UBUNTU-MONITOR"}[0m 5.64ms]
  1409.  
  1410. ./poller.php 192.168.0.121 2019-02-21 10:39:37 - 1 devices polled in 1.939 secs  
  1411. SNMP [24/0.51s]: Get[15/0.15s] Getnext[0/0.00s] Walk[9/0.35s]
  1412. MySQL [54/0.13s]: Cell[30/0.02s] Row[-27/-0.02s] Rows[34/0.02s] Column[1/0.00s] Update[14/0.09s] Insert[2/0.01s] Delete[0/0.00s]
  1413. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  1414.  


Reply to "Untitled"