ubuntu-cve-2023-22794
Vulnerability from osv_ubuntu
Published
2023-02-09 20:15
Modified
2026-05-20 15:02
Summary
Details
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.
Severity
8.8 (High)
N/A (UNKNOWN)
References
{
"affected": [
{
"ecosystem_specific": {
"binaries": [
{
"binary_name": "rails",
"binary_version": "2:4.2.6-1ubuntu0.1~esm2"
},
{
"binary_name": "ruby-actionmailer",
"binary_version": "2:4.2.6-1ubuntu0.1~esm2"
},
{
"binary_name": "ruby-actionpack",
"binary_version": "2:4.2.6-1ubuntu0.1~esm2"
},
{
"binary_name": "ruby-actionview",
"binary_version": "2:4.2.6-1ubuntu0.1~esm2"
},
{
"binary_name": "ruby-activejob",
"binary_version": "2:4.2.6-1ubuntu0.1~esm2"
},
{
"binary_name": "ruby-activemodel",
"binary_version": "2:4.2.6-1ubuntu0.1~esm2"
},
{
"binary_name": "ruby-activerecord",
"binary_version": "2:4.2.6-1ubuntu0.1~esm2"
},
{
"binary_name": "ruby-activesupport",
"binary_version": "2:4.2.6-1ubuntu0.1~esm2"
},
{
"binary_name": "ruby-rails",
"binary_version": "2:4.2.6-1ubuntu0.1~esm2"
},
{
"binary_name": "ruby-railties",
"binary_version": "2:4.2.6-1ubuntu0.1~esm2"
}
]
},
"package": {
"ecosystem": "Ubuntu:Pro:16.04:LTS",
"name": "rails",
"purl": "pkg:deb/ubuntu/rails@2:4.2.6-1ubuntu0.1~esm2?arch=source\u0026distro=esm-apps/xenial"
},
"ranges": [
{
"events": [
{
"introduced": "0"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"2:4.1.10-1",
"2:4.2.5-1",
"2:4.2.5.1-1",
"2:4.2.5.2-2",
"2:4.2.6-1",
"2:4.2.6-1ubuntu0.1~esm1",
"2:4.2.6-1ubuntu0.1~esm2"
]
},
{
"ecosystem_specific": {
"binaries": [
{
"binary_name": "rails",
"binary_version": "2:4.2.10-0ubuntu4+esm2"
},
{
"binary_name": "ruby-actionmailer",
"binary_version": "2:4.2.10-0ubuntu4+esm2"
},
{
"binary_name": "ruby-actionpack",
"binary_version": "2:4.2.10-0ubuntu4+esm2"
},
{
"binary_name": "ruby-actionview",
"binary_version": "2:4.2.10-0ubuntu4+esm2"
},
{
"binary_name": "ruby-activejob",
"binary_version": "2:4.2.10-0ubuntu4+esm2"
},
{
"binary_name": "ruby-activemodel",
"binary_version": "2:4.2.10-0ubuntu4+esm2"
},
{
"binary_name": "ruby-activerecord",
"binary_version": "2:4.2.10-0ubuntu4+esm2"
},
{
"binary_name": "ruby-activesupport",
"binary_version": "2:4.2.10-0ubuntu4+esm2"
},
{
"binary_name": "ruby-rails",
"binary_version": "2:4.2.10-0ubuntu4+esm2"
},
{
"binary_name": "ruby-railties",
"binary_version": "2:4.2.10-0ubuntu4+esm2"
}
]
},
"package": {
"ecosystem": "Ubuntu:Pro:18.04:LTS",
"name": "rails",
"purl": "pkg:deb/ubuntu/rails@2:4.2.10-0ubuntu4+esm2?arch=source\u0026distro=esm-apps/bionic"
},
"ranges": [
{
"events": [
{
"introduced": "0"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"2:4.2.9-2",
"2:4.2.9-4",
"2:4.2.10-0ubuntu4",
"2:4.2.10-0ubuntu4+esm1",
"2:4.2.10-0ubuntu4+esm2"
]
},
{
"ecosystem_specific": {
"binaries": [
{
"binary_name": "rails",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-actioncable",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-actionmailer",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-actionpack",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-actionview",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-activejob",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-activemodel",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-activerecord",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-activestorage",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-activesupport",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-rails",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
},
{
"binary_name": "ruby-railties",
"binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1"
}
]
},
"package": {
"ecosystem": "Ubuntu:Pro:20.04:LTS",
"name": "rails",
"purl": "pkg:deb/ubuntu/rails@2:5.2.3+dfsg-3ubuntu0.1~esm1?arch=source\u0026distro=esm-apps/focal"
},
"ranges": [
{
"events": [
{
"introduced": "0"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"2:5.2.2.1+dfsg-1ubuntu1",
"2:5.2.3+dfsg-3",
"2:5.2.3+dfsg-3ubuntu0.1~esm1"
]
},
{
"ecosystem_specific": {
"binaries": [
{
"binary_name": "rails",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-actioncable",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-actionmailbox",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-actionmailer",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-actionpack",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-actiontext",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-actionview",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-activejob",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-activemodel",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-activerecord",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-activestorage",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-activesupport",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-rails",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
},
{
"binary_name": "ruby-railties",
"binary_version": "2:6.1.4.1+dfsg-8ubuntu2+esm1"
}
]
},
"package": {
"ecosystem": "Ubuntu:Pro:22.04:LTS",
"name": "rails",
"purl": "pkg:deb/ubuntu/rails@2:6.1.4.1+dfsg-8ubuntu2+esm1?arch=source\u0026distro=esm-apps/jammy"
},
"ranges": [
{
"events": [
{
"introduced": "0"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"2:6.0.3.7+dfsg-2",
"2:6.1.4.1+dfsg-8ubuntu2",
"2:6.1.4.1+dfsg-8ubuntu2+esm1"
]
},
{
"ecosystem_specific": {
"binaries": [
{
"binary_name": "rails",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-actioncable",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-actionmailbox",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-actionmailer",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-actionpack",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-actiontext",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-actionview",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-activejob",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-activemodel",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-activerecord",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-activestorage",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-activesupport",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-rails",
"binary_version": "2:6.1.7.3+dfsg-3"
},
{
"binary_name": "ruby-railties",
"binary_version": "2:6.1.7.3+dfsg-3"
}
]
},
"package": {
"ecosystem": "Ubuntu:24.04:LTS",
"name": "rails",
"purl": "pkg:deb/ubuntu/rails@2:6.1.7.3+dfsg-3?arch=source\u0026distro=noble"
},
"ranges": [
{
"events": [
{
"introduced": "0"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"2:6.1.7.3+dfsg-2build1",
"2:6.1.7.3+dfsg-3"
]
},
{
"ecosystem_specific": {
"binaries": [
{
"binary_name": "rails",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-actioncable",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-actionmailbox",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-actionmailer",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-actionpack",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-actiontext",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-actionview",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-activejob",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-activemodel",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-activerecord",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-activestorage",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-activesupport",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-rails",
"binary_version": "2:7.2.2.1+dfsg-7"
},
{
"binary_name": "ruby-railties",
"binary_version": "2:7.2.2.1+dfsg-7"
}
]
},
"package": {
"ecosystem": "Ubuntu:25.10",
"name": "rails",
"purl": "pkg:deb/ubuntu/rails@2:7.2.2.1+dfsg-7?arch=source\u0026distro=questing"
},
"ranges": [
{
"events": [
{
"introduced": "0"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"2:6.1.7.3+dfsg-7",
"2:7.2.2.1+dfsg-7"
]
},
{
"ecosystem_specific": {
"binaries": [
{
"binary_name": "rails",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-actioncable",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-actionmailbox",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-actionmailer",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-actionpack",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-actiontext",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-actionview",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-activejob",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-activemodel",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-activerecord",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-activestorage",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-activesupport",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-rails",
"binary_version": "2:7.2.3+dfsg-2"
},
{
"binary_name": "ruby-railties",
"binary_version": "2:7.2.3+dfsg-2"
}
]
},
"package": {
"ecosystem": "Ubuntu:26.04:LTS",
"name": "rails",
"purl": "pkg:deb/ubuntu/rails@2:7.2.3+dfsg-2?arch=source\u0026distro=resolute"
},
"ranges": [
{
"events": [
{
"introduced": "0"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"2:7.2.2.1+dfsg-7",
"2:7.2.2.2+dfsg-2",
"2:7.2.3+dfsg-2"
]
}
],
"aliases": [],
"details": "A vulnerability in ActiveRecord \u003c6.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.",
"id": "UBUNTU-CVE-2023-22794",
"modified": "2026-05-20T15:02:26Z",
"published": "2023-02-09T20:15:00Z",
"references": [
{
"type": "REPORT",
"url": "https://ubuntu.com/security/CVE-2023-22794"
},
{
"type": "REPORT",
"url": "https://discuss.rubyonrails.org/t/cve-2023-22794-sql-injection-vulnerability-via-activerecord-comments/82117"
},
{
"type": "REPORT",
"url": "https://github.com/rails/rails/commit/048e9fc05e18c91838a44e60175e475de8b2aad5"
},
{
"type": "REPORT",
"url": "https://www.cve.org/CVERecord?id=CVE-2023-22794"
}
],
"related": [],
"schema_version": "1.7.0",
"severity": [
{
"score": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H",
"type": "CVSS_V3"
},
{
"score": "medium",
"type": "Ubuntu"
}
],
"upstream": [
"CVE-2023-22794"
]
}
Loading…
Loading…
Experimental. This forecast is provided for visualization only and may change without notice. Do not use it for operational decisions.
Forecast uses a logistic model when the trend is rising, or an exponential decay model when the trend is falling. Fitted via linearized least squares.
Sightings
| Author | Source | Type | Date | Other |
|---|
Nomenclature
- Seen: The vulnerability was mentioned, discussed, or observed by the user.
- Confirmed: The vulnerability has been validated from an analyst's perspective.
- Published Proof of Concept: A public proof of concept is available for this vulnerability.
- Exploited: The vulnerability was observed as exploited by the user who reported the sighting.
- Patched: The vulnerability was observed as successfully patched by the user who reported the sighting.
- Not exploited: The vulnerability was not observed as exploited by the user who reported the sighting.
- Not confirmed: The user expressed doubt about the validity of the vulnerability.
- Not patched: The vulnerability was not observed as successfully patched by the user who reported the sighting.
Loading…
Loading…