Australia's Leading Computer Emergency Response Team

ESB-2012.0253 - [Win][UNIX/Linux][RedHat] python-sqlalchemy: Execute arbitrary code/commands - Remote/unauthenticated
Date: 08 March 2012
Original URL: https://www.auscert.org.au/render.html?cid=1980&it=15567
References: ESB-2012.0367  

Click here for PGP verifiable version
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

===========================================================================
             AUSCERT External Security Bulletin Redistribution

                               ESB-2012.0253
                Moderate: python-sqlalchemy security update
                               8 March 2012

===========================================================================

        AusCERT Security Bulletin Summary
        ---------------------------------

Product:           python-sqlalchemy
Publisher:         Red Hat
Operating System:  Red Hat Enterprise Linux Server 6
                   Red Hat Enterprise Linux WS/Desktop 6
                   UNIX variants (UNIX, Linux, OSX)
                   Windows
Impact/Access:     Execute Arbitrary Code/Commands -- Remote/Unauthenticated
Resolution:        Patch/Upgrade
CVE Names:         CVE-2012-0805  

Original Bulletin: 
   https://rhn.redhat.com/errata/RHSA-2012-0369.html

Comment: This advisory references vulnerabilities in products which run on 
         platforms other than Red Hat. It is recommended that administrators
         running python-sqlalchemy check for an updated version of the 
         software for their operating system.

- --------------------------BEGIN INCLUDED TEXT--------------------

- -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

=====================================================================
                   Red Hat Security Advisory

Synopsis:          Moderate: python-sqlalchemy security update
Advisory ID:       RHSA-2012:0369-01
Product:           Red Hat Enterprise Linux
Advisory URL:      https://rhn.redhat.com/errata/RHSA-2012-0369.html
Issue date:        2012-03-07
CVE Names:         CVE-2012-0805 
=====================================================================

1. Summary:

An updated python-sqlalchemy package that fixes one security issue is now
available for Red Hat Enterprise Linux 6.

The Red Hat Security Response Team has rated this update as having moderate
security impact. A Common Vulnerability Scoring System (CVSS) base score,
which gives a detailed severity rating, is available from the CVE link in
the References section.

2. Relevant releases/architectures:

Red Hat Enterprise Linux Server (v. 6) - noarch
Red Hat Enterprise Linux Workstation (v. 6) - noarch

3. Description:

SQLAlchemy is an Object Relational Mapper (ORM) that provides a flexible,
high-level interface to SQL databases.

It was discovered that SQLAlchemy did not sanitize values for the limit and
offset keywords for SQL select statements. If an application using
SQLAlchemy accepted values for these keywords, and did not filter or
sanitize them before passing them to SQLAlchemy, it could allow an attacker
to perform an SQL injection attack against the application. (CVE-2012-0805)

All users of python-sqlalchemy are advised to upgrade to this updated
package, which contains a patch to correct this issue. All running
applications using SQLAlchemy must be restarted for this update to take
effect.

4. Solution:

Before applying this update, make sure all previously-released errata
relevant to your system have been applied.

This update is available via the Red Hat Network. Details on how to
use the Red Hat Network to apply this update are available at
https://access.redhat.com/knowledge/articles/11258

