Bug 1580362 - Undercloud deployment ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Summary: Undercloud deployment ERROR 1045 (28000): Access denied for user 'root'@'loca...
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: instack-undercloud
Version: 12.0 (Pike)
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
: ---
Assignee: James Slagle
QA Contact: Arik Chernetsky
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-05-21 11:08 UTC by karan singh
Modified: 2018-05-22 13:40 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-05-22 13:40:04 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description karan singh 2018-05-21 11:08:11 UTC
Description of problem:
On a fresh machine, deploying OSP-12 undercloud throws error 

2018-05-21 06:47:53,832 INFO: Error: Failed to apply catalog: Execution of '/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe SELECT CONCAT(User, '@',Host) AS User FROM mysql.u
ser' returned 1: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Version-Release number of selected component (if applicable):

[stack@refarch-r220-04 ~]$ rpm -qa | grep -i trip
openstack-tripleo-puppet-elements-7.0.5-1.el7ost.noarch
openstack-tripleo-common-7.6.9-3.el7ost.noarch
puppet-tripleo-7.4.8-5.el7ost.noarch
openstack-tripleo-image-elements-7.0.3-1.el7ost.noarch
openstack-tripleo-common-containers-7.6.9-3.el7ost.noarch
python-tripleoclient-7.3.8-1.el7ost.noarch
openstack-tripleo-heat-templates-7.0.9-8.el7ost.noarch
[stack@refarch-r220-04 ~]$

How reproducible:

alwsys

Steps to Reproduce:
1. Setup OSP-12 repositiries 
2. sudo yum install -y python-tripleoclient
3. Create a undercloud.conf file

[DEFAULT]
local_ip = 192.168.120.1/24
network_gateway = 192.168.120.1
local_interface = p1p1
network_cidr = 192.168.120.0/24
masquerade_network = 192.168.120.0/24
dhcp_start = 192.168.120.5
dhcp_end = 192.168.120.25
inspection_interface = br-ctlplane
inspection_iprange = 192.168.120.100,192.168.120.120
inspection_enable_uefi = true
undercloud_debug = true
enable_ui = true
enable_validations = true
scheduler_max_attempts = 4
enabled_drivers = pxe_ipmitool,pxe_drac,pxe_ilo
enabled_hardware_types = ipmi,redfish

4. openstack undercloud install

Actual results:

.....
.....

2018-05-21 06:47:53,832 INFO: Error: Failed to apply catalog: Execution of '/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe SELECT CONCAT(User, '@',Host) AS User FROM mysql.u
ser' returned 1: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

.....
.....

2018-05-21 06:47:54,089 DEBUG: An exception occurred
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/instack_undercloud/undercloud.py", line 1869, in install
    _run_orc(instack_env)
  File "/usr/lib/python2.7/site-packages/instack_undercloud/undercloud.py", line 1383, in _run_orc
    _run_live_command(args, instack_env, 'os-refresh-config')
  File "/usr/lib/python2.7/site-packages/instack_undercloud/undercloud.py", line 620, in _run_live_command
    raise RuntimeError('%s failed. See log for details.' % name)
RuntimeError: os-refresh-config failed. See log for details.
2018-05-21 06:47:54,090 ERROR:
#############################################################################
Undercloud install failed.

Reason: os-refresh-config failed. See log for details.

See the previous output for details about what went wrong.  The full install
log can be found at /home/stack/.instack/install-undercloud.log.

#############################################################################

Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "/usr/lib/python2.7/site-packages/instack_undercloud/undercloud.py", line 1869, in install
    _run_orc(instack_env)
  File "/usr/lib/python2.7/site-packages/instack_undercloud/undercloud.py", line 1383, in _run_orc
    _run_live_command(args, instack_env, 'os-refresh-config')
  File "/usr/lib/python2.7/site-packages/instack_undercloud/undercloud.py", line 620, in _run_live_command
    raise RuntimeError('%s failed. See log for details.' % name)
RuntimeError: os-refresh-config failed. See log for details.
Command 'instack-install-undercloud' returned non-zero exit status 1
[stack@refarch-r220-04 ~]$


Expected results:

Undercloud should get deployed


Additional info:

see full logs here https://paste.fedoraproject.org/paste/AGNXMomnvGHYm5yOr5BGiQ/raw

Comment 1 karan singh 2018-05-21 11:09:11 UTC
please see [1] for undercloud.conf and full error logs


[1] https://paste.fedoraproject.org/paste/AGNXMomnvGHYm5yOr5BGiQ/raw

Comment 2 John Fulton 2018-05-21 11:55:59 UTC
(In reply to karan singh from comment #0)
> On a fresh machine, deploying OSP-12 undercloud throws error 
> 
> 2018-05-21 06:47:53,832 INFO: Error: Failed to apply catalog: Execution of
> '/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe SELECT CONCAT(User,
> '@',Host) AS User FROM mysql.u
> ser' returned 1: ERROR 1045 (28000): Access denied for user
> 'root'@'localhost' (using password: YES)

Was the machine really a fresh install or had you followed [1] to erase the undercloud first and then attempt the reinstall? It looks like the MySQL datbase's root password is set in a way that the installer is not expecting.

[1] https://access.redhat.com/solutions/2210421

Comment 3 karan singh 2018-05-22 13:27:40 UTC
#1 John is right, I cleaned up the undercloud node by following [1] and when I tried to re-deploy undercloud it failed with the message ( i shared above )


#2 When i deploy undercloud on a FRESH machine, it works without issues.


So looks like there is some step missing in the doc [1] which performs absolute cleaning of the database.


what should be the correct way to cleanup undercloud (database) ? 


[1] https://access.redhat.com/solutions/2210421

Comment 4 John Fulton 2018-05-22 13:40:04 UTC
Karan,

Thanks for the update. So it's not a bug in the software but a step missing from the KB article. I added a comment to the KB article to add the missing step. 

 https://access.redhat.com/solutions/2210421

  John


Note You need to log in before you can comment on or make changes to this bug.