API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 5th, 2017
510
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.56 KB | None | 0 0
raw download clone embed print report
  1. LibreNMS Poller
  2. ===================================
  3. Version info:
  4. Commit SHA: 0ff847a9b3fad5a5766c5da9aca9d3cb453360f2
  5. Commit Date: 1501783261
  6. DB Schema: 200
  7. PHP: 7.0.15-0ubuntu0.16.04.4
  8. MySQL: 5.7.19-0ubuntu0.16.04.1
  9. RRDTool: 1.5.5
  10. SNMP: NET-SNMP 5.7.3
  11. ==================================DEBUG!
  12. Starting polling run:
  13.  
  14. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'picam.quantum.lan' ORDER BY `device_id` ASC]
  15. SQL[SELECT * FROM devices_attribs WHERE `device_id` = '8']
  16. Hostname: picam.quantum.lan
  17. Device ID: 8
  18. OS: linux (unix)
  19.  
  20. SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','68.6','86.4','77.4','8',NOW())]
  21. SNMP Check response code: 0
  22. 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 -t 10 udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0]
  23. sysUpTime.0 = 6070785
  24. sysLocation.0 = Sitting on the Dock of the Bay
  25. sysContact.0 = Me <me@example.org>
  26. sysName.0 = picam
  27. sysObjectID.0 = enterprises.8*
  28.  
  29. 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 -t 10 udp:HOSTNAME:161 sysDescr.0]
  30. Linux picam 4.1.19+ #858 Tue Mar 15 15:52:03 GMT 2016 armv6l
  31.  
  32. 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 -t 10 udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0]
  33. snmpEngineTime.0 = 60707
  34. hrSystemUptime.0 = 414212442
  35.  
  36. Uptime seconds: 4142124
  37. RRD[update /opt/librenms/rrd/picam.quantum.lan/uptime.rrd N:4142124]
  38. [RRD Disabled]Uptime: 47 days, 22h 35m 24s
  39. Using cached lat/lng from other device
  40. Modules status: Global+ OS Device
  41. #### Load poller module sensors ####
  42. SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = '8' GROUP BY `sensor_class`]
  43. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '8']
  44. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell -t 10 udp:HOSTNAME:161 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.6 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.7]
  45. .*.4.1.8*.*.*.*.121.6 = "700000000"
  46. .*.4.1.8*.*.*.*.121.7 = "250000000"
  47.  
  48. Checking (snmp) frequency ARM...
  49. Checking (snmp) frequency Core...
  50. 0
  51. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-frequency-raspberry_freq-6.rrd N:0]
  52. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Frequency' AND `sensor_id` = '93']
  53. 0
  54. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-frequency-raspberry_freq-7.rrd N:0]
  55. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Frequency' AND `sensor_id` = '94']
  56. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '8']
  57. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell -t 10 udp:HOSTNAME:161 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.8 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.9 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.10 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.11 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.12 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.13]
  58. .*.4.1.8*.*.*.*.121.8 = "enabled"
  59. .*.4.1.8*.*.*.*.121.9 = "disabled"
  60. .*.4.1.8*.*.*.*.121.10 = "disabled"
  61. .*.4.1.8*.*.*.*.121.11 = "enabled"
  62. .*.4.1.8*.*.*.*.121.12 = "enabled"
  63. .*.4.1.8*.*.*.*.121.13 = "disabled"
  64.  
  65. Checking (snmp) state H264 codec...
  66. SQL[SELECT `state_value`
  67. FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
  68. ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
  69. WHERE `sensors_to_state_indexes`.`sensor_id` = '80'
  70. AND `state_translations`.`state_descr` LIKE '']
  71. State value of is
  72. Checking (snmp) state MPG2 codec...
  73. SQL[SELECT `state_value`
  74. FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
  75. ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
  76. WHERE `sensors_to_state_indexes`.`sensor_id` = '81'
  77. AND `state_translations`.`state_descr` LIKE '']
  78. State value of is
  79. Checking (snmp) state WVC1 codec...
  80. SQL[SELECT `state_value`
  81. FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
  82. ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
  83. WHERE `sensors_to_state_indexes`.`sensor_id` = '82'
  84. AND `state_translations`.`state_descr` LIKE '']
  85. State value of is
  86. Checking (snmp) state MPG4 codec...
  87. SQL[SELECT `state_value`
  88. FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
  89. ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
  90. WHERE `sensors_to_state_indexes`.`sensor_id` = '83'
  91. AND `state_translations`.`state_descr` LIKE '']
  92. State value of is
  93. Checking (snmp) state MJPG codec...
  94. SQL[SELECT `state_value`
  95. FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
  96. ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
  97. WHERE `sensors_to_state_indexes`.`sensor_id` = '84'
  98. AND `state_translations`.`state_descr` LIKE '']
  99. State value of is
  100. Checking (snmp) state WMV9 codec...
  101. SQL[SELECT `state_value`
  102. FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
  103. ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
  104. WHERE `sensors_to_state_indexes`.`sensor_id` = '85'
  105. AND `state_translations`.`state_descr` LIKE '']
  106. State value of is
  107. 0
  108. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-state-raspberry_codec-8.rrd N:0]
  109. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '80']
  110. 0
  111. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-state-raspberry_codec-9.rrd N:0]
  112. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '81']
  113. 0
  114. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-state-raspberry_codec-10.rrd N:0]
  115. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '82']
  116. 0
  117. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-state-raspberry_codec-11.rrd N:0]
  118. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '83']
  119. 0
  120. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-state-raspberry_codec-12.rrd N:0]
  121. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '84']
  122. 0
  123. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-state-raspberry_codec-13.rrd N:0]
  124. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '85']
  125. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '8']
  126. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell -t 10 udp:HOSTNAME:161 .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.1]
  127. .*.4.1.8*.*.*.*.121.1 = "46.5"
  128.  
  129. Checking (snmp) temperature CPU Temp...
  130. 46.5
  131. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-temperature-raspberry_temp-1.rrd N:46.5]
  132. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='46.5',`sensor_prev` ='46.5',`lastupdate` =NOW() WHERE `sensor_class` = 'Temperature' AND `sensor_id` = '86']
  133. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '8']
  134. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQnt -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell -t 10 udp:HOSTNAME:161 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.2 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.3 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.4 1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.5]
  135. .*.4.1.8*.*.*.*.121.2 = "1.2000"
  136. .*.4.1.8*.*.*.*.121.3 = "1.2000"
  137. .*.4.1.8*.*.*.*.121.4 = "1.2000"
  138. .*.4.1.8*.*.*.*.121.5 = "1.2250"
  139.  
  140. Checking (snmp) voltage Core...
  141. Checking (snmp) voltage SDRAMc...
  142. Checking (snmp) voltage SDRAMi...
  143. Checking (snmp) voltage SDRAMp...
  144. 0
  145. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-voltage-rasbperry_volts-2.rrd N:0]
  146. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Voltage' AND `sensor_id` = '95']
  147. 0
  148. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-voltage-rasbperry_volts-3.rrd N:0]
  149. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Voltage' AND `sensor_id` = '96']
  150. 0
  151. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-voltage-rasbperry_volts-4.rrd N:0]
  152. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Voltage' AND `sensor_id` = '97']
  153. 0
  154. RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-voltage-rasbperry_volts-5.rrd N:0]
  155. [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Voltage' AND `sensor_id` = '98']
  156.  
  157. >> Runtime for poller module 'sensors': 1.5356 seconds with 264 bytes
  158. #### Unload poller module sensors ####
  159.  
  160. RRD[update /opt/librenms/rrd/picam.quantum.lan/poller-perf-sensors.rrd N:1.5356040000916]
  161. [RRD Disabled]### Start Device Groups ###
  162. SQL[SELECT * FROM device_groups ORDER BY name]
  163. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='8']
  164. Groups Added:
  165. Groups Removed:
  166. ### End Device Groups ###
  167. RRD[update /opt/librenms/rrd/picam.quantum.lan/ping-perf.rrd N:77.4]
  168. [RRD Disabled]RRD[update /opt/librenms/rrd/picam.quantum.lan/poller-perf.rrd N:2.117]
  169. [RRD Disabled]Polled in 2.117 seconds
  170. Updating picam.quantum.lan
  171. SQL[UPDATE `devices` set `uptime` ='4142124',`last_ping` =NOW(),`last_ping_timetaken` ='77.4',`last_polled` =NOW(),`last_polled_timetaken` ='2.117' WHERE `device_id` = '8']
  172. UPDATED!
  173. #### Start Alerts ####
  174. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='8']
  175. 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 = '8' ) && ((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]
  176. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='8']
  177. 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 = '8' ) || alert_map.target = '8' )]
  178. Rule #1 (Devices down):
  179. SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '8' ORDER BY id DESC LIMIT 1]
  180. SQL[SELECT * FROM devices WHERE (devices.device_id = '8') && (((devices.status = 0 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" )]
  181. Status: NOCHG
  182. Rule #2 (Device rebooted):
  183. SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '8' ORDER BY id DESC LIMIT 1]
  184. SQL[SELECT * FROM devices WHERE (devices.device_id = '8') && (devices.uptime < "300" && ((devices.disabled = 0 && devices.ignore = 0)) = "1")]
  185. Status: NOCHG
  186. Rule #6 (Port utilisation over threshold):
  187. SQL[SELECT state FROM alerts WHERE rule_id = '6' && device_id = '8' ORDER BY id DESC LIMIT 1]
  188. SQL[SELECT * FROM ports WHERE (ports.device_id = '8') && ((((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" )]
  189. Status: NOCHG
  190. Rule #7 (Sensor over limit):
  191. SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '8' ORDER BY id DESC LIMIT 1]
  192. SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '8') && (sensors.sensor_current > sensors.sensor_limit && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" )]
  193. Status: NOCHG
  194. Rule #8 (Sensor under limit):
  195. SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '8' ORDER BY id DESC LIMIT 1]
  196. SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '8') && (sensors.sensor_current < sensors.sensor_limit_low && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" )]
  197. Status: NOCHGSQL[SELECT alert_log.id, alert_log.details FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = '8' && alert_log.rule_id = '8' && alert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1]
  198. SQL[UPDATE `alert_log` set `details` ='x��mo�6ǿ���\\\"H�e��04K��@�I�7E!�c��H�J� ߽w�l\'v�-�5(�����ݟ�݆��Tք�۰Zjf�kJ>s\"�W��0U� g������ Ԏ�p��64T�KV�o:\nֆ�rj)Z㭱���ᕦ_�\n\\5mYE�<+�9ե])� 4�Q��J�Q4��h�\"�\ri�F�(I��4���`(�$N:k�M�h���DMo �=Ӱ�&Fͩ֫��0Si�]��3���/�56�[�8�;��iM�}�\Z�\Z��|���ߎ��&Z�3�8�qpy��|c�[K��v�.c�K0B��+�*���M����ˆ�4���[�jb��i��qqgA�ϲ�,��i�i;t����:�R\Z+H�9��D_�5(3���=/X����Q�t�k��+rs�*0g�����Q�#x:��4kװc���z���wf�����A�B���$���JY9�n����?/�d�r�i�M�N��\0&8��0���(y�\Z*]�\r��jFͺ=�:�0���:�v��V�� ��)Q����woH�N �2�n���ޞd�k�K��{G�3��$��Y���Q���}\0ӜD7������5��!��4�z�;��y\r���p��%���\n�Y�]jQW�X�����cpp8���%Z�NR6��4JG�$N� �ȓ8�$��xF,�Bj�|�PjPn���� {T3C�|��r\n���H�i҉�,���ƁQ��{{���&�$��Fه�fX^bVK>S�\rƖ�WB]������Q̶q���?� ���h�UN+ih߷�{�j�6^m_�U]�n��i��BK���a�մI�nG���nU���;&+�Ŕ��ixw�����@Q�����(:F�~��4{��Q�yyyyy���_�����0���$J#�\\u$�Z��\"8M�D\n%Q�z\0y\0y\0y\0��\0��\0��4z:�.O.��*� � � � ��A�K@�xA�g\"�yyyyy�*^��}e�D��\Z�uʞN�q�fDDDD?�>�f��7O�8��E\'w_��t�' WHERE id = '4395']
  199.  
  200. Rule #9 (Service up/down):
  201. SQL[SELECT state FROM alerts WHERE rule_id = '9' && device_id = '8' ORDER BY id DESC LIMIT 1]
  202. SQL[SELECT * FROM services,devices WHERE (( devices.device_id = services.device_id ) && services.device_id = '8') && (services.service_status != "0" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" )]
  203. Status: NOCHG
  204. Rule #16 (Storage Over 90%):
  205. SQL[SELECT state FROM alerts WHERE rule_id = '16' && device_id = '8' ORDER BY id DESC LIMIT 1]
  206. SQL[SELECT * FROM storage WHERE (storage.device_id = '8') && (storage.storage_descr NOT REGEXP "/boot" && storage.storage_descr NOT REGEXP "/var/dhcpd/dev" && storage.storage_perc >= "90" )]
  207. Status: NOCHG
  208. Rule #17 (Interface Output Errors over threshold):
  209. SQL[SELECT state FROM alerts WHERE rule_id = '17' && device_id = '8' ORDER BY id DESC LIMIT 1]
  210. SQL[SELECT * FROM ports WHERE (ports.device_id = '8') && (ports.ifOutErrors_delta > "1" && ports.ifDescr NOT REGEXP "Dot11Radio" )]
  211. Status: NOCHG
  212. Rule #18 (Processor usage over 85%):
  213. SQL[SELECT state FROM alerts WHERE rule_id = '18' && device_id = '8' ORDER BY id DESC LIMIT 1]
  214. SQL[SELECT * FROM processors,devices WHERE (( devices.device_id = processors.device_id ) && processors.device_id = '8') && (processors.processor_usage > "85" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" && devices.hostname NOT REGEXP "cgsyslog" )]
  215. Status: NOCHG
  216. Rule #19 (Port status changed to down):
  217. SQL[SELECT state FROM alerts WHERE rule_id = '19' && device_id = '8' ORDER BY id DESC LIMIT 1]
  218. SQL[SELECT * FROM ports WHERE (ports.device_id = '8') && (ports.ifOperStatus = "down" && ports.ifOperStatus_prev = "up" && ports.deleted = "0" && ports.ignore = "0" && ports.disabled = "0" )]
  219. Status: NOCHG
  220. Rule #20 (Interface Input Errors over threshold):
  221. SQL[SELECT state FROM alerts WHERE rule_id = '20' && device_id = '8' ORDER BY id DESC LIMIT 1]
  222. SQL[SELECT * FROM ports WHERE (ports.device_id = '8') && (ports.ifInErrors_delta > "1" && ports.ifDescr NOT REGEXP "Dot11Radio" )]
  223. Status: NOCHG
  224. Rule #21 (Syslog - Authentication Failure):
  225. SQL[SELECT state FROM alerts WHERE rule_id = '21' && device_id = '8' ORDER BY id DESC LIMIT 1]
  226. SQL[SELECT * FROM syslog WHERE (syslog.device_id = '8') && (syslog.timestamp >= (DATE_SUB(NOW(),INTERVAL 5 MINUTE)) && syslog.msg REGEXP ".*authentication failure.*" )]
  227. Status: NOCHG
  228. Rule #22 (Syslog - Authentication Error):
  229. SQL[SELECT state FROM alerts WHERE rule_id = '22' && device_id = '8' ORDER BY id DESC LIMIT 1]
  230. SQL[SELECT * FROM syslog WHERE (syslog.device_id = '8') && (syslog.timestamp >= (DATE_SUB(NOW(),INTERVAL 5 MINUTE)) && syslog.msg REGEXP ".*authentication error.*" )]
  231. Status: NOCHG
  232. Rule #23 (Syslog - Failed password):
  233. SQL[SELECT state FROM alerts WHERE rule_id = '23' && device_id = '8' ORDER BY id DESC LIMIT 1]
  234. SQL[SELECT * FROM syslog WHERE (syslog.device_id = '8') && (syslog.timestamp >= (DATE_SUB(NOW(),INTERVAL 5 MINUTE)) && syslog.msg REGEXP ".*Failed password.*" )]
  235. Status: NOCHG
  236. #### End Alerts ####
  237. SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','picam.quantum.lan','1501934364.4716','2.214','1','velocity\n')]
  238. ./poller.php picam.quantum.lan 2017-08-05 07:59:26 - 1 devices polled in 2.214 secs
  239. SNMP: Get[8/1.54s] Walk [0/0.00s]
  240. MySQL: Cell[9/0.00s] Row[15/0.01s] Rows[25/0.03s] Column[3/0.00s] Update[15/0.07s] Insert[2/0.01s] Delete[0/0.00s]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!