CVE-2023-30545: Prestashop/prestashop SQL Injection Vulnerability

HIGH
Advisory Identifier: GHSA-8r4m-5p6p-52rp
Share
CVSS 7.7
CWE-89
Published
Advisory Summary

CVE-2023-30545 is a HIGH (CVSS 7.7) sql injection vulnerability (CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')) affecting Prestashop/prestashop libraries in the Packagist ecosystem. The issue involves arbitrary file read via sql injection. Remediation is available by upgrading affected packages to version 8.0.4, 1.7.8.9.

CVE-2023-30545 at a Glance

CVE Identifier CVE-2023-30545
GHSA Identifier GHSA-8r4m-5p6p-52rp
Severity HIGH
CVSS v3.1 Base Score 7.7
CWE Classification CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
Affected Product Prestashop/prestashop
Package Ecosystem Packagist
Published Date
Last Updated

Security Impact

CVSS: 7.7

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:C/C:H/I:N/A:N).

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

How to Fix CVE-2023-30545

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

prestashop/prestashop fixed: 8.0.4 
Upgrade prestashop/prestashop to 8.0.4
prestashop/prestashop fixed: 1.7.8.9 
Upgrade prestashop/prestashop to 1.7.8.9
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 prestashop/prestashop

How to Check if You Are Affected

To determine whether your application is affected by CVE-2023-30545, inspect your project dependencies for Prestashop/prestashop:

inspect dependencies for prestashop/prestashop

Analyze the terminal output to locate any version of Prestashop/prestashop in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 8.0.4), 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 Prestashop/prestashop, 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

### Impact It is possible for a user having access to the SQL Manager (Advanced Options -> Database) to arbitrary read any file on the Operating system when using SQL function LOAD_FILE in a SELECT request. So It can access to critical information. ### Patches The patch will be on PS 8.0.4 and PS 1.7.8.9

CVE-2023-30545 Affected Prestashop/prestashop Versions

2 component(s)
Fixed Versions:
8.0.41.7.8.9
Product / Package Ecosystem Affected Versions Fixed Version
prestashop/prestashop
 Packagist
≥ 8.0.0
< 8.0.4
8.0.4
prestashop/prestashop
 Packagist
< 1.7.8.9
1.7.8.9

References

GitHub Advisory / Wiki ADVISORY
https://github.com/PrestaShop/PrestaShop/security/advisories/GHSA-8r4m-5p6p-52rp
NVD — CVE-2023-30545 NVD
https://nvd.nist.gov/vuln/detail/CVE-2023-30545
Security Fix Commit FIX COMMIT
https://github.com/PrestaShop/PrestaShop/commit/cddac4198a47c602878a787280d813f60c6c0630
Security Fix Commit FIX COMMIT
https://github.com/PrestaShop/PrestaShop/commit/d900806e1841a31f26ff0a1843a6888fc1bb7f81
Prestashop/prestashop Source Repository REPOSITORY
https://github.com/PrestaShop/PrestaShop

Frequently Asked Questions

What is CVE-2023-30545?
CVE-2023-30545 is a security vulnerability in Prestashop/prestashop involving Arbitrary file read via SQL injection under CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection').
Which Prestashop/prestashop versions are affected?
Affected versions include releases prior to 8.0.4, 1.7.8.9 across affected packages: prestashop/prestashop.
What version fixes CVE-2023-30545?
Upgrading to 8.0.4, 1.7.8.9 (or the latest patched release for your respective branch) resolves the vulnerability.
Is prestashop/prestashop affected?
Yes, prestashop/prestashop is affected in releases prior to 8.0.4, 1.7.8.9. Upgrade your dependency to 8.0.4, 1.7.8.9 or later.
What is the CVSS score of CVE-2023-30545?
CVE-2023-30545 has a CVSS v3.1 base score of 7.7 (HIGH) with vector string CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:N/A:N.
What CWE is associated with CVE-2023-30545?
CVE-2023-30545 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 CVE-2023-30545?
Run the dependency tree command: 'inspect dependencies for prestashop/prestashop'. 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
View Raw JSON 
{
  "schema_version" : "1.4.0",
  "id" : "GHSA-8r4m-5p6p-52rp",
  "modified" : "2023-04-26T16:03:45Z",
  "published" : "2023-04-26T16:03:45Z",
  "aliases" : [ "CVE-2023-30545" ],
  "summary" : "Arbitrary file read via SQL injection",
  "details" : "### Impact\nIt is possible for a user having access to the SQL Manager (Advanced Options -> Database) to arbitrary read any file on the Operating system when using SQL function LOAD_FILE in a SELECT request. So It can access to critical information.\n\n### Patches\nThe patch will be on PS 8.0.4 and PS 1.7.8.9\n",
  "severity" : [ {
    "type" : "CVSS_V3",
    "score" : "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:N/A:N"
  } ],
  "affected" : [ {
    "package" : {
      "ecosystem" : "Packagist",
      "name" : "prestashop/prestashop"
    },
    "ranges" : [ {
      "type" : "ECOSYSTEM",
      "events" : [ {
        "introduced" : "8.0.0"
      }, {
        "fixed" : "8.0.4"
      } ]
    } ]
  }, {
    "package" : {
      "ecosystem" : "Packagist",
      "name" : "prestashop/prestashop"
    },
    "ranges" : [ {
      "type" : "ECOSYSTEM",
      "events" : [ {
        "introduced" : "0"
      }, {
        "fixed" : "1.7.8.9"
      } ]
    } ]
  } ],
  "references" : [ {
    "type" : "WEB",
    "url" : "https://github.com/PrestaShop/PrestaShop/security/advisories/GHSA-8r4m-5p6p-52rp"
  }, {
    "type" : "ADVISORY",
    "url" : "https://nvd.nist.gov/vuln/detail/CVE-2023-30545"
  }, {
    "type" : "WEB",
    "url" : "https://github.com/PrestaShop/PrestaShop/commit/cddac4198a47c602878a787280d813f60c6c0630"
  }, {
    "type" : "WEB",
    "url" : "https://github.com/PrestaShop/PrestaShop/commit/d900806e1841a31f26ff0a1843a6888fc1bb7f81"
  }, {
    "type" : "PACKAGE",
    "url" : "https://github.com/PrestaShop/PrestaShop"
  } ],
  "database_specific" : {
    "cwe_ids" : [ "CWE-89" ],
    "severity" : "HIGH",
    "github_reviewed" : true,
    "github_reviewed_at" : "2023-04-26T16:03:45Z",
    "nvd_published_at" : "2023-04-25T18:15:09Z"
  }
}