製品・ソフトウェアに関する情報

JVN脆弱性詳細

Ruby on Rails の Active Record 用 PostgreSQL アダプタにおける SQL インジェクションの脆弱性

Title	Ruby on Rails の Active Record 用 PostgreSQL アダプタにおける SQL インジェクションの脆弱性
Summary	Ruby on Rails の Active Record 用 PostgreSQL アダプタの activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb には、SQL インジェクションの脆弱性が存在します。
Possible impacts	第三者により、不適切なビット列のクォートを利用されることで、任意の SQL コマンドを実行される可能性があります。
Solution	ベンダより正式な対策が公開されています。ベンダ情報を参照して適切な対策を実施してください。
Publication Date	July 2, 2014, midnight
Registration Date	July 8, 2014, 5:33 p.m.
Last Update	Aug. 6, 2014, 5:21 p.m.

CVSS2.0 : 危険
Score	7.5
Vector	AV:N/AC:L/Au:N/C:P/I:P/A:P

Affected System

Ruby on Rails project

Rails 2.x

Rails 3.2.19 未満の 3.x

CVE (情報セキュリティ共通脆弱性識別子)

No	Name	URL
Common Vulnerabilities and Exposures (CVE)
1	CVE-2014-3482	http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2014-3482
National Vulnerability Database (NVD)
2	CVE-2014-3482	http://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2014-3482

CWE (共通脆弱性タイプ一覧)

No	Name	URL
JVNDB
1	CWE-89	https://jvndb.jvn.jp/ja/cwe/CWE-89.html

ベンダー情報

No	Name	URL
Google Groups
1	[CVE-2014-3482] [CVE-2014-3483] Two Active Record SQL Injection Vulnerabilities Affecting PostgreSQL	https://groups.google.com/forum/message/raw?msg=rubyonrails-security/wDxePLJGZdI/WP7EasCJTA4J
Red Hat Security Advisory
2	RHSA-2014:0876	https://rhn.redhat.com/errata/RHSA-2014-0876.html

Change Log

No	Changed Details	Date of change
0	[2014年07月08日] 掲載 [2014年08月06日] ベンダ情報：レッドハット (RHSA-2014:0876) を追加	Feb. 17, 2018, 10:37 a.m.

NVD Vulnerability Information

CVE-2014-3482

Summary	SQL injection vulnerability in activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb in the PostgreSQL adapter for Active Record in Ruby on Rails 2.x and 3.x before 3.2.19 allows remote attackers to execute arbitrary SQL commands by leveraging improper bitstring quoting.
Publication Date	July 7, 2014, 8:01 p.m.
Registration Date	Jan. 26, 2021, 3:10 p.m.
Last Update	Nov. 21, 2024, 11:08 a.m.

Affected software configurations

Configuration1	or higher	or less	more than	less than
cpe:2.3:a:rubyonrails:ruby_on_rails:2.3.17:::::::*
cpe:2.3:a:rubyonrails:ruby_on_rails:3.0.4:::::::*
cpe:2.3:a:rubyonrails:rails:2.0.1:::::::*
cpe:2.3:a:rubyonrails:rails:2.0.2:::::::*
cpe:2.3:a:rubyonrails:rails:2.0.4:::::::*
cpe:2.3:a:rubyonrails:rails:2.1.0:::::::*
cpe:2.3:a:rubyonrails:rails:2.1.1:::::::*
cpe:2.3:a:rubyonrails:rails:2.1.2:::::::*
cpe:2.3:a:rubyonrails:rails:2.2.0:::::::*
cpe:2.3:a:rubyonrails:rails:2.2.1:::::::*
cpe:2.3:a:rubyonrails:rails:2.2.2:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.0:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.1:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.2:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.3:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.4:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.9:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.10:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.11:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.12:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.13:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.14:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.15:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.16:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.18:::::::*
cpe:2.3:a:rubyonrails:rails:2.0.0:rc1::::::
cpe:2.3:a:rubyonrails:rails:2.0.0:rc2::::::
cpe:2.3:a:rubyonrails:rails:2.0.0:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.0:beta::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:beta2::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:beta3::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:beta4::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:rc::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.0.1:pre::::::
cpe:2.3:a:rubyonrails:rails:3.0.2:pre::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.10:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.10:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.12:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.12:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.13:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.13:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.0:beta1::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc3::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc4::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc5::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc6::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc7::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.0:rc8::::::
cpe:2.3:a:rubyonrails:rails:3.1.1:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.1.1:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.1.1:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.1:rc3::::::
cpe:2.3:a:rubyonrails:rails:3.1.2:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.1.2:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.1.2:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.4:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.4:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.1.5:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.5:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.2.0:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.2.0:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.2.0:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.7:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.8:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.9:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.13:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.2.13:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.2.15:rc3::::::
cpe:2.3:a:rubyonrails:rails:3.0.1:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.2:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.3:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.11:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.14:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.16:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.17:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.18:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.19:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.20:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.3:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.6:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.7:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.8:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.9:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.10:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.1:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.5:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.6:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.10:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.11:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.12:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.16:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.17:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.18:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.4:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.5:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.5:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.6:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.6:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.0.6:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.7:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.7:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.0.7:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.8:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.8:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.0.8:rc3::::::
cpe:2.3:a:rubyonrails:rails:3.0.8:rc4::::::
cpe:2.3:a:rubyonrails:rails:3.0.8:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.9:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.9:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.0.9:rc3::::::
cpe:2.3:a:rubyonrails:rails:3.0.9:rc4::::::
cpe:2.3:a:rubyonrails:rails:3.0.9:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.9:rc5::::::
cpe:2.3:a:rubyonrails:rails:3.2.2:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.2.2:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.3:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.2.3:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.3:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.2.4:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.4:rc1::::::

