After restoring the database we have to set the mysql root passwort once again. i noticed that after restoring the undercloud database the backup process failed. It failed because it uses the password from hieradata. And these are the steps to set the password to the correct one: - Determining the password: root@director~ # hiera -c /etc/puppet/hiera.yaml mysql::server::root_password - Setting the password: root@director ~ # podman exec -ti mysql bash bash-4.4$ mysqladmin -u root password Reported by: rhn-support-tmicheli https://access.redhat.com/documentation/en-us/red_hat_openstack_platform/16.2/html/backing_up_and_restoring_the_undercloud_and_control_plane_nodes/assembly_restoring-the-undercloud-and-control-plane-nodes_br-undercloud-ctlplane#annotations:6d39c4db-4fca-456d-be2a-22be9813fd9a
As can be seen at [1], the password of the root user is not backed up. [1] - https://github.com/openstack/tripleo-ansible/blob/stable/train/tripleo_ansible/roles/backup-and-restore/backup/tasks/db_backup.yml#L130 As a workaround and it's being suggested on the BZ. Which is setting back the password of the user root.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (Release of components for Red Hat OpenStack Platform 16.2.2), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2022:1001