{"schemaVersion":3,"id":"CVE-2014-1471","aliases":["UBUNTU-CVE-2014-1471","DEBIAN-CVE-2014-1471"],"status":"published","duplicateOf":null,"title":null,"description":"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.","dates":{"published":"2014-02-04T16:00:00.000Z","modified":"2024-08-06T09:42:35.594Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":7.5,"severity":"high","version":"2.0","versionLabel":"v2.0","source":"NVD","vector":"AV:N/AC:L/Au:N/C:P/I:P/A:P","computed":false,"selection":"backend-summary"},"metrics":[{"version":"2.0","versionLabel":"v2.0","source":"NVD","score":7.5,"severity":"high","vector":"AV:N/AC:L/Au:N/C:P/I:P/A:P","exploitability":null,"impact":null,"computed":false}]},"epss":{"probability":0.01774,"percentile":0.77988,"severity":"low","asOf":"2026-10-21T00:00:00.000Z","change":{"pp":0,"baselineDate":"2026-09-21T00:00:00.000Z","baselineScore":0.01774},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-20T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-21T00:00:00.000Z","score":0.01774,"percentile":0.77988}],"last30":[{"date":"2026-09-21T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-20T00:00:00.000Z","score":0.01774,"percentile":null},{"date":"2026-10-21T00:00:00.000Z","score":0.01774,"percentile":0.77988}]},"kev":{"state":"not-listed","entries":[],"listedCount":0,"totalCatalogs":3,"catalogs":[{"source":"cisa","label":"CISA","listed":false,"entry":null},{"source":"enisa","label":"ENISA","listed":false,"entry":null},{"source":"circl","label":"CIRCL","listed":false,"entry":null}]},"ransomware":{"state":"none-recorded","sources":[]},"exploits":[],"exploitCount":0,"weaknesses":[{"id":"CWE-89","name":"Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')","description":"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.","type":"weakness","status":"Stable","abstraction":"Base","likelihoodOfExploit":"High","url":"https://cwe.mitre.org/data/definitions/89.html"}],"affected":[{"vendor":"debian","product":"otrs2","name":"otrs2","label":"otrs2","ecosystem":"Debian","cpePart":null,"purl":"pkg:deb/debian/otrs2","purlType":"deb","versions":[{"text":"< 3.3.4-1","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 3.3.4-1","eol":null,"hubHref":null},{"vendor":"ubuntu","product":"otrs2","name":"otrs2","label":"otrs2","ecosystem":"Ubuntu","cpePart":null,"purl":"pkg:deb/ubuntu/otrs2","purlType":"deb","versions":[{"text":"< 3.3.5-1","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 3.3.5-1","eol":null,"hubHref":null},{"vendor":"otrs","product":"otrs","name":"otrs","label":"otrs","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"3.3.0","noFixRecorded":false,"fixedIn":null},{"text":"3.3.0:beta1","noFixRecorded":false,"fixedIn":null},{"text":"3.3.0:beta2","noFixRecorded":false,"fixedIn":null},{"text":"3.3.0:beta3","noFixRecorded":false,"fixedIn":null},{"text":"3.3.0:beta4","noFixRecorded":false,"fixedIn":null},{"text":"3.3.0:beta5","noFixRecorded":false,"fixedIn":null},{"text":"3.3.0:rc1","noFixRecorded":false,"fixedIn":null},{"text":"3.3.1","noFixRecorded":false,"fixedIn":null},{"text":"3.3.2","noFixRecorded":false,"fixedIn":null},{"text":"3.3.3","noFixRecorded":false,"fixedIn":null},{"text":"3.2.0","noFixRecorded":false,"fixedIn":null},{"text":"3.2.0:beta1","noFixRecorded":false,"fixedIn":null},{"text":"3.2.0:beta2","noFixRecorded":false,"fixedIn":null},{"text":"3.2.0:beta3","noFixRecorded":false,"fixedIn":null},{"text":"3.2.0:beta4","noFixRecorded":false,"fixedIn":null},{"text":"3.2.0:beta5","noFixRecorded":false,"fixedIn":null},{"text":"3.2.0:rc1","noFixRecorded":false,"fixedIn":null},{"text":"3.2.1","noFixRecorded":false,"fixedIn":null},{"text":"3.2.2","noFixRecorded":false,"fixedIn":null},{"text":"3.2.3","noFixRecorded":false,"fixedIn":null},{"text":"3.2.4","noFixRecorded":false,"fixedIn":null},{"text":"3.2.5","noFixRecorded":false,"fixedIn":null},{"text":"3.2.6","noFixRecorded":false,"fixedIn":null},{"text":"3.2.7","noFixRecorded":false,"fixedIn":null},{"text":"3.2.8","noFixRecorded":false,"fixedIn":null},{"text":"3.2.9","noFixRecorded":false,"fixedIn":null},{"text":"3.2.10","noFixRecorded":false,"fixedIn":null},{"text":"3.1.0","noFixRecorded":false,"fixedIn":null},{"text":"3.1.1","noFixRecorded":false,"fixedIn":null},{"text":"3.1.2","noFixRecorded":false,"fixedIn":null},{"text":"3.1.3","noFixRecorded":false,"fixedIn":null},{"text":"3.1.4","noFixRecorded":false,"fixedIn":null},{"text":"3.1.5","noFixRecorded":false,"fixedIn":null},{"text":"3.1.6","noFixRecorded":false,"fixedIn":null},{"text":"3.1.7","noFixRecorded":false,"fixedIn":null},{"text":"3.1.8","noFixRecorded":false,"fixedIn":null},{"text":"3.1.9","noFixRecorded":false,"fixedIn":null},{"text":"3.1.10","noFixRecorded":false,"fixedIn":null},{"text":"3.1.11","noFixRecorded":false,"fixedIn":null},{"text":"3.1.13","noFixRecorded":false,"fixedIn":null},{"text":"3.1.14","noFixRecorded":false,"fixedIn":null},{"text":"3.1.15","noFixRecorded":false,"fixedIn":null},{"text":"3.1.16","noFixRecorded":false,"fixedIn":null},{"text":"3.1.17","noFixRecorded":false,"fixedIn":null},{"text":"3.1.18","noFixRecorded":false,"fixedIn":null}],"versionsText":"3.3.0 | 3.3.0:beta1 | 3.3.0:beta2 | 3.3.0:beta3 | 3.3.0:beta4 | 3.3.0:beta5 | 3.3.0:rc1 | 3.3.1 | 3.3.2 | 3.3.3 | 3.2.0 | 3.2.0:beta1 | 3.2.0:beta2 | 3.2.0:beta3 | 3.2.0:beta4 | 3.2.0:beta5 | 3.2.0:rc1 | 3.2.1 | 3.2.2 | 3.2.3 | 3.2.4 | 3.2.5 | 3.2.6 | 3.2.7 | 3.2.8 | 3.2.9 | 3.2.10 | 3.1.0 | 3.1.1 | 3.1.2 | 3.1.3 | 3.1.4 | 3.1.5 | 3.1.6 | 3.1.7 | 3.1.8 | 3.1.9 | 3.1.10 | 3.1.11 | 3.1.13 | 3.1.14 | 3.1.15 | 3.1.16 | 3.1.17 | 3.1.18","eol":null,"hubHref":"/vendor/otrs/otrs"}],"affectedCount":3,"eol":{"hasEol":false,"count":0},"references":[{"url":"https://github.com/OTRS/otrs/commit/0680603a07b8dc37c2ddca6ff14e0236babefc82","label":"github.com/OTRS/otrs/commit/0680603a07b8dc37c2ddca6ff14e0236babefc82","hostname":"github.com","tags":["X Refsource CONFIRM","Patch"]},{"url":"http://www.securityfocus.com/bid/65241","label":"www.securityfocus.com/bid/65241","hostname":"www.securityfocus.com","tags":["VDB Entry","X Refsource BID"]},{"url":"http://www.openwall.com/lists/oss-security/2014/01/29/15","label":"www.openwall.com/lists/oss-security/2014/01/29/15","hostname":"www.openwall.com","tags":["Mailing List","X Refsource MLIST"]},{"url":"https://www.otrs.com/security-advisory-2014-02-sql-injection-issue","label":"www.otrs.com/security-advisory-2014-02-sql-injection-issue","hostname":"www.otrs.com","tags":["X Refsource CONFIRM","Patch","Vendor Advisory"]},{"url":"https://github.com/OTRS/otrs/commit/c4ec9205bde9c49770ddad94c1a980c006164949","label":"github.com/OTRS/otrs/commit/c4ec9205bde9c49770ddad94c1a980c006164949","hostname":"github.com","tags":["X Refsource CONFIRM","Patch"]},{"url":"http://osvdb.org/102661","label":"osvdb.org/102661","hostname":"osvdb.org","tags":["VDB Entry","X Refsource OSVDB"]},{"url":"https://www.otrs.com/release-notes-otrs-help-desk-3-3-4","label":"www.otrs.com/release-notes-otrs-help-desk-3-3-4","hostname":"www.otrs.com","tags":["X Refsource CONFIRM"]},{"url":"http://secunia.com/advisories/56655","label":"secunia.com/advisories/56655","hostname":"secunia.com","tags":["Third Party Advisory","X Refsource SECUNIA","Vendor Advisory"]},{"url":"https://github.com/OTRS/otrs/commit/2997b36a7c84e933c4b025930cabe93efc4d261d","label":"github.com/OTRS/otrs/commit/2997b36a7c84e933c4b025930cabe93efc4d261d","hostname":"github.com","tags":["X Refsource CONFIRM","Patch"]},{"url":"http://secunia.com/advisories/56644","label":"secunia.com/advisories/56644","hostname":"secunia.com","tags":["Third Party Advisory","X Refsource SECUNIA","Vendor Advisory"]},{"url":"http://www.debian.org/security/2014/dsa-2867","label":"www.debian.org/security/2014/dsa-2867","hostname":"www.debian.org","tags":["Vendor Advisory","X Refsource DEBIAN"]},{"url":"https://ubuntu.com/security/CVE-2014-1471","label":"ubuntu.com/security/CVE-2014-1471","hostname":"ubuntu.com","tags":["REPORT"]},{"url":"https://www.otrs.com/security-advisory-2014-02-sql-injection-issue/","label":"www.otrs.com/security-advisory-2014-02-sql-injection-issue/","hostname":"www.otrs.com","tags":["REPORT"]},{"url":"http://www.openwall.com/lists/oss-security/2014/01/29","label":"www.openwall.com/lists/oss-security/2014/01/29","hostname":"www.openwall.com","tags":["REPORT"]},{"url":"https://www.cve.org/CVERecord?id=CVE-2014-1471","label":"www.cve.org/CVERecord?id=CVE-2014-1471","hostname":"www.cve.org","tags":["REPORT"]},{"url":"https://security-tracker.debian.org/tracker/CVE-2014-1471","label":"security-tracker.debian.org/tracker/CVE-2014-1471","hostname":"security-tracker.debian.org","tags":["Advisory"]}],"lineage":{"upstream":[],"downstream":["DSA-2867-1","MGASA-2014-0094"],"duplicates":[],"related":[]},"timeline":[{"kind":"published","date":"2014-02-04T16:00:00.000Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2024-08-06T09:42:35.594Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":30,"level":"medium","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-21T22:18:21.732Z","stale":false,"partial":false}}