Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 2024227

Summary:	[DDF] After restoring the database we have to set the mysql root passwort once again
Product:	Red Hat OpenStack	Reporter:	Direct Docs Feedback <ddf-bot>
Component:	tripleo-ansible	Assignee:	Juan Larriba <jlarriba>
Status:	CLOSED ERRATA	QA Contact:	myadla
Severity:	low	Docs Contact:
Priority:	medium
Version:	16.2 (Train)	CC:	adahms, astillma, hyunpark, jbadiapa, jlarriba, mariel
Target Milestone:	z2	Keywords:	Reopened, Triaged
Target Release:	16.2 (Train on RHEL 8.4)
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:	tripleo-ansible-0.8.1-2.20211223005854.b33463b.el8ost	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	2069076 2076121 (view as bug list)		Environment:
Last Closed:	2022-04-08 07:47:23 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	2069076, 2076121

Description Direct Docs Feedback 2021-11-17 16:15:54 UTC

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

Comment 1 Juan Badia Payno 2021-11-24 13:32:16 UTC

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.

Comment 10 errata-xmlrpc 2022-03-23 22:12:24 UTC

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