Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LibreNMS Poller
- ===================================
- Version info:
- Commit SHA: 4e56ee17b8fafad4da48dd5a176c2263ce2a5cfe
- Commit Date: 1501874206
- DB Schema: 201
- 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` = 'picam.quantum.lan' ORDER BY `device_id` ASC]
- SQL[SELECT * FROM devices_attribs WHERE `device_id` = '8']
- Hostname: picam.quantum.lan
- Device ID: 8
- OS: linux (unix)
- SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','25.7','37.5','32.0','8',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 = 15948284
- sysLocation.0 = Sitting on the Dock of the Bay
- sysContact.0 = Me <me@example.org>
- sysName.0 = picam
- 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 picam 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 = 159482
- hrSystemUptime.0 = 424089940
- Uptime seconds: 4240899
- RRD[update /opt/librenms/rrd/picam.quantum.lan/uptime.rrd N:4240899]
- [RRD Disabled]Uptime: 49 days, 2h 1m 39s
- 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` = '8' GROUP BY `sensor_class`]
- SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '8']
- 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/picam.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` = '93']
- 0
- RRD[update /opt/librenms/rrd/picam.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` = '94']
- SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '8']
- 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 = "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` = '80'
- 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` = '81'
- 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` = '82'
- 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` = '83'
- 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` = '84'
- 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` = '85'
- AND `state_translations`.`state_descr` LIKE '']
- State value of is
- 0
- RRD[update /opt/librenms/rrd/picam.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` = '80']
- 0
- RRD[update /opt/librenms/rrd/picam.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` = '81']
- 0
- RRD[update /opt/librenms/rrd/picam.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` = '82']
- 0
- RRD[update /opt/librenms/rrd/picam.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` = '83']
- 0
- RRD[update /opt/librenms/rrd/picam.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` = '84']
- 0
- RRD[update /opt/librenms/rrd/picam.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` = '85']
- SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '8']
- 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 = "48.7"
- Checking (snmp) temperature CPU Temp...
- 48.7
- RRD[update /opt/librenms/rrd/picam.quantum.lan/sensor-temperature-raspberry_temp-1.rrd N:48.7]
- [RRD Disabled]SQL[UPDATE `sensors` set `sensor_current` ='48.7',`sensor_prev` ='49.8',`lastupdate` =NOW() WHERE `sensor_class` = 'Temperature' AND `sensor_id` = '86']
- SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '8']
- 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/picam.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` = '95']
- 0
- RRD[update /opt/librenms/rrd/picam.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` = '96']
- 0
- RRD[update /opt/librenms/rrd/picam.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` = '97']
- 0
- RRD[update /opt/librenms/rrd/picam.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` = '98']
- >> Runtime for poller module 'sensors': 1.4275 seconds with 264 bytes
- #### Unload poller module sensors ####
- RRD[update /opt/librenms/rrd/picam.quantum.lan/poller-perf-sensors.rrd N:1.4275040626526]
- [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`='8']
- Groups Added:
- Groups Removed:
- ### End Device Groups ###
- RRD[update /opt/librenms/rrd/picam.quantum.lan/ping-perf.rrd N:32.0]
- [RRD Disabled]RRD[update /opt/librenms/rrd/picam.quantum.lan/poller-perf.rrd N:2.233]
- [RRD Disabled]Polled in 2.233 seconds
- Updating picam.quantum.lan
- SQL[UPDATE `devices` set `uptime` ='4240899',`last_ping` =NOW(),`last_ping_timetaken` ='32.0',`last_polled` =NOW(),`last_polled_timetaken` ='2.233' WHERE `device_id` = '8']
- UPDATED!
- #### Start Alerts ####
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='8']
- 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]
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='8']
- 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' )]
- Rule #1 (Devices down):
- SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '8' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices WHERE (devices.device_id = '8') && (((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 = '8' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices WHERE (devices.device_id = '8') && (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 = '8' ORDER BY id DESC LIMIT 1]
- 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" )]
- Status: NOCHG
- Rule #7 (Sensor over limit):
- SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '8' ORDER BY id DESC LIMIT 1]
- 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" )]
- Status: NOCHG
- Rule #8 (Sensor under limit):
- SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '8' ORDER BY id DESC LIMIT 1]
- 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" )]
- 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]
- SQL[UPDATE `alert_log` set `details` ='x���o�6��A�D�Òlc�W I��ؗ�h�q�P�ʇ#���;I~�n�9@7`����xO��R\nCJ���_�)��J�9՛EMJY�S����|�+˩?���k*�T�@7I�\Z��p#,9�p���WKE�UE[V�����9U�Y6p��E�l���*\n�
- �`�q��\n��1&A��I?)|A0�0��7��l㑉�>��-�p�\"��S��F���.�gח[B�2���6��r�\Z�莼�JQa^�����(OҰ��QD *,�;\n.0��;�@��lv�Ҧ�!D��n�YI�H��]yQS���V��cc���bF�i8>\r3/��q:m]�(�U�\Zz~kE�u\r3K�A�ٗ����6��xg���WK��u\0�7.�Ֆ$���� �O<�wm8G#;�!��Ӗr\n9��+�A�vP\r7v�2��~��35w����AA�B���<��Բ1r�]?&��o0d�6.����a�\"B[�VSi;
- ���F1�We�/�
- -�����/�4����������)ܨ�؝#�}�z�m��g�q:�>Z�]�E)�O�x\Z&��ˏt?�ی�����z���\r}$u�i ��W0�|5�0���;KT�u~KU��`�Z��[J�����=(8�jzGȚz�ލ���)�qfatr�g��8���3��c���z� �C�`�;�8>
- !���F�d��o;�`30�x�\'�T�X+�\n���v�wemSchݘ�k6/Ы!�c�!��I���P�}�l�d?��4]�5L,�!L�xqM�먱����u[�ש���W�b���beWߪkf���
- 3�V����Ŧ���f3� �,YgSԲ������Fǁ�|]���:���슳8}\r��$O�����gW�/��Jn�����}r��\"�ȅ���]���@jEA;`9`9`9`9`�����+9X7�׳��!�!�!�!�!�X���F��\Z�Y�!�!�!�!�!�X�5>d���J_����
- �=O��(�S....���g�g��ˣ4��8���D��]' WHERE id = '4395']
- Rule #9 (Service up/down):
- SQL[SELECT state FROM alerts WHERE rule_id = '9' && device_id = '8' ORDER BY id DESC LIMIT 1]
- 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" )]
- Status: NOCHG
- Rule #16 (Storage Over 90%):
- SQL[SELECT state FROM alerts WHERE rule_id = '16' && device_id = '8' ORDER BY id DESC LIMIT 1]
- 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" )]
- Status: NOCHG
- Rule #17 (Interface Output Errors over threshold):
- SQL[SELECT state FROM alerts WHERE rule_id = '17' && device_id = '8' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '8') && (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 = '8' ORDER BY id DESC LIMIT 1]
- 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" )]
- Status: NOCHG
- Rule #19 (Port status changed to down):
- SQL[SELECT state FROM alerts WHERE rule_id = '19' && device_id = '8' ORDER BY id DESC LIMIT 1]
- 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" )]
- Status: NOCHG
- Rule #20 (Interface Input Errors over threshold):
- SQL[SELECT state FROM alerts WHERE rule_id = '20' && device_id = '8' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '8') && (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 = '8' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM syslog WHERE (syslog.device_id = '8') && (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 = '8' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM syslog WHERE (syslog.device_id = '8') && (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 = '8' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM syslog WHERE (syslog.device_id = '8') && (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','picam.quantum.lan','1502033139.2335','2.319','1','velocity\n')]
- ./poller.php picam.quantum.lan 2017-08-06 11:25:41 - 1 devices polled in 2.319 secs
- SNMP: Get[8/1.55s] Walk [0/0.00s]
- MySQL: Cell[9/0.01s] Row[15/0.01s] Rows[25/0.03s] Column[3/0.00s] Update[15/0.05s] Insert[2/0.18s] Delete[0/0.00s]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement