{"containers":{"cna":{"affected":[{"product":"n/a","vendor":"n/a","versions":[{"status":"affected","version":"n/a"}]}],"descriptions":[{"lang":"en","value":"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."}],"problemTypes":[{"descriptions":[{"description":"n/a","lang":"en","type":"text"}]}],"providerMetadata":{"dateUpdated":"2020-06-19T02:06:18.000Z","orgId":"8254265b-2729-46b6-b9e3-3dfca2d5bfca","shortName":"mitre"},"references":[{"tags":["x_refsource_CONFIRM"],"url":"https://groups.google.com/forum/#%21topic/django-announce/X45S86X5bZI"},{"tags":["x_refsource_CONFIRM"],"url":"https://docs.djangoproject.com/en/3.0/releases/security/"},{"tags":["x_refsource_CONFIRM"],"url":"https://www.openwall.com/lists/oss-security/2020/02/03/1"},{"tags":["x_refsource_CONFIRM"],"url":"https://www.djangoproject.com/weblog/2020/feb/03/security-releases/"},{"name":"[oss-security] 20200203 Django 3.0.3, 2.2.10 and 1.11.28: CVE-2020-7471: Potential SQL injection via ``StringAgg(delimiter)``","tags":["mailing-list","x_refsource_MLIST"],"url":"http://www.openwall.com/lists/oss-security/2020/02/03/1"},{"tags":["x_refsource_CONFIRM"],"url":"https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136"},{"name":"USN-4264-1","tags":["vendor-advisory","x_refsource_UBUNTU"],"url":"https://usn.ubuntu.com/4264-1/"},{"name":"20200219 [SECURITY] [DSA 4629-1] python-django security update","tags":["mailing-list","x_refsource_BUGTRAQ"],"url":"https://seclists.org/bugtraq/2020/Feb/30"},{"name":"DSA-4629","tags":["vendor-advisory","x_refsource_DEBIAN"],"url":"https://www.debian.org/security/2020/dsa-4629"},{"tags":["x_refsource_CONFIRM"],"url":"https://security.netapp.com/advisory/ntap-20200221-0006/"},{"name":"GLSA-202004-17","tags":["vendor-advisory","x_refsource_GENTOO"],"url":"https://security.gentoo.org/glsa/202004-17"},{"name":"FEDORA-2020-c2639662af","tags":["vendor-advisory","x_refsource_FEDORA"],"url":"https://lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/"}],"x_legacyV4Record":{"CVE_data_meta":{"ASSIGNER":"cve@mitre.org","ID":"CVE-2020-7471","STATE":"PUBLIC"},"affects":{"vendor":{"vendor_data":[{"product":{"product_data":[{"product_name":"n/a","version":{"version_data":[{"version_value":"n/a"}]}}]},"vendor_name":"n/a"}]}},"data_format":"MITRE","data_type":"CVE","data_version":"4.0","description":{"description_data":[{"lang":"eng","value":"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."}]},"problemtype":{"problemtype_data":[{"description":[{"lang":"eng","value":"n/a"}]}]},"references":{"reference_data":[{"name":"https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI","refsource":"CONFIRM","url":"https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI"},{"name":"https://docs.djangoproject.com/en/3.0/releases/security/","refsource":"CONFIRM","url":"https://docs.djangoproject.com/en/3.0/releases/security/"},{"name":"https://www.openwall.com/lists/oss-security/2020/02/03/1","refsource":"CONFIRM","url":"https://www.openwall.com/lists/oss-security/2020/02/03/1"},{"name":"https://www.djangoproject.com/weblog/2020/feb/03/security-releases/","refsource":"CONFIRM","url":"https://www.djangoproject.com/weblog/2020/feb/03/security-releases/"},{"name":"[oss-security] 20200203 Django 3.0.3, 2.2.10 and 1.11.28: CVE-2020-7471: Potential SQL injection via ``StringAgg(delimiter)``","refsource":"MLIST","url":"http://www.openwall.com/lists/oss-security/2020/02/03/1"},{"name":"https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136","refsource":"CONFIRM","url":"https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136"},{"name":"USN-4264-1","refsource":"UBUNTU","url":"https://usn.ubuntu.com/4264-1/"},{"name":"20200219 [SECURITY] [DSA 4629-1] python-django security update","refsource":"BUGTRAQ","url":"https://seclists.org/bugtraq/2020/Feb/30"},{"name":"DSA-4629","refsource":"DEBIAN","url":"https://www.debian.org/security/2020/dsa-4629"},{"name":"https://security.netapp.com/advisory/ntap-20200221-0006/","refsource":"CONFIRM","url":"https://security.netapp.com/advisory/ntap-20200221-0006/"},{"name":"GLSA-202004-17","refsource":"GENTOO","url":"https://security.gentoo.org/glsa/202004-17"},{"name":"FEDORA-2020-c2639662af","refsource":"FEDORA","url":"https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/"}]}}},"adp":[{"providerMetadata":{"orgId":"af854a3a-2127-422b-91ae-364da2661108","shortName":"CVE","dateUpdated":"2024-08-04T09:33:19.635Z"},"title":"CVE Program Container","references":[{"tags":["x_refsource_CONFIRM","x_transferred"],"url":"https://groups.google.com/forum/#%21topic/django-announce/X45S86X5bZI"},{"tags":["x_refsource_CONFIRM","x_transferred"],"url":"https://docs.djangoproject.com/en/3.0/releases/security/"},{"tags":["x_refsource_CONFIRM","x_transferred"],"url":"https://www.openwall.com/lists/oss-security/2020/02/03/1"},{"tags":["x_refsource_CONFIRM","x_transferred"],"url":"https://www.djangoproject.com/weblog/2020/feb/03/security-releases/"},{"name":"[oss-security] 20200203 Django 3.0.3, 2.2.10 and 1.11.28: CVE-2020-7471: Potential SQL injection via ``StringAgg(delimiter)``","tags":["mailing-list","x_refsource_MLIST","x_transferred"],"url":"http://www.openwall.com/lists/oss-security/2020/02/03/1"},{"tags":["x_refsource_CONFIRM","x_transferred"],"url":"https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136"},{"name":"USN-4264-1","tags":["vendor-advisory","x_refsource_UBUNTU","x_transferred"],"url":"https://usn.ubuntu.com/4264-1/"},{"name":"20200219 [SECURITY] [DSA 4629-1] python-django security update","tags":["mailing-list","x_refsource_BUGTRAQ","x_transferred"],"url":"https://seclists.org/bugtraq/2020/Feb/30"},{"name":"DSA-4629","tags":["vendor-advisory","x_refsource_DEBIAN","x_transferred"],"url":"https://www.debian.org/security/2020/dsa-4629"},{"tags":["x_refsource_CONFIRM","x_transferred"],"url":"https://security.netapp.com/advisory/ntap-20200221-0006/"},{"name":"GLSA-202004-17","tags":["vendor-advisory","x_refsource_GENTOO","x_transferred"],"url":"https://security.gentoo.org/glsa/202004-17"},{"name":"FEDORA-2020-c2639662af","tags":["vendor-advisory","x_refsource_FEDORA","x_transferred"],"url":"https://lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/"}]}]},"cveMetadata":{"assignerOrgId":"8254265b-2729-46b6-b9e3-3dfca2d5bfca","assignerShortName":"mitre","cveId":"CVE-2020-7471","datePublished":"2020-02-03T11:59:20.000Z","dateReserved":"2020-01-21T00:00:00.000Z","dateUpdated":"2024-08-04T09:33:19.635Z","state":"PUBLISHED"},"dataType":"CVE_RECORD","dataVersion":"5.1"}