UBUNTU-CVE-2023-22794

See a problem?
Please try reporting it to the source first.
Source
https://ubuntu.com/security/CVE-2023-22794
Import Source
https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-22794.json
JSON Data
https://api.osv.dev/v1/vulns/UBUNTU-CVE-2023-22794
Upstream
Published
2023-02-09T20:15:00Z
Modified
2025-10-24T05:01:46Z
Severity
  • 8.8 (High) CVSS_V3 - CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H CVSS Calculator
  • Ubuntu - medium
Summary
[none]
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.

References

Affected packages

Ubuntu:24.04:LTS

rails

Package

Name
rails
Purl
pkg:deb/ubuntu/rails@2:6.1.7.3+dfsg-3?arch=source&distro=noble

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected

Affected versions

2:6.*

2:6.1.7.3+dfsg-2build1
2:6.1.7.3+dfsg-3

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"
        }
    ]
}

Ubuntu:25.04

rails

Package

Name
rails
Purl
pkg:deb/ubuntu/rails@2:6.1.7.3+dfsg-7?arch=source&distro=plucky

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected

Affected versions

2:6.*

2:6.1.7.3+dfsg-3
2:6.1.7.3+dfsg-4
2:6.1.7.3+dfsg-7

Ecosystem specific 

{
    "binaries": [
        {
            "binary_name": "rails",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-actioncable",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-actionmailbox",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-actionmailer",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-actionpack",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-actiontext",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-actionview",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-activejob",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-activemodel",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-activerecord",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-activestorage",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-activesupport",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-rails",
            "binary_version": "2:6.1.7.3+dfsg-7"
        },
        {
            "binary_name": "ruby-railties",
            "binary_version": "2:6.1.7.3+dfsg-7"
        }
    ]
}

Ubuntu:25.10

rails

Package

Name
rails
Purl
pkg:deb/ubuntu/rails@2:7.2.2.1+dfsg-7?arch=source&distro=questing

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected

Affected versions

2:6.*

2:6.1.7.3+dfsg-7

2:7.*

2:7.2.2.1+dfsg-7

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"
        }
    ]
}

Ubuntu:Pro:16.04:LTS

rails

Package

Name
rails
Purl
pkg:deb/ubuntu/rails@2:4.2.6-1ubuntu0.1~esm2?arch=source&distro=esm-apps/xenial

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected

Affected versions

2:4.*

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.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"
        }
    ]
}

Ubuntu:Pro:18.04:LTS

rails

Package

Name
rails
Purl
pkg:deb/ubuntu/rails@2:4.2.10-0ubuntu4+esm2?arch=source&distro=esm-apps/bionic

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected

Affected versions

2:4.*

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: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"
        }
    ]
}

Ubuntu:Pro:20.04:LTS

rails

Package

Name
rails
Purl
pkg:deb/ubuntu/rails@2:5.2.3+dfsg-3ubuntu0.1~esm1?arch=source&distro=esm-apps/focal

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected

Affected versions

2:5.*

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: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"
        }
    ]
}

Ubuntu:Pro:22.04:LTS

rails

Package

Name
rails
Purl
pkg:deb/ubuntu/rails@2:6.1.4.1+dfsg-8ubuntu2+esm1?arch=source&distro=esm-apps/jammy

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected

Affected versions

2:6.*

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.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"
        }
    ]
}