los angeles information security consultants
DigiTrust Assurance

The DigiTrust Group: Advisory #080620a - eTicket SQL Injection Vulnerability

Product:
eTicket v1.5.7
Older versions of eTicket are likely affected as well

Credits:
Omer Singer
The DigiTrust Group
http://www.digitrustgroup.com
June 20, 2008

Risk Level:
HIGH

Program Summary:
eTicket is a PHP-based online support ticket system that can receive tickets via e-mail or a web form. In many implementations, no authentication is required for ticket creation.
http://eticket.sourceforge.net/

SQL Injection Vulnerability:
Input passed to the "pri" parameter is not properly sanitised before being used. This can be exploited to manipulate SQL queries by injecting arbitrary SQL code.

Affected Pages:
- index.php
- open.php
- open_raw.php
- newticket.php

Sample Exploit Code:
Submit a non-numeric value to "pri" parameter; the following error message is returned:
Error: Failed: Open Ticket INSERT INTO tickets (subject, name, email, cat, phone, status, ID, priority, ip, timestamp) VALUES ('subject', 'name', 'example@example.com', '1', 'phone', 'open', 361328, , '192.168.1.48', UTC_TIMESTAMP())You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '192.168.1.48', UTC_TIMESTAMP())' at line 1

Vendor Solution:
Update to version 1.7.0.

Copyright (c) 2008 The DigiTrust Group.

Permission is granted for the redistribution of this alert electronically. It may not be edited in any way without the express written consent of The DigiTrust Group.

Disclaimer: The information in the advisory is believed to be accurate at the time of publishing based on currently available information. Use of the information constitutes acceptance for use on an AS IS condition. There are no warranties with regard to this information. Neither the author nor the publisher accepts any liability for any direct, indirect, or consequential loss or damage arising from use of, or reliance on, this information.

 





Newsletter Registration





web application security - eticket