Research on SQL Injection Attacks Detection Method Based on the Truncated Key Payload

doi:10.3969/j.issn.1671-1122.2021.07.006

Abstract

Abstract:

SQL injection attack is one of the common methods used by hackers to attack the database, which poses a great threat to the security of current Web applications. Considering that there are a lot of the same strings between the SQL injection and the normal HTTP statements, it will decrease the discrimination results of these statements. With the analysis of the difference between the SQL injection and the normal HTTP statements, this paper proposes a key payload truncating method based on keyword pairs. This method can truncate the key payloads from SQL injection statements to decrease the number of the same strings with the SQL injection attacks statements. Integrate with natural language processing technology, the truncated payloads, word2vec, and a classification algorithm, this paper constructs a SQL injection attacks detection method based on the truncated key payloads(SDMTKP), and constructs a Web system to test this method. The experimental results show that SDMTKP is better than the method based on the complete statements and word2vec in terms of detection accuracy and detection efficiency.

Key words: SQL injection, truncated key payloads, machine learning

CLC Number:

TP309

GUO Chun, CAI Wenyan, SHEN Guowei, ZHOU Xuemei. Research on SQL Injection Attacks Detection Method Based on the Truncated Key Payload[J]. Netinfo Security, 2021, 21(7): 43-53.

Figures/Tables 16

References 25

[1]	OWASP Top10-open Web Application Security Project. Top Ten Web Application Security Risks[EB/OL]. http://www.owasp.org.cn/owasp-project/OWASPTop102017RC1V1.0.pdf, 2021-03-08.
[2]	JACOB I, PIRNAU M. SQL Injection Attacks and Vulnerabilities[J]. Journal of Information Systems & Operations Management, 2020, 14(1):68-81.
[3]	ABIKOYE O C, ABUBAKAR A, DOKORO A H, et al. A Novel Technique to Prevent SQL Injection and Cross-site Scripting Attacks Using Knuth-morris-pratt String Match Algorithm[J]. Eurasip Journal on Information Security, 2020, 2020(1):1-14. doi: 10.1186/s13635-020-0101-7 URL
[4]	JAHANSHAHI R, DOUPÉ A, EGELE M. You Shall Not Pass: Mitigating SQL Injection Attacks on Legacy Web Applications[C]// SIGSAC. The 15th ACM Asia Conference on Computer and Communications Security, October 5, 2020, Taibei, China. New York: Association for Computing Machinery, 2020: 445-457.
[5]	DAS D, SHARMA U, BHATTACHARYYA D K. Defeating SQL Injection Attack in Authentication Security: An Experimental Study[J]. International Journal of Information Security, 2019, 18(1):1-22. doi: 10.1007/s10207-017-0393-x URL
[6]	DAN G. Rookie Coding Mistake Prior to Gab Hack Came from Site’S CTO[EB/OL]. https://arstechnica.com/gadgets/2021/03/rookie-coding-mistake-prior-to-gab-hack-came-from-sites-cto/?comments=1, 2021-03-03.
[7]	GUO Qiquan, ZHANG Haixia. Technology System for Security Protection of Critical Information Infrastructures[J]. Netinfo Security, 2020, 20(11):1-9.
	郭启全, 张海霞. 关键信息基础设施安全保护技术体系[J]. 信息网络安全, 2020, 20(11):1-9.
[8]	NADEEM R M, SALEEM R M, BASHIR R, et al. Detection and Prevention of SQL Injection Attack by Dynamic Analyzer and Testing Model[J]. International Journal of Advanced Computer Science and Applications, 2017, 8(8):209-214.
	MCWHIRTER P R, KIFAYAT K, SHI Q, et al. SQL Injection Attack Classification Through The Feature Extraction of SQL Query Strings Using a Gap-weighted String Subsequence Kernel[J]. Journal of Information Security and Applications, 2018, 18(40):199-216.
