Removing customized MariaDB passwords for system updates

During updates of Resource Manager, customers who are using customized MariaDB passwords experience failures (ZEN-32036). Use this procedure to restore the default passwords, perform the update, and then customize the passwords again.

Log in to the Control Center master host as a user with serviced CLI privileges.
Stop Resource Manager services.
1. Check the status of Zenoss services.
```
serviced service status Zenoss.resmgr/Zenoss  --show-fields 'Name,ServiceID,Status'
```
  - If the status of Zenoss services is stopped, continue to the next step.
  - If the status is started, perform the next substep.
2. Stop Zenoss services.
```
serviced service stop Zenoss.resmgr/Zenoss
```
Start Infrastructure services.
1. Check the status of Infrastructure services.
```
serviced service status Zenoss.resmgr/Infrastructure --show-fields 'Name,ServiceID,Status'
```
  - If the status of Infrastructure services is started, continue to the next step.
  - If the status is stopped, perform the next substep.
2. Start Infrastructure services.
```
serviced service start Zenoss.resmgr/Infrastructure
```

Store the customized passwords in a text file.

serviced service list Zenoss.resmgr | awk '/(zep|zodb).*-password/' > origDBpasswords.txt

Follow the procedure for changing MariaDB passwords, replacing the customized passwords with the defaults.

You need to use the customized password to log in:

mysql -uroot -pPASSWORD
Example: myslq -uroot -p26D72357829DF94B817311

Use the following commands to set the passwords for both mariadb-model and mariadb-events:

SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('');
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('');
SET PASSWORD FOR 'zenoss'@'127.0.0.1' = PASSWORD('zenoss');
SET PASSWORD FOR 'zenoss'@'%' = PASSWORD('zenoss');

Likewise, the values in global.conf need to be reset:

global.conf.zep-admin-password
global.conf.zep-password zenoss
global.conf.zodb-admin-password
global.conf.zodb-password zenoss

If you are unable to edit global.conf through the Control Center browser interface, use the following command to edit the JSON file:
```
serviced service edit Zenoss.resmgr
```

Update Resource Manager.
Follow the procedure for changing MariaDB passwords, restoring your customized passwords.

Stop and restart Resource Manager.

serviced serviced stop Zenoss.resmgr && serviced service start Zenoss.resmgr