API tools faq
paste
ehoitinga

Poller-SwitchTV-01

ehoitinga
Nov 2nd, 2017
563
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.16 KB | None | 0 0
raw download clone embed print report
  1. root@1259d41e1f38:/opt/librenms# ./poller.php -h switch-tv -m ports -d
  2. LibreNMS Poller
  3. ===================================
  4. Version info:
  5. Commit SHA: e55c68de3bfba3b94c01e7dff9431a7a009d7c20
  6. Commit Date: 1509313164
  7. DB Schema: 213
  8. PHP: 7.1.11-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` = 'switch-tv' ORDER BY `device_id` ASC]
  16. SQL[SELECT * FROM devices_attribs WHERE `device_id` = '10']
  17. Hostname: switch-tv
  18. Device ID: 10
  19. OS: dlink
  20.  
  21. SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','1.81','2.28','1.97','10',NOW())]
  22. SNMP Check response code: 0
  23. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0]
  24. sysUpTime.0 = 661500
  25. sysLocation.0 = Sur les Chenes 3 - 6960 Manhay
  26. sysContact.0 = [email protected]
  27. sysName.0 = switch-tv
  28. sysObjectID.0 = enterprises.*.2
  29.  
  30. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysDescr.0]
  31. DGS-1100-05PD Gigabit Ethernet Switch
  32.  
  33. SNMP[/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]
  34. snmpEngineTime.0 = No Such Instance currently exists at this OID
  35.  
  36. Uptime seconds: 6615
  37. RRD[last switch-tv/uptime.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
  38. RRD[update switch-tv/uptime.rrd N:6615 --daemon unix:/var/run/rrdcached/rrdcached.sock]
  39. Uptime: 1h 50m 15s
  40. SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`='Sur les Chenes 3 - 6960 Manhay' LIMIT 1]
  41. Using cached lat/lng from other device
  42. Modules status: Global+ OS Device
  43. #### Load poller module ports ####
  44. Caching Oids: SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifXEntry]
  45. Timeout: No Response from udp:switch-tv:161
  46.  
  47. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 ifEntry]
  48. Timeout: No Response from udp:switch-tv:161
  49.  
  50. dot3StatsDuplexStatusSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot3StatsDuplexStatus]
  51. Timeout: No Response from udp:switch-tv:161
  52.  
  53. SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '10' AND `ifType` = 'adsl']
  54. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 dot1qPvid]
  55. Timeout: No Response from udp:switch-tv:161
  56.  
  57. Array
  58. (
  59. )
  60. SQL[SELECT `name` FROM `port_association_mode` WHERE pom_id = '1']
  61. 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` = '10' ORDER BY ports.port_id]
  62.  
  63.  
  64. >> Runtime for poller module 'ports': 24.1168 seconds with 22152 bytes
  65. #### Unload poller module ports ####
  66.  
  67. RRD[last switch-tv/poller-perf-ports.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
  68. RRD[update switch-tv/poller-perf-ports.rrd N:24.116754055023 --daemon unix:/var/run/rrdcached/rrdcached.sock]
  69. ### Start Device Groups ###
  70. SQL[SELECT * FROM device_groups ORDER BY name]
  71. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='10']
  72. Groups Added:
  73. Groups Removed:
  74. ### End Device Groups ###
  75. RRD[last switch-tv/ping-perf.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
  76. RRD[update switch-tv/ping-perf.rrd N:1.97 --daemon unix:/var/run/rrdcached/rrdcached.sock]
  77. RRD[last switch-tv/poller-perf.rrd --daemon unix:/var/run/rrdcached/rrdcached.sock]
  78. RRD[update switch-tv/poller-perf.rrd N:25.053 --daemon unix:/var/run/rrdcached/rrdcached.sock]
  79. Polled in 25.053 seconds
  80. Updating switch-tv
  81. SQL[UPDATE `devices` set `uptime` ='6615',`last_ping` =NOW(),`last_ping_timetaken` ='1.97',`last_polled` =NOW(),`last_polled_timetaken` ='25.053' WHERE `device_id` = '10']
  82. UPDATED!
  83. #### Start Alerts ####
  84. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='10']
  85. 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 = '10' ) && ((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]
  86. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='10']
  87. 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 = '10' ) || alert_map.target = '10' )]
  88. Rule #1 (Devices up/down):
  89. SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '10' ORDER BY id DESC LIMIT 1]
  90. SQL[SELECT * FROM devices WHERE (devices.device_id = '10') && (((devices.status = 0 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  91. Status: NOCHG
  92. Rule #2 (Device rebooted):
  93. SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '10' ORDER BY id DESC LIMIT 1]
  94. SQL[SELECT * FROM devices WHERE (devices.device_id = '10') && (devices.uptime < "300" && ((devices.disabled = 0 && devices.ignore = 0)) = "1")]
  95. Status: NOCHG
  96. Rule #3 (BGP Session down):
  97. SQL[SELECT state FROM alerts WHERE rule_id = '3' && device_id = '10' ORDER BY id DESC LIMIT 1]
  98. SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '10') && (bgpPeers.bgpPeerState != "established" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  99. Status: NOCHG
  100. Rule #4 (BGP Session established):
  101. SQL[SELECT state FROM alerts WHERE rule_id = '4' && device_id = '10' ORDER BY id DESC LIMIT 1]
  102. SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '10') && (bgpPeers.bgpPeerFsmEstablishedTime < "300" && bgpPeers.bgpPeerState = "established" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  103. Status: NOCHG
  104. Rule #5 (Port status up/down):
  105. SQL[SELECT state FROM alerts WHERE rule_id = '5' && device_id = '10' ORDER BY id DESC LIMIT 1]
  106. SQL[SELECT * FROM ports WHERE (ports.device_id = '10') && (((ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && ((ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)))) = "1")]
  107. Status: NOCHG
  108. Rule #6 (Port utilisation over threshold):
  109. SQL[SELECT state FROM alerts WHERE rule_id = '6' && device_id = '10' ORDER BY id DESC LIMIT 1]
  110. SQL[SELECT * FROM ports WHERE (ports.device_id = '10') && ((((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")]
  111. Status: NOCHG
  112. Rule #7 (Sensor over limit):
  113. SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '10' ORDER BY id DESC LIMIT 1]
  114. SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '10') && (sensors.sensor_current > sensors.sensor_limit && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  115. Status: NOCHG
  116. Rule #8 (Sensor under limit):
  117. SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '10' ORDER BY id DESC LIMIT 1]
  118. SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '10') && (sensors.sensor_current < sensors.sensor_limit_low && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  119. Status: NOCHG
  120. Rule #9 (Service up/down):
  121. SQL[SELECT state FROM alerts WHERE rule_id = '9' && device_id = '10' ORDER BY id DESC LIMIT 1]
  122. SQL[SELECT * FROM services,devices WHERE (( devices.device_id = services.device_id ) && services.device_id = '10') && (services.service_status != "0" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  123. Status: NOCHG
  124. Rule #10 (Wireless Sensor over limit):
  125. SQL[SELECT state FROM alerts WHERE rule_id = '10' && device_id = '10' ORDER BY id DESC LIMIT 1]
  126. SQL[SELECT * FROM wireless_sensors,devices WHERE (( devices.device_id = wireless_sensors.device_id ) && wireless_sensors.device_id = '10') && (wireless_sensors.sensor_current >= wireless_sensors.sensor_limit && wireless_sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  127. Status: NOCHG
  128. Rule #11 (Wireless Sensor under limit):
  129. SQL[SELECT state FROM alerts WHERE rule_id = '11' && device_id = '10' ORDER BY id DESC LIMIT 1]
  130. SQL[SELECT * FROM wireless_sensors,devices WHERE (( devices.device_id = wireless_sensors.device_id ) && wireless_sensors.device_id = '10') && (wireless_sensors.sensor_current <= wireless_sensors.sensor_limit_low && wireless_sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")]
  131. Status: NOCHG
  132. #### End Alerts ####
  133. SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','switch-tv','1509650385.0634','25.37','1','1259d41e1f38')]
  134. ./poller.php switch-tv 2017-11-02 20:20:10 - 1 devices polled in 25.37 secs
  135. SNMP: Get[4/0.44s] Walk [4/24.11s]
  136. MySQL: Cell[4/0.04s] Row[13/0.01s] Rows[18/0.02s] Column[3/0.00s] Update[1/0.05s] Insert[2/0.15s] Delete[0/0.00s]
  137. root@1259d41e1f38:/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!