[9]	JANA A, MAITY D. Code-based Analysis Approach to Detect and Prevent SQL Injection Attacks[C]// IEEE. 2020 11th International Conference on Computing, Communication and Networking Technologies (ICCCNT), July 1-3, 2020, Kharagpur, India. Piscataway, New Jersey: IEEE, 2020: 1-6.
[10]	ZHANG Yajun, LI Zhoujun, LIAO Xiangke, et al. Research on Automated White Box Fuzzy Testing Technology[J]. Computer Science, 2014, 41(2):7-10.
	张亚军, 李舟军, 廖湘科, 等. 自动化白盒模糊测试技术研究[J]. 计算机科学, 2014, 41(2):7-10.
[11]	ALIERO M S, GHANI I, QURESHI K N, et al. An Algorithm For Detecting SQL Injection Vulnerability Using Black-box Testing[J]. Journal of Ambient Intelligence and Humanized Computing, 2020, 11(1):249-266. doi: 10.1007/s12652-019-01235-z URL
[12]	HLAING Z CS S, KHAING M. A Detection and Prevention Technique on SQL Injection Attacks[C]// IEEE. 2020 IEEE Conference on Computer Applications (ICCA), February 27-28, 2020, Yangon, Myanmar. Piscataway, New Jersey: IEEE, 2020: 1-6.
[13]	WANG Jie. Research on SQL Injection Defense Based on Abstract Syntax Tree[D]. Wu Han: Wuhan Research Institute of Posts and Telecommunications, 2018.
	王杰. 基于抽象语法树的SQL注入防御研究[D]. 武汉:武汉邮电科学研究院, 2018.
[14]	TANG Peng, QIU Weidong, HUANG Zheng, et al. Detection of SQL Injection Based on Artificial Neural Network[J]. Knowledge-based Systems, 2020,20, (190):105528.
[15]	MCWHIRTER P R, KIFAYAT K, SHI Q, et al. SQL Injection Attack Classification Through the Feature Extraction of SQL Query Strings Using A Gap-weighted String Subsequence Kernel[J]. Journal of Information Security and Applications, 2018, 18(40):199-216.
[16]	CHEN Ding, YAN Qiseng, WU Chunwang, et al. SQL Injection Attack Detection and Prevention Techniques Using Deep Learning[C]// Kehua Guo.International Conference on Computer Big Data and Artificial Intelligence (ICCBDAI 2020), October 24-25, 2020, Changsha, China. Britain: IOP Publishing, 2021: 12-55.
[17]	SHARMA S, ZAVARSKY P, BUTAKOV S. Machine Learning Based Intrusion Detection System for Web-based Attacks[C]// IEEE. 2020 IEEE 6th Intl Conference on Big Data Security on Cloud (Big Data Security), May 25-27, 2020, Baltimore, MD, USA. New York: IEEE, 2020: 227-230.
[18]	HASAN M, BALBAHAITH Z, TARIQUE M. Detection of SQL Injection Attacks: A Machine Learning Approach[C]// IEEE. 2019 International Conference on Electrical and Computing Technologies and Applications (ICECTA), November 19-21, 2019, Ras Al Khaimah, United Arab Emirates. New York: IEEE, 2019: 1-6.
[19]	LI Yuan, WANG Guoyin, LI Zhixing, et al. Convolutional Neural Network Anomaly Detection Based on Sequence Attention Mechanism[J]. Journal of Zhengzhou University (Natural Science Edition), 2019, 51(2):20-25.
	李苑, 王国胤, 李智星, 等. 基于序列注意力机制的卷积神经网络异常检测[J]. 郑州大学学报(理学版), 2019, 51(2):20-25.
