Data mining and information extraction from data is a field that has gained relevance in recent years thanks to techniques based on artificial intelligence and use of machine and deep learning. The main aim of the present work is the development of a tool based on a previous behaviour study of security audit tools (oriented to SQL pentesting) with the purpose of creating testing sets capable of performing an accurate detection of a SQL attack. The study is based on the information collected through the generated web server logs in a pentesting laboratory environment. Then, making use of the common extracted patterns from the logs, each attack vector has been classified in risk levels (dangerous attack, normal attack, non-attack, etc.). Finally, a training with the generated data was performed in order to obtain a classifier system that has a variable performance between 97 and 99 percent in positive attack detection. The training data is shared to other servers in order to create a distributed network capable of deciding if a query is an attack or is a real petition and inform to connected clients in order to block the petitions from the attacker's IP.
翻译:从数据中提取数据和信息是一个领域,近年来由于基于人工智能的技术以及机器的使用和深层学习而变得具有相关性,目前工作的主要目的是在以前对安全审计工具的行为研究(面向SQL笔测试)的基础上开发一个工具,目的是建立能够准确探测SQL攻击的测试组,该研究以通过生成的网络服务器记录在笔试实验室环境中收集的信息为基础。然后,利用从日志中提取的共同模式,将每个攻击矢量分类为风险水平(危险攻击、正常攻击、非攻击等)。最后,利用生成的数据进行了培训,以获得一个分类系统,其性能在97%至99%之间,在正面攻击探测方面是可变的。培训数据与其他服务器共享,以便建立一个分布式网络,能够决定查询是攻击还是真正的请求,并通知相关客户,以阻止攻击者IP的请愿。