SQL injection vulnerability in the StateGetStatesByType function in Kernel/System/State.pm in Open Ticket Request System (OTRS) 3.1.x before 3.1.19, 3.2.x before 3.2.14, and 3.3.x before 3.3.4 allows remote attackers to execute arbitrary SQL commands via vectors related to a ticket search URL.
The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.
| Link | Tags |
|---|---|
| https://github.com/OTRS/otrs/commit/0680603a07b8dc37c2ddca6ff14e0236babefc82 | patch |
| http://www.securityfocus.com/bid/65241 | vdb entry |
| http://www.openwall.com/lists/oss-security/2014/01/29/15 | mailing list |
| https://www.otrs.com/security-advisory-2014-02-sql-injection-issue | patch vendor advisory |
| https://github.com/OTRS/otrs/commit/c4ec9205bde9c49770ddad94c1a980c006164949 | patch |
| http://osvdb.org/102661 | vdb entry |
| https://www.otrs.com/release-notes-otrs-help-desk-3-3-4 | |
| http://secunia.com/advisories/56655 | third party advisory vendor advisory |
| https://github.com/OTRS/otrs/commit/2997b36a7c84e933c4b025930cabe93efc4d261d | patch |
| http://secunia.com/advisories/56644 | third party advisory vendor advisory |
| http://www.debian.org/security/2014/dsa-2867 | vendor advisory |