OpenPanel before 3.0.0 ClickHouse SQL Injection via profile.values

Summary

OpenPanel before 3.0.0 contains an sql injection vulnerability that allows authenticated users to read cross-tenant data by supplying a crafted property parameter to profile.values. Attackers can inject a SELECT expression with their own FROM/WHERE clauses and comment out the project_id scope to exfiltrate other projects' profiles, events, and sessions.

Remediation

1. Inventory every Openpanel-dev openpanel deployment, including staging.
2. Upgrade Openpanel-dev openpanel to 3.0.0.
3. Confirm the running version after the upgrade.

References

• Patchhttps://github.com/Openpanel-dev/openpanel/commit/a2aa053cb23e92967e812d3be5fb0f1d606d9fdc
• Advisoryhttps://github.com/Openpanel-dev/openpanel/security/advisories/GHSA-4j6c-j6vc-xq96
• Advisoryhttps://www.vulncheck.com/advisories/openpanel-before-3.0.0-clickhouse-sql-injection-via-profile-values