CVE-2024-31445

Name	CVE-2024-31445
Description	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.
Source	CVE (at NVD; CERT, LWN, oss-sec, fulldisc, Red Hat, Ubuntu, Gentoo, SUSE bugzilla/CVE, GitHub advisories/code/issues, web search, more)
References	DLA-3884-1

Vulnerable and fixed packages

The table below lists information on source packages.

Source Package	Release	Version	Status
cacti (PTS)	bullseye	1.2.16+ds1-2+deb11u3	vulnerable
	bullseye (security)	1.2.16+ds1-2+deb11u4	fixed
	bookworm	1.2.24+ds1-1+deb12u4	fixed
	bookworm (security)	1.2.24+ds1-1+deb12u2	vulnerable
	sid, trixie	1.2.28+ds1-2	fixed

The information below is based on the following data on fixed versions.

Package	Type	Release	Fixed Version	Origin
cacti	source	bullseye	1.2.16+ds1-2+deb11u4	DLA-3884-1
cacti	source	bookworm	1.2.24+ds1-1+deb12u3
cacti	source	(unstable)	1.2.27+ds1-1

https://github.com/Cacti/cacti/security/advisories/GHSA-vjph-r677-6pcc
https://github.com/Cacti/cacti/commit/fd93c6e47651958b77c3bbe6a01fff695f81e886