Multiple SQL injection vulnerabilities in the FAQ package 2.x before 2.3.6, 4.x before 4.0.5, and 5.x before 5.0.5 in Open Ticket Request Sy

Affected versions

NVD version ranges (for catalog products). Add the product to your stack with a version and matching uses these.

• otrs faq2.0.1
• otrs faq2.0.2
• otrs faq2.0.3
• otrs faq2.0.4
• otrs faq2.0.5
• otrs faq2.0.6
• otrs faq2.0.7
• otrs faq2.0.8
• otrs faq2.1.0
• otrs faq2.1.1
• otrs faq2.1.2
• otrs faq2.1.3
• otrs faq2.1.4
• otrs faq2.2.0
• otrs faq2.2.1
• otrs faq2.2.2
• otrs faq2.2.3
• otrs faq2.3.0
• otrs faq2.3.1
• otrs faq2.3.2

Package-level exposure

OSV and GitHub Advisory data: ecosystem, package and range. SBOM matching uses this table.

Other highest-scoring records for the same primary product.

• CVE-2013-2625An Access Bypass issue exists in OTRS Help Desk before 3.2.4, 3.1.14, and 3.0.19, OTRS ITSM before 3.2.3, 3.1.8, and 3.0.7, and FAQ before 2
  26Monitor
• CVE-2013-2637A Cross-Site Scripting (XSS) Vulnerability exists in OTRS ITSM prior to 3.2.4, 3.1.8, and 3.0.7 and FAQ prior to 2.1.4 and 2.0.8 via changes
  25Monitor
• CVE-2021-21438FAQ articles are shown to users without permission
  17Monitor

FIRST EPSS daily score; only changes of 0.01 or more are recorded (step chart).

Root cause

The query text is built by concatenating user input. The database cannot tell where the data ends and the command begins.

A representative example of this vulnerability class. Not the vendor's source code; it shows the faulty pattern and its fix.

1const owner = req.query.owner;2const rows = await db.query(3  "SELECT * FROM files WHERE owner = '" + owner + "'"4);

1const owner = req.query.owner;2const rows = await db.query(3  "SELECT * FROM files WHERE owner = $1",4  [owner]5);

Attack context

MITRE CAPEC attack patterns and ATT&CK techniques for this weakness class (CWE). A starting point for detection rules and threat hunting.