CAS-002 · Question #652
An administrator is reviewing logs and sees the following entry: Message: Access denied with code 403 (phase 2). Pattern match "\bunion\b.{1,100}?\bselect\b" at ARGS:$id. [data "union all select"]…
The correct answer is C. SQL injection. The WAF log entry reveals a blocked SQL UNION SELECT injection attempt, identifiable by the regex pattern, the matched payload, and the OWASP/WASC tags referencing SQL injection.
Question
An administrator is reviewing logs and sees the following entry:
Message: Access denied with code 403 (phase 2). Pattern match "\bunion\b.{1,100}?\bselect\b" at ARGS:$id. [data "union all select"] [severity "CRITICAL"] [tag "WEB_ATTACK"] [tag "WASCTC/WASC-19"] [tag "OWASP_TOP_10/A1"] [tag "OWASP_AppSensor/CIE1"] Action: Intercepted (phase 2) Apache-Handler: php5-script Which of the following attacks was being attempted?
Options
- ASession hijacking
- BCross-site script
- CSQL injection
- DBuffer overflow
How the community answered
(29 responses)- A3% (1)
- B3% (1)
- C83% (24)
- D10% (3)
Why each option
The WAF log entry reveals a blocked SQL UNION SELECT injection attempt, identifiable by the regex pattern, the matched payload, and the OWASP/WASC tags referencing SQL injection.
Session hijacking involves stealing or forging authentication session tokens, not crafting UNION SELECT SQL syntax against a query parameter.
Cross-site scripting injects client-side script payloads into web page output, whereas this log shows SQL keyword patterns targeting a backend database query.
The log pattern `\bunion\b.{1,100}?\bselect\b` and the matched data `union all select` are classic signatures of a SQL injection attack using a UNION-based technique to append a secondary SELECT query. The tags WASCTC/WASC-19 and OWASP_TOP_10/A1 explicitly categorize the event as SQL injection, and the ModSecurity WAF intercepted it at phase 2 before the query could reach the database.
Buffer overflow attacks target memory boundaries in application code, not SQL query parsers, and produce entirely different signatures than UNION SELECT strings.
Concept tested: SQL injection attack identification from WAF log entries
Source: https://owasp.org/www-community/attacks/SQL_Injection
Topics
Community Discussion
No community discussion yet for this question.