Goal Reached Thanks to every supporter — we hit 100%!

Goal: 1000 CNY · Raised: 1336 CNY

100%
Buy Us a Coffee

CVE-2022-35956— update_by_case before 0.1.3 vulnerable to sql injection

Quick assessment

Affected
camilova activerecord-update-by-case
Exploitation
No confirmed in-the-wild exploitation; assess based on exposure
Recommended action
Check the vendor advisory and references for a fixed version. If immediate upgrade is impossible, restrict exposure and increase monitoring.

Activerecord update_by_case是通过单个数据库命中的案例值更新许多记录的Ruby on Rails工具。 Activerecord update_by_case 0.1.3 之前版本存在SQL注入漏洞，该漏洞源于update_by_case使用了自定义的 sql 字符串，没有经过清理。

CVSS 5.8 · Medium EPSS 0.62% · P47

Possible ATT&CK Techniques 1 AI

T1190 · Exploit Public-Facing Application
Get alerts for future matching vulnerabilities Log in to subscribe

I. Basic Information for CVE-2022-35956

Vulnerability Information
Have questions about the vulnerability? See if Shenlong's analysis helps!
View Shenlong Deep Dive ↗

Although we use advanced large model technology, its output may still contain inaccurate or outdated information.Shenlong tries to ensure data accuracy, but please verify and judge based on the actual situation.

Vulnerability Title
update_by_case before 0.1.3 vulnerable to sql injection
Source: CVE Program / CVE List V5
Vulnerability Description
This Rails gem adds two methods to the ActiveRecord::Base class that allow you to update many records on a single database hit, using a case sql statement for it. Before version 0.1.3 `update_by_case` gem used custom sql strings, and it was not sanitized, making it vulnerable to sql injection. Upgrade to version >= 0.1.3 that uses `Arel` instead to construct the resulting sql statement, with sanitized sql.
Source: CVE Program / CVE List V5
CVSS Information
CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:C/C:L/I:L/A:L
Source: CVE Program / CVE List V5
Vulnerability Type
SQL命令中使用的特殊元素转义处理不恰当(SQL注入)
Source: CVE Program / CVE List V5
Vulnerability Title
Activerecord update_by_case SQL注入漏洞
Source: CNNVD (China National Vulnerability Database)
Vulnerability Description
Activerecord update_by_case是通过单个数据库命中的案例值更新许多记录的Ruby on Rails工具。 Activerecord update_by_case 0.1.3 之前版本存在SQL注入漏洞，该漏洞源于update_by_case使用了自定义的 sql 字符串，没有经过清理。
Source: CNNVD (China National Vulnerability Database)
CVSS Information
N/A
Source: CNNVD (China National Vulnerability Database)
Vulnerability Type
N/A
Source: CNNVD (China National Vulnerability Database)

Affected Products

Vendor Product Affected Versions CPE Subscribe
camilova activerecord-update-by-case < 0.1.3 -

II. Public POCs for CVE-2022-35956

# POC Description Source Link Shenlong Link
AI-Generated POC Premium

No public POC found.

Login to generate AI POC

III. Intelligence Information for CVE-2022-35956

请登录查看更多情报信息。

Vendor Advisories for CVE-2022-35956 (1)

Other References for CVE-2022-35956 (1)

IV. Related Vulnerabilities

Same weakness: CWE-89

V. Comments for CVE-2022-35956

No comments yet

Leave a comment