Azure SQL Firewall Rules IP parameters missing
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 35/100
- Issue type
- Bug
- Clarity
- Mostly clear
- Activity status
- Stale
- Tech stack
- azure, powershell
- Domain
- cloud, databases, networking
Research direction
The issue names no source files, entry points, or tests. Reproduce the export with an Azure SQL firewall rule, then trace the generated ARM JSON and compare it with the portal resource. Done means the exported firewall-rule resource includes the source IP parameters and the relevant tests pass.
Written by the indexing model from the issue text.
Description
We are trying to help a customer using AzOps to Backup their Azure Infrastructure ARM configuration.
The AIM is to have history of the changes in case of accidental deletion.
We found the JSON generated form the tool missing a parameter in case of Firewall Rules applied to an Azure SQL.
To reproduce:
- Create an Azure SQL
- Apply a Firewall rule with a source IP Address.
- Find the Source IP address in the generated JSON.
Here the resource in the portal:
Here the generated JSON:
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"metadata": {
"_generator": {
"name": "AzOps"
}
},
"parameters": {},
"variables": {},
"resources": [
{
"apiVersion": "2022-05-01-preview",
"name": "deletedbtest/ClientIPAddress_2023-3-1_15-26-4",
"type": "Microsoft.Sql/servers/firewallRules"
}
],
"outputs": {}
}
- Dominant language
- PowerShell
- Stars
- 420
- Forks
- 174
- Avg merge
- 16d 18h
- Merged PRs (30d)
- 1
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from Azure/AzOps
-
Difficulty 1/5 Under an hour Newbie friendliness 90/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
-
Difficulty 3/5 1-2 days Newbie friendliness 78/100
-
Difficulty 4/5 3-5 days Newbie friendliness 42/100
-
Difficulty 4/5 3-5 days Newbie friendliness 28/100
Similar issues
-
[BUG] ECR GetAuthorizationToken returns a proxyEndpoint for the default region, not the request's Openbug ecr
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
docs-from-code
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
microsoft/aspire.dev#1734 ·
-
[BUG] Openbug needs-triage
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
openwallet-foundation/eudiplo#1067 · 1 comment ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
hashicorp/go-azure-helpers#286 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
akash-network/community#1526 ·