1044753 – Foreman report error installing with host that contain '-'

Bug 1044753 - Foreman report error installing with host that contain '-'

Summary: Foreman report error installing with host that contain '-'

Keywords:
Status:	CLOSED WONTFIX
Alias:	None
Product:	Red Hat OpenStack
Classification:	Red Hat
Component:	openstack-foreman-installer
Sub Component:
Version:	4.0
Hardware:	Unspecified
OS:	Unspecified
Priority:	medium
Severity:	unspecified
Target Milestone:	---
Target Release:	Installer
Assignee:	Crag Wolfe
QA Contact:	Ami Jeain
Docs Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+	depends on / blocked

Reported:	2013-12-18 22:26 UTC by Steve Reichard
Modified:	2015-05-06 13:40 UTC (History)
CC List:	7 users (show)
Fixed In Version:
Doc Type:	Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed:	2015-05-06 13:40:23 UTC
Target Upstream Version:

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

Description Steve Reichard 2013-12-18 22:26:45 UTC

Description of problem:

When I run foreman_server.sh, on my host rhos-foreman, I get the following error:


Error: Could not prefetch mysql_grant provider 'mysql': Execution of '/usr/bin/mysql --defaults-file=/root/.my.cnf -NBe SHOW GRANTS FOR root.lab.eng.bos.redhat.com;' returned 1: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-foreman.cloud.lab.eng.bos.redhat.com' at line 1


I've had discussions with Mike Orazi, who suggest it is because of the mysql puppet module they use do not adequately quote there paramters.


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


Current version is below, but seen this for a while.



[root@rhos-foreman ~]# cat /etc/redhat-release ; uname -a
Red Hat Enterprise Linux Server release 6.5 (Santiago)
Linux rhos-foreman.cloud.lab.eng.bos.redhat.com 2.6.32-431.1.2.el6.x86_64 #1 SMP Sun Nov 24 09:37:37 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[root@rhos-foreman ~]# yum list installed | grep RHOS
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
augeas.x86_64                        1.0.0-5.el6           @RHOS-4.0            
facter.x86_64                        1.6.6-1.el6_4         @RHOS-4.0            
foreman.noarch                       1.3.0-28.el6sat       @RHOS-4.0            
foreman-installer.noarch             1:1.3.0-1.el6sat      @RHOS-4.0            
foreman-mysql.noarch                 1.3.0-28.el6sat       @RHOS-4.0            
foreman-mysql2.noarch                1.3.0-28.el6sat       @RHOS-4.0            
foreman-proxy.noarch                 1.3.0-3.el6sat        @RHOS-4.0            
foreman-selinux.noarch               1.3.0-1.el6sat        @RHOS-4.0            
hiera.noarch                         1.0.0-3.el6_4         @RHOS-4.0            
libev.x86_64                         4.04-2.el6ost         @RHOS-4.0            
libyaml.x86_64                       0.1.3-1.1.el6         @RHOS-4.0            
mod_passenger.x86_64                 4.0.5-19.el6sat       @RHOS-4.0            
openstack-foreman-installer.noarch   1.0.0-1.el6ost        @RHOS-4.0            
                                                           @RHOS-4.0            
puppet.noarch                        3.2.4-3.el6_5         @RHOS-4.0            
puppet-server.noarch                 3.2.4-3.el6_5         @RHOS-4.0            
ruby-augeas.x86_64                   0.4.1-1.el6_4         @RHOS-4.0            
ruby-shadow.x86_64                   1.4.1-13.el6_4        @RHOS-4.0            
ruby193-facter.x86_64                1.6.18-5.el6ost       @RHOS-4.0            
ruby193-ruby.x86_64                  1.9.3.448-40.1.el6    @RHOS-4.0            
ruby193-ruby-irb.noarch              1.9.3.448-40.1.el6    @RHOS-4.0            
ruby193-ruby-libs.x86_64             1.9.3.448-40.1.el6    @RHOS-4.0            
ruby193-ruby-wrapper.noarch          0.0.2-2.el6sat        @RHOS-4.0            
ruby193-rubygem-actionmailer.noarch  1:3.2.8-6.el6sat      @RHOS-4.0            
ruby193-rubygem-actionpack.noarch    1:3.2.8-15.el6sat     @RHOS-4.0            
ruby193-rubygem-activemodel.noarch   3.2.8-7.el6sat        @RHOS-4.0            
ruby193-rubygem-activerecord.noarch  1:3.2.8-16.el6sat     @RHOS-4.0            
                                     1:3.2.8-7.el6sat      @RHOS-4.0            
