A bug in RR template for VSTS?
I recently faced an issue that seems like a bug, related to RR template in VSTS. It turned out that the build procedure in VSTS ceased working. The reason surprised me, as I didn’t expect to find a bug in VSTS. I heavily use environment variables and to hide a password I normally check “Change variable type to secret” checkbox (see a screenshot below):
So, RR passwords (shadow and target) are not an exception, but after checking this checkbox the build procedure start failing with the following message: “##[error] (0,0): Error : An error occurred while attempting to verify your deployment scripts: Login failed for user ‘db_user’”. After I deselect this checkbox and re-enter the password, everything back to normal. Please notice that the “TargetPassword” variable works perfectly with ‘secret’ passwords.
So, RR passwords (shadow and target) are not an exception, but after checking this checkbox the build procedure start failing with the following message: “##[error] (0,0): Error : An error occurred while attempting to verify your deployment scripts: Login failed for user ‘db_user’”. After I deselect this checkbox and re-enter the password, everything back to normal. Please notice that the “TargetPassword” variable works perfectly with ‘secret’ passwords.
Tagged:
Answers
We released the new version 2.1.5 to the VSTS marketplace (https://marketplace.visualstudio.com/items?itemName=redgatesoftware.redgate-readyroll), this version fixes the issue where you couldn't use secret in ShadowPassword.
Kind regards,
Greg
I tried the new version already and it works as expected. Thanks a lot for updating it so quickly.