CVE-2024-39250: EfroTech Timetrax v8.3 - Sql Injection

id: CVE-2024-39250

info:
  name: EfroTech Timetrax v8.3 - Sql Injection
  author: s4e-io,efran
  severity: high
  description: |
    EfroTech Timetrax v8.3 was discovered to contain an unauthenticated SQL injection vulnerability via the q parameter in the search web interface.
  impact: |
    Unauthenticated attackers can execute SQL injection attacks to extract or modify sensitive timetrax database information.
  remediation: |
    Update EfroTech Timetrax to a version later than v8.3 that patches the SQL injection vulnerability.
  reference:
    - https://nvd.nist.gov/vuln/detail/CVE-2024-39250
    - https://www.tenable.com/cve/CVE-2024-39250
    - https://github.com/efrann/CVE-2024-39250
    - https://vuldb.com/?id.272268
  classification:
    epss-score: 0.85497
    epss-percentile: 0.99338
  metadata:
    vendor: efroTech
    product: timetrax
    fofa-query: icon_hash="-661694518"
  tags: cve,cve2024,sqli,timetrax,vuln

flow: http(1) && http(2)

http:
  - raw:
      - |
        GET /Login.aspx HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - 'contains(body,"TimeTrax - Cloud HR Software")'
          - 'contains(content_type, "text/html")'
          - "status_code == 200"
        condition: and
        internal: true

  - raw:
      - |
        GET /search.aspx?q=' HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - 'contains_all(body,"Incorrect syntax near","Unclosed quotation mark after the character string")'
          - 'contains(content_type, "text/html")'
          - "status_code == 500"
        condition: and
# digest: 4a0a0047304502206cb8726f0831e0378d93d38b341e19f071e260d983510f9bac046ff012e153f4022100b4cd9438dd579efb616312690e90ecbcf098d1e8ba2bf61669a30a48147c2b1d:922c64590222798bb761d5b6d8e72950