ruby193-rubygem-activesupport.noarch 1:3.2.8-10.el6sat     @RHOS-4.0            
ruby193-rubygem-ancestry.noarch      2.0.0-1.el6sat        @RHOS-4.0            
ruby193-rubygem-apipie-rails.noarch  0.0.23-2.el6sat       @RHOS-4.0            
ruby193-rubygem-arel.noarch          3.0.2-7.el6sat        @RHOS-4.0            
ruby193-rubygem-audited.noarch       3.0.0-5.el6sat        @RHOS-4.0            
                                     3.0.0-8.el6sat        @RHOS-4.0            
ruby193-rubygem-bigdecimal.x86_64    1.1.0-40.1.el6        @RHOS-4.0            
ruby193-rubygem-builder.noarch       3.0.0-15.el6sat       @RHOS-4.0            
ruby193-rubygem-bundler.noarch       1.1.4-7.el6sat        @RHOS-4.0            
ruby193-rubygem-bundler_ext.noarch   0.3.0-6.el6sat        @RHOS-4.0            
ruby193-rubygem-coffee-rails.noarch  3.2.2-5.el6sat        @RHOS-4.0            
ruby193-rubygem-coffee-script.noarch 2.2.0-5.el6sat        @RHOS-4.0            
                                     1.3.3-6.el6sat        @RHOS-4.0            
                                     1.1.4-5.el6sat        @RHOS-4.0            
ruby193-rubygem-daemons.noarch       1.1.4-10.el6sat       @RHOS-4.0            
ruby193-rubygem-deface.noarch        0.7.2-7.el6sat        @RHOS-4.0            
ruby193-rubygem-diff-lcs.noarch      1.1.3-11.el6sat       @RHOS-4.0            
ruby193-rubygem-erubis.noarch        2.7.0-14.el6sat       @RHOS-4.0            
ruby193-rubygem-eventmachine.x86_64  0.12.10-11.el6sat     @RHOS-4.0            
ruby193-rubygem-execjs.noarch        1.4.0-8.el6sat        @RHOS-4.0            
ruby193-rubygem-fast_gettext.noarch  0.8.0-3.el6sat        @RHOS-4.0            
ruby193-rubygem-foreigner.noarch     1.4.2-1.el6sat        @RHOS-4.0            
                                     0.0.6-3.el6ost        @RHOS-4.0            
                                     0.10.0-3.el6sat       @RHOS-4.0            
                                     0.0.8-3.el6sat        @RHOS-4.0            
ruby193-rubygem-hike.noarch          1.2.1-6.el6sat        @RHOS-4.0            
ruby193-rubygem-i18n.noarch          0.6.0-9.el6sat        @RHOS-4.0            
ruby193-rubygem-i18n_data.noarch     0.2.7-5.el6sat        @RHOS-4.0            
ruby193-rubygem-io-console.x86_64    0.3-40.1.el6          @RHOS-4.0            
ruby193-rubygem-journey.noarch       1.0.4-4.el6sat        @RHOS-4.0            
ruby193-rubygem-jquery-rails.noarch  2.0.2-6.el6sat        @RHOS-4.0            
                                     4.0.2-8.el6sat        @RHOS-4.0            
