gsd-2020-7471
Vulnerability from gsd
Modified
2023-12-13 01:21
Details
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.
Aliases
Aliases
CVE-2020-7471


To clipboard 

{
   GSD: {
      alias: "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.",
      id: "GSD-2020-7471",
      references: [
         "https://www.suse.com/security/cve/CVE-2020-7471.html",
         "https://www.debian.org/security/2020/dsa-4629",
         "https://ubuntu.com/security/CVE-2020-7471",
         "https://security.archlinux.org/CVE-2020-7471",
      ],
   },
   gsd: {
      metadata: {
         exploitCode: "unknown",
         remediation: "unknown",
         reportConfidence: "confirmed",
         type: "vulnerability",
      },
      osvSchema: {
         aliases: [
            "CVE-2020-7471",
         ],
         details: "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.",
         id: "GSD-2020-7471",
         modified: "2023-12-13T01:21:51.980171Z",
         schema_version: "1.4.0",
      },
   },
   namespaces: {
      "cve.org": {
         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/",
               },
            ],
         },
      },
      "gitlab.com": {
         advisories: [
            {
               affected_range: ">=1.11,<1.11.28||>=2.2,<2.2.10||>=3.0,<3.0.3",
               affected_versions: "All versions starting from 1.11 before 1.11.28, all versions starting from 2.2 before 2.2.10, all versions starting from 3.0 before 3.0.3",
               cvss_v2: "AV:N/AC:L/Au:N/C:P/I:P/A:P",
               cvss_v3: "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H",
               cwe_ids: [
                  "CWE-1035",
                  "CWE-89",
                  "CWE-937",
               ],
               date: "2020-06-19",
               description: "Django allows SQL Injection if untrusted data is used as a 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.",
               fixed_versions: [
                  "1.11.28",
                  "2.2.10",
                  "3.0.3",
               ],
               identifier: "CVE-2020-7471",
               identifiers: [
                  "CVE-2020-7471",
               ],
               not_impacted: "All versions before 1.11, all versions starting from 1.11.28 before 2.2, all versions starting from 2.2.10 before 3.0, all versions starting from 3.0.3",
               package_slug: "pypi/Django",
               pubdate: "2020-02-03",
               solution: "Upgrade to versions 1.11.28, 2.2.10, 3.0.3 or above.",
               title: "SQL Injection",
               urls: [
                  "https://nvd.nist.gov/vuln/detail/CVE-2020-7471",
                  "https://docs.djangoproject.com/en/3.0/releases/security/",
                  "https://www.djangoproject.com/weblog/2020/feb/03/security-releases/",
               ],
               uuid: "ea400310-29db-4c48-8236-42d462d1de1c",
            },
         ],
      },
      "nvd.nist.gov": {
         configurations: {
            CVE_data_version: "4.0",
            nodes: [
               {
                  children: [],
                  cpe_match: [
                     {
                        cpe23Uri: "cpe:2.3:a:djangoproject:django:*:*:*:*:*:*:*:*",
                        cpe_name: [],
                        versionEndExcluding: "1.11.28",
                        versionStartIncluding: "1.11",
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:a:djangoproject:django:*:*:*:*:*:*:*:*",
                        cpe_name: [],
                        versionEndExcluding: "2.2.10",
                        versionStartIncluding: "2.2",
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:a:djangoproject:django:*:*:*:*:*:*:*:*",
                        cpe_name: [],
                        versionEndExcluding: "3.0.3",
                        versionStartIncluding: "3.0",
                        vulnerable: true,
                     },
                  ],
                  operator: "OR",
               },
            ],
         },
         cve: {
            CVE_data_meta: {
               ASSIGNER: "cve@mitre.org",
               ID: "CVE-2020-7471",
            },
            data_format: "MITRE",
            data_type: "CVE",
            data_version: "4.0",
            description: {
               description_data: [
                  {
                     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.",
                  },
               ],
            },
            problemtype: {
               problemtype_data: [
                  {
                     description: [
                        {
                           lang: "en",
                           value: "CWE-89",
                        },
                     ],
                  },
               ],
            },
            references: {
               reference_data: [
                  {
                     name: "https://www.openwall.com/lists/oss-security/2020/02/03/1",
                     refsource: "CONFIRM",
                     tags: [
                        "Mailing List",
                        "Third Party Advisory",
                     ],
                     url: "https://www.openwall.com/lists/oss-security/2020/02/03/1",
                  },
                  {
                     name: "https://docs.djangoproject.com/en/3.0/releases/security/",
                     refsource: "CONFIRM",
                     tags: [
                        "Vendor Advisory",
                     ],
                     url: "https://docs.djangoproject.com/en/3.0/releases/security/",
                  },
                  {
                     name: "https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI",
                     refsource: "CONFIRM",
                     tags: [
                        "Mailing List",
                        "Third Party Advisory",
                     ],
                     url: "https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI",
                  },
                  {
                     name: "https://www.djangoproject.com/weblog/2020/feb/03/security-releases/",
                     refsource: "CONFIRM",
                     tags: [
                        "Vendor Advisory",
                     ],
                     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",
                     tags: [
                        "Mailing List",
                        "Third Party Advisory",
                     ],
                     url: "http://www.openwall.com/lists/oss-security/2020/02/03/1",
                  },
                  {
                     name: "https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136",
                     refsource: "CONFIRM",
                     tags: [
                        "Patch",
                        "Third Party Advisory",
                     ],
                     url: "https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136",
                  },
                  {
                     name: "USN-4264-1",
                     refsource: "UBUNTU",
                     tags: [],
                     url: "https://usn.ubuntu.com/4264-1/",
                  },
                  {
                     name: "20200219 [SECURITY] [DSA 4629-1] python-django security update",
                     refsource: "BUGTRAQ",
                     tags: [],
                     url: "https://seclists.org/bugtraq/2020/Feb/30",
                  },
                  {
                     name: "DSA-4629",
                     refsource: "DEBIAN",
                     tags: [],
                     url: "https://www.debian.org/security/2020/dsa-4629",
                  },
                  {
                     name: "https://security.netapp.com/advisory/ntap-20200221-0006/",
                     refsource: "CONFIRM",
                     tags: [],
                     url: "https://security.netapp.com/advisory/ntap-20200221-0006/",
                  },
                  {
                     name: "GLSA-202004-17",
                     refsource: "GENTOO",
                     tags: [],
                     url: "https://security.gentoo.org/glsa/202004-17",
                  },
                  {
                     name: "FEDORA-2020-c2639662af",
                     refsource: "FEDORA",
                     tags: [],
                     url: "https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/",
                  },
               ],
            },
         },
         impact: {
            baseMetricV2: {
               acInsufInfo: false,
               cvssV2: {
                  accessComplexity: "LOW",
                  accessVector: "NETWORK",
                  authentication: "NONE",
                  availabilityImpact: "PARTIAL",
                  baseScore: 7.5,
                  confidentialityImpact: "PARTIAL",
                  integrityImpact: "PARTIAL",
                  vectorString: "AV:N/AC:L/Au:N/C:P/I:P/A:P",
                  version: "2.0",
               },
               exploitabilityScore: 10,
               impactScore: 6.4,
               obtainAllPrivilege: false,
               obtainOtherPrivilege: false,
               obtainUserPrivilege: false,
               severity: "HIGH",
               userInteractionRequired: false,
            },
            baseMetricV3: {
               cvssV3: {
                  attackComplexity: "LOW",
                  attackVector: "NETWORK",
                  availabilityImpact: "HIGH",
                  baseScore: 9.8,
                  baseSeverity: "CRITICAL",
                  confidentialityImpact: "HIGH",
                  integrityImpact: "HIGH",
                  privilegesRequired: "NONE",
                  scope: "UNCHANGED",
                  userInteraction: "NONE",
                  vectorString: "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H",
                  version: "3.1",
               },
               exploitabilityScore: 3.9,
               impactScore: 5.9,
            },
         },
         lastModifiedDate: "2020-06-19T03:15Z",
         publishedDate: "2020-02-03T12:15Z",
      },
   },
}


Log in or create an account to share your comment.

Security Advisory comment format.

This schema specifies the format of a comment related to a security advisory.

UUIDv4 of the comment
UUIDv4 of the Vulnerability-Lookup instance
When the comment was created originally
When the comment was last updated
Title of the comment
Description of the comment
The identifier of the vulnerability (CVE ID, GHSA-ID, PYSEC ID, etc.).



Tags
Taxonomy of the tags.




Sightings

Author Source Type Date

Nomenclature

  • Seen: The vulnerability was mentioned, discussed, or seen somewhere by the user.
  • Confirmed: The vulnerability is confirmed from an analyst perspective.
  • Exploited: This vulnerability was exploited and seen by the user reporting the sighting.
  • Patched: This vulnerability was successfully patched by the user reporting the sighting.
  • Not exploited: This vulnerability was not exploited or seen by the user reporting the sighting.
  • Not confirmed: The user expresses doubt about the veracity of the vulnerability.
  • Not patched: This vulnerability was not successfully patched by the user reporting the sighting.