A security engineer analyzing packet telemetry from an inline Network Intrusion Prevention System (NIPS) notices a high-priority alert triggered by inbound traffic directed at a public-facing web server. The alert details contain the following HTTP payload snippet:
`GET /catalog.php?item_id=105%27%20UNION%20SELECT%20null,username,password_hash%20FROM%20user_credentials--%20HTTP/1.1`
`Host: portal.example.com`
The engineer must select a targeted mitigation control that specifically blocks this attack payload while preserving uninterrupted HTTP/HTTPS access for legitimate users. Which of the following actions should the engineer take?
- Deploy a Web Application Firewall (WAF) rule to inspect layer 7 payload parameters and block requests containing SQL syntax tokens.Cevap
- BImplement Content Security Policy (CSP) headers to sanitize dynamic user inputs and block script execution in client browsers.
- CAdd a stateful network firewall rule to drop all incoming TCP port 80 and 443 traffic originating from external subnets.
- DReroute incoming connections matching the URL pattern to an inline honeypot to filter out database queries before reaching the database server.
Cevap
Deploying a Web Application Firewall (WAF) rule to inspect layer 7 parameters and block requests containing SQL syntax tokens effectively mitigates the SQL injection payload while keeping standard web services available.
The log snippet reveals a URL-encoded SQL injection string (`UNION SELECT ... FROM user_credentials`). Because SQL injection is an application-layer (Layer 7) vulnerability, a Web Application Firewall (WAF) is the appropriate control. A WAF inspects HTTP/HTTPS payload contents and parameter values to block malicious database query structures while allowing benign web traffic through.
Adım Adım Çözüm
Anahtar Kavram
Layer 7 Network Security Monitoring and WAF Mitigation