Saturday 9 February 2013

Resetting the wcsadmin user password (Developer)

Procedure
  1. Stop your test environment.
  2. From a Windows command window, navigate to the WCDE_installdir\bin directory, where WCDE_installdir is the installation directory of your development environment.
  3. Depending on your database, perform the following:
    1.  For Derby:
      1. Type ij.bat to use a command line utility to access your Cloudscape database.
      1. At the ij > prompt, type connect '..\db\mall';
      1. 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';
      2. Type exit; to exit the ij utility.
      3. Restart your test environment.