search

gatewayapps / ims-migration

Database migration tooling for IMS
1 stars 0 forks source link

Update Password not working properly #13

Open justinneff opened 7 years ago

justinneff commented 7 years ago

On multiple occasions, when I publish with the login password in single quotes, the password that gets updated for login in SQL Server is not correct. I have had to go in and manually change the password correctly.

This appears to only be an issue publishing from the command line as publishing from a node script does not suffer this issue. Suspect the problem has to do with the interpretation of the quoted arguments by yargs.

justinneff commented 7 years ago

I have tracked it down to what appears to be an issue in the yargs library. The caret (^) character is getting removed from the parsed parameter string value. Therefore any password containing a caret are being changed to a form without the caret.

I have opened an issue on the yargs project. https://github.com/yargs/yargs/issues/860

justinneff commented 7 years ago

This is a Windows command shell issue. See this SO post. There are several characters that Windows command shell and powershell treat as special characters. The characters & | ( < > ^ are reserved characters and may cause problems.

Possible, workarounds would include reading password for a file or prompting the user for the passwords after launching the command.