"[23-MAR-2021] [dx_set_dbpass [ -engine|d <delphix identifier> | -all ] [ -configfile file ][ -group group_name | -dbname db_name | -host host_name | -type dsource|vdb ] [-username <username>] -password <password> [ --help|? ] [ -debug ]"

Jgadelphix commented 3 years ago

Expected Behavior the db password should have been changed

Actual Behavior the db password is not changed and the following error is being displayed. It is complaining about a parameter that does not exist in the syntax of the command ex: D:\dxtoolkit2-v2.4.8-win64-installer\dxtoolkit2>dx_set_dbpass -d delphixenginecollector -group MSSQL_TEST -dbname "FX" -username svc_delphixdb_prod -password Password2 MS SQL database user type is now required Password check failed. Username or password is invalid. Problem with setting password Steps To Reproduce the Problem just type the command replacing the parameters by their values Steps to reproduce the behavior:

Go to '. your dxtoolkit drectory'
run the following command : dx_set_dbpass -d -group -dbname "" -username -password
. Scroll down to '....'
See error MS SQL database user type is now required Password check failed. Username or password is invalid. Problem with setting passwordScreenshots If applicable, add screenshots to help explain your problem.

Version dxtoolkit version 2.4.8 Additional Context Add any other context about the problem here, including additional logs or debugging information if appropriate.

Ranzo3 commented 3 years ago

Steps To Reproduce the Problem Attempting to change the DB Password for an already existing user

Version It worked in version of Delphix 5.3.8.1 version but not working with latest delphix 6.0.6.1 version. Probably a breaking change in the API.

Ranzo3 commented 3 years ago

Hypothesis (not proven): this is part of new change with option to create dSource using db user or os user, which was previously only db user.

Jgadelphix commented 3 years ago

Good Evening Ranzo, How are you? I was just about to post something on the TS channel as I did not want to annoy you with an email, because Michael took told ne that you answered to the post from Himanshu @OTPP, so I know you were interested in the solution:

Marcin and I worked on the issue together today and me with the customer ( did not want to create a lab for this lol!) We found out that the issue was the 6.0.0.0 + API and what we did, is exactly what you suggested in the previous email. So Marcin asked me file the issue and we corrected it the following way:

As the customer, OTPP , has both 5.3.8.1 and 6.0.0.1 engines, I had him run the commands on both.
It succeeded on the 5.3.8.1 and failed on the 6.0.0.1 engine.
So , we knew that the API was the culprit. So we ran it with the “ -dever 5.3” and it worked! Thanks JG From: Ranzo J Taylor, III @.> Date: Tuesday, March 23, 2021 at 16:42 To: delphix/dxtoolkit @.> Cc: Jgadelphix @.>, Author @.> Subject: Re: [delphix/dxtoolkit] "[23-MAR-2021] [dx_set_dbpass [ -engine|d | -all ] [ -configfile file ][ -group group_name | -dbname db_name | -host host_name | -type dsource|vdb ] [-username ] -password [ --help|? ] [...

Hypothesis (not proven): this is part of new change with option to create dSource using db user or os user, which was previously only db user.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/delphix/dxtoolkit/issues/176#issuecomment-805237785, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AREE3SA43B7ENK7BNSOB2ADTFD4J5ANCNFSM4ZVGH2QA.

Jgadelphix commented 3 years ago

Thanks

JG

From: Ranzo J Taylor, III @.> Date: Tuesday, March 23, 2021 at 15:26 To: delphix/dxtoolkit @.> Cc: Jgadelphix @.>, Author @.> Subject: Re: [delphix/dxtoolkit] "[23-MAR-2021] [dx_set_dbpass [ -engine|d | -all ] [ -configfile file ][ -group group_name | -dbname db_name | -host host_name | -type dsource|vdb ] [-username ] -password [ --help|? ] [...

Steps To Reproduce the Problem Attempting to change the DB Password for an already existing user

Version It worked in version of Delphix 5.3.8.1 version but not working with latest delphix 6.0.6.1 version. Probably a breaking change in the API.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/delphix/dxtoolkit/issues/176#issuecomment-805171648, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AREE3SB6SMGWPM6SNZWH2HDTFDTPDANCNFSM4ZVGH2QA.

marcinops commented 3 years ago

There was a problem with validating password call inside dxtoolkit. Fixed in version 2.4.11

delphix / dxtoolkit

"[23-MAR-2021] [dx_set_dbpass [ -engine|d <delphix identifier> | -all ] [ -configfile file ][ -group group_name | -dbname db_name | -host host_name | -type dsource|vdb ] [-username <username>] -password <password> [ --help|? ] [ -debug ]" #176