Undercloud DB password is not correctly configured in undercloud-passwords.conf

[Carlos Camacho]

Error:

Connecting to the DB in the Undercloud as root, getting the pass from undercloud-passwords.conf does not work properly.

Reproducible: 100%

How to reproduce:

If you print undercloud-passwords.conf

This is what you will get:

    [stack@undercloud ~]$ cat undercloud-passwords.conf
    [auth]
    undercloud_db_password=3aea80bccd96abd3c8b4c61c029a606107a61e07
    undercloud_admin_token=dbff79c6061d2792b43be9b6c3d73fdab307def4
    undercloud_admin_password=d717ef11685846cf57c41163ccacfb699748b900
    undercloud_glance_password=f94edaef2716038de14761b8a79d325a79050039
    undercloud_heat_encryption_key=1cbfccfcc4fd765f100fce1165c3e566
    undercloud_heat_password=a4352a3e9fcd4b0a86d12fe1ec2e03903c3c2936
    undercloud_heat_cfn_password=f30a145c0836ea611dc24aafc35ccc85a57a0bb8
    undercloud_neutron_password=6f06a63d1b872f38a4c2b2bfb41978cdafe2e135
    undercloud_nova_password=ac80f3cc810fd51195b7c1836b3871ce929cef8e
    undercloud_ironic_password=30aa146e83bf733f98986fb2de176edbb7868412

Now, if you run:

    mysql -u root -p3aea80bccd96abd3c8b4c61c029a606107a61e07

It does not work, and you will get:

    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Now, the code in:

    https://github.com/openstack/instack-undercloud/blob/14fc83c45cc5f58a2de57bab1f82cbb61bc2849e/elements/undercloud-install/os-apply-config/root/tripleo-undercloud-passwords

Configures the same pass for the admin user and the DB but is not what we have in undercloud-passwords.conf

Running:

    mysql -u root@127.0.0.1 -p`sudo hiera admin_password`

Does not work either, so, this password must be overridden somewhere when installing the undercloud.

I want to see if after https://review.openstack.org/#/c/518292/ got merged, we can get correctly the value running:

    mistral environment-get tripleo.undercloud-config

[Carlos Camacho (ccamacho)]

Michele logged the issue here: https://bugs.launchpad.net/tripleo/+bug/1742191