Wildcard URL for Non-HTTP/HTTPS traffic

[R8787H]

Hi, this question may have been answered before, but I can’t find it anywhere on the LIVEcommunity. We need to allow traffic for the mssql-db app for a specific wildcard URL (*.example.com). It needs to be a wildcard because the alternative is to allow all Azure IP Ranges, which we cannot do. We tried using URL Categories, but it seems to only works for HTTP/HTTPS traffic. Does anyone have any ideas if this is possible?

Thank you.

PA-5280 v10.2.8-h3

[BPry]

@R8787H,

That isn't going to work. The firewall isn't able to get any information that would tie the SQL traffic to a URL since that isn't really how SQL functions. You are essentially being asked to allow SQL traffic to a wildcard FQDN which PAN can't do while other vendors (IE: Fortigate) can.

You can work around this in a convoluted way by using the API and scrubbing the DNS logs on your servers (assuming that they're private) to make it "functional". Alternatively if you don't control the DNS servers you may be able to pull resolved domains through your EDR solution as well.

You would essentially scrub the logs using your own wildcard search. Any domain that matches is one that you need to allow access to, so you could utilize an EDL and feed the identified domains into the EDL to make things "functional". This isn't a great solution since there's going to be a delay between identifying a new required domain and authorizing access on the firewall, but it works well enough if whoever/whatever your connecting to absolutely can't give you actual requirements.