itsourcecode School Management System SQL Injection Vulnerability

A SQL injection vulnerability exists in itsourcecode School Management System version 1.0, specifically within the file '/ramonsys/course/index.php'. The vulnerability arises because the application does not properly sanitize or validate the 'id' parameter in GET requests, allowing attackers to inject malicious SQL code. This flaw can be exploited remotely without authentication.

Impact

Exploitation of this vulnerability allows attackers to execute arbitrary SQL commands, potentially leading to unauthorized database access, data manipulation, and in some cases, executing commands on the server.

Reproduction

The vulnerability can be reproduced by sending a GET request to '/ramonsys/course/index.php' with the 'view' parameter set to 'edit' and the 'id' parameter manipulated to include a crafted SQL payload. This injection takes advantage of time-based blind SQL injection techniques, such as using the SQL 'SLEEP' function to demonstrate the injection's success.

Remediation

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.