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.
{ "binaries": [ { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "rails" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-actioncable" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-actionmailbox" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-actionmailer" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-actionpack" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-actiontext" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-actionview" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-activejob" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-activemodel" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-activerecord" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-activestorage" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-activesupport" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-rails" }, { "binary_version": "2:6.1.4.1+dfsg-8ubuntu2", "binary_name": "ruby-railties" } ] }
{ "binaries": [ { "binary_version": "2:6.1.7.3+dfsg-3", "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" } ] }
{ "binaries": [ { "binary_version": "2:6.1.7.3+dfsg-7", "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" } ] }
{ "binaries": [ { "binary_version": "2:7.2.2.1+dfsg-7", "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" } ] }
{ "binaries": [ { "binary_version": "2:4.2.6-1ubuntu0.1~esm2", "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" } ] }
{ "binaries": [ { "binary_version": "2:4.2.10-0ubuntu4+esm2", "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" } ] }
{ "binaries": [ { "binary_version": "2:5.2.3+dfsg-3ubuntu0.1~esm1", "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" } ] }