[AVM Question/Feedback]: Db-for-my-sql/flexible-server - Unable to add admin #4403

mahlatseprince · 2025-02-07T12:00:36Z

Check for previous/existing GitHub issues

I have checked for previous/existing GitHub issues

Description

Hi there,

I am unable to add administrators when deploying a MySQL Flexible Server. the server builds and fails on adding the administrator. it gives the below generic error.

{"code":"InternalServerError","message":"An unexpected error occured while processing the request. Tracking ID: '3a49570a-5473-48fd-9943-1ce463029288'"}

microsoft-github-policy-service · 2025-02-07T12:00:48Z

Important

The "Needs: Triage 🔍" label must be removed once the triage process is complete!

Tip

For additional guidance on how to triage this issue/PR, see the BRM Issue Triage documentation.

AlexanderSehr · 2025-02-11T08:38:34Z

Hey @mahlatseprince ,
thank you for the issue. I just assigned the module owners. For the future, please create issues for modules as 'Module Issues' as they then get auto-assigned to the module's owners :)

microsoft-github-policy-service · 2025-02-14T12:21:59Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

hundredacres · 2025-02-14T19:42:33Z

@mahlatseprince can I see some code? We add administrators in our tests and those have been running fine.

mahlatseprince98 · 2025-02-16T12:32:41Z

@hundredacres here's my piece of code below. I want to enable AD authentication for this server but i can't seem to add the admin

@description('The name for the MySQL server.')
param mysqlServerName string

@description('The pricing tier of the MySQL server.')
@allowed([
  'Burstable'
  'GeneralPurpose'
  'MemoryOptimized'
])
param tier string

@description('The SKU of the MySQL server.')
@allowed([
  'Standard_B2s'
  'Standard_B2ms'
  'Standard_B2s'
  'Standard_B4ms'
  'Standard_B8ms'
  'Standard_B12ms'
  'Standard_B16ms'
  'Standard_B20ms'
  'Standard_D2ds_v4'
  'Standard_D4ds_v4'
  'Standard_D8ds_v4'
  'Standard_D16ds_v4'
  'Standard_D32ds_v4'
  'Standard_D48ds_v4'
  'Standard_D64ds_v4'
  'Standard_E2ds_v4'
  'Standard_E4ds_v4'
  'Standard_E8ds_v4'
  'Standard_E16ds_v4'
  'Standard_E32ds_v4'
  'Standard_E48ds_v4'
  'Standard_E64ds_v4'
  'Standard_E96ds_v4'
  'Standard_E2ds_v5'
])
param skuName string

@description('Max storage allowed for a server. In all compute tiers, the minimum storage supported is 20 GiB and maximum is 16 TiB')
@allowed([
  20
  32
  64
  128
  256
  512
  1024
  2048
  4096
  8192
  16384
])
param StorageSizeGB int

@description('Storage IOPS for a server. Max IOPS are determined by compute size')
@minValue(360)
@maxValue(48000)
param IOPS int

@description('MySQL version.')
@allowed([
  '8.0.21'
])
param mysqlVersion string

@allowed([
  'Disabled'
  'ZoneRedundant'
  'SameZone'
])
param HighAvailability string

@description('delegate subnet name for the server.')
param delegatedSubnetName string

@description('Entra admin username for the server.')
@minLength(1)
param adminUsername string

@description('Entra admin type. E.g User, Group or Application')
@allowed([
  'User'
  'Group'
  'Application'
])
param entraAdminType string

@description('Entra admin object Id')
param entraAdminObjectId string

@description('The name of the identity used for AAD Authentication. needs directory reader role in Microsoft Entra')
param mysqluserAssignedIdentity string

var details = split(subscription().displayName, '-')
var environment = details[3]
var region = details[4]
var appName = details[2]
var standardPrefix = 'sbg5'

var privateEndpointSubnetId = '/subscriptions/${subscription().subscriptionId}/resourceGroups/${region}-BaseInfra/providers/Microsoft.Network/virtualNetworks/${standardPrefix}-vnet-${environment}-${appName}/subnets/${standardPrefix}-subn-${environment}-${appName}-pep'
var delegatedSubnetId = '/subscriptions/${subscription().subscriptionId}/resourceGroups/${region}-BaseInfra/providers/Microsoft.Network/virtualNetworks/${standardPrefix}-vnet-${environment}-${appName}/subnets/${delegatedSubnetName}'
//
resource userAssignedIdentity 'Microsoft.ManagedIdentity/userAssignedIdentities@2023-07-31-preview' existing = {
  name: mysqluserAssignedIdentity
  scope: resourceGroup()
}

