Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LibreNMS Poller
- ===================================
- Version info:
- Commit SHA: 0ff847a9b3fad5a5766c5da9aca9d3cb453360f2
- Commit Date: 1501783261
- DB Schema: 200
- PHP: 7.0.15-0ubuntu0.16.04.4
- MySQL: 5.7.19-0ubuntu0.16.04.1
- RRDTool: 1.5.5
- SNMP: NET-SNMP 5.7.3
- ==================================DEBUG!
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'piweather.quantum.lan' ORDER BY `device_id` ASC]
- SQL[SELECT * FROM devices_attribs WHERE `device_id` = '9']
- Hostname: piweather.quantum.lan
- Device ID: 9
- OS: linux (unix)
- SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','72.5','86.0','78.5','9',NOW())]
- SNMP Check response code: 0
- 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]
- sysUpTime.0 = 2380942
- sysLocation.0 = Sitting on the Dock of the Bay
- sysContact.0 = Me <me@example.org>
- sysName.0 = piweather
- sysObjectID.0 = enterprises.8*
- 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]
- Linux piweather 4.1.19+ #858 Tue Mar 15 15:52:03 GMT 2016 armv6l
- 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]
- snmpEngineTime.0 = 23809
- hrSystemUptime.0 = 46386520
- Uptime seconds: 463865
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/uptime.rrd N:463865]
- [RRD Disabled]Uptime: 5 days, 8h 51m 5s
- Using cached lat/lng from other device
- Modules status: Global+ OS Device
- #### Load poller module sensors ####
- SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = '9' GROUP BY `sensor_class`]
- SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '9']
- 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]
- .*.4.1.8*.*.*.*.121.6 = "700000000"
- .*.4.1.8*.*.*.*.121.7 = "250000000"
- Checking (snmp) frequency ARM...
- Checking (snmp) frequency Core...
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-frequency-raspberry_freq-6.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Frequency' AND `sensor_id` = '87']
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-frequency-raspberry_freq-7.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Frequency' AND `sensor_id` = '88']
- SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '9']
- 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]
- .*.4.1.8*.*.*.*.121.8 = "enabled"
- .*.4.1.8*.*.*.*.121.9 = "disabled"
- .*.4.1.8*.*.*.*.121.10 = "disabled"
- .*.4.1.8*.*.*.*.121.11 = "enabled"
- .*.4.1.8*.*.*.*.121.12 = "enabled"
- .*.4.1.8*.*.*.*.121.13 = "WMV9=disabled"
- Checking (snmp) state H264 codec...
- SQL[SELECT `state_value`
- FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
- ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
- WHERE `sensors_to_state_indexes`.`sensor_id` = '34'
- AND `state_translations`.`state_descr` LIKE '']
- State value of is
- Checking (snmp) state MPG2 codec...
- SQL[SELECT `state_value`
- FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
- ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
- WHERE `sensors_to_state_indexes`.`sensor_id` = '35'
- AND `state_translations`.`state_descr` LIKE '']
- State value of is
- Checking (snmp) state WVC1 codec...
- SQL[SELECT `state_value`
- FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
- ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
- WHERE `sensors_to_state_indexes`.`sensor_id` = '36'
- AND `state_translations`.`state_descr` LIKE '']
- State value of is
- Checking (snmp) state MPG4 codec...
- SQL[SELECT `state_value`
- FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
- ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
- WHERE `sensors_to_state_indexes`.`sensor_id` = '37'
- AND `state_translations`.`state_descr` LIKE '']
- State value of is
- Checking (snmp) state MJPG codec...
- SQL[SELECT `state_value`
- FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
- ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
- WHERE `sensors_to_state_indexes`.`sensor_id` = '38'
- AND `state_translations`.`state_descr` LIKE '']
- State value of is
- Checking (snmp) state WMV9 codec...
- SQL[SELECT `state_value`
- FROM `state_translations` LEFT JOIN `sensors_to_state_indexes`
- ON `state_translations`.`state_index_id` = `sensors_to_state_indexes`.`state_index_id`
- WHERE `sensors_to_state_indexes`.`sensor_id` = '39'
- AND `state_translations`.`state_descr` LIKE '']
- State value of is
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-state-raspberry_codec-8.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '34']
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-state-raspberry_codec-9.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '35']
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-state-raspberry_codec-10.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '36']
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-state-raspberry_codec-11.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '37']
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-state-raspberry_codec-12.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '38']
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-state-raspberry_codec-13.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'State' AND `sensor_id` = '39']
- SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '9']
- 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]
- .*.4.1.8*.*.*.*.121.1 = "44.4"
- Checking (snmp) temperature CPU Temp...
- 44.4
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-temperature-raspberry_temp-1.rrd N:44.4]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='44.4',`sensor_prev` ='44.4',`lastupdate` =NOW() WHERE `sensor_class` = 'Temperature' AND `sensor_id` = '79']
- SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '9']
- 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]
- .*.4.1.8*.*.*.*.121.2 = "1.2000"
- .*.4.1.8*.*.*.*.121.3 = "1.2000"
- .*.4.1.8*.*.*.*.121.4 = "1.2000"
- .*.4.1.8*.*.*.*.121.5 = "1.2250"
- Checking (snmp) voltage Core...
- Checking (snmp) voltage SDRAMc...
- Checking (snmp) voltage SDRAMi...
- Checking (snmp) voltage SDRAMp...
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-voltage-rasbperry_volts-2.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Voltage' AND `sensor_id` = '89']
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-voltage-rasbperry_volts-3.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Voltage' AND `sensor_id` = '90']
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-voltage-rasbperry_volts-4.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Voltage' AND `sensor_id` = '91']
- 0
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/sensor-voltage-rasbperry_volts-5.rrd N:0]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='0',`sensor_prev` ='0',`lastupdate` =NOW() WHERE `sensor_class` = 'Voltage' AND `sensor_id` = '92']
- >> Runtime for poller module 'sensors': 2.7224 seconds with 264 bytes
- #### Unload poller module sensors ####
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/poller-perf-sensors.rrd N:2.7224290370941]
- [RRD Disabled]### Start Device Groups ###
- SQL[SELECT * FROM device_groups ORDER BY name]
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='9']
- Groups Added:
- Groups Removed:
- ### End Device Groups ###
- RRD[update /opt/librenms/rrd/piweather.quantum.lan/ping-perf.rrd N:78.5]
- [RRD Disabled]RRD[update /opt/librenms/rrd/piweather.quantum.lan/poller-perf.rrd N:3.373]
- [RRD Disabled]Polled in 3.373 seconds
- Updating piweather.quantum.lan
- SQL[UPDATE `devices` set `uptime` ='463865',`last_ping` =NOW(),`last_ping_timetaken` ='78.5',`last_polled` =NOW(),`last_polled_timetaken` ='3.373' WHERE `device_id` = '9']
- UPDATED!
- #### Start Alerts ####
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='9']
- 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 = '9' ) && ((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]
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='9']
- 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 = '9' ) || alert_map.target = '9' )]
- Rule #1 (Devices down):
- SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices WHERE (devices.device_id = '9') && (((devices.status = 0 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" )]
- Status: NOCHG
- Rule #2 (Device rebooted):
- SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices WHERE (devices.device_id = '9') && (devices.uptime < "300" && ((devices.disabled = 0 && devices.ignore = 0)) = "1")]
- Status: NOCHG
- Rule #6 (Port utilisation over threshold):
- SQL[SELECT state FROM alerts WHERE rule_id = '6' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '9') && ((((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" )]
- Status: NOCHG
- Rule #7 (Sensor over limit):
- SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '9') && (sensors.sensor_current > sensors.sensor_limit && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" )]
- Status: NOCHG
- Rule #8 (Sensor under limit):
- SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '9') && (sensors.sensor_current < sensors.sensor_limit_low && sensors.sensor_alert = "1" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" )]
- 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 = '9' && alert_log.rule_id = '8' && alert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1]
- SQL[UPDATE `alert_log` set `details` ='x���o�6��A���z�����HҢ-�(Zbl������N���N�%@�c���x�\'7~)K��ٍ_����/�6ՋeM� �����Ŀ=�̟}��5k�T�`-��b���`\',�p���W˚r\rK�x�Sxo�Lf���n�v�_�Z!�IJB2�\'��� �_#2%a8!��x@��{i�D!IwyS�k�yG4���nL�u���\rL�\n����y���� k+og{��*�\Zs?5��EY����RqEU��\Z+�ނ�W@�}���^\nI6�~i3�X�<|�Zk^R�zHҰ_^Ԍj��ԃ��ض��av����
- ��$�Ewz�U��`5���6���Jj��\Zm�:Ѭ�\"_-m�� t%ZY�=\r���\nH�(�mm֨h�� �֬�\0a#��v!�*ލK�����vhݗ%f%/?[��XJX8?�S���Qw�>���x�nCKw}OtQ�7�P�Kam�(����5����D)fgz��Ų=�P��VYy���J���@��j!\n��Y�I�\r�����g����6�NR8���%Or�e�9U^���,�fA�:��AeS���K�`�d�@0��f/�5�[�T��Ab�\\B�}�����91ׯX�/=��������<�����3\r
- �5��?eͼcpOC��KV))k�c<%Q�Axt��v��A� �J�&0Zt��z3�K���{��H�F�a�*��Bl�3�bY0�4�S,<]B����p��:��; [��\Z���ܟ�q{�V\r��е���V)!�*��P�Љl����o��{�d9IpkU+5Ҷ�����y���MP���[�%�[�n�S�+^���lWo�T#ͮ�qR\n6Y�^��e�z�ۣ=6�σM�!��G����)J��)p��,qprprprprpz\0N�N\n��o��)M��G��=6A4�#�� rDrDrDrDrD�G�i��)~<�ޟ�����I�I�I�I�I?-�����!�&OdwLrLrLrLrL�i�=&%�LJ�Ȥ��0iӔ<K�0J������d��a�wxx�a�M� ��%ѡ�' WHERE id = '4396']
- Rule #9 (Service up/down):
- SQL[SELECT state FROM alerts WHERE rule_id = '9' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM services,devices WHERE (( devices.device_id = services.device_id ) && services.device_id = '9') && (services.service_status != "0" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" )]
- Status: NOCHG
- Rule #16 (Storage Over 90%):
- SQL[SELECT state FROM alerts WHERE rule_id = '16' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM storage WHERE (storage.device_id = '9') && (storage.storage_descr NOT REGEXP "/boot" && storage.storage_descr NOT REGEXP "/var/dhcpd/dev" && storage.storage_perc >= "90" )]
- Status: NOCHG
- Rule #17 (Interface Output Errors over threshold):
- SQL[SELECT state FROM alerts WHERE rule_id = '17' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '9') && (ports.ifOutErrors_delta > "1" && ports.ifDescr NOT REGEXP "Dot11Radio" )]
- Status: NOCHG
- Rule #18 (Processor usage over 85%):
- SQL[SELECT state FROM alerts WHERE rule_id = '18' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM processors,devices WHERE (( devices.device_id = processors.device_id ) && processors.device_id = '9') && (processors.processor_usage > "85" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1" && devices.hostname NOT REGEXP "cgsyslog" )]
- Status: NOCHG
- Rule #19 (Port status changed to down):
- SQL[SELECT state FROM alerts WHERE rule_id = '19' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '9') && (ports.ifOperStatus = "down" && ports.ifOperStatus_prev = "up" && ports.deleted = "0" && ports.ignore = "0" && ports.disabled = "0" )]
- Status: NOCHG
- Rule #20 (Interface Input Errors over threshold):
- SQL[SELECT state FROM alerts WHERE rule_id = '20' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '9') && (ports.ifInErrors_delta > "1" && ports.ifDescr NOT REGEXP "Dot11Radio" )]
- Status: NOCHG
- Rule #21 (Syslog - Authentication Failure):
- SQL[SELECT state FROM alerts WHERE rule_id = '21' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM syslog WHERE (syslog.device_id = '9') && (syslog.timestamp >= (DATE_SUB(NOW(),INTERVAL 5 MINUTE)) && syslog.msg REGEXP ".*authentication failure.*" )]
- Status: NOCHG
- Rule #22 (Syslog - Authentication Error):
- SQL[SELECT state FROM alerts WHERE rule_id = '22' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM syslog WHERE (syslog.device_id = '9') && (syslog.timestamp >= (DATE_SUB(NOW(),INTERVAL 5 MINUTE)) && syslog.msg REGEXP ".*authentication error.*" )]
- Status: NOCHG
- Rule #23 (Syslog - Failed password):
- SQL[SELECT state FROM alerts WHERE rule_id = '23' && device_id = '9' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM syslog WHERE (syslog.device_id = '9') && (syslog.timestamp >= (DATE_SUB(NOW(),INTERVAL 5 MINUTE)) && syslog.msg REGEXP ".*Failed password.*" )]
- Status: NOCHG
- #### End Alerts ####
- SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','piweather.quantum.lan','1501879704.0419','3.477','1','velocity\n')]
- ./poller.php piweather.quantum.lan 2017-08-04 16:48:27 - 1 devices polled in 3.477 secs
- SNMP: Get[8/2.75s] Walk [0/0.00s]
- MySQL: Cell[9/0.01s] Row[15/0.01s] Rows[25/0.04s] Column[3/0.00s] Update[15/0.10s] Insert[2/0.02s] Delete[0/0.00s]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement