Prisma Cloud Compute: SQLi detection for certain text combinations

Prisma Cloud Compute: SQLi detection for certain text combinations

196
Created On 07/17/24 22:22 PM - Last Modified 09/17/25 20:26 PM


Symptom


  1. Detected SQL Injection attack in request body parameter "value" in value ivyPublish/*,ivyRetrieve/*,ivyFingerprint/**

    1ff75b7e-6dba-4763-8300-9f38a12fa3d5.png
  2. Detected SQL Injection attack in path in value /display/IBD/Cautions+while+investing+time+on+Microsoft+AI+toolsde1a1b33-288a-4f37-80af-dd04858a8b00.png


Environment


  • Prisma Cloud Self Hosted
  • Prisma Cloud Enterprise Edition


Cause


  1. Regarding the payload

ivyPublish/*,ivyRetrieve/*,ivyFingerprint/**

This works as intended. WAAS alerts on this payload because it fits the pattern of an SQLi attack. If we look at the beginning of the payload, we can see that it starts with ivyPublish (a word) and them /* (which is a comment operator in SQL). You can use comments to truncate a query and remove the portion of the original query that follows your input. More info could be found in the links provided below.

  1. Regarding the payload

/display/IBD/Cautions+while+investing+time+on+Microsoft+AI+tools

This is a vaild sqli pattern. “while” and “time” are reserved sql words. separated by the spaces in the pattern.



Resolution


You have to create an exception rule once it is confirmed that the SQLi event detected is false positive. Create an exception for SQL Injection by following the below steps.

  1. Goto Defend>>WAAS
  2. Select the app you want to configure.
  3. Select the firewall app tab.
  4. Select SQL Injection under projection column.
  5. Add Exception
  6. Location will be path and path value would be ^/display/IBD/Cautions\+while\+investing\+time\+on\+Microsoft\+AI\+toolsl?$ under App firewall settings.

 



Additional Information


View our documentation here for App Firewall Settings. 



Actions
  • Print
  • Copy Link

    https://knowledgebase.paloaltonetworks.com/KCSArticleDetail?id=kA14u0000010zGeCAI&lang=en_US&refURL=http%3A%2F%2Fknowledgebase.paloaltonetworks.com%2FKCSArticleDetail