Resetting the wcsadmin user password (runtime)

You can reset the default wcsadmin user password (by calling wcs_password).

In the sample IBM Db2 docker image, the default administrator logon ID is wcsadmin, and the default password is wcs1admin. You can change the following statements to update your custom values.

Procedure

  1. Enter the following SQL statement.
     select salt from userreg where logonid='wcsadmin';
    
  2. Open the Utility server Docker container.
  3. Run the following command.
     $ wcs_password password salt merchantKey;
    
    For example:
     $ wcs_password wcs1admin 3h8x876vd8g3 1a1a1a1a1a1a1a1a2b2b2b2b2b2b2b2b
  4. Enter the following SQL statement.
     update userreg 
    set logonpassword=hex_encrypted_version_of_password_output_from_the_wcs_password_script
    where logonid = 'wcsadmin';
    
    For example:
    • DB2
      update userreg 
      set logonpassword=x'534B6E474962776F466D2F5574486666537679732B6862527657665348364654694A56476D2F6C6930564352626E44496573586148387A64736E5151717A2B596D6573302F5941552F36644470513141364A724E2F413D3D' 
      where logonid = 'wcsadmin';
      
      update userreg set status = 1 where logonid='wcsadmin'; 
      
      update userreg set passwordexpired = 1 where logonid='wcsadmin';
    • Oracle
      update userreg
      set logonpassword='534B6E474962776F466D2F5574486666537679732B6862527657665348364654694A56476D2F6C6930564352626E44496573586148387A64736E5151717A2B596D6573302F5941552F36644470513141364A724E2F413D3D'
      where logonid = 'wcsadmin';
      
      update userreg set status = 1 where logonid='wcsadmin';
      
      update userreg set passwordexpired = 1 where logonid='wcsadmin'; 
      
      commit;