{"id":1295,"cve":"CVE-2024-8055","cve_url":"https:\/\/www.cvedetails.com\/cve\/CVE-2024-8055\/","cwe":"CWE-89","cwe_number":89,"cwe_url":"https:\/\/cwe.mitre.org\/data\/definitions\/89","cvss_score":7.5,"published":"2025-03-20","owasp":"A03 Injection","odc":"Interface","cdc":"Incorrect Functionality","category":"Input Validation and Sanitization","subcategory":"SQL Injection","scope":"Remote","impact":"Data Theft","summary":"Vanna 0.6.3 SQL injection allows reading arbitrary local files via Snowflake database.","permalink":"https:\/\/netpack.pt\/vaitp\/vulnerability\/CVE-2024-8055\/","description":"Vanna v0.6.3 is vulnerable to SQL injection via Snowflake database in its file staging operations using the `PUT` and `COPY` commands. This vulnerability allows unauthenticated remote users to read arbitrary local files on the victim server, such as `\/etc\/passwd`, by exploiting the exposed SQL queries through a Python Flask API.","solution":"Upgrade to Vanna v0.6.4 or later.","affected_component":"Vanna","fixed_by_upgrading":true,"vulnerable_code":"import sqlite3\n\ndef get_user(user_id):\n    \"\"\"Get user - VULNERABLE to SQL injection\"\"\"\n    conn = sqlite3.connect('users.db')\n    cursor = conn.cursor()\n    \n    # VULNERABILITY: String concatenation in SQL\n    query = f\"SELECT * FROM users WHERE id = {user_id}\"\n    cursor.execute(query)\n    \n    result = cursor.fetchone()\n    conn.close()\n    return result\n\n# Example exploitation:\n# get_user(\"1 OR 1=1 --\")","patched_code":"import sqlite3\n\ndef get_user_secure(user_id):\n    \"\"\"Securely get user with parameterized query\"\"\"\n    try:\n        if not isinstance(user_id, int) or user_id <= 0:\n            return None\n        \n        conn = sqlite3.connect('users.db')\n        cursor = conn.cursor()\n        \n        # SECURE: Parameterized query\n        query = \"SELECT * FROM users WHERE id = ?\"\n        cursor.execute(query, (user_id,))\n        \n        result = cursor.fetchone()\n        conn.close()\n        return result\n    except Exception:\n        return None","payload_needed":true,"payload":"```\n;PUT file:\/\/\/etc\/passwd @%users; COPY INTO users FROM @%users;\n```","payload_status":"available","published_fix":[],"references":null}