GHSA-p64x-8rxx-wf6q
CRITICAL
Django `Trunc()` and `Extract()` database functions vulnerable to SQL Injection
Published July 5, 2022Updated February 21, 2025Source: osv
Details
An issue was discovered in Django 3.2 before 3.2.14 and 4.0 before 4.0.6. The `Trunc()` and `Extract()` database functions are subject to SQL injection if untrusted data is used as a kind/lookup_name value. Applications that constrain the lookup name and kind choice to a known safe list are unaffected.
Remediation
Upgrade to the fixed version using your package manager.
pip
Update django to 4.0.6 or laterpip install "django>=4.0.6"
pip
Update django to 3.2.14 or laterpip install "django>=3.2.14"
After upgrading, run your dependency scanner again to confirm the vulnerability is resolved.
Affected Packages (2)
Vulnerability Classification
Common Weakness Enumeration (CWE) identifiers for this vulnerability type.
- CWE-89SQL InjectionMITRE
CVSS Score Breakdown
What the CVSS (Common Vulnerability Scoring System) 3.1 score means for each attack dimension.
Attack Vector
Network
Attack Complexity
Low
Privileges Required
None
User Interaction
None
Scope
Unchanged
Confidentiality
High
Integrity
High
Availability
High
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
References
- https://nvd.nist.gov/vuln/detail/CVE-2022-34265ADVISORY
- https://github.com/django/django/commit/0dc9c016fadb71a067e5a42be30164e3f96c0492WEB
- https://github.com/django/django/commit/5e2f4ddf2940704a26a4ac782b851989668d74dbWEB
- https://github.com/django/django/commit/877c800f255ccaa7abde1fb944de45d1616f5cc9WEB
- https://github.com/django/django/commit/a9010fe5555e6086a9d9ae50069579400ef0685eWEB
- https://docs.djangoproject.com/en/4.0/releases/securityWEB
- https://github.com/advisories/GHSA-p64x-8rxx-wf6qADVISORY
- https://github.com/django/djangoPACKAGE
- https://github.com/pypa/advisory-database/tree/main/vulns/django/PYSEC-2022-213.yamlWEB
- https://groups.google.com/forum/#!forum/django-announceWEB
- https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/HWY6DQWRVBALV73BPUVBXC3QIYUM24IKWEB
- https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/LTZVAKU5ALQWOKFTPISE257VCVIYGFQIWEB
- https://security.netapp.com/advisory/ntap-20220818-0006WEB
- https://www.debian.org/security/2022/dsa-5254WEB
- https://www.djangoproject.com/weblog/2022/jul/04/security-releasesWEB
Risk Assessment
CVSS Score
3.1
Exploitation is difficult or impact is minor. Address in your next planned update.
EPSS Score (30-day exploit probability)
92.83%
Higher than 100% of vulnerabilities
Also Known As
Check if you're affected
Scan your dependencies to see if this vulnerability affects your projects.
Scan Your Dependencies