Ecosyste.ms: Advisories

Security Advisories: GSA_kwCzR0hTQS04eHBqLTlqOWctZmM5cs05eQ

SQL Injection in elide-datastore-aggregation

Impact

When leveraging the following together:

• Elide Aggregation Data Store for Analytic Queries
• Parameterized Columns (A column that requires a client provided parameter)
• A parameterized column of type TEXT

There is the potential for a hacker to provide a carefully crafted query that would bypass server side authorization filters through SQL injection. A recent patch to Elide 6.1.2 allowed the '-' character to be included in parameterized TEXT columns. This character can be interpreted as SQL comments ('--') and allow the attacker to remove the WHERE clause from the generated query and bypass authorization filters.

Patches

A fix is provided in Elide 6.1.4.

Workarounds

The vulnerability only exists for parameterized columns of type TEXT and only for analytic queries (CRUD is not impacted). Workarounds include leveraging a different type of parameterized column (TIME, MONEY, etc) or not leveraging parameterized columns.

For more information

If you have any questions or comments about this advisory:

• Open an issue in elide
• Contact us in Discord

Permalink: https://github.com/advisories/GHSA-8xpj-9j9g-fc9r
JSON: https://advisories.ecosyste.ms/api/v1/advisories/GSA_kwCzR0hTQS04eHBqLTlqOWctZmM5cs05eQ
Source: GitHub Advisory Database
Origin: Unspecified
Severity: High
Classification: General
Published: about 2 years ago
Updated: over 1 year ago

CVSS Score: 8.1
CVSS vector: CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H

Identifiers: GHSA-8xpj-9j9g-fc9r, CVE-2022-24827
References:

• https://github.com/yahoo/elide/security/advisories/GHSA-8xpj-9j9g-fc9r
• https://github.com/yahoo/elide/pull/2581
• https://github.com/yahoo/elide/releases/tag/6.1.4
• https://nvd.nist.gov/vuln/detail/CVE-2022-24827
• https://github.com/advisories/GHSA-8xpj-9j9g-fc9r

Repository: https://github.com/yahoo/elide
Blast Radius: 6.8

Affected Packages