ET WEB_SERVER Possible SQL Injection SELECT CONCAT in HTTP URI

Query · suricata

flow:established,to_server;
http.request_line;
content:"SELECT"; nocase;
content:"CONCAT"; nocase; within:100; fast_pattern;
pcre:"/SELECT.+CONCAT.+(?:\x3b|\x253b)/i";
Raw source ET WEB_SERVER Possible SQL Injection SELECT CONCAT in HTTP URI · Suricata
Esc
Published by Emerging Threats Open ↗, licensed under BSD 3-Clause ↗. Line breaks added for readability; the rule is otherwise unchanged. 
alert http $EXTERNAL_NET any -> $HOME_NET any (
    msg:"ET WEB_SERVER Possible SQL Injection SELECT CONCAT in HTTP URI";
    flow:established,to_server;
    http.request_line;
    content:"SELECT"; nocase;
    content:"CONCAT"; nocase; within:100; fast_pattern;
    pcre:"/SELECT.+CONCAT.+(?:\x3b|\x253b)/i";
    reference:url,ferruh.mavituna.com/sql-injection-cheatsheet-oku/;
    reference:url,www.webdevelopersnotes.com/tutorials/sql/a_little_more_on_the_mysql_select_statement.php3;
    classtype:web-application-attack;
    sid:2011042; rev:10;
    metadata:affected_product Web_Server_Applications, attack_target Web_Server, created_at 2010_07_30, deployment Datacenter, confidence Medium, signature_severity Major, tag SQL_Injection, updated_at 2024_11_28, mitre_tactic_id TA0001, mitre_tactic_name Initial_Access, mitre_technique_id T1190, mitre_technique_name Exploit_Public_Facing_Application;
)

Detection rules belong to the projects that publish them and remain under their own licenses. This site indexes and links to them; it claims no rights in them.