Description
Yiuman citrus through 0.15.0 contains an ORDER BY sql injection vulnerability in the citrus-support generic query framework that allows users to inject SQL via the sortBy request parameter. Attackers can reach any generic list route of controllers extending BaseQueryController or BaseQueryRestful to append unvalidated SQL to the ORDER BY clause and extract database contents using boolean- or time-based blind techniques.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| Yiuman | citrus | ≤ 0.15.0 | — |
References
- https://hackmd.io/@1ExmmukzRMWN7B4gQ4W-4Q/citrus-generic-query-orderby-sqli third-party-advisory
- https://github.com/Yiuman/citrus/blob/0.15.0/citrus-support/src/main/java/com/github/yiuman/citrus/support/crud/query/QueryHelper.java#L123-L129 technical-description
- https://github.com/Yiuman/citrus product
- VulnCheck Advisory: Yiuman citrus through 0.15.0 ORDER BY SQL Injection via sortBy Parameter third-party-advisory