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

Bug 1534550

Summary: [OSP12] Password not required to login as root to MariaDB on the Undercloud
Product: Red Hat OpenStack Reporter: Michele Baldessari <michele>
Component: instack-undercloudAssignee: Michele Baldessari <michele>
Status: CLOSED ERRATA QA Contact: Arik Chernetsky <achernet>
Severity: high Docs Contact:
Priority: medium    
Version: 12.0 (Pike)CC: chjones, dbecker, dciabrin, dyasny, fdinitto, jason.dobies, mbayer, mburns, michele, morazi, nkinder, ohochman, rhel-osp-director-maint, sclewis, slinaber, tvignaud, ushkalim
Target Milestone: z2Keywords: Triaged, ZStream
Target Release: 12.0 (Pike)   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: instack-undercloud-7.4.9-1.el7ost Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1364576 Environment:
Last Closed: 2018-03-28 17:28:51 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:
Bug Depends On: 1364576, 1534552, 1534558    
Bug Blocks:    

Comment 2 Udi Shkalim 2018-03-06 12:27:19 UTC
Verified on: instack-undercloud-7.4.9-1.el7ost.noarch

[root@undercloud-0 ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1519
Server version: 5.5.56-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select user,host,password from mysql.user where user like 'root';
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *A7BA3145EDEC53E9A7F72E12DB9A6D8ADEE4A92E |
+------+-----------+-------------------------------------------+

Comment 5 errata-xmlrpc 2018-03-28 17:28:51 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, 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-2018:0607