User profile for ColinSmit

Alistair This does not work., you have inverted comma's around the whole parameter, was this intentional? Either way, I tried it as you have suggested and it does not resolve the variable. ERROR: Unexpected error org.flywaydb.core.api.FlywayException: Unsupported database type for changes Build url: $env:CheckJDBC / comments

AlistairThis does not work., you have inverted comma's around the whole parameter, was this intentional?Either way, I tried it as you have suggested and it does not resolve the variable.ERROR: Unex...

0 votes

Good day Alistair Since you have not responded to my post in some time, I thought I'd update this with some new findings. In an effort to get away from username and password (since the password variable cannot be obtained) I have made use of integrated security, where the VSTS agent uses an MSA Account, and set integrated security to true. Added the MSA Account to all the relevant DB's with sa rights which works like a dream. The problem I am encountering remains with the -check parameter, I can set the build DB URL via a variable and it is resolved, but I cannot set the check DB URL via a variable as it does not get resolved. I can set the check DB URL to the actual JDBC of the check DB and it works. - script: '${{parameters.FlywayCommand}} -X check -changes -drift -code -environment="Dev" -environments.Dev.url="$(JDBC) -environments.check.url="${{parameters.CheckJDBCConnectionString}}" -check.buildEnvironment="check" -reportFilename="$(System.DefaultWorkingDirectory)\${{parameters.Environment}}-${{parameters.DriftandChangeReportOutputName}}"' - script: '${{parameters.FlywayCommand}} -X check -changes -drift -code -environment="Dev" -environments.Dev.url="$(JDBC) -environments.check.url="${CheckJDBC}" -check.buildEnvironment="check" -reportFilename="$(System.DefaultWorkingDirectory)\${{parameters.Environment}}-${{parameters.DriftandChangeReportOutputName}}"' - script: '${{parameters.FlywayCommand}} -X check -changes -drift -code -environment="Dev" -environments.Dev.url="$(JDBC) -environments.check.url="$(CheckJDBC)" -check.buildEnvironment="check" -reportFilename="$(System.DefaultWorkingDirectory)\${{parameters.Environment}}-${{parameters.DriftandChangeReportOutputName}}"' None of the above works as the -check parameter url is never resolved, however; substituting the actual JDBC: - script: '${{parameters.FlywayCommand}} -X check -changes -drift -code -environment="Dev" -environments.Dev.url="jdbc:sqlserver://Dev13.directtransact.corp:2433;encrypt=false;databaseName=DIRENT_YOCO_DEV" -environments.Check.url="jdbc:sqlserver://Dev13.directtransact.corp:2433;encrypt=false;databaseName=DIRENT_YOCO_DEV_Check" -check.buildEnvironment="Check" -reportFilename="Report.html"' This works perfectly. I believe there may be a bug in the software that has not yet been identified or attended to, please can you confirm whether I am missing something or a bug does exist. Regards / comments

Good day AlistairSince you have not responded to my post in some time, I thought I'd update this with some new findings.In an effort to get away from username and password (since the password varia...

0 votes

Thank you very much, that was the information I was looking for! However, when the password value in the variable group is saved as a secret the command fails with: Suppressed: org.flywaydb.core.api.FlywayException: Unable to resolve environment variable: 'DatabasePassword' But if the password value is stored in clear text everything works as intended. Could you check to see if this is a known issue or am I missing something? [flyway.check] majorTolerance = 0 buildEnvironment="build" [environments.build] url = "${env.BuildJDBC}" user = "${env.DatabaseLogin}" password = "${env.DatabasePassword}" Variable group has the variable all 3 variables as above. / comments

Thank you very much, that was the information I was looking for! However, when the password value in the variable group is saved as a secret the command fails with:Suppressed: org.flywaydb.core.ap...

0 votes

How can we help you today?

ColinSmit

Activity overview