TITLE:
OTRS SQL Injection and Cross-Site Scripting Vulnerabilities

SECUNIA ADVISORY ID:
SA17685

VERIFY ADVISORY:
http://secunia.com/advisories/17685/

CRITICAL:
Moderately critical

IMPACT:
Cross Site Scripting, Manipulation of data

WHERE:
>From remote

SOFTWARE:
OTRS (Open Ticket Request System) 1.x
http://secunia.com/product/6192/
OTRS (Open Ticket Request System) 2.x
http://secunia.com/product/6193/

DESCRIPTION:
Some vulnerabilities have been reported in OTRS (Open Ticket Request
System), which can be exploited by malicious people to conduct SQL
injection, script insertion, and cross-site scripting attacks.

1) Input passed to the "User" parameter in the "Login" function is
not properly sanitised before being used in a SQL query. This can
potentially be exploited to login to the application without valid
credentials.

2) Input passed to the "TicketID" and "ArticleID" parameters in the
"AgentTicketPlain" function is not properly sanitised before being
used in a SQL query. This can be exploited by authenticated users to
manipulate SQL queries by injecting arbitrary SQL code.

3) HTML email attachments are not properly sanitised before being
displayed. This can be exploited to execute arbitrary script code in
a user's browser session in context of an affected website when the
queue moderator clicks on the attachment download button.

4) Input passed to the "QueueID" and "Action" parameters in
"index.pl" is not properly sanitised before being returned to the
user. This can be exploited to execute arbitrary HTML and script code
in a user's browser session in context of an affected site.

The vulnerabilities have been reported in all releases of OTRS 2.x
prior to 2.0.4, and all releases of OTRS 1.x prior to 1.3.3.

SOLUTION:
Update to the fixed versions.
ftp://ftp.otrs.org/pub/otrs/

OTRS 2.x:
Update to version 2.0.4 

OTRS 1.x:
Update to version 1.3.3.

PROVIDED AND/OR DISCOVERED BY:
Moritz Naumann IT Consulting & Services

ORIGINAL ADVISORY:
Otrs.org:
http://otrs.org/advisory/OSA-2005-01-en/

Moritz Naumann IT Consulting & Services:
http://moritz-naumann.com/adv/0007/otrsmulti/0007.txt

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

About:
This Advisory was delivered by Secunia as a free service to help
everybody keeping their systems up to date against the latest
vulnerabilities.

Subscribe:
http://secunia.com/secunia_security_advisories/

Definitions: (Criticality, Where etc.)
http://secunia.com/about_secunia_advisories/


Please Note:
Secunia recommends that you verify all advisories you receive by
clicking the link.
Secunia NEVER sends attached files with advisories.
Secunia does not advise people to install third party patches, only
use those supplied by the vendor.

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