CVE-2023-22578: @sequelize/core Sequelize - Default Support For Vulnerability
CRITICALCVE-2023-22578 is a CRITICAL (CVSS 10.0) sequelize - default support for vulnerability (CWE-790: Improper Filtering of Special Elements) affecting @sequelize/core libraries in the npm ecosystem. The issue involves sequelize - default support for “raw attributes” when using parentheses. Remediation is available by upgrading affected packages to version 7.0.0-alpha.20, 6.29.0.
CVE-2023-22578 at a Glance
Security Impact
CVSS: 10.0
The security impact metrics below are parsed directly from the CVSS v3.1 vector string (CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H).
How to Fix CVE-2023-22578
To remediate this vulnerability, upgrade all affected @sequelize/core dependencies to a patched release. Both direct and transitive dependencies should be checked, as frameworks or security libraries may pull in vulnerable versions transitively.
npm install @sequelize/core@7.0.0-alpha.20npm install sequelize@6.29.0Run the following command in your project directory to verify that all resolved dependencies use the patched release:
npm ls @sequelize/coreHow to Check if You Are Affected
To determine whether your Node.js application is affected by CVE-2023-22578, inspect your project dependencies using npm:
npm ls @sequelize/coreAnalyze the terminal output to locate any version of @sequelize/core in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 7.0.0-alpha.20), your application is affected.
Note: The npm ls @sequelize/core command inspects dependencies declared in your package.json and lockfile; it does not perform automated runtime dynamic scanning.
Technical Details
Vulnerability Mechanism & Technical Analysis
This vulnerability is classified under CWE-790: Improper Filtering of Special Elements, where the product receives data from an upstream component, but does not filter or incorrectly filters special elements before sending it to a downstream component. In @sequelize/core, 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
CVE-2023-22578 Affected @sequelize/core Versions
2 component(s)| Product / Package | Ecosystem | Affected Versions | Fixed Version |
|---|---|---|---|
|
@sequelize/core
|
npm |
< 7.0.0-alpha.20
|
7.0.0-alpha.20
|
|
sequelize
|
npm |
< 6.29.0
|
6.29.0
|
References
Frequently Asked Questions
What is CVE-2023-22578?
Which @sequelize/core versions are affected?
What version fixes CVE-2023-22578?
Is @sequelize/core affected?
Is sequelize affected?
What is the CVSS score of CVE-2023-22578?
What CWE is associated with CVE-2023-22578?
How can I check npm dependencies for CVE-2023-22578?
Machine-readable OSV JSON
OSV v1.5 Schema
{
"schema_version" : "1.4.0",
"id" : "GHSA-f598-mfpv-gmfx",
"modified" : "2023-02-24T18:48:49Z",
"published" : "2023-02-24T18:48:49Z",
"aliases" : [ "CVE-2023-22578" ],
"summary" : "Sequelize - Default support for “raw attributes” when using parentheses",
"details" : "### Impact\n\nSequelize 6.28.2 and prior has a dangerous feature where using parentheses in the attribute option would make Sequelize use the string as-is in the SQL\n\n```ts\nUser.findAll({\n attributes: [\n ['count(id)', 'count']\n ]\n});\n```\n\nProduced\n\n```sql\nSELECT count(id) AS \"count\" FROM \"users\"\n```\n\n### Patches\n\nThis feature was deprecated in Sequelize 5, and using it prints a deprecation warning.\n\nThis issue has been patched in [`@sequelize/core@7.0.0.alpha-20`](https://github.com/sequelize/sequelize/pull/15374) and [`sequelize@6.29.0`](https://github.com/sequelize/sequelize/pull/15710). \n\nIn Sequelize 7, it now produces the following:\n\n```sql\nSELECT \"count(id)\" AS \"count\" FROM \"users\"\n```\n\nIn Sequelize 6, it throws an error explaining that we had to introduce a breaking change, and requires the user to explicitly opt-in to either the Sequelize 7 behavior (always escape) or the Sequelize 5 behavior (inline attributes that include `()` without escaping). See https://github.com/sequelize/sequelize/pull/15710 for more information.\n\n### Mitigations\n\nDo not use user-provided content to build your list or attributes. If you do, make sure that attribute in question actually exists on your model by checking that it exists in the `rawAttributes` property of your model first.\n\n---\n\nA discussion thread about this issue is open at https://github.com/sequelize/sequelize/discussions/15694\nCVE: CVE-2023-22578",
"severity" : [ {
"type" : "CVSS_V3",
"score" : "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H"
} ],
"affected" : [ {
"package" : {
"ecosystem" : "npm",
"name" : "@sequelize/core"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "7.0.0-alpha.20"
} ]
} ]
}, {
"package" : {
"ecosystem" : "npm",
"name" : "sequelize"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "6.29.0"
} ]
} ]
} ],
"references" : [ {
"type" : "WEB",
"url" : "https://github.com/sequelize/sequelize/security/advisories/GHSA-f598-mfpv-gmfx"
}, {
"type" : "ADVISORY",
"url" : "https://nvd.nist.gov/vuln/detail/CVE-2023-22578"
}, {
"type" : "WEB",
"url" : "https://github.com/sequelize/sequelize/pull/15710"
}, {
"type" : "WEB",
"url" : "https://csirt.divd.nl/CVE-2023-22578"
}, {
"type" : "WEB",
"url" : "https://csirt.divd.nl/DIVD-2022-00020"
}, {
"type" : "PACKAGE",
"url" : "https://github.com/sequelize/sequelize"
}, {
"type" : "WEB",
"url" : "https://github.com/sequelize/sequelize/discussions/15694"
}, {
"type" : "WEB",
"url" : "https://github.com/sequelize/sequelize/releases/tag/v6.29.0"
}, {
"type" : "WEB",
"url" : "https://github.com/sequelize/sequelize/releases/tag/v7.0.0-alpha.20"
} ],
"database_specific" : {
"cwe_ids" : [ "CWE-790" ],
"severity" : "CRITICAL",
"github_reviewed" : true,
"github_reviewed_at" : "2023-02-24T18:48:49Z",
"nvd_published_at" : null
}
}