An SQL Injection vulnerability exists in the dashboard widget data API endpoint (/api/data/{type})

Overview

An SQL Injection vulnerability exists in the dashboard widget data API endpoint (/api/data/{type}). Chart filter parameters supplied by the client are not properly validated before they are used in the database queries that build dashboard chart data. An authenticated user with API access can exploit this to inject SQL into these reporting queries. Using blind SQL injection techniques, the attacker can read arbitrary data from the Mautic database, including contact and other marketing data and user account data with password hashes. The injected SQL can also be used to slow down database queries, which can have a limited impact on availability. Data modification is not possible through this vulnerability. Exploitation requires the Mautic API to be enabled.

Affected

• mautic/core >= 2.8.1 < 5.2.12
• mautic/core >= 6.0.0 < 6.0.10
• mautic/core >= 7.0.0 < 7.2.2

Remediation

Refer to the linked advisories for vendor-supplied fixes and affected version ranges.

Workarounds

There are no official workarounds. To mitigate this vulnerability without upgrading, disable the Mautic API if it is not needed, or restrict API access to trusted users only.