Vulnerability advisory
CVE-2024-27289
pgx SQL Injection via Line Comment Creation
Also known as GHSA-m7wr-2xf7-cm9pGO-2024-2605
Severity
- CVSS 3.x
CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H
Affected versions
Repository
| Affected commits | Fixed by commit |
|---|---|
| GIT github.com/jackc/pgx ↗ | |
| All commits before 14690df4c533758df97f7cc561cb9062155045c6 | 14690df4c533758df97f7cc561cb9062155045c6 |
| Not specified | f94eb0e2f96782042c96801b5ac448f44f0a81df |
Also listed as affected (57)
| |
Description
pgx is a PostgreSQL driver and toolkit for Go. Prior to version 4.18.2, SQL injection can occur when all of the following conditions are met: the non-default simple protocol is used; a placeholder for a numeric value must be immediately preceded by a minus; there must be a second placeholder for a string value after the first placeholder; both must be on the same line; and both parameter values must be user-controlled. The problem is resolved in v4.18.2. As a workaround, do not use the simple protocol or do not place a minus directly before a placeholder.
References
- Advisorygithub.com/CVEProject/cvelistV5/tree/main/cves/2024/27xxx/CVE-2024-27289.json ↗
- Advisorygithub.com/jackc/pgx/security/advisories/GHSA-m7wr-2xf7-cm9p ↗
- Advisorynvd.nist.gov/vuln/detail/CVE-2024-27289 ↗
- Fixgithub.com/jackc/pgx/commit/f94eb0e2f96782042c96801b5ac448f44f0a81df ↗
- ARTICLEwww.sonarsource.com/blog/double-dash-double-trouble-a-subtle-sql-injection-flaw/ ↗