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