Bug 1150104

Summary:	Packstack fails on mysql installation "Could not open required defaults file: /root/.my.cnf"
Product:	Red Hat OpenStack	Reporter:	Ami Jeain <ajeain>
Component:	openstack-packstack	Assignee:	Martin Magr <mmagr>
Status:	CLOSED ERRATA	QA Contact:	Ami Jeain <ajeain>
Severity:	urgent	Docs Contact:
Priority:	unspecified
Version:	4.0	CC:	aberezin, ajeain, aortega, derekh, whayutin, yeylon
Target Milestone:	z5	Keywords:	Triaged, ZStream
Target Release:	4.0
Hardware:	Unspecified
OS:	Linux
Whiteboard:
Fixed In Version:	openstack-packstack-2013.2.1-0.33.dev1048.el6ost	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-10-22 17:17:40 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:
Bug Blocks:	1083625

Description Ami Jeain 2014-10-07 12:44:26 UTC

Description of problem:


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


How reproducible:
always

Steps to Reproduce:
1. provisioned a RHEL 6.6 machine and run yum update -y
2. run packstack --allinone on a RHEL 6.6 machine
3.

Actual results:

Error: Could not prefetch database_grant provider 'mysql': Execution of '/usr/bin/mysql --defaults-file=/root/.my.cnf mysql -Be describe user' returned 1: Could not open required defaults file: /root/.my.cnf

Expected results:

the installation runs smooth

Additional info:
/root/.my.cnf file doesn't exist anywhere

Comment 1 Martin Magr 2014-10-07 13:02:01 UTC

^[[1;31mError: Could not start Service[mysqld]: Execution of '/sbin/service mysqld start' returned 1: ^[[0m
^[[1;31mError: /Stage[main]//Service[mysqld]/ensure: change from stopped to running failed: Could not start Service[mysqld]: Execution of '/sbin/service mysqld start' returned 1: ^[[0m
^[[mNotice: /Stage[main]//Service[mysqld]: Triggered 'refresh' from 2 events^[[0m
^[[mNotice: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]: Dependency Service[mysqld] has failures: true^[[0m
^[[1;31mWarning: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]: Skipping because of failed dependencies^[[0m
^[[mNotice: /File[/root/.my.cnf]: Dependency Service[mysqld] has failures: true^[[0m
^[[1;31mWarning: /File[/root/.my.cnf]: Skipping because of failed dependencies^[[0m

From log above it is clear that catalog has been compiled so that /root/.my.cnf is created after service start. We have to fix that.

Comment 2 Lon Hohberger 2014-10-07 14:14:53 UTC

We saw this on our tests as well, but it went away - and we're not sure what, if anything, changed.

Comment 7 Martin Magr 2014-10-09 15:28:50 UTC

Patch requires OPM update for puppetlabs-mysql module: https://github.com/redhat-openstack/openstack-puppet-modules/pull/121

Comment 8 Martin Magr 2014-10-09 15:30:37 UTC

Tested on RHEL-6.5 and RHEL-6.6.

Comment 9 Ami Jeain 2014-10-13 09:38:28 UTC

provided the machine details

Comment 10 Martin Magr 2014-10-13 10:07:35 UTC

Note that facter-1.7.4 is also dependency fo this bug.

Comment 11 Martin Magr 2014-10-13 13:11:43 UTC

*** Bug 1149000 has been marked as a duplicate of this bug. ***

Comment 13 Ami Jeain 2014-10-19 11:00:42 UTC

verified in latest puddle

Comment 15 errata-xmlrpc 2014-10-22 17:17:40 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://rhn.redhat.com/errata/RHSA-2014-1691.html