CVE Professor — Güvenlik Açığı Takip & Analiz
›
CVE-2026-63224

CWE-89

BELİRSİZ CVSS 0 ⚡ EPSS 0.3% NVD

OpenRemote is an open-source internet-of-things platform. Prior to 1.26.0, the `datapoint export` API constructs `CSV crosstab` SQL by concatenating an `asset name` and `attribute name` into a `COPY` query that uses `crosstab` and streams `TO STDOUT`. The `asset name` enters both a double-quoted column identifier and a category query enclosed by the fixed `$cat$` delimiter. Escaping single quotes in one string context does not escape embedded double quotes in identifiers or protect that dollar-quote boundary. An authenticated user permitted to create or rename an asset and read/export datapoints for one of its attributes can store SQL metacharacters in the name and request a `crosstab` export, causing injected SELECT output to be returned in the normal ZIP/CSV response. This enables database exfiltration without direct database or filesystem access or token forgery. In a multi-tenant deployment it can expose other tenants' data if the manager's database role can read shared tables; integrity and availability effects are not established by the demonstrated read primitive. This issue is fixed in version 1.26.0.

Yayınlanma 30.10.2026
ISO Tarih 2026-10-30
Kaynak NVD
EPSS — Exploit Olasılık Skoru
0.3%
30 günlük olasılık
Tüm CVElerin 27. yüzdeliğinde — Bu açığın istismar edilme ihtimali çoğu CVEden yüksek.
AI Güvenlik Analizi

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
CVE-2026-63224
CVSS 0/10 · BELİRSİZ · 30.10.2026
CWE: CWE-89
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🎯 AÇIK NEDİR?
SQL Injection (SQLi)
Açıklama: OpenRemote is an open-source internet-of-things platform. Prior to 1.26.0, the datapoint export API constructs CSV crosstab SQL by concatenating an asset name and attribute name into a COPY query that uses crosstab and streams TO STDOUT. The asset name enters both a double-quoted column identifier and a category query enclosed by the fixed $cat$ delimiter.

⚡ 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ı]

Hedef Keşif Sorguları
CVSS Skoru
0 / 10 · CVSS BELİRSİZ
Zayıflık Türleri (CWE)
CWE-89
İlgili CVE'ler
10.0
CVE-2026-124815
The Clockinator Lite WordPress plugin before 1.1.0 does not restrict access to several of its record deletion
10.0
CVE-2026-105781
Adobe Campaign Classic (ACC) is affected by an Improper Neutralization of Special Elements used in an SQL Comm
10.0
CVE-2026-79848
Vulnerabilities in the affected interface of AOS-8 could allow an unauthenticated remote attacker to conduct S
10.0
CVE-2026-79849
Vulnerabilities in the affected interface of AOS-8 could allow an unauthenticated remote attacker to conduct S
10.0
CVE-2026-55572
e107 is a content management system (CMS). Prior to 2.3.7, the bundled alt_auth plugin's otherdb and e107db au