The best way to prevent sql injection is to filter out all the data submitted to the background.
For simple cases, such as including single quotes ‘, semicolon;, <, >, and other characters can be avoided by rewriting directly to the 404 page.
There is a premise to use rewrite to know that the general use of rewrite for regular matching can only match the URI of the web page, that is the front part of the “?” in the url, and the “?” later part is the request parameter.
The request parameters after “?” are expressed in nginx with $query_string, they cannot be matched in rewrite, so you need to use “if” to judge
For example, matching ‘ with single quotes in the argument and then directing to the error page:
|
1 2 |
/nginx/test.php?tid=11&mid=22' rewrite ^.*([;'<>]).* /error.html break; |
Directly writing such an rewrite will definitely not match correctly, because the rewrite parameter will only match the requested uri, which is the /nginx/test.php part.
You need to use $query_string to determine with “if”. If the query string contains special characters, return 404.
|
1 2 3 |
if ( $query_string ~* ".*[;'<>].*" ){ return 404; } |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 |
server { ## Forbidden SQL injection Block SQL injections set $block_sql_injections 0; if ($query_string ~ “union.*select.*(“) { set $block_sql_injections 1; } if ($query_string ~ “union.*all.*select.*”) { set $block_sql_injections 1; } if ($query_string ~ “concat.*(“) { set $block_sql_injections 1; } if ($block_sql_injections = 1) { return 444; } ## Prohibit file injection set $block_file_injections 0; if ($query_string ~ “[a-zA-Z0-9_]=http://”) { set $block_file_injections 1; } if ($query_string ~ “[a-zA-Z0-9_]=(..//?)+”) { set $block_file_injections 1; } if ($query_string ~ “[a-zA-Z0-9_]=/([a-z0-9_.]//?)+”) { set $block_file_injections 1; } if ($block_file_injections = 1) { return 444; } ## Ban overflow attack set $block_common_exploits 0; if ($query_string ~ “(<|%3C).*script.*(>|%3E)”) { set $block_common_exploits 1; } if ($query_string ~ “GLOBALS(=|[|%[0-9A-Z]{0,2})”) { set $block_common_exploits 1; } if ($query_string ~ “_REQUEST(=|[|%[0-9A-Z]{0,2})”) { set $block_common_exploits 1; } if ($query_string ~ “proc/self/environ”) { set $block_common_exploits 1; } if ($query_string ~ “mosConfig_[a-zA-Z_]{1,21}(=|%3D)”) { set $block_common_exploits 1; } if ($query_string ~ “base64_(en|de)code(.*)”) { set $block_common_exploits 1; } if ($block_common_exploits = 1) { return 444; } ## Forbidden spam field set $block_spam 0; if ($query_string ~ “b(ultram|unicauca|valium|viagra|vicodin|xanax|ypxaieo)b”) { set $block_spam 1; } if ($query_string ~ “b(erections|hoodia|huronriveracres|impotence|levitra|libido)b”) { set $block_spam 1; } if ($query_string ~ “b(ambien|bluespill|cialis|cocaine|ejaculation|erectile)b”) { set $block_spam 1; } if ($query_string ~ “b(lipitor|phentermin|pro[sz]ac|sandyauer|tramadol|troyhamby)b”) { set $block_spam 1; } if ($block_spam = 1) { return 444; } ## Prohibit user-agents set $block_user_agents 0; # Don't disable wget if you need it to run cron jobs! #if ($http_user_agent ~ “Wget”) { # set $block_user_agents 1; #} # Disable Akeeba Remote Control 2.5 and earlier if ($http_user_agent ~ “Indy Library”) { set $block_user_agents 1; } # Common bandwidth hoggers and hacking tools. if ($http_user_agent ~ “libwww-perl”) { set $block_user_agents 1; } if ($http_user_agent ~ “GetRight”) { set $block_user_agents 1; } if ($http_user_agent ~ “GetWeb!”) { set $block_user_agents 1; } if ($http_user_agent ~ “Go!Zilla”) { set $block_user_agents 1; } if ($http_user_agent ~ “Download Demon”) { set $block_user_agents 1; } if ($http_user_agent ~ “Go-Ahead-Got-It”) { set $block_user_agents 1; } if ($http_user_agent ~ “TurnitinBot”) { set $block_user_agents 1; } if ($http_user_agent ~ “GrabNet”) { set $block_user_agents 1; } if ($http_user_agent ~ "WebBench") { set $block_user_agents 1; } if ($http_user_agent ~ "ApacheBench") { set $block_user_agents 1; } if ($http_user_agent ~ ^$) { set $block_user_agents 1; } if ($http_user_agent ~ "Python-urllib") { set $block_user_agents 1; } if ($block_user_agents = 1) { return 444; } } |
This article was first published by V on 2019-05-07 and can be reprinted with permission, but please be sure to indicate the original link address of the article :http://www.nginxer.com/records/the-configuration-of-preventing-sql-injection-attacks-in-nginx/