[root@bambiraptor ~]# sudo -u librenms /u01/librenms/alerts.php -d
DEBUG!
Start: Mon, 02 Oct 2017 16:34:36 -0600
ClearStaleAlerts():
SQL[SELECT `alerts`.`id` AS `alert_id`, `devices`.`hostname` AS `hostname` FROM `alerts` LEFT JOIN `devices` ON `alerts`.`device_id`=`devices`.`device_id`  RIGHT JOIN `alert_rules` ON `alerts`.`rule_id`=`alert_rules`.`id` WHERE `alerts`.`state`!=0 AND `devices`.`hostname` IS NULL]
RunFollowUp():
SQL[SELECT alerts.device_id, alerts.rule_id, alerts.state FROM alerts WHERE alerts.state != 2 && alerts.state > 0 && alerts.open = 0]
RunAlerts():
SQL[SELECT alerts.device_id, alerts.rule_id, alerts.state FROM alerts WHERE alerts.state != 2 && alerts.open = 1]
SQL[SELECT alert_log.id,alert_log.rule_id,alert_log.device_id,alert_log.state,alert_log.details,alert_log.time_logged,alert_rules.rule,alert_rules.severity,alert_rules.extra,alert_rules.name FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = '1' && alert_log.rule_id = '60' && alert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1]
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='1']
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 = '1' ) || alert_map.target = '1'  || alert_map.target = 'g4' )]
SQL[SELECT alerts.alerted,devices.ignore,devices.disabled FROM alerts,devices WHERE alerts.device_id = '1' && devices.device_id = alerts.device_id && alerts.rule_id = '60']
SQL[SELECT alert_log.id,alert_log.rule_id,alert_log.device_id,alert_log.state,alert_log.details,alert_log.time_logged,alert_rules.rule,alert_rules.severity,alert_rules.extra,alert_rules.name FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = '8' && alert_log.rule_id = '83' && alert_rules.disabled = 0 ORDER BY alert_log.id DESC 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'  || alert_map.target = 'g1' || alert_map.target = 'g4' )]
SQL[SELECT alerts.alerted,devices.ignore,devices.disabled FROM alerts,devices WHERE alerts.device_id = '8' && devices.device_id = alerts.device_id && alerts.rule_id = '83']
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_items.target = 'g1' || alert_schedule_items.target = 'g4' ) && ((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[UPDATE `alert_log` set `details` ='xڅTßoÚ0þW¬ì¡/ÅMB Oe”N­ÚNڗuŠLâ3Ƕüƒ.ªú¿ïL¥¬Û¢(âîŸûîüùŽ— Â’š {	®÷‚ý\Z—5絑ØÕÓÒY@Œ«‰•:8\rÖR`-—Lyœ–ͺ uC6¢)©>Î ‚捀à̊4‚âµ\\}À9ßÑu^Öq\Zdß_‚’nXAsVl<+i¬ 5ƒgkzkÂxŒ™}cƒR¹û7‚)F!†7ÅÉ<…¬k\'˜m p»˜Ogà%ή8ÝPdÂqÞ:Úêo¶\"ÆڄWrgºQV\"ZÏ!ƈZm@£,ØÄUR[ß^\Z
7\"Lçq¥òVSéì.[S«ÝÓ/+u#ÂÇ{šñm¹Š…œº\0*,ÕJ3C\r†ƒ÷qŒ‡­hÔŸKMé—ùúP=E8ìÍŠ7Óñ|ÚS#ŽCû?…Z8ŠÆJC…Ã,7D÷‹	ŠÃh€ü£¥Žç€.Ó€·tŒÃšà’ÐZ\nÉeÕ`AmöxæŒ~<“Ëu÷Ëè>y<û:œ›Î®&hKОaҎ;œâoÃ~\Z€Ø†Á˜Æï{öãEtùLŽžë%Öi/qÐ\'‘mKòpëÐÉ%\'vEIy‚&ܐõ±ÝÀCŠôO ÖҔŸYŽÞí\\Sb¶œ~F+!·}„`”̐%§eg:å§\0ŒA\ZEÉ(ö£ZÁÕæû€Gqbl®$oóŒæœ(ì…1ŠÒ¬Ÿdáð“ki­¬Ç¶ƒsž{VK~Rß[Šãd—	}ô<‚ôq4ørÔDœõûYÒß7ÁDõŸ6
ñ®LŒt厒f¿“¶Q^
CõŠý硚‘ý³b+pwØlªíÊÁ)u^iéT\'žoY³’æ0T7o—íCBÚ·…ó»™Ã~˂m1y-KºœÕ×PͯÛÆW>‡éhØOéëo+dÏý' WHERE id = '1577']
SQL[SELECT attrib_value FROM devices_attribs WHERE attrib_type = "disable_notify" && device_id = '8']
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT * FROM devices WHERE (devices.device_id = '8') && (devices.hostname REGEXP "wts-jail" )]
SQL[SELECT * FROM `users` ORDER BY `username`]
SQL[SELECT attrib_value FROM devices_attribs WHERE attrib_type = 'override_sysContact_bool' AND device_id = '8']
SQL[SELECT sysContact FROM devices WHERE device_id = '8']
SQL[SELECT user_id FROM devices_perms WHERE access_level >= 0 AND device_id = '8']
SQL[SELECT hostname, sysName, sysDescr, hardware, version, location, purpose, notes, uptime FROM devices WHERE device_id = '8']
SQL[SELECT `template`,`title`,`title_rec` FROM `alert_templates` JOIN `alert_template_map` ON `alert_template_map`.`alert_templates_id`=`alert_templates`.`id` WHERE `alert_template_map`.`alert_rule_id`='83']
SQL[SELECT `template`,`title`,`title_rec` FROM `alert_templates`  WHERE `name`='Default Alert Template']
Issuing Alert-UID #1577/1: ; ;