CodePanda Source Canteen Management System SQL Injection Vulnerability in Login API

A SQL injection vulnerability exists in CodePanda Source Canteen Management System version 1.0, specifically within the '/api/login.php' file. The issue arises because the 'username' parameter can be manipulated to inject malicious SQL queries. This exploitation occurs remotely and without authentication, allowing attackers to access and manipulate the database, potentially leading to unauthorized data access, data modification, and disruption of services.

Impact

Exploitation of this vulnerability allows for unauthorized SQL query manipulation, database access, and could lead to unauthorized data access, data modification, and service disruption.

Reproduction

To reproduce this vulnerability, send a POST request to '/api/login.php' with the 'username' parameter. Inject a payload that exploits the SQL injection vulnerability, such as one that uses a time-based blind SQL injection technique, like adding a SQL injection payload that includes a time delay command, such as 'SLEEP(5)'. This demonstrates the injection's effectiveness by causing a delay in the response, indicating successful exploitation.

Remediation

It is recommended to use prepared statements and parameter binding to prevent SQL injection. Additionally, input validation and filtering should be implemented to ensure that user input meets expected formats, blocking malicious data. Finally, database user permissions should be minimized, ensuring that the account used for database connections has only the necessary privileges.