LibreNMS Pastebin service

ℹ️ Your data is safe here... unless you make the SNIP gods angry. And let's just say they have a really bad sense of humor.

Untitled

From stefan, 5 Years ago, written in Plain Text.
URL https://p.libren.ms/view/98801abb
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.61ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.25ms]
  5.  
  6. SQL[[1;33mSELECT version() [0;33m[][0m 0.15ms]
  7.  
  8. ===================================
  9. Version info:
  10. Commit SHA: 431b645303d7bd251909df30ba17016cdad32bba
  11. Commit Date: 1548952820
  12. DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
  13. PHP: 7.2.14-1+ubuntu14.04.1+deb.sury.org+1
  14. MySQL: 5.6.33-0ubuntu0.14.04.1
  15. RRDTool: 1.4.7
  16. SNMP: NET-SNMP 5.7.2
  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` = 'beamer-1001' ORDER BY `device_id` ASC [0;33m[][0m 1.59ms]
  23.  
  24. SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[25][0m 0.31ms]
  25.  
  26. Hostname: beamer-1001
  27. Device ID: 25
  28. OS: generic
  29. Warning: dns_get_record(): A temporary server error occurred. in /opt/librenms/includes/functions.php on line 1674
  30.  
  31.  
  32. [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 beamer-1001  
  33. array (
  34.   'xmt' => '3',
  35.   'rcv' => '3',
  36.   'loss' => '0',
  37.   'min' => '0.40',
  38.   'max' => '0.50',
  39.   'avg' => '0.44',
  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":"0.40","max":"0.50","avg":"0.44","device_id":25,"debug":"[]"}[0m 21.77ms]
  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' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
  51. .*.*.0 = 1999105501
  52. .*.*.0 =
  53. .*.*.0 =
  54. .*.*.0 = Raum1001
  55. .*.*.0 = .*.4.1.1248.4.1
  56. .*.*.0 = EPSON Network Projector  
  57.  
  58. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m]
  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: 19991055  
  63. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/uptime.rrd N:19991055[0m]
  64. [[0;31mRRD Disabled[0m]Uptime: 231 days, 9h 4m 15s
  65. SQL[[1;33mselect * from `locations` where `locations`.`id` is null limit 1 [0;33m[][0m 0.51ms]
  66.  
  67.  
  68. >> Runtime for poller module 'core': 0.0467 seconds with 44072 bytes
  69. >> SNMP: [2/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s]
  70. #### Unload poller module core ####
  71.  
  72. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-core.rrd N:0.046715021133423[0m]
  73. [[0;31mRRD Disabled[0m]Modules status: Global-  
  74. OS  
  75. Device  
  76. Module [ unix-agent ] disabled globally.
  77.  
  78. Modules status: Global+  
  79. OS  
  80. Device  
  81.  
  82. #### Load poller module os ####
  83. Generic :(
  84. Hardware:
  85. Version:
  86. Features:
  87. Serial:
  88.  
  89. >> Runtime for poller module 'os': 0.0003 seconds with 512 bytes
  90. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  91. #### Unload poller module os ####
  92.  
  93. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-os.rrd N:0.00029706954956055[0m]
  94. [[0;31mRRD Disabled[0m]Modules status: Global+  
  95. OS  
  96. Device  
  97.  
  98. #### Load poller module ipmi ####
  99. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[25][0m 0.53ms]
  100.  
  101. array (
  102. )  
  103.  
  104. >> Runtime for poller module 'ipmi': 0.0010 seconds with 2552 bytes
  105. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  106. #### Unload poller module ipmi ####
  107.  
  108. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-ipmi.rrd N:0.00097799301147461[0m]
  109. [[0;31mRRD Disabled[0m]Modules status: Global+  
  110. OS  
  111. Device  
  112.  
  113. #### Load poller module sensors ####
  114. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[25][0m 0.3ms]
  115.  
  116.  
  117. >> Runtime for poller module 'sensors': 0.0006 seconds with 1464 bytes
  118. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  119. #### Unload poller module sensors ####
  120.  
  121. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-sensors.rrd N:0.00057888031005859[0m]
  122. [[0;31mRRD Disabled[0m]Modules status: Global+  
  123. OS  
  124. Device  
  125.  
  126. #### Load poller module processors ####
  127. Attempting to initialize OS: generic  
  128. OS initialized: LibreNMS\OS\Generic  
  129. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[25][0m 0.28ms]
  130.  
  131.  
  132. >> Runtime for poller module 'processors': 0.0024 seconds with 156248 bytes
  133. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  134. #### Unload poller module processors ####
  135.  
  136. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-processors.rrd N:0.0023880004882812[0m]
  137. [[0;31mRRD Disabled[0m]Modules status: Global+  
  138. OS  
  139. Device  
  140.  
  141. #### Load poller module mempools ####
  142. SQL[[1;33mSELECT * FROM mempools WHERE device_id = ? [0;33m[25][0m 0.32ms]
  143.  
  144.  
  145. >> Runtime for poller module 'mempools': 0.0006 seconds with 1720 bytes
  146. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  147. #### Unload poller module mempools ####
  148.  
  149. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-mempools.rrd N:0.00064396858215332[0m]
  150. [[0;31mRRD Disabled[0m]Modules status: Global+  
  151. OS  
  152. Device  
  153.  
  154. #### Load poller module storage ####
  155. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[25][0m 0.27ms]
  156.  
  157.  
  158. >> Runtime for poller module 'storage': 0.0006 seconds with 1704 bytes
  159. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  160. #### Unload poller module storage ####
  161.  
  162. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-storage.rrd N:0.00055313110351562[0m]
  163. [[0;31mRRD Disabled[0m]Modules status: Global+  
  164. OS  
  165. Device  
  166.  
  167. #### Load poller module netstats ####
  168.  ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'icmp'[0m]
  169. icmpInMsgs.0 = 56469
  170. icmpInErrors.0 = 1
  171. icmpInDestUnreachs.0 = 271
  172. icmpInTimeExcds.0 = 0
  173. icmpInParmProbs.0 = 0
  174. icmpInSrcQuenchs.0 = 0
  175. icmpInRedirects.0 = 0
  176. icmpInEchos.0 = 56198
  177. icmpInEchoReps.0 = 0
  178. icmpInTimestamps.0 = 0
  179. icmpInTimestampReps.0 = 0
  180. icmpInAddrMasks.0 = 0
  181. icmpInAddrMaskReps.0 = 0
  182. icmpOutMsgs.0 = 56199
  183. icmpOutErrors.0 = 0
  184. icmpOutDestUnreachs.0 = 1
  185. icmpOutTimeExcds.0 = 0
  186. icmpOutParmProbs.0 = 0
  187. icmpOutSrcQuenchs.0 = 0
  188. icmpOutRedirects.0 = 0
  189. icmpOutEchos.0 = 0
  190. icmpOutEchoReps.0 = 56198
  191. icmpOutTimestamps.0 = 0
  192. icmpOutTimestampReps.0 = 0
  193. icmpOutAddrMasks.0 = 0
  194. icmpOutAddrMaskReps.0 = 0  
  195.  
  196. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/netstats-icmp.rrd N:56469:56199:1:0:56198:0:0:56198:271:1:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0[0m]
  197. [[0;31mRRD Disabled[0m] IPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m]
  198.  
  199. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  200.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
  201. No Such Object available on this agent at this OID  
  202.  
  203.  SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmp'[0m]
  204.  
  205. Timeout: No Response from udp:beamer-1001:161  
  206.  TCPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m]
  207.  
  208. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  209.  UDPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]
  210.  
  211. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  212.  
  213.  
  214. >> Runtime for poller module 'netstats': 6.1415 seconds with 3560 bytes
  215. >> SNMP: [6/6.14s] MySQL: [0/0.00s] RRD: [0/0.00s]
  216. #### Unload poller module netstats ####
  217.  
  218. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-netstats.rrd N:6.1415140628815[0m]
  219. [[0;31mRRD Disabled[0m]Modules status: Global+  
  220. OS  
  221. Device  
  222.  
  223. #### Load poller module hr-mib ####
  224. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  225. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  226. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  227.  
  228.  
  229.  
  230. >> Runtime for poller module 'hr-mib': 0.0216 seconds with 1480 bytes
  231. >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
  232. #### Unload poller module hr-mib ####
  233.  
  234. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-hr-mib.rrd N:0.021631002426147[0m]
  235. [[0;31mRRD Disabled[0m]Modules status: Global+  
  236. OS  
  237. Device  
  238.  
  239. #### Load poller module ucd-mib ####
  240. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m]
  241. systemStats = No more variables left in this MIB View (It is past the end of the MIB tree)  
  242.  
  243. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'memTotalSwap.0' 'memAvailSwap.0' 'memTotalReal.0' 'memAvailReal.0' 'memTotalFree.0' 'memShared.0' 'memBuffer.0' 'memCached.0'[0m]
  244. memTotalSwap.0 = No Such Object available on this agent at this OID
  245. memAvailSwap.0 = No Such Object available on this agent at this OID
  246. memTotalReal.0 = No Such Object available on this agent at this OID
  247. memAvailReal.0 = No Such Object available on this agent at this OID
  248. memTotalFree.0 = No Such Object available on this agent at this OID
  249. memShared.0 = No Such Object available on this agent at this OID
  250. memBuffer.0 = No Such Object available on this agent at this OID
  251. memCached.0 = No Such Object available on this agent at this OID  
  252.  
  253. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  254. laLoadInt.1 = No Such Object available on this agent at this OID
  255. laLoadInt.2 = No Such Object available on this agent at this OID
  256. laLoadInt.3 = No Such Object available on this agent at this OID  
  257.  
  258.  
  259. >> Runtime for poller module 'ucd-mib': 0.0682 seconds with 2464 bytes
  260. >> SNMP: [3/0.07s] MySQL: [0/0.00s] RRD: [0/0.00s]
  261. #### Unload poller module ucd-mib ####
  262.  
  263. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-ucd-mib.rrd N:0.068233966827393[0m]
  264. [[0;31mRRD Disabled[0m]Modules status: Global+  
  265. OS  
  266. Device  
  267.  
  268. #### Load poller module ipSystemStats ####
  269. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  270. ipSystemStatsTable = No Such Object available on this agent at this OID  
  271.  
  272.  
  273.  
  274. >> Runtime for poller module 'ipSystemStats': 0.0277 seconds with 1880 bytes
  275. >> SNMP: [1/0.03s] MySQL: [0/0.00s] RRD: [0/0.00s]
  276. #### Unload poller module ipSystemStats ####
  277.  
  278. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-ipSystemStats.rrd N:0.027691841125488[0m]
  279. [[0;31mRRD Disabled[0m]Modules status: Global+  
  280. OS  
  281. Device  
  282.  
  283. #### Load poller module ports ####
  284. 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[25][0m 1.98ms]
  285.  
  286. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  287.  
  288. Timeout: No Response from udp:beamer-1001:161  
  289. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m]
  290. ifIndex.1 = 1
  291. ifIndex.2 = 2
  292. ifDescr.1 = lo
  293. ifDescr.2 = eth0
  294. ifType.1 = softwareLoopback
  295. ifType.2 = ethernetCsmacd
  296. ifMtu.1 = 16436
  297. ifMtu.2 = 1500
  298. ifSpeed.1 = 10000000
  299. ifSpeed.2 = 100000000
  300. ifPhysAddress.1 = 0:0:0:0:0:0
  301. ifPhysAddress.2 = 64:eb:8c:d8:76:c0
  302. ifAdminStatus.1 = up
  303. ifAdminStatus.2 = up
  304. ifOperStatus.1 = up
  305. ifOperStatus.2 = up
  306. ifLastChange.1 = 0
  307. ifLastChange.2 = 0
  308. ifInOctets.1 = 4294967295
  309. ifInOctets.2 = 58174658
  310. ifInUcastPkts.1 = 249245351
  311. ifInUcastPkts.2 = 57135671
  312. ifInNUcastPkts.1 = 0
  313. ifInNUcastPkts.2 = 0
  314. ifInDiscards.1 = 0
  315. ifInDiscards.2 = 9667901
  316. ifInErrors.1 = 0
  317. ifInErrors.2 = 0
  318. ifInUnknownProtos.1 = 0
  319. ifInUnknownProtos.2 = 0
  320. ifOutOctets.1 = 4294967295
  321. ifOutOctets.2 = 1206099745
  322. ifOutUcastPkts.1 = 249245351
  323. ifOutUcastPkts.2 = 4654029
  324. ifOutNUcastPkts.1 = 0
  325. ifOutNUcastPkts.2 = 0
  326. ifOutDiscards.1 = 0
  327. ifOutDiscards.2 = 0
  328. ifOutErrors.1 = 0
  329. ifOutErrors.2 = 0  
  330. Timeout: No Response from udp:beamer-1001:161  
  331. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  332.  
  333. Timeout: No Response from udp:beamer-1001:161  
  334. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  335.  
  336. Timeout: No Response from udp:beamer-1001:161  
  337. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[25][0m 2.26ms]
  338.  
  339. array (
  340.   1 =>
  341.   array (
  342.     'ifIndex' => '1',
  343.     'ifDescr' => 'lo',
  344.     'ifType' => 'softwareLoopback',
  345.     'ifMtu' => '16436',
  346.     'ifSpeed' => '10000000',
  347.     'ifPhysAddress' => '0:0:0:0:0:0',
  348.     'ifAdminStatus' => 'up',
  349.     'ifOperStatus' => 'up',
  350.     'ifLastChange' => '0',
  351.     'ifInOctets' => '4294967295',
  352.     'ifInUcastPkts' => '249245351',
  353.     'ifInNUcastPkts' => '0',
  354.     'ifInDiscards' => '0',
  355.     'ifInErrors' => '0',
  356.     'ifInUnknownProtos' => '0',
  357.     'ifOutOctets' => '4294967295',
  358.     'ifOutUcastPkts' => '249245351',
  359.     'ifOutNUcastPkts' => '0',
  360.     'ifOutDiscards' => '0',
  361.     'ifOutErrors' => '0',
  362.   ),
  363.   2 =>
  364.   array (
  365.     'ifIndex' => '2',
  366.     'ifDescr' => 'eth0',
  367.     'ifType' => 'ethernetCsmacd',
  368.     'ifMtu' => '1500',
  369.     'ifSpeed' => '100000000',
  370.     'ifPhysAddress' => '64:eb:8c:d8:76:c0',
  371.     'ifAdminStatus' => 'up',
  372.     'ifOperStatus' => 'up',
  373.     'ifLastChange' => '0',
  374.     'ifInOctets' => '58174658',
  375.     'ifInUcastPkts' => '57135671',
  376.     'ifInNUcastPkts' => '0',
  377.     'ifInDiscards' => '9667901',
  378.     'ifInErrors' => '0',
  379.     'ifInUnknownProtos' => '0',
  380.     'ifOutOctets' => '1206099745',
  381.     'ifOutUcastPkts' => '4654029',
  382.     'ifOutNUcastPkts' => '0',
  383.     'ifOutDiscards' => '0',
  384.     'ifOutErrors' => '0',
  385.   ),
  386. )  
  387.  valid  
  388.  valid  
  389.  
  390. Port lo: lo (1 / #194) ifInOctets  
  391. ifOutOctets  
  392. ifInUcastPkts  
  393. ifOutUcastPkts  
  394. ifInBroadcastPkts  
  395. ifOutBroadcastPkts  
  396. ifInMulticastPkts  
  397. ifOutMulticastPkts  
  398. ifSpeed  
  399. VLAN =   Using ifDescr as ifAlias  
  400.  Using ifDescr as ifName  
  401. lo
  402.  ifInOctets (0 B) 0 Bps 137 secs  
  403.  
  404.  ifOutOctets (0 B) 0 Bps 137 secs  
  405.  
  406.  ifInErrors (0 B) 0 Bps 137 secs  
  407.  
  408.  ifOutErrors (0 B) 0 Bps 137 secs  
  409.  
  410.  ifInUcastPkts (3652 B) 26.656934306569 Bps 137 secs  
  411.  
  412.  ifOutUcastPkts (3652 B) 26.656934306569 Bps 137 secs  
  413.  
  414.  ifInNUcastPkts (0 B) 0 Bps 137 secs  
  415.  
  416.  ifOutNUcastPkts (0 B) 0 Bps 137 secs  
  417.  
  418.  ifInDiscards (0 B) 0 Bps 137 secs  
  419.  
  420.  ifOutDiscards (0 B) 0 Bps 137 secs  
  421.  
  422.  ifInUnknownProtos (0 B) 0 Bps 137 secs  
  423.  
  424.  ifInBroadcastPkts (0 B) 0 Bps 137 secs  
  425.  
  426.  ifOutBroadcastPkts (0 B) 0 Bps 137 secs  
  427.  
  428.  ifInMulticastPkts (0 B) 0 Bps 137 secs  
  429.  
  430.  ifOutMulticastPkts (0 B) 0 Bps 137 secs  
  431. bps(0 bps/0 bps)bytes(0 B/0 B)pkts(26.66 pps/26.66 pps)RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/port-id194.rrd N:4294967295:4294967295:0:0:249245351:249245351:0:0:0:0:0:U:U:U:U[0m]
  432. [[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[1549375680,1549375543,137,"0","4294967295",4294967295,0,0,"4294967295",4294967295,0,0,"0",0,0,0,"0",0,0,0,"249245351",249241699,26.656934306569344,3652,"249245351",249241699,26.656934306569344,3652,194][0m 27.51ms]
  433.  
  434. 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,194][0m 29.82ms]
  435.  
  436. 1 updated  
  437.  
  438. Port eth0: eth0 (2 / #195) ifInOctets  
  439. ifOutOctets  
  440. ifInUcastPkts  
  441. ifOutUcastPkts  
  442. ifInBroadcastPkts  
  443. ifOutBroadcastPkts  
  444. ifInMulticastPkts  
  445. ifOutMulticastPkts  
  446. ifSpeed  
  447. VLAN =   Using ifDescr as ifAlias  
  448.  Using ifDescr as ifName  
  449. eth0
  450.  ifInOctets (30491 B) 222.56204379562 Bps 137 secs  
  451.  
  452.  ifOutOctets (15848 B) 115.67883211679 Bps 137 secs  
  453.  
  454.  ifInErrors (0 B) 0 Bps 137 secs  
  455.  
  456.  ifOutErrors (0 B) 0 Bps 137 secs  
  457.  
  458.  ifInUcastPkts (409 B) 2.985401459854 Bps 137 secs  
  459.  
  460.  ifOutUcastPkts (60 B) 0.43795620437956 Bps 137 secs  
  461.  
  462.  ifInNUcastPkts (0 B) 0 Bps 137 secs  
  463.  
  464.  ifOutNUcastPkts (0 B) 0 Bps 137 secs  
  465.  
  466.  ifInDiscards (66 B) 0.48175182481752 Bps 137 secs  
  467.  
  468.  ifOutDiscards (0 B) 0 Bps 137 secs  
  469.  
  470.  ifInUnknownProtos (0 B) 0 Bps 137 secs  
  471.  
  472.  ifInBroadcastPkts (0 B) 0 Bps 137 secs  
  473.  
  474.  ifOutBroadcastPkts (0 B) 0 Bps 137 secs  
  475.  
  476.  ifInMulticastPkts (0 B) 0 Bps 137 secs  
  477.  
  478.  ifOutMulticastPkts (0 B) 0 Bps 137 secs  
  479. bps(1.78 kbps/925 bps)bytes(29.78 kB/15.48 kB)pkts(2.99 pps/0.44 pps)RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/port-id195.rrd N:58174658:1206099745:0:0:57135671:4654029:0:0:9667901:0:0:U:U:U:U[0m]
  480. [[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[1549375680,1549375543,137,"0","58174658",58144167,222.56204379562044,30491,"1206099745",1206083897,115.67883211678833,15848,"0",0,0,0,"0",0,0,0,"57135671",57135262,2.9854014598540144,409,"4654029",4653969,0.43795620437956206,60,195][0m 19.15ms]
  481.  
  482. 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,"9667901",9667835,0.48175182481751827,66,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,195][0m 23.81ms]
  483.  
  484. 2 updated  
  485.  
  486.  
  487. >> Runtime for poller module 'ports': 24.2383 seconds with 43120 bytes
  488. >> SNMP: [4/24.12s] MySQL: [5/0.10s] RRD: [0/0.00s]
  489. #### Unload poller module ports ####
  490.  
  491. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-ports.rrd N:24.2383248806[0m]
  492. [[0;31mRRD Disabled[0m]Modules status: Global+  
  493. OS  
  494. Device  
  495.  
  496. #### Load poller module bgp-peers ####
  497. 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[25][0m 0.56ms]
  498.  
  499.  
  500. >> Runtime for poller module 'bgp-peers': 0.0020 seconds with 11224 bytes
  501. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  502. #### Unload poller module bgp-peers ####
  503.  
  504. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-bgp-peers.rrd N:0.0020120143890381[0m]
  505. [[0;31mRRD Disabled[0m]Modules status: Global-  
  506. OS  
  507. Device  
  508. Module [ junose-atm-vp ] disabled globally.
  509.  
  510. Modules status: Global-  
  511. OS  
  512. Device  
  513. Module [ toner ] disabled globally.
  514.  
  515. Modules status: Global+  
  516. OS  
  517. Device  
  518.  
  519. #### Load poller module ucd-diskio ####
  520. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[25][0m 0.27ms]
  521.  
  522.  
  523. >> Runtime for poller module 'ucd-diskio': 0.0006 seconds with 1824 bytes
  524. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  525. #### Unload poller module ucd-diskio ####
  526.  
  527. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-ucd-diskio.rrd N:0.00057601928710938[0m]
  528. [[0;31mRRD Disabled[0m]Modules status: Global-  
  529. OS  
  530. Device  
  531. Module [ wifi ] disabled globally.
  532.  
  533. Modules status: Global+  
  534. OS  
  535. Device  
  536.  
  537. #### Load poller module wireless ####
  538. Attempting to initialize OS: generic  
  539. OS initialized: LibreNMS\OS\Generic  
  540. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[25][0m 0.34ms]
  541.  
  542.  
  543. >> Runtime for poller module 'wireless': 0.0020 seconds with 102344 bytes
  544. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  545. #### Unload poller module wireless ####
  546.  
  547. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-wireless.rrd N:0.0020360946655273[0m]
  548. [[0;31mRRD Disabled[0m]Modules status: Global+  
  549. OS  
  550. Device  
  551.  
  552. #### Load poller module ospf ####
  553. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[25][0m 0.57ms]
  554.  
  555.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]
  556.  
  557. Timeout: No Response from udp:beamer-1001:161  
  558. array (
  559. )  
  560. SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[25][0m 0.56ms]
  561.  
  562. 0
  563. >> Runtime for poller module 'ospf': 6.0345 seconds with 160368 bytes
  564. >> SNMP: [1/6.03s] MySQL: [0/0.00s] RRD: [0/0.00s]
  565. #### Unload poller module ospf ####
  566.  
  567. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-ospf.rrd N:6.0344870090485[0m]
  568. [[0;31mRRD Disabled[0m]Modules status: Global-  
  569. OS  
  570. Device  
  571. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  572.  
  573. Modules status: Global-  
  574. OS  
  575. Device  
  576. Module [ cisco-remote-access-monitor ] disabled globally.
  577.  
  578. Modules status: Global-  
  579. OS  
  580. Device  
  581. Module [ cisco-cef ] disabled globally.
  582.  
  583. Modules status: Global-  
  584. OS  
  585. Device  
  586. Module [ cisco-sla ] disabled globally.
  587.  
  588. Modules status: Global-  
  589. OS  
  590. Device  
  591. Module [ cisco-mac-accounting ] disabled globally.
  592.  
  593. Modules status: Global-  
  594. OS  
  595. Device  
  596. Module [ cipsec-tunnels ] disabled globally.
  597.  
  598. Modules status: Global-  
  599. OS  
  600. Device  
  601. Module [ cisco-ace-loadbalancer ] disabled globally.
  602.  
  603. Modules status: Global-  
  604. OS  
  605. Device  
  606. Module [ cisco-ace-serverfarms ] disabled globally.
  607.  
  608. Modules status: Global-  
  609. OS  
  610. Device  
  611. Module [ cisco-asa-firewall ] disabled globally.
  612.  
  613. Modules status: Global-  
  614. OS  
  615. Device  
  616. Module [ cisco-voice ] disabled globally.
  617.  
  618. Modules status: Global-  
  619. OS  
  620. Device  
  621. Module [ cisco-cbqos ] disabled globally.
  622.  
  623. Modules status: Global-  
  624. OS  
  625. Device  
  626. Module [ cisco-otv ] disabled globally.
  627.  
  628. Modules status: Global-  
  629. OS  
  630. Device  
  631. Module [ cisco-vpdn ] disabled globally.
  632.  
  633. Modules status: Global-  
  634. OS  
  635. Device  
  636. Module [ nac ] disabled globally.
  637.  
  638. Modules status: Global-  
  639. OS  
  640. Device  
  641. Module [ netscaler-vsvr ] disabled globally.
  642.  
  643. Modules status: Global-  
  644. OS  
  645. Device  
  646. Module [ aruba-controller ] disabled globally.
  647.  
  648. Modules status: Global+  
  649. OS  
  650. Device  
  651.  
  652. #### Load poller module entity-physical ####
  653. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[25][0m 0.39ms]
  654.  
  655.  
  656. >> Runtime for poller module 'entity-physical': 0.0008 seconds with 1960 bytes
  657. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  658. #### Unload poller module entity-physical ####
  659.  
  660. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-entity-physical.rrd N:0.00082612037658691[0m]
  661. [[0;31mRRD Disabled[0m]Modules status: Global-  
  662. OS  
  663. Device  
  664. Module [ entity-state ] disabled globally.
  665.  
  666. Modules status: Global+  
  667. OS  
  668. Device  
  669.  
  670. #### Load poller module applications ####
  671. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[25][0m 0.26ms]
  672.  
  673.  
  674. >> Runtime for poller module 'applications': 0.0005 seconds with 1472 bytes
  675. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  676. #### Unload poller module applications ####
  677.  
  678. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-applications.rrd N:0.00049400329589844[0m]
  679. [[0;31mRRD Disabled[0m]Modules status: Global-  
  680. OS  
  681. Device  
  682. Module [ mib ] disabled globally.
  683.  
  684. Modules status: Global+  
  685. OS  
  686. Device  
  687.  
  688. #### Load poller module stp ####
  689. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[25][0m 0.28ms]
  690.  
  691. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
  692. No Such Object available on this agent at this OID  
  693.  
  694.  
  695.  
  696. >> Runtime for poller module 'stp': 0.0324 seconds with 5624 bytes
  697. >> SNMP: [1/0.03s] MySQL: [1/0.00s] RRD: [0/0.00s]
  698. #### Unload poller module stp ####
  699.  
  700. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-stp.rrd N:0.032397985458374[0m]
  701. [[0;31mRRD Disabled[0m]Modules status: Global+  
  702. OS  
  703. Device  
  704.  
  705. #### Load poller module ntp ####
  706.  
  707. >> Runtime for poller module 'ntp': 0.0003 seconds with 320 bytes
  708. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  709. #### Unload poller module ntp ####
  710.  
  711. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf-ntp.rrd N:0.00025391578674316[0m]
  712. [[0;31mRRD Disabled[0m]Modules status: Global-  
  713. OS  
  714. Device  
  715. Module [ loadbalancers ] disabled globally.
  716.  
  717. Modules status: Global-  
  718. OS  
  719. Device  
  720. Module [ mef ] disabled globally.
  721.  
  722. ### Start Device Groups ###  
  723. SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.68ms]
  724.  
  725. SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[25][0m 0.32ms]
  726.  
  727. Groups Added:  
  728. Groups Removed:  
  729. ### End Device Groups ###  
  730. Enabling graphs: SQL[[1;33mSELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [0;33m[25][0m 0.3ms]
  731.  
  732. uptime netstat_icmp netstat_icmp_info
  733. RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/ping-perf.rrd N:0.44[0m]
  734. [[0;31mRRD Disabled[0m]RRD[[0;32mupdate /opt/librenms/rrd/beamer-1001/poller-perf.rrd N:47.728[0m]
  735. [[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[19991055,"0.44",47.728,25][0m 27.14ms]
  736.  
  737. Updating beamer-1001  
  738.  
  739. Polled in 47.728 seconds
  740. #### Start Alerts ####
  741. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[25][0m 0.41ms]
  742.  
  743. 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[25][0m 0.39ms]
  744.  
  745. 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 0 = 1))) as `exists` [0;33m[0,1,"0000-00-00","","","device",25,"device_group"][0m 0.74ms]
  746.  
  747. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  748.   LEFT JOIN alert_device_map d ON a.id=d.rule_id
  749.   LEFT JOIN alert_group_map g ON a.id=g.rule_id
  750.   LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
  751.   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[25,25][0m 11.79ms]
  752.  
  753. #### End Alerts ####
  754. 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":"beamer-1001","start":1549375639.140339,"duration":"48.08","devices":1,"poller":"management"}[0m 22.77ms]
  755.  
  756. ./poller.php beamer-1001 2019-02-05 15:08:07 - 1 devices polled in 48.08 secs  
  757. SNMP [20/36.51s]: Get[11/0.25s] Getnext[0/0.00s] Walk[9/36.26s]
  758. MySQL [24/0.20s]: Cell[2/0.00s] Row[-1/-0.00s] Rows[15/0.03s] Column[1/0.00s] Update[5/0.13s] Insert[2/0.05s] Delete[0/0.00s]
  759. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  760.  

Reply to "Untitled"

captcha