module mysqlDbFlexibleServer 'br/public:avm/res/db-for-my-sql/flexible-server:0.6.1' = {
  name: 'mysqlDbFlexibleServer'
  params: {
    name: mysqlServerName
    skuName: skuName
    tier: tier
    location: resourceGroup().location
    publicNetworkAccess: 'Disabled'
    storageAutoGrow: 'Enabled'
    storageIOPS: IOPS
    storageSizeGB: StorageSizeGB
    highAvailability: HighAvailability
    administratorLogin: adminUsername
    administratorLoginPassword: 'hgdgpiaggty@98'
    administrators: [
      {
        login: adminUsername
        sid: entraAdminObjectId
        identityResourceId: userAssignedIdentity.id
      }
    ]
    managedIdentities: {
      userAssignedResourceIds: [
        userAssignedIdentity.id
      ]
    }
    version: mysqlVersion
    advancedThreatProtection: 'Enabled'
    createMode: 'Default'
  }
}

microsoft-github-policy-service · 2025-02-20T12:13:54Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-02-25T13:31:40Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-02-25T13:31:55Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

microsoft-github-policy-service · 2025-03-03T13:54:55Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-03-03T13:55:12Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

microsoft-github-policy-service · 2025-03-07T12:04:48Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-03-07T12:05:15Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

microsoft-github-policy-service · 2025-03-13T12:14:21Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-03-13T12:14:51Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

microsoft-github-policy-service · 2025-03-19T12:29:08Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-03-19T12:30:38Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

microsoft-github-policy-service · 2025-03-25T12:09:39Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-03-25T12:10:51Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

microsoft-github-policy-service · 2025-03-31T14:17:00Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-03-31T14:18:28Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

microsoft-github-policy-service · 2025-04-04T12:27:03Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-04-04T12:28:21Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

microsoft-github-policy-service · 2025-04-10T12:32:03Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-04-10T12:33:55Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

microsoft-github-policy-service · 2025-04-16T12:15:00Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-04-16T12:16:35Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

microsoft-github-policy-service · 2025-04-21T17:12:58Z

Warning

Tagging the AVM Core Team (@Azure/avm-core-team-technical-bicep) due to a module owner or contributor having not responded to this issue within 3 business days. The AVM Core Team will attempt to contact the module owners/contributors directly.

Tip

To prevent further actions to take effect, the "Status: Response Overdue 🚩" label must be removed, once this issue has been responded to.
To avoid this rule being (re)triggered, the ""Needs: Triage 🔍" label must be removed as part of the triage process (when the issue is first responded to)!

microsoft-github-policy-service · 2025-04-21T17:14:22Z

Caution

**This issue requires the AVM Core Team's (@Azure/avm-core-team-technical-bicep) immediate attention as it hasn't been responded to within 6 business days. **

Tip

To avoid this rule being (re)triggered, the "Needs: Triage 🔍" and "Status: Response Overdue 🚩" labels must be removed when the issue is first responded to!
Remove the "Needs: Immediate Attention ‼️" label once the issue has been responded to.

mahlatseprince added Needs: Triage 🔍 Type: AVM 🅰️ ✌️ Ⓜ️ Type: Question/Feedback 🙋 labels Feb 7, 2025

AlexanderSehr assigned hundredacres Feb 11, 2025

AlexanderSehr changed the title ~~[AVM Question/Feedback]:~~ [AVM Question/Feedback]: Db-for-my-sql/flexible-server - Unable to add admin Feb 11, 2025

microsoft-github-policy-service bot added the Status: Response Overdue 🚩 label Feb 14, 2025

hundredacres removed the Status: Response Overdue 🚩 label Feb 14, 2025

microsoft-github-policy-service bot added the Status: Response Overdue 🚩 label Feb 20, 2025

microsoft-github-policy-service bot added the Needs: Immediate Attention ‼️ label Feb 25, 2025

hundredacres linked a pull request Apr 16, 2025 that will close this issue

