Description
Lotus through 0.10.2 contains an sql injection vulnerability that allows authenticated organization users to inject SQL by registering crafted subscription_filter_keys that bypass keyword-only validation. Attackers can create subscriptions using the malicious key, which is rendered as an unquoted group-by identifier, to inject SQL into usage aggregation queries against the shared multi-tenant database.
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/serializers/model_serializers.py#L518-L534 technical-description
- https://github.com/uselotus/lotus product
- VulnCheck Advisory: Lotus through 0.10.2 SQL Injection via Subscription Filter Keys third-party-advisory