• caglararli@hotmail.com
  • 05386281520

Problem bypassing a PHP WAF for SQLi

Çağlar Arlı      -    65 Views

Problem bypassing a PHP WAF for SQLi

I am working to bypass this WAF, but I have some problems.

    $args_arr=array(
    
    'sql'=>"[^\\{\\s]{1}(\\s|\\b)+(?:select\\b|update\\b|insert(?:(\\/\\*.*?\\*\\/)|(\\s)|(\\+))+into\\b).+?(?:from\\b|set\\b)|[^\\{\\s]{1}(\\s|\\b)+(?:create|delete|drop|truncate|rename|desc)(?:(\\/\\*.*?\\*\\/)|(\\s)|(\\+))+(?:table\\b|from\\b|database\\b)|into(?:(\\/\\*.*?\\*\\/)|\\s|\\+)+(?:dump|out)file\\b|\\bsleep\\([\\s]*[\\d]+[\\s]*\\)|benchmark\\(([^\\,]*)\\,([^\\,]*)\\)|(?:declare|set|select)\\b.*@|union\\b.*(?:select|all)\\b|(?:select|update|insert|create|delete|drop|grant|truncate|rename|exec|desc|from|table|database|set|where)\\b.*(charset|ascii|bin|char|uncompress|concat|concat_ws|conv|export_set|hex|instr|left|load_file|locate|mid|sub|substring|oct|reverse|right|unhex)\\(|(?:master\\.\\.sysdatabases|msysaccessobjects|msysqueries|sysmodules|\\.db|sys\\.database_name|_schema\\.|sysobjects|sp_makewebtask|xp_cmdshell|sp_oamethod|sp_addextendedproc|sp_oacreate|xp_regread|sys\\.dbms_export_extension)",mysql
    
    'other'=>"\\.\\.[\\\\\\/].*\\%00([^0-9a-fA-F]|$)|%00[\\'\\\"\\.]");
    
    $referer=empty($_SERVER['HTTP_REFERER']) ? array() : array($_SERVER['HTTP_REFERER']);
    $query_string=empty($_SERVER["QUERY_STRING"]) ? array() : array($_SERVER["QUERY_STRING"]);
    check_data($query_string,$url_arr);
    check_data($_GET,$args_arr);
    check_data($_POST,$args_arr);
    check_data($_COOKIE,$args_arr);
    check_data($referer,$args_arr);
    function W_log($log)
    {
        $logpath=$_SERVER["DOCUMENT_ROOT"]."/log.txt";
        $log_f=fopen($logpath,"a+");
        fputs($log_f,$log."\r\n");
        fclose($log_f);
    }
    function check_data($arr,$v) {
     foreach($arr as $key=>$value)
     {
        if(!is_array($key))
        { //check($key,$v);
        }
        else
        { check_data($key,$v);}
        
        if(!is_array($value))
        {// check($value,$v);
        }
        else
        { //check_data($value,$v);
        }
     }
    }
    function check($str,$v)
    {
        foreach($v as $key=>$value)
        {
        if (preg_match("/".$value."/is",$str)==1||preg_match("/".$value."/is",urlencode($str))==1)
            {
                 header('Content-type:text/html;charset=utf-8');
                 print "ERROR INPUT";
                 exit();
            }
        }
    }
    ?>

I have tried /**/, URL encode and several other ways, but all of them got blocked.

eg:

?id=1 AND (SELECT COUNT(*) f/**/rom information/**/_schema.tables WHERE table_schema=database())=1 

gets blocked by the WAF.

What else can I do to execute the boolean-based injection?