Description
SQLBot through 1.10.3 contains a path traversal vulnerability in the importToDb endpoint that allows authenticated workspace administrators to read files via an unsanitized filePath parameter. Attackers can supply absolute paths or ../ sequences to import CSV or spreadsheet files, including other workspaces' uploads and server files, into queryable excel_* tables.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| dataease | SQLBot | ≤ 1.10.3 | — |
References
- GitHub Issue #1434 issue-tracking
- https://github.com/dataease/SQLBot product
- Fix commit patch
- https://github.com/dataease/SQLBot/blob/v1.10.3/backend/apps/datasource/api/datasource.py#L580-L585 technical-description
- https://github.com/dataease/SQLBot/blob/v1.10.3/backend/apps/datasource/utils/excel.py#L48-L57 technical-description
- VulnCheck Advisory: SQLBot through 1.10.3 Path Traversal via datasource importToDb Endpoint third-party-advisory