Reset expired user's password for user with priviledge to set passwords - link to issue #172

[codonAG2]

Hi, We do have the same problem again as in closed issue #172. However, the solution below did not work this time. Any idea what we can do to reset the admin password? ... for now it is easiest to create a temporary user (with local authentication), and then use it to change the expired user's password.

so to create such temporary "phoenix1" user (with priviledge to set passwords), log in to the phoenix VM console and run below command (taken from install.sh):

sudo -u ctsms /ctsms/dbtool.sh -cu -dlk <MY_DEPARTMENT> -dp <DEPARTMENT_PASSWORD> -u "phoenix1" -p <USER_PASSWORD> -pp "INVENTORY_MASTER_ALL_DEPARTMENTS,STAFF_MASTER_ALL_DEPARTMENTS,COURSE_MASTER_ALL_DEPARTMENTS,TRIAL_MASTER_ALL_DEPARTMENTS,PROBAND_MASTER_ALL_DEPARTMENTS,USER_ALL_DEPARTMENTS,INPUT_FIELD_MASTER,MASS_MAIL_MASTER_ALL_DEPARTMENTS,INVENTORY_MASTER_SEARCH,STAFF_MASTER_SEARCH,COURSE_MASTER_SEARCH,TRIAL_MASTER_SEARCH,PROBAND_MASTER_SEARCH,USER_MASTER_SEARCH,INPUT_FIELD_MASTER_SEARCH,MASS_MAIL_MASTER_SEARCH"

• <MY_DEPARTMENT> : your department name (ie. "my_department")
• <DEPARTMENT_PASSWORD> : the passphrase of yourdepartment, see last line of /home/phoenix/install.log
• <USER_PASSWORD> : the password of your new "phoenix1" user

there is also an interactive form of the command:

sudo -u ctsms /ctsms/dbtool.sh --create_user_interactive

after logging into the webUI with the phoenix1 user, search&open your expired user, and set a fresh password.

Originally posted by @rkrenn in https://github.com/phoenixctms/ctsms/issues/172#issuecomment-848645468

[rkrenn]

what exactly is the issue

• did creating the separate user failed?
• or is there an error when setting the topical user's password?

pls also note you can simply disable password expiration.

-- [email protected]

[codonAG2]

Hi, The department password seems to be the issue. We have been reading it from the install.log about 15 times. See attached screenshot.

Best regards, Anja

[codonAG2]

[rkrenn]

pls try without the quotes.

also note that the $ in "Passw0rd$09" will try to do a variable interpolation.

[rkrenn]

did you manage to sort it out?

[codonAG2]

Sorry, but the admin user is not available until 11-09. I will send an update asap. Thanks for the hint so far.

[codonAG2]

Hi, removing the quotes did not work as well as avoiding the $ in "Passw0rd$09". Any other idea? If not we would have to setup the phoenix instance again. In case we do so, is there a way to re-import CRF data into a new phoenix instance? I know you can re-import the CRF setup but what about data and what do we have to take care of to do so?

[rkrenn]

If not we would have to setup the phoenix instance again.

if your department password got lost, you could create another department - the consequence is that you cannot read PII (name, DoB, addresses, ..) of subjects of other departments. but maybe you did not enter these data anyway, as usual for CDMS use. and pls turn off user password expiries in the future :-/

I know you can re-import the CRF setup but what about data and what do we have to take care of to do so?

yes you can re-import eCRF setup AND also data.

• https://github.com/phoenixctms/ctsms/issues/104
• https://github.com/phoenixctms/bulk-processor/pull/9
• https://github.com/phoenixctms/ctsms/pull/171

just export the eCRF data, then take one of the "horizontal" format and import it using the importer job:

if you used an ancient phoenix version, ensure the header row (containing the column names) of the horizontal file matches the expected header row of the new phoenix version.

[codonAG]

We installed a new phoenixCTMS Server and will import the data from the old one.

Issue can be closed.