Cacti provides an operational monitoring and fault management framework. Prior
to version 1.2.27, a SQL injection vulnerability in
`automation_get_new_graphs_sql` function of `api_automation.php` allows
authenticated users to exploit these SQL injection vulnerabilities to perform
privilege escalation and remote code execution. In `api_automation.php` line
856, the `get_request_var('filter')` is being concatenated into the SQL
statement without any sanitization. In `api_automation.php` line 717, The
filter of `'filter'` is `FILTER_DEFAULT`, which means there is no filter for
it. Version 1.2.27 contains a patch for the issue.

References:
http://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2024-31445
https://www.cve.org/CVERecord?id=CVE-2024-31445
https://github.com/Cacti/cacti/blob/501712998589763d411a68d35e3cda98fd9cfd18/lib/api_automation.php#L717
https://github.com/Cacti/cacti/blob/501712998589763d411a68d35e3cda98fd9cfd18/lib/api_automation.php#L856
https://github.com/Cacti/cacti/commit/fd93c6e47651958b77c3bbe6a01fff695f81e886
https://github.com/Cacti/cacti/security/advisories/GHSA-vjph-r677-6pcc

Bug ID	1224237
Summary	VUL-0: CVE-2024-31445: cacti: SQL injection vulnerability when retrieving graphs using Automation API
Classification	openSUSE
Product	openSUSE Distribution
Version	Leap 15.6
Hardware	Other
URL	https://smash.suse.de/issue/405129/
OS	Other
Status	NEW
Severity	Normal
Priority	P5 - None
Component	Security
Assignee	Andreas.Stieger@gmx.de
Reporter	smash_bz@suse.de
QA Contact	security-team@suse.de
CC	camila.matos@suse.com
Target Milestone	---
Found By	Security Response Team
Blocker	---