CVE-2024-6956

6.3 MEDIUM

📋 TL;DR

This CVE describes a critical SQL injection vulnerability in itsourcecode University Management System 1.0, specifically in the /view_cgpa.php file via manipulation of the VR/VN argument. It allows remote attackers to execute arbitrary SQL commands, potentially compromising the database. Users of this software version are affected.

💻 Affected Systems

Products:
  • itsourcecode University Management System
Versions: 1.0
Operating Systems: Any OS running the software (typically web servers like Linux/Windows with PHP)
Default Config Vulnerable: ⚠️ Yes
Notes: The vulnerability is in a specific file (/view_cgpa.php) and requires the system to be deployed and accessible.

📦 What is this software?

⚠️ Risk & Real-World Impact

🔴

Worst Case

Full database compromise leading to data theft, manipulation, or deletion, and potential remote code execution on the underlying server.

🟠

Likely Case

Unauthorized access to sensitive student and university data stored in the database.

🟢

If Mitigated

Limited impact if input validation and parameterized queries block the injection, though the vulnerability remains present.

🌐 Internet-Facing: HIGH, as the attack can be launched remotely against exposed systems.
🏢 Internal Only: MEDIUM, as internal attackers could exploit it if the system is accessible on the network.

🎯 Exploit Status

Public PoC: ⚠️ Yes
Weaponized: LIKELY
Unauthenticated Exploit: ⚠️ Yes
Complexity: LOW

Exploit details are publicly disclosed on GitHub, making it easy for attackers to leverage.

🛠️ Fix & Mitigation

✅ Official Fix

Patch Version: Unknown

Vendor Advisory: None known

Restart Required: No

Instructions:

No official patch is available; rely on workarounds or consider replacing the software.

🔧 Temporary Workarounds

Input Validation and Sanitization

all

Implement strict input validation and sanitization for the VR/VN parameters in /view_cgpa.php to block SQL injection attempts.

Modify the PHP code to use prepared statements with parameterized queries (e.g., using PDO or mysqli).

Web Application Firewall (WAF) Rules

all

Deploy a WAF with rules to detect and block SQL injection patterns targeting /view_cgpa.php.

Configure WAF to filter malicious SQL patterns in requests to the vulnerable endpoint.

🧯 If You Can't Patch

  • Isolate the system on a segmented network to limit access and reduce attack surface.
  • Monitor logs and network traffic for unusual SQL queries or access attempts to /view_cgpa.php.

🔍 How to Verify

Check if Vulnerable:

Test the /view_cgpa.php endpoint with SQL injection payloads in the VR/VN parameters (e.g., ' OR '1'='1) and check for database errors or unexpected responses.

Check Version:

Check the software version in its configuration files or documentation; for web-based systems, inspect source code or admin panels.

Verify Fix Applied:

After applying workarounds, retest with the same payloads to ensure they are blocked or sanitized without errors.

📡 Detection & Monitoring

Log Indicators:

  • Unusual SQL error messages in web server logs (e.g., PHP errors related to database queries) for /view_cgpa.php.
  • Multiple failed login or query attempts with SQL-like strings in parameters.

Network Indicators:

  • HTTP requests to /view_cgpa.php containing SQL keywords (e.g., SELECT, UNION, DROP) in the VR/VN parameters.

SIEM Query:

Example: source="web_server" AND url="/view_cgpa.php" AND (param="VR" OR param="VN") AND (query="*SELECT*" OR query="*UNION*" OR query="*OR*1*" OR status>=500)

🔗 References

📤 Share & Export