| タイトル | Jawher Kl node-api-postgres 2.5 SQL Injection |
|---|
| 説明 | A Critical SQL Injection vulnerability exists in the node-api-postgres application. In the file models/user.js (within User.getAll()), the sort parameter provided via the GET /users endpoint is concatenated directly into the SQL query without adequate sanitization or parameterized execution. Because ORDER BY clauses cannot be parameterized in PostgreSQL, this direct string concatenation allows unauthenticated attackers (after obtaining a basic user JWT) to execute arbitrary SQL commands. This can be exploited to achieve boolean-based data extraction or full data exfiltration via subqueries (e.g., extracting admin bcrypt password hashes and emails). |
|---|
| ソース | ⚠️ https://hackmd.io/@YzU_KiOzT86cEbFQdBceVg/Bk56LQQYbe |
|---|
| ユーザー | yeee3642 (UID 91336) |
|---|
| 送信 | 2026年03月02日 16:14 (2 月 ago) |
|---|
| モデレーション | 2026年03月14日 23:40 (12 days later) |
|---|
| ステータス | 承諾済み |
|---|
| VulDBエントリ | 351097 [JawherKl node-api-postgres 迄 2.5 models/user.js User.getAll sort SQLインジェクション] |
|---|
| ポイント | 20 |
|---|