GHSA-265q-222x-52m6: Silverstripe/framework SQL Injection Vulnerability

HIGH
CVSS 8.8
CWE-89
Published
Advisory Summary

GHSA-265q-222x-52m6 is a HIGH (CVSS 8.8) sql injection vulnerability (CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')) affecting Silverstripe/framework libraries in the Packagist ecosystem. The issue involves silverstripe/framework has potential sql injection vulnerability in postgresql database connector. Remediation is available by upgrading affected packages to version 4.0.6, 4.1.4, 4.2.3.

GHSA-265q-222x-52m6 at a Glance

CVE Identifier N/A
GHSA Identifier GHSA-265q-222x-52m6
Severity HIGH
CVSS v3.1 Base Score 8.8
CWE Classification CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
Affected Product Silverstripe/framework
Package Ecosystem Packagist
Published Date
Last Updated

Security Impact

CVSS: 8.8

The security impact metrics below are parsed directly from the CVSS v3.1 vector string (CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H).

Attack Vector Network (AV:N)
Attack Complexity Low (AC:L)
Privileges Required Low (PR:L)
User Interaction None (UI:N)
Scope Unchanged (S:U)
Confidentiality High (C:H)
Integrity High (I:H)
Availability High (A:H)

How to Fix GHSA-265q-222x-52m6

To remediate this vulnerability, upgrade all affected Silverstripe/framework dependencies to a patched release. Both direct and transitive dependencies should be checked, as frameworks or security libraries may pull in vulnerable versions transitively.

silverstripe/framework fixed: 4.0.6
Upgrade silverstripe/framework to 4.0.6
silverstripe/framework fixed: 4.1.4
Upgrade silverstripe/framework to 4.1.4
silverstripe/framework fixed: 4.2.3
Upgrade silverstripe/framework to 4.2.3
Verify Direct and Transitive Dependencies

Run the following command in your project directory to verify that all resolved dependencies use the patched release:

inspect dependencies for silverstripe/framework

How to Check if You Are Affected

To determine whether your application is affected by GHSA-265q-222x-52m6, inspect your project dependencies for Silverstripe/framework:

inspect dependencies for silverstripe/framework

Analyze the terminal output to locate any version of Silverstripe/framework in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 4.0.6), your application is affected.

Note: Verify declared build manifests and deployed runtime container environments.

Technical Details

Vulnerability Mechanism & Technical Analysis

This vulnerability is classified under CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection'), where the product constructs all or part of an sql command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended sql command when it is sent to a downstream component. without sufficient removal or quoting of sql syntax in user-controllable inputs, the generated sql query can cause those inputs to be interpreted as sql instead of ordinary user data. In Silverstripe/framework, software state validation or input boundaries are circumvented during processing. Review the official source advisory statement below for specific affected components, classes, and reproduction details.

Source Advisory Statement

A potential SQL injection vulnerability was identified by using the silverstripe/postgresql database adapter. While unlikely to be exploitable, we have patched silverstripe/framework to ensure that table names are safely escaped before being passed to database adapters or user code.

GHSA-265q-222x-52m6 Affected Silverstripe/framework Versions

3 component(s)
Fixed Versions:
4.0.64.1.44.2.3
Product / Package Ecosystem Affected Versions Fixed Version
silverstripe/framework
Packagist
≥ 4.0.0-rc1
< 4.0.6
4.0.6
silverstripe/framework
Packagist
≥ 4.1.0-rc1
< 4.1.4
4.1.4
silverstripe/framework
Packagist
≥ 4.2.0-rc1
< 4.2.3
4.2.3

References

Frequently Asked Questions

