SQL injection in ext-pgsql via E'...' backslash breakout

Affected versions

NVD version ranges (for catalog products). Add the product to your stack with a version and matching uses these.

• php php8.2.0 and later · before 8.2.33
• php php8.3.0 and later · before 8.3.33
• php php8.4.0 and later · before 8.4.24
• php php8.5.0 and later · before 8.5.9

Versions reported by the vendor

Affected version ranges reported by the assigning authority (php). Independent of NVD's CPE analysis and usually ahead of it.

• PHP Group PHP

  • 8.2.* and later · before 8.2.33affected · semver
  • 8.3.* and later · before 8.3.33affected · semver
  • 8.4.* and later · before 8.4.24affected · semver
  • 8.5.* and later · before 8.5.9affected · semver

Package-level exposure

OSV and GitHub Advisory data: ecosystem, package and range. SBOM matching uses this table.

Other highest-scoring records for the same primary product.

• CVE-2024-4577Argument Injection in PHP-CGIKEV
  99Now
• CVE-2019-11043Underflow in PHP-FPM can lead to RCEKEV
  99Now
• CVE-2012-1823sapi/cgi/cgi_main.c in PHP before 5.3.12 and 5.4.x before 5.4.2, when configured as a CGI script (aka php-cgi), does not properly handle queKEV
  99Now
• CVE-2018-7584In PHP through 5.6.33, 7.0.x before 7.0.28, 7.1.x through 7.1.14, and 7.2.x through 7.2.2, there is a stack-based buffer under-read while pa
  65This week
• CVE-2018-19518University of Washington IMAP Toolkit 2007f on UNIX, as used in imap_open() in PHP and other products, launches an rsh command (by means of
  59Plan
• CVE-2016-3078Multiple integer overflows in php_zip.c in the zip extension in PHP before 7.0.6 allow remote attackers to cause a denial of service (heap-b
  56Plan

FIRST EPSS daily score; only changes of 0.01 or more are recorded (step chart).

Root cause

The query text is built by concatenating user input. The database cannot tell where the data ends and the command begins.

A representative example of this vulnerability class. Not the vendor's source code; it shows the faulty pattern and its fix.

1const owner = req.query.owner;2const rows = await db.query(3  "SELECT * FROM files WHERE owner = '" + owner + "'"4);

1const owner = req.query.owner;2const rows = await db.query(3  "SELECT * FROM files WHERE owner = $1",4  [owner]5);

Attack context

MITRE CAPEC attack patterns and ATT&CK techniques for this weakness class (CWE). A starting point for detection rules and threat hunting.