osTicket v1.6 RC4 Admin Login Blind SQLi

[Adam Baldwin <adam_baldwin () mail ngenuity-is com>]

nGenuity Information Services - Security Advisory

   Advisory ID: NGENUITY-2009-007 osTicket Admin Login Blind SQL Injection
   Application: osTicket v1.6 RC4
        Vendor: osTicket
Vendor website: http://www.osticket.com
        Author: Adam Baldwin (adam_baldwin () ngenuity-is com)

  I. BACKGROUND
    "osTicket is a widely-used open source support ticket system. It 
seamlessly
    integrates inquiries created via email and web-based forms into a 
simple
    easy to use multi-user web interface. Easily manage, organize and 
archive
    all your support requests and responses in one place while providing 
your
    clients with accountability and responsiveness they deserve." [1]

  II. DETAILS
    osTicket prior to v1.6 RC5 fails to validate / escape staff usernames 
which
    can be abused to execute a blind sql injection attack by an 
unauthenticated
    attacker.

    The vendor has provided a new release v1.6 RC5 which addresses this 
vulnerability.
    They have also provided patching instructions [2] should you be unable 
to perform
    a full upgrade at this time.

    One sample attack string might look similar to the following:
    '+(SELECT 
IF(SUBSTRING(passwd,1,1)=CHAR(48),BENCHMARK(1000000,SHA1(1)),0) passwd
    FROM ost_staff where staff_id=1) and '1'='1

  III. REFERENCES
    [1] - http://www.osticket.com
    [2] - http://osticket.com/forums/project.php?issueid=118

  IV. VENDOR COMMUNICATION
    3.25.2009 - Vulnerability Discovery
    3.25.2009 - Vendor notification & initial vendor response
    6.26.2009 - Vendor releases fix in osTicket v1.6 RC5

Copyright (c) 2009 nGenuity Information Services, LLC