itsourcecode Web-Based Internet Laboratory Management System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in itsourcecode Web-Based Internet Laboratory Management System version 1.0. The issue resides in the file '/enrollment/controller.php', where insufficient input validation allows attackers to inject malicious SQL queries through the 'action=delete&id=1' parameter. This vulnerability can be exploited remotely, without authentication, leading to unauthorized database access, data manipulation, and potential leakage of sensitive information.

Impact

Exploitation of this vulnerability allows for SQL injection, enabling attackers to interfere with the application's database queries. This could result in unauthorized data access, data modification or deletion, and in some cases, executing administrative operations on the database.

Reproduction

The vulnerability can be reproduced by sending a request to 'enrollment/controller.php' with the 'action' parameter set to 'delete' and the 'id' parameter set to a value that triggers the injection. The injection can be verified by using a time-based blind SQL injection payload, such as one that causes the database to pause execution for a few seconds before responding.

Remediation

To address this vulnerability, it is recommended to implement prepared statements and parameter binding to separate SQL code from user input, ensuring that injected data is not executed as part of the SQL command. Additionally, input validation and filtering should be applied to confirm that user inputs meet expected formats. Minimizing database user permissions and conducting regular security audits can further enhance the application's security.