CVE-2023-22794: RubyGems ActiveRecord SQL Injection Vulnerability
On January 18, a SQL injection vulnerability was disclosed that impacts some specific versions of the Ruby on Rails (a.k.a. Rails) platform. According to an advisory, the SQLi flaw was discovered within Rails’ ActiveRecord.
Active Record insulates you from the need to use SQL in most cases. It will perform queries on the database for you and is compatible with most database systems, including MySQL, MariaDB, PostgreSQL, and SQLite. Regardless of which database system you’re using, the Active Record method format will always be the same.
RubyGems ActiveRecord is vulnerable to SQL injection. Tracked as CVE-2023-22794, the flaw related to the sanitization of comments. An attacker could send specially-crafted SQL statements to the system, which could allow the attacker to read or modify any data on the underlying database.
“There is a possible vulnerability in ActiveRecord related to the sanitization of comments. This vulnerability has been assigned the CVE identifier CVE-2023-22794,” the advisory explains.
“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 with insufficient sanitization and be able to inject SQL outside of the comment,” they add.
The security vulnerability affected ActiveRecord 6.0.x prior to versions 22.214.171.124, 6.1.x prior to versions 126.96.36.199, and 7.0.0 prior to version 188.8.131.52, and was fixed by Rails in versions 184.108.40.206, 220.127.116.11, 18.104.22.168. Other vulnerabilities were also fixed in these versions including:
- [CVE-2023-22797] Possible Open Redirect Vulnerability in Action Pack
- [CVE-2022-44566] Possible Denial of Service Vulnerability in ActiveRecord’s PostgreSQL
- [CVE-2023-22795] Possible ReDoS based DoS vulnerability in Action Dispatch
- [CVE-2023-22796] Possible ReDoS based DoS vulnerability in Active Support’s underscore
- [CVE-2023-22792] Possible ReDoS based DoS vulnerability in Action Dispatch
Organizations working with Rails should upgrade to remain on the safe side. Upgraded versions of Rails are available here. To aid users who aren’t able to upgrade immediately Rails has provided patches for the two supported release series. They are in git-am format and consist of a single changeset.
- 6-0-Make-sanitize_as_sql_comment-more-strict.patch – Patch for 6.0 series
- 6-1-Make-sanitize_as_sql_comment-more-strict.patch – Patch for 6.1 series
- 7-0-Make-sanitize_as_sql_comment-more-strict.patch – Patch for 7.0 series