Unknown Resolver: {azureAdInteractive}

• 
  Hello Azhkanizkael,
  
  Are you using the updated config settings via the top of the project please?
  You don't need to, I'm just establishing so bounds to investigate from.

  Peter_Laws July 21, 2023 08:14

  - 0 +
• 
  Yes, it's using the new .toml files
  
  Updated to 6.5.3 today and still no luck.
  
  

  Azhkanizkael July 25, 2023 16:12

  - 0 +
• 
  My apologies for this rather crude test. I'm currently tracking an issue where the upgrade process isn't validating dependencies correctly resulting in some orphaning. However until that's resolved the fix is quite involved and the fast solution is crude.
  
  Please could you uninstall and reinstall the tool, verifying the install directory is empty once installed?
  If the issue persists after that then it's unrelated to the issue I'm referencing.
  
  Alternatively installing and testing the same process on another machine would be an equally viable test, whichever is the least effort for you.

  Peter_Laws July 25, 2023 16:40

  - 0 +
• 
  Uninstalled Flyway entirely
  Created an empty folder for the project to reside in
  Downloaded the latest (6.5.4)
  Installed to: "C:\Program Files\Red Gate\Flyway Desktop\flyway-desktop\Flyway Desktop.exe"
  Restarted Computer
  Created a new project and put it in the new empty folder
  Connect to VPN to ensure I can connect to database
  Connect to Dev Server => input values for AAD Universal with MFA and database server/name
  
  SQL State : S0001 Error Code : 18456 Message : Login failed for user ''.
  
  Attempted connection on an old project that wasn't upgraded yet to the .toml files and with the same information I was able to connect just fine.
  

  Azhkanizkael July 26, 2023 18:29

  - 0 +
• 
  Thank you so much for all the detail, it's most helpful!
  
  Ok so it appears that the reinstall fixed the issue I was concerned about, but the TOML config failed to correctly handle the auth. If you open the TOML file in the project directory, is the target host and auth method correctly represented?
  
  I'm glad you're unblocked, but I'd still like to get to the bottom of this if you're willing.

  Peter_Laws July 27, 2023 07:10

  - 0 +
• 
  It can't save the connection because it thinks it cannot connect. Whereas the other projects can connect just fine w/ the same values using the old config files.
  

  Azhkanizkael July 27, 2023 13:32

  - 0 +
• 
  On the left is the new .toml files and on the right is the old .json files.
  
  Same machine, same version of flyway, left one is just trying to create a new repo and the right is using an existing one.
  
  

  Azhkanizkael July 27, 2023 13:38

  - 0 +
• 
  Updated to 6.5.5
  
  new project:
  Still unable to connect to the database.
  
  existing project:
  stayed on .json files and was able to connect just fine.
  upgraded to .toml files and connection fails. Unknown resolver: {azureADInteractive}
  
  

  Azhkanizkael July 31, 2023 14:43

  - 0 +
• 
  Understood, thank you for the distinction, I think I know what it is now, I'll come back once I've verified.
  Please stay on the .JSON format since that's working, it will persist for a little while before TOML replaces it.

  Peter_Laws August 01, 2023 09:00

  - 0 +
• 
  Updated to v6.5.14
  
  new project:
  Still unable to connect to the database with Azure AD Universal with MFA. - Cannot create new flyway projects unless I downgrade to a previous version of Flyway Desktop as the current version forces usage of the .toml files
  
  existing project:
  stayed on .json files and was able to connect just fine.
  upgraded to .toml files and connection fails. Unknown resolver: {azureADInteractive}
  

  Azhkanizkael September 05, 2023 19:29

  - 0 +
• 
  Hello all,
  
  We believe this issue should be resolved as of the release of Flyway Desktop 6.11.2.
  Please do let us know if you have an issue on that version or later.

  Peter_Laws November 21, 2023 14:16

  - 0 +
• 
  Confirmed, the update to 6.11.2+ worked.

  Azhkanizkael November 21, 2023 17:44

  - 0 +
• 
  Thank you so much for confirming Azhkanizkael, I'll wait to confirm this works for the others too.
  
  It would be much appreciated if you could help by marking this as answered, that should help others suffering from the issue to find the answer.

  Peter_Laws November 23, 2023 17:08

  - 0 +

Add comment

Please sign in to leave a comment.