Skip to content
OpenAdvisories
High · 8.8 CVE-2023-22794 EUVD-2023-0490GHSA-hq7p-j377-6v63

SQL Injection Vulnerability via ActiveRecord comments

Published Feb 9, 2023 · Updated Aug 2, 2024 · Assigned by hackerone

Description

A vulnerability in ActiveRecord <6.0.6.1, v6.1.7.1 and v7.0.4.1 related to the sanitization of comments. If malicious user input is passed to either the `annotate` query method, the `optimizer_hints` query method, or through the QueryLogs interface which automatically adds annotations, it may be sent to the database withinsufficient sanitization and be able to inject SQL outside of the comment.

Affected products

VendorProductAffectedFixed
— https://github.com/rails/rails 6.0.6.1, 6.1.7.1, 7.0.4.1 —

Fixed in Linux distributions

Distributions backport fixes, so the version that fixes this vulnerability differs per release — upgrade to at least the version shown. From the distributions' security trackers and advisories.

ReleasePackageFixed inAdvisory
Debian 14 rails 2:6.1.7.3+dfsg-1 —
Debian 13 rails 2:6.1.7.3+dfsg-1 —
Debian 12 rails 2:6.1.7.3+dfsg-1 —
Debian 11 rails 2:6.0.3.7+dfsg-2+deb11u1 DSA-5372-1
ReleasePackageFixed inAdvisory
Ubuntu 26.10 rails No fix yet —
Ubuntu 26.04 LTS rails No fix yet —
Ubuntu 25.10 rails No fix yet —
Ubuntu 24.04 LTS rails No fix yet —
Show 4 more (older releases, extended support, other products)
ReleasePackageFixed inAdvisory
Ubuntu Pro 22.04 LTS rails No fix yet —
Ubuntu Pro 20.04 LTS rails No fix yet —
Ubuntu Pro 18.04 LTS rails No fix yet —
Ubuntu Pro 16.04 LTS rails No fix yet —
ReleasePackageFixed inAdvisory
Red Hat Satellite Utils 6 foreman +1 3.7.0.9-1.el8sat RHSA-2023:6818
Red Hat Satellite Capsule 6 foreman +1 3.7.0.9-1.el8sat RHSA-2023:6818
Red Hat Satellite Capsule 6 puppet-agent 7.26.0-3.el8sat RHSA-2023:6818
Red Hat Satellite Capsule 6 puppetserver 7.11.0-1.el8sat RHSA-2023:6818
Red Hat Satellite Capsule 6 python-django +1 3.2.21-1.el8pc RHSA-2023:6818
Red Hat Satellite Capsule 6 python-future +1 0.18.3-1.el8pc RHSA-2023:6818
Red Hat Satellite Capsule 6 python-gitpython +1 3.1.32-1.el8pc RHSA-2023:6818
Red Hat Satellite Capsule 6 python-pulp-ansible +1 1:0.16.0-1.el8pc RHSA-2023:6818
Red Hat Satellite Capsule 6 python-requests +1 2.31.0-1.el8pc RHSA-2023:6818
Red Hat Satellite Capsule 6 python-sqlparse +1 0.4.4-1.el8pc RHSA-2023:6818
Red Hat Satellite Capsule 6 rubygem-rack 2.2.7-1.el8sat RHSA-2023:6818
Red Hat Satellite 6 foreman +13 3.7.0.9-1.el8sat RHSA-2023:6818
Red Hat Satellite 6 puppet-agent 7.26.0-3.el8sat RHSA-2023:6818
Red Hat Satellite 6 puppetserver 7.11.0-1.el8sat RHSA-2023:6818
Red Hat Satellite 6 python-django +1 3.2.21-1.el8pc RHSA-2023:6818
Red Hat Satellite 6 python-future +1 0.18.3-1.el8pc RHSA-2023:6818
Red Hat Satellite 6 python-gitpython +1 3.1.32-1.el8pc RHSA-2023:6818
Red Hat Satellite 6 python-pulp-ansible +1 1:0.16.0-1.el8pc RHSA-2023:6818
Red Hat Satellite 6 python-requests +1 2.31.0-1.el8pc RHSA-2023:6818
Red Hat Satellite 6 python-sqlparse +1 0.4.4-1.el8pc RHSA-2023:6818
Red Hat Satellite 6 rubygem-actionpack +2 6.1.7.3-1.el8sat RHSA-2023:6818
Red Hat Satellite 6 rubygem-git 1.18.0-1.el8sat RHSA-2023:6818
Red Hat Satellite 6 rubygem-globalid 1.1.0-1.el8sat RHSA-2023:6818
Red Hat Satellite 6 rubygem-kubeclient 4.10.1-1.el8sat RHSA-2023:6818
Red Hat Satellite 6 rubygem-rack 2.2.7-1.el8sat RHSA-2023:6818
Red Hat Satellite 6 yggdrasil-worker-forwarder 0.0.3-1.el8sat RHSA-2023:6818
ReleasePackageFixed inAdvisory
openSUSE Tumbleweed rubygem-activerecord-7.0 7.0.4.1-1.1 openSUSE-SU-2025:15112-1, openSUSE-SU-2024:14069-1, openSUSE-SU-2024:12766-1

Affected packages

EcosystemPackageAffectedFixedRecord
RubyGems activerecord >= 6.0.0, < 6.0.6.1 6.0.6.1 GHSA-hq7p-j377-6v63
RubyGems activerecord >= 6.1.0, < 6.1.7.1 6.1.7.1 GHSA-hq7p-j377-6v63
RubyGems activerecord >= 7.0.0, < 7.0.4.1 7.0.4.1 GHSA-hq7p-j377-6v63

Advisories 7

References