BillaBear is Vulnerable to SQL Injection in the EventRepository
The advisory, in context
BillaBear (all versions prior to Jan 2026) contains a SQL Injection vulnerability in the EventRepository. User-controlled input from metric filter names and aggregation properties is directly interpolated into SQL queries using sprintf() without proper sanitization or identifier quoting. Although filter values are parameterized, the filter identifiers (keys) are not. An authenticated attacker with ROLE_ACCOUNT_MANAGER permissions can exploit this to execute arbitrary SQL commands.
Affected packages
Start with the recorded fix for your release branch. Check your installed version and test compatibility before upgrading. Fixing this advisory does not rule out other vulnerabilities in the release.
Earlier releases through 2025.01.03 (inclusive)
No fix recorded for this interval.
17 explicitly affected versions
2023.04.01, 2023.04.02, 2023.04.03, 2024.01.01, 2024.01.02, 2024.01.03, 2025.01.01, 2025.01.02, 2025.01.03, v1.0.0, v1.0.1, v1.0.2, v1.0.3, v1.1.0, v1.1.1, v1.1.2, v1.1.3
View affected-version evidence
{
"ranges": [
{
"events": [
{
"introduced": "0"
},
{
"last_affected": "2025.01.03"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"2023.04.01",
"2023.04.02",
"2023.04.03",
"2024.01.01",
"2024.01.02",
"2024.01.03",
"2025.01.01",
"2025.01.02",
"2025.01.03",
"v1.0.0",
"v1.0.1",
"v1.0.2",
"v1.0.3",
"v1.1.0",
"v1.1.1",
"v1.1.2",
"v1.1.3"
]
}