Resetting accounts

If a WebSphere Commerce account gets locked or disabled for some reason, an administrator can unlock or enable the account.

1. Resetting a Site Administrator's account

   1. Connect to your WebSphere Commerce database.

   2. Run the following SQL statements

      UPDATE USERREG SET STATUS=1, PASSWORDRETRIES=0 WHERE LOGONID='logonId';
       commit;
      
      
      

      I5/OS: To enter SQL statements, use either the DB2/400 Query Manager and the SQL development kit, or use iSeries Navigator. To use iSeries Navigator to perform database queries:

      1. Start iSeries Navigator from the PC where it is installed.

      2. Expand the iSeries system. Expand Databases, right-click the Relational Database, and select Run SQL Scripts. The Run SQL Scripts window opens.

      3. From the Connection menu, select JDBC Setup. Click the Server tab.

      4. In the Default libraries field, erase any existing values and enter the name of the database schema of your instance. By default the schema name is the name of the instance. Click OK to save your changes.

      5. Type the preceding SQL statement in the window.

      where logonId is the user ID of the account that you want to reset (for example, wcsadmin).

   3. Disconnect from the database.

2. Resetting other user accounts, if the account is not a Site Administrator's account:

   1. Open the Organization Administration Console.

   2. Click Access Management > Users.

   3. Double-click the user account or select the user account from the list and click Change.

   4. Enabled in the Account status field.

   5. Click OK.

3. Resetting the wcsadmin user's password:
   By default the administrator logon id and password are wcsadmin. You can reset the password for the wcsadmin user if the following statements are true:

   1. You are using a new instance, not a migrated instance.

   2. You did not change the merchant key from its default value.

   After the wcsadmin user's password has been reset, it will become expired and must be changed the next time the wcsadmin user logs on.

   • Stop your test environment.

   • From a Windows command window, navigate to the WCDE_installdir\bin directory, where WCDE_installdir is the installation directory of your development environment.

   • Type ij.bat to use a command line utility to access your Cloudscape database.

   • At the ij > prompt, type connect '..\db\mall';

   • Enter the following SQL statements in order

     update userreg set logonpassword = x'74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020' where logonid='wcsadmin'; 
     
     update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin'; 
     
     update userreg set status = 1 where logonid='wcsadmin'; 
     
     update userreg set passwordexpired = 0 where logonid='wcsadmin'; 
     
     
     

   • Type exit; to exit the ij utility.

   • Restart your test environment.

   
   From a DB2 command window, connect to your database. Enter the following SQL statements in order

   update userreg set logonpassword = x'74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020' where logonid='wcsadmin'; 
   
   update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin'; 
   
   update userreg set status = 1 where logonid='wcsadmin'; 
   
   update userreg set passwordexpired = 0 where logonid='wcsadmin'; 
   
   
   

   Type exit to close the DB2 command window.
   

   (Oracle) To reset the wcsadmin user's password to wcsadmin:

   1. Open an SQLPlus command window using the user name and password for your WebSphere Commerce database.

   2. Enter the following SQL statements in order

      update userreg set logonpassword = x'74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020' where logonid='wcsadmin'; 
      
      update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin'; 
      
      update userreg set status = 1 where logonid='wcsadmin'; 
      
      update userreg set passwordexpired = 0 where logonid='wcsadmin';
      
      commit;
      
      
      

   3. Exit from the SQLPlus command window.

4. Resetting the wcsadmin user's password on runtime (calling wcs_password):

   By default the administrator logon id and password are wcsadmin. You can change the statements below to reflect your administrator logon id if you have changed it from the default logon id.

   • Enter the following SQL statements in order

     select salt from userreg where logonid='wcsadmin';
     
     $ wcs_password 'hsdbacehyoyn' <merchant key>;
     
     update userreg set logonpassword=x'74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020';
     
     
     

 

Related Concepts

Quick reference to user IDs, passwords, and Web addresses