Az.Network | New-AzFirewallPolicyApplicationRule does not allow Mssql as the protocol

v-royavinash commented 2 years ago

Description

Az.Network | New-AzFirewallPolicyApplicationRule does not allow Mssql as the protocol.

On Azure portal there are 3 supported protocols i.e. http, https, mssql.

Issue script & Debug output

New-AzFirewallPolicyApplicationRule -Name AR1 -SourceAddress "192.168.0.0/16" -Protocol "http:80","mssql:1443" -WebCategory "DatingAndPersonals", "Tasteless"

Environment data

NA

Module versions

Applicable to all the versions.

Error output

New-AzFirewallPolicyApplicationRule: Invalid protocol mssql:1443

ghost commented 2 years ago

Thank you for your feedback. This has been routed to the support team for assistance.

ghost commented 2 years ago

Thank you for your feedback. This has been routed to the support team for assistance.

SaurabhSharma-MSFT commented 2 years ago

@v-royavinash I could see the same and it looks like this is not supported and redirecting this to service team to provide their inputs.

Thanks Saurabh

ghost commented 2 years ago

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @fwsuppgithub.

Issue Details

### Description Az.Network | New-AzFirewallPolicyApplicationRule does not allow Mssql as the protocol. On Azure portal there are 3 supported protocols i.e. http, https, mssql. ![image](https://user-images.githubusercontent.com/94480537/150575154-932b1e0b-69d1-45b3-8c30-7a6d35051ad4.png) ### Issue script & Debug output ```PowerShell New-AzFirewallPolicyApplicationRule -Name AR1 -SourceAddress "192.168.0.0/16" -Protocol "http:80","mssql:1443" -WebCategory "DatingAndPersonals", "Tasteless" ``` ### Environment data ```PowerShell NA ``` ### Module versions ```PowerShell Applicable to all the versions. ``` ### Error output ```PowerShell New-AzFirewallPolicyApplicationRule: Invalid protocol mssql:1443 ```

Author:	v-royavinash
Assignees:	SaurabhSharma-MSFT
Labels:	`Service Attention`, `bug`, `question`, `customer-reported`, `Network - Firewall`
Milestone:	-

diogomaul commented 2 years ago

Hello team,

Any updates on this issue? I have a big firewall policy migration and right now this problem is a show stopper.

diogomaul commented 2 years ago

Hi @SaurabhSharma-MSFT , Can you assign this issue to me?

I fixed this locally for my own use. I believe I can push it back to you in the next few days.

fwsuppgithub commented 2 years ago

@Jiejiong @.***> please take a look.

Get Outlook for iOShttps://aka.ms/o0ukef

From: Diogo Maul @.> Sent: Friday, May 20, 2022 8:30:34 AM To: Azure/azure-powershell @.> Cc: Firewall Supportability GitHub Contacts @.>; Mention @.> Subject: Re: [Azure/azure-powershell] Az.Network | New-AzFirewallPolicyApplicationRule does not allow Mssql as the protocol (Issue #16894)

Hi @SaurabhSharma-MSFThttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FSaurabhSharma-MSFT&data=05%7C01%7CGirish.Motwani%40microsoft.com%7C68f9cc74586d445b058b08da3a75af3e%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637886574392353564%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=AsChPnaK3xMd445I4nlcjKp8XFpHVe7X%2BMzXHfWPqs0%3D&reserved=0 , Can you assign this issue to me?

I fixed this locally for my own use. I believe I can push it back to you in the next few days.

— Reply to this email directly, view it on GitHubhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FAzure%2Fazure-powershell%2Fissues%2F16894%23issuecomment-1133039951&data=05%7C01%7CGirish.Motwani%40microsoft.com%7C68f9cc74586d445b058b08da3a75af3e%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637886574392353564%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=rmCa90yRQJmBblLQ9KM3vl%2BPeumQXxPCTKyGGziE%2Fck%3D&reserved=0, or unsubscribehttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAREIPQWNYLUX6JNAJCDPGJLVK6VZVANCNFSM5MQDWU5Q&data=05%7C01%7CGirish.Motwani%40microsoft.com%7C68f9cc74586d445b058b08da3a75af3e%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637886574392353564%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2Buu3UYNsKCaHHjoY9lNeNIxxTDOPRcDLPQ11c3tnFsA%3D&reserved=0. You are receiving this because you were mentioned.Message ID: @.***>

fwsuppgithub commented 1 year ago

Adding @Gustavo @.***> for visibility.

From: Girish Motwani @.> Sent: Friday, May 20, 2022 8:32 AM To: Azure/azure-powershell @.>; Azure/azure-powershell @.>; Jiejiong Wu @.> Cc: Firewall Supportability GitHub Contacts @.>; Mention @.> Subject: Re: [Azure/azure-powershell] Az.Network | New-AzFirewallPolicyApplicationRule does not allow Mssql as the protocol (Issue #16894)

@Jiejiong @.***> please take a look.

Get Outlook for iOShttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Faka.ms%2Fo0ukef&data=05%7C01%7COluwatobi.Otolorin%40microsoft.com%7Cd4d229aa1b30445f7df308da3a75ee63%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637886575469186753%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=AfB9gsZwLoLavQFkqDCrtFZ9HVzTh%2BsxJOLBTj4lb%2BI%3D&reserved=0

From: Diogo Maul @.**@.>> Sent: Friday, May 20, 2022 8:30:34 AM To: Azure/azure-powershell @.**@.>> Cc: Firewall Supportability GitHub Contacts @.**@.>>; Mention @.**@.>> Subject: Re: [Azure/azure-powershell] Az.Network | New-AzFirewallPolicyApplicationRule does not allow Mssql as the protocol (Issue #16894)

Hi @SaurabhSharma-MSFThttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FSaurabhSharma-MSFT&data=05%7C01%7COluwatobi.Otolorin%40microsoft.com%7Cd4d229aa1b30445f7df308da3a75ee63%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637886575469186753%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=gYrm8MRkFfOngv6ZgvEE14fipHZi2hQS64i%2F4UNpnuc%3D&reserved=0 , Can you assign this issue to me?

I fixed this locally for my own use. I believe I can push it back to you in the next few days.

- Reply to this email directly, view it on GitHubhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FAzure%2Fazure-powershell%2Fissues%2F16894%23issuecomment-1133039951&data=05%7C01%7COluwatobi.Otolorin%40microsoft.com%7Cd4d229aa1b30445f7df308da3a75ee63%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637886575469186753%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=wRCz6vlXLQ35B6T6JUFU2tpEBnHiLsPny6SZg17I3Wc%3D&reserved=0, or unsubscribehttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAREIPQWNYLUX6JNAJCDPGJLVK6VZVANCNFSM5MQDWU5Q&data=05%7C01%7COluwatobi.Otolorin%40microsoft.com%7Cd4d229aa1b30445f7df308da3a75ee63%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637886575469186753%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Pn%2BULsHl53Kg9xIvphS5vXzZQhJdggF%2FRlLOuX5Rug0%3D&reserved=0. You are receiving this because you were mentioned.Message ID: @.**@.>>

DaAntifreeze commented 1 year ago

Has this issue been resolved? I am still experiencing the exact same issue, where New-AzFirewallPolicyApplicationRule does not allow Mssql as the protocol.

Azure / azure-powershell