API tools faq
paste
ehoitinga

laptop-erik-01

ehoitinga
Dec 3rd, 2017
534
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.36 KB | None | 0 0
raw download clone embed print report
  1. root@librenms:/opt/librenms# ./poller.php -h laptop_erik -d -m ports
  2. LibreNMS Poller
  3. ===================================
  4. Version info:
  5. Commit SHA: b7a06045b01aa86e7eabef9e1018c3d34c190a2a
  6. Commit Date: 1511610529
  7. DB Schema: 217
  8. PHP: 7.1.12-1+ubuntu16.04.1+deb.sury.org+1
  9. MySQL: 10.0.31-MariaDB
  10. RRDTool: 1.5.5
  11. SNMP: NET-SNMP 5.7.3
  12. ==================================DEBUG!
  13. Starting polling run:
  14.  
  15. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'laptop_erik' ORDER BY `device_id` ASC]
  16. ./poller.php laptop_erik 2017-12-03 10:29:12 - 0 devices polled in 0.300 secs
  17. SNMP 0.00s: Get[0/0.00s] Getnext [0/0.00s] Walk [0/0.00s]
  18. MySQL 0.00s: Cell[2/0.00s] Row[0/-0.00s] Rows[3/0.00s] Column[0/0.00s] Update[0/0.00s] Insert[0/0.00s] Delete[0/0.00s]
  19. RRD 0.00s: Update [0/0.00s] Create [0/0.00s] Other [0/0.00s]
  20. root@librenms:/opt/librenms# ./poller.php -h laptop-erik -d -m ports
  21. LibreNMS Poller
  22. ===================================
  23. Version info:
  24. Commit SHA: b7a06045b01aa86e7eabef9e1018c3d34c190a2a
  25. Commit Date: 1511610529
  26. DB Schema: 217
  27. PHP: 7.1.12-1+ubuntu16.04.1+deb.sury.org+1
  28. MySQL: 10.0.31-MariaDB
  29. RRDTool: 1.5.5
  30. SNMP: NET-SNMP 5.7.3
  31. ==================================DEBUG!
  32. Starting polling run:
  33.  
  34. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'laptop-erik' ORDER BY `device_id` ASC]
  35. SQL[SELECT * FROM devices_attribs WHERE `device_id` = '23']
  36. Hostname: laptop-erik
  37. Device ID: 23
  38. OS: linux (unix)
  39.  
  40. SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','0.43','0.68','0.56','23',NOW())]
  41. SNMP Check response code: 0
  42. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0]
  43. sysUpTime.0 = 263608
  44. sysLocation.0 = \"Sur les Chenes 3, 6960 Manhay, [50.348455, 5.590925]\"
  45. sysContact.0 = [email protected]
  46. sysName.0 = LAPTOP-ERIK
  47. sysObjectID.0 = enterprises.8*
  48.  
  49. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 sysDescr.0]
  50. Linux LAPTOP-ERIK 4.8.0-30-generic #32~16.04.1-Ubuntu SMP Fri Dec 2 03:43:51 UTC 2016 x86_64
  51.  
  52. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0]
  53. snmpEngineTime.0 = 2636
  54. hrSystemUptime.0 = 266215
  55.  
  56. Uptime seconds: 2662
  57. RRD[last laptop-erik/uptime.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
  58. RRD[update laptop-erik/uptime.rrd N:2662 --daemon unix:/var/run/rrdcached/rrdcached.sock]
  59. Uptime: 44m 22s
  60. Using cached lat/lng from other device
  61. Modules status: Global+ OS Device
  62. #### Load poller module ports ####
  63. Caching Oids: SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifXEntry]
  64. ifName.1 = lo
  65. ifName.2 = wlp2s0
  66. ifName.3 = enx18dbf260f245
  67. ifInMulticastPkts.1 = 0
  68. ifInMulticastPkts.2 = 0
  69. ifInMulticastPkts.3 = 0
  70. ifInBroadcastPkts.1 = 0
  71. ifInBroadcastPkts.2 = 0
  72. ifInBroadcastPkts.3 = 0
  73. ifOutMulticastPkts.1 = 0
  74. ifOutMulticastPkts.2 = 0
  75. ifOutMulticastPkts.3 = 0
  76. ifOutBroadcastPkts.1 = 0
  77. ifOutBroadcastPkts.2 = 0
  78. ifOutBroadcastPkts.3 = 0
  79. ifHCInOctets.1 = 9056151
  80. ifHCInOctets.2 = 0
  81. ifHCInOctets.3 = 35749489
  82. ifHCInUcastPkts.1 = 109120
  83. ifHCInUcastPkts.2 = 0
  84. ifHCInUcastPkts.3 = 40549
  85. ifHCInMulticastPkts.1 = 0
  86. ifHCInMulticastPkts.2 = 0
  87. ifHCInMulticastPkts.3 = 0
  88. ifHCInBroadcastPkts.1 = 0
  89. ifHCInBroadcastPkts.2 = 0
  90. ifHCInBroadcastPkts.3 = 0
  91. ifHCOutOctets.1 = 9056151
  92. ifHCOutOctets.2 = 0
  93. ifHCOutOctets.3 = 3596936
  94. ifHCOutUcastPkts.1 = 109120
  95. ifHCOutUcastPkts.2 = 0
  96. ifHCOutUcastPkts.3 = 25631
  97. ifHCOutMulticastPkts.1 = 0
  98. ifHCOutMulticastPkts.2 = 0
  99. ifHCOutMulticastPkts.3 = 0
  100. ifHCOutBroadcastPkts.1 = 0
  101. ifHCOutBroadcastPkts.2 = 0
  102. ifHCOutBroadcastPkts.3 = 0
  103. ifHighSpeed.1 = 10
  104. ifHighSpeed.2 = 0
  105. ifHighSpeed.3 = 1000
  106. ifPromiscuousMode.1 = false
  107. ifPromiscuousMode.2 = false
  108. ifPromiscuousMode.3 = false
  109. ifConnectorPresent.1 = false
  110. ifConnectorPresent.2 = true
  111. ifConnectorPresent.3 = true
  112. ifAlias.1 =
  113. ifAlias.2 =
  114. ifAlias.3 =
  115. ifCounterDiscontinuityTime.1 = 0:0:00:00.00
  116. ifCounterDiscontinuityTime.2 = 0:0:00:00.00
  117. ifCounterDiscontinuityTime.3 = 0:0:00:00.00
  118.  
  119. ifDescr SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifDescr]
  120. ifDescr.1 = lo
  121. ifDescr.2 = Qualcomm Atheros QCA6174 802.11ac Wireless Network Adapter
  122. ifDescr.3 = enx18dbf260f245
  123.  
  124. ifAdminStatus SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifAdminStatus]
  125. ifAdminStatus.1 = up
  126. ifAdminStatus.2 = down
  127. ifAdminStatus.3 = up
  128.  
  129. ifOperStatus SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifOperStatus]
  130. ifOperStatus.1 = up
  131. ifOperStatus.2 = down
  132. ifOperStatus.3 = up
  133.  
  134. ifLastChange SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifLastChange]
  135. ifLastChange.1 = 0
  136. ifLastChange.2 = 301
  137. ifLastChange.3 = 901
  138.  
  139. ifType SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifType]
  140. ifType.1 = softwareLoopback
  141. ifType.2 = ethernetCsmacd
  142. ifType.3 = ethernetCsmacd
  143.  
  144. ifPhysAddress SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifPhysAddress]
  145. ifPhysAddress.1 =
  146. ifPhysAddress.2 = 9c:b6:d0:d2:a4:4d
  147. ifPhysAddress.3 = 18:db:f2:60:f2:45
  148.  
  149. ifMtu SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifMtu]
  150. ifMtu.1 = 65536
  151. ifMtu.2 = 1500
  152. ifMtu.3 = 1500
  153.  
  154. ifInErrors SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifInErrors]
  155. ifInErrors.1 = 0
  156. ifInErrors.2 = 0
  157. ifInErrors.3 = 0
  158.  
  159. ifOutErrors SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifOutErrors]
  160. ifOutErrors.1 = 0
  161. ifOutErrors.2 = 0
  162. ifOutErrors.3 = 0
  163.  
  164. ifInDiscards SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifInDiscards]
  165. ifInDiscards.1 = 0
  166. ifInDiscards.2 = 0
  167. ifInDiscards.3 = 0
  168.  
  169. ifOutDiscards SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifOutDiscards]
  170. ifOutDiscards.1 = 0
  171. ifOutDiscards.2 = 0
  172. ifOutDiscards.3 = 0
  173.  
  174. dot3StatsDuplexStatusSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 dot3StatsDuplexStatus]
  175. dot3StatsDuplexStatus.3 = fullDuplex
  176.  
  177. SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '23' AND `ifType` = 'adsl']
  178. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 dot1qPvid]
  179. dot1qPvid = No Such Object available on this agent at this OID
  180.  
  181. Array
  182. (
  183. [1] => Array
  184. (
  185. [ifName] => lo
  186. [ifInMulticastPkts] => 0
  187. [ifInBroadcastPkts] => 0
  188. [ifOutMulticastPkts] => 0
  189. [ifOutBroadcastPkts] => 0
  190. [ifHCInOctets] => 9056151
  191. [ifHCInUcastPkts] => 109120
  192. [ifHCInMulticastPkts] => 0
  193. [ifHCInBroadcastPkts] => 0
  194. [ifHCOutOctets] => 9056151
  195. [ifHCOutUcastPkts] => 109120
  196. [ifHCOutMulticastPkts] => 0
  197. [ifHCOutBroadcastPkts] => 0
  198. [ifHighSpeed] => 10
  199. [ifPromiscuousMode] => false
  200. [ifConnectorPresent] => false
  201. [ifAlias] =>
  202. [ifCounterDiscontinuityTime] => 0:0:00:00.00
  203. [ifDescr] => lo
  204. [ifAdminStatus] => up
  205. [ifOperStatus] => up
  206. [ifLastChange] => 0
  207. [ifType] => softwareLoopback
  208. [ifPhysAddress] =>
  209. [ifMtu] => 65536
  210. [ifInErrors] => 0
  211. [ifOutErrors] => 0
  212. [ifInDiscards] => 0
  213. [ifOutDiscards] => 0
  214. )
  215.  
  216. [2] => Array
  217. (
  218. [ifName] => wlp2s0
  219. [ifInMulticastPkts] => 0
  220. [ifInBroadcastPkts] => 0
  221. [ifOutMulticastPkts] => 0
  222. [ifOutBroadcastPkts] => 0
  223. [ifHCInOctets] => 0
  224. [ifHCInUcastPkts] => 0
  225. [ifHCInMulticastPkts] => 0
  226. [ifHCInBroadcastPkts] => 0
  227. [ifHCOutOctets] => 0
  228. [ifHCOutUcastPkts] => 0
  229. [ifHCOutMulticastPkts] => 0
  230. [ifHCOutBroadcastPkts] => 0
  231. [ifHighSpeed] => 0
  232. [ifPromiscuousMode] => false
  233. [ifConnectorPresent] => true
  234. [ifAlias] =>
  235. [ifCounterDiscontinuityTime] => 0:0:00:00.00
  236. [ifDescr] => Qualcomm Atheros QCA6174 802.11ac Wireless Network Adapter
  237. [ifAdminStatus] => down
  238. [ifOperStatus] => down
  239. [ifLastChange] => 301
  240. [ifType] => ethernetCsmacd
  241. [ifPhysAddress] => 9c:b6:d0:d2:a4:4d
  242. [ifMtu] => 1500
  243. [ifInErrors] => 0
  244. [ifOutErrors] => 0
  245. [ifInDiscards] => 0
  246. [ifOutDiscards] => 0
  247. )
  248.  
  249. [3] => Array
  250. (
  251. [ifName] => enx18dbf260f245
  252. [ifInMulticastPkts] => 0
  253. [ifInBroadcastPkts] => 0
  254. [ifOutMulticastPkts] => 0
  255. [ifOutBroadcastPkts] => 0
  256. [ifHCInOctets] => 35749489
  257. [ifHCInUcastPkts] => 40549
  258. [ifHCInMulticastPkts] => 0
  259. [ifHCInBroadcastPkts] => 0
  260. [ifHCOutOctets] => 3596936
  261. [ifHCOutUcastPkts] => 25631
  262. [ifHCOutMulticastPkts] => 0
  263. [ifHCOutBroadcastPkts] => 0
  264. [ifHighSpeed] => 1000
  265. [ifPromiscuousMode] => false
  266. [ifConnectorPresent] => true
  267. [ifAlias] =>
  268. [ifCounterDiscontinuityTime] => 0:0:00:00.00
  269. [ifDescr] => enx18dbf260f245
  270. [ifAdminStatus] => up
  271. [ifOperStatus] => up
  272. [ifLastChange] => 901
  273. [ifType] => ethernetCsmacd
  274. [ifPhysAddress] => 18:db:f2:60:f2:45
  275. [ifMtu] => 1500
  276. [ifInErrors] => 0
  277. [ifOutErrors] => 0
  278. [ifInDiscards] => 0
  279. [ifOutDiscards] => 0
  280. [dot3StatsDuplexStatus] => fullDuplex
  281. )
  282.  
  283. )
  284. SQL[SELECT `name` FROM `port_association_mode` WHERE pom_id = '3']
  285. 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` = '23' ORDER BY ports.port_id]
  286. ignored by ifDescr: lo (matched: /^lo$/)
  287. SQL[UPDATE `ports` set `deleted` ='1' WHERE `port_id` = '']
  288. validvalidSQL[UPDATE `ports` set `deleted` ='0' WHERE `port_id` = '']
  289. SQL[INSERT INTO `ports_statistics` (`port_id`) VALUES ('')]
  290.  
  291. Port wlp2s0: Qualcomm Atheros QCA6174 802.11ac Wireless Network Adapter (2 / #85) disabled.
  292. Port : (3 / #) ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed dot3Duplex VLAN == Using ifDescr as ifAliasSQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifName: -> enx18dbf260f245','')]
  293. ifName SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifDescr: -> enx18dbf260f245','')]
  294. ifDescr SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifAlias: -> enx18dbf260f245','')]
  295. ifAlias SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifAdminStatus: -> up','')]
  296. ifAdminStatus SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifOperStatus: -> up','')]
  297. ifOperStatus SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifMtu: -> 1500','')]
  298. ifMtu SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifSpeed: -> 1000000000','')]
  299. ifSpeed SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifHighSpeed: -> 1000','')]
  300. ifHighSpeed SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifType: -> ethernetCsmacd','')]
  301. ifType SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifPhysAddress: -> 18dbf260f245','')]
  302. ifPhysAddress SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifPromiscuousMode: -> false','')]
  303. ifPromiscuousMode SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifConnectorPresent: -> true','')]
  304. ifConnectorPresent SQL[INSERT INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES ('23','23','NULL','interface',NOW(),'3','ifDuplex: -> fullDuplex','')]
  305. ifDuplex enx18dbf260f245bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[last laptop-erik/port-id.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
  306. RRD[update laptop-erik/port-id.rrd N:35749489:3596936:0:0:40549:25631:U:U:0:0:U:0:0:0:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
  307. SQL[UPDATE `ports` set `ifIndex` ='3',`poll_time` ='1512293382',`poll_period` ='1512293382',`ifLastChange` ='901',`ifName` ='enx18dbf260f245',`ifDescr` ='enx18dbf260f245',`ifAlias` ='enx18dbf260f245',`ifAdminStatus` ='up',`ifOperStatus` ='up',`ifMtu` ='1500',`ifSpeed` ='1000000000',`ifHighSpeed` ='1000',`ifType` ='ethernetCsmacd',`ifPhysAddress` ='18dbf260f245',`ifPromiscuousMode` ='false',`ifConnectorPresent` ='true',`ifDuplex` ='fullDuplex',`ifInOctets` ='35749489',`ifInOctets_prev` ='0',`ifOutOctets` ='3596936',`ifOutOctets_prev` ='0',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifInUcastPkts` ='40549',`ifInUcastPkts_prev` ='0',`ifOutUcastPkts` ='25631',`ifOutUcastPkts_prev` ='0' WHERE `port_id` = '']
  308. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts` ='0',`ifInNUcastPkts_prev` ='0',`ifOutNUcastPkts` ='0',`ifOutNUcastPkts_prev` ='0',`ifInDiscards` ='0',`ifInDiscards_prev` ='0',`ifOutDiscards` ='0',`ifOutDiscards_prev` ='0',`ifInUnknownProtos` ='0',`ifInUnknownProtos_prev` ='0',`ifInBroadcastPkts` ='0',`ifInBroadcastPkts_prev` ='0',`ifOutBroadcastPkts` ='0',`ifOutBroadcastPkts_prev` ='0',`ifInMulticastPkts` ='0',`ifInMulticastPkts_prev` ='0',`ifOutMulticastPkts` ='0',`ifOutMulticastPkts_prev` ='0' WHERE `port_id` = '']
  309. 0 updated
  310.  
  311. >> Runtime for poller module 'ports': 1.4026 seconds with 35024 bytes
  312. #### Unload poller module ports ####
  313.  
  314. RRD[last laptop-erik/poller-perf-ports.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
  315. RRD[update laptop-erik/poller-perf-ports.rrd N:1.4026048183441 --daemon unix:/var/run/rrdcached/rrdcached.sock]
  316. ### Start Device Groups ###
  317. SQL[SELECT * FROM device_groups ORDER BY name]
  318. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='23']
  319. Groups Added:
  320. Groups Removed:
  321. ### End Device Groups ###
  322. RRD[last laptop-erik/ping-perf.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
  323. RRD[update laptop-erik/ping-perf.rrd N:0.56 --daemon unix:/var/run/rrdcached/rrdcached.sock]
  324. RRD[last laptop-erik/poller-perf.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
  325. RRD[update laptop-erik/poller-perf.rrd N:2.579 --daemon unix:/var/run/rrdcached/rrdcached.sock]
  326. Polled in 2.579 seconds
  327. Updating laptop-erik
  328. SQL[UPDATE `devices` set `uptime` ='2662',`last_ping` =NOW(),`last_ping_timetaken` ='0.56',`last_polled` =NOW(),`last_polled_timetaken` ='2.579' WHERE `device_id` = '23']
  329. UPDATED!
  330. #### Start Alerts ####
  331. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='23']
  332. 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 = '23' ) && ((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]
  333. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='23']
  334. SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE alert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = '23' ) || alert_map.target = '23' )]
  335. Rule #1 (Devices up/down):
  336. SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '23' ORDER BY id DESC LIMIT 1]
  337. SQL[SELECT * FROM devices WHERE (devices.device_id = '23') && (((devices.status = 0 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  338. Status: NOCHG
  339. Rule #2 (Device rebooted):
  340. SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '23' ORDER BY id DESC LIMIT 1]
  341. SQL[SELECT * FROM devices WHERE (devices.device_id = '23') && (devices.uptime < "300" && ((devices.disabled = 0 && devices.ignore = 0)) = "1")]
  342. Status: NOCHG
  343. Rule #3 (BGP Session down):
  344. SQL[SELECT state FROM alerts WHERE rule_id = '3' && device_id = '23' ORDER BY id DESC LIMIT 1]
  345. SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '23') && (bgpPeers.bgpPeerState != "established" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  346. Status: NOCHG
  347. Rule #4 (BGP Session established):
  348. SQL[SELECT state FROM alerts WHERE rule_id = '4' && device_id = '23' ORDER BY id DESC LIMIT 1]
  349. SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '23') && (bgpPeers.bgpPeerFsmEstablishedTime < "300" && bgpPeers.bgpPeerState = "established" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  350. Status: NOCHG
  351. Rule #5 (Port status up/down):
  352. SQL[SELECT state FROM alerts WHERE rule_id = '5' && device_id = '23' ORDER BY id DESC LIMIT 1]
  353. SQL[SELECT * FROM ports WHERE (ports.device_id = '23') && (((ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && ((ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)))) = "1")]
  354. Status: NOCHG
  355. Rule #6 (Port utilisation over threshold):
  356. SQL[SELECT state FROM alerts WHERE rule_id = '6' && device_id = '23' ORDER BY id DESC LIMIT 1]
  357. SQL[SELECT * FROM ports WHERE (ports.device_id = '23') && ((((ports.ifInOctets_rate*8) / ports.ifSpeed)*100) >= "80" && ((ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && ((ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)))) = "1" && ((ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = "1")]
  358. Status: NOCHG
  359. Rule #7 (Sensor over limit):
  360. SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '23' ORDER BY id DESC LIMIT 1]
  361. SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '23') && (sensors.sensor_current > sensors.sensor_limit && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  362. Status: NOCHG
  363. Rule #8 (Sensor under limit):
  364. SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '23' ORDER BY id DESC LIMIT 1]
  365. SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '23') && (sensors.sensor_current < sensors.sensor_limit_low && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  366. Status: NOCHG
  367. Rule #9 (Service up/down):
  368. SQL[SELECT state FROM alerts WHERE rule_id = '9' && device_id = '23' ORDER BY id DESC LIMIT 1]
  369. SQL[SELECT * FROM services,devices WHERE (( devices.device_id = services.device_id ) && services.device_id = '23') && (services.service_status != "0" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  370. Status: NOCHG
  371. Rule #10 (Wireless Sensor over limit):
  372. SQL[SELECT state FROM alerts WHERE rule_id = '10' && device_id = '23' ORDER BY id DESC LIMIT 1]
  373. SQL[SELECT * FROM wireless_sensors,devices WHERE (( devices.device_id = wireless_sensors.device_id ) && wireless_sensors.device_id = '23') && (wireless_sensors.sensor_current >= wireless_sensors.sensor_limit && wireless_sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  374. Status: NOCHG
  375. Rule #11 (Wireless Sensor under limit):
  376. SQL[SELECT state FROM alerts WHERE rule_id = '11' && device_id = '23' ORDER BY id DESC LIMIT 1]
  377. SQL[SELECT * FROM wireless_sensors,devices WHERE (( devices.device_id = wireless_sensors.device_id ) && wireless_sensors.device_id = '23') && (wireless_sensors.sensor_current <= wireless_sensors.sensor_limit_low && wireless_sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  378. Status: NOCHG
  379. #### End Alerts ####
  380. SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','laptop-erik','1512293381.3009','2.729','1','librenms')]
  381. ./poller.php laptop-erik 2017-12-03 10:29:44 - 1 devices polled in 2.729 secs
  382. SNMP 0.31s: Get[4/0.07s] Getnext [0/0.00s] Walk [14/0.24s]
  383. MySQL 1.41s: Cell[4/0.00s] Row[12/0.01s] Rows[18/0.02s] Column[3/0.00s] Update[5/0.19s] Insert[16/1.18s] Delete[0/0.00s]
  384. RRD 0.00s: Update [5/0.00s] Create [0/0.00s] Other [5/0.00s]
  385. root@librenms:/opt/librenms#
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!