| 标题 | Daptin https://github.com/daptin/daptin 0.10.3 SQL Injection |
|---|
| 描述 | A SQL Injection vulnerability exists in Daptin's aggregate API endpoint (`/aggregate/:typename`). The vulnerability occurs because user-supplied input is directly passed to `goqu.L()` (Literal function) without proper sanitization or validation, allowing attackers to execute arbitrary SQL queries.
In the file `server/resource/resource_aggregate.go`, the `column`, `group`, and `order` parameters from user requests are directly interpolated into SQL queries using `goqu.L()`:
```go
// Lines 139-141 in resource_aggregate.go
if strings.Index(project, " as ") > -1 {
parts := strings.Split(project, " as ")
projectionsAdded = append(projectionsAdded, goqu.L(parts[0]).As(parts[1]))
} else {
projectionsAdded = append(projectionsAdded, goqu.L(project))
}
```
The `goqu.L()` function treats input as a raw SQL literal, bypassing all query parameterization and escaping mechanisms.
|
|---|
| 来源 | ⚠️ https://note-hxlab.wetolink.com/share/yMZ8oEgMTAur |
|---|
| 用户 | hiro (UID 93548) |
|---|
| 提交 | 2025-12-19 08時04分 (8 月前) |
|---|
| 管理 | 2026-01-02 11時08分 (14 days later) |
|---|
| 状态 | 已接受 |
|---|
| VulDB条目 | 339384 [Daptin 0.10.3 Aggregate API resource_aggregate.go goqu.L column/group/order SQL注入] |
|---|
| 积分 | 20 |
|---|