5. Bugs fixed (http://bugzilla.redhat.com/):

783305 - CVE-2012-0805 python-sqlalchemy: SQL injection flaw due to not checking LIMIT input for correct type

6. Package List:

Red Hat Enterprise Linux Server (v. 6):

Source:
ftp://ftp.redhat.com/pub/redhat/linux/enterprise/6Server/en/os/SRPMS/python-sqlalchemy-0.5.5-3.el6_2.src.rpm

noarch:
python-sqlalchemy-0.5.5-3.el6_2.noarch.rpm

Red Hat Enterprise Linux Workstation (v. 6):

Source:
ftp://ftp.redhat.com/pub/redhat/linux/enterprise/6Workstation/en/os/SRPMS/python-sqlalchemy-0.5.5-3.el6_2.src.rpm

noarch:
python-sqlalchemy-0.5.5-3.el6_2.noarch.rpm

These packages are GPG signed by Red Hat for security.  Our key and 
details on how to verify the signature are available from
https://access.redhat.com/security/team/key/#package

7. References:

https://www.redhat.com/security/data/cve/CVE-2012-0805.html
https://access.redhat.com/security/updates/classification/#moderate

8. Contact:

The Red Hat security contact is <secalert@redhat.com>.  More contact
details at https://access.redhat.com/security/team/contact/

Copyright 2012 Red Hat, Inc.
- -----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.4 (GNU/Linux)

iD8DBQFPV3HxXlSAg2UNWIIRArtJAKCrAMKqUNWWK49IvHBPzqI9dE9EmgCeP+pD
Pid9IBfgRRF5wes87heuHec=
=IJ1b
- -----END PGP SIGNATURE-----

- --------------------------END INCLUDED TEXT--------------------

You have received this e-mail bulletin as a result of your organisation's
registration with AusCERT. The mailing list you are subscribed to is
maintained within your organisation, so if you do not wish to continue
receiving these bulletins you should contact your local IT manager. If
you do not know who that is, please send an email to auscert@auscert.org.au
and we will forward your request to the appropriate person.

NOTE: Third Party Rights
This security bulletin is provided as a service to AusCERT's members.  As
AusCERT did not write the document quoted above, AusCERT has had no control
over its content. The decision to follow or act on information or advice
contained in this security bulletin is the responsibility of each user or
organisation, and should be considered in accordance with your organisation's
site policies and procedures. AusCERT takes no responsibility for consequences
which may arise from following or acting on information or advice contained in
this security bulletin.

NOTE: This is only the original release of the security bulletin.  It may
not be updated when updates to the original are made.  If downloading at
a later date, it is recommended that the bulletin is retrieved directly
from the author's website to ensure that the information is still current.

Contact information for the authors of the original document is included
in the Security Bulletin above.  If you have any questions or need further
information, please contact them directly.

Previous advisories and external security bulletins can be retrieved from:

        http://www.auscert.org.au/render.html?cid=1980

===========================================================================
Australian Computer Emergency Response Team
The University of Queensland
Brisbane
Qld 4072

Internet Email: auscert@auscert.org.au
Facsimile:      (07) 3365 7031
Telephone:      (07) 3365 4417 (International: +61 7 3365 4417)
                AusCERT personnel answer during Queensland business hours
                which are GMT+10:00 (AEST).
                On call after hours for member emergencies only.
===========================================================================
-----BEGIN PGP SIGNATURE-----
Comment: http://www.auscert.org.au/render.html?it=1967

iQIVAwUBT1g95u4yVqjM2NGpAQKBvhAAgjUaU19XpJtJCL43IrhXTLei8zCM3YPl
P5I4eiqOhgtzpkemfqbayZOPtgSvsSr+DpXGqUxDlMCZt9xfuZQ84KFydAnazgMP
bfyQgwaOxEF29uQnBXxo4hPX/Ev41anBgUHVoEDUoSiwrge/9YpOayboIcatfc+c
+cCtYs8MHzRgcz01aHLRyfotNhoKyhmL0HO+FekteivyfoYiHLE75oPWk2vc7BqG
k4NkX5aOPCKqqmkLBkILiznufY44LYTLGDXrc4i2wUaRBLMhVr+LMfqe52cSe0si
5KmZ/Bl8LatPjgPafjFYVsA2WqgM1yHObYjg2sAABMg27+kMQcucbLc8P5II8f5P
F+sWCbcWhEp0lUP8qPx7OiEW5DiECBehIc6QRpmOdUJ+mTP5QM0v+XhlztusuyAi
YFyfO2Vmfhy/j2gS49+V1YVrTQ5yRBBd3fIm4Y4bfXMnh/fr1AZvHSBtGba/V/+O
v/64hqcuZZrD0fLy1McOYLFudf/DWe8wuttg44KS3R/+Xp4k18L9p11q2CxEICZ+
9piAFFhQQEne97BfpQLu2Ss8YzXb5YDZMvGXCC4jDEoW8zyX6b2qqrfLQROpDUOI
Abz/okeEidrzEG1ZeVO6heyGdEgSXEtkuDg7uaoH9s3kWdvmmrrRR7cAcyAVVo7q
ah7cW20xPhI=
=IT0R
-----END PGP SIGNATURE-----