Skip to content

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.

PackageAffectedFixed inStatus
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

ProductAffected versionsFixed 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
ProductAffected versionsFixed 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