GHSA-VQHW-XHFF-464Q
Langroid 0.69.18 SQL validator omits SQLite readfile() and writefile()
Texto original en inglés · Ver en español
CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:N
Fuente: GitHub
Ciclo de vida de la vulnerabilidad
| Fecha | Fase | Evento | Detalle |
|---|---|---|---|
| Divulgación | Publicada | GHSA-VQHW-XHFF-464Q divulgada · CVSS 7.4 (GitHub) | |
| Divulgación | Modificada | Última actualización del registro | |
| Remediación | Parche 0.69.19 | langroid · 0 d desde divulgación | |
| Monitoreo | Detectada | Ingresó al índice | |
| Monitoreo | Verificada | Última verificación contra las fuentes |
Summary
The SQLChatAgent validator allows SQLite readfile() and writefile() under the default SELECT-only policy, enabling arbitrary file read and arbitrary-content file write. Reporter credit: Gavin Blacklock (GitHub Epsilon0xCell).
Details
The SQLChatAgent validator enumerates dangerous functions per dialect and blocks SQLite load_extension and ATTACH, but allows readfile() and writefile() under the default SELECT-only policy: arbitrary file read and arbitrary-content file write. Confirmed by a local fixture reproduction; validation was local-lab only, never against any production system. Suggested fix: add readfile and writefile to the SQLite denylist and default-deny unlisted functions. Reporter credit: Gavin Blacklock (GitHub Epsilon0xCell).
Proof of concept
In a local lab fixture only, configure Langroid 0.69.18 SQLChatAgent with the default SELECT-only SQLite policy and submit queries using readfile() to read a local test file and writefile() to write attacker-controlled content to a local test path. Observe that both functions are permitted by the validator, unlike load_extension and ATTACH. No production system was involved.
Impact
CWE-184 Incomplete List of Disallowed Inputs. An attacker able to influence SQLChatAgent queries can read arbitrary files accessible to the application and write arbitrary content to files, with high confidentiality and integrity impact. This affects Langroid 0.69.18 SQLite deployments under the default SELECT-only policy.
Incluye detalles técnicos publicados por el investigador. Úselos solo para validar y corregir sus propios sistemas.
Desglose de métricas
Rangos afectados
Estado del parche por paquete
| Paquete / producto | Estado | Corregida en | Desde divulgación | Última versión |
|---|---|---|---|---|
pypilangroid |
Corregida | 0.69.19 | 0 d | 0.69.22 no afectada |
0.69.19Arsenal público
Sin exploits, módulos ni PoC públicos conocidos a la fecha de verificación.
https://github.com/langroid/langroid/security/advisories/GHSA-vqhw-xhff-464qLas referencias externas se muestran para copiar: cve.llama.ec no lo redirige a otros sitios.
