CVE-2022-44566

There is a potential denial of service vulnerability present in ActiveRecord's PostgreSQL adapter.

This has been assigned the CVE identifier CVE-2022-44566.

Versions Affected: All. Not affected: None.

Fixed Versions

• 2.3.18.47 (Rails LTS, which is a paid service and not part of the rubygem)
• 3.2.22.34 (Rails LTS, which is a paid service and not part of the rubygem)
• 4.2.11.27 (Rails LTS, which is a paid service and not part of the rubygem)
• 5.2.8.15 (Rails LTS, which is a paid service and not part of the rubygem)
• 6.1.7.1
• 7.0.4.1

Impact

In ActiveRecord < 7.0.4.1 and < 6.1.7.1, when a value outside the range for a 64bit signed integer is provided to the PostgreSQL connection adapter, it will treat the target column type as numeric. Comparing integer values against numeric values can result in a slow sequential scan resulting in potential Denial of Service.

Releases

The fixed releases are available at the normal locations.

Workarounds

Ensure that user supplied input which is provided to ActiveRecord clauses do not contain integers wider than a signed 64bit representation or floats.

Patches

To aid users who aren't able to upgrade immediately we have provided patches for the supported release series in accordance with our maintenance policy 1 regarding security issues. They are in git-am format and consist of a single changeset.

6-1-Added-integer-width-check-to-PostgreSQL-Quoting.patch - Patch for 6.1 series 7-0-Added-integer-width-check-to-PostgreSQL-Quoting.patch - Patch for 7.0 series

Implements the ActiveRecord pattern (Fowler, PoEAA) for ORM. It ties database tables and classes together for business objects, like Customer or Subscription, that can find, save, and destroy themselves without resorting to manual SQL.

Security Fix(es):

A denial of service vulnerability present in ActiveRecord's PostgreSQL adapter <7.0.4.1 and <6.1.7.1. When a value outside the range for a 64bit signed integer is provided to the PostgreSQL connection adapter, it will treat the target column type as numeric. Comparing integer values against numeric values can result in a slow sequential scan resulting in potential Denial of Service.(CVE-2022-44566)

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.(CVE-2023-22794)

Implements the ActiveRecord pattern (Fowler, PoEAA) for ORM. It ties database tables and classes together for business objects, like Customer or Subscription, that can find, save, and destroy themselves without resorting to manual SQL.

Security Fix(es):

A denial of service vulnerability present in ActiveRecord's PostgreSQL adapter <7.0.4.1 and <6.1.7.1. When a value outside the range for a 64bit signed integer is provided to the PostgreSQL connection adapter, it will treat the target column type as numeric. Comparing integer values against numeric values can result in a slow sequential scan resulting in potential Denial of Service.(CVE-2022-44566)

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.(CVE-2023-22794)

A denial of service vulnerability present in ActiveRecord's PostgreSQL adapter <7.0.4.1 and <6.1.7.1. When a value outside the range for a 64bit signed integer is provided to the PostgreSQL connection adapter, it will treat the target column type as numeric. Comparing integer values against numeric values can result in a slow sequential scan resulting in potential Denial of Service.

These are all security issues fixed in the ruby3.1-rubygem-activerecord-7.0-7.0.4.1-1.1 package on the GA media of openSUSE Tumbleweed.

These are all security issues fixed in the ruby3.3-rubygem-activerecord-7.0-7.0.8.4-1.1 package on the GA media of openSUSE Tumbleweed.

These are all security issues fixed in the ruby3.4-rubygem-activerecord-7.0-7.0.8.6-1.3 package on the GA media of openSUSE Tumbleweed.

Rocky Enterprise Software Foundation Satellite is a systems management tool for Linux-based infrastructure. It allows for provisioning, remote management, and monitoring of multiple Linux deployments with a single centralized tool.

Security Fix(es):

• golang: net/http, x/net/http2: rapid stream resets can cause excessive work (CVE-2023-44487) (CVE-2023-39325)

• HTTP/2: Multiple HTTP/2 enabled web servers are vulnerable to a DDoS attack (Rapid Reset Attack) (CVE-2023-44487)

• GitPython: Insecure non-multi options in clone and clone_from is not blocked (CVE-2023-40267)

• kubeclient: kubeconfig parsing error can lead to MITM attacks (CVE-2022-0759)

• foreman: OS command injection via ct_command and fcct_command (CVE-2022-3874)

• ruby-git: code injection vulnerability (CVE-2022-46648)

• ruby-git: code injection vulnerability (CVE-2022-47318)

• Foreman: Arbitrary code execution through templates (CVE-2023-0118)

• rubygem-activerecord: SQL Injection (CVE-2023-22794)

• openssl: c_rehash script allows command injection (CVE-2022-1292)

• openssl: the c_rehash script allows command injection (CVE-2022-2068)

• Pulp:Tokens stored in plaintext (CVE-2022-3644)

• satellite: Blind SSRF via Referer header (CVE-2022-4130)

• python-future: remote attackers can cause denial of service via crafted Set-Cookie header from malicious web server (CVE-2022-40899)

• golang: net/http: excessive memory growth in a Go server accepting HTTP/2 requests (CVE-2022-41717)

• rubygem-activerecord: Denial of Service (CVE-2022-44566)

• rubygem-rack: denial of service in Content-Disposition parsing (CVE-2022-44570)

• rubygem-rack: denial of service in Content-Disposition parsing (CVE-2022-44571)

• rubygem-rack: denial of service in Content-Disposition parsing (CVE-2022-44572)

• Foreman: Stored cross-site scripting in host tab (CVE-2023-0119)

• puppet: Puppet Server ReDoS (CVE-2023-1894)

• rubygem-actionpack: Denial of Service in Action Dispatch (CVE-2023-22792)

• rubygem-actionpack: Denial of Service in Action Dispatch (CVE-2023-22795)

• rubygem-activesupport: Regular Expression Denial of Service (CVE-2023-22796)

• rubygem-globalid: ReDoS vulnerability (CVE-2023-22799)

• rubygem-rack: Denial of service in Multipart MIME parsing (CVE-2023-27530)

• rubygem-rack: denial of service in header parsing (CVE-2023-27539)

• golang: net/http: insufficient sanitization of Host header (CVE-2023-29406)

• sqlparse: Parser contains a regular expression that is vulnerable to ReDOS (Regular Expression Denial of Service) (CVE-2023-30608)

• python-django: Potential bypass of validation when uploading multiple files using one form field (CVE-2023-31047)

• python-requests: Unintended leak of Proxy-Authorization header (CVE-2023-32681)

• python-django: Potential regular expression denial of service vulnerability in EmailValidator/URLValidator (CVE-2023-36053)

For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.

Additional Changes:

This update also fixes several bugs and adds various enhancements. Documentation for these changes is available from the Release Notes document linked to in the References section.

This update for rubygem-activerecord-5_1 fixes the following issues:

• CVE-2022-44566: Fixed possible denial of service vulnerability in ActiveRecord's PostgreSQL adapter (bsc#1207450).

This update for rubygem-activerecord-4_2 fixes the following issues:

• CVE-2022-44566: Fixed a potential denial of service due to an inefficient comparison between integer and numeric values (bsc#1207450).

This update for rubygem-activerecord-4_2 contains the following fixes:

• CVE-2022-44566: Fixed a potential denial of service due to an inefficient comparison between integer and numeric values. (bsc#1207450)

• fixed regression caused by fix for CVE-2022-44566. (bsc#1207450)