Untitled

From robbert, 6 Years ago, written in Plain Text.
URL https://p.libren.ms/view/975dd720
Embed
Download Paste or View Raw
  1. LibreNMS Poller
  2. ===================================
  3. Version info:
  4. Commit SHA: 1aa971375cc59819f58b3d2bb8eb7a90c14f4841
  5. Commit Date: 1510181843
  6. DB Schema: 215
  7. PHP: 7.0.22-0ubuntu0.16.04.1
  8. MySQL: 5.7.20-0ubuntu0.16.04.1-log
  9. RRDTool: 1.5.5
  10. SNMP: NET-SNMP 5.7.3
  11. ==================================DEBUG!
  12. Starting polling run:
  13.  
  14. SQL[[0;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'hp8600.homeserv.lan' ORDER BY `device_id` ASC[0m]
  15. SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '111'[0m]
  16. Hostname: hp8600.homeserv.lan
  17. Device ID: 111
  18. OS: jetdirect (printer)
  19.  
  20. SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','1.56','4.25','3.08','111',NOW())[0m]
  21. SNMP Check response code: 0
  22. SNMP[[0;36m/usr/bin/snmpget -v1 -c 'public' -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:hp8600.homeserv.lan:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0[0m]
  23. sysUpTime.0 = 216800
  24. sysLocation.0 = ........................................
  25. sysContact.0 = ........................................
  26. sysName.0 = HP8600
  27. sysObjectID.0 = joint-iso-ccitt.543893180.811937840.808464432.808464432.808464432.808464432.808463408
  28.  
  29. SNMP[[0;36m/usr/bin/snmpget -v1 -c 'public' -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:hp8600.homeserv.lan:161 sysDescr.0[0m]
  30. HP ETHERNET MULTI-ENVIRONMENT
  31.  
  32. SNMP[[0;36m/usr/bin/snmpget -v1 -c 'public' -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:hp8600.homeserv.lan:161 snmpEngineTime.0 hrSystemUptime.0[0m]
  33.  
  34. Uptime seconds: 2168
  35. RRD[[0;32mlast hp8600.homeserv.lan/uptime.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  36. RRDtool Output: 1510223700
  37. OK u:0.01 s:0.00 r:0.47
  38. RRD[[0;32mupdate hp8600.homeserv.lan/uptime.rrd N:2168 --daemon unix:/var/run/rrdcached.sock[0m]
  39. [[0;31mRRD Disabled[0m]Uptime: 36m 8s
  40. Using cached lat/lng from other device
  41. Modules status: Global+ OS+ Device  
  42. #### Load poller module toner ####
  43. SQL[[0;33mSELECT * FROM toner WHERE device_id = '111'[0m]
  44. Checking toner Black ink... SNMP[[0;36m/usr/bin/snmpget -v1 -c 'public' -OUqnv -M /opt/librenms/mibs udp:hp8600.homeserv.lan:161 .1.3.6.1.2.1.43.11.1.1.9.0.1[0m]
  45. 135
  46.  
  47. 20 %
  48. RRD[[0;32mlast hp8600.homeserv.lan/toner-1.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  49. RRDtool Output: 1510223700
  50. OK u:0.01 s:0.00 r:0.49
  51. RRD[[0;32mupdate hp8600.homeserv.lan/toner-1.rrd N:20 --daemon unix:/var/run/rrdcached.sock[0m]
  52. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `toner` set `toner_current` ='20',`toner_capacity` ='674' WHERE `toner_id` = '29'[0m]
  53. Checking toner yellow ink... SNMP[[0;36m/usr/bin/snmpget -v1 -c 'public' -OUqnv -M /opt/librenms/mibs udp:hp8600.homeserv.lan:161 .1.3.6.1.2.1.43.11.1.1.9.0.2[0m]
  54. 200
  55.  
  56. 87 %
  57. RRD[[0;32mlast hp8600.homeserv.lan/toner-2.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  58. RRDtool Output: 1510223700
  59. OK u:0.01 s:0.00 r:0.52
  60. RRD[[0;32mupdate hp8600.homeserv.lan/toner-2.rrd N:87 --daemon unix:/var/run/rrdcached.sock[0m]
  61. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `toner` set `toner_current` ='87',`toner_capacity` ='230' WHERE `toner_id` = '30'[0m]
  62. Checking toner cyan ink... SNMP[[0;36m/usr/bin/snmpget -v1 -c 'public' -OUqnv -M /opt/librenms/mibs udp:hp8600.homeserv.lan:161 .1.3.6.1.2.1.43.11.1.1.9.0.3[0m]
  63. 188
  64.  
  65. 87 %
  66. RRD[[0;32mlast hp8600.homeserv.lan/toner-3.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  67. RRDtool Output: 1510223700
  68. OK u:0.01 s:0.00 r:0.54
  69. RRD[[0;32mupdate hp8600.homeserv.lan/toner-3.rrd N:87 --daemon unix:/var/run/rrdcached.sock[0m]
  70. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `toner` set `toner_current` ='87',`toner_capacity` ='216' WHERE `toner_id` = '31'[0m]
  71. Checking toner magenta ink... SNMP[[0;36m/usr/bin/snmpget -v1 -c 'public' -OUqnv -M /opt/librenms/mibs udp:hp8600.homeserv.lan:161 .1.3.6.1.2.1.43.11.1.1.9.0.4[0m]
  72.  
  73. 0 %
  74. RRD[[0;32mlast hp8600.homeserv.lan/toner-4.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  75. RRDtool Output: 1510223700
  76. OK u:0.01 s:0.00 r:0.56
  77. RRD[[0;32mupdate hp8600.homeserv.lan/toner-4.rrd N:0 --daemon unix:/var/run/rrdcached.sock[0m]
  78. [[0;31mRRD Disabled[0m]SQL[[0;33mUPDATE `toner` set `toner_current` ='0',`toner_capacity` ='230' WHERE `toner_id` = '32'[0m]
  79.  
  80. >> Runtime for poller module 'toner': 0.0908 seconds with 9824 bytes
  81. #### Unload poller module toner ####
  82.  
  83. RRD[[0;32mlast hp8600.homeserv.lan/poller-perf-toner.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  84. RRDtool Output: 1510223700
  85. OK u:0.01 s:0.00 r:0.56
  86. RRD[[0;32mupdate hp8600.homeserv.lan/poller-perf-toner.rrd N:0.090801000595093 --daemon unix:/var/run/rrdcached.sock[0m]
  87. [[0;31mRRD Disabled[0m]### Start Device Groups ###
  88. SQL[[0;33mSELECT * FROM device_groups ORDER BY name[0m]
  89. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='111' AND (devices.hostname REGEXP ".damnl.local") LIMIT 1[0m]
  90. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='111' AND (devices.location = "David Livingstonestraat, Almere, Netherlands [52.351902,5.146170]") LIMIT 1[0m]
  91. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='111' AND (devices.hostname REGEXP ".homeserv.lan") LIMIT 1[0m]
  92. SQL[[0;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='111' AND (devices.hostname REGEXP "pi") LIMIT 1[0m]
  93. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='111'[0m]
  94. Groups Added:
  95. Groups Removed:
  96. ### End Device Groups ###
  97. RRD[[0;32mlast hp8600.homeserv.lan/ping-perf.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  98. RRDtool Output: 1510223700
  99. OK u:0.01 s:0.00 r:0.56
  100. RRD[[0;32mupdate hp8600.homeserv.lan/ping-perf.rrd N:3.08 --daemon unix:/var/run/rrdcached.sock[0m]
  101. [[0;31mRRD Disabled[0m]RRD[[0;32mlast hp8600.homeserv.lan/poller-perf.rrd  --daemon unix:/var/run/rrdcached.sock[0m]
  102. RRDtool Output: 1510223700
  103. OK u:0.01 s:0.00 r:0.56
  104. RRD[[0;32mupdate hp8600.homeserv.lan/poller-perf.rrd N:0.567 --daemon unix:/var/run/rrdcached.sock[0m]
  105. [[0;31mRRD Disabled[0m]Polled in 0.567 seconds
  106. Updating hp8600.homeserv.lan
  107. SQL[[0;33mUPDATE `devices` set `uptime` ='2168',`last_ping` =NOW(),`last_ping_timetaken` ='3.08',`last_polled` =NOW(),`last_polled_timetaken` ='0.567' WHERE `device_id` = '111'[0m]
  108. UPDATED!
  109. #### Start Alerts ####
  110. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='111'[0m]
  111. SQL[[0;33mSELECT 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 = '111' || alert_schedule_items.target = 'g1' || alert_schedule_items.target = 'g5' ) && ((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(), '[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 = '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(), '[0;37m'),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1[0m]
  112. SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='111'[0m]
  113. SQL[[0;33mSELECT 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 = '111' ) || alert_map.target = '111'  || alert_map.target = 'g1' || alert_map.target = 'g5' )[0m]
  114. Rule [0;35m#1 (Devices up/down):[0m
  115. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '1' && device_id = '111' ORDER BY id DESC LIMIT 1[0m]
  116. SQL[[0;33mSELECT * FROM devices WHERE (devices.device_id = '111') && (((devices.status = 0  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"      )[0m]
  117. Status: [0;34mNOCHG[0m
  118. Rule [0;35m#6 (Port utilisation over threshold):[0m
  119. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '6' && device_id = '111' ORDER BY id DESC LIMIT 1[0m]
  120. SQL[[0;33mSELECT * FROM ports WHERE (ports.device_id = '111') && ((((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"  )[0m]
  121. Status: [0;34mNOCHG[0m
  122. Rule [0;35m#7 (Sensor over limit):[0m
  123. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '7' && device_id = '111' ORDER BY id DESC LIMIT 1[0m]
  124. SQL[[0;33mSELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '111') && (sensors.sensor_current > sensors.sensor_limit  &&  sensors.sensor_alert = "1"  &&  ((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"  )[0m]
  125. Status: [0;34mNOCHG[0m
  126. Rule [0;35m#8 (Sensor under limit):[0m
  127. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '8' && device_id = '111' ORDER BY id DESC LIMIT 1[0m]
  128. SQL[[0;33mSELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '111') && (sensors.sensor_current < sensors sensors.sensor_alert = "1" xss=removed xss=removed xss=removed rule_id = '9' device_id = '111' xss=removed services.device_id = '111' xss=removed xss=removed xss=removed rule_id = '10' device_id = '111' xss=removed wireless_sensors.device_id = '111'>= wireless_sensors.sensor_limit  &&  wireless_sensors.sensor_alert = "1"  &&  ((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"  )[0m]
  129. Status: [0;34mNOCHG[0m
  130. Rule [0;35m#11 (Wireless Sensor under limit):[0m
  131. SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '11' && device_id = '111' ORDER BY id DESC LIMIT 1[0m]
  132. SQL[[0;33mSELECT * FROM wireless_sensors,devices WHERE (( devices.device_id = wireless_sensors.device_id ) && wireless_sensors.device_id = '111') && (wireless_sensors.sensor_current <= wireless_sensors.sensor_limit_low  &&  wireless_sensors.sensor_alert = "1"  &&  ((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"  )[0m]
  133. Status: [0;34mNOCHG[0m
  134. #### End Alerts ####
  135. SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','hp8600.homeserv.lan','1510223820.4937','0.618','1','mon1')[0m]
  136. /opt/librenms/poller.php hp8600.homeserv.lan 2017-11-09 11:37:01 - 1 devices polled in 0.618 secs
  137. SNMP: Get[8/0.14s] Getnext [0/0.00s] Walk [0/0.00s]
  138. MySQL: Cell[7/0.00s] Row[7/0.00s] Rows[14/0.00s] Column[3/0.00s] Update[5/0.01s] Insert[2/0.00s] Delete[0/0.00s]
  139.  


Reply to "Untitled"