ruby193-rubygem-json.x86_64          1.5.5-40.1.el6        @RHOS-4.0            
ruby193-rubygem-mail.noarch          2.4.4-10.el6sat       @RHOS-4.0            
ruby193-rubygem-mime-types.noarch    1.19-1.el6            @RHOS-4.0            
ruby193-rubygem-multi_json.noarch    1.3.6-11.el6sat       @RHOS-4.0            
ruby193-rubygem-mysql.x86_64         2.8.1-5.el6sat        @RHOS-4.0            
ruby193-rubygem-mysql2.x86_64        0.3.11-4.el6sat       @RHOS-4.0            
                                     2.7-5.el6sat          @RHOS-4.0            
ruby193-rubygem-net-ldap.noarch      0.3.1-3.el6sat        @RHOS-4.0            
ruby193-rubygem-nokogiri.x86_64      1.5.6-17.el6sat       @RHOS-4.0            
ruby193-rubygem-oauth.noarch         0.4.7-7.el6sat        @RHOS-4.0            
ruby193-rubygem-passenger.x86_64     4.0.5-19.el6sat       @RHOS-4.0            
                                     4.0.5-19.el6sat       @RHOS-4.0            
                                     4.0.5-19.el6sat       @RHOS-4.0            
ruby193-rubygem-po_to_json.noarch    0.0.7-3.el6sat        @RHOS-4.0            
ruby193-rubygem-polyglot.noarch      0.3.3-6.el6sat        @RHOS-4.0            
ruby193-rubygem-rabl.noarch          0.7.6-6.el6sat        @RHOS-4.0            
ruby193-rubygem-rack.noarch          1:1.4.1-11.el6sat     @RHOS-4.0            
ruby193-rubygem-rack-cache.noarch    1.2-5.el6sat          @RHOS-4.0            
ruby193-rubygem-rack-ssl.noarch      1.3.2-11.el6sat       @RHOS-4.0            
ruby193-rubygem-rack-test.noarch     0.6.1-8.el6sat        @RHOS-4.0            
ruby193-rubygem-rails.noarch         1:3.2.8-5.el6sat      @RHOS-4.0            
ruby193-rubygem-railties.noarch      3.2.8-6.el6sat        @RHOS-4.0            
ruby193-rubygem-rake.noarch          0.9.2.2-40.1.el6      @RHOS-4.0            
ruby193-rubygem-rdoc.x86_64          3.12-26.el6sat        @RHOS-4.0            
ruby193-rubygem-ref.noarch           1.0.0-7.el6sat        @RHOS-4.0            
ruby193-rubygem-rest-client.noarch   1.6.1-8.el6sat        @RHOS-4.0            
ruby193-rubygem-ruby2ruby.noarch     2.0.1-9.el6sat        @RHOS-4.0            
ruby193-rubygem-ruby_parser.noarch   3.1.1-15.el6sat       @RHOS-4.0            
ruby193-rubygem-safemode.noarch      1.2.0-9.el6sat        @RHOS-4.0            
ruby193-rubygem-sass.noarch          3.1.20-6.el6sat       @RHOS-4.0            
ruby193-rubygem-sass-rails.noarch    3.2.5-5.el6sat        @RHOS-4.0            
ruby193-rubygem-scoped_search.noarch 2.5.1-6.el6sat        @RHOS-4.0            
                                     4.1.3-7.el6sat        @RHOS-4.0            
ruby193-rubygem-sprockets.noarch     2.4.5-5.el6sat        @RHOS-4.0            
                                                           @RHOS-4.0            
ruby193-rubygem-thin.x86_64          1.3.1-9.el6sat        @RHOS-4.0            
ruby193-rubygem-thor.noarch          0.15.4-8.el6sat       @RHOS-4.0            
ruby193-rubygem-tilt.noarch          1.3.3-15.el6sat       @RHOS-4.0            
ruby193-rubygem-treetop.noarch       1.4.10-9.el6sat       @RHOS-4.0            
                                     2.2.6-6.el6sat        @RHOS-4.0            
