Unknown Resolver: {azureAdInteractive}
Azhkanizkael
Posts: 25 Bronze 2
Version: Flyway Desktoip Enterprise v6.5.0
Flyway Engine: 9.20.1
Git: 2.40.1
Redgate Compare: 1.14.1.10156
Authentication Method: Azure Active Directory Universal with MFA
Whenever I go to connect to a database or generate a migration, I'm met with this error "Flyway returned a non-zero exit code. Unknown Resolver: {azureAdInteractive}"
Any ideas?
Flyway Engine: 9.20.1
Git: 2.40.1
Redgate Compare: 1.14.1.10156
Authentication Method: Azure Active Directory Universal with MFA
Whenever I go to connect to a database or generate a migration, I'm met with this error "Flyway returned a non-zero exit code. Unknown Resolver: {azureAdInteractive}"
Any ideas?
Tagged:
Best Answer
-
Peter_Laws Posts: 259 Silver 2Hello 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.
Answers
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.
Updated to 6.5.3 today and still no luck.
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.
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.
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.
Same machine, same version of flyway, left one is just trying to create a new repo and the right is using an existing one.
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}
Please stay on the .JSON format since that's working, it will persist for a little while before TOML replaces it.
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}
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.