CVE-2020-7471 SQL injection in Django
CriticalCVSS 9.8
EPSS 65.6%
- Published
- Updated
- Exploit status
- No public exploit known
- Technology
- UbuntuDebian
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.
Upgrade path
23 packages: 23 fixed.
| Package | Affected | Fixed in | Status |
|---|---|---|---|
| alpine/py-django(Alpine v3.10) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py-django(Alpine v3.8) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py-django(Alpine v3.9) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.11) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.12) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.13) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.14) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.15) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.16) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.17) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.18) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.19) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.20) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.21) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.22) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.23) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| alpine/py3-django(Alpine v3.24) | < 1.11.28-r0 | 1.11.28-r0 | Fixed |
| debian/python-django(Debian 12) | < 2:2.2.10-1 | 2:2.2.10-1 | Fixed |
| debian/python-django(Debian 13) | < 2:2.2.10-1 | 2:2.2.10-1 | Fixed |
| debian/python-django(Debian 14) | < 2:2.2.10-1 | 2:2.2.10-1 | Fixed |
| djangoproject django | >= 1.11, < 1.11.28; >= 2.2, < 2.2.10; >= 3.0, < 3.0.3 | 1.11.28, 2.2.10, 3.0.3 | Fixed |
| pypi django(PyPI) | < 1.11.28; = 1.0.1; = 1.0.2; = 1.0.3 +217 more | 1.11.28, 2.2.10, 3.0.3 | Fixed |
| ubuntu/python-django(Ubuntu 18.04) | < 1:1.11.11-1ubuntu1.7; = 1:1.11.4-1ubuntu1; = 1:1.11.6-1ubuntu1; = 1:1.11.9-1ubuntu1 +7 more | 1:1.11.11-1ubuntu1.7 | Fixed |
Affected products
| Product | Affected versions | Fixed in |
|---|---|---|
| pypi django(PyPI) | < 1.11.28 | 1.11.28 |
| pypi django(PyPI) | = 1.0.1 | No fix listed |
| pypi django(PyPI) | = 1.0.2 | No fix listed |
| pypi django(PyPI) | = 1.0.3 | No fix listed |
| pypi django(PyPI) | = 1.0.4 | No fix listed |
| pypi django(PyPI) | = 1.1 | No fix listed |
| pypi django(PyPI) | = 1.1.1 | No fix listed |
| pypi django(PyPI) | = 1.1.2 | No fix listed |
| pypi django(PyPI) | = 1.1.3 | No fix listed |
| pypi django(PyPI) | = 1.1.4 | No fix listed |
| pypi django(PyPI) | = 1.10 | No fix listed |
| pypi django(PyPI) | = 1.10.1 | No fix listed |
| pypi django(PyPI) | = 1.10.2 | No fix listed |
| pypi django(PyPI) | = 1.10.3 | No fix listed |
| pypi django(PyPI) | = 1.10.4 | No fix listed |
| pypi django(PyPI) | = 1.10.5 | No fix listed |
| pypi django(PyPI) | = 1.10.6 | No fix listed |
| pypi django(PyPI) | = 1.10.7 | No fix listed |
| pypi django(PyPI) | = 1.10.8 | No fix listed |
| pypi django(PyPI) | = 1.10a1 | No fix listed |
| pypi django(PyPI) | = 1.10b1 | No fix listed |
| pypi django(PyPI) | = 1.10rc1 | No fix listed |
| pypi django(PyPI) | = 1.11 | No fix listed |
| pypi django(PyPI) | = 1.11.1 | No fix listed |
| pypi django(PyPI) | = 1.11.10 | No fix listed |
Show 175 more
| Product | Affected versions | Fixed in |
|---|---|---|
| pypi django(PyPI) | = 1.11.11 | No fix listed |
| pypi django(PyPI) | = 1.11.12 | No fix listed |
| pypi django(PyPI) | = 1.11.13 | No fix listed |
| pypi django(PyPI) | = 1.11.14 | No fix listed |
| pypi django(PyPI) | = 1.11.15 | No fix listed |
| pypi django(PyPI) | = 1.11.16 | No fix listed |
| pypi django(PyPI) | = 1.11.17 | No fix listed |
| pypi django(PyPI) | = 1.11.18 | No fix listed |
| pypi django(PyPI) | = 1.11.2 | No fix listed |
| pypi django(PyPI) | = 1.11.20 | No fix listed |
| pypi django(PyPI) | = 1.11.21 | No fix listed |
| pypi django(PyPI) | = 1.11.22 | No fix listed |
| pypi django(PyPI) | = 1.11.23 | No fix listed |
| pypi django(PyPI) | = 1.11.24 | No fix listed |
| pypi django(PyPI) | = 1.11.25 | No fix listed |
| pypi django(PyPI) | = 1.11.26 | No fix listed |
| pypi django(PyPI) | = 1.11.27 | No fix listed |
| pypi django(PyPI) | = 1.11.3 | No fix listed |
| pypi django(PyPI) | = 1.11.4 | No fix listed |
| pypi django(PyPI) | = 1.11.5 | No fix listed |
| pypi django(PyPI) | = 1.11.6 | No fix listed |
| pypi django(PyPI) | = 1.11.7 | No fix listed |
| pypi django(PyPI) | = 1.11.8 | No fix listed |
| pypi django(PyPI) | = 1.11.9 | No fix listed |
| pypi django(PyPI) | = 1.11a1 | No fix listed |
| pypi django(PyPI) | = 1.11b1 | No fix listed |
| pypi django(PyPI) | = 1.11rc1 | No fix listed |
| pypi django(PyPI) | = 1.2 | No fix listed |
| pypi django(PyPI) | = 1.2.1 | No fix listed |
| pypi django(PyPI) | = 1.2.2 | No fix listed |
| pypi django(PyPI) | = 1.2.3 | No fix listed |
| pypi django(PyPI) | = 1.2.4 | No fix listed |
| pypi django(PyPI) | = 1.2.5 | No fix listed |
| pypi django(PyPI) | = 1.2.6 | No fix listed |
| pypi django(PyPI) | = 1.2.7 | No fix listed |
| pypi django(PyPI) | = 1.3 | No fix listed |
| pypi django(PyPI) | = 1.3.1 | No fix listed |
| pypi django(PyPI) | = 1.3.2 | No fix listed |
| pypi django(PyPI) | = 1.3.3 | No fix listed |
| pypi django(PyPI) | = 1.3.4 | No fix listed |
| pypi django(PyPI) | = 1.3.5 | No fix listed |
| pypi django(PyPI) | = 1.3.6 | No fix listed |
| pypi django(PyPI) | = 1.3.7 | No fix listed |
| pypi django(PyPI) | = 1.4 | No fix listed |
| pypi django(PyPI) | = 1.4.1 | No fix listed |
| pypi django(PyPI) | = 1.4.10 | No fix listed |
| pypi django(PyPI) | = 1.4.11 | No fix listed |
| pypi django(PyPI) | = 1.4.12 | No fix listed |
| pypi django(PyPI) | = 1.4.13 | No fix listed |
| pypi django(PyPI) | = 1.4.14 | No fix listed |
| pypi django(PyPI) | = 1.4.15 | No fix listed |
| pypi django(PyPI) | = 1.4.16 | No fix listed |
| pypi django(PyPI) | = 1.4.17 | No fix listed |
| pypi django(PyPI) | = 1.4.18 | No fix listed |
| pypi django(PyPI) | = 1.4.19 | No fix listed |
| pypi django(PyPI) | = 1.4.2 | No fix listed |
| pypi django(PyPI) | = 1.4.20 | No fix listed |
| pypi django(PyPI) | = 1.4.21 | No fix listed |
| pypi django(PyPI) | = 1.4.22 | No fix listed |
| pypi django(PyPI) | = 1.4.3 | No fix listed |
| pypi django(PyPI) | = 1.4.4 | No fix listed |
| pypi django(PyPI) | = 1.4.5 | No fix listed |
| pypi django(PyPI) | = 1.4.6 | No fix listed |
| pypi django(PyPI) | = 1.4.7 | No fix listed |
| pypi django(PyPI) | = 1.4.8 | No fix listed |
| pypi django(PyPI) | = 1.4.9 | No fix listed |
| pypi django(PyPI) | = 1.5 | No fix listed |
| pypi django(PyPI) | = 1.5.1 | No fix listed |
| pypi django(PyPI) | = 1.5.10 | No fix listed |
| pypi django(PyPI) | = 1.5.11 | No fix listed |
| pypi django(PyPI) | = 1.5.12 | No fix listed |
| pypi django(PyPI) | = 1.5.2 | No fix listed |
| pypi django(PyPI) | = 1.5.3 | No fix listed |
| pypi django(PyPI) | = 1.5.4 | No fix listed |
| pypi django(PyPI) | = 1.5.5 | No fix listed |
| pypi django(PyPI) | = 1.5.6 | No fix listed |
| pypi django(PyPI) | = 1.5.7 | No fix listed |
| pypi django(PyPI) | = 1.5.8 | No fix listed |
| pypi django(PyPI) | = 1.5.9 | No fix listed |
| pypi django(PyPI) | = 1.6 | No fix listed |
| pypi django(PyPI) | = 1.6.1 | No fix listed |
| pypi django(PyPI) | = 1.6.10 | No fix listed |
| pypi django(PyPI) | = 1.6.11 | No fix listed |
| pypi django(PyPI) | = 1.6.2 | No fix listed |
| pypi django(PyPI) | = 1.6.3 | No fix listed |
| pypi django(PyPI) | = 1.6.4 | No fix listed |
| pypi django(PyPI) | = 1.6.5 | No fix listed |
| pypi django(PyPI) | = 1.6.6 | No fix listed |
| pypi django(PyPI) | = 1.6.7 | No fix listed |
| pypi django(PyPI) | = 1.6.8 | No fix listed |
| pypi django(PyPI) | = 1.6.9 | No fix listed |
| pypi django(PyPI) | = 1.7 | No fix listed |
| pypi django(PyPI) | = 1.7.1 | No fix listed |
| pypi django(PyPI) | = 1.7.10 | No fix listed |
| pypi django(PyPI) | = 1.7.11 | No fix listed |
| pypi django(PyPI) | = 1.7.2 | No fix listed |
| pypi django(PyPI) | = 1.7.3 | No fix listed |
| pypi django(PyPI) | = 1.7.4 | No fix listed |
| pypi django(PyPI) | = 1.7.5 | No fix listed |
| pypi django(PyPI) | = 1.7.6 | No fix listed |
| pypi django(PyPI) | = 1.7.7 | No fix listed |
| pypi django(PyPI) | = 1.7.8 | No fix listed |
| pypi django(PyPI) | = 1.7.9 | No fix listed |
| pypi django(PyPI) | = 1.8 | No fix listed |
| pypi django(PyPI) | = 1.8.1 | No fix listed |
| pypi django(PyPI) | = 1.8.10 | No fix listed |
| pypi django(PyPI) | = 1.8.11 | No fix listed |
| pypi django(PyPI) | = 1.8.12 | No fix listed |
| pypi django(PyPI) | = 1.8.13 | No fix listed |
| pypi django(PyPI) | = 1.8.14 | No fix listed |
| pypi django(PyPI) | = 1.8.15 | No fix listed |
| pypi django(PyPI) | = 1.8.16 | No fix listed |
| pypi django(PyPI) | = 1.8.17 | No fix listed |
| pypi django(PyPI) | = 1.8.18 | No fix listed |
| pypi django(PyPI) | = 1.8.19 | No fix listed |
| pypi django(PyPI) | = 1.8.2 | No fix listed |
| pypi django(PyPI) | = 1.8.3 | No fix listed |
| pypi django(PyPI) | = 1.8.4 | No fix listed |
| pypi django(PyPI) | = 1.8.5 | No fix listed |
| pypi django(PyPI) | = 1.8.6 | No fix listed |
| pypi django(PyPI) | = 1.8.7 | No fix listed |
| pypi django(PyPI) | = 1.8.8 | No fix listed |
| pypi django(PyPI) | = 1.8.9 | No fix listed |
| pypi django(PyPI) | = 1.8a1 | No fix listed |
| pypi django(PyPI) | = 1.8b1 | No fix listed |
| pypi django(PyPI) | = 1.8b2 | No fix listed |
| pypi django(PyPI) | = 1.8c1 | No fix listed |
| pypi django(PyPI) | = 1.9 | No fix listed |
| pypi django(PyPI) | = 1.9.1 | No fix listed |
| pypi django(PyPI) | = 1.9.10 | No fix listed |
| pypi django(PyPI) | = 1.9.11 | No fix listed |
| pypi django(PyPI) | = 1.9.12 | No fix listed |
| pypi django(PyPI) | = 1.9.13 | No fix listed |
| pypi django(PyPI) | = 1.9.2 | No fix listed |
| pypi django(PyPI) | = 1.9.3 | No fix listed |
| pypi django(PyPI) | = 1.9.4 | No fix listed |
| pypi django(PyPI) | = 1.9.5 | No fix listed |
| pypi django(PyPI) | = 1.9.6 | No fix listed |
| pypi django(PyPI) | = 1.9.7 | No fix listed |
| pypi django(PyPI) | = 1.9.8 | No fix listed |
| pypi django(PyPI) | = 1.9.9 | No fix listed |
| pypi django(PyPI) | = 1.9a1 | No fix listed |
| pypi django(PyPI) | = 1.9b1 | No fix listed |
| pypi django(PyPI) | = 1.9rc1 | No fix listed |
| pypi django(PyPI) | = 1.9rc2 | No fix listed |
| pypi django(PyPI) | >= 2.0, < 2.2.10 | 2.2.10 |
| pypi django(PyPI) | = 2.0 | No fix listed |
| pypi django(PyPI) | = 2.0.1 | No fix listed |
| pypi django(PyPI) | = 2.0.10 | No fix listed |
| pypi django(PyPI) | = 2.0.12 | No fix listed |
| pypi django(PyPI) | = 2.0.13 | No fix listed |
| pypi django(PyPI) | = 2.0.2 | No fix listed |
| pypi django(PyPI) | = 2.0.3 | No fix listed |
| pypi django(PyPI) | = 2.0.4 | No fix listed |
| pypi django(PyPI) | = 2.0.5 | No fix listed |
| pypi django(PyPI) | = 2.0.6 | No fix listed |
| pypi django(PyPI) | = 2.0.7 | No fix listed |
| pypi django(PyPI) | = 2.0.8 | No fix listed |
| pypi django(PyPI) | = 2.0.9 | No fix listed |
| pypi django(PyPI) | = 2.1 | No fix listed |
| pypi django(PyPI) | = 2.1.1 | No fix listed |
| pypi django(PyPI) | = 2.1.10 | No fix listed |
| pypi django(PyPI) | = 2.1.11 | No fix listed |
| pypi django(PyPI) | = 2.1.12 | No fix listed |
| pypi django(PyPI) | = 2.1.13 | No fix listed |
| pypi django(PyPI) | = 2.1.14 | No fix listed |
| pypi django(PyPI) | = 2.1.15 | No fix listed |
| pypi django(PyPI) | = 2.1.2 | No fix listed |
| pypi django(PyPI) | = 2.1.3 | No fix listed |
| pypi django(PyPI) | = 2.1.4 | No fix listed |
| pypi django(PyPI) | = 2.1.5 | No fix listed |
| pypi django(PyPI) | = 2.1.7 | No fix listed |
| pypi django(PyPI) | = 2.1.8 | No fix listed |
| pypi django(PyPI) | = 2.1.9 | No fix listed |
| pypi django(PyPI) | = 2.1a1 | No fix listed |
References
- nvd.nist.gov third-party-advisory vendor-advisory
- github.com patch
- github.com patch
- github.com patch
- github.com patch third-party-advisory
- www.openwall.com issue-tracking mailing-list third-party-advisory
- www.djangoproject.com technical-description vendor-advisory
- DSA-4629 vendor-advisory
- USN-4264-1 vendor-advisory
- security.netapp.com vendor-advisory
- GLSA-202004-17 vendor-advisory
- 20200219 [SECURITY] [DSA 4629-1] python-django security update mailing-list
- lists.fedoraproject.org
- groups.google.com
- github.com
- github.com product
- github.com vendor-advisory
- docs.djangoproject.com vendor-advisory
- [oss-security] 20200203 Django 3.0.3, 2.2.10 and 1.11.28: CVE-2020-7471: Potential SQL injection via ``StringAgg(delimiter)`` mailing-list third-party-advisory
- Debian Security Tracker CVE-2020-7471 vendor-advisory
- FEDORA-2020-c2639662af vendor-advisory
- security.alpinelinux.org vendor-advisory
- bugs.debian.org issue-tracking
- ubuntu.com issue-tracking
- ubuntu.com vendor-advisory
- www.cve.org issue-tracking