{"id":1804,"date":"2023-06-07T16:02:00","date_gmt":"2023-06-07T08:02:00","guid":{"rendered":"https:\/\/systw.net\/note\/?p=1804"},"modified":"2026-01-10T20:24:52","modified_gmt":"2026-01-10T12:24:52","slug":"sqlmap%e5%81%b5%e6%b8%ac%e8%a8%ad%e5%ae%9a","status":"publish","type":"post","link":"https:\/\/systw.net\/note\/archives\/1804","title":{"rendered":"SQLMap\u5075\u6e2c\u8a2d\u5b9a"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>sqlmap\u5075\u6e2c\u76ee\u6a19\u6642\uff0c\u5e38\u898b\u8a2d\u5b9a\u5305\u62ec\u4ee5\u4e0b:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6aa2\u6e2c\u884c\u70ba<\/li>\n\n\n\n<li>\u6aa2\u6e2c\u6df1\u5ea6<\/li>\n\n\n\n<li>\u8f38\u51fa\u5167\u5bb9<\/li>\n\n\n\n<li>\u6aa2\u6e2c\u689d\u4ef6 <\/li>\n\n\n\n<li>\u8f14\u52a9\u9078\u9805<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u6aa2\u6e2c\u884c\u70ba<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u81ea\u52d5\u5316<\/h3>\n\n\n\n<p>&#8211;batch \u4e0d\u8a62\u554f\u4f7f\u7528\u8005\u8981\u505a\u4ec0\u9ebc\u52d5\u4f5c\uff0c\u76f4\u63a5\u7528\u9810\u8a2d\u503c\u81ea\u52d5\u8dd1\u5b8c<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u901f\u5ea6<\/h3>\n\n\n\n<p>&#8211;threads \u6307\u5b9a\u8981\u7528\u5e7e\u689d\u7dda\u7a0b\u505a\u6e2c\u8a66\uff0c\u8d8a\u9ad8\u901f\u5ea6\u8d8a\u5feb\uff0c\u4f46\u4e00\u4e9b\u9632\u79a6\u8a2d\u8a2d\u6703\u628a\u901f\u5ea6\u592a\u5feb\u7684\u5217\u5165\u9ed1\u540d\u55ae<\/p>\n\n\n\n<p>&#8211;delay \u6307\u5b9a\u6bcf\u6b21\u8981\u66ab\u6642\u591a\u4e45\u624d\u6703\u57f7\u884c\u4e0b\u4e00\u500b\u6e2c\u8a66<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u4ee3\u7406<\/h3>\n\n\n\n<p>&#8211;proxy  (http|https|socks4|socks5):\/\/address:port \u6307\u5b9a\u8981\u7528\u7684\u4ee3\u7406 , \u4f8b\u5982 <code>--proxy  http:\/\/127.0.0.1:8080<\/code><\/p>\n\n\n\n<p>&#8211;proxy-cred username:psswprd \u5982\u679c\u6709\u5bc6\u78bc\u53ef\u7167\u9019\u683c\u5f0f\u589e\u52a0\u53c3\u6578<\/p>\n\n\n\n<p>\u6709\u6642\u5019\u9047\u5230ssl\u554f\u984c\u7121\u6cd5\u6383\u53ef\u4ee5\u63a5\u4ee3\u7406\uff0c\u4f8b\u5982\u76f4\u63a5\u57f7\u884cmitmproxy\u5728\u672c\u6a5f\u5efa\u4e00\u500b127.0.0.1:8080\u7684proxy<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u6aa2\u6e2c\u6df1\u5ea6<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6aa2\u6e2c\u7b49\u7d1a<\/h3>\n\n\n\n<p>\u9810\u8a2d\u60c5\u6cc1\u4e0bSQLMAP\u53ea\u652f\u63f4GET\/POST\u53c3\u6578\u7684\u6ce8\u5165\u6e2c\u8a66\uff0c\u4f46\u662f\u4f7f\u7528\u2013level \u53c3\u6578\u4e14\u6578\u503c&gt;=2\u7684\u6642\u5019\u4e5f\u6703\u6aa2\u67e5cookie\u88e1\u9762\u7684\u53c3\u6578\uff0c\u7576&gt;=3\u7684\u6642\u5019\u5c07\u6aa2\u67e5User-agent\u548cReferer\u3002\u53ef\u4ee5\u900f\u904eburpsuite\u7b49\u5de5\u5177\u53d6\u5f97\u7576\u524d\u7684cookie\u503c\uff0c\u7136\u5f8c\u9032\u884c\u6ce8\u5165\uff1a<\/p>\n\n\n\n<p>\u53c3\u6578 &#8211;level<\/p>\n\n\n\n<p>level \u5b9a\u7fa9\u4e86\u6ce8\u5165\u7684\u7b49\u7d1a\uff0c\u7b49\u7d1a\u8d8a\u9ad8\u4f7f\u7528\u7684payload\u8d8a\u591a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1\uff1a\u9810\u8a2d\u662f1(&lt;100 requests)<\/li>\n\n\n\n<li>2\uff1a\u5927\u65bc\u7b49\u65bc2\u7684\u6642\u5019\u4e5f\u6703\u6e2c\u8a66HTTP Cookie\u982d\u7684\u503c(100-200 requests)<\/li>\n\n\n\n<li>3: \u5927\u65bc\u7b49\u65bc3\u7684\u6642\u5019\u4e5f\u6703\u6e2c\u8a66User-Agent\u548cHTTP Referer\u982d\u7684\u503c(200-500 requests)<\/li>\n\n\n\n<li>4: (500-1000 requests)<\/li>\n\n\n\n<li>5: (&gt;1000 requests)<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>\u5728boundaries.xml\u5167\u6709\u660e\u78ba\u5b9a\u4e0d\u540clevel\u4f7f\u7528\u4e0d\u540c\u653b\u6483payload\uff0c\u5167\u5bb9\u5982\u4e0b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;boundary&gt;     \n&lt;level&gt;3&lt;\/level&gt; \n&lt;clause&gt;1&lt;\/clause&gt;\n&lt;where&gt;1,2&lt;\/where&gt;\n&lt;ptype&gt;1&lt;\/ptype&gt;      \n&lt;prefix&gt;)&lt;\/prefix&gt;\n&lt;suffix&gt;&#91;GENERIC_SQL_COMMENT]&lt;\/suffix&gt;\n&lt;\/boundary&gt;<\/code><\/pre>\n\n\n\n<p>\u5404\u53c3\u6578\u8aaa\u660e<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ptype \u6307 payload\u7684\u985e\u578b<\/li>\n\n\n\n<li>prefix payload\u524d\u8981\u62fc\u63a5\u54ea\u4e9b\u5b57\u7b26<\/li>\n\n\n\n<li>suffix\uff1a payload\u4e4b\u5f8c\u62fc\u63a5\u90a3\u4e9b\u5b57\u7b26<\/li>\n\n\n\n<li>clause \u6307\u793a\u4e86\u4f7f\u7528\u7684\u67e5\u8a62\u8a9e\u53e5\u7684\u985e\u578b,\u53ef\u4ee5\u540c\u6642\u5beb\u591a\u500b\uff0c\u7528\u9017\u865f\u9694\u958b\u3002<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u98a8\u96aa\u7b49\u7d1a<\/h3>\n\n\n\n<p>\u53c3\u6578 \u2013risk \u6aa2\u6e2c\u5f37\u5ea6\uff0c\u5efa\u8b70\u4f7f\u75283\u4ee5\u4e0a\uff0c\u8d8a\u9ad8\u62c6\u89e3\u7684\u901f\u5ea6\u8d8a\u6162<\/p>\n\n\n\n<p>\u6b64\u53c3\u6578\u7528\u65bc\u6307\u5b9a\u98a8\u96aa\u7b49\u7d1a\uff0c\u6709 1~3 \u5171 3 \u7d1a\u3002\u9810\u8a2d\u98a8\u96aa\u7b49\u7d1a\u70ba 1\uff0c\u6b64\u7b49\u7d1a\u5728\u5927\u591a\u6578\u60c5\u6cc1\u4e0b\u5c0d\u6e2c\u8a66\u76ee\u6a19\u7121\u5bb3\u3002<\/p>\n\n\n\n<p>\u7b49\u7d1a2\u65b0\u589e\u4e86\u57fa\u65bc\u6642\u9593\u7684\u6ce8\u5165\u6e2c\u8a66<\/p>\n\n\n\n<p>\u7b49\u7d1a3\u65b0\u589e\u4e86OR\u6e2c\u8a66\u3002\u6709\u4e9bSQLi \u7684\u767b\u5165\u9801\u6703\u9700\u8981risk 3\u7684OR payload\u624d\u80fd\u767c\u73fe\u3002\u4f46\u5982\u679c\u6ce8\u5165\u9ede\u662f\u5728UPDATE\u8a9e\u53e5\u4e2d\uff0c\u4f7f\u7528OR\u6e2c\u8a66\u53ef\u80fd\u6703\u4fee\u6539\u6574\u500b\u8868\u7684\u6578\u64da<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>refer<br><a href=\"https:\/\/www.anquanke.com\/post\/id\/188173\" target=\"_blank\" rel=\"noopener\">https:\/\/www.anquanke.com\/post\/id\/188173<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u8f38\u51fa\u5167\u5bb9<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u8f38\u51fa\u7b49\u7d1a<\/h3>\n\n\n\n<p>\u8f38\u51fa\u7684\u8a0a\u606f\u7e3d\u5171\u5206\u4e86\u4e03\u500b\u7b49\u7d1a\uff0c\u9019\u4e03\u500b\u7b49\u7d1a\u5728\u6aa2\u6e2c\u8a66\u6642\u6703\u5728\u4ecb\u9762\u88e1\u56de\u50b3\u4e0d\u540c\u7684\u5167\u5bb9\u3002\u9810\u8a2d\u662f\u7b49\u7d1a1 <\/p>\n\n\n\n<p>\u53c3\u6578:  -v<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>0\uff1a\u53ea\u986f\u793a Python \u7684 tracebacks \u8a0a\u606f\u3001\u932f\u8aa4\u8a0a\u606f [ERROR] \u548c\u95dc\u9375\u8a0a\u606f [CRITICAL]\uff1b<\/li>\n\n\n\n<li>1\uff1a\u540c\u6642\u986f\u793a\u666e\u901a\u8cc7\u8a0a [INFO] \u548c\u8b66\u544a\u8a0a\u606f [WARNING]\uff1b<\/li>\n\n\n\n<li>2\uff1a\u540c\u6642\u986f\u793a\u8abf\u8a66\u8cc7\u8a0a [DEBUG]\uff1b<\/li>\n\n\n\n<li>3\uff1a\u540c\u6642\u986f\u793a\u6ce8\u5165\u6240\u4f7f\u7528\u7684\u653b\u64ca\u8377\u8f09\uff1b<\/li>\n\n\n\n<li>4\uff1a\u540c\u6642\u986f\u793a HTTP \u8acb\u6c42\uff1b<\/li>\n\n\n\n<li>5\uff1a\u540c\u6642\u986f\u793a HTTP \u56de\u61c9\u982d\uff1b<\/li>\n\n\n\n<li>6\uff1a\u540c\u6642\u986f\u793a HTTP \u56de\u61c9\u9ad4\u3002<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u4f30\u8a08\u5b8c\u6210\u6642\u9593<\/h3>\n\n\n\n<p>\u53c3\u6578: &#8211;eta<\/p>\n\n\n\n<p>\u8f38\u51fa\u7d50\u679c\u5927\u81f4\u5982\u4e0b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;hh:mm:01] &#91;INFO] the back-end DBMS is Oracle\n&#91;hh:mm:01] &#91;INFO] fetching banner\n&#91;hh:mm:01] &#91;INFO] retrieving the length of query output\n&#91;hh:mm:01] &#91;INFO] retrieved: 64\n17% &#91;========&gt;                                           ] 11\/64\n\nThen:\n\n100% &#91;===================================================] 64\/64\n&#91;hh:mm:53] &#91;INFO] retrieved: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod\n\nweb application technology: PHP 5.2.6, Apache 2.2.9\nback-end DBMS: Oracle\nbanner:\n'Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod'<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u8f38\u51fa\u5230\u65e5\u5fd7<\/h3>\n\n\n\n<p>\u5c07\u8acb\u6c42\u548c\u56de\u61c9\u4ee5\u6587\u5b57\u683c\u5f0f\u8a18\u9304\u5230\u6a94\u6848\u4e2d\u4f5c\u70ba\u65e5\u8a8c\uff0c\u5728\u8abf\u8a66\u6642\u5f88\u6709\u5e6b\u52a9<\/p>\n\n\n\n<p>\u53c3\u6578: -t  &lt; logfile path &gt;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6307\u5b9asession\u5b58\u653e\u4f4d\u7f6e<\/h3>\n\n\n\n<p>&#8211;output-dir  \u4e0d\u6307\u5b9a\u7684\u8a71\u9810\u8a2d\u662f .local\/share\/sqlmap\/output<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>refer<br><a href=\"http:\/\/www.91ri.org\/6775.html\" target=\"_blank\" rel=\"noopener\">http:\/\/www.91ri.org\/6775.html<\/a><br><a href=\"https:\/\/www.freebuf.com\/sectool\/164608.html\" target=\"_blank\" rel=\"noopener\">https:\/\/www.freebuf.com\/sectool\/164608.html<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u6aa2\u6e2c\u689d\u4ef6<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6307\u5b9a\u6578\u64da\u5eab<\/h3>\n\n\n\n<p>\u53c3\u6578 &#8211;dbms &#8220;&lt;MySQL|Oracle|PostgreSQL|Microsoft SQL Server|&#8230;&gt;&#8221;<\/p>\n\n\n\n<p>\u7bc4\u4f8b<\/p>\n\n\n\n<p><code>python sqlmap.py -u&nbsp;\"http:\/\/192.168.1.1\/sqlmap\/pgsql\/get_int.php?id=1\" --dbms&nbsp;\"PostgreSQL\"<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u6307\u5b9a\u4f5c\u696d\u7cfb\u7d71<\/h3>\n\n\n\n<p>\u53c3\u6578 &#8211;os &#8220;&lt;Linux|Windows&gt;&#8221;<\/p>\n\n\n\n<p>\u7bc4\u4f8b<\/p>\n\n\n\n<p><code>sqlmap -u&nbsp;\"http:\/\/192.168.1.1\/sqlmap\/pgsql\/get_int.php?id=1\"  --os&nbsp;\"Windows\"<\/code><\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u6307\u5b9a\u6aa2\u6e2c\u985e\u578b<\/h3>\n\n\n\n<p>\u53c3\u6578 &#8211;technique<\/p>\n\n\n\n<p>B: Boolean-based blind SQL injection\uff08\u5e03\u6797\u578b\u6ce8\u5165\uff09<br>E: Error-based SQL injection\uff08\u5831\u932f\u578b\u6ce8\u5165\uff09<br>U: UNION query SQL injection\uff08\u53ef\u806f\u5408\u67e5\u8a62\u6ce8\u5165\uff09<br>S: Stacked queries SQL injection\uff08\u53ef\u591a\u8a9e\u53e5\u67e5\u8a62\u6ce8\u5165\uff09<br>T: Time-based blind SQL injection\uff08\u57fa\u65bc\u6642\u9593\u5ef6\u9072\u6ce8\u5165\uff09<br>Q: inline_query SQL injection(\u5167\u806f\u6ce8\u5165)<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u7bc4\u4f8b\uff1a\u6307\u5b9a\u4f7f\u7528\u5831\u932f\u578b\u6ce8\u5165\u548c\u53ef\u591a\u8a9e\u53e5\u67e5\u8a62\u6ce8\u5165<\/p>\n\n\n\n<p><code>sqlmap --technique ES<\/code><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u8f14\u52a9\u9078\u9805<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">HTTP User-Agent<\/h3>\n\n\n\n<p>\u9810\u8a2d\u60c5\u6cc1\u4e0bsqlmap\u7684HTTP\u8acb\u6c42\u982d\u4e2dUser-Agent\u503c\u662f\uff1asqlmap\/1.0-dev-xxxxxxx (http:\/\/sqlmap.org)<\/p>\n\n\n\n<p>\u53c3\u6578\uff1a\u2013user-agent,\u2013random-agent<\/p>\n\n\n\n<p>\u53ef\u4ee5\u4f7f\u7528\u2013user-agent\u53c3\u6578\u4f86\u4fee\u6539\uff0c\u540c\u6642\u4e5f\u53ef\u4ee5\u4f7f\u7528\u2013random-agent\u53c3\u6578\u4f86\u96a8\u6a5f\u7684\u5f9e.\/txt\/user-agents.txt\u4e2d\u53d6\u5f97\u3002<\/p>\n\n\n\n<p>ps:<br>\u7576\u2013level\u53c3\u6578\u8a2d\u5b9a\u70ba3\u62163\u4ee5\u4e0a\u7684\u6642\u5019\uff0c\u6703\u5617\u8a66\u5c0dUser-Agent\u9032\u884c\u6ce8\u5165\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>refer<br><a href=\"http:\/\/www.91ri.org\/6775.html\" target=\"_blank\" rel=\"noopener\">http:\/\/www.91ri.org\/6775.html<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e8c\u968eSQL\u6ce8\u5165<\/h3>\n\n\n\n<p>\u6709\u4e9b\u6642\u5019\u6ce8\u5165\u9ede\u8f38\u5165\u7684\u8cc7\u6599\u770b\u56de\u50b3\u7d50\u679c\u7684\u6642\u5019\u4e26\u4e0d\u662f\u76ee\u524d\u7684\u9801\u9762\uff0c\u800c\u662f\u53e6\u5916\u7684\u4e00\u500b\u9801\u9762\uff0c\u9019\u6642\u5019\u5c31\u9700\u8981\u4f60\u6307\u5b9a\u5230\u54ea\u500b\u9801\u9762\u53d6\u5f97\u56de\u61c9\u5224\u65b7\u771f\u5047\u3002<\/p>\n\n\n\n<p>\u53c3\u6578\uff1a\u2013second-order<\/p>\n\n\n\n<p>\u7528\u6cd5\u8209\u4f8b\u5982\u4e0b<\/p>\n\n\n\n<p><code>python sqlmap.py -r \/tmp\/r.txt --dbms MySQL --second-order \"http:\/\/targetapp\/wishlist\" -v 3<\/code><\/p>\n\n\n\n<p><code>sqlmap -r 1.txt -dbms MySQL -second-order \"http:\/\/&lt;IP\/domain&gt;\/joomla\/administrator\/index.php\" -D \"joomla\" -dbs<\/code><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>refer<br><a href=\"https:\/\/xz.aliyun.com\/t\/3010\" target=\"_blank\" rel=\"noopener\">https:\/\/xz.aliyun.com\/t\/3010<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u9801\u9762\u5c0d\u6bd4<\/h3>\n\n\n\n<p>\u9810\u8a2d\u60c5\u6cc1\u4e0b\u5728\u5e03\u6797\u578b\u6ce8\u5165\u4e2dSqlmap\u900f\u904e\u6bd4\u8f03\u50b3\u56de\u9801\u9762\u5167\u5bb9\u4f86\u5224\u65b7True\u6216False\u3002\u4f46\u6709\u6642\u9801\u9762\u6bcf\u6b21\u91cd\u65b0\u6574\u7406\u90fd\u6703\u4e0d\u540c\u3002\u4f8b\u5982\uff0c\u9801\u9762\u7576\u4e2d\u5305\u542b\u4e00\u500b\u52d5\u614b\u7684\u5ee3\u544a\u6216\u5176\u4ed6\u5167\u5bb9\uff0c\u9019\u6703\u5c0e\u81f4sqlmap\u7684\u8aa4\u5224\u3002\u6b64\u6642\u4f7f\u7528\u8005\u53ef\u4ee5\u63d0\u4f9b\u4e00\u500b\u5b57\u4e32\u6216\u4e00\u6bb5\u6b63\u898f\u5339\u914d\u3002<\/p>\n\n\n\n<p>\u53c3\u6578\uff1a\u2013string\u3001\u2013not-string\u3001\u2013regexp<\/p>\n\n\n\n<p>\u7528\u6cd5\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>\u65b9\u6cd51\uff0c\u627e\u4e00\u500b\u5728\u539f\u59cb\u9801\u9762\u8207\u771f\u689d\u4ef6\u4e0b\u7684\u9801\u9762\u90fd\u5b58\u5728\u7684\u5b57\u4e32\uff0c\u800c\u932f\u8aa4\u9801\u9762\u4e2d\u4e0d\u5b58\u5728\u7684\u5b57\u4e32\uff0c\u4f7f\u7528\u2013string\u53c3\u6578\u6dfb\u52a0\u5b57\u4e32\uff0c\u6216\u2013regexp\u6dfb\u52a0\u6b63\u898f\u5247 <\/p>\n\n\n\n<p>\u65b9\u6cd52\uff0c \u627e\u4e00\u6bb5\u53ea\u5728\u932f\u8aa4\u9801\u9762\u4e2d\u5b58\u5728\u7684\u5b57\u4e32\uff0c\u7136\u5f8c\u4f7f\u7528 \u2013not-string\u52a0\u8a72\u5b57\u4e32 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>refer<br><a href=\"https:\/\/xz.aliyun.com\/t\/3010\" target=\"_blank\" rel=\"noopener\">https:\/\/xz.aliyun.com\/t\/3010<\/a><br><a href=\"https:\/\/www.itread01.com\/content\/1550368654.html\" target=\"_blank\" rel=\"noopener\">https:\/\/www.itread01.com\/content\/1550368654.html<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u63d0\u9ad8UNION query SQL injection\u6e96\u78ba\u5ea6<\/h3>\n\n\n\n<p>\u9078\u9805\uff1a&#8211;union-char<\/p>\n\n\n\n<p>\u9810\u8a2d\u60c5\u6cc1\u4e0b\uff0csqlmap \u6e2c\u8a66\u806f\u5408\u67e5\u8a62\u6ce8\u5165\u6703\u4f7f\u7528 NULL \u5b57\u5143\u3002\u7136\u800c\uff0c\u900f\u904e\u63d0\u4f9b\u66f4\u9ad8\u7684&#8211;level \u503c\uff0csqlmap \u5c07\u57f7\u884c\u4e00\u500b\u96a8\u6a5f\u6578\u5b57\u7684\u6e2c\u8a66\uff0c\u56e0\u70ba\u5b58\u5728\u5c11\u6578\u60c5\u6cc1\uff0c\u4f7f\u7528 NULL \u7684\u806f\u5408\u67e5\u8a62\u6ce8\u5165\u6703\u5931\u6557\uff0c\u800c\u4f7f\u7528\u96a8\u6a5f\u6574\u6578\u6703\u6210\u529f\u3002<\/p>\n\n\n\n<p>\u4f60\u53ef\u4ee5\u624b\u52d5\u63d0\u4f9b\u9078\u9805 &#8211;union-char \u548c\u6240\u9700\u7684\u6578\u5b57\uff08\u4f8b\u5982\uff1a&#8211;union-char 123\uff09\u4f86\u6e2c\u8a66\u8a72\u985e\u578b\u7684 SQL \u6ce8\u5165\u3002<\/p>\n\n\n\n<p>refer<br>https:\/\/octobug.gitbooks.io\/sqlmap-wiki-zhcn\/content\/Users-manual\/Usage\/Techniques.html<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u81ea\u8a02\u6ce8\u5165 payload<\/h3>\n\n\n\n<p>\u9078\u9805\uff1a&#8211;prefix \u548c &#8211;suffix<\/p>\n\n\n\n<p>\u5728\u67d0\u4e9b\u60c5\u6cc1\u4e0b\uff0c\u53ea\u6709\u7576\u4f7f\u7528\u8005\u63d0\u4f9b\u9644\u52a0\u5230\u6ce8\u5165 payload \u7684\u7279\u5b9a\u5f8c\u7db4\u6642\uff0c\u624d\u80fd\u5229\u7528\u6613\u53d7\u653b\u64ca\u7684\u53c3\u6578\u3002\u53e6\u5916\uff0c\u7576\u4f7f\u7528\u8005\u5df2\u7d93\u77e5\u9053\u67e5\u8a62\u8a9e\u6cd5\u4e26\u5e0c\u671b\u900f\u904e\u76f4\u63a5\u63d0\u4f9b\u6ce8\u5165 payload \u524d\u7db4\u548c\u5f8c\u7db4\u4f86\u5075\u6e2c\u5229\u7528 SQL \u6ce8\u5165\u6642\uff0c\u9019\u4e9b\u9078\u9805\u5c0d\u9019\u7a2e\u5834\u666f\u6703\u5f88\u65b9\u4fbf\u3002<\/p>\n\n\n\n<p>\u6f0f\u6d1e\u6e90\u4ee3\u78bc\u7bc4\u4f8b\uff1a<code>$query = \"SELECT * FROM users WHERE id=('\" . $_GET['id'] . \"') LIMIT 0, 1\";<\/code><br>\u82e5\u8981\u5075\u6e2c\u4e26\u5229\u7528\u6b64 SQL \u6ce8\u5165\uff0c\u60a8\u53ef\u4ee5\u8b93 sqlmap \u5728\u5075\u6e2c\u968e\u6bb5\u5075\u6e2c\u908a\u754c\uff08\u8207 SQL payload \u524d\u7db4\u548c\u5f8c\u7db4\u7d44\u5408\uff09\uff0c\u6216\u81ea\u884c\u63d0\u4f9b\u3002<\/p>\n\n\n\n<p>\u4f8b\u5982\uff1a<code>sqlmap -u \"http:\/\/127.0.0.1\/get_str_brackets.php?id=1\" -p id --prefix \"<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">')<\/mark>\" --suffix \"<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">AND ('abc'='abc<\/mark>\"<\/code><br><br>\u9019\u5c07\u4f7f\u6240\u6709 sqlmap \u8acb\u6c42\u6700\u7d42\u69cb\u6210\u4ee5\u4e0b\u67e5\u8a62\uff1a<code>$query = \"SELECT * FROM users WHERE id=('1<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">')<\/mark> &lt;PAYLOAD&gt; <\/code><\/p>\n\n\n\n<p><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">AND ('abc'='abc<\/mark>') LIMIT 0, 1\";<\/code><\/p>\n\n\n\n<p>refer<br><a href=\"https:\/\/octobug.gitbooks.io\/sqlmap-wiki-zhcn\/content\/Users-manual\/Usage\/Injection.html\" target=\"_blank\" rel=\"noopener\">https:\/\/octobug.gitbooks.io\/sqlmap-wiki-zhcn\/content\/Users-manual\/Usage\/Injection.html<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u7e5e\u904e\u9632\u706b\u7246 <\/h3>\n\n\n\n<p>\u9078\u9805\uff1a&#8211;hex<\/p>\n\n\n\n<p>\u5c07\u6578\u64da\u8f49\u70ba16\u9032\u4f4d\u683c\u5f0f\uff0c\u67d0\u4e9b Web \u61c9\u7528\u7a0b\u5f0f\u53ef\u80fd\u6703\u904e\u6ffe\u6216\u9650\u5236\u7279\u5b9a\u5b57\u5143\uff08\u5982\u5f15\u865f &#8216;\u3001\u96d9\u5f15\u865f &#8221; \u7b49\uff09\u3002\u4f7f\u7528 Hex \u7de8\u78bc\u53ef\u4ee5\u907f\u514d\u76f4\u63a5\u5305\u542b\u9019\u4e9b\u5b57\u5143<\/p>\n\n\n\n<p><code>sqlmap -u target --hex<\/code><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u9078\u9805\uff1a&#8211;tamper<\/p>\n\n\n\n<p>\u6b64\u53c3\u6578\u7528\u65bc\u5c0d payload \u9032\u884c\u6df7\u6dc6\u4ee5\u7e5e\u904e IPS \u6216 WAF<br>1.\u82e5\u8a72 tamper \u8173\u672c\u4f4d\u65bc sqlmap \u7684\u5b89\u88dd\u76ee\u9304\u7684 tamper\u76ee\u9304\u4e2d\uff0c\u5c31\u53ef\u4ee5\u7701\u7565\u8def\u5f91\u548c\u5f8c\u7db4\u540d\uff0c\u53ea\u5beb\u6a94\u540d\u3002<br>2.\u591a\u500b tamper \u8173\u672c\u4e4b\u9593\u7528\u7a7a\u683c\u9694\u958b\uff0ctamper\u76ee\u9304\u4e2d\u6709\u8a31\u591a\u53ef\u7528\u7684 tamper \u8173\u672c\uff0c\u53ef\u81ea\u5df1\u5beb tamper \u8173\u672c<br>ps\uff1a\u9810\u8a2d\u4f4d\u7f6e\u5728 \/usr\/share\/sqlmap\/tamper\/<\/p>\n\n\n\n<p>\u8209\u4f8b\u5982\u4e0b<\/p>\n\n\n\n<p><code>sqlmap -u target --tamper space2comment<\/code><\/p>\n\n\n\n<p>\u8f38\u51fa\u6642\u6703\u986f\u793a\u8b80\u53d6\u76f8\u95dctamper\u8173\u672c\u5982\u4e0b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sqlmap -u target --tamper tamper\/between.py,tamper\/randomcase.py,tamper\/space2comment.py -v\n...omit...\n&#91;12:55:52] &#91;DEBUG] cleaning up configuration parameters\n&#91;12:55:52] &#91;INFO] loading tamper script 'between'\n&#91;12:55:52] &#91;INFO] loading tamper script 'randomcase'\n&#91;12:55:52] &#91;INFO] loading tamper script 'space2comment'\n...omit...<\/code><\/pre>\n\n\n\n<p>\u5e38\u898b\u7684\u8173\u672c\u6709\u4ee5\u4e0b<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7a7a\u683c\u76f8\u95dc\uff1aspace2comment\uff0cspace2dash\uff0cspace2hash<\/li>\n\n\n\n<li>\u7de8\u78bc\u76f8\u95dc\uff1acharencode\uff0cbase64encode\uff0cunmagicquotes<\/li>\n\n\n\n<li>\u95dc\u9375\u5b57\u8b8a\u5f62\uff1arandomcase\uff0cbetween\uff0cequaltolike<\/li>\n\n\n\n<li>\u6ce8\u5165\u8a9e\u53e5\u8b8a\u5f62\uff1aunionalltounion\uff0cappendnullbyte\uff0cmodsecurityversioned<\/li>\n<\/ul>\n\n\n\n<p>ps:\u67d0\u4e9b WAF \u4f7f\u7528\u591a\u5c64\u6aa2\u6e2c\u6a5f\u5236\uff0c\u55ae\u4e00\u7684 Tamper \u8173\u672c\u53ef\u80fd\u7121\u6cd5\u5b8c\u5168\u7e5e\u904e\u3002\u56e0\u6b64\uff0c\u7d44\u5408\u4f7f\u7528\u591a\u500b\u8173\u672c\u53ef\u4ee5\u589e\u5f37\u6548\u679c<\/p>\n\n\n\n<p>refer<br>https:\/\/xz.aliyun.com\/t\/2746?time__1311=n4%2Bxni0%3DG%3DGQn3xGx0HaxIOxR2nFKDc77CoD<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u66fe\u7d93\u6709\u6210\u529f\u7e5e\u904e\u7684\u7d44\u5408<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&#8211;tamper=between,randomcase,charencode<\/li>\n\n\n\n<li>&#8211;tamper=space2comment,randomcase,between<\/li>\n\n\n\n<li>&#8211;tamper=space2comment,equaltolike,charencode<\/li>\n\n\n\n<li>&#8211;tamper=space2comment,randomcase,charencode<\/li>\n\n\n\n<li>&#8211;tamper=space2comment,equaltolike,appendnullbyte<\/li>\n\n\n\n<li>&#8211;tamper=space2comment,between,randomcase,charencode<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>refer<br><a href=\"https:\/\/www.tr0y.wang\/2018\/03\/21\/sqlmap-guide\" target=\"_blank\" rel=\"noopener\">https:\/\/www.tr0y.wang\/2018\/03\/21\/sqlmap-guide<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">sqlmap\u5075\u6e2c\u6d41\u7a0b<\/h3>\n\n\n\n<p>\u5728sqlmap\u5075\u6e2csql\u6ce8\u5165\u9ede\u7684\u904e\u7a0b\u4e2d\uff0c\u6703\u6709\u4e00\u7cfb\u5217\u524d\u7f6e\u767c\u5305\uff0c\u9019\u4e9b\u524d\u7f6e\u767c\u5305\u4e3b\u8981\u5305\u62ec<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7db2\u7ad9\u9023\u901a\u6027\u6aa2\u6e2c<\/li>\n\n\n\n<li>WAF\u63a2\u6e2c<\/li>\n\n\n\n<li>\u7db2\u9801\u7a69\u5b9a\u5075\u6e2c<\/li>\n\n\n\n<li>\u53c3\u6578\u52d5\u614b\u6027\u5075\u6e2c<\/li>\n\n\n\n<li>\u555f\u767c\u5f0f\u8a3b\u5165\u5075\u6e2c<\/li>\n\n\n\n<li>\u8aa4\u5831\u5075\u6e2c<\/li>\n<\/ul>\n\n\n\n<p>refer<br><a href=\"https:\/\/paper.seebug.org\/729\" target=\"_blank\" rel=\"noopener\">https:\/\/paper.seebug.org\/729\/<\/a>. sqlmap\u904b\u4f5c\u6d41\u7a0b<br><a href=\"https:\/\/www.jishuwen.com\/d\/2egl\/zh-tw\" target=\"_blank\" rel=\"noopener\">https:\/\/www.jishuwen.com\/d\/2egl\/zh-tw<\/a> SQLMAP\u5728\u9032\u884csql\u6ce8\u5165\u6642\u7684\u6574\u500b\u6d41\u7a0b<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u6df1\u5165\u4e86\u89e3SQLMAP API<\/h3>\n\n\n\n<p><a href=\"https:\/\/cloud.tencent.com\/developer\/article\/1451915\" target=\"_blank\" rel=\"noopener\">https:\/\/cloud.tencent.com\/developer\/article\/1451915<\/a><br><a href=\"https:\/\/zhuanlan.zhihu.com\/p\/56005857\" target=\"_blank\" rel=\"noopener\">https:\/\/zhuanlan.zhihu.com\/p\/56005857<\/a><br><a href=\"https:\/\/zhuanlan.zhihu.com\/p\/43242220\" target=\"_blank\" rel=\"noopener\">https:\/\/zhuanlan.zhihu.com\/p\/43242220<\/a>  sqlmap \u5185\u6838\u5206\u6790 I: \u57fa\u7840\u6d41\u7a0b<br><a href=\"https:\/\/zhuanlan.zhihu.com\/p\/44157153\" target=\"_blank\" rel=\"noopener\">https:\/\/zhuanlan.zhihu.com\/p\/44157153<\/a>&nbsp; sqlmap \u5185\u6838\u5206\u6790 II: \u6838\u5fc3\u539f\u7406-\u9875\u9762\u76f8\u4f3c\u5ea6\u7b97\u6cd5\u5b9e\u8df5<br><a href=\"https:\/\/zhuanlan.zhihu.com\/p\/45291193\" target=\"_blank\" rel=\"noopener\">https:\/\/zhuanlan.zhihu.com\/p\/45291193<\/a>&nbsp; sqlmap \u5185\u6838\u5206\u6790 III: \u6838\u5fc3\u903b\u8f91<\/p>\n","protected":false},"excerpt":{"rendered":"<p>sqlmap\u5075\u6e2c\u76ee\u6a19\u6642\uff0c\u5e38\u898b\u8a2d\u5b9a\u5305\u62ec\u4ee5\u4e0b: \u6aa2\u6e2c\u884c\u70ba \u81ea\u52d5\u5316 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[369],"tags":[],"class_list":["post-1804","post","type-post","status-publish","format-standard","hentry","category-red-team"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts\/1804","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/comments?post=1804"}],"version-history":[{"count":2,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts\/1804\/revisions"}],"predecessor-version":[{"id":2994,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts\/1804\/revisions\/2994"}],"wp:attachment":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/media?parent=1804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/categories?post=1804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/tags?post=1804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}