Menu

Reset Expired Password for qTest OnPremise's Admin Account

Overview

If you are using qTest OnPremise and your Admin or all qTest accounts expire, you can follow this instruction to your Security Settings and reactivate accounts in qTest.

Note: Enter the appropriate username for the account you wish to reactivate in the johnsampleuser@qasymphony.com variable in the code below.

Reactivate One Admin Account

To reactivate one admin account (one username), do the following:

  1. Stop the qTest service.
  2. Connect to the qTest database and run the following script:
    update clients set passwordhealthyperiod=0, passwordshelflife=0, maxfailedloginattempt=0, minimumuniquepasswordssequencelength=0
    where id in
    (select cu.clientid
    from client_users cu
    inner join users u on cu.userid = u.id
    where
    cu.credentialnonexpired = false and lower(u.username)=lower('johnsampleuser@qasymphony.com'));
    update client_users cu set credentialnonexpired=true, status=1
    from users u
    where
    u.id = cu.userid
    and cu.credentialnonexpired = false and lower(u.username)=lower('johnsampleuser@qasymphony.com');
  3. Restart the qTest service.
  4. Login to qTest and change the password.

Reactivate All Accounts

To reactivate all accounts, do the following:

  1. Stop the qTest service.
  2. Connect to the qTest database and run the following script:
    update clients set passwordhealthyperiod=0, passwordshelflife=0, maxfailedloginattempt=0, minimumuniquepasswordssequencelength=0 where id<>0;
    update client_users cu set credentialnonexpired=true, status=1 where credentialnonexpired = false;
  3. Restart the qTest service.
  4. Login to qTest and change the password.

 

Note: These scripts will deactivate your current Security Settings and allow you to login to qTest. If you want to use Security Settings again, make sure you change your user's password before enabling Security Settings.

Powered by Zendesk