Skip to content
Merged
Show file tree
Hide file tree
Changes from all commits
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
2 changes: 1 addition & 1 deletion rules/RESPONSE-951-DATA-LEAKAGES-SQL.conf
Original file line number Diff line number Diff line change
Expand Up @@ -266,7 +266,7 @@ SecRule RESPONSE_BODY "@rx (?i:<b>Warning</b>: ibase_|Unexpected end of command
setvar:'tx.outbound_anomaly_score_pl1=+%{tx.critical_anomaly_score}',\
setvar:'tx.sql_injection_score=+%{tx.critical_anomaly_score}'"

SecRule RESPONSE_BODY "@rx (?i:SQL error.*POS[0-9]+.*|Warning.*maxdb.*)" \
SecRule RESPONSE_BODY "@rx (?i)Warning.{1,10}maxdb[\(\)_a-z:]{1,26}:" \
Comment thread
fzipi marked this conversation as resolved.
"id:951210,\
phase:4,\
block,\
Expand Down
21 changes: 21 additions & 0 deletions tests/regression/tests/RESPONSE-951-DATA-LEAKAGES-SQL/951210.yaml
Original file line number Diff line number Diff line change
Expand Up @@ -24,3 +24,24 @@ tests:
output:
log:
expect_ids: [951210]
- test_id: 2
desc: "Matching maxDB SQL Information Leakage with double colon syntax"
stages:
- input:
dest_addr: "127.0.0.1"
port: 80
headers:
Host: "localhost"
User-Agent: "OWASP CRS test agent"
Accept: "text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5"
Accept-Encoding: "gzip,deflate"
Accept-Language: "en-us,en;q=0.5"
Content-Type: "application/json"
method: "POST"
version: "HTTP/1.1"
uri: "/reflect"
data: |-
{"body": "[match sql-errors.data]the used select statements have different number of columns[/match]: Warning: maxdb::query(): -4004 POS(15) Unknown table name:CALCULATE_RETURN [42000]"}
output:
log:
expect_ids: [951210]
Loading