Untitled

From qubic, 5 Years ago, written in Plain Text.
URL https://p.libren.ms/view/2dbef2d8
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.41ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.27ms]
  5.  
  6. SQL[[1;33mSELECT version() [0;33m[][0m 0.78ms]
  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.60.240' ORDER BY `device_id` ASC [0;33m[][0m 816.11ms]
  23.  
  24. SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[347][0m 0.23ms]
  25.  
  26. Hostname: 192.168.60.240
  27. Device ID: 347
  28. OS: zyxel-vmg
  29. Warning: inet_pton(): Unrecognized address  in /opt/librenms/includes/polling/functions.inc.php on line 249
  30.  (zyxel)
  31.  
  32. [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 192.168.60.240  
  33. array (
  34.   'xmt' => '3',
  35.   'rcv' => '3',
  36.   'loss' => '0',
  37.   'min' => '2.82',
  38.   'max' => '3.45',
  39.   'avg' => '3.05',
  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":"2.82","max":"3.45","avg":"3.05","device_id":347,"debug":"[]"}[0m 11.17ms]
  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/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
  51. .*.*.0 = 1196161539
  52. .*.*.0 =
  53. .*.*.0 =
  54. .*.*.0 = Storage Center 247360-SCV2080hayes-FYQZWM2
  55. .*.*.0 = .*.4.1.8*
  56. .*.*.0 = FreeBSD sn247361.BLADES.QUBICGROUP.NET 10.0-RELEASE-p11 FreeBSD 10.0-RELEASE-p11 #0: Mon Jun 25 17:25:29 CDT 2018     root@es-vb100-1:/work/buildmaster/r07.02.51/R*/07_02_51_004/work/buildmaster/r07.02.51/R*/src/sys/COMPELLENT amd64  
  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/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m]
  59. snmpEngineTime.0 = No Such Object available on this agent at this OID
  60. hrSystemUptime.0 = No Such Object available on this agent at this OID  
  61.  
  62. Uptime seconds: 11961615  
  63. RRD[[0;32mupdate 192.168.60.240/uptime.rrd N:11961615 --daemon unix:/var/run/rrdcached.sock[0m]
  64. [[0;31mRRD Disabled[0m]Uptime: 138 days, 10h 40m 15s
  65. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[250][0m 2.12ms]
  66.  
  67.  
  68. >> Runtime for poller module 'core': 0.0302 seconds with 506376 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.60.240/poller-perf-core.rrd N:0.030232906341553 --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.60.240/poller-perf-unix-agent.rrd N:0.00040197372436523 --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' '-OUQnt' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.890.1.15.3.1.11.0' '.1.3.6.1.4.1.890.1.15.3.1.6.0' '.1.3.6.1.4.1.890.1.15.3.1.12.0'[0m]
  90. .*.4.1.8*.1.11.0 = No Such Object available on this agent at this OID
  91. .*.4.1.8*.1.6.0 = No Such Object available on this agent at this OID
  92. .*.4.1.8*.1.12.0 = No Such Object available on this agent at this OID  
  93.  
  94. Hardware:
  95. Version:
  96. Features:
  97. Serial:
  98.  
  99. >> Runtime for poller module 'os': 0.0082 seconds with 2480 bytes
  100. >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [0/0.00s]
  101. #### Unload poller module os ####
  102.  
  103. RRD[[0;32mupdate 192.168.60.240/poller-perf-os.rrd N:0.008202075958252 --daemon unix:/var/run/rrdcached.sock[0m]
  104. [[0;31mRRD Disabled[0m]Modules status: Global+  
  105. OS  
  106. Device  
  107.  
  108. #### Load poller module ipmi ####
  109. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[347][0m 0.87ms]
  110.  
  111. array (
  112. )  
  113.  
  114. >> Runtime for poller module 'ipmi': 0.0014 seconds with 2552 bytes
  115. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  116. #### Unload poller module ipmi ####
  117.  
  118. RRD[[0;32mupdate 192.168.60.240/poller-perf-ipmi.rrd N:0.0014081001281738 --daemon unix:/var/run/rrdcached.sock[0m]
  119. [[0;31mRRD Disabled[0m]Modules status: Global+  
  120. OS  
  121. Device  
  122.  
  123. #### Load poller module sensors ####
  124. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[347][0m 0.44ms]
  125.  
  126.  
  127. >> Runtime for poller module 'sensors': 0.0009 seconds with 1464 bytes
  128. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  129. #### Unload poller module sensors ####
  130.  
  131. RRD[[0;32mupdate 192.168.60.240/poller-perf-sensors.rrd N:0.00086092948913574 --daemon unix:/var/run/rrdcached.sock[0m]
  132. [[0;31mRRD Disabled[0m]Modules status: Global+  
  133. OS  
  134. Device  
  135.  
  136. #### Load poller module processors ####
  137. Attempting to initialize OS: zyxel-vmg  
  138. Attempting to initialize OS: zyxel  
  139. OS initialized as Generic  
  140. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[347][0m 0.99ms]
  141.  
  142.  
  143. >> Runtime for poller module 'processors': 0.0033 seconds with 91448 bytes
  144. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  145. #### Unload poller module processors ####
  146.  
  147. RRD[[0;32mupdate 192.168.60.240/poller-perf-processors.rrd N:0.0032908916473389 --daemon unix:/var/run/rrdcached.sock[0m]
  148. [[0;31mRRD Disabled[0m]Modules status: Global+  
  149. OS  
  150. Device  
  151.  
  152. #### Load poller module mempools ####
  153. SQL[[1;33mSELECT * FROM mempools WHERE device_id = ? [0;33m[347][0m 0.42ms]
  154.  
  155.  
  156. >> Runtime for poller module 'mempools': 0.0008 seconds with 1720 bytes
  157. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  158. #### Unload poller module mempools ####
  159.  
  160. RRD[[0;32mupdate 192.168.60.240/poller-perf-mempools.rrd N:0.00081300735473633 --daemon unix:/var/run/rrdcached.sock[0m]
  161. [[0;31mRRD Disabled[0m]Modules status: Global+  
  162. OS  
  163. Device  
  164.  
  165. #### Load poller module storage ####
  166. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[347][0m 0.39ms]
  167.  
  168.  
  169. >> Runtime for poller module 'storage': 0.0007 seconds with 1704 bytes
  170. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  171. #### Unload poller module storage ####
  172.  
  173. RRD[[0;32mupdate 192.168.60.240/poller-perf-storage.rrd N:0.00071191787719727 --daemon unix:/var/run/rrdcached.sock[0m]
  174. [[0;31mRRD Disabled[0m]Modules status: Global+  
  175. OS  
  176. Device  
  177.  
  178. #### Load poller module netstats ####
  179.  ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'icmp'[0m]
  180. icmpInMsgs.0 = 98777
  181. icmpInErrors.0 = 128
  182. icmpInDestUnreachs.0 = 34
  183. icmpInTimeExcds.0 = 0
  184. icmpInParmProbs.0 = 0
  185. icmpInSrcQuenchs.0 = 0
  186. icmpInRedirects.0 = 0
  187. icmpInEchos.0 = 98614
  188. icmpInEchoReps.0 = 0
  189. icmpInTimestamps.0 = 0
  190. icmpInTimestampReps.0 = 0
  191. icmpInAddrMasks.0 = 0
  192. icmpInAddrMaskReps.0 = 0
  193. icmpOutMsgs.0 = 139052
  194. icmpOutErrors.0 = 0
  195. icmpOutDestUnreachs.0 = 40439
  196. icmpOutTimeExcds.0 = 0
  197. icmpOutParmProbs.0 = 0
  198. icmpOutSrcQuenchs.0 = 0
  199. icmpOutRedirects.0 = 0
  200. icmpOutEchos.0 = 0
  201. icmpOutEchoReps.0 = 98613
  202. icmpOutTimestamps.0 = 0
  203. icmpOutTimestampReps.0 = 0
  204. icmpOutAddrMasks.0 = 0
  205. icmpOutAddrMaskReps.0 = 0  
  206.  
  207. RRD[[0;32mupdate 192.168.60.240/netstats-icmp.rrd N:98777:139052:128:0:98614:0:0:98613:34:40439:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]
  208. [[0;31mRRD Disabled[0m] IPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-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]
  209.  
  210. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  211.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
  212. No Such Object available on this agent at this OID  
  213.  
  214.  SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'snmp'[0m]
  215. snmp = No Such Object available on this agent at this OID  
  216.  
  217.  TCPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-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]
  218.  
  219. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  220.  UDPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]
  221.  
  222. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  223.  
  224.  
  225. >> Runtime for poller module 'netstats': 0.0866 seconds with 2976 bytes
  226. >> SNMP: [6/0.08s] MySQL: [0/0.00s] RRD: [0/0.00s]
  227. #### Unload poller module netstats ####
  228.  
  229. RRD[[0;32mupdate 192.168.60.240/poller-perf-netstats.rrd N:0.086579084396362 --daemon unix:/var/run/rrdcached.sock[0m]
  230. [[0;31mRRD Disabled[0m]Modules status: Global+  
  231. OS  
  232. Device  
  233.  
  234. #### Load poller module hr-mib ####
  235. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  236. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  237. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  238.  
  239.  
  240.  
  241. >> Runtime for poller module 'hr-mib': 0.0165 seconds with 1472 bytes
  242. >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
  243. #### Unload poller module hr-mib ####
  244.  
  245. RRD[[0;32mupdate 192.168.60.240/poller-perf-hr-mib.rrd N:0.016503095626831 --daemon unix:/var/run/rrdcached.sock[0m]
  246. [[0;31mRRD Disabled[0m]Modules status: Global+  
  247. OS  
  248. Device  
  249.  
  250. #### Load poller module ucd-mib ####
  251. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'systemStats'[0m]
  252. systemStats = No Such Object available on this agent at this OID  
  253.  
  254. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'memTotalSwap.0' 'memAvailSwap.0' 'memTotalReal.0' 'memAvailReal.0' 'memTotalFree.0' 'memShared.0' 'memBuffer.0' 'memCached.0'[0m]
  255. memTotalSwap.0 = No Such Object available on this agent at this OID
  256. memAvailSwap.0 = No Such Object available on this agent at this OID
  257. memTotalReal.0 = No Such Object available on this agent at this OID
  258. memAvailReal.0 = No Such Object available on this agent at this OID
  259. memTotalFree.0 = No Such Object available on this agent at this OID
  260. memShared.0 = No Such Object available on this agent at this OID
  261. memBuffer.0 = No Such Object available on this agent at this OID
  262. memCached.0 = No Such Object available on this agent at this OID  
  263.  
  264. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  265. laLoadInt.1 = No Such Object available on this agent at this OID
  266. laLoadInt.2 = No Such Object available on this agent at this OID
  267. laLoadInt.3 = No Such Object available on this agent at this OID  
  268.  
  269.  
  270. >> Runtime for poller module 'ucd-mib': 0.0391 seconds with 2496 bytes
  271. >> SNMP: [3/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s]
  272. #### Unload poller module ucd-mib ####
  273.  
  274. RRD[[0;32mupdate 192.168.60.240/poller-perf-ucd-mib.rrd N:0.039093971252441 --daemon unix:/var/run/rrdcached.sock[0m]
  275. [[0;31mRRD Disabled[0m]Modules status: Global+  
  276. OS  
  277. Device  
  278.  
  279. #### Load poller module ipSystemStats ####
  280. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  281. ipSystemStatsTable = No Such Object available on this agent at this OID  
  282.  
  283.  
  284.  
  285. >> Runtime for poller module 'ipSystemStats': 0.0312 seconds with 1872 bytes
  286. >> SNMP: [1/0.03s] MySQL: [0/0.00s] RRD: [0/0.00s]
  287. #### Unload poller module ipSystemStats ####
  288.  
  289. RRD[[0;32mupdate 192.168.60.240/poller-perf-ipSystemStats.rrd N:0.031224966049194 --daemon unix:/var/run/rrdcached.sock[0m]
  290. [[0;31mRRD Disabled[0m]Modules status: Global+  
  291. OS  
  292. Device  
  293.  
  294. #### Load poller module ports ####
  295. 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[347][0m 8.3ms]
  296.  
  297. 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/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  298. ifXEntry = No Such Object available on this agent at this OID  
  299.  
  300. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ifEntry'[0m]
  301. ifIndex.1 = 1
  302. ifIndex.2 = 2
  303. ifIndex.3 = 3
  304. ifIndex.4 = 4
  305. ifDescr.1 = eth1
  306. ifDescr.2 = pf0
  307. ifDescr.3 = lo0
  308. ifDescr.4 = eth0
  309. ifType.1 = ethernetCsmacd
  310. ifType.2 = ethernetCsmacd
  311. ifType.3 = softwareLoopback
  312. ifType.4 = ethernetCsmacd
  313. ifMtu.1 = 16384
  314. ifMtu.2 = 9000
  315. ifMtu.3 = 16384
  316. ifMtu.4 = 1500
  317. ifSpeed.1 = 10000000
  318. ifSpeed.2 = 1410065408
  319. ifSpeed.3 = 0
  320. ifSpeed.4 = 1000000000
  321. ifPhysAddress.1 = 0:0:0:1:0:0
  322. ifPhysAddress.2 = 0:50:cc:7f:22:80
  323. ifPhysAddress.3 =
  324. ifPhysAddress.4 = 0:50:cc:7f:22:80
  325. ifAdminStatus.1 = up
  326. ifAdminStatus.2 = down
  327. ifAdminStatus.3 = up
  328. ifAdminStatus.4 = up
  329. ifOperStatus.1 = up
  330. ifOperStatus.2 = down
  331. ifOperStatus.3 = up
  332. ifOperStatus.4 = up
  333. ifLastChange.1 = 52577
  334. ifLastChange.2 = 0
  335. ifLastChange.3 = 0
  336. ifLastChange.4 = 3772089
  337. ifInOctets.1 = 4182532641
  338. ifInOctets.2 = 1085150169
  339. ifInOctets.3 = 1155845277
  340. ifInOctets.4 = 2904944618
  341. ifInUcastPkts.1 = 3
  342. ifInUcastPkts.2 = 618793806
  343. ifInUcastPkts.3 = 15716988
  344. ifInUcastPkts.4 = 618793835
  345. ifInNUcastPkts.1 = 0
  346. ifInNUcastPkts.2 = 0
  347. ifInNUcastPkts.3 = 0
  348. ifInNUcastPkts.4 = 0
  349. ifInDiscards.1 = 0
  350. ifInDiscards.2 = 0
  351. ifInDiscards.3 = 0
  352. ifInDiscards.4 = 0
  353. ifInErrors.1 = 0
  354. ifInErrors.2 = 21244
  355. ifInErrors.3 = 0
  356. ifInErrors.4 = 0
  357. ifInUnknownProtos.1 = 0
  358. ifInUnknownProtos.2 = 0
  359. ifInUnknownProtos.3 = 0
  360. ifInUnknownProtos.4 = 0
  361. ifOutOctets.1 = 1445518151
  362. ifOutOctets.2 = 1088987960
  363. ifOutOctets.3 = 1155845264
  364. ifOutOctets.4 = 898134408
  365. ifOutUcastPkts.1 = 0
  366. ifOutUcastPkts.2 = 32185225
  367. ifOutUcastPkts.3 = 15716987
  368. ifOutUcastPkts.4 = 31838084
  369. ifOutNUcastPkts.1 = 0
  370. ifOutNUcastPkts.2 = 0
  371. ifOutNUcastPkts.3 = 0
  372. ifOutNUcastPkts.4 = 0
  373. ifOutDiscards.1 = 0
  374. ifOutDiscards.2 = 0
  375. ifOutDiscards.3 = 0
  376. ifOutDiscards.4 = 0
  377. ifOutErrors.1 = 0
  378. ifOutErrors.2 = 0
  379. ifOutErrors.3 = 0
  380. ifOutErrors.4 = 0
  381. ifOutQLen.1 = 0
  382. ifOutQLen.2 = 0
  383. ifOutQLen.3 = 0
  384. ifOutQLen.4 = 0
  385. ifSpecific.1 = zeroDotZero
  386. ifSpecific.2 = zeroDotZero
  387. ifSpecific.3 = zeroDotZero
  388. ifSpecific.4 = zeroDotZero  
  389.  
  390. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  391. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  392.  
  393. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  394. dot1qPvid = No Such Object available on this agent at this OID  
  395.  
  396. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[347][0m 0.88ms]
  397.  
  398. array (
  399.   1 =>
  400.   array (
  401.     'ifIndex' => '1',
  402.     'ifDescr' => 'eth1',
  403.     'ifType' => 'ethernetCsmacd',
  404.     'ifMtu' => '16384',
  405.     'ifSpeed' => '10000000',
  406.     'ifPhysAddress' => '0:0:0:1:0:0',
  407.     'ifAdminStatus' => 'up',
  408.     'ifOperStatus' => 'up',
  409.     'ifLastChange' => '52577',
  410.     'ifInOctets' => '4182532641',
  411.     'ifInUcastPkts' => '3',
  412.     'ifInNUcastPkts' => '0',
  413.     'ifInDiscards' => '0',
  414.     'ifInErrors' => '0',
  415.     'ifInUnknownProtos' => '0',
  416.     'ifOutOctets' => '1445518151',
  417.     'ifOutUcastPkts' => '0',
  418.     'ifOutNUcastPkts' => '0',
  419.     'ifOutDiscards' => '0',
  420.     'ifOutErrors' => '0',
  421.     'ifOutQLen' => '0',
  422.     'ifSpecific' => 'zeroDotZero',
  423.   ),
  424.   2 =>
  425.   array (
  426.     'ifIndex' => '2',
  427.     'ifDescr' => 'pf0',
  428.     'ifType' => 'ethernetCsmacd',
  429.     'ifMtu' => '9000',
  430.     'ifSpeed' => '1410065408',
  431.     'ifPhysAddress' => '0:50:cc:7f:22:80',
  432.     'ifAdminStatus' => 'down',
  433.     'ifOperStatus' => 'down',
  434.     'ifLastChange' => '0',
  435.     'ifInOctets' => '1085150169',
  436.     'ifInUcastPkts' => '618793806',
  437.     'ifInNUcastPkts' => '0',
  438.     'ifInDiscards' => '0',
  439.     'ifInErrors' => '21244',
  440.     'ifInUnknownProtos' => '0',
  441.     'ifOutOctets' => '1088987960',
  442.     'ifOutUcastPkts' => '32185225',
  443.     'ifOutNUcastPkts' => '0',
  444.     'ifOutDiscards' => '0',
  445.     'ifOutErrors' => '0',
  446.     'ifOutQLen' => '0',
  447.     'ifSpecific' => 'zeroDotZero',
  448.   ),
  449.   3 =>
  450.   array (
  451.     'ifIndex' => '3',
  452.     'ifDescr' => 'lo0',
  453.     'ifType' => 'softwareLoopback',
  454.     'ifMtu' => '16384',
  455.     'ifSpeed' => '0',
  456.     'ifPhysAddress' => '',
  457.     'ifAdminStatus' => 'up',
  458.     'ifOperStatus' => 'up',
  459.     'ifLastChange' => '0',
  460.     'ifInOctets' => '1155845277',
  461.     'ifInUcastPkts' => '15716988',
  462.     'ifInNUcastPkts' => '0',
  463.     'ifInDiscards' => '0',
  464.     'ifInErrors' => '0',
  465.     'ifInUnknownProtos' => '0',
  466.     'ifOutOctets' => '1155845264',
  467.     'ifOutUcastPkts' => '15716987',
  468.     'ifOutNUcastPkts' => '0',
  469.     'ifOutDiscards' => '0',
  470.     'ifOutErrors' => '0',
  471.     'ifOutQLen' => '0',
  472.     'ifSpecific' => 'zeroDotZero',
  473.   ),
  474.   4 =>
  475.   array (
  476.     'ifIndex' => '4',
  477.     'ifDescr' => 'eth0',
  478.     'ifType' => 'ethernetCsmacd',
  479.     'ifMtu' => '1500',
  480.     'ifSpeed' => '1000000000',
  481.     'ifPhysAddress' => '0:50:cc:7f:22:80',
  482.     'ifAdminStatus' => 'up',
  483.     'ifOperStatus' => 'up',
  484.     'ifLastChange' => '3772089',
  485.     'ifInOctets' => '2904944618',
  486.     'ifInUcastPkts' => '618793835',
  487.     'ifInNUcastPkts' => '0',
  488.     'ifInDiscards' => '0',
  489.     'ifInErrors' => '0',
  490.     'ifInUnknownProtos' => '0',
  491.     'ifOutOctets' => '898134408',
  492.     'ifOutUcastPkts' => '31838084',
  493.     'ifOutNUcastPkts' => '0',
  494.     'ifOutDiscards' => '0',
  495.     'ifOutErrors' => '0',
  496.     'ifOutQLen' => '0',
  497.     'ifSpecific' => 'zeroDotZero',
  498.   ),
  499. )  
  500.  valid  
  501.  valid  
  502.  valid  
  503.  valid  
  504.  
  505. Port eth1: eth1 (1 / #269398) ifInOctets  
  506. ifOutOctets  
  507. ifInUcastPkts  
  508. ifOutUcastPkts  
  509. ifInBroadcastPkts  
  510. ifOutBroadcastPkts  
  511. ifInMulticastPkts  
  512. ifOutMulticastPkts  
  513. ifSpeed  
  514. VLAN =   Using ifDescr as ifAlias  
  515.  Using ifDescr as ifName  
  516. eth1
  517.  ifInOctets (2131639 B) 7129.2274247492 Bps 299 secs  
  518.  
  519.  ifOutOctets (2250218 B) 7525.8127090301 Bps 299 secs  
  520.  
  521.  ifInErrors (0 B) 0 Bps 299 secs  
  522.  
  523.  ifOutErrors (0 B) 0 Bps 299 secs  
  524.  
  525.  ifInUcastPkts (0 B) 0 Bps 299 secs  
  526.  
  527.  ifOutUcastPkts (0 B) 0 Bps 299 secs  
  528.  
  529.  ifInNUcastPkts (0 B) 0 Bps 299 secs  
  530.  
  531.  ifOutNUcastPkts (0 B) 0 Bps 299 secs  
  532.  
  533.  ifInDiscards (0 B) 0 Bps 299 secs  
  534.  
  535.  ifOutDiscards (0 B) 0 Bps 299 secs  
  536.  
  537.  ifInUnknownProtos (0 B) 0 Bps 299 secs  
  538.  
  539.  ifInBroadcastPkts (0 B) 0 Bps 299 secs  
  540.  
  541.  ifOutBroadcastPkts (0 B) 0 Bps 299 secs  
  542.  
  543.  ifInMulticastPkts (0 B) 0 Bps 299 secs  
  544.  
  545.  ifOutMulticastPkts (0 B) 0 Bps 299 secs  
  546. bps(57.03 kbps/60.21 kbps)bytes(2.03 MB/2.15 MB)pkts(0 pps/0 pps)RRD[[0;32mupdate 192.168.60.240/port-id269398.rrd N:4182532641:1445518151:0:0:3:0:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  547. [[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[1550744737,1550744438,299,"52577","4182532641",4180401002,7129.2274247492,2131639,"1445518151",1443267933,7525.8127090301,2250218,"0",0,0,0,"0",0,0,0,"3",3,0,0,"0",0,0,0,269398][0m 9.26ms]
  548.  
  549. 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,269398][0m 11ms]
  550.  
  551. 1 updated  
  552.  
  553. Port pf0: pf0 (2 / #269399) ifInOctets  
  554. ifOutOctets  
  555. ifInUcastPkts  
  556. ifOutUcastPkts  
  557. ifInBroadcastPkts  
  558. ifOutBroadcastPkts  
  559. ifInMulticastPkts  
  560. ifOutMulticastPkts  
  561. ifSpeed  
  562. VLAN =   Using ifDescr as ifAlias  
  563.  Using ifDescr as ifName  
  564. pf0
  565.  ifInOctets (2655644 B) 8881.7525083612 Bps 299 secs  
  566.  
  567.  ifOutOctets (165672 B) 554.08695652174 Bps 299 secs  
  568.  
  569.  ifInErrors (0 B) 0 Bps 299 secs  
  570.  
  571.  ifOutErrors (0 B) 0 Bps 299 secs  
  572.  
  573.  ifInUcastPkts (18072 B) 60.441471571906 Bps 299 secs  
  574.  
  575.  ifOutUcastPkts (896 B) 2.9966555183946 Bps 299 secs  
  576.  
  577.  ifInNUcastPkts (0 B) 0 Bps 299 secs  
  578.  
  579.  ifOutNUcastPkts (0 B) 0 Bps 299 secs  
  580.  
  581.  ifInDiscards (0 B) 0 Bps 299 secs  
  582.  
  583.  ifOutDiscards (0 B) 0 Bps 299 secs  
  584.  
  585.  ifInUnknownProtos (0 B) 0 Bps 299 secs  
  586.  
  587.  ifInBroadcastPkts (0 B) 0 Bps 299 secs  
  588.  
  589.  ifOutBroadcastPkts (0 B) 0 Bps 299 secs  
  590.  
  591.  ifInMulticastPkts (0 B) 0 Bps 299 secs  
  592.  
  593.  ifOutMulticastPkts (0 B) 0 Bps 299 secs  
  594. bps(71.05 kbps/4.43 kbps)bytes(2.53 MB/161.79 kB)pkts(60.44 pps/3 pps)RRD[[0;32mupdate 192.168.60.240/port-id269399.rrd N:1085150169:1088987960:21244:0:618793806:32185225:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  595. [[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[1550744737,1550744438,299,"0","1085150169",1082494525,8881.7525083612,2655644,"1088987960",1088822288,554.08695652174,165672,"21244",21244,0,0,"0",0,0,0,"618793806",618775734,60.441471571906,18072,"32185225",32184329,2.9966555183946,896,269399][0m 12.34ms]
  596.  
  597. 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,269399][0m 10.95ms]
  598.  
  599. 1 updated  
  600.  
  601. Port lo0: lo0 (3 / #269400) ifInOctets  
  602. ifOutOctets  
  603. ifInUcastPkts  
  604. ifOutUcastPkts  
  605. ifInBroadcastPkts  
  606. ifOutBroadcastPkts  
  607. ifInMulticastPkts  
  608. ifOutMulticastPkts  
  609. ifSpeed  
  610. VLAN =   Using ifDescr as ifAlias  
  611.  Using ifDescr as ifName  
  612. lo0
  613.  ifInOctets (24775 B) 82.859531772575 Bps 299 secs  
  614.  
  615.  ifOutOctets (24775 B) 82.859531772575 Bps 299 secs  
  616.  
  617.  ifInErrors (0 B) 0 Bps 299 secs  
  618.  
  619.  ifOutErrors (0 B) 0 Bps 299 secs  
  620.  
  621.  ifInUcastPkts (338 B) 1.1304347826087 Bps 299 secs  
  622.  
  623.  ifOutUcastPkts (338 B) 1.1304347826087 Bps 299 secs  
  624.  
  625.  ifInNUcastPkts (0 B) 0 Bps 299 secs  
  626.  
  627.  ifOutNUcastPkts (0 B) 0 Bps 299 secs  
  628.  
  629.  ifInDiscards (0 B) 0 Bps 299 secs  
  630.  
  631.  ifOutDiscards (0 B) 0 Bps 299 secs  
  632.  
  633.  ifInUnknownProtos (0 B) 0 Bps 299 secs  
  634.  
  635.  ifInBroadcastPkts (0 B) 0 Bps 299 secs  
  636.  
  637.  ifOutBroadcastPkts (0 B) 0 Bps 299 secs  
  638.  
  639.  ifInMulticastPkts (0 B) 0 Bps 299 secs  
  640.  
  641.  ifOutMulticastPkts (0 B) 0 Bps 299 secs  
  642. bps(663 bps/663 bps)bytes(24.19 kB/24.19 kB)pkts(1.13 pps/1.13 pps)RRD[[0;32mupdate 192.168.60.240/port-id269400.rrd N:1155845277:1155845264:0:0:15716988:15716987:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  643. [[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[1550744737,1550744438,299,"0","1155845277",1155820502,82.859531772575,24775,"1155845264",1155820489,82.859531772575,24775,"0",0,0,0,"0",0,0,0,"15716988",15716650,1.1304347826087,338,"15716987",15716649,1.1304347826087,338,269400][0m 54.37ms]
  644.  
  645. 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,269400][0m 45.48ms]
  646.  
  647. 1 updated  
  648.  
  649. Port eth0: eth0 (4 / #269401) ifInOctets  
  650. ifOutOctets  
  651. ifInUcastPkts  
  652. ifOutUcastPkts  
  653. ifInBroadcastPkts  
  654. ifOutBroadcastPkts  
  655. ifInMulticastPkts  
  656. ifOutMulticastPkts  
  657. ifSpeed  
  658. VLAN =   Using ifDescr as ifAlias  
  659.  Using ifDescr as ifName  
  660. eth0
  661.  ifInOctets (2582620 B) 8637.525083612 Bps 299 secs  
  662.  
  663.  ifOutOctets (156953 B) 524.92642140468 Bps 299 secs  
  664.  
  665.  ifInErrors (0 B) 0 Bps 299 secs  
  666.  
  667.  ifOutErrors (0 B) 0 Bps 299 secs  
  668.  
  669.  ifInUcastPkts (18066 B) 60.421404682274 Bps 299 secs  
  670.  
  671.  ifOutUcastPkts (873 B) 2.9197324414716 Bps 299 secs  
  672.  
  673.  ifInNUcastPkts (0 B) 0 Bps 299 secs  
  674.  
  675.  ifOutNUcastPkts (0 B) 0 Bps 299 secs  
  676.  
  677.  ifInDiscards (0 B) 0 Bps 299 secs  
  678.  
  679.  ifOutDiscards (0 B) 0 Bps 299 secs  
  680.  
  681.  ifInUnknownProtos (0 B) 0 Bps 299 secs  
  682.  
  683.  ifInBroadcastPkts (0 B) 0 Bps 299 secs  
  684.  
  685.  ifOutBroadcastPkts (0 B) 0 Bps 299 secs  
  686.  
  687.  ifInMulticastPkts (0 B) 0 Bps 299 secs  
  688.  
  689.  ifOutMulticastPkts (0 B) 0 Bps 299 secs  
  690. bps(69.1 kbps/4.2 kbps)bytes(2.46 MB/153.27 kB)pkts(60.42 pps/2.92 pps)RRD[[0;32mupdate 192.168.60.240/port-id269401.rrd N:2904944618:898134408:0:0:618793835:31838084:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m]
  691. [[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[1550744737,1550744438,299,"3772089","2904944618",2902361998,8637.525083612,2582620,"898134408",897977455,524.92642140468,156953,"0",0,0,0,"0",0,0,0,"618793835",618775769,60.421404682274,18066,"31838084",31837211,2.9197324414716,873,269401][0m 161.87ms]
  692.  
  693. 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,269401][0m 22.96ms]
  694.  
  695. 1 updated  
  696.  
  697.  
  698. >> Runtime for poller module 'ports': 0.4641 seconds with 37544 bytes
  699. >> SNMP: [4/0.11s] MySQL: [9/0.34s] RRD: [0/0.00s]
  700. #### Unload poller module ports ####
  701.  
  702. RRD[[0;32mupdate 192.168.60.240/poller-perf-ports.rrd N:0.4641170501709 --daemon unix:/var/run/rrdcached.sock[0m]
  703. [[0;31mRRD Disabled[0m]Modules status: Global+  
  704. OS  
  705. Device  
  706.  
  707. #### Load poller module bgp-peers ####
  708. 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[347][0m 0.54ms]
  709.  
  710.  
  711. >> Runtime for poller module 'bgp-peers': 0.0017 seconds with 11256 bytes
  712. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  713. #### Unload poller module bgp-peers ####
  714.  
  715. RRD[[0;32mupdate 192.168.60.240/poller-perf-bgp-peers.rrd N:0.0017108917236328 --daemon unix:/var/run/rrdcached.sock[0m]
  716. [[0;31mRRD Disabled[0m]Modules status: Global+  
  717. OS  
  718. Device  
  719.  
  720. #### Load poller module junose-atm-vp ####
  721. SQL[[1;33mSELECT * FROM `ports` AS P, `juniAtmVp` AS J WHERE P.`device_id` = ? AND J.port_id = P.port_id [0;33m[347][0m 1.13ms]
  722.  
  723.  
  724. >> Runtime for poller module 'junose-atm-vp': 0.0015 seconds with 2448 bytes
  725. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  726. #### Unload poller module junose-atm-vp ####
  727.  
  728. RRD[[0;32mupdate 192.168.60.240/poller-perf-junose-atm-vp.rrd N:0.0014979839324951 --daemon unix:/var/run/rrdcached.sock[0m]
  729. [[0;31mRRD Disabled[0m]Modules status: Global-  
  730. OS  
  731. Device  
  732. Module [ toner ] disabled globally.
  733.  
  734. Modules status: Global+  
  735. OS  
  736. Device  
  737.  
  738. #### Load poller module ucd-diskio ####
  739. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[347][0m 0.24ms]
  740.  
  741.  
  742. >> Runtime for poller module 'ucd-diskio': 0.0005 seconds with 1824 bytes
  743. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  744. #### Unload poller module ucd-diskio ####
  745.  
  746. RRD[[0;32mupdate 192.168.60.240/poller-perf-ucd-diskio.rrd N:0.00052499771118164 --daemon unix:/var/run/rrdcached.sock[0m]
  747. [[0;31mRRD Disabled[0m]Modules status: Global-  
  748. OS  
  749. Device  
  750. Module [ wifi ] disabled globally.
  751.  
  752. Modules status: Global+  
  753. OS  
  754. Device  
  755.  
  756. #### Load poller module wireless ####
  757. Attempting to initialize OS: zyxel-vmg  
  758. Attempting to initialize OS: zyxel  
  759. OS initialized as Generic  
  760. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[347][0m 1.03ms]
  761.  
  762.  
  763. >> Runtime for poller module 'wireless': 0.0025 seconds with 167872 bytes
  764. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  765. #### Unload poller module wireless ####
  766.  
  767. RRD[[0;32mupdate 192.168.60.240/poller-perf-wireless.rrd N:0.0025148391723633 --daemon unix:/var/run/rrdcached.sock[0m]
  768. [[0;31mRRD Disabled[0m]Modules status: Global+  
  769. OS  
  770. Device  
  771.  
  772. #### Load poller module ospf ####
  773. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[347][0m 17.93ms]
  774.  
  775.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]
  776. ospfGeneralGroup = No Such Object available on this agent at this OID  
  777.  
  778. array (
  779. )  
  780. SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[347][0m 0.46ms]
  781.  
  782. 0
  783. >> Runtime for poller module 'ospf': 0.0432 seconds with 161120 bytes
  784. >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
  785. #### Unload poller module ospf ####
  786.  
  787. RRD[[0;32mupdate 192.168.60.240/poller-perf-ospf.rrd N:0.043230056762695 --daemon unix:/var/run/rrdcached.sock[0m]
  788. [[0;31mRRD Disabled[0m]Modules status: Global+  
  789. OS  
  790. Device  
  791.  
  792. #### Load poller module cisco-ipsec-flow-monitor ####
  793.  
  794. >> Runtime for poller module 'cisco-ipsec-flow-monitor': 0.0002 seconds with 2368 bytes
  795. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  796. #### Unload poller module cisco-ipsec-flow-monitor ####
  797.  
  798. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-ipsec-flow-monitor.rrd N:0.00024986267089844 --daemon unix:/var/run/rrdcached.sock[0m]
  799. [[0;31mRRD Disabled[0m]Modules status: Global+  
  800. OS  
  801. Device  
  802.  
  803. #### Load poller module cisco-remote-access-monitor ####
  804.  
  805. >> Runtime for poller module 'cisco-remote-access-monitor': 0.0002 seconds with 600 bytes
  806. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  807. #### Unload poller module cisco-remote-access-monitor ####
  808.  
  809. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-remote-access-monitor.rrd N:0.00018310546875 --daemon unix:/var/run/rrdcached.sock[0m]
  810. [[0;31mRRD Disabled[0m]Modules status: Global+  
  811. OS  
  812. Device  
  813.  
  814. #### Load poller module cisco-cef ####
  815.  
  816. >> Runtime for poller module 'cisco-cef': 0.0004 seconds with 2104 bytes
  817. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  818. #### Unload poller module cisco-cef ####
  819.  
  820. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-cef.rrd N:0.00035786628723145 --daemon unix:/var/run/rrdcached.sock[0m]
  821. [[0;31mRRD Disabled[0m]Modules status: Global+  
  822. OS  
  823. Device  
  824.  
  825. #### Load poller module cisco-sla ####
  826. SQL[[1;33mSELECT * FROM `slas` WHERE `device_id` = ? AND `deleted` = 0 [0;33m[347][0m 1.35ms]
  827.  
  828.  
  829. >> Runtime for poller module 'cisco-sla': 0.0018 seconds with 4312 bytes
  830. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  831. #### Unload poller module cisco-sla ####
  832.  
  833. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-sla.rrd N:0.0017869472503662 --daemon unix:/var/run/rrdcached.sock[0m]
  834. [[0;31mRRD Disabled[0m]Modules status: Global+  
  835. OS  
  836. Device  
  837.  
  838. #### Load poller module cisco-mac-accounting ####
  839.  
  840. >> Runtime for poller module 'cisco-mac-accounting': 0.0004 seconds with 1064 bytes
  841. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  842. #### Unload poller module cisco-mac-accounting ####
  843.  
  844. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-mac-accounting.rrd N:0.00036191940307617 --daemon unix:/var/run/rrdcached.sock[0m]
  845. [[0;31mRRD Disabled[0m]Modules status: Global+  
  846. OS  
  847. Device  
  848.  
  849. #### Load poller module cipsec-tunnels ####
  850.  
  851. >> Runtime for poller module 'cipsec-tunnels': 0.0003 seconds with 1728 bytes
  852. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  853. #### Unload poller module cipsec-tunnels ####
  854.  
  855. RRD[[0;32mupdate 192.168.60.240/poller-perf-cipsec-tunnels.rrd N:0.00029516220092773 --daemon unix:/var/run/rrdcached.sock[0m]
  856. [[0;31mRRD Disabled[0m]Modules status: Global+  
  857. OS  
  858. Device  
  859.  
  860. #### Load poller module cisco-ace-loadbalancer ####
  861.  
  862. >> Runtime for poller module 'cisco-ace-loadbalancer': 0.0002 seconds with 968 bytes
  863. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  864. #### Unload poller module cisco-ace-loadbalancer ####
  865.  
  866. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-ace-loadbalancer.rrd N:0.00019216537475586 --daemon unix:/var/run/rrdcached.sock[0m]
  867. [[0;31mRRD Disabled[0m]Modules status: Global+  
  868. OS  
  869. Device  
  870.  
  871. #### Load poller module cisco-ace-serverfarms ####
  872.  
  873. >> Runtime for poller module 'cisco-ace-serverfarms': 0.0004 seconds with 936 bytes
  874. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  875. #### Unload poller module cisco-ace-serverfarms ####
  876.  
  877. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-ace-serverfarms.rrd N:0.0003809928894043 --daemon unix:/var/run/rrdcached.sock[0m]
  878. [[0;31mRRD Disabled[0m]Modules status: Global+  
  879. OS  
  880. Device  
  881.  
  882. #### Load poller module cisco-asa-firewall ####
  883.  
  884. >> Runtime for poller module 'cisco-asa-firewall': 0.0025 seconds with 648 bytes
  885. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  886. #### Unload poller module cisco-asa-firewall ####
  887.  
  888. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-asa-firewall.rrd N:0.0025429725646973 --daemon unix:/var/run/rrdcached.sock[0m]
  889. [[0;31mRRD Disabled[0m]Modules status: Global+  
  890. OS  
  891. Device  
  892.  
  893. #### Load poller module cisco-voice ####
  894.  
  895. >> Runtime for poller module 'cisco-voice': 0.0001 seconds with 288 bytes
  896. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  897. #### Unload poller module cisco-voice ####
  898.  
  899. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-voice.rrd N:8.0108642578125E-5 --daemon unix:/var/run/rrdcached.sock[0m]
  900. [[0;31mRRD Disabled[0m]Modules status: Global+  
  901. OS  
  902. Device  
  903.  
  904. #### Load poller module cisco-cbqos ####
  905.  
  906. >> Runtime for poller module 'cisco-cbqos': 0.0002 seconds with 1296 bytes
  907. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  908. #### Unload poller module cisco-cbqos ####
  909.  
  910. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-cbqos.rrd N:0.0002140998840332 --daemon unix:/var/run/rrdcached.sock[0m]
  911. [[0;31mRRD Disabled[0m]Modules status: Global+  
  912. OS  
  913. Device  
  914.  
  915. #### Load poller module cisco-otv ####
  916.  
  917. >> Runtime for poller module 'cisco-otv': 0.0003 seconds with 4336 bytes
  918. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  919. #### Unload poller module cisco-otv ####
  920.  
  921. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-otv.rrd N:0.00031709671020508 --daemon unix:/var/run/rrdcached.sock[0m]
  922. [[0;31mRRD Disabled[0m]Modules status: Global+  
  923. OS  
  924. Device  
  925.  
  926. #### Load poller module cisco-vpdn ####
  927.  
  928. >> Runtime for poller module 'cisco-vpdn': 0.0001 seconds with 520 bytes
  929. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  930. #### Unload poller module cisco-vpdn ####
  931.  
  932. RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-vpdn.rrd N:0.00012612342834473 --daemon unix:/var/run/rrdcached.sock[0m]
  933. [[0;31mRRD Disabled[0m]Modules status: Global-  
  934. OS  
  935. Device  
  936. Module [ nac ] disabled globally.
  937.  
  938. Modules status: Global+  
  939. OS  
  940. Device  
  941.  
  942. #### Load poller module netscaler-vsvr ####
  943.  
  944. >> Runtime for poller module 'netscaler-vsvr': 0.0003 seconds with 1560 bytes
  945. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  946. #### Unload poller module netscaler-vsvr ####
  947.  
  948. RRD[[0;32mupdate 192.168.60.240/poller-perf-netscaler-vsvr.rrd N:0.00032687187194824 --daemon unix:/var/run/rrdcached.sock[0m]
  949. [[0;31mRRD Disabled[0m]Modules status: Global+  
  950. OS  
  951. Device  
  952.  
  953. #### Load poller module aruba-controller ####
  954.  
  955. >> Runtime for poller module 'aruba-controller': 0.0007 seconds with 2616 bytes
  956. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  957. #### Unload poller module aruba-controller ####
  958.  
  959. RRD[[0;32mupdate 192.168.60.240/poller-perf-aruba-controller.rrd N:0.0007169246673584 --daemon unix:/var/run/rrdcached.sock[0m]
  960. [[0;31mRRD Disabled[0m]Modules status: Global+  
  961. OS  
  962. Device  
  963.  
  964. #### Load poller module entity-physical ####
  965. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[347][0m 0.37ms]
  966.  
  967.  
  968. >> Runtime for poller module 'entity-physical': 0.0008 seconds with 1960 bytes
  969. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  970. #### Unload poller module entity-physical ####
  971.  
  972. RRD[[0;32mupdate 192.168.60.240/poller-perf-entity-physical.rrd N:0.00084710121154785 --daemon unix:/var/run/rrdcached.sock[0m]
  973. [[0;31mRRD Disabled[0m]Modules status: Global+  
  974. OS  
  975. Device  
  976.  
  977. #### Load poller module entity-state ####
  978. 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[347][0m 0.47ms]
  979.  
  980.  
  981. >> Runtime for poller module 'entity-state': 0.0009 seconds with 2224 bytes
  982. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  983. #### Unload poller module entity-state ####
  984.  
  985. RRD[[0;32mupdate 192.168.60.240/poller-perf-entity-state.rrd N:0.00086402893066406 --daemon unix:/var/run/rrdcached.sock[0m]
  986. [[0;31mRRD Disabled[0m]Modules status: Global+  
  987. OS  
  988. Device  
  989.  
  990. #### Load poller module applications ####
  991. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[347][0m 6.37ms]
  992.  
  993.  
  994. >> Runtime for poller module 'applications': 0.0068 seconds with 1472 bytes
  995. >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [0/0.00s]
  996. #### Unload poller module applications ####
  997.  
  998. RRD[[0;32mupdate 192.168.60.240/poller-perf-applications.rrd N:0.00677490234375 --daemon unix:/var/run/rrdcached.sock[0m]
  999. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1000. OS  
  1001. Device  
  1002.  
  1003. #### Load poller module mib ####
  1004. SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [0;33m[347,"poll_mib"][0m 6.69ms]
  1005.  
  1006. MIB: polling  
  1007. SQL[[1;33mSELECT `mib`, `module` FROM device_mibs WHERE device_id = ? [0;33m[347][0m 0.34ms]
  1008.  
  1009.  
  1010.  
  1011. >> Runtime for poller module 'mib': 0.0078 seconds with 1232 bytes
  1012. >> SNMP: [0/0.00s] MySQL: [2/0.01s] RRD: [0/0.00s]
  1013. #### Unload poller module mib ####
  1014.  
  1015. RRD[[0;32mupdate 192.168.60.240/poller-perf-mib.rrd N:0.0077519416809082 --daemon unix:/var/run/rrdcached.sock[0m]
  1016. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1017. OS  
  1018. Device  
  1019.  
  1020. #### Load poller module stp ####
  1021. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[347][0m 8.49ms]
  1022.  
  1023. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
  1024. No Such Object available on this agent at this OID  
  1025.  
  1026.  
  1027.  
  1028. >> Runtime for poller module 'stp': 0.0225 seconds with 5624 bytes
  1029. >> SNMP: [1/0.01s] MySQL: [1/0.01s] RRD: [0/0.00s]
  1030. #### Unload poller module stp ####
  1031.  
  1032. RRD[[0;32mupdate 192.168.60.240/poller-perf-stp.rrd N:0.022543907165527 --daemon unix:/var/run/rrdcached.sock[0m]
  1033. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1034. OS  
  1035. Device  
  1036.  
  1037. #### Load poller module ntp ####
  1038.  
  1039. >> Runtime for poller module 'ntp': 0.0001 seconds with 320 bytes
  1040. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1041. #### Unload poller module ntp ####
  1042.  
  1043. RRD[[0;32mupdate 192.168.60.240/poller-perf-ntp.rrd N:0.0001218318939209 --daemon unix:/var/run/rrdcached.sock[0m]
  1044. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1045. OS  
  1046. Device  
  1047.  
  1048. #### Load poller module loadbalancers ####
  1049.  
  1050. >> Runtime for poller module 'loadbalancers': 0.0001 seconds with 240 bytes
  1051. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1052. #### Unload poller module loadbalancers ####
  1053.  
  1054. RRD[[0;32mupdate 192.168.60.240/poller-perf-loadbalancers.rrd N:5.2928924560547E-5 --daemon unix:/var/run/rrdcached.sock[0m]
  1055. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1056. OS  
  1057. Device  
  1058.  
  1059. #### Load poller module mef ####
  1060. MEF Links: SQL[[1;33mSELECT id, mefID, mefType, mefIdent, mefMTU, mefAdmState, mefRowState FROM mefinfo WHERE device_id = ? [0;33m[347][0m 0.86ms]
  1061.  
  1062.  
  1063.  
  1064. >> Runtime for poller module 'mef': 0.0013 seconds with 2272 bytes
  1065. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  1066. #### Unload poller module mef ####
  1067.  
  1068. RRD[[0;32mupdate 192.168.60.240/poller-perf-mef.rrd N:0.0012760162353516 --daemon unix:/var/run/rrdcached.sock[0m]
  1069. [[0;31mRRD Disabled[0m]Modules status: Global+  
  1070. OS  
  1071. Device  
  1072.  
  1073. #### Load poller module services ####
  1074.  
  1075. 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
  1076.  
  1077. 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
  1078.  
  1079. >> Runtime for poller module 'services': 0.0001 seconds with 0 bytes
  1080. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  1081. #### Unload poller module services ####
  1082.  
  1083. RRD[[0;32mupdate 192.168.60.240/poller-perf-services.rrd N:5.2928924560547E-5 --daemon unix:/var/run/rrdcached.sock[0m]
  1084. [[0;31mRRD Disabled[0m]### Start Device Groups ###  
  1085. SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.32ms]
  1086.  
  1087. SQL[[1;33mSELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME LIKE "%\_id" [0;33m["ports"][0m 1.42ms]
  1088.  
  1089. 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[347][0m 1.44ms]
  1090.  
  1091. 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[347][0m 0.44ms]
  1092.  
  1093. 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[347][0m 0.37ms]
  1094.  
  1095. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 3.5ms]
  1096.  
  1097. 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[347][0m 0.4ms]
  1098.  
  1099. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 1.41ms]
  1100.  
  1101. 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[347][0m 0.33ms]
  1102.  
  1103. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 0.97ms]
  1104.  
  1105. 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[347][0m 0.37ms]
  1106.  
  1107. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 5.96ms]
  1108.  
  1109. 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[347][0m 6.13ms]
  1110.  
  1111. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.hardware REGEXP ".*iDRAC.*") LIMIT 1 [0;33m[347][0m 0.54ms]
  1112.  
  1113. 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[347][0m 0.71ms]
  1114.  
  1115. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.os = "pfSense") LIMIT 1 [0;33m[347][0m 0.46ms]
  1116.  
  1117. 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[347][0m 0.39ms]
  1118.  
  1119. 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[347][0m 0.38ms]
  1120.  
  1121. SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[347][0m 0.28ms]
  1122.  
  1123. Groups Added:  
  1124. Groups Removed:  
  1125. ### End Device Groups ###  
  1126. Enabling graphs: SQL[[1;33mSELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [0;33m[347][0m 0.26ms]
  1127.  
  1128. uptime netstat_icmp netstat_icmp_info
  1129. RRD[[0;32mupdate 192.168.60.240/ping-perf.rrd N:3.05 --daemon unix:/var/run/rrdcached.sock[0m]
  1130. [[0;31mRRD Disabled[0m]RRD[[0;32mupdate 192.168.60.240/poller-perf.rrd N:1.874 --daemon unix:/var/run/rrdcached.sock[0m]
  1131. [[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[11961615,"3.05",1.874,347][0m 15.53ms]
  1132.  
  1133. Updating 192.168.60.240  
  1134.  
  1135. Polled in 1.874 seconds
  1136. #### Start Alerts ####
  1137. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[347][0m 0.73ms]
  1138.  
  1139. 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[347][0m 0.39ms]
  1140.  
  1141. 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",347,"device_group",12][0m 1.45ms]
  1142.  
  1143. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  1144.   LEFT JOIN alert_device_map d ON a.id=d.rule_id
  1145.   LEFT JOIN alert_group_map g ON a.id=g.rule_id
  1146.   LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
  1147.   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[347,347][0m 0.47ms]
  1148.  
  1149. Rule [0;35m#1 (Devices up/down):[0m  
  1150. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[347][0m 0.64ms]
  1151.  
  1152. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,347][0m 0.53ms]
  1153.  
  1154. Status: [0;34mNOCHG[0m
  1155. Rule [0;35m#2 (Device rebooted):[0m  
  1156. 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[347][0m 1.11ms]
  1157.  
  1158. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,347][0m 0.38ms]
  1159.  
  1160. Status: [0;34mNOCHG[0m
  1161. Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m  
  1162. 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[347][0m 0.81ms]
  1163.  
  1164. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,347][0m 0.43ms]
  1165.  
  1166. Status: [0;34mNOCHG[0m
  1167. Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m  
  1168. 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[347][0m 0.81ms]
  1169.  
  1170. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,347][0m 0.36ms]
  1171.  
  1172. Status: [0;34mNOCHG[0m
  1173. Rule [0;35m#9 (Service up/down):[0m  
  1174. 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[347][0m 0.76ms]
  1175.  
  1176. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[9,347][0m 0.38ms]
  1177.  
  1178. Status: [0;34mNOCHG[0m
  1179. Rule [0;35m#12 (State Sensor Critical):[0m  
  1180. 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[347][0m 0.97ms]
  1181.  
  1182. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,347][0m 0.38ms]
  1183.  
  1184. Status: [0;34mNOCHG[0m
  1185. Rule [0;35m#13 (Device up down):[0m  
  1186. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.status = 1 [0;33m[347][0m 0.62ms]
  1187.  
  1188. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,347][0m 0.36ms]
  1189.  
  1190. 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[347,13][0m 0.55ms]
  1191.  
  1192. SQL[[1;33mUPDATE `alert_log` set `details`=? WHERE id = ? [0;33m[0m 9.46ms]
  1193.  
  1194. [0m
  1195. Rule [0;35m#15 (BGP Session down all):[0m  
  1196. 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[347][0m 0.67ms]
  1197.  
  1198. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,347][0m 0.36ms]
  1199.  
  1200. Status: [0;34mNOCHG[0m
  1201. #### End Alerts ####
  1202. 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.60.240","start":1550744734.9573,"duration":"3.077","devices":1,"poller":"UBUNTU-MONITOR"}[0m 11.82ms]
  1203.  
  1204. ./poller.php 192.168.60.240 2019-02-21 10:25:38 - 1 devices polled in 3.077 secs  
  1205. SNMP [21/0.36s]: Get[12/0.14s] Getnext[0/0.00s] Walk[9/0.22s]
  1206. MySQL [49/1.26s]: Cell[30/0.04s] Row[-27/-0.02s] Rows[33/0.86s] Column[1/0.00s] Update[10/0.36s] Insert[2/0.02s] Delete[0/0.00s]
  1207. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  1208.  


Reply to "Untitled"