Gentoo: 201209-16 SQLAlchemy: SQL injection
Posted by Benjamin D. Thomas   
Gentoo An input sanitation flaw in SQLAlchemy allows remote attacker to conduct SQL injection.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Gentoo Linux Security Advisory                           GLSA 201209-16
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
                                            http://security.gentoo.org/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

 Severity: Normal
    Title: SQLAlchemy: SQL injection
     Date: September 26, 2012
     Bugs: #407437
       ID: 201209-16

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Synopsis
========

An input sanitation flaw in SQLAlchemy allows remote attacker to
conduct SQL injection.

Background
==========

SQLAlchemy is a Python SQL toolkit and Object Relational Mapper.

Affected packages
=================

    -------------------------------------------------------------------
     Package              /     Vulnerable     /            Unaffected
    -------------------------------------------------------------------
  1  dev-python/sqlalchemy        < 0.7.4                    >= 0.7.4

Description
===========

SQLAlchemy does not properly sanitize input passed from the "limit" and
"offset" keywords to the select() function before using it in an SQL
query.

Impact
======

A remote attacker could exploit this vulnerability to execute arbitrary
SQL statements.

Workaround
==========

There is no known workaround at this time.

Resolution
==========

All SQLAlchemy users should upgrade to the latest version:

  # emerge --sync
  # emerge --ask --oneshot --verbose ">=dev-python/sqlalchemy-0.7.4"

References
==========

[ 1 ] CVE-2012-0805
      http://nvd.nist.gov/nvd.cfm?cvename=CVE-2012-0805

Availability
============

This GLSA and any updates to it are available for viewing at
the Gentoo Security Website:

 http://security.gentoo.org/glsa/glsa-201209-16.xml

Concerns?
=========

Security is a primary focus of Gentoo Linux and ensuring the
confidentiality and security of our users' machines is of utmost
importance to us. Any security concerns should be addressed to
security@gentoo.org or alternatively, you may file a bug at
https://bugs.gentoo.org.

License

Copyright 2012 Gentoo Foundation, Inc; referenced text
belongs to its owner(s).

The contents of this document are licensed under the
Creative Commons - Attribution / Share Alike license.

http://creativecommons.org/licenses/by-sa/2.5