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
please see [1] for undercloud.conf and full error logs [1] https://paste.fedoraproject.org/paste/AGNXMomnvGHYm5yOr5BGiQ/raw
(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
#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
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