Query: write Sigma for Detects potential SQL injection attempts via GET requests in access logs.
Matching passage: Sigma rule: Detects potential SQL injection attempts via GET requests in access logs.. Logsource: webserver. Rule: title: SQL Injection Strings In URI id: 5513deaf-f49a-46c2-a6c8-3f111b5cb453 status: test description: Detects potential SQL injection attempts via GET requests in access logs. references: - https://www.acunetix.com/blog/articles/exploiting-sql-injection-example/ - https://www.acunetix.com/blog/articles/using-logs-to-investigate-a-web-application-attack/ - https://brightsec.com/blog/sql-injection-payloads/ - https://github.com/payloadbox/sql-injection-payload-list - https://book.hacktricks.xyz/pentesting-web/sql-injection/mysql-injection author: Saw Win Naung, Nasreddine Bencherchali (Nextron Systems), Thurein Oo (Yoma Bank) date: 2020-02-22 modified: 2023-09-04 tags: - attack.initial-access - attack.t1190 logsource: category: webserver detection: selection: cs-method: GET keywords: - '@@version' - '%271%27%3D%271' - '=select ' - =select( - =select%20 - concat_ws( - CONCAT(0x - from mysql.innodb_table_stats - from%20mysql.innodb_table_stats - group_concat( - information_schema.tables - json_arrayagg( - or 1=1# - or%201=1# - 'order by ' - order%20by%20 - 'select * ' - select database() - select version() - select%20*%20 - select%20database() - select%20version() - select%28sleep%2810%29 - SELECTCHAR( - table_schema - UNION ALL SELECT - UNION SELECT - UNION%20ALL%20SELECT - UNION%20SELECT - '''1''=''1' filter_main_status: sc-status: 404 condition: selection and keywords and not 1 of filter_main_* falsepositives: - Java scripts and CSS Files - User searches in search boxes of the respective website - Internal vulnerability scanners can cause some serious FPs when used, if you experience a lot of FPs due to this think of adding more filters such as "User Agent" strings and more response codes level: high
Near-miss passage: Sigma rule: Detects exploitation attempt using the JNDI-Exploit-Kit. Logsource: webserver. Rule: title: JNDIExploit Pattern id: 412d55bc-7737-4d25-9542-5b396867ce55 status: test description: Detects exploitation attempt using the JNDI-Exploit-Kit references: - https://github.com/pimps/JNDI-Exploit-Kit - https://web.archive.org/web/20231015205935/https://githubmemory.com/repo/FunctFan/JNDIExploit author: Florian Roth (Nextron Systems) date: 2021-12-12 modified: 2022-12-25 tags: - attack.initial-access - attack.t1190 logsource: category: webserver detection: keywords: - /Basic/Command/Base64/ - /Basic/ReverseShell/ - /Basic/TomcatMemshell - /Basic/JettyMemshell - /Basic/WeblogicMemshell - /Basic/JBossMemshell - /Basic/WebsphereMemshell - /Basic/SpringMemshell - /Deserialization/URLDNS/ - /Deserialization/CommonsCollections1/Dnslog/ - /Deserialization/CommonsCollections2/Command/Base64/ - /Deserialization/CommonsBeanutils1/ReverseShell/ - /Deserialization/Jre8u20/TomcatMemshell - /TomcatBypass/Dnslog/ - /TomcatBypass/Command/ - /TomcatBypass/ReverseShell/ - /TomcatBypass/TomcatMemshell - /TomcatBypass/SpringMemshell - /GroovyBypass/Command/ - /WebsphereBypass/Upload/ condition: keywords falsepositives: - Legitimate apps the use these paths level: high