CVE-2021-47811

id: cve-2021-47811

info:
  name: grocerycrud grocery_crud - Security Advisory & Vulnerability Scan
  author: cybervault-security-intel
  severity: critical
  description: |
    Automated signature & scanner for CVE-2021-47811 affecting grocerycrud grocery_crud.
    Evaluation: Grocery Crud 1.6.4 contains a SQL injection vulnerability in the order_by parameter that allows remote attackers to manipulate database queries. Attac...
  reference:
    - https://cybervault-cve.pages.dev/cve/CVE-2021-47811
  classification:
    cvss-metrics: CVSS:3.1/CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:N
    cvss-score: 9.1
    cve-id: CVE-2021-47811
    cwe-id: CWE-89
  tags: cve,cve-2021-47811,grocerycrud,grocery_crud,critical

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

# Proof-of-Concept Exploit & Verification Probe for CVE-2021-47811
# Target: grocerycrud grocery_crud | CVSS: 9.1 (CRITICAL)
# Educational & Security Audit Purpose Only

import requests
import sys

def verify_vulnerability(target_url):
    print(f"[*] Auditing {target_url} for CVE-2021-47811 (grocerycrud grocery_crud)...")
    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 grocerycrud grocery_crud scope (*).")
        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-2021-47811
# 1. Update package via distribution package manager:
sudo apt-get update && sudo apt-get --only-upgrade install grocery_crud 2>/dev/null || \
sudo dnf upgrade grocery_crud 2>/dev/null || \
sudo yum update grocery_crud

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

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