ET WEB_SPECIFIC_APPS Grafana Post-Authentication DuckDB SQL Injection (CVE-2024-9264)

alert http any any -> $HOME_NET any (
    msg:"ET WEB_SPECIFIC_APPS Grafana Post-Authentication DuckDB SQL Injection (CVE-2024-9264)";
    flow:established,to_server;
    http.method;
    content:"POST";
    http.uri;
    content:"/api/ds/query|3f|"; startswith;
    content:"ds|5f|type|3d 5f 5f|expr|5f 5f|"; fast_pattern;
    content:"expression|3d|true";
    http.request_body;
    content:"|22|expression|22 3a|";
    pcre:"/^\x20?\x22[^\x22]*?(?:(?:S(?:HOW\x20(?:C(?:UR(?:DAT|TIM)E|HARACTER\x20SET)|(?:VARI|T)ABLES)|ELECT\x20(?:FROM|USER))|U(?:NION\x20SELEC|PDATE\x20SE)T|DELETE\x20FROM|INSERT\x20INTO)|S(?:HOW.+(?:C(?:HARACTER.+SET|UR(DATE|TIME))|(?:VARI|T)ABLES)|ELECT.+(?:FROM|USER))|U(?:NION.+SELEC|PDATE.+SE)T|DELETE.+FROM|INSERT.+INTO|\x2f\*.+\*\x2f)/Ri";
    reference:url,github.com/nollium/CVE-2024-9264/;
    reference:cve,2024-9264;
    classtype:web-application-attack;
    sid:2056768; rev:2;
    metadata:attack_target Server, tls_state TLSDecrypt, created_at 2024_10_22, cve CVE_2024_9264, deployment Perimeter, deployment Internal, deployment SSLDecrypt, confidence High, signature_severity Major, tag Exploit, updated_at 2024_11_25, reviewed_at 2025_08_26, mitre_tactic_id TA0001, mitre_tactic_name Initial_Access, mitre_technique_id T1190, mitre_technique_name Exploit_Public_Facing_Application;
    target:dest_ip;
)