What is GHSA-265q-222x-52m6?
GHSA-265q-222x-52m6 is a security vulnerability in Silverstripe/framework involving silverstripe/framework has potential SQL Injection vulnerability in PostgreSQL database connector under CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection').
Which Silverstripe/framework versions are affected?
Affected versions include releases prior to 4.0.6, 4.1.4, 4.2.3 across affected packages: silverstripe/framework.
What version fixes GHSA-265q-222x-52m6?
Upgrading to 4.0.6, 4.1.4, 4.2.3 (or the latest patched release for your respective branch) resolves the vulnerability.
Is silverstripe/framework affected?
Yes, silverstripe/framework is affected in releases prior to 4.0.6, 4.1.4, 4.2.3. Upgrade your dependency to 4.0.6, 4.1.4, 4.2.3 or later.
What is the CVSS score of GHSA-265q-222x-52m6?
GHSA-265q-222x-52m6 has a CVSS v3.1 base score of 8.8 (HIGH) with vector string CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H.
What CWE is associated with GHSA-265q-222x-52m6?
GHSA-265q-222x-52m6 is classified under CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') (The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.).
How can I check Packagist dependencies for GHSA-265q-222x-52m6?
Run the dependency tree command: 'inspect dependencies for silverstripe/framework'. This command lists direct and transitive dependencies in your build configuration so you can verify if a vulnerable version is resolved.
Machine-readable OSV JSON OSV v1.5 Schema
Normalized schema output
{
  "schema_version" : "1.4.0",
  "id" : "GHSA-265q-222x-52m6",
  "modified" : "2024-05-28T13:01:48Z",
  "published" : "2024-05-28T13:01:48Z",
  "aliases" : [ ],
  "summary" : "silverstripe/framework has potential SQL Injection vulnerability in PostgreSQL database connector",
  "details" : "A potential SQL injection vulnerability was identified by using the silverstripe/postgresql database adapter. While unlikely to be exploitable, we have patched silverstripe/framework to ensure that table names are safely escaped before being passed to database adapters or user code.",
  "severity" : [ {
    "type" : "CVSS_V3",
    "score" : "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H"
  } ],
  "affected" : [ {
    "package" : {
      "ecosystem" : "Packagist",
      "name" : "silverstripe/framework"
    },
    "ranges" : [ {
      "type" : "ECOSYSTEM",
      "events" : [ {
        "introduced" : "4.0.0-rc1"
      }, {
        "fixed" : "4.0.6"
      } ]
    } ]
  }, {
    "package" : {
      "ecosystem" : "Packagist",
      "name" : "silverstripe/framework"
    },
    "ranges" : [ {
      "type" : "ECOSYSTEM",
      "events" : [ {
        "introduced" : "4.1.0-rc1"
      }, {
        "fixed" : "4.1.4"
      } ]
    } ]
  }, {
    "package" : {
      "ecosystem" : "Packagist",
      "name" : "silverstripe/framework"
    },
    "ranges" : [ {
      "type" : "ECOSYSTEM",
      "events" : [ {
        "introduced" : "4.2.0-rc1"
      }, {
        "fixed" : "4.2.3"
      } ]
    } ]
  } ],
  "references" : [ {
    "type" : "WEB",
    "url" : "https://github.com/silverstripe/silverstripe-framework/commit/48bd335648188df9dae72be1e5f9c808f3fe1e77"
  }, {
    "type" : "WEB",
    "url" : "https://github.com/silverstripe/silverstripe-framework/commit/fecedc2d98eeaaff6424fb59dc70ef6bdc6dc92d"
  }, {
    "type" : "WEB",
    "url" : "https://github.com/FriendsOfPHP/security-advisories/blob/master/silverstripe/framework/SS-2018-020-1.yaml"
  }, {
    "type" : "PACKAGE",
    "url" : "https://github.com/silverstripe/silverstripe-framework"
  }, {
    "type" : "WEB",
    "url" : "https://www.silverstripe.org/download/security-releases/ss-2018-020"
  } ],
  "database_specific" : {
    "cwe_ids" : [ "CWE-89" ],
    "severity" : "HIGH",
    "github_reviewed" : true,
    "github_reviewed_at" : "2024-05-28T13:01:48Z",
    "nvd_published_at" : null
  }
}