Executive brief
Emlog is an open-source website building platform with an integrated AI Assistant. The AI Assistant's database query feature lacks CSRF protection and validation, allowing an attacker to trick a logged-in administrator into executing arbitrary SQL queries that can read and modify any database table except the blog content table. An attacker can exploit this to steal administrator password hashes, change user credentials, and gain complete administrative control of the website.
Technical details
This is a CSRF vulnerability combined with multiple authentication and authorization flaws in the AI Assistant's execute_tool endpoint (admin/ai.php). The vulnerability exploits the absence of CSRF token validation (no LoginAuth::checkToken() call), a missing SameSite attribute on the authentication cookie (enabling Chrome's Lax+POST grace period), and a hardcoded public confirmation string ("confirm") instead of a secret token. Read operations execute with no confirmation requirement, while write operations are protected only by the public string. The password redaction mechanism can be bypassed by aliasing password columns (e.g., SELECT password AS pwd_hash). An attacker delivers a forged cross-site request to a recently logged-in administrator, gaining full database read access (including password hashes) and write access to all tables except blog, enabling direct user table modification for account takeover. No patched version is available as of the advisory date.
Affected products
- Emlog Emlog 2.6.23 and earlier
Timeline
- 2026-08-14: disclosed: CVE-2026-73847 and GHSA-v6wr-4x55-7qp5 published