CWE-89
Lightdash is an open source business intelligence platform. In affected versions through 0.3213.0, the dbt Cloud webhook `POST /api/v1/projects/{projectUuid}/dbt-cloud/webhook` has no authentication middleware or signature validation. In `packages/backend/src/controllers/projectController.ts`, `testWebhook()` accepts `accountId` and `runId` from a `job.run.completed` request and passes them to `createPreviewWithExplores()` in `packages/backend/src/services/ProjectService/ProjectService.ts`. These unsanitized values are interpolated into the server-side dbt Cloud API URL, which is requested with the victim project's API key in the `Authorization` header. Path traversal through `accountId` changes the requested path on `cloud.getdbt.com` without changing its host, so the credential-bearing request reaches an attacker-influenced path on that fixed host. The advisory claims API-key theft, but the supplied evidence does not establish that the attacker can observe the `Authorization` header. The unauthenticated webhook also allows preview creation. The target must be a `dbt Cloud IDE` project and the attacker must know its `projectUuid`; the UUID is not enumerable but can be discovered in shared or multi-tenant contexts. Version 0.3214.0 fixes identifier path traversal and verifies webhook HMAC signatures only when a secret is configured; without a secret, unsigned webhooks continue to be processed.
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
CVE-2026-61654
CVSS 0/10 · BELİRSİZ · 29.10.2026
CWE: CWE-89
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🎯 AÇIK NEDİR?
SQL Injection (SQLi)
Açıklama: Lightdash is an open source business intelligence platform. In affected versions through 0.3213.0, the dbt Cloud webhook POST /api/v1/projects/{projectUuid}/dbt-cloud/webhook has no authentication middleware or signature validation. In packages/backend/src/controllers/projectController.ts, testWebhook() accepts accountId and runId from a job.run.completed request and passes them to …
⚡ SALDIRI ZİNCİRİ
Saldırı adımları:
1. Hedef uygulamada kullanıcı girdisinin doğrudan SQL sorgusuna dahil edildiği parametre tespit edilir (URL parametresi, form alanı, HTTP başlığı).
2. Temel enjeksiyon testi: ' OR '1'='1 ile hata veya anormal davranış aranır.
3. Boolean-based blind SQLi ile veri okunur: ' AND SUBSTRING(password,1,1)='a
4. Time-based blind ile sunucu geciktirilir: '; WAITFOR DELAY '0:0:5'--
5. UNION-based ile tablo yapısı ve veri çekilir: ' UNION SELECT table_name,null FROM information_schema.tables--
6. Araç: sqlmap -u 'URL' --dbs --dump --level=5 --risk=3
7. Erişim sağlanınca: DB dump, admin şifresi kırma, webshell yükleme (INTO OUTFILE).
🔧 Araçlar: sqlmap, Burp Suite (Intruder), manual
🗺️ MITRE ATT&CK: T1190 (Exploit Public-Facing Application), T1078 (Valid Accounts)
🌍 GERÇEK DÜNYA ETKİSİ
🛡️ ÇÖZÜM VE MİTİGASYON
→ Üretici tarafından yayınlanan yamayı uygula.
→ Prepared statement ve parameterized query kullan.
→ WAF kuralı ekle, anormal trafik için IDS alert oluştur.
⚠️ ACİLİYET
📌 Düşük öncelik — rutin güncelleme yeterli.
────────────────────────────────────────
[Kural Tabanlı Analiz] [💡 config.json dosyasına ai_key (Claude: sk-ant-... veya Groq: gsk_...) ekleyerek gerçek AI analizi kullanabilirsiniz]
[⚠️ AI key mevcut ancak istek başarısız — kural tabanlı analiz kullanıldı]