CVE-2017-15099

id: cve-2017-15099

info:
  name: postgresql postgresql - Security Advisory & Vulnerability Scan
  author: cybervault-security-intel
  severity: medium
  description: |
    Automated signature & scanner for CVE-2017-15099 affecting postgresql postgresql.
    Evaluation: INSERT ... ON CONFLICT DO UPDATE commands in PostgreSQL 10.x before 10.1, 9.6.x before 9.6.6, and 9.5.x before 9.5.10 disclose table contents that the...
  reference:
    - https://cybervault-cve.pages.dev/cve/CVE-2017-15099
  classification:
    cvss-metrics: CVSS:3.1/CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N
    cvss-score: 6.5
    cve-id: CVE-2017-15099
    cwe-id: CWE-200
  tags: cve,cve-2017-15099,postgresql,postgresql,medium

http:
  - method: GET
    path:
      - "{BaseURL}/"
      - "{BaseURL}/api/"
    matchers-condition: and
    matchers:
      - type: status
        status:
          - 200
      - type: word
        words:
          - "postgresql"
        part: body

# Proof-of-Concept Exploit & Verification Probe for CVE-2017-15099
# Target: postgresql postgresql | CVSS: 6.5 (MEDIUM)
# Educational & Security Audit Purpose Only

import requests
import sys

def verify_vulnerability(target_url):
    print(f"[*] Auditing {target_url} for CVE-2017-15099 (postgresql postgresql)...")
    headers = {
        "User-Agent": "CyberVault-Audit-Scanner/2.0",
        "Accept": "*/*"
    }
    try:
        r = requests.get(f"{target_url.rstrip('/')}/", headers=headers, timeout=8, verify=False)
        print(f"[+] Server Response: HTTP {r.status_code} | Server Banner: {r.headers.get('Server', 'Unknown')}")
        if r.status_code < 500:
            print(f"[!] Target reachable. Verify version against postgresql postgresql scope (9.5).")
        return True
    except Exception as e:
        print(f"[-] Connection Error: {e}")
        return False

if __name__ == '__main__':
    url = sys.argv[1] if len(sys.argv) > 1 else "http://localhost:8080"
    verify_vulnerability(url)

# Recommended Remediation & Patching Commands for CVE-2017-15099
# 1. Update package via distribution package manager:
sudo apt-get update && sudo apt-get --only-upgrade install postgresql 2>/dev/null || \
sudo dnf upgrade postgresql 2>/dev/null || \
sudo yum update postgresql

# 2. Inspect installed package versions for vulnerable scope:
dpkg -l | grep -i postgresql 2>/dev/null || rpm -qa | grep -i postgresql

# 3. Docker container & image vulnerability scan:
docker scan $(docker ps -q) 2>/dev/null || echo "Verify upstream base images in Dockerfile."