itsourcecode School Management System SQL Injection Vulnerability in Setting Handler

A SQL injection vulnerability exists in the itsourcecode School Management System version 1.0, specifically within the Setting Handler component. The issue is located in the file '/settings/index.php', where the 'id' parameter can be manipulated to inject malicious SQL queries. This vulnerability can be exploited remotely without authentication, allowing attackers to interfere with database operations and potentially access or modify sensitive information.

Impact

Exploitation of this vulnerability allows for SQL injection, where attackers can manipulate database queries. This could lead to unauthorized data access, data modification, and in some cases, executing administrative operations on the database.

Reproduction

The vulnerability can be reproduced by sending a GET request to '/ramonsys/settings/index.php' with the 'view' parameter set to 'edit' and the 'id' parameter manipulated to include a SQL injection payload. The injection can be verified by using a time-based blind SQL injection technique, such as adding 'AND (SELECT 5567 FROM (SELECT(SLEEP(5)))LSGs)' to the 'id' parameter, which would cause a delay in the response time.

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 user input conforms to expected formats. Minimizing database user permissions and conducting regular security audits can also help mitigate such vulnerabilities.