CVE-2024-27304: Github.com/jackc/pgx SQL Injection Vulnerability
HIGHCVE-2024-27304 is a HIGH (CVSS 9.8) sql injection vulnerability (CWE-190: Integer Overflow or Wraparound) affecting Github.com/jackc/pgx libraries in the Go ecosystem. The issue involves pgx sql injection via protocol message size overflow. Remediation is available by upgrading affected packages to version 4.18.2, 5.5.4.
CVE-2024-27304 at a Glance
Security Impact
CVSS: 9.8
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:U/C:H/I:H/A:H).
How to Fix CVE-2024-27304
To remediate this vulnerability, upgrade all affected Github.com/jackc/pgx dependencies to a patched release. Both direct and transitive dependencies should be checked, as frameworks or security libraries may pull in vulnerable versions transitively.
Upgrade github.com/jackc/pgx to 4.18.2Upgrade github.com/jackc/pgx to 5.5.4Upgrade github.com/jackc/pgx/v4 to 4.18.2Upgrade github.com/jackc/pgx/v5 to 5.5.4Run the following command in your project directory to verify that all resolved dependencies use the patched release:
inspect dependencies for github.com/jackc/pgxHow to Check if You Are Affected
To determine whether your application is affected by CVE-2024-27304, inspect your project dependencies for Github.com/jackc/pgx:
inspect dependencies for github.com/jackc/pgxAnalyze the terminal output to locate any version of Github.com/jackc/pgx in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 4.18.2), 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-190: Integer Overflow or Wraparound, where the product performs a calculation that can produce an integer overflow or wraparound when the logic assumes that the resulting value will always be larger than the original value. this occurs when an integer value is incremented to a value that is too large to store in the associated representation. when this occurs, the value may become a very small or negative number. In Github.com/jackc/pgx, 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-2024-27304 Affected Github.com/jackc/pgx Versions
4 component(s)| Product / Package | Ecosystem | Affected Versions | Fixed Version |
|---|---|---|---|
|
github.com/jackc/pgx
|
Go |
< 4.18.2
|
4.18.2
|
|
github.com/jackc/pgx
|
Go |
≥ 5.0.0
< 5.5.4
|
5.5.4
|
|
github.com/jackc/pgx/v4
|
Go |
< 4.18.2
|
4.18.2
|
|
github.com/jackc/pgx/v5
|
Go |
≥ 5.0.0
< 5.5.4
|
5.5.4
|
References
Frequently Asked Questions
What is CVE-2024-27304?
Which Github.com/jackc/pgx versions are affected?
What version fixes CVE-2024-27304?
Is github.com/jackc/pgx affected?
Is github.com/jackc/pgx/v4 affected?
What is the CVSS score of CVE-2024-27304?
What CWE is associated with CVE-2024-27304?
How can I check Go dependencies for CVE-2024-27304?
Machine-readable OSV JSON
OSV v1.5 Schema
{
"schema_version" : "1.4.0",
"id" : "GHSA-mrww-27vc-gghv",
"modified" : "2024-12-12T22:30:36Z",
"published" : "2024-03-04T20:43:24Z",
"aliases" : [ "CVE-2024-27304" ],
"summary" : "pgx SQL Injection via Protocol Message Size Overflow",
"details" : "### Impact\n\nSQL injection can occur if an attacker can cause a single query or bind message to exceed 4 GB in size. An integer overflow in the calculated message size can cause the one large message to be sent as multiple messages under the attacker's control.\n\n### Patches\n\nThe problem is resolved in v4.18.2 and v5.5.4.\n\n### Workarounds\n\nReject user input large enough to cause a single query or bind message to exceed 4 GB in size.\n",
"severity" : [ {
"type" : "CVSS_V3",
"score" : "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"
}, {
"type" : "CVSS_V4",
"score" : "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N/E:U"
} ],
"affected" : [ {
"package" : {
"ecosystem" : "Go",
"name" : "github.com/jackc/pgx"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "4.18.2"
} ]
} ]
}, {
"package" : {
"ecosystem" : "Go",
"name" : "github.com/jackc/pgx"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "5.0.0"
}, {
"fixed" : "5.5.4"
} ]
} ]
}, {
"package" : {
"ecosystem" : "Go",
"name" : "github.com/jackc/pgx/v4"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "4.18.2"
} ]
} ]
}, {
"package" : {
"ecosystem" : "Go",
"name" : "github.com/jackc/pgx/v5"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "5.0.0"
}, {
"fixed" : "5.5.4"
} ]
} ]
} ],
"references" : [ {
"type" : "WEB",
"url" : "https://github.com/jackc/pgproto3/security/advisories/GHSA-7jwh-3vrq-q3m8"
}, {
"type" : "WEB",
"url" : "https://github.com/jackc/pgx/security/advisories/GHSA-mrww-27vc-gghv"
}, {
"type" : "ADVISORY",
"url" : "https://nvd.nist.gov/vuln/detail/CVE-2024-27304"
}, {
"type" : "WEB",
"url" : "https://github.com/jackc/pgproto3/commit/945c2126f6db8f3bea7eeebe307c01fe92bca007"
}, {
"type" : "WEB",
"url" : "https://github.com/jackc/pgx/commit/adbb38f298c76e283ffc7c7a3f571036fea47fd4"
}, {
"type" : "WEB",
"url" : "https://github.com/jackc/pgx/commit/c543134753a0c5d22881c12404025724cb05ffd8"
}, {
"type" : "WEB",
"url" : "https://github.com/jackc/pgx/commit/f94eb0e2f96782042c96801b5ac448f44f0a81df"
}, {
"type" : "PACKAGE",
"url" : "https://github.com/jackc/pgx"
}, {
"type" : "WEB",
"url" : "https://www.youtube.com/watch?v=Tfg1B8u1yvE"
} ],
"database_specific" : {
"cwe_ids" : [ "CWE-190", "CWE-89" ],
"severity" : "HIGH",
"github_reviewed" : true,
"github_reviewed_at" : "2024-03-04T20:43:24Z",
"nvd_published_at" : "2024-03-06T19:15:08Z"
}
}