Tuning IPS and URL Filtering Without Weakening Protection
An online retailer uses a Huawei USG firewall with IPS, antivirus, and URL filtering enabled on the outbound policy. The IPS profile is set to block all signatures at severity high and above. Since rollout, the customer-service team reports that searches containing an apostrophe followed by text are blocked as SQL injection, and that a legitimate payment provider's domain is categorized as malicious and blocked. The antivirus engine is scanning HTTP and SMTP; users report slow page loads and occasional timeouts on large PDF invoices. The firewall is rated for 4 Gbps throughput, but the ISP link is 1 Gbps and CPU utilization reaches 85 percent during peak hours. The security team is under pressure to disable IPS and URL filtering to restore service, but management wants protection maintained.
1. How would you determine whether the SQL injection alerts are false positives, and what tuning would you apply?
Read the worked answer
Start by capturing the exact request and the IPS signature ID, severity, and action from logs. Reproduce the search in a controlled browser session and compare the payload with the signature definition. A search string containing an apostrophe and common words may match a broad SQL injection pattern, but the request is a normal parameterized query from the application, not an attack. Check whether the source is an internal user, whether the destination is the legitimate application, and whether the payload contains actual SQL metacharacters that the application passes to the database. If the same signature fires on many benign searches from many users while no exploitation is observed, it is a false positive.
Tuning should be narrow. Change the specific signature from block to alert, or create a signature exception/whitelist for the affected source-destination-service tuple, rather than disabling the whole IPS profile. If the vendor provides a signature threshold or parameter, adjust it to reduce broad matching. Keep severity-high signatures that detect real exploitation in block mode. Re-test with benign searches and with a controlled SQL injection test against a lab instance. Monitor for a day, then confirm that the exception does not allow the actual attack pattern. Document the signature ID, reason, scope, and expiry date for review.
2. The payment provider is blocked by URL filtering. What is the correct remediation, and how does it differ from disabling URL filtering?
Read the worked answer
First verify the categorization: check the URL filtering log for the exact URL, category, and response. Confirm that the domain is genuinely the payment provider and not a lookalike or a compromised redirect. If the provider is miscategorized, the narrow fix is a URL filtering whitelist entry for the exact domain or URL, scoped to the relevant source group if possible, so that only the payment flow is exempted. Many platforms also allow a custom category or a category override. This preserves blocking for genuinely malicious categories.
Disabling URL filtering would remove protection for all users and all categories, including phishing and malware sites, and would not be auditable. The whitelist should be documented with the business owner, the exact hostnames, and a review date. If the provider uses multiple domains for payment, CDN, and redirects, list them explicitly rather than whitelisting a broad wildcard. After the change, test the payment checkout flow and confirm that a known malicious test URL is still blocked. If the provider is actually malicious or newly compromised, do not whitelist it; escalate to the security team and inform the business.
3. What would you examine to address the performance degradation, and what changes would you recommend before considering hardware replacement?
Read the worked answer
Identify where the CPU is spent: enable or review per-profile statistics, session counts, and throughput graphs. Determine whether the load comes from IPS, antivirus, URL filtering, or a combination, and whether large PDF scans and SMTP scanning dominate. Check whether the firewall is inspecting traffic that does not need inspection, such as backup or software-update flows, and whether the outbound policy applies all profiles to all users. Also check for asymmetric routing, session table exhaustion, and excessive logging, which can add load.
Reasonable changes: apply IPS and antivirus only to the traffic that needs it, for example browser and mail traffic, rather than all outbound traffic. Exclude trusted business destinations from deep inspection where risk is acceptable, with documented exceptions. Adjust antivirus maximum file size and scan timeouts so large PDFs do not stall sessions. Use URL filtering categories rather than full URL logging, and reduce verbose logging. If SSL inspection is enabled, size it separately because it is CPU-intensive. After tuning, measure again at peak. If throughput still exceeds the platform's measured IPS/AV throughput with the required profiles, then propose a higher-capacity model or a dedicated security appliance; do not disable protection to mask a sizing problem.