Skip to content

Authenticated SQL Injection

Moderate
marcelfolaron published GHSA-559g-3h98-g3fj Oct 19, 2023

Package

app/domain/files/repositories/class.files.php (leantime)

Affected versions

< 2.4-beta-4

Patched versions

2.4-beta-4

Description

Summary

A 'userId' variable in app/domain/files/repositories/class.files.php is not parameterized. An authenticated attacker can send a carefully crafted POST request to /api/jsonrpc to exploit an SQL injection vulnerability.

I was able to dump the following sensitive information from the database:

  • 2FA secret keys
  • Hashed passwords
  • Emails
  • Active session tokens

Impact

Confidentiality is impacted as it allows for dumping information from the database. It is possible that it affects availability and integrity as well, however I was unable to modify/drop any tables.

Severity

Moderate

CVSS overall score

This score calculates overall vulnerability severity from 0 to 10 and is based on the Common Vulnerability Scoring System (CVSS).
/ 10

CVSS v3 base metrics

Attack vector
Network
Attack complexity
Low
Privileges required
Low
User interaction
None
Scope
Unchanged
Confidentiality
High
Integrity
None
Availability
None

CVSS v3 base metrics

Attack vector: More severe the more the remote (logically and physically) an attacker can be in order to exploit the vulnerability.
Attack complexity: More severe for the least complex attacks.
Privileges required: More severe if no privileges are required.
User interaction: More severe when no user interaction is required.
Scope: More severe when a scope change occurs, e.g. one vulnerable component impacts resources in components beyond its security scope.
Confidentiality: More severe when loss of data confidentiality is highest, measuring the level of data access available to an unauthorized user.
Integrity: More severe when loss of data integrity is the highest, measuring the consequence of data modification possible by an unauthorized user.
Availability: More severe when the loss of impacted component availability is highest.
CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N

CVE ID

CVE-2023-45826

Weaknesses

Credits