CVE-2026-71231

IOTSmartHome - Unauthenticated SQL Injection via lastLogin Cookie

Published Aug 5, 2026 CVSS 3.1 · 9.8 Critical EPSS < 1% KEV · Not listed
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.

Analysis

AI-generated

Technical impact

The vulnerability resides in IOTSmartHome's login interface, where a base64‑decoded cookie value is concatenated directly into an SQL query without sanitization, enabling SQL injection. An attacker can set a specially crafted lastLogin cookie, base64‑encode an injection payload, and trigger a UNION-based clause that bypasses authentication and retrieves user data, including credentials. This results in full unauthenticated access to sensitive information. The weakness corresponds to CWE‑89. The impact is both unauthorized access and data exposure.

Affected Systems

Affected vendor and product: thebradleysanders IOTSmartHome. Specific version information was not disclosed in the advisory, so all released releases remain potentially exposed until a patch is applied.

Risk and Exploitability

The CVSS score of 9.8 marks this flaw as critical, and the EPSS score of 0.339% indicates a very low probability of exploitation. It is not yet listed in the CISA KEV catalog. Based on the description, the likely attack vector is an unauthenticated client manipulating the lastLogin cookie sent via a browser to the application. Once injected, the attacker can bypass authentication and extract arbitrary data. The severity is high, but due to the very low EPSS score, the actual exploitation risk is considered low.

Remediation

No solution or workaround provided in the CVE record.

OpenCVE Recommended Actions

  • Apply the vendor’s latest patch or update the IOTSmartHome firmware to a version where the SQL injection has been fixed.
  • If a patch is not yet available, enforce strict validation of the lastLogin cookie on the server side before decoding it; reject malformed or suspicious values.
  • If customizing the firmware is possible, limit the length and character set of the lastLogin cookie or disable the cookie‑based authentication path until a secure implementation is deployed.

Generated by OpenCVE AI on August 10, 2026 at 22:22 UTC.

Tracking

Sign in to view the affected projects.

Advisories

No advisories available
History
Type Values Removed Values Added
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. An unauthenticated attacker can set a lastLogin cookie containing a base64-encoded SQL injection payload (e.g. base64("' OR '1'='1")) to bypass authentication and, via UNION-based injection, extract arbitrary data including user credentials. 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.
Type Values Removed Values Added
Title IOTSmartHome: Unauthenticated SQL Injection via lastLogin Cookie IOTSmartHome - Unauthenticated SQL Injection via lastLogin Cookie
Type Values Removed Values Added
First Time appeared Thebradleysanders
Thebradleysanders iotsmarthome
Vendors & Products Thebradleysanders
Thebradleysanders iotsmarthome
Type Values Removed Values Added
Metrics ssvc

{'options': {'Automatable': 'yes', 'Exploitation': 'none', 'Technical Impact': 'total'}, 'version': '2.0.3'}

Type Values Removed Values Added
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. An unauthenticated attacker can set a lastLogin cookie containing a base64-encoded SQL injection payload (e.g. base64("' OR '1'='1")) to bypass authentication and, via UNION-based injection, extract arbitrary data including user credentials.
Title IOTSmartHome: Unauthenticated SQL Injection via lastLogin Cookie
Weaknesses CWE-89
References
Metrics cvssV3_1

{'score': 9.8, 'vector': 'CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H'}

Weaknesses
  • CWE-89

    Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Sources

Status
PUBLISHED
Assigner
TuranSec
Published
Updated
Aug 10, 2026, 11:45 AM
Reserved
Aug 5, 2026, 10:53 AM
Status
Deferred
Published
Aug 5, 2026, 11:16 AM
Modified
Oct 24, 2026, 3:10 PM