/
Changing Database Password

Changing Database Password

Jan 03, 2024

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

Note!

A prerequisite for this to work properly is that the database is only used by the Platform and not by any configurations. 

  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.

  3. Use the command mzsh topo get to list the jdbc parameters.

    $ mzsh topo get -s --format data-only topo://container:<mz.container>/pico:platform/obj:config.properties.mz.jdbc

  4. Use the mzsh topo set command to update the password for mzadmin:

    $ mzsh topo set topo://container:<mz.container>/pico:platform/val:config.properties.mz.jdbc.password `mzsh encryptpassword <new password>`



  5. Shut down the platform using the mzsh shutdown command.


  6. Update the Oracle, PostgreSQL or SAP HANA passwords to correspond to your new mzadmin password.


  7. Startup the Platform.


  8. Enable all workflow groups and start all workflows again.