{"id":"UBUNTU-CVE-2014-1471","details":"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.","modified":"2025-07-16T07:31:44.470942Z","published":"2014-02-04T21:55:00Z","withdrawn":"2025-07-18T16:42:59Z","upstream":["CVE-2014-1471"],"references":[{"type":"REPORT","url":"https://ubuntu.com/security/CVE-2014-1471"},{"type":"REPORT","url":"https://www.otrs.com/security-advisory-2014-02-sql-injection-issue/"},{"type":"REPORT","url":"http://www.openwall.com/lists/oss-security/2014/01/29"},{"type":"REPORT","url":"https://www.cve.org/CVERecord?id=CVE-2014-1471"}],"affected":[{"package":{"name":"otrs2","ecosystem":"Ubuntu:14.04:LTS","purl":"pkg:deb/ubuntu/otrs2@3.3.5-1?arch=source&distro=trusty"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.3.5-1"}]}],"versions":["3.2.9-2","3.2.11-1","3.2.12-1","3.3.1-1","3.3.2-1","3.3.3-1","3.3.3-2","3.3.3-3","3.3.4-1"],"ecosystem_specific":{"availability":"No subscription required","binaries":[{"binary_name":"otrs","binary_version":"3.3.5-1"},{"binary_name":"otrs2","binary_version":"3.3.5-1"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2014/UBUNTU-CVE-2014-1471.json"}}],"schema_version":"1.7.3","severity":[{"type":"Ubuntu","score":"medium"}]}