CVE-2024-12931

6.3 MEDIUM

📋 TL;DR

This critical SQL injection vulnerability in Simple Admin Panel 1.0 allows remote attackers to execute arbitrary SQL commands by manipulating the 'size' parameter in /addCatController.php. This can lead to unauthorized data access, modification, or deletion. All users running Simple Admin Panel 1.0 are affected.

💻 Affected Systems

Products:
  • Simple Admin Panel
Versions: 1.0
Operating Systems: All
Default Config Vulnerable: ⚠️ Yes
Notes: Affects the PHP-based Simple Admin Panel from code-projects.org. The vulnerability exists in the default installation.

📦 What is this software?

⚠️ Risk & Real-World Impact

🔴

Worst Case

Complete database compromise including data theft, data destruction, and potential server takeover via SQL injection to execute system commands.

🟠

Likely Case

Unauthorized access to sensitive data, privilege escalation, and potential data manipulation or deletion.

🟢

If Mitigated

Limited impact with proper input validation and database permissions, potentially only error messages or failed queries.

🌐 Internet-Facing: HIGH
🏢 Internal Only: MEDIUM

🎯 Exploit Status

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

Exploit details are publicly disclosed on vuldb.com. SQL injection vulnerabilities are commonly weaponized.

🛠️ Fix & Mitigation

✅ Official Fix

Patch Version: Unknown

Vendor Advisory: None found

Restart Required: No

Instructions:

No official patch available. Consider upgrading to a newer version if available, or implement workarounds.

🔧 Temporary Workarounds

Input Validation and Sanitization

all

Add proper input validation and parameterized queries to /addCatController.php

Edit /addCatController.php to use prepared statements: $stmt = $conn->prepare('INSERT INTO table (size) VALUES (?)'); $stmt->bind_param('s', $size);

Web Application Firewall (WAF)

all

Deploy a WAF to block SQL injection attempts

🧯 If You Can't Patch

  • Restrict network access to the admin panel to trusted IPs only
  • Implement database user with minimal permissions (read-only if possible)

🔍 How to Verify

Check if Vulnerable:

Check if /addCatController.php exists and accepts 'size' parameter without proper validation. Test with SQL injection payloads like: size=1' OR '1'='1

Check Version:

Check the source code or documentation for version information. The vulnerable version is 1.0.

Verify Fix Applied:

Test the same SQL injection payloads after implementing fixes - they should return errors or be blocked without executing SQL.

📡 Detection & Monitoring

Log Indicators:

  • Unusual SQL queries in database logs
  • Multiple failed login attempts or parameter manipulation in web server logs for /addCatController.php

Network Indicators:

  • HTTP requests to /addCatController.php with SQL keywords in parameters (UNION, SELECT, INSERT, etc.)

SIEM Query:

source="web_server" AND uri="/addCatController.php" AND (param="size" AND value MATCHES "'.*OR.*|UNION|SELECT.*FROM")

🔗 References

📤 Share & Export