A denial of service vulnerability present in ActiveRecords 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.
Weakness
The product does not properly control the allocation and maintenance of a limited resource.
Affected Software
| Name | Vendor | Start Version | End Version |
|---|---|---|---|
| Activerecord | Activerecord_project | * | 6.1.7.1 (excluding) |
| Activerecord | Activerecord_project | 7.0.0 (including) | 7.0.4.1 (excluding) |
| Red Hat Satellite 6.14 for RHEL 8 | RedHat | rubygem-activerecord-0:6.1.7.3-1.el8sat | * |
| Rails | Ubuntu | bionic | * |
| Rails | Ubuntu | focal | * |
| Rails | Ubuntu | kinetic | * |
| Rails | Ubuntu | lunar | * |
| Rails | Ubuntu | mantic | * |
| Rails | Ubuntu | oracular | * |
| Rails | Ubuntu | plucky | * |
| Rails | Ubuntu | trusty | * |
| Rails | Ubuntu | xenial | * |
| Rails-4.0 | Ubuntu | trusty | * |
| Ruby-actionpack-3.2 | Ubuntu | trusty | * |
| Ruby-activemodel-3.2 | Ubuntu | trusty | * |
| Ruby-activerecord-3.2 | Ubuntu | trusty | * |
| Ruby-activesupport-3.2 | Ubuntu | trusty | * |
| Ruby-rails-3.2 | Ubuntu | trusty | * |
Potential Mitigations
Mitigation of resource exhaustion attacks requires that the target system either:
The first of these solutions is an issue in itself though, since it may allow attackers to prevent the use of the system by a particular valid user. If the attacker impersonates the valid user, they may be able to prevent the user from accessing the server in question.
The second solution is simply difficult to effectively institute – and even when properly done, it does not provide a full solution. It simply makes the attack require more resources on the part of the attacker.
Related Attack Patterns
- https://cwe.mitre.org/data/definitions/147.html
- https://cwe.mitre.org/data/definitions/227.html
- https://cwe.mitre.org/data/definitions/492.html
References
- https://code.jeremyevans.net/2022-11-01-forcing-sequential-scans-on-postgresql.html
- https://discuss.rubyonrails.org/t/cve-2022-44566-possible-denial-of-service-vulnerability-in-activerecords-postgresql-adapter/82119
- https://code.jeremyevans.net/2022-11-01-forcing-sequential-scans-on-postgresql.html
- https://discuss.rubyonrails.org/t/cve-2022-44566-possible-denial-of-service-vulnerability-in-activerecords-postgresql-adapter/82119