Page Comparison

Use the procedure below to change the password of the users mzadmin and mzowner in Oracle, PostgreSQL and SAP HANA databases.

1. Disable all workflow groups, either from the Execution Manager in Desktop, or by using the mzsh wfdisable command.
   
   

2. Let all batch workflows finish execution.

   Note
   title Note!
   Batch workflows containing Inter Workflow agents that do not have the Deactivate on Idle check box selected will have to be shutdown manually.

   
   

3. Use the command mzsh topo to list the instances of the the service storage-dispatcher.

   Code Block
   language text theme Eclipse
   $ mzsh topo get --format data-only topo://services:standard/obj:storage-dispatcher

   
   

   Info
   title Example - List of sevice instances
   Code Block language text theme Eclipse { "storage-dispatcher1" : { "config" : { "password" : "DR_DEFAULT_KEY-48851644227183C2041D838568E117EC", "type" : "oracle", "url" : "jdbc:oracle:thin:@myhost:1521:orcl" "user" : "mzadmin" }, "start-after" : [], "template" : "1/standard/oracle" } }

   
   

4. Use the mzsh topo command to update the passwords in the STR:

   Code Block
   language text theme Eclipse
   $ mzsh topo set topo://services:standard/val:storage-dispatcher.<service instance>.\ config.password `mzsh encryptpassword <password>`

   
   

   Info
   title Example - Updating the password(s)
   Code Block language text theme Eclipse $ mzsh topo set topo://services:standard/val:storage-dispatcher.storage-dispatcher1.\ config.password `mzsh encryptpassword mypassword`

   
   

5. Shut down the platform using the mzsh shutdown command.
   
   
6. Update the Oracle, PostgreSQL or SAP HANA passwords to correspond to the ones you set in the STR.
   
   
7. Startup the Platform.
   
   
8. Enable all workflow groups and start all workflows again.