Adding entra-id support #5071

Draft

11 tasks

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[AVM Question/Feedback]: Db-for-my-sql/flexible-server - Unable to add admin #4403

[AVM Question/Feedback]: Db-for-my-sql/flexible-server - Unable to add admin #4403

mahlatseprince commented Feb 7, 2025

microsoft-github-policy-service bot commented Feb 7, 2025

AlexanderSehr commented Feb 11, 2025

microsoft-github-policy-service bot commented Feb 14, 2025

hundredacres commented Feb 14, 2025

mahlatseprince98 commented Feb 16, 2025 •

edited by AlexanderSehr

Loading

microsoft-github-policy-service bot commented Feb 20, 2025

microsoft-github-policy-service bot commented Feb 25, 2025

microsoft-github-policy-service bot commented Feb 25, 2025

microsoft-github-policy-service bot commented Mar 3, 2025

microsoft-github-policy-service bot commented Mar 3, 2025

microsoft-github-policy-service bot commented Mar 7, 2025

microsoft-github-policy-service bot commented Mar 7, 2025

microsoft-github-policy-service bot commented Mar 13, 2025

microsoft-github-policy-service bot commented Mar 13, 2025

microsoft-github-policy-service bot commented Mar 19, 2025

microsoft-github-policy-service bot commented Mar 19, 2025

microsoft-github-policy-service bot commented Mar 25, 2025

microsoft-github-policy-service bot commented Mar 25, 2025

microsoft-github-policy-service bot commented Mar 31, 2025

microsoft-github-policy-service bot commented Mar 31, 2025

microsoft-github-policy-service bot commented Apr 4, 2025

microsoft-github-policy-service bot commented Apr 4, 2025

microsoft-github-policy-service bot commented Apr 10, 2025

microsoft-github-policy-service bot commented Apr 10, 2025

microsoft-github-policy-service bot commented Apr 16, 2025

microsoft-github-policy-service bot commented Apr 16, 2025

microsoft-github-policy-service bot commented Apr 21, 2025

microsoft-github-policy-service bot commented Apr 21, 2025

[AVM Question/Feedback]: Db-for-my-sql/flexible-server - Unable to add admin #4403

[AVM Question/Feedback]: Db-for-my-sql/flexible-server - Unable to add admin #4403

Comments

mahlatseprince commented Feb 7, 2025

Check for previous/existing GitHub issues

Description

microsoft-github-policy-service bot commented Feb 7, 2025

AlexanderSehr commented Feb 11, 2025

microsoft-github-policy-service bot commented Feb 14, 2025

hundredacres commented Feb 14, 2025

mahlatseprince98 commented Feb 16, 2025 • edited by AlexanderSehr Loading

microsoft-github-policy-service bot commented Feb 20, 2025

microsoft-github-policy-service bot commented Feb 25, 2025

microsoft-github-policy-service bot commented Feb 25, 2025

microsoft-github-policy-service bot commented Mar 3, 2025

microsoft-github-policy-service bot commented Mar 3, 2025

microsoft-github-policy-service bot commented Mar 7, 2025

microsoft-github-policy-service bot commented Mar 7, 2025

microsoft-github-policy-service bot commented Mar 13, 2025

microsoft-github-policy-service bot commented Mar 13, 2025

microsoft-github-policy-service bot commented Mar 19, 2025

microsoft-github-policy-service bot commented Mar 19, 2025

microsoft-github-policy-service bot commented Mar 25, 2025

microsoft-github-policy-service bot commented Mar 25, 2025

microsoft-github-policy-service bot commented Mar 31, 2025

microsoft-github-policy-service bot commented Mar 31, 2025

microsoft-github-policy-service bot commented Apr 4, 2025

microsoft-github-policy-service bot commented Apr 4, 2025

microsoft-github-policy-service bot commented Apr 10, 2025

microsoft-github-policy-service bot commented Apr 10, 2025

microsoft-github-policy-service bot commented Apr 16, 2025

microsoft-github-policy-service bot commented Apr 16, 2025

microsoft-github-policy-service bot commented Apr 21, 2025

microsoft-github-policy-service bot commented Apr 21, 2025

mahlatseprince98 commented Feb 16, 2025 •

edited by AlexanderSehr

Loading