azure-service-operator icon indicating copy to clipboard operation
azure-service-operator copied to clipboard

Bug: Cannot log into MySQL as MySQLAADUser representing a group

Open matthchr opened this issue 4 years ago • 4 comments
trafficstars

Describe the bug MySQLAADUser representing an AAD Group cannot be logged in as on the MySQL server.

To Reproduce Steps to reproduce the behavior:

  1. Create a MySQLAADUser for a group. Specify the group name as the Username and the group object ID as the AADID.
  2. Observe that the user reconciles successfully.
  3. Attempt to log in to the user in MySQL, following the instructions. Specifically: "When logging in, members of the group will use their personal access tokens, but sign with the group name specified as the username."

Expected behavior I am able to log in as the user.

matthchr avatar Mar 30 '21 20:03 matthchr

Flexible server is adding support for this sometime later this year (~Nov timeframe). Until then we have to live with this issue as we can't work around it.

matthchr avatar Jul 19 '21 22:07 matthchr

We believe flexible support has been delayed, and are trying to find out the new estimate.

theunrepentantgeek avatar Feb 22 '22 20:02 theunrepentantgeek

It sounds like this was delayed until ~Sept 2022

matthchr avatar Feb 23 '22 22:02 matthchr

Still waiting on this from the product team AFAIK

matthchr avatar Jun 13 '22 23:06 matthchr

The product team has recently release support for this for MySQL Flexible Server. We now need to implement support for it in ASO.

matthchr avatar Oct 31 '22 22:10 matthchr

I'm currently working on support for this in MySQL FlexibleServer

matthchr avatar May 01 '23 22:05 matthchr