PeerBanHelper: SQL injection via ${field} interpolation in MyBatis mapper for analysis endpoint

Overview

PeerBanHelper automatically blocks unwanted, leeching, and abnormal BitTorrent peers using customizable and cloud rules. From 5.0.0 until 9.3.15, the /api/statistic/analysis/field endpoint accepts a crafted field query parameter from an authenticated user and passes it to countField or sumField. The mapField() method forwards unrecognized field names without sanitization, so unrecognized field names are interpolated into SQL through ${field} across the SQLite, MySQL, and PostgreSQL mappers. Successful exploitation can read all data in the PeerBanHelper database. This issue is fixed in version 9.3.15.

Affected

• PeerBanHelper >= 5.0.0, < 9.3.15

Remediation

Refer to the linked advisories for vendor-supplied fixes and affected version ranges.