GHSA-7jwh-3vrq-q3m8: Github.com/jackc/pgproto3 SQL Injection Vulnerability
HIGHGHSA-7jwh-3vrq-q3m8 is a HIGH (CVSS 9.8) sql injection vulnerability (CWE-190: Integer Overflow or Wraparound) affecting Github.com/jackc/pgproto3 libraries in the Go ecosystem. The issue involves pgproto3 sql injection via protocol message size overflow. Remediation is available by upgrading affected packages to version 2.3.3.
GHSA-7jwh-3vrq-q3m8 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 GHSA-7jwh-3vrq-q3m8
To remediate this vulnerability, upgrade all affected Github.com/jackc/pgproto3 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/pgproto3 to 2.3.3Upgrade github.com/jackc/pgproto3/v2 to 2.3.3Run the following command in your project directory to verify that all resolved dependencies use the patched release:
inspect dependencies for github.com/jackc/pgproto3How to Check if You Are Affected
To determine whether your application is affected by GHSA-7jwh-3vrq-q3m8, inspect your project dependencies for Github.com/jackc/pgproto3:
inspect dependencies for github.com/jackc/pgproto3Analyze the terminal output to locate any version of Github.com/jackc/pgproto3 in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 2.3.3), 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/pgproto3, 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
GHSA-7jwh-3vrq-q3m8 Affected Github.com/jackc/pgproto3 Versions
2 component(s)| Product / Package | Ecosystem | Affected Versions | Fixed Version |
|---|---|---|---|
|
github.com/jackc/pgproto3
|
Go |
< 2.3.3
|
2.3.3
|
|
github.com/jackc/pgproto3/v2
|
Go |
< 2.3.3
|
2.3.3
|
References
Frequently Asked Questions
What is GHSA-7jwh-3vrq-q3m8?
Which Github.com/jackc/pgproto3 versions are affected?
What version fixes GHSA-7jwh-3vrq-q3m8?
Is github.com/jackc/pgproto3 affected?
Is github.com/jackc/pgproto3/v2 affected?
What is the CVSS score of GHSA-7jwh-3vrq-q3m8?
What CWE is associated with GHSA-7jwh-3vrq-q3m8?
How can I check Go dependencies for GHSA-7jwh-3vrq-q3m8?
Machine-readable OSV JSON
OSV v1.5 Schema
{
"schema_version" : "1.4.0",
"id" : "GHSA-7jwh-3vrq-q3m8",
"modified" : "2024-09-13T15:36:58Z",
"published" : "2024-03-04T20:45:25Z",
"aliases" : [ ],
"summary" : "pgproto3 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 v2.3.3\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/pgproto3"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "2.3.3"
} ]
} ]
}, {
"package" : {
"ecosystem" : "Go",
"name" : "github.com/jackc/pgproto3/v2"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "2.3.3"
} ]
} ]
} ],
"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/pgproto3"
} ],
"database_specific" : {
"cwe_ids" : [ "CWE-190", "CWE-89" ],
"severity" : "HIGH",
"github_reviewed" : true,
"github_reviewed_at" : "2024-03-04T20:45:25Z",
"nvd_published_at" : null
}
}