What is CVE-2024-56374?

A SQL injection vulnerability in Django's QuerySet.annotate(), aggregate(), and extra() methods allows attackers to execute arbitrary SQL through unsanitized user-controlled input in certain conditions.

How do I fix CVE-2024-56374?

Upgrade Django to 4.2.17+, 5.0.10+, or 5.1.4+ immediately. Audit all QuerySet.annotate(), aggregate(), and extra() calls for user-controlled inputs. Never pass raw user input directly to Django ORM annotation/aggregation methods. Use Django's parameterized queries (Func(), Value(), etc.) instead of raw strings. Enable SQL query logging in staging to detect suspicious patterns. Run django.test.utils.CaptureQueriesContext to audit queries in tests.

Which versions are affected by CVE-2024-56374?

Affected: Django < 4.2.17, < 5.0.10, < 5.1.4. Fixed in: Django 4.2.17+, 5.0.10+, 5.1.4+.

highCVSS 7.5/10·Published: 2024-12-19·Django

How to fix CVE-2024-56374 – Step-by-Step Guide

CVE-2024-56374 is a high-severity SQL injection vulnerability affecting Django applications. Published on December 19, 2024, it allows attackers to execute arbitrary SQL commands. This critical flaw specifically impacts Django's `QuerySet.annotate()` method and related ORM functions.

CVE ID

CVE-2024-56374

Severity

HIGH

CVSS Score

7.5/10

Affected

Django

What is Django SQL Injection via QuerySet.annotate()?

This SQL injection vulnerability arises when unsanitized, user-controlled input is directly passed to Django's `QuerySet.annotate()`, `aggregate()`, or `extra()` methods. Attackers can craft malicious input that is then incorporated into the database query without proper escaping. This allows them to execute arbitrary SQL commands against the underlying database.

Affected Versions

Django < 4.2.17, < 5.0.10, < 5.1.4

Fixed In

Django 4.2.17+, 5.0.10+, 5.1.4+

Official References

Impact and Risks for your Infrastructure

The primary impact of CVE-2024-56374 is the potential for unauthorized data exfiltration, allowing attackers to steal sensitive information from your database. It can also lead to authentication bypass, granting unauthorized access to your application, and enable full database manipulation, compromising data integrity and availability.

djangosql-injectionpythonhigh2024

Step-by-Step Mitigation Guide

To mitigate CVE-2024-56374, immediately upgrade your Django installation to a patched version: 4.2.17+, 5.0.10+, or 5.1.4+. Verify the fix by checking your Django version using `python -m django --version` to ensure it meets or exceeds the specified secure versions.

1Upgrade Django to 4.2.17+, 5.0.10+, or 5.1.4+ immediately.
2Audit all QuerySet.annotate(), aggregate(), and extra() calls for user-controlled inputs.
3Never pass raw user input directly to Django ORM annotation/aggregation methods.
4Use Django's parameterized queries (Func(), Value(), etc.) instead of raw strings.
5Enable SQL query logging in staging to detect suspicious patterns.
6Run django.test.utils.CaptureQueriesContext to audit queries in tests.

Frequently Asked Questions

What is the CVSS score for CVE-2024-56374?▼

CVE-2024-56374 has a CVSS score of 7.5/10 (high severity). This reflects a significant security risk that should be addressed promptly.

Which versions of Django are affected?▼

Affected: Django < 4.2.17, < 5.0.10, < 5.1.4. The vulnerability was fixed in: Django 4.2.17+, 5.0.10+, 5.1.4+.

How long does it take to fix CVE-2024-56374?▼

For most teams: 15–60 minutes to apply the patch, plus 15 minutes of post-patch verification. Complex multi-service environments may require 2–4 hours including staging validation.

Is CVE-2024-56374 being actively exploited?▼

Check the NVD entry and CISA KEV catalog for exploitation status. As a high-severity vulnerability, treat it as a priority remediation regardless of known exploitation status.

Run Security Check →Browse Runbooks →← All CVE Solutions

This CVE fix guide is based on publicly available security advisories (NVD, vendor bulletins). Always test changes in a staging environment before applying to production. Verify against the official vendor advisory for the most up-to-date guidance.