CodeAstro Pharmacy Management System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in CodeAstro Pharmacy Management System version 1.0. The issue resides in the Login component, specifically within the 'index.php' file. The vulnerability allows remote attackers to inject malicious SQL queries through the 'username' parameter, exploiting insufficient input validation. This could lead to unauthorized database access, data manipulation, and exposure of sensitive information.

Impact

Exploitation of this vulnerability allows for unauthorized database access, manipulation of data, and leakage of sensitive information. It poses a significant threat to system security and data integrity.

Reproduction

The vulnerability can be reproduced by sending a POST request to 'index.php' with the 'username' parameter. Injected SQL payloads can be used to exploit the time-based blind SQL injection vulnerability, such as using a payload that includes a SQL injection command that causes a delay, indicating the injection was successful.

Remediation

To address this vulnerability, it is recommended to use prepared statements and parameter binding to prevent SQL injection, validate and filter user input, minimize database user permissions, and conduct regular security audits.