Description
Lotus through 0.10.2 contains an sql injection vulnerability that allows authenticated organization users to execute arbitrary SQL by appending stacked statements to custom metric queries. Attackers can submit semicolon-separated SQL through POST /app/metrics/, bypassing first-statement-only validation, to read or modify data across all tenants.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| uselotus | lotus | ≤ 0.10.2 | — |
References
- https://hackmd.io/@leediay/BkUc3WL2Mx technical-description
- https://github.com/uselotus/lotus/blob/0.10.2/backend/metering_billing/aggregation/billable_metrics.py#L643-L656 technical-description
- https://github.com/uselotus/lotus product
- VulnCheck Advisory: Lotus through 0.10.2 SQL Injection via Custom SQL Billable Metrics third-party-advisory