Bug 1580362
| Summary: | Undercloud deployment ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) | ||
|---|---|---|---|
| Product: | Red Hat OpenStack | Reporter: | karan singh <karan> |
| Component: | instack-undercloud | Assignee: | James Slagle <jslagle> |
| Status: | CLOSED NOTABUG | QA Contact: | Arik Chernetsky <achernet> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 12.0 (Pike) | CC: | aschultz, dbecker, johfulto, karan, mburns, morazi |
| Target Milestone: | --- | Keywords: | Triaged, ZStream |
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2018-05-22 13:40:04 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
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 |
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