Not able to create Virtual Network Rule for MySQL flexible server using powershell code

MONDALABDULKADIR-7547 25

Hello Team ,

Actually we have IAC infracture to deploy MYSQL DBaaS services. However the existing terraform modules now has been depreciated and we are trying to upgrade the latest terraform module to deploy the same.

Now the issue is:-

In the existing code we are using "azurerm_mysql_firewall_rule" but in latest terraform module same module has been depreciated.

We are trying to deploy the MySQL flexible server using terraform and want to create Virtual Network Rule for MySQL using powershell module "New-AzMySqlVirtualNetworkRule" but doesn't work it seems.

Can someone please help just to create the Virtual Network Rule for existing MySQL flexible server without creating DNS zone , Records , Private Endpoints ets?

I could not see any azure powershell API for the same.

Used code:-

$virtualNetworkRule = New-AzMySqlVirtualNetworkRule -ResourceGroupName $resourceGroupName `

-ServerName $serverName `

-VirtualNetworkRuleName "myVnetRule" `

-SubnetId $subnet.Id

Error:-

New-AzMySqlVirtualNetworkRule : Failed to perform 'write' on resource(s) of type 'servers/virtualNetworkRules', because the parent resource

/subscriptions/xxxxxxx/resourceGroups/xxxxxxxxxx/providers/Microsoft.DBforMySQL/servers/weemeasbxtestmysql1' could not be found.

Thanks ,

Abdul Kadir

1 answer

Syed Mohsin Abbas 5 Reputation points

2024-10-17T15:27:05.51+00:00

The error indicates that the MySQL server resource isn’t found. Ensure the server name and resource group are correct in your code. Additionally, make sure that the MySQL flexible server is properly deployed before running the New-AzMySqlVirtualNetworkRule command.

If the issue persists, check if the required permissions to write to the virtual network rules are set, and ensure you're using the correct API version for flexible servers.
Please sign in to rate this answer.
MONDALABDULKADIR-7547 25 Reputation points

2024-10-17T16:00:08.67+00:00

Hello Abbas, Could you please share me the correct API. Resource is correctly deployed and also have the write permission.

Syed Mohsin Abbas 5 Reputation points

2024-10-17T17:37:05.2633333+00:00

Hello Kadir ,

If the resource is correctly deployed and permissions are in place, you may be using an incorrect API version. Try using the API version 2021-05-01 for MySQL flexible servers. Here's an example of how to specify it:

PowerShell Copy code New-AzMySqlVirtualNetworkRule -ResourceGroupName $resourceGroupName ` -ServerName $serverName ` -VirtualNetworkRuleName "myVnetRule" ` -SubnetId $subnet.Id ` -ApiVersion "2021-05-01"

This should ensure compatibility with the MySQL flexible server deployment.

MONDALABDULKADIR-7547 25 Reputation points

2024-10-18T07:46:24.4366667+00:00

Hello Abbas ,

As you suggested I have tried with above powershell script but getting below error.

New-AzMySqlVirtualNetworkRule : A parameter cannot be found that matches parameter name 'ApiVersion'.

At line:5 char:5

-ApiVersion "2021-05-01"

~~~~~~~~~~~

CategoryInfo : InvalidArgument: (:) [New-AzMySqlVirtualNetworkRule], ParameterBindingException

FullyQualifiedErrorId : NamedParameterNotFound,New-AzMySqlVirtualNetworkRule

Moreover , I am not sure if we can create Virtual network rule for flexiable server

MONDALABDULKADIR-7547 25 Reputation points

2024-10-18T12:48:32.01+00:00

Also one more observation from my side is once we are running this API New-AzMySqlVirtualNetworkRule without "-ApiVersion "2021-05-01" tag ,

It's failing with

/subscriptions/xxxxxxx/resourceGroups/xxxxxxxxxx/providers/Microsoft.DBforMySQL/servers/weemeasbxtestmysql1' could not be found.

But If I look at the original resource details where the MySQL flexible server resourceID is as below

Actual ResourceId : /subscriptions/xxxxx/resourceGroups/xxxxx/providers/Microsoft.DBforMySQL/flexibleServers/weemeasbxtestmysql1

Here the issue is API is looking for below ID.

/subscriptions/xxxxxxx/resourceGroups/xxxxxxxxxx/providers/Microsoft.DBforMySQL/servers/weemeasbxtestmysql1'

Sai Raghunadh M 895 Reputation points Microsoft Vendor

2024-10-21T18:49:42.0933333+00:00

Hi @MONDALABDULKADIR-7547,

Did your issue got resolved?

Sai Raghunadh M 895 Reputation points Microsoft Vendor

2024-10-22T18:55:39.1433333+00:00

Hi @MONDALABDULKADIR-7547,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

MONDALABDULKADIR-7547 25 Reputation points

2024-10-23T01:45:14.91+00:00

Hello, Still I don't have any resolution. Still waiting for the resolution. Thanks, Abdul

Sai Raghunadh M 895 Reputation points Microsoft Vendor

2024-10-23T16:31:46.82+00:00

Hi @MONDALABDULKADIR-7547,

Please go through these documents that might help you.

https://video2.skills-academy.com/en-us/azure/mysql/flexible-server/concepts-networking-vnet

https://video2.skills-academy.com/en-us/powershell/module/az.mysql/new-azmysqlvirtualnetworkrule?view=azps-12.4.0&viewFallbackFrom=azps-12.2.0

Sai Raghunadh M 895 Reputation points Microsoft Vendor

2024-10-24T17:50:08.1733333+00:00

Hi @MONDALABDULKADIR-7547,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Not able to create Virtual Network Rule for MySQL flexible server using powershell code

1 answer

Your answer