gsd-2019-7164
Vulnerability from gsd
Modified
2023-12-13 01:23
Details
SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.
Aliases
Aliases
CVE-2019-7164


To clipboard 

{
   GSD: {
      alias: "CVE-2019-7164",
      description: "SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.",
      id: "GSD-2019-7164",
      references: [
         "https://www.suse.com/security/cve/CVE-2019-7164.html",
         "https://access.redhat.com/errata/RHSA-2019:0984",
         "https://access.redhat.com/errata/RHSA-2019:0981",
         "https://advisories.mageia.org/CVE-2019-7164.html",
         "https://linux.oracle.com/cve/CVE-2019-7164.html",
      ],
   },
   gsd: {
      metadata: {
         exploitCode: "unknown",
         remediation: "unknown",
         reportConfidence: "confirmed",
         type: "vulnerability",
      },
      osvSchema: {
         aliases: [
            "CVE-2019-7164",
         ],
         details: "SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.",
         id: "GSD-2019-7164",
         modified: "2023-12-13T01:23:46.927659Z",
         schema_version: "1.4.0",
      },
   },
   namespaces: {
      "cve.org": {
         CVE_data_meta: {
            ASSIGNER: "cve@mitre.org",
            ID: "CVE-2019-7164",
            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: "SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.",
               },
            ],
         },
         problemtype: {
            problemtype_data: [
               {
                  description: [
                     {
                        lang: "eng",
                        value: "n/a",
                     },
                  ],
               },
            ],
         },
         references: {
            reference_data: [
               {
                  name: "[debian-lts-announce] 20190318 [SECURITY] [DLA 1718-1] sqlalchemy security update",
                  refsource: "MLIST",
                  url: "https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html",
               },
               {
                  name: "RHSA-2019:0984",
                  refsource: "REDHAT",
                  url: "https://access.redhat.com/errata/RHSA-2019:0984",
               },
               {
                  name: "RHSA-2019:0981",
                  refsource: "REDHAT",
                  url: "https://access.redhat.com/errata/RHSA-2019:0981",
               },
               {
                  name: "openSUSE-SU-2019:2039",
                  refsource: "SUSE",
                  url: "http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html",
               },
               {
                  name: "openSUSE-SU-2019:2064",
                  refsource: "SUSE",
                  url: "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html",
               },
               {
                  name: "openSUSE-SU-2019:2078",
                  refsource: "SUSE",
                  url: "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html",
               },
               {
                  name: "https://www.oracle.com/security-alerts/cpujan2021.html",
                  refsource: "MISC",
                  url: "https://www.oracle.com/security-alerts/cpujan2021.html",
               },
               {
                  name: "https://github.com/sqlalchemy/sqlalchemy/issues/4481",
                  refsource: "MISC",
                  url: "https://github.com/sqlalchemy/sqlalchemy/issues/4481",
               },
               {
                  name: "[debian-lts-announce] 20211106 [SECURITY] [DLA 2811-1] sqlalchemy security update",
                  refsource: "MLIST",
                  url: "https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html",
               },
            ],
         },
      },
      "gitlab.com": {
         advisories: [
            {
               affected_range: "<=1.2.17||==1.3.0",
               affected_versions: "All versions up to 1.2.17, version 1.3.0",
               cvss_v2: "AV:N/AC:L/Au:N/C:P/I:P/A:P",
               cvss_v3: "CVSS:3.0/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: "2019-05-07",
               description: "SQLAlchemy allows SQL Injection via the `order_by` parameter.",
               fixed_versions: [
                  "1.2.18",
                  "1.3.1",
               ],
               identifier: "CVE-2019-7164",
               identifiers: [
                  "CVE-2019-7164",
               ],
               not_impacted: "All versions after 1.2.17 before 1.3.0, all versions after 1.3.0",
               package_slug: "pypi/sqlalchemy",
               pubdate: "2019-02-19",
               solution: "Upgrade to versions 1.2.18, 1.3.1 or above.",
               title: "SQL Injection via order_by",
               urls: [
                  "https://nvd.nist.gov/vuln/detail/CVE-2019-7164",
                  "https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-7164",
                  "https://cwe.mitre.org/data/definitions/89.html",
                  "https://github.com/sqlalchemy/sqlalchemy/commit/30307c4616ad67c01ddae2e1e8e34fabf6028414",
                  "https://github.com/sqlalchemy/sqlalchemy/issues/4481",
               ],
               uuid: "0de37752-a5ef-4310-bddc-516aa95e4dc6",
            },
         ],
      },
      "nvd.nist.gov": {
         configurations: {
            CVE_data_version: "4.0",
            nodes: [
               {
                  children: [],
                  cpe_match: [
                     {
                        cpe23Uri: "cpe:2.3:a:sqlalchemy:sqlalchemy:1.3.0:beta1:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:a:sqlalchemy:sqlalchemy:*:*:*:*:*:*:*:*",
                        cpe_name: [],
                        versionEndIncluding: "1.2.17",
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:a:sqlalchemy:sqlalchemy:1.3.0:beta2:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                  ],
                  operator: "OR",
               },
               {
                  children: [],
                  cpe_match: [
                     {
                        cpe23Uri: "cpe:2.3:o:debian:debian_linux:8.0:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:o:debian:debian_linux:9.0:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                  ],
                  operator: "OR",
               },
               {
                  children: [],
                  cpe_match: [
                     {
                        cpe23Uri: "cpe:2.3:a:opensuse:backports_sle:15.0:-:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:o:opensuse:leap:15.0:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:o:opensuse:leap:15.1:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                  ],
                  operator: "OR",
               },
               {
                  children: [],
                  cpe_match: [
                     {
                        cpe23Uri: "cpe:2.3:o:redhat:enterprise_linux:8.0:*:*:*:-:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:o:redhat:enterprise_linux_eus:8.1:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:o:redhat:enterprise_linux_eus:8.2:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:o:redhat:enterprise_linux_eus:8.4:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:o:redhat:enterprise_linux_server_aus:8.2:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:o:redhat:enterprise_linux_server_aus:8.4:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:o:redhat:enterprise_linux_server_tus:8.2:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:o:redhat:enterprise_linux_server_tus:8.4:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                  ],
                  operator: "OR",
               },
               {
                  children: [],
                  cpe_match: [
                     {
                        cpe23Uri: "cpe:2.3:a:oracle:communications_operations_monitor:4.2:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                     {
                        cpe23Uri: "cpe:2.3:a:oracle:communications_operations_monitor:4.3:*:*:*:*:*:*:*",
                        cpe_name: [],
                        vulnerable: true,
                     },
                  ],
                  operator: "OR",
               },
            ],
         },
         cve: {
            CVE_data_meta: {
               ASSIGNER: "cve@mitre.org",
               ID: "CVE-2019-7164",
            },
            data_format: "MITRE",
            data_type: "CVE",
            data_version: "4.0",
            description: {
               description_data: [
                  {
                     lang: "en",
                     value: "SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.",
                  },
               ],
            },
            problemtype: {
               problemtype_data: [
                  {
                     description: [
                        {
                           lang: "en",
                           value: "CWE-89",
                        },
                     ],
                  },
               ],
            },
            references: {
               reference_data: [
                  {
                     name: "https://github.com/sqlalchemy/sqlalchemy/issues/4481",
                     refsource: "MISC",
                     tags: [
                        "Exploit",
                        "Third Party Advisory",
                     ],
                     url: "https://github.com/sqlalchemy/sqlalchemy/issues/4481",
                  },
                  {
                     name: "[debian-lts-announce] 20190318 [SECURITY] [DLA 1718-1] sqlalchemy security update",
                     refsource: "MLIST",
                     tags: [
                        "Mailing List",
                        "Third Party Advisory",
                     ],
                     url: "https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html",
                  },
                  {
                     name: "RHSA-2019:0984",
                     refsource: "REDHAT",
                     tags: [
                        "Third Party Advisory",
                     ],
                     url: "https://access.redhat.com/errata/RHSA-2019:0984",
                  },
                  {
                     name: "RHSA-2019:0981",
                     refsource: "REDHAT",
                     tags: [
                        "Third Party Advisory",
                     ],
                     url: "https://access.redhat.com/errata/RHSA-2019:0981",
                  },
                  {
                     name: "openSUSE-SU-2019:2039",
                     refsource: "SUSE",
                     tags: [
                        "Mailing List",
                        "Third Party Advisory",
                     ],
                     url: "http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html",
                  },
                  {
                     name: "openSUSE-SU-2019:2064",
                     refsource: "SUSE",
                     tags: [
                        "Mailing List",
                        "Third Party Advisory",
                     ],
                     url: "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html",
                  },
                  {
                     name: "openSUSE-SU-2019:2078",
                     refsource: "SUSE",
                     tags: [
                        "Mailing List",
                        "Third Party Advisory",
                     ],
                     url: "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html",
                  },
                  {
                     name: "https://www.oracle.com/security-alerts/cpujan2021.html",
                     refsource: "MISC",
                     tags: [
                        "Patch",
                        "Third Party Advisory",
                     ],
                     url: "https://www.oracle.com/security-alerts/cpujan2021.html",
                  },
                  {
                     name: "[debian-lts-announce] 20211106 [SECURITY] [DLA 2811-1] sqlalchemy security update",
                     refsource: "MLIST",
                     tags: [
                        "Mailing List",
                        "Third Party Advisory",
                     ],
                     url: "https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html",
                  },
               ],
            },
         },
         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: "2021-12-03T20:09Z",
         publishedDate: "2019-02-20T00:29Z",
      },
   },
}


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.