CVE-2020-7471
Description
Django 1.11 before 1.11.28, 2.2 before 2.2.10, and 3.0 before 3.0.3 allows SQL Injection if untrusted data is used as a StringAgg delimiter (e.g., in Django applications that offer downloads of data as a series of rows with a user-specified column delimiter). By passing a suitably crafted delimiter to a contrib.postgres.aggregates.StringAgg instance, it was possible to break escaping and inject malicious SQL.
Predictions
Heuristic predictions, AS-IS, for prioritization only.
Mitigations
No mitigations published for this CVE yet.
The vendor-content worker queues fetches as references arrive (check back in a few minutes). Or — if you've already worked around this in production — publish your fix to the community-verified tier.
✚ Propose a mitigation on Community → Mitigations published via the community go through AI scoring + 2 human reviewers + 7-day silent objection window before landing here withsource_tier=community-verified.
OS impact
SUSE Affected 1 release
| Version | Status | Fixed in |
|---|---|---|
| — | Affected | — |
Arch Fixed 1 release
| Version | Status | Fixed in |
|---|---|---|
| — | Fixed | 3.0.3-1 |
Debian Fixed 5 releases
| Version | Status | Fixed in |
|---|---|---|
| trixie | Fixed | 2:2.2.10-1 |
| sid | Fixed | 2:2.2.10-1 |
| forky | Fixed | 2:2.2.10-1 |
| bullseye | Fixed | 2:2.2.10-1 |
| bookworm | Fixed | 2:2.2.10-1 |
References
- https://security.archlinux.org/ASA-202002-1
- https://nvd.nist.gov/vuln/detail/CVE-2020-7471
- https://github.com/django/django/commit/001b0634cd309e372edb6d7d95d083d02b8e37bd
- https://github.com/django/django/commit/505826b469b16ab36693360da9e11fd13213421b
- https://github.com/django/django/commit/c67a368c16e4680b324b4f385398d638db4d8147
- https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136
- https://www.openwall.com/lists/oss-security/2020/02/03/1
- https://www.djangoproject.com/weblog/2020/feb/03/security-releases
- https://www.debian.org/security/2020/dsa-4629
- https://usn.ubuntu.com/4264-1
- https://security.netapp.com/advisory/ntap-20200221-0006
- https://security.gentoo.org/glsa/202004-17
- https://seclists.org/bugtraq/2020/Feb/30
- https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ
- https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI
- https://github.com/pypa/advisory-database/tree/main/vulns/django/PYSEC-2020-35.yaml
- https://github.com/django/django
- https://github.com/advisories/GHSA-hmr4-m2h5-33qx
- https://docs.djangoproject.com/en/3.0/releases/security
- http://www.openwall.com/lists/oss-security/2020/02/03/1
- https://docs.djangoproject.com/en/3.0/releases/security/
- https://www.djangoproject.com/weblog/2020/feb/03/security-releases/
- https://usn.ubuntu.com/4264-1/
- https://security.netapp.com/advisory/ntap-20200221-0006/
- https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/
Community-verified mitigations for this CVE will appear above when contributors publish them.
Verify integrity in audit chain (admin only). AS-IS.