From Forensic Hummingbird, 1 Year ago, written in Plain Text.
Embed
  1. LibreNMS Poller
  2. ===================================
  3. Version info:
  4. Commit SHA: 386fea0321a86b197d302629a04d20d480828d6d
  5. Commit Date: 1525034560
  6. DB Schema: 249
  7. PHP: 7.0.28-0ubuntu0.16.04.1
  8. MySQL: 10.0.34-MariaDB-0ubuntu0.16.04.1
  9. RRDTool: 1.5.5
  10. SNMP: NET-SNMP 5.7.3
  11. ==================================DEBUG!
  12. Updating os_def.cache... Done
  13. Starting polling run:
  14.  
  15. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.115.0.32' ORDER BY `device_id` ASC]
  16. SQL[SELECT * FROM devices_attribs WHERE `device_id` = '1430']
  17. Hostname: 10.115.0.32
  18. Device ID: 1430
  19. OS: generic
  20.  
  21. SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('5','5','0','0.69','0.87','0.78','1430',NOW())]
  22. SNMP Check response code: 0
  23. Modules status: Global+ OS  Device  
  24. #### Load poller module core ####
  25. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUt -m SNMPv2-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0]
  26. .*.*.0 = 50748596
  27. .*.*.0 =
  28. .*.*.0 =
  29. .*.*.0 = FortiWeb
  30. .*.*.0 = .*.4.1.123*007
  31. .*.*.0 = FortiwebAz
  32.  
  33. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0]
  34. snmpEngineTime.0 = No Such Object available on this agent at this OID
  35. hrSystemUptime.0 = No Such Object available on this agent at this OID
  36.  
  37. Uptime seconds: 507486
  38. RRD[update /opt/librenms/rrd/10.115.0.32/uptime.rrd N:507486]
  39. [RRD Disabled]Uptime: 5 days, 20h 58m 6s
  40.  
  41. >> Runtime for poller module 'core': 0.0218 seconds with 15560 bytes
  42. >> SNMP: [2/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
  43. #### Unload poller module core ####
  44.  
  45. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-core.rrd N:0.021833896636963]
  46. [RRD Disabled]Modules status: Global- OS  Device  Module [ unix-agent ] disabled globally.
  47.  
  48. Modules status: Global+ OS  Device  
  49. #### Load poller module os ####
  50. Generic :(
  51. Hardware:
  52. Version:
  53. Features:
  54. Serial:
  55.  
  56. >> Runtime for poller module 'os': 0.0002 seconds with 512 bytes
  57. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  58. #### Unload poller module os ####
  59.  
  60. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-os.rrd N:0.00018310546875]
  61. [RRD Disabled]Modules status: Global+ OS  Device  
  62. #### Load poller module ipmi ####
  63. SQL[SELECT * FROM sensors WHERE device_id = '1430' AND poller_type='ipmi']
  64. Array
  65. (
  66. )
  67.  
  68. >> Runtime for poller module 'ipmi': 0.0004 seconds with 2384 bytes
  69. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  70. #### Unload poller module ipmi ####
  71.  
  72. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ipmi.rrd N:0.00038003921508789]
  73. [RRD Disabled]Modules status: Global+ OS  Device  
  74. #### Load poller module sensors ####
  75. SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = '1430' GROUP BY `sensor_class`]
  76.  
  77. >> Runtime for poller module 'sensors': 0.0002 seconds with 1336 bytes
  78. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  79. #### Unload poller module sensors ####
  80.  
  81. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-sensors.rrd N:0.00018620491027832]
  82. [RRD Disabled]Modules status: Global+ OS  Device  
  83. #### Load poller module processors ####
  84. Attempting to initialize OS: generic
  85. OS initialized: LibreNMS\OS\Generic
  86. SQL[SELECT * FROM processors WHERE device_id='1430']
  87.  
  88. >> Runtime for poller module 'processors': 0.0015 seconds with 155008 bytes
  89. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  90. #### Unload poller module processors ####
  91.  
  92. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-processors.rrd N:0.0015389919281006]
  93. [RRD Disabled]Modules status: Global+ OS  Device  
  94. #### Load poller module mempools ####
  95. SQL[SELECT * FROM mempools WHERE device_id = '1430']
  96.  
  97. >> Runtime for poller module 'mempools': 0.0003 seconds with 1760 bytes
  98. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  99. #### Unload poller module mempools ####
  100.  
  101. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-mempools.rrd N:0.00030398368835449]
  102. [RRD Disabled]Modules status: Global+ OS  Device  
  103. #### Load poller module storage ####
  104. SQL[SELECT * FROM storage WHERE device_id = '1430']
  105.  
  106. >> Runtime for poller module 'storage': 0.0003 seconds with 1824 bytes
  107. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  108. #### Unload poller module storage ####
  109.  
  110. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-storage.rrd N:0.0002751350402832]
  111. [RRD Disabled]Modules status: Global+ OS  Device  
  112. #### Load poller module netstats ####
  113.  ICMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 icmp]
  114. icmpInMsgs.0 = 164
  115. icmpInErrors.0 = 0
  116. icmpInDestUnreachs.0 = 0
  117. icmpInTimeExcds.0 = 118
  118. icmpInParmProbs.0 = 0
  119. icmpInSrcQuenchs.0 = 0
  120. icmpInRedirects.0 = 0
  121. icmpInEchos.0 = 0
  122. icmpInEchoReps.0 = 46
  123. icmpInTimestamps.0 = 0
  124. icmpInTimestampReps.0 = 0
  125. icmpInAddrMasks.0 = 0
  126. icmpInAddrMaskReps.0 = 0
  127. icmpOutMsgs.0 = 0
  128. icmpOutErrors.0 = 56
  129. icmpOutDestUnreachs.0 = 0
  130. icmpOutTimeExcds.0 = 10
  131. icmpOutParmProbs.0 = 0
  132. icmpOutSrcQuenchs.0 = 0
  133. icmpOutRedirects.0 = 0
  134. icmpOutEchos.0 = 0
  135. icmpOutEchoReps.0 = 0
  136. icmpOutTimestamps.0 = 46
  137. icmpOutTimestampReps.0 = 0
  138. icmpOutAddrMasks.0 = 0
  139. icmpOutAddrMaskReps.0 = 0
  140.  
  141. RRD[update /opt/librenms/rrd/10.115.0.32/netstats-icmp.rrd N:164:0:0:56:0:0:46:0:0:0:0:118:0:0:0:0:0:0:10:0:0:0:46:0:0:0]
  142. [RRD Disabled] IPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs -t 2 -r 5 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]
  143. ipForwDatagrams.0 = 0
  144. ipInDelivers.0 = 6271831
  145. ipInReceives.0 = 6271831
  146. ipOutRequests.0 = 4661948
  147. ipInDiscards.0 = 0
  148. ipOutDiscards.0 = 0
  149. ipOutNoRoutes.0 = 16
  150. ipReasmReqds.0 = 0
  151. ipReasmOKs.0 = 0
  152. ipReasmFails.0 = 0
  153. ipFragOKs.0 = 0
  154. ipFragFails.0 = 0
  155. ipFragCreates.0 = 0
  156. ipInUnknownProtos.0 = 0
  157. ipInHdrErrors.0 = 0
  158. ipInAddrErrors.0 = 0
  159.  
  160. RRD[update /opt/librenms/rrd/10.115.0.32/netstats-ip.rrd N:0:6271831:6271831:4661948:0:0:16:0:0:0:0:0:0:0:0:0]
  161. [RRD Disabled] IP-FORWARDSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQv -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 IP-FORWARD-MIB::ipCidrRouteNumber.0]
  162. No Such Instance currently exists at this OID
  163.  
  164.  SNMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m SNMPv2-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 snmp]
  165. snmp = No Such Object available on this agent at this OID
  166.  
  167.  TCPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m TCP-MIB -M /opt/librenms/mibs -t 2 -r 5 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]
  168. tcpActiveOpens.0 = 276654
  169. tcpPassiveOpens.0 = 19240
  170. tcpAttemptFails.0 = 203057
  171. tcpEstabResets.0 = 4598
  172. tcpCurrEstab.0 = 43
  173. tcpInSegs.0 = 6192322
  174. tcpOutSegs.0 = 5692835
  175. tcpRetransSegs.0 = 63477
  176. tcpInErrs.0 = 0
  177. tcpOutRsts.0 = 204393
  178. tcpHCInSegs.0 = No Such Object available on this agent at this OID
  179. tcpHCOutSegs.0 = No Such Object available on this agent at this OID
  180.  
  181. RRD[update /opt/librenms/rrd/10.115.0.32/netstats-tcp.rrd N:276654:19240:203057:4598:43:6192322:5692835:63477:0:204393]
  182. [RRD Disabled] UDPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UDP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161  UDP-MIB::udpInDatagrams.0 UDP-MIB::udpOutDatagrams.0 UDP-MIB::udpInErrors.0 UDP-MIB::udpNoPorts.0]
  183. udpInDatagrams.0 = 83568
  184. udpOutDatagrams.0 = 83631
  185. udpInErrors.0 = 0
  186. udpNoPorts.0 = 10
  187.  
  188. RRD[update /opt/librenms/rrd/10.115.0.32/netstats-udp.rrd N:83568:83631:0:10]
  189. [RRD Disabled]
  190.  
  191. >> Runtime for poller module 'netstats': 0.1186 seconds with 14888 bytes
  192. >> SNMP: [6/0.12s] MySQL: [0/0.00s] RRD: [0/0.00s]
  193. #### Unload poller module netstats ####
  194.  
  195. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-netstats.rrd N:0.11859703063965]
  196. [RRD Disabled]Modules status: Global+ OS  Device  
  197. #### Load poller module hr-mib ####
  198. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 hrSystemProcesses.0 hrSystemNumUsers.0]
  199. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  200. hrSystemNumUsers.0 = No Such Object available on this agent at this OID
  201.  
  202.  
  203.  
  204. >> Runtime for poller module 'hr-mib': 0.0108 seconds with 1584 bytes
  205. >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [0/0.00s]
  206. #### Unload poller module hr-mib ####
  207.  
  208. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-hr-mib.rrd N:0.010780096054077]
  209. [RRD Disabled]Modules status: Global+ OS  Device  
  210. #### Load poller module ucd-mib ####
  211. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 systemStats]
  212. systemStats = No Such Object available on this agent at this OID
  213.  
  214. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 memTotalSwap.0 memAvailSwap.0 memTotalReal.0 memAvailReal.0 memTotalFree.0 memShared.0 memBuffer.0 memCached.0]
  215. memTotalSwap.0 = No Such Object available on this agent at this OID
  216. memAvailSwap.0 = No Such Object available on this agent at this OID
  217. memTotalReal.0 = No Such Object available on this agent at this OID
  218. memAvailReal.0 = No Such Object available on this agent at this OID
  219. memTotalFree.0 = No Such Object available on this agent at this OID
  220. memShared.0 = No Such Object available on this agent at this OID
  221. memBuffer.0 = No Such Object available on this agent at this OID
  222. memCached.0 = No Such Object available on this agent at this OID
  223.  
  224. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 laLoadInt.1 laLoadInt.2 laLoadInt.3]
  225. laLoadInt.1 = No Such Object available on this agent at this OID
  226. laLoadInt.2 = No Such Object available on this agent at this OID
  227. laLoadInt.3 = No Such Object available on this agent at this OID
  228.  
  229.  
  230. >> Runtime for poller module 'ucd-mib': 0.0366 seconds with 2792 bytes
  231. >> SNMP: [3/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s]
  232. #### Unload poller module ucd-mib ####
  233.  
  234. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ucd-mib.rrd N:0.036607980728149]
  235. [RRD Disabled]Modules status: Global+ OS  Device  
  236. #### Load poller module ipSystemStats ####
  237. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 ipSystemStats]
  238. ipSystemStatsTable = No Such Instance currently exists at this OID
  239.  
  240.  
  241.  
  242. >> Runtime for poller module 'ipSystemStats': 0.0143 seconds with 1920 bytes
  243. >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [0/0.00s]
  244. #### Unload poller module ipSystemStats ####
  245.  
  246. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ipSystemStats.rrd N:0.014273166656494]
  247. [RRD Disabled]Modules status: Global+ OS  Device  
  248. #### Load poller module ports ####
  249. Caching Oids: Select ports pollingSQL[SELECT * FROM `ports` where `device_id` = '1430' AND `deleted` = 0 AND `disabled` = 0]
  250. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 ifName.1 ifAlias.1 ifDescr.1 ifHighSpeed.1 ifOperStatus.1 ifAdminStatus.1]
  251. ifName.1 = port1
  252. ifAlias.1 = port1
  253. ifDescr.1 = port1
  254. ifHighSpeed.1 = 0
  255. ifOperStatus.1 = up
  256. ifAdminStatus.1 = up
  257.  
  258. validSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 ifSpeed.1 ifInOctets.1 ifInUcastPkts.1 ifInUnknownProtos.1 ifOutOctets.1 ifOutUcastPkts.1 ifInErrors.1 ifOutErrors.1 ifInNUcastPkts.1 ifOutNUcastPkts.1 ifInDiscards.1 ifOutDiscards.1 ifPhysAddress.1 ifLastChange.1 ifType.1 ifMtu.1]
  259. ifSpeed.1 = 1048576000
  260. ifInOctets.1 = 288574448
  261. ifInUcastPkts.1 = 5467853
  262. ifInUnknownProtos.1 = 0
  263. ifOutOctets.1 = 4170045242
  264. ifOutUcastPkts.1 = 3931974
  265. ifInErrors.1 = 0
  266. ifOutErrors.1 = 0
  267. ifInNUcastPkts.1 = 0
  268. ifOutNUcastPkts.1 = 0
  269. ifInDiscards.1 = 0
  270. ifOutDiscards.1 = 0
  271. ifPhysAddress.1 = 0:d:3a:37:ee:ad
  272. ifLastChange.1 = 0
  273. ifType.1 = ethernetCsmacd
  274. ifMtu.1 = 1500
  275.  
  276. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m EtherLike-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 dot3StatsIndex.1 dot3StatsDuplexStatus.1]
  277. dot3StatsIndex.1 = 1
  278. dot3StatsDuplexStatus.1 = 0
  279.  
  280. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 ifName.2 ifAlias.2 ifDescr.2 ifHighSpeed.2 ifOperStatus.2 ifAdminStatus.2]
  281. ifName.2 = port2
  282. ifAlias.2 = port2
  283. ifDescr.2 = port2
  284. ifHighSpeed.2 = 0
  285. ifOperStatus.2 = up
  286. ifAdminStatus.2 = up
  287.  
  288. validSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 ifSpeed.2 ifInOctets.2 ifInUcastPkts.2 ifInUnknownProtos.2 ifOutOctets.2 ifOutUcastPkts.2 ifInErrors.2 ifOutErrors.2 ifInNUcastPkts.2 ifOutNUcastPkts.2 ifInDiscards.2 ifOutDiscards.2 ifPhysAddress.2 ifLastChange.2 ifType.2 ifMtu.2]
  289. ifSpeed.2 = 1048576000
  290. ifInOctets.2 = 45163874
  291. ifInUcastPkts.2 = 409537
  292. ifInUnknownProtos.2 = 0
  293. ifOutOctets.2 = 326357125
  294. ifOutUcastPkts.2 = 335675
  295. ifInErrors.2 = 0
  296. ifOutErrors.2 = 0
  297. ifInNUcastPkts.2 = 0
  298. ifOutNUcastPkts.2 = 0
  299. ifInDiscards.2 = 12
  300. ifOutDiscards.2 = 0
  301. ifPhysAddress.2 = 0:d:3a:38:28:5c
  302. ifLastChange.2 = 0
  303. ifType.2 = ethernetCsmacd
  304. ifMtu.2 = 1500
  305.  
  306. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUst -m EtherLike-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 dot3StatsIndex.2 dot3StatsDuplexStatus.2]
  307. dot3StatsIndex.2 = 2
  308. dot3StatsDuplexStatus.2 = 0
  309.  
  310. SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '1430' AND `ifType` = 'adsl']
  311. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 dot1qPvid]
  312. dot1qPvid = No Such Object available on this agent at this OID
  313.  
  314. Array
  315. (
  316.     [1] => Array
  317.         (
  318.             [ifName] => port1
  319.             [ifAlias] => port1
  320.             [ifDescr] => port1
  321.             [ifHighSpeed] => 0
  322.             [ifOperStatus] => up
  323.             [ifAdminStatus] => up
  324.             [ifSpeed] => 1048576000
  325.             [ifInOctets] => 288574448
  326.             [ifInUcastPkts] => 5467853
  327.             [ifInUnknownProtos] => 0
  328.             [ifOutOctets] => 4170045242
  329.             [ifOutUcastPkts] => 3931974
  330.             [ifInErrors] => 0
  331.             [ifOutErrors] => 0
  332.             [ifInNUcastPkts] => 0
  333.             [ifOutNUcastPkts] => 0
  334.             [ifInDiscards] => 0
  335.             [ifOutDiscards] => 0
  336.             [ifPhysAddress] => 0:d:3a:37:ee:ad
  337.             [ifLastChange] => 0
  338.             [ifType] => ethernetCsmacd
  339.             [ifMtu] => 1500
  340.             [dot3StatsIndex] => 1
  341.             [dot3StatsDuplexStatus] => 0
  342.         )
  343.  
  344.     [2] => Array
  345.         (
  346.             [ifName] => port2
  347.             [ifAlias] => port2
  348.             [ifDescr] => port2
  349.             [ifHighSpeed] => 0
  350.             [ifOperStatus] => up
  351.             [ifAdminStatus] => up
  352.             [ifSpeed] => 1048576000
  353.             [ifInOctets] => 45163874
  354.             [ifInUcastPkts] => 409537
  355.             [ifInUnknownProtos] => 0
  356.             [ifOutOctets] => 326357125
  357.             [ifOutUcastPkts] => 335675
  358.             [ifInErrors] => 0
  359.             [ifOutErrors] => 0
  360.             [ifInNUcastPkts] => 0
  361.             [ifOutNUcastPkts] => 0
  362.             [ifInDiscards] => 12
  363.             [ifOutDiscards] => 0
  364.             [ifPhysAddress] => 0:d:3a:38:28:5c
  365.             [ifLastChange] => 0
  366.             [ifType] => ethernetCsmacd
  367.             [ifMtu] => 1500
  368.             [dot3StatsIndex] => 2
  369.             [dot3StatsDuplexStatus] => 0
  370.         )
  371.  
  372. )
  373. SQL[SELECT `name` FROM `port_association_mode` WHERE pom_id = '1']
  374. SQL[SELECT *, `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` = '1430' ORDER BY ports.port_id]
  375. validvalid
  376. Port port1: port1 (1 / #8790) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed dot3Duplex VLAN == port1
  377.  ifInOctets (0 B) 0 Bps 11 secs
  378.  
  379.  ifOutOctets (0 B) 0 Bps 11 secs
  380.  
  381.  ifInErrors (0 B) 0 Bps 11 secs
  382.  
  383.  ifOutErrors (0 B) 0 Bps 11 secs
  384.  
  385.  ifInUcastPkts (0 B) 0 Bps 11 secs
  386.  
  387.  ifOutUcastPkts (0 B) 0 Bps 11 secs
  388.  
  389.  ifInNUcastPkts (0 B) 0 Bps 11 secs
  390.  
  391.  ifOutNUcastPkts (0 B) 0 Bps 11 secs
  392.  
  393.  ifInDiscards (0 B) 0 Bps 11 secs
  394.  
  395.  ifOutDiscards (0 B) 0 Bps 11 secs
  396.  
  397.  ifInUnknownProtos (0 B) 0 Bps 11 secs
  398.  
  399.  ifInBroadcastPkts (0 B) 0 Bps 11 secs
  400.  
  401.  ifOutBroadcastPkts (0 B) 0 Bps 11 secs
  402.  
  403.  ifInMulticastPkts (0 B) 0 Bps 11 secs
  404.  
  405.  ifOutMulticastPkts (0 B) 0 Bps 11 secs
  406. bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[update /opt/librenms/rrd/10.115.0.32/port-id8790.rrd N:288574448:4170045242:0:0:5467853:3931974:0:0:0:0:0:U:U:U:U]
  407. [RRD Disabled]SQL[UPDATE `ports` set `poll_time` ='1525274351',`poll_prev` ='1525274340',`poll_period` ='11',`ifLastChange` ='0',`ifInOctets` ='288574448',`ifInOctets_prev` ='288574448',`ifInOctets_rate` ='0',`ifInOctets_delta` ='0',`ifOutOctets` ='4170045242',`ifOutOctets_prev` ='4170045242',`ifOutOctets_rate` ='0',`ifOutOctets_delta` ='0',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='5467853',`ifInUcastPkts_prev` ='5467853',`ifInUcastPkts_rate` ='0',`ifInUcastPkts_delta` ='0',`ifOutUcastPkts` ='3931974',`ifOutUcastPkts_prev` ='3931974',`ifOutUcastPkts_rate` ='0',`ifOutUcastPkts_delta` ='0' WHERE `port_id` = '8790']
  408. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts` ='0',`ifInNUcastPkts_prev` ='0',`ifInNUcastPkts_rate` ='0',`ifInNUcastPkts_delta` ='0',`ifOutNUcastPkts` ='0',`ifOutNUcastPkts_prev` ='0',`ifOutNUcastPkts_rate` ='0',`ifOutNUcastPkts_delta` ='0',`ifInDiscards` ='0',`ifInDiscards_prev` ='0',`ifInDiscards_rate` ='0',`ifInDiscards_delta` ='0',`ifOutDiscards` ='0',`ifOutDiscards_prev` ='0',`ifOutDiscards_rate` ='0',`ifOutDiscards_delta` ='0',`ifInUnknownProtos` ='0',`ifInUnknownProtos_prev` ='0',`ifInUnknownProtos_rate` ='0',`ifInUnknownProtos_delta` ='0',`ifInBroadcastPkts` ='0',`ifInBroadcastPkts_prev` ='0',`ifInBroadcastPkts_rate` ='0',`ifInBroadcastPkts_delta` ='0',`ifOutBroadcastPkts` ='0',`ifOutBroadcastPkts_prev` ='0',`ifOutBroadcastPkts_rate` ='0',`ifOutBroadcastPkts_delta` ='0',`ifInMulticastPkts` ='0',`ifInMulticastPkts_prev` ='0',`ifInMulticastPkts_rate` ='0',`ifInMulticastPkts_delta` ='0',`ifOutMulticastPkts` ='0',`ifOutMulticastPkts_prev` ='0',`ifOutMulticastPkts_rate` ='0',`ifOutMulticastPkts
  409. _delta` ='0' WHERE `port_id` = '8790']
  410. 1 updated
  411. Port port2: port2 (2 / #8791) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed dot3Duplex VLAN == port2
  412.  ifInOctets (19723 B) 1793 Bps 11 secs
  413.  
  414.  ifOutOctets (42567 B) 3869.7272727273 Bps 11 secs
  415.  
  416.  ifInErrors (0 B) 0 Bps 11 secs
  417.  
  418.  ifOutErrors (0 B) 0 Bps 11 secs
  419.  
  420.  ifInUcastPkts (200 B) 18.181818181818 Bps 11 secs
  421.  
  422.  ifOutUcastPkts (200 B) 18.181818181818 Bps 11 secs
  423.  
  424.  ifInNUcastPkts (0 B) 0 Bps 11 secs
  425.  
  426.  ifOutNUcastPkts (0 B) 0 Bps 11 secs
  427.  
  428.  ifInDiscards (0 B) 0 Bps 11 secs
  429.  
  430.  ifOutDiscards (0 B) 0 Bps 11 secs
  431.  
  432.  ifInUnknownProtos (0 B) 0 Bps 11 secs
  433.  
  434.  ifInBroadcastPkts (0 B) 0 Bps 11 secs
  435.  
  436.  ifOutBroadcastPkts (0 B) 0 Bps 11 secs
  437.  
  438.  ifInMulticastPkts (0 B) 0 Bps 11 secs
  439.  
  440.  ifOutMulticastPkts (0 B) 0 Bps 11 secs
  441. bps(14.340kbps/30.960kbps)bytes(19.260kB/41.570kB)pkts(18.180pps/18.180pps)RRD[update /opt/librenms/rrd/10.115.0.32/port-id8791.rrd N:45163874:326357125:0:0:409537:335675:0:0:12:0:0:U:U:U:U]
  442. [RRD Disabled]SQL[UPDATE `ports` set `poll_time` ='1525274351',`poll_prev` ='1525274340',`poll_period` ='11',`ifLastChange` ='0',`ifInOctets` ='45163874',`ifInOctets_prev` ='45144151',`ifInOctets_rate` ='1793',`ifInOctets_delta` ='19723',`ifOutOctets` ='326357125',`ifOutOctets_prev` ='326314558',`ifOutOctets_rate` ='3869.7272727273',`ifOutOctets_delta` ='42567',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='409537',`ifInUcastPkts_prev` ='409337',`ifInUcastPkts_rate` ='18.181818181818',`ifInUcastPkts_delta` ='200',`ifOutUcastPkts` ='335675',`ifOutUcastPkts_prev` ='335475',`ifOutUcastPkts_rate` ='18.181818181818',`ifOutUcastPkts_delta` ='200' WHERE `port_id` = '8791']
  443. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts` ='0',`ifInNUcastPkts_prev` ='0',`ifInNUcastPkts_rate` ='0',`ifInNUcastPkts_delta` ='0',`ifOutNUcastPkts` ='0',`ifOutNUcastPkts_prev` ='0',`ifOutNUcastPkts_rate` ='0',`ifOutNUcastPkts_delta` ='0',`ifInDiscards` ='12',`ifInDiscards_prev` ='12',`ifInDiscards_rate` ='0',`ifInDiscards_delta` ='0',`ifOutDiscards` ='0',`ifOutDiscards_prev` ='0',`ifOutDiscards_rate` ='0',`ifOutDiscards_delta` ='0',`ifInUnknownProtos` ='0',`ifInUnknownProtos_prev` ='0',`ifInUnknownProtos_rate` ='0',`ifInUnknownProtos_delta` ='0',`ifInBroadcastPkts` ='0',`ifInBroadcastPkts_prev` ='0',`ifInBroadcastPkts_rate` ='0',`ifInBroadcastPkts_delta` ='0',`ifOutBroadcastPkts` ='0',`ifOutBroadcastPkts_prev` ='0',`ifOutBroadcastPkts_rate` ='0',`ifOutBroadcastPkts_delta` ='0',`ifInMulticastPkts` ='0',`ifInMulticastPkts_prev` ='0',`ifInMulticastPkts_rate` ='0',`ifInMulticastPkts_delta` ='0',`ifOutMulticastPkts` ='0',`ifOutMulticastPkts_prev` ='0',`ifOutMulticastPkts_rate` ='0',`ifOutMulticastPk
  444. ts_delta` ='0' WHERE `port_id` = '8791']
  445. 1 updated
  446.  
  447. >> Runtime for poller module 'ports': 0.1177 seconds with 67424 bytes
  448. >> SNMP: [7/0.08s] MySQL: [8/0.03s] RRD: [0/0.00s]
  449. #### Unload poller module ports ####
  450.  
  451. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ports.rrd N:0.11772203445435]
  452. [RRD Disabled]Modules status: Global+ OS  Device  
  453. #### Load poller module bgp-peers ####
  454. SQL[SELECT * FROM bgpPeers WHERE device_id = '1430']
  455.  
  456. >> Runtime for poller module 'bgp-peers': 0.0008 seconds with 13312 bytes
  457. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  458. #### Unload poller module bgp-peers ####
  459.  
  460. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-bgp-peers.rrd N:0.00084805488586426]
  461. [RRD Disabled]Modules status: Global- OS  Device  Module [ junose-atm-vp ] disabled globally.
  462.  
  463. Modules status: Global- OS  Device  Module [ toner ] disabled globally.
  464.  
  465. Modules status: Global+ OS  Device  
  466. #### Load poller module ucd-diskio ####
  467. SQL[SELECT * FROM `ucd_diskio` WHERE `device_id`  = '1430']
  468.  
  469. >> Runtime for poller module 'ucd-diskio': 0.0003 seconds with 1856 bytes
  470. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  471. #### Unload poller module ucd-diskio ####
  472.  
  473. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ucd-diskio.rrd N:0.00028109550476074]
  474. [RRD Disabled]Modules status: Global- OS  Device  Module [ wifi ] disabled globally.
  475.  
  476. Modules status: Global+ OS  Device  
  477. #### Load poller module wireless ####
  478. Attempting to initialize OS: generic
  479. OS initialized: LibreNMS\OS\Generic
  480. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = '1430']
  481.  
  482. >> Runtime for poller module 'wireless': 0.0010 seconds with 98760 bytes
  483. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  484. #### Unload poller module wireless ####
  485.  
  486. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-wireless.rrd N:0.0010440349578857]
  487. [RRD Disabled]Modules status: Global+ OS  Device  
  488. #### Load poller module ospf ####
  489. Processes: SQL[SELECT * FROM `ospf_instances` WHERE `device_id` = '1430' AND `context_name` = '']
  490. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 OSPF-MIB::ospfGeneralGroup]
  491. ospfGeneralGroup = No Such Object available on this agent at this OID
  492.  
  493.  
  494. Polled: Array
  495. (
  496. )
  497. Database:  Areas: SQL[SELECT * FROM `ospf_areas` WHERE `device_id` = '1430' AND `context_name`= '']
  498. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 OSPF-MIB::ospfAreaEntry]
  499. ospfAreaEntry = No Such Object available on this agent at this OID
  500.  
  501.  
  502. Polled: Array
  503. (
  504. )
  505. Database:  Ports: SQL[SELECT * FROM `ospf_ports` WHERE `device_id` = '1430' AND `context_name` = '']
  506. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 OSPF-MIB::ospfIfEntry]
  507. ospfIfEntry = No Such Object available on this agent at this OID
  508.  
  509.  
  510. Polled: Array
  511. (
  512. )
  513. Database:  Neighbours: SQL[SELECT * FROM `ospf_nbrs` WHERE `device_id` = '1430' AND `context_name` = '']
  514. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 OSPF-MIB::ospfNbrEntry]
  515. ospfNbrEntry = No Such Object available on this agent at this OID
  516.  
  517.  
  518. Polled: Array
  519. (
  520. )
  521. Database:
  522. RRD[update /opt/librenms/rrd/10.115.0.32/ospf-statistics.rrd N:0:0:0:0]
  523. [RRD Disabled]
  524.  
  525. >> Runtime for poller module 'ospf': 0.0513 seconds with 6992 bytes
  526. >> SNMP: [4/0.05s] MySQL: [4/0.00s] RRD: [0/0.00s]
  527. #### Unload poller module ospf ####
  528.  
  529. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ospf.rrd N:0.051262140274048]
  530. [RRD Disabled]Modules status: Global- OS  Device  Module [ cisco-ipsec-flow-monitor ] disabled globally.
  531.  
  532. Modules status: Global- OS  Device  Module [ cisco-remote-access-monitor ] disabled globally.
  533.  
  534. Modules status: Global- OS  Device  Module [ cisco-cef ] disabled globally.
  535.  
  536. Modules status: Global- OS  Device  Module [ cisco-sla ] disabled globally.
  537.  
  538. Modules status: Global- OS  Device  Module [ cisco-mac-accounting ] disabled globally.
  539.  
  540. Modules status: Global- OS  Device  Module [ cipsec-tunnels ] disabled globally.
  541.  
  542. Modules status: Global- OS  Device  Module [ cisco-ace-loadbalancer ] disabled globally.
  543.  
  544. Modules status: Global- OS  Device  Module [ cisco-ace-serverfarms ] disabled globally.
  545.  
  546. Modules status: Global- OS  Device  Module [ cisco-asa-firewall ] disabled globally.
  547.  
  548. Modules status: Global- OS  Device  Module [ cisco-voice ] disabled globally.
  549.  
  550. Modules status: Global- OS  Device  Module [ cisco-cbqos ] disabled globally.
  551.  
  552. Modules status: Global- OS  Device  Module [ cisco-otv ] disabled globally.
  553.  
  554. Modules status: Global- OS  Device  Module [ cisco-vpdn ] disabled globally.
  555.  
  556. Modules status: Global- OS  Device  Module [ netscaler-vsvr ] disabled globally.
  557.  
  558. Modules status: Global- OS  Device  Module [ aruba-controller ] disabled globally.
  559.  
  560. Modules status: Global+ OS  Device  
  561. #### Load poller module entity-physical ####
  562. SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = '1430']
  563.  
  564. >> Runtime for poller module 'entity-physical': 0.0004 seconds with 1944 bytes
  565. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  566. #### Unload poller module entity-physical ####
  567.  
  568. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-entity-physical.rrd N:0.00040698051452637]
  569. [RRD Disabled]Modules status: Global- OS  Device  Module [ entity-state ] disabled globally.
  570.  
  571. Modules status: Global+ OS  Device  
  572. #### Load poller module applications ####
  573. SQL[SELECT * FROM `applications` WHERE `device_id`  = '1430']
  574.  
  575. >> Runtime for poller module 'applications': 0.0003 seconds with 1512 bytes
  576. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  577. #### Unload poller module applications ####
  578.  
  579. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-applications.rrd N:0.00027203559875488]
  580. [RRD Disabled]Modules status: Global- OS  Device  Module [ mib ] disabled globally.
  581.  
  582. Modules status: Global+ OS  Device  
  583. #### Load poller module stp ####
  584. SQL[SELECT * FROM `stp` WHERE `device_id` = '1430']
  585. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs -t 2 -r 5 udp:HOSTNAME:161 dot1dStpProtocolSpecification.0]
  586. No Such Object available on this agent at this OID
  587.  
  588.  
  589.  
  590. >> Runtime for poller module 'stp': 0.0109 seconds with 5720 bytes
  591. >> SNMP: [1/0.01s] MySQL: [1/0.00s] RRD: [0/0.00s]
  592. #### Unload poller module stp ####
  593.  
  594. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-stp.rrd N:0.010910034179688]
  595. [RRD Disabled]Modules status: Global+ OS  Device  
  596. #### Load poller module ntp ####
  597.  
  598. >> Runtime for poller module 'ntp': 0.0001 seconds with 176 bytes
  599. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  600. #### Unload poller module ntp ####
  601.  
  602. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-ntp.rrd N:9.2983245849609E-5]
  603. [RRD Disabled]Modules status: Global+ OS  Device  
  604. #### Load poller module services ####
  605.  
  606. >> Runtime for poller module 'services': 0.0000 seconds with 0 bytes
  607. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  608. #### Unload poller module services ####
  609.  
  610. RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf-services.rrd N:3.6001205444336E-5]
  611. [RRD Disabled]Modules status: Global- OS  Device  Module [ loadbalancers ] disabled globally.
  612.  
  613. Modules status: Global- OS  Device  Module [ mef ] disabled globally.
  614.  
  615. ### Start Device Groups ###
  616. SQL[SELECT * FROM device_groups ORDER BY name]
  617. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-aa" ) LIMIT 1]
  618. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "pti-ach" || devices.sysName REGEXP "civ-ach" ) LIMIT 1]
  619. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "pti-anz" || devices.sysName REGEXP "civ-anz" ) LIMIT 1]
  620. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "pti-at-" || devices.sysName REGEXP "civ-at-" || devices.sysName REGEXP "civ-ath-" ) LIMIT 1]
  621. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName = "civeo-austin-mpls.civeo.local" ) LIMIT 1]
  622. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName = "civeo-bellechase-mpls.civeo.local" || devices.sysName REGEXP "civ-bel-" ) LIMIT 1]
  623. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-bog" ) LIMIT 1]
  624. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "pti-br" || devices.sysName REGEXP "civ-brp-" || devices.sysName REGEXP "pti-brp-" ) LIMIT 1]
  625. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-bne-" ) LIMIT 1]
  626. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "pti-clg" || devices.sysName REGEXP "civ-clg" ) LIMIT 1]
  627. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-hou-cl49" || devices.sysName REGEXP "civeo-houston-mpls.civeo.local" ) LIMIT 1]
  628. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysname REGEXP "pti-ckl" || devices.sysName REGEXP "civ-ckl" ) LIMIT 1]
  629. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-cbl-" ) LIMIT 1]
  630. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-da" ) LIMIT 1]
  631. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-dic-" ) LIMIT 1]
  632. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-dys-" ) LIMIT 1]
  633. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "pti-edm" || devices.sysName REGEXP "civ-edm-co-" ) LIMIT 1]
  634. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-kam" ) LIMIT 1]
  635. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-kar-" ) LIMIT 1]
  636. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "PTI-KID-" || devices.sysName REGEXP "pti-kid-" || devices.sysName REGEXP "civ-kid-" ) LIMIT 1]
  637. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-scr-" || devices.sysName REGEXP "civeo-longmont-mpls.civeo.local" ) LIMIT 1]
  638. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-mrl" ) LIMIT 1]
  639. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "pti-mcl" ) LIMIT 1]
  640. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-mnt" ) LIMIT 1]
  641. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-mbh" ) LIMIT 1]
  642. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-nbi" ) LIMIT 1]
  643. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-neb" ) LIMIT 1]
  644. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-nsl" ) LIMIT 1]
  645. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-sea-" || devices.sysName REGEXP "civeo-mpls-telus" ) LIMIT 1]
  646. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-syd" ) LIMIT 1]
  647. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-bdr" ) LIMIT 1]
  648. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-ver-ut-" ) LIMIT 1]
  649. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "pti-wpe" || devices.sysName REGEXP "civ-wpe" ) LIMIT 1]
  650. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "pti-wpm" || devices.sysName REGEXP "civ-wpm" ) LIMIT 1]
  651. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysname REGEXP "pti-wpw" || devices.sysName REGEXP "civ-wpw" ) LIMIT 1]
  652. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='1430' AND (devices.sysName REGEXP "civ-pc-" ) LIMIT 1]
  653. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='1430']
  654. Groups Added:
  655. Groups Removed:
  656. ### End Device Groups ###
  657. SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = '1430']
  658. uptime netstat_icmp netstat_icmp_info netstat_ip netstat_ip_frag netstat_tcp netstat_udp
  659. RRD[update /opt/librenms/rrd/10.115.0.32/ping-perf.rrd N:0.78]
  660. [RRD Disabled]RRD[update /opt/librenms/rrd/10.115.0.32/poller-perf.rrd N:4.867]
  661. [RRD Disabled]Polled in 4.867 seconds
  662. Updating 10.115.0.32
  663. SQL[UPDATE `devices` set `uptime` ='507486',`last_ping` =NOW(),`last_ping_timetaken` ='0.78',`last_polled` =NOW(),`last_polled_timetaken` ='4.867' WHERE `device_id` = '1430']
  664. UPDATED!
  665. #### Start Alerts ####
  666. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='1430']
  667. SQL[SELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '1430' ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '--%d') AND (end_recurring_dt >= date_format(NOW(), '--%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), ''),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1]
  668. SQL[SELECT DISTINCT a.* FROM alert_rules a  LEFT JOIN alert_device_map d ON a.id=d.rule_id  LEFT JOIN alert_group_map g ON a.id=g.rule_id  LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id  WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id='1430' OR dg.device_id='1430')]
  669. Rule #1 (Device Down):
  670. SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '1430' ORDER BY id DESC LIMIT 1]
  671. SQL[SELECT * FROM devices WHERE (devices.device_id = '1430') AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1]
  672. Status: NOCHG
  673. Rule #3 (APC UPS Switched to Battery Power):
  674. SQL[SELECT state FROM alerts WHERE rule_id = '3' && device_id = '1430' ORDER BY id DESC LIMIT 1]
  675. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '1430' AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 3 AND sensors.sensor_type = "upsBasicOutputStatus"]
  676. Status: NOCHG
  677. Rule #4 (Cisco PSU status failed):
  678. SQL[SELECT state FROM alerts WHERE rule_id = '4' && device_id = '1430' ORDER BY id DESC LIMIT 1]
  679. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '1430' AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 8 AND sensors.sensor_oid = ".1.3.6.1.4.1.9.9.13.1.5.1.3"]
  680. Status: NOCHG
  681. Rule #5 (APC UPS Battery Needs Replacement):
  682. SQL[SELECT state FROM alerts WHERE rule_id = '5' && device_id = '1430' ORDER BY id DESC LIMIT 1]
  683. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '1430' AND devices.device_id = sensors.device_id) AND sensors.sensor_type = "upsAdvBatteryReplaceIndicator" AND sensors.sensor_current = 2]
  684. Status: NOCHG
  685. Rule #6 (APC UPS in Hardware Failure Bypass Mode):
  686. SQL[SELECT state FROM alerts WHERE rule_id = '6' && device_id = '1430' ORDER BY id DESC LIMIT 1]
  687. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '1430' AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 10 AND sensors.sensor_type = "upsBasicOutputStatus"]
  688. Status: NOCHG
  689. Rule #7 (Device rebooted):
  690. SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '1430' ORDER BY id DESC LIMIT 1]
  691. SQL[SELECT * FROM devices WHERE (devices.device_id = '1430') AND devices.uptime &lt; 300 AND (devices.disabled = 0 && devices.ignore = 0) = 1]
  692. Status: NOCHG
  693. Rule #8 (Cisco Fan Status failed ):
  694. SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '1430' ORDER BY id DESC LIMIT 1]
  695. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '1430' AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 9 AND sensors.sensor_oid = ".1.3.6.1.4.1.9.9.13.1.4.1.3"]
  696. Status: NOCHG
  697. #### End Alerts ####
  698. SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','10.115.0.32','1525274346.3448','5.004','1','AzPrdLibreNMS01')]
  699. /opt/librenms/poller.php 10.115.0.32 2018-05-02 09:19:11 - 1 devices polled in 5.004 secs
  700. SNMP [26/0.79s]: Get[17/0.67s] Getnext[0/0.00s] Walk[9/0.12s]
  701. MySQL [90/0.08s]: Cell[42/0.01s] Row[8/0.00s] Rows[30/0.01s] Column[2/0.00s] Update[6/0.05s] Insert[2/0.02s] Delete[0/0.00s]
  702. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  703.  
  704.