[20]	LI Qi, WANG Fang, WANG Junfeng, et al. LSTM-based SQL Injection Detection Method for Intelligent Transportation System[J]. IEEE Transactions on Vehicular Technology, 2019, 68(5):4182-4191.
[21]	LI Ming, XING Guangsheng, WANG Zhihui, et al. Research on real-time online intelligent detection technology of SQL injection behavior[J]. Journal of Hunan University(Natural Sciences), 2020, 47(8):31-41.
	李铭, 邢光升, 王芝辉, 等. SQL注入行为实时在线智能检测技术研究[J]. 湖南大学学报(自然科学版), 2020, 47(8):31-41.
[22]	ZHANG Huafeng, ZHAO Bo, YUAN Hui, et al. SQL Injection Detection Based on Deep Belief Network[C]// Ali Emrouznejad. The 3rd International Conference on Computer Science and Application Engineering, October 22, 2019, Sanya, China. New York: Association for Computing Machinery, 2019: 1-6.
[23]	GUPTA S, KHARE V. BlazingText: Scaling and Accelerating Word2vec using Multiple GPUs[C]// IEEE. The International Conference for High Performance Computing, Networking, Storage and Analysis, November 12, 2017, Denver, CO, USA. New York: Association for Computing Machinery, 2017: 1-5.
[24]	CASELLESD H, LESAINT F, ROYOL J. Word2vec Applied to Recommendation: Hyperparameters Matter[C]// RecSys. The 12th ACM Conference on Recommender Systems, October 2, 2018, Vancouver British Columbia, Canada. New York: Association for Computing Machinery, 2018: 352-356.
[25]	ASGHARI M, SIERRAS D, ELMAGHR A. Trends on Health in Social Media: Analysis Using Twitter Topic Modeling[C]// IEEE. 2018 IEEE International Symposium on Signal Processing and Information Technology (ISSPIT), December 6-8, 2018, Louisville, KY, USA. New York: IEEE, 2018: 558-563.

阶段	请求及特点	与正常HTTP请求相同的字符数	与正常HTTP请求不同的字符数
正常HTTP请求	http://www.example.com/?wfr=spider&id=1	-	-
寻找注入点	1: http://www.example.com/?wfr=spider&id=’（返回错误)	38	1
	2: http://www.example.com/?wfr=spider&id=’ and 1=1 —+（返回正常）	38	13
	则判断参数id为注入点
判断注入点类型	1: http://www.example.com/?wfr=spider&id=1’ and ‘1’=’1（返回正常）	39	12
	2: http://www.example.com/?wfr=spider&id=1’ and ‘1’=’2（返回错误）	39	12
	根据错误提示syntax to use near ''1'') LIMIT 0,1' at line 1,则判断为单引号字符型注入点。
获取数据库信息	http://www.example.com/?wfr=spider&id=1’ union select 1,concat_ws(‘\|’,user(),database()),3 — +	39	55
获取数据库信息	成功返回的当前用户和数据库名称
操作数据库	http://www.example.com/?wfr=spider&id=1’;drop table list — +	39	21
操作数据库	删除整个list表

对象	状态	示例
SQL注入攻击语句	请求预处理前	http://www.test.com/s?link_type=false&slot=%7B%7D&id=2%20%20or%20sleep%2820%29
	请求预处理后	link_type=false&slot={}&id=0 or sleep(0)
	关键载荷截取后	&id=0 or sleep(0)

类别	数量/条
正常HTTP请求	10000
SQLmap攻击语句	10000
DSSS攻击语句	1045
jSQL Injection攻击语句	771
SSQL Injection攻击语句	3269

类别	数量/条	训练集/条	测试集/条
用于提取特征词对的正常HTTP请求	5000	*	*
正常HTTP请求	4977	2489	2488
SQL注入攻击语句	10085	5044	5041
合计	20062	7533	7529

类别	数量/条	训练集/条	测试集/条
用于提取特征词对的正常HTTP请求	5000	*	*
正常HTTP请求	4727	2364	2363
SQL注入攻击语句	15085	5000 （SQLmap）	10085 （SQLmap、DSSS、 JSQLI、SSQLI）
合计	24812	7364	12448