Related information, measures and tools

No	URL	refsource	タグ
1	http://openwall.com/lists/oss-security/2014/07/02/5
2	http://openwall.com/lists/oss-security/2014/07/02/5
3	http://rhn.redhat.com/errata/RHSA-2014-0876.html
4	http://rhn.redhat.com/errata/RHSA-2014-0876.html
5	http://secunia.com/advisories/59973
6	http://secunia.com/advisories/59973
7	http://secunia.com/advisories/60214
8	http://secunia.com/advisories/60214
9	http://secunia.com/advisories/60763
10	http://secunia.com/advisories/60763
11	http://www.debian.org/security/2014/dsa-2982
12	http://www.debian.org/security/2014/dsa-2982
13	http://www.securityfocus.com/bid/68343
14	http://www.securityfocus.com/bid/68343
15	https://groups.google.com/forum/message/raw?msg=rubyonrails-security/wDxePLJGZdI/WP7EasCJTA4J
16	https://groups.google.com/forum/message/raw?msg=rubyonrails-security/wDxePLJGZdI/WP7EasCJTA4J

Common Vulnerabilities List

No	CWE	Name	URL
1	CWE-89	SQLインジェクション	https://cwe.mitre.org/data/definitions/89.html

Configuration1	or higher	or less	more than	less than
cpe:2.3:a:rubyonrails:ruby_on_rails:2.3.17:::::::*
cpe:2.3:a:rubyonrails:ruby_on_rails:3.0.4:::::::*
cpe:2.3:a:rubyonrails:rails:2.0.1:::::::*
cpe:2.3:a:rubyonrails:rails:2.0.2:::::::*
cpe:2.3:a:rubyonrails:rails:2.0.4:::::::*
cpe:2.3:a:rubyonrails:rails:2.1.0:::::::*
cpe:2.3:a:rubyonrails:rails:2.1.1:::::::*
cpe:2.3:a:rubyonrails:rails:2.1.2:::::::*
cpe:2.3:a:rubyonrails:rails:2.2.0:::::::*
cpe:2.3:a:rubyonrails:rails:2.2.1:::::::*
cpe:2.3:a:rubyonrails:rails:2.2.2:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.0:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.1:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.2:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.3:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.4:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.9:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.10:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.11:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.12:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.13:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.14:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.15:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.16:::::::*
cpe:2.3:a:rubyonrails:rails:2.3.18:::::::*
cpe:2.3:a:rubyonrails:rails:2.0.0:rc1::::::
cpe:2.3:a:rubyonrails:rails:2.0.0:rc2::::::
cpe:2.3:a:rubyonrails:rails:2.0.0:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.0:beta::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:beta2::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:beta3::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:beta4::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:rc::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.0.1:pre::::::
cpe:2.3:a:rubyonrails:rails:3.0.2:pre::::::
cpe:2.3:a:rubyonrails:rails:3.0.0:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.10:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.10:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.12:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.12:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.13:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.13:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.0:beta1::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc3::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc4::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc5::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc6::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:rc7::::::
cpe:2.3:a:rubyonrails:rails:3.1.0:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.0:rc8::::::
cpe:2.3:a:rubyonrails:rails:3.1.1:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.1.1:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.1.1:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.1:rc3::::::
cpe:2.3:a:rubyonrails:rails:3.1.2:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.1.2:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.1.2:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.4:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.4:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.1.5:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.5:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.2.0:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.2.0:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.2.0:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.7:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.8:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.9:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.13:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.2.13:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.2.15:rc3::::::
cpe:2.3:a:rubyonrails:rails:3.0.1:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.2:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.3:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.11:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.14:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.16:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.17:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.18:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.19:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.20:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.3:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.6:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.7:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.8:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.9:::::::*
cpe:2.3:a:rubyonrails:rails:3.1.10:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.1:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.5:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.6:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.10:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.11:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.12:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.16:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.17:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.18:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.4:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.5:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.5:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.6:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.6:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.0.6:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.7:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.7:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.0.7:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.8:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.8:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.0.8:rc3::::::
cpe:2.3:a:rubyonrails:rails:3.0.8:rc4::::::
cpe:2.3:a:rubyonrails:rails:3.0.8:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.9:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.0.9:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.0.9:rc3::::::
cpe:2.3:a:rubyonrails:rails:3.0.9:rc4::::::
cpe:2.3:a:rubyonrails:rails:3.0.9:::::::*
cpe:2.3:a:rubyonrails:rails:3.0.9:rc5::::::
cpe:2.3:a:rubyonrails:rails:3.2.2:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.2.2:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.3:rc1::::::
cpe:2.3:a:rubyonrails:rails:3.2.3:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.3:rc2::::::
cpe:2.3:a:rubyonrails:rails:3.2.4:::::::*
cpe:2.3:a:rubyonrails:rails:3.2.4:rc1::::::