POJIA破甲
地图 / `sql` does not properly escape parameters when building SQL queries, resulting in potential SQLi

`sql` does not properly escape parameters when building SQL queries, resulting in potential SQLi

SQL 注入 / SQL 注入 / #319465

厂商
Node.js third-party modules
严重程度
低危 · CVSS 6.3
赏金
—
弱点
SQL 注入
研究员
@chalker
披露日期
2018-05-12
资产
sql
CVE
—

该报告还没有中文解读。

原文摘录

摘自原文(2153 字符中的一小部分)
It allows to insert potentially user-controlled content into the queries without proper escaping, in cases where that is not verified additionally in the applications that are using `sql` library.
原文中的代码
var sql = require('sql');
var user = sql.define({
  name: 'users',
  columns: ['id', 'name', 'email', 'lastLogin']
});
console.log(user.select(user.star()).from(user).limit('1; drop table users').toQuery().text);
console.log(user.select(user.star()).from(user).offset('1; drop table …

默认不展示报告全文。以上为简短摘录,完整复现过程请阅读原文。版权归研究员与 Node.js third-party modules 所有。

时间线

  • 报告提交
  • 公开披露
阅读 HackerOne 原文 ↗作者 @chalker · 版权归作者与 Node.js third-party modules 所有

同类报告

SQL Injection Extracts Starbucks Enterprise Accounting, Financial, Payroll DatabaseStarbucks · 2019-08-06SQL injection in https://labs.data.gov/dashboard/datagov/csv_to_json via User-agentGSA Bounty · 2019-03-22Time-Based SQL injection at city-mobil.ruMail.ru · — · $15,000SQL injection at https://sea-web.gold.razer.com/ajax-get-status.php via txid parameterRazer · — · $2,000SQL Injection in https://api-my.pay.razer.com/inviteFriend/getInviteHistoryLogRazer · — · $2,000Blind SQL InjectionInnoGames · — · $2,000