CVE-2011-2930: SQL Injection
First published: Wed Aug 17 2011(Updated: )
An SQL injection vulnerability in the quote_table_name method could allow malicious users to inject arbitrary SQL into a query [1]. This is corrected in upstream 3.0.10, 2.3.13, and 3.1.0rc5 versions. Patches are available in the advisory [1] and in git [2]. [1] <a href="http://groups.google.com/group/rubyonrails-security/browse_thread/thread/6a1e473744bc389b">http://groups.google.com/group/rubyonrails-security/browse_thread/thread/6a1e473744bc389b</a> [2] <a href="https://github.com/rails/rails/commit/8a39f411dc3c806422785b1f4d5c7c9d58e4bf85">https://github.com/rails/rails/commit/8a39f411dc3c806422785b1f4d5c7c9d58e4bf85</a>
Credit: secalert@redhat.com
| Affected Software | Affected Version | How to fix |
|---|---|---|
| rubygems/activerecord | >=3.0.0<3.0.10 | 3.0.10 |
| rubygems/activerecord | >=2.0.0<2.3.13 | 2.3.13 |
| redhat/rubygem-activerecord | <2.3.13 | 2.3.13 |
| redhat/rubygem-activerecord | <3.0.10 | 3.0.10 |
| redhat/rubygem-activerecord | <3.1.0 | 3.1.0 |
| Ruby on Rails | =2.0.0 | |
| Ruby on Rails | =2.0.0-rc1 | |
| Ruby on Rails | =2.0.0-rc2 | |
| Ruby on Rails | =2.0.1 | |
| Ruby on Rails | =2.0.2 | |
| Ruby on Rails | =2.0.4 | |
| Ruby on Rails | =2.1.0 | |
| Ruby on Rails | =2.1.1 | |
| Ruby on Rails | =2.1.2 | |
| Ruby on Rails | =2.2.0 | |
| Ruby on Rails | =2.2.1 | |
| Ruby on Rails | =2.2.2 | |
| Ruby on Rails | =2.3.2 | |
| Ruby on Rails | =2.3.3 | |
| Ruby on Rails | =2.3.4 | |
| Ruby on Rails | =2.3.9 | |
| Ruby on Rails | =2.3.10 | |
| Ruby on Rails | =2.3.11 | |
| Ruby on Rails | =2.3.12 | |
| Ruby on Rails | =3.0.0 | |
| Ruby on Rails | =3.0.0-beta | |
| Ruby on Rails | =3.0.0-beta2 | |
| Ruby on Rails | =3.0.0-beta3 | |
| Ruby on Rails | =3.0.0-beta4 | |
| Ruby on Rails | =3.0.0-rc | |
| Ruby on Rails | =3.0.0-rc2 | |
| Ruby on Rails | =3.0.1 | |
| Ruby on Rails | =3.0.1-pre | |
| Ruby on Rails | =3.0.2 | |
| Ruby on Rails | =3.0.2-pre | |
| Ruby on Rails | =3.0.3 | |
| Ruby on Rails | =3.0.4-rc1 | |
| Ruby on Rails | =3.0.5 | |
| Ruby on Rails | =3.0.5-rc1 | |
| Ruby on Rails | =3.0.6 | |
| Ruby on Rails | =3.0.6-rc1 | |
| Ruby on Rails | =3.0.6-rc2 | |
| Ruby on Rails | =3.0.7 | |
| Ruby on Rails | =3.0.7-rc1 | |
| Ruby on Rails | =3.0.7-rc2 | |
| Ruby on Rails | =3.0.8 | |
| Ruby on Rails | =3.0.8-rc1 | |
| Ruby on Rails | =3.0.8-rc2 | |
| Ruby on Rails | =3.0.8-rc3 | |
| Ruby on Rails | =3.0.8-rc4 | |
| Ruby on Rails | =3.0.9 | |
| Ruby on Rails | =3.0.9-rc1 | |
| Ruby on Rails | =3.0.9-rc2 | |
| Ruby on Rails | =3.0.9-rc3 | |
| Ruby on Rails | =3.0.9-rc4 | |
| Ruby on Rails | =3.0.9-rc5 | |
| Ruby on Rails | =3.0.10-rc1 | |
| Ruby on Rails | =3.1.0 | |
| Ruby on Rails | =3.1.0-beta1 | |
| Ruby on Rails | =3.1.0-rc1 | |
| Ruby on Rails | =3.1.0-rc2 | |
| Ruby on Rails | =3.1.0-rc3 | |
| Ruby on Rails | =3.1.0-rc4 | |
| Ruby on Rails | =3.0.4 |
Remedy
http://groups.google.com/group/rubyonrails-security/msg/b1a85d36b0f9dd30?dmode=source&output=gplain
Never miss a vulnerability like this again
Sign up to SecAlerts for real-time vulnerability data matched to your software, aggregated from hundreds of sources.
Reference Links
- http://www.openwall.com/lists/oss-security/2011/08/22/14
- http://www.openwall.com/lists/oss-security/2011/08/22/5
- https://bugzilla.redhat.com/show_bug.cgi?id=731438
- http://www.openwall.com/lists/oss-security/2011/08/20/1
- https://github.com/rails/rails/commit/8a39f411dc3c806422785b1f4d5c7c9d58e4bf85
- http://weblog.rubyonrails.org/2011/8/16/ann-rails-3-1-0-rc6
- http://groups.google.com/group/rubyonrails-security/msg/b1a85d36b0f9dd30?dmode=source&output=gplain
- http://www.openwall.com/lists/oss-security/2011/08/17/1
- http://www.openwall.com/lists/oss-security/2011/08/19/11
- http://www.openwall.com/lists/oss-security/2011/08/22/13
- http://lists.fedoraproject.org/pipermail/package-announce/2011-September/065212.html
- http://www.debian.org/security/2011/dsa-2301
- https://nvd.nist.gov/vuln/detail/CVE-2011-2930
- https://github.com/rubysec/ruby-advisory-db/blob/master/gems/activerecord/CVE-2011-2930.yml
- https://github.com/advisories/GHSA-h6w6-xmqv-7q78 (Advisory)
- http://groups.google.com/group/rubyonrails-security/browse_thread/thread/6a1e473744bc389b
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=731452
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=731453
Frequently Asked Questions
What is the severity of CVE-2011-2930?
CVE-2011-2930 has a high severity rating due to its ability to allow SQL injection attacks.
How do I fix CVE-2011-2930?
To fix CVE-2011-2930, upgrade to ActiveRecord version 3.0.10, 2.3.13, or 3.1.0rc5 or apply available patches.
Which software is affected by CVE-2011-2930?
CVE-2011-2930 affects specific versions of ActiveRecord including 3.0.0 through 3.0.9 and 2.0.0 through 2.3.12.
Is there a workaround for CVE-2011-2930?
There is no documented workaround for CVE-2011-2930; the only resolution is to update to the patched versions.
What kind of attacks can exploit CVE-2011-2930?
CVE-2011-2930 can be exploited via SQL injection attacks, enabling attackers to execute arbitrary SQL code.
- collector/github-advisory-latest
- alias/GHSA-h6w6-xmqv-7q78
- alias/CVE-2011-2930
- collector/github-advisory
- agent/author
- agent/type
- agent/first-publish-date
- collector/mitre-cve
- source/MITRE
- collector/redhat-bugzilla
- source/Red Hat
- agent/software-canonical-lookup
- agent/weakness
- agent/last-modified-date
- agent/severity
- agent/references
- agent/remedy
- agent/description
- agent/event
- agent/trending
- agent/source
- agent/tags
- agent/softwarecombine
- collector/nvd-cve
- agent/software-canonical-lookup-request
- collector/nvd-index
- collector/nvd-historical
- package-manager/rubygems
- package-manager/redhat
- vendor/rubyonrails
- canonical/ruby on rails
- version/ruby on rails/2.0.0
- version/ruby on rails/2.0.0-rc1
- version/ruby on rails/2.0.0-rc2
- version/ruby on rails/2.0.1
- version/ruby on rails/2.0.2
- version/ruby on rails/2.0.4
- version/ruby on rails/2.1.0
- version/ruby on rails/2.1.1
- version/ruby on rails/2.1.2
- version/ruby on rails/2.2.0
- version/ruby on rails/2.2.1
- version/ruby on rails/2.2.2
- version/ruby on rails/2.3.2
- version/ruby on rails/2.3.3
- version/ruby on rails/2.3.4
- version/ruby on rails/2.3.9
- version/ruby on rails/2.3.10
- version/ruby on rails/2.3.11
- version/ruby on rails/2.3.12
- version/ruby on rails/3.0.0
- version/ruby on rails/3.0.0-beta
- version/ruby on rails/3.0.0-beta2
- version/ruby on rails/3.0.0-beta3
- version/ruby on rails/3.0.0-beta4
- version/ruby on rails/3.0.0-rc
- version/ruby on rails/3.0.0-rc2
- version/ruby on rails/3.0.1
- version/ruby on rails/3.0.1-pre
- version/ruby on rails/3.0.2
- version/ruby on rails/3.0.2-pre
- version/ruby on rails/3.0.3
- version/ruby on rails/3.0.4-rc1
- version/ruby on rails/3.0.5
- version/ruby on rails/3.0.5-rc1
- version/ruby on rails/3.0.6
- version/ruby on rails/3.0.6-rc1
- version/ruby on rails/3.0.6-rc2
- version/ruby on rails/3.0.7
- version/ruby on rails/3.0.7-rc1
- version/ruby on rails/3.0.7-rc2
- version/ruby on rails/3.0.8
- version/ruby on rails/3.0.8-rc1
- version/ruby on rails/3.0.8-rc2
- version/ruby on rails/3.0.8-rc3
- version/ruby on rails/3.0.8-rc4
- version/ruby on rails/3.0.9
- version/ruby on rails/3.0.9-rc1
- version/ruby on rails/3.0.9-rc2
- version/ruby on rails/3.0.9-rc3
- version/ruby on rails/3.0.9-rc4
- version/ruby on rails/3.0.9-rc5
- version/ruby on rails/3.0.10-rc1
- version/ruby on rails/3.1.0
- version/ruby on rails/3.1.0-beta1
- version/ruby on rails/3.1.0-rc1
- version/ruby on rails/3.1.0-rc2
- version/ruby on rails/3.1.0-rc3
- version/ruby on rails/3.1.0-rc4
- version/ruby on rails/3.0.4