CVE-2026-71231 IOTSmartHome - Unauthenticated SQL Injection via lastLogin Cookie
Unauthenticated attackers can execute arbitrary SQL commands via the lastLogin cookie, potentially accessing user data or taking over accounts.
- Exploited in the wild
- Not known
- Login needed
- Not needed
- Attackable
- Over the internet
- Victim action needed
- Not needed
- Fix
- None listed
What is CVE-2026-71231?
CVE-2026-71231 is a critical SQL injection vulnerability in thebradleysanders IOTSmartHome, published on 5 Aug 2026. An attacker can exploit it over the internet without logging in, with no action from the victim.
Official description
IOTSmartHome's gui/login.php checkCookie function builds an authentication query as SELECT * FROM users WHERE ID='<decoded lastLogin cookie>' after base64-decoding the client-supplied lastLogin cookie via safe_decode, which performs URL-safe base64 decoding with no sanitization of the decoded value before it is concatenated into the SQL string.
Weakness: CWE-89
Which versions are affected by CVE-2026-71231?
How do I fix CVE-2026-71231?
No fix has been published for CVE-2026-71231 yet. Limit exposure of the affected software until one is available.
Use parameterised queries everywhere and never build SQL by joining strings. Upgrade affected software first; a web application firewall only buys time. More about SQL injection.
Is CVE-2026-71231 being exploited?
There is no known exploitation of CVE-2026-71231 in the wild and no public exploit code.
Sources
Also known as GHSA-hchq-288f-9hjc.