Vulnerability Name:

CVE-2012-0805 (CCN-73756)

Assigned:2012-03-07
Published:2012-03-07
Updated:2018-01-18
Summary:Multiple SQL injection vulnerabilities in SQLAlchemy before 0.7.0b4, as used in Keystone, allow remote attackers to execute arbitrary SQL commands via the (1) limit or (2) offset keyword to the select function, or unspecified vectors to the (3) select.limit or (4) select.offset function.
CVSS v3 Severity:7.3 High (CCN CVSS v3.1 Vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:L/A:L)
Exploitability Metrics:Attack Vector (AV): Network
Attack Complexity (AC): Low
Privileges Required (PR): None
User Interaction (UI): None
Scope:Scope (S): Unchanged
Impact Metrics:Confidentiality (C): Low
Integrity (I): Low
Availibility (A): Low
CVSS v2 Severity:7.5 High (CVSS v2 Vector: AV:N/AC:L/Au:N/C:P/I:P/A:P)
6.5 Medium (Temporal CVSS v2 Vector: AV:N/AC:L/Au:N/C:P/I:P/A:P/E:H/RL:OF/RC:C)
Exploitability Metrics:Access Vector (AV): Network
Access Complexity (AC): Low
Authentication (Au): None
Impact Metrics:Confidentiality (C): Partial
Integrity (I): Partial
Availibility (A): Partial
7.5 High (CCN CVSS v2 Vector: AV:N/AC:L/Au:N/C:P/I:P/A:P)
6.5 Medium (CCN Temporal CVSS v2 Vector: AV:N/AC:L/Au:N/C:P/I:P/A:P/E:H/RL:OF/RC:C)
Exploitability Metrics:Access Vector (AV): Network
Access Complexity (AC): Low
Athentication (Au): None
Impact Metrics:Confidentiality (C): Partial
Integrity (I): Partial
Availibility (A): Partial
4.3 Medium (REDHAT CVSS v2 Vector: AV:N/AC:M/Au:N/C:N/I:P/A:N)
3.7 Low (REDHAT Temporal CVSS v2 Vector: AV:N/AC:M/Au:N/C:N/I:P/A:N/E:H/RL:OF/RC:C)
Exploitability Metrics:Access Vector (AV): Network
Access Complexity (AC): Medium
Authentication (Au): None
Impact Metrics:Confidentiality (C): None
Integrity (I): Partial
Availibility (A): None
Vulnerability Type:CWE-89
Vulnerability Consequences:Data Manipulation
References:Source: MITRE
Type: CNA
CVE-2012-0805

Source: CCN
Type: RHSA-2012-0369
Moderate: python-sqlalchemy security update

Source: REDHAT
Type: UNKNOWN
RHSA-2012:0369

Source: SECUNIA
Type: Vendor Advisory
48327

Source: CCN
Type: SA48328
SQLAlchemy "limit" and "offset" Keywords SQL Injection Vulnerabilities

Source: SECUNIA
Type: Vendor Advisory
48328

Source: SECUNIA
Type: Vendor Advisory
48771

Source: DEBIAN
Type: UNKNOWN
DSA-2449

Source: DEBIAN
Type: DSA-2449
sqlalchemy -- missing input sanitization

Source: MANDRIVA
Type: UNKNOWN
MDVSA-2012:059

Source: CCN
Type: OSVDB ID: 79864
SQLAlchemy select() Function Multiple Keyword SQL Injection

Source: CCN
Type: BID-52330
SQLAlchemy 'limit' and 'offset' Parameters SQL Injection Vulnerabilities

Source: CCN
Type: SQLAlchemy Web Site
CHANGES 0.7.0

Source: CONFIRM
Type: UNKNOWN
http://www.sqlalchemy.org/changelog/CHANGES_0_7_0

Source: CONFIRM
Type: Exploit, Patch
http://www.sqlalchemy.org/trac/changeset/852b6a1a87e7/

Source: MISC
Type: UNKNOWN
https://bugs.launchpad.net/keystone/+bug/918608

Source: XF
Type: UNKNOWN
sqlalchemy-select-sql-injection(73756)

Source: XF
Type: UNKNOWN
sqlalchemy-select-sql-injection(73756)

Vulnerable Configuration:Configuration 1:
  • cpe:/a:sqlalchemy:sqlalchemy:0.6.0:*:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.6.0:beta1:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.6.0:beta2:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.6.0:beta3:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.6.1:*:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.6.2:*:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.6.3:*:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.6.4:*:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.6.5:*:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.6.6:*:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.6.7:*:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.7.0:b1:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:0.7.0:b2:*:*:*:*:*:*
  • OR cpe:/a:sqlalchemy:sqlalchemy:*:b3:*:*:*:*:*:* (Version <= 0.7.0)

    • Configuration RedHat 1:
  • cpe:/o:redhat:enterprise_linux:6:*:*:*:*:*:*:*

    • Configuration RedHat 2:
  • cpe:/o:redhat:enterprise_linux:6::server:*:*:*:*:*

    • Configuration RedHat 3:
  • cpe:/o:redhat:enterprise_linux:6::workstation:*:*:*:*:*

    • Configuration CCN 1:
  • cpe:/a:sqlalchemy:sqlalchemy:0.6.7:*:*:*:*:*:*:*
  • AND
  • cpe:/o:redhat:enterprise_linux:6:*:server:*:*:*:*:*
  • OR cpe:/o:redhat:enterprise_linux:6:*:workstation:*:*:*:*:*

    • * Denotes that component is vulnerable
    Oval Definitions
    Definition IDClassTitleLast Modified
    oval:org.mitre.oval:def:18475
    P
    		DSA-2449-1 sqlalchemy - missing input sanitisation
    2014-06-23
    oval:org.mitre.oval:def:23515
    P
    		ELSA-2012:0369: python-sqlalchemy security update (Moderate)
    2014-05-26
    oval:org.mitre.oval:def:20474
    P
    		RHSA-2012:0369: python-sqlalchemy security update (Moderate)
    2014-02-24
    oval:com.ubuntu.precise:def:20120805000
    V
    		CVE-2012-0805 on Ubuntu 12.04 LTS (precise) - medium.
    2012-06-05
    oval:com.redhat.rhsa:def:20120369
    P
    		RHSA-2012:0369: python-sqlalchemy security update (Moderate)
    2012-03-07
    BACK
    sqlalchemy sqlalchemy 0.6.0
    sqlalchemy sqlalchemy 0.6.0 beta1
    sqlalchemy sqlalchemy 0.6.0 beta2
    sqlalchemy sqlalchemy 0.6.0 beta3
    sqlalchemy sqlalchemy 0.6.1
    sqlalchemy sqlalchemy 0.6.2
    sqlalchemy sqlalchemy 0.6.3
    sqlalchemy sqlalchemy 0.6.4
    sqlalchemy sqlalchemy 0.6.5
    sqlalchemy sqlalchemy 0.6.6
    sqlalchemy sqlalchemy 0.6.7
    sqlalchemy sqlalchemy 0.7.0 b1
    sqlalchemy sqlalchemy 0.7.0 b2
    sqlalchemy sqlalchemy * b3
    sqlalchemy sqlalchemy 0.6.7
    redhat enterprise linux 6
    redhat enterprise linux 6