ruby193-rubygem-tzinfo.noarch        0.3.33-6.el6sat       @RHOS-4.0            
ruby193-rubygem-uglifier.noarch      1.2.6-4.el6sat        @RHOS-4.0            
ruby193-rubygem-uuidtools.noarch     2.1.3-6.el6sat        @RHOS-4.0            
ruby193-rubygem-will_paginate.noarch 3.0.2-10.el6sat       @RHOS-4.0            
ruby193-rubygems.noarch              1.8.24-9.el6sat       @RHOS-4.0            
ruby193-runtime.x86_64               1-10.el6              @RHOS-4.0            
ruby193-v8.x86_64                    1:3.14.5.10-2.el6     @RHOS-4.0            
rubygem-clamp.noarch                 0.6.1-10.el6sat       @RHOS-4.0            
rubygem-daemon_controller.noarch     1.1.4-6.el6sat        @RHOS-4.0            
rubygem-fastthread.x86_64            1.0.7-3.el6sat        @RHOS-4.0            
rubygem-foreman_api.noarch           0.1.6-1.el6sat        @RHOS-4.0            
rubygem-highline.noarch              1.6.1-3.el6sat        @RHOS-4.0            
rubygem-json.x86_64                  1.6.8-3.el6sat        @RHOS-4.0            
rubygem-kafo.noarch                  0.0.14-1.el6sat       @RHOS-4.0            
rubygem-little-plugger.noarch        1.1.3-12.el6sat       @RHOS-4.0            
rubygem-logging.noarch               1.8.1-25.el6sat       @RHOS-4.0            
rubygem-mime-types.noarch            1.19-6.el6sat         @RHOS-4.0            
rubygem-multi_json.noarch            1.3.6-11.el6sat       @RHOS-4.0            
rubygem-oauth.noarch                 0.4.7-6.el6sat        @RHOS-4.0            
rubygem-passenger.x86_64             4.0.5-19.el6sat       @RHOS-4.0            
rubygem-passenger-native.x86_64      4.0.5-19.el6sat       @RHOS-4.0            
rubygem-passenger-native-libs.x86_64 4.0.5-19.el6sat       @RHOS-4.0            
rubygem-rack.noarch                  1:1.4.1-10.el6sat     @RHOS-4.0            
rubygem-rack-protection.noarch       1.5.0-3.el6sat        @RHOS-4.0            
rubygem-rake.noarch                  0.9.2.2-40.el6sat     @RHOS-4.0            
rubygem-rdoc.x86_64                  3.12-27.el6sat        @RHOS-4.0            
rubygem-rest-client.noarch           1.6.1-7.el6sat        @RHOS-4.0            
rubygem-rkerberos.x86_64             0.1.1-6.el6sat        @RHOS-4.0            
rubygem-rubyipmi.noarch              0.6.0-3.el6sat        @RHOS-4.0            
rubygem-sinatra.noarch               1:1.3.6-24.el6sat     @RHOS-4.0            
rubygem-tilt.noarch                  1.3.3-14.el6sat       @RHOS-4.0            
[root@rhos-foreman ~]# 




How reproducible:

Each time a re-install for months.


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 4 Martin Magr 2014-07-01 12:25:54 UTC

So I investigated a little bit. Current latest openstack-puppet-modules package has puppetlabs-mysql version 0.9 forked and patched. This version still has database_grant resource [1] instead of mysql_grant . Resource mysql_grant has been introduced by refactor PR [2] later and hence is not part of puppetlabs-mysql installed by openstack-puppet-modules. To me it seems like Foreman installer is using it's own puppetlabs-mysql module. Switching this bug to correct component.

[1] https://github.com/packstack/puppetlabs-mysql/blob/packstack/icehouse/lib/puppet/provider/database_grant/mysql.rb
[2] https://github.com/puppetlabs/puppetlabs-mysql/pull/248

Comment 6 Crag Wolfe 2015-01-05 19:00:05 UTC

I believe that despite the error message the foreman installer completes, i.e. it is more of an annoyance than a blocker.

Comment 7 Arthur Berezin 2015-05-06 13:40:23 UTC

At this phase RHEL-OSP6-Installer does not accept feature enhancements, or Foreman re-bases.

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