Hash: SHA1

             AUSCERT External Security Bulletin Redistribution

              Vulnerability in OTRS-Core allows SQL-Injection
                              9 February 2010


        AusCERT Security Bulletin Summary

Product:           OTRS 2.4.x
                   OTRS 2.3.x
                   OTRS 2.2.x
                   OTRS 2.1.x
Publisher:         OTRS
Operating System:  Windows
                   UNIX variants (UNIX, Linux, OSX)
Impact/Access:     Increased Privileges            -- Existing Account
                   Execute Arbitrary Code/Commands -- Existing Account
Resolution:        Patch/Upgrade
CVE Names:         CVE-2010-0438  

Original Bulletin: 

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

- --------------------------------------------------------------------------------
 OTRS Security Advisory 2010-01                           <security@otrs.org>
- --------------------------------------------------------------------------------
 ID:         OSA-2010-01
 Date:       2010-02-08
 Title:      Vulnerability in OTRS-Core allows SQL-Injection
 Severity:   Critical
 Product:    OTRS 2.4.x, OTRS 2.3.x, OTRS 2.2.x, OTRS 2.1.x
 Fixed in:   OTRS 2.4.7, OTRS 2.3.5, OTRS 2.2.9, OTRS 2.1.9
 URL:        http://otrs.org/advisory/OSA-2010-01-en/
 CVE:        CVE-2010-0438
- --------------------------------------------------------------------------------

This Advisory covers a vulnerability discovered in the OTRS core system.

SQL Injection

  Missing security quoting for SQL statements allows agents and customers to
  manipulate SQL queries. So it's possible for authenticated users to inject
  SQL queries via string manipulation of statements.

  A malicious user may be able to manipulate SQL queries to read or modify
  records in the database. This way it could also be possible to get access 
  to more permissions (e. g. administrator permissions).

  To use this vulnerability the malicious user needs to have a valid Agent-
  or Customer-session.

Affected by this vulnerability are all releases of OTRS 2.1.x up
to and including 2.4.6.

This vulnerability is fixed in OTRS 2.1.9, OTRS 2.2.9, OTRS 2.3.5
and OTRS 2.4.7.

Fixed OTRS releases can be found at:

 o http://otrs.org/releases/

As a workaround it's also possible to replace the file 
Kernel/System/Ticket.pm by a version that has been fixed.

 o OTRS 2.1.x: v1.233.2.3
 o OTRS 2.2.x: v1.275.2.19
 o OTRS 2.3.x: v1.346.2.9
 o OTRS 2.4.x: v1.416.2.10


Please send information regarding vulnerabilities in OTRS to

Many thanks to CESICAT (http://www.cesicat.cat/) for discovering this

Copyright (c) OTRS AG, <http://otrs.org/>

- --------------------------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:


If you believe that your computer system has been compromised or attacked in 
any way, we encourage you to let us know by completing the secure National IT 
Incident Reporting Form at:


Australian Computer Emergency Response Team
The University of Queensland
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.
Comment: http://www.auscert.org.au/render.html?it=1967