| 제목 | github Cafe Management System (CafeManagement) - Neethuharii 1.0 Unauthenticated SQL Injection leading to Authentication Bypass |
|---|
| 설명 | The login handler CafePortalLogin.php builds its SQL query by directly concatenating the user-supplied uname (POST) parameter, with no prepared statement, escaping, or input validation:
$username = $_POST[‘uname’]; // raw, unsanitized
…
$sql = “SELECT * FROM register WHERE Username=’$username’”; // string concatenation
$result = mysqli_query($connection, $sql);
if (mysqli_num_rows($result) == 0) { $invalid_error = “Username does not exist”; }
else { $row = mysqli_fetch_assoc($result);
if ($row[‘Password’] == $password) { /* login success */ } }
The uname parameter is injectable. Because the fetched row’s Password column is later compared in PHP against the attacker-supplied password, a UNION SELECT allows the attacker to forge the password value and authenticate as any user — a full authentication bypass. The same flaw also permits full database extraction. |
|---|
| 원천 | ⚠️ https://medium.com/@mr.yk404/unauthenticated-sql-injection-leading-to-authentication-bypass-in-cafemanagement-php-e64abc2f52da |
|---|
| 사용자 | Yashkumar Keral (UID 99903) |
|---|
| 제출 | 2026. 07. 20. PM 05:57 (2 개월 ago) |
|---|
| 모더레이션 | 2026. 09. 23. PM 12:50 (2 months later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 408920 [Neethuharii CafeManagement Login CafePortalLogin.php uname SQL 주입] |
|---|
| 포인트들 | 20 |
|---|