GHSA-f2mf-q878-gh58 Parsl Monitoring Visualization Vulnerable to SQL Injection

• PyPI parsl: < 2026.01.05 → fixed in 2026.01.05

Affected Product: Parsl (Python Parallel Scripting Library) Component: parsl.monitoring.visualization Vulnerability Type: SQL Injection (CWE-89) Severity: High (CVSS Rating Recommended: 7.5 - 8.6) URL: https://github.com/Parsl/parsl/blob/master/parsl/monitoring/visualization/views.py Summary A SQL Injection vulnerability exists in the parsl-visualize component of the Parsl library. The application constructs SQL queries using unsafe string formatting (Python % operator) with user-supplied input (workflow_id) directly from URL routes. This allows an unauthenticated attacker with access to the visualization dashboard to inject arbitrary SQL commands, potentially leading to data exfiltration or denial of service against the monitoring database. Root Cause Analysis The vulnerability is located in parsl/monitoring/visualization/views.py. Multiple route handlers take the workflow_id parameter from the URL and inject it directly into a raw SQL query string without sanitization or parameterization. Vulnerable Code Snippet 1 ``` query = """SELECT task.task_id, task.task_func_name, task.task_depends, status.task_status_name FROM task LEFT JOIN status ON task.task_id = status.task_id AND task.run_id = status.run_id AND status.timestamp = (SELECT MAX(status.timestamp) FROM status WHERE status.task_id = task.task_id and status.run_id = task.run_id ) WHERE task.run_id='%s'""" % (workflow_id) ``` Vulnerable Code Snippet 2 ``` df_task_tries = pd.read_sql_query("""SELECT ... WHERE task.task_id = try.task_id AND task.run_id='%s' and try.run_id='%s'""" % (workflow_id, workflow_id), db.engine) # :8080/workflow/'%20AND%20'1'='0/dag_group_by_states ` Test 2: Boolean TRUE (Graph Reappears) Injecting a true condition (1=1) restores the query logic, causing the graph to render correctly. `http://:8080/workflow/'%20AND%20'1'='1/dag_group_by_states `