CVE-2020-7471: SQL Injection
First published: Mon Feb 03 2020(Updated: )
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.
Credit: cve@mitre.org cve@mitre.org
| Affected Software | Affected Version | How to fix |
|---|---|---|
| pip/django | >=3.0.0<3.0.3 | 3.0.3 |
| pip/django | >=2.0.0<2.2.10 | 2.2.10 |
| pip/django | <1.11.28 | 1.11.28 |
| debian/python-django | <=1:1.11.27-1~deb10u1<=2:2.2.9-2 | 2:2.2.10-1 1:1.11.28-1~deb10u1 1:1.10.7-2+deb9u8 |
| Djangoproject Django | >=1.11<1.11.28 | |
| Djangoproject Django | >=2.2<2.2.10 | |
| Djangoproject Django | >=3.0<3.0.3 | |
| ubuntu/python-django | <1:1.11.11-1ubuntu1.7 | 1:1.11.11-1ubuntu1.7 |
| ubuntu/python-django | <1:1.11.22-1ubuntu1.2 | 1:1.11.22-1ubuntu1.2 |
| ubuntu/python-django | <2.2.10 | 2.2.10 |
| debian/python-django | 1:1.11.29-1~deb10u1 1:1.11.29-1+deb10u10 2:2.2.28-1~deb11u2 3:3.2.19-1+deb12u1 3:4.2.10-1 |
Never miss a vulnerability like this again
Sign up to SecAlerts for real-time vulnerability data matched to your software, aggregated from hundreds of sources.
Reference Links
- https://security-tracker.debian.org/tracker/CVE-2020-7471
- https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2020-7471
- https://www.djangoproject.com/weblog/2020/feb/03/security-releases/
- https://salsa.debian.org/python-team/modules/python-django/commit/5eca46bbe33eb6f08e9798166e217fbe4534e97a
- https://bugs.debian.org/950581
- https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=950581
- https://nvd.nist.gov/vuln/detail/CVE-2020-7471
- https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136
- https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI
- https://www.openwall.com/lists/oss-security/2020/02/03/1
- http://www.openwall.com/lists/oss-security/2020/02/03/1
- https://usn.ubuntu.com/4264-1/
- https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/
- https://seclists.org/bugtraq/2020/Feb/30
- https://security.gentoo.org/glsa/202004-17
- https://security.netapp.com/advisory/ntap-20200221-0006/
- https://www.debian.org/security/2020/dsa-4629
- https://github.com/django/django/commit/001b0634cd309e372edb6d7d95d083d02b8e37bd
- https://github.com/django/django/commit/505826b469b16ab36693360da9e11fd13213421b
- https://github.com/django/django/commit/c67a368c16e4680b324b4f385398d638db4d8147
- https://github.com/advisories/GHSA-hmr4-m2h5-33qx (Advisory)
- https://docs.djangoproject.com/en/3.0/releases/security/
- https://groups.google.com/forum/#%21topic/django-announce/X45S86X5bZI
- https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/UZMN2NKAGTFE3YKMNM2JVJG7R2W7LLHY/
- https://launchpad.net/bugs/cve/CVE-2020-7471
- https://lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/
- https://ubuntu.com/security/notices/USN-4264-1
- https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136 (master)
- https://github.com/django/django/commit/505826b469b16ab36693360da9e11fd13213421b (3.0)
- https://github.com/django/django/commit/c67a368c16e4680b324b4f385398d638db4d8147 (2.2)
- https://github.com/django/django/commit/001b0634cd309e372edb6d7d95d083d02b8e37bd (1.1)
- https://ubuntu.com/security/CVE-2020-7471
Frequently Asked Questions
What is the severity of CVE-2020-7471?
The severity of CVE-2020-7471 is critical with a CVSS score of 9.8.
How does CVE-2020-7471 affect Django versions?
CVE-2020-7471 affects Django versions 1.11 before 1.11.28, 2.2 before 2.2.10, and 3.0 before 3.0.3.
What is the vulnerability in CVE-2020-7471?
The vulnerability in CVE-2020-7471 is SQL Injection if untrusted data is used as a StringAgg delimiter.
How can I fix CVE-2020-7471?
To fix CVE-2020-7471, update Django to version 3.0.3, 2.2.10, or 1.11.28 depending on the version you are using.
Where can I find more information about CVE-2020-7471?
You can find more information about CVE-2020-7471 in the following references: [NVD](https://nvd.nist.gov/vuln/detail/CVE-2020-7471), [GitHub](https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136), [Google Groups](https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI).
- agent/author
- agent/description
- agent/event
- agent/first-publish-date
- agent/last-modified-date
- agent/references
- agent/remedy
- agent/severity
- agent/softwarecombine
- agent/tags
- agent/type
- agent/weakness
- collector/debian-bugs
- alias/CVE-2020-7471
- collector/github-advisory
- alias/GHSA-hmr4-m2h5-33qx
- collector/github-advisory-latest
- collector/launchpad-cve
- source/Launchpad
- collector/nvd-cve
- source/NVD
- agent/software-canonical-lookup
- collector/nvd-index
- collector/security-tracker-debian
- source/Debian
- collector/usn-cve
- source/Ubuntu
- package-manager/debian
- package-manager/pip
- vendor/djangoproject
- canonical/djangoproject django
- version/djangoproject django/1.11
- version/djangoproject django/2.2
- version/djangoproject django/3.0
- package-manager/ubuntu