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.
Published: 2026-08-05
Score: 9.8 Critical
EPSS: < 1% Very Low
KEV: No
Impact: n/a
Action: n/a
AI Analysis

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.

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

Remediation

No vendor fix or workaround currently provided.

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 yet.

History

Mon, 10 Aug 2026 12:00:00 +0000

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.

Mon, 10 Aug 2026 11:30:00 +0000

Type Values Removed Values Added
Title IOTSmartHome: Unauthenticated SQL Injection via lastLogin Cookie IOTSmartHome - Unauthenticated SQL Injection via lastLogin Cookie

Fri, 07 Aug 2026 11:45:00 +0000

Type Values Removed Values Added
First Time appeared Thebradleysanders
Thebradleysanders iotsmarthome
Vendors & Products Thebradleysanders
Thebradleysanders iotsmarthome

Wed, 05 Aug 2026 13:30:00 +0000

Type Values Removed Values Added
Metrics ssvc

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


Wed, 05 Aug 2026 11:15:00 +0000

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'}


Subscriptions

Thebradleysanders Iotsmarthome
cve-icon MITRE

Status: PUBLISHED

Assigner: TuranSec

Published:

Updated: 2026-08-10T11:45:27.796Z

Reserved: 2026-08-05T10:53:53.175Z

Link: CVE-2026-71231

cve-icon Vulnrichment

Updated: 2026-08-05T12:52:49.815Z

cve-icon NVD

Status : Received

Published: 2026-08-05T11:16:25.740

Modified: 2026-08-10T12:17:25.533

Link: CVE-2026-71231

cve-icon Redhat

No data.

cve-icon OpenCVE Enrichment

Updated: 2026-08-10T22:30:06Z

Weaknesses
  • CWE-89

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