clickhouse-unauth-api: ClickHouse API Database Interface - Improper Authorization

id: clickhouse-unauth-api

info:
  name: ClickHouse API Database Interface - Improper Authorization
  author: DhiyaneshDk
  severity: high
  description: Clickhouse API Database is exposed.
  reference:
    - https://github.com/luck-ying/Library-POC/blob/master/ClickHouse%E6%95%B0%E6%8D%AE%E5%BA%93/ClickHouse%E6%95%B0%E6%8D%AE%E5%BA%93%208123%E7%AB%AF%E5%8F%A3%E7%9A%84%E6%9C%AA%E6%8E%88%E6%9D%83%E8%AE%BF%E9%97%AE.py
    - https://github.com/PeiQi0/PeiQi-WIKI-Book/blob/main/docs/redteam/vulnerability/unauthorized/ClickHouse%208123%E7%AB%AF%E5%8F%A3.md?plain=1
  classification:
    cpe: cpe:2.3:a:clickhouse:clickhouse:*:*:*:*:*:*:*:*
  metadata:
    verified: true
    max-request: 1
    vendor: clickhouse
    product: clickhouse
    shodan-query: "X-ClickHouse-Summary"
    fofa-query: "X-ClickHouse-Summary"
  tags: misconfig,clickhouse,unauth,disclosure,vuln

http:
  - method: GET
    path:
      - "{{BaseURL}}/?query=SHOW%20DATABASES"

    matchers-condition: and
    matchers:
      - type: word
        part: body
        words:
          - 'default'
          - 'system'
        condition: and

      - type: word
        part: header
        words:
          - 'text/tab-separated-values'

      - type: status
        status:
          - 200
# digest: 4a0a004730450220207ff6325cd9603cd52f9a025d70be35c63e0e28096f3b9a069eead345e36c9902210089b4176a0b22c49a3f4910186dc8f41549944cdba5a423afcf130998f62fe77f:922c64590222798bb761d5b6d8e72950