CodeAstro Leave Management System SQL Injection Vulnerability

A SQL injection vulnerability has been identified in CodeAstro Leave Management System version 1.0, specifically in the file '/admin/add_leave.php'. This vulnerability allows remote attackers to manipulate the 'type_of_leave' parameter, injecting malicious SQL code that could be executed by the database. The lack of proper input validation and sanitization enables this exploitation, potentially leading to unauthorized database access, data manipulation, and leakage of sensitive information.

Impact

Exploitation of this vulnerability allows for SQL injection, which could be used to access, modify, or delete database information. Additionally, such vulnerabilities can sometimes be leveraged to execute administrative operations on the database or the underlying system.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/LeaveManagement-PHP/admin/add_leave.php' with the 'type_of_leave' parameter. The injection can be verified by using payloads that exploit SQL injection, such as those that cause error messages or manipulate SQL query execution, such as time-based or boolean-based blind injection techniques.

Remediation

To address this vulnerability, it is recommended to use prepared statements and parameter binding to prevent SQL injection. Input validation and filtering should be implemented to ensure user input conforms to expected formats. Additionally, minimize database user permissions and conduct regular security audits.