Error message appears during OpenStack deployment with Fuel when "Install Murano" checkbox is checked in Fuel Web UI

[Ilya Popov]

MOS 9.0

1. Login to Fuel Dashboard
2. Create new environment
3. Set checkbox "Install Murano" in "Settings" -> "OpenStack Services" of new environment.
4. Leave all other settings with default values.
5. Click "Deploy" to deploy new environment on nodes

Deploy will be stopped with the following error message:

2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/util/errors.rb:106:in `fail'
2016-08-13 18:46:29 ERR Validation of Mysql_grant[murano@Controller1/murano.*] failed: name must match user and table parameters at /etc/puppet/modules/openstacklib/manifests/db/mysql/host_access.pp:40

Full log is the following:

2016-08-13 18:46:29 ERR /usr/bin/puppet:8:in `<main>'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/util/command_line.rb:92:in `execute'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/util/command_line.rb:146:in `run'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/application.rb:381:in `run'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/util.rb:496:in `exit_on_fail'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/application.rb:381:in `block in run'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/application.rb:507:in `plugin_hook'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/application.rb:381:in `block (2 levels) in run'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/application/apply.rb:159:in `run_command'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/application/apply.rb:198:in `main'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet.rb:246:in `override'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/context.rb:64:in `override'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/application/apply.rb:225:in `block in main'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/resource/catalog.rb:404:in `to_ral'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/resource/catalog.rb:512:in `to_catalog'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/resource/catalog.rb:512:in `each'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/resource/catalog.rb:520:in `block in to_catalog'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/resource.rb:349:in `to_ral'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/resource.rb:349:in `new'
2016-08-13 18:46:29 ERR /etc/puppet/modules/mysql/lib/puppet/type/mysql_grant.rb:10:in `initialize'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/type.rb:2225:in `initialize'
2016-08-13 18:46:29 ERR /etc/puppet/modules/mysql/lib/puppet/type/mysql_grant.rb:36:in `block (2 levels) in <top (required)>'
2016-08-13 18:46:29 ERR /usr/lib/ruby/vendor_ruby/puppet/util/errors.rb:106:in `fail'
2016-08-13 18:46:29 ERR Validation of Mysql_grant[murano@Controller1/murano.*] failed: name must match user and table parameters at /etc/puppet/modules/openstacklib/manifests/db/mysql/host_access.pp:40

[Ilya Popov (ilya-p)]

Mysql_grant[murano@Controller1/murano.*] failed to check

in 2016-08-13 18:46:29 ERR /etc/puppet/modules/mysql/lib/puppet/type/mysql_grant.rb:36

fail('name must match user and table parameters') if self[:name] != "#{self[:user]}/#{self[:table]}"

in this row script expect "user/table", it doesn't match "murano@Controller1/murano"

after this row was commented in /etc/puppet/mitaka-9.0/modules/mysql/lib/puppet/type/mysql_grant.rb on fuel masternode, installation continued.

[Oleksiy Molchanov (omolchanov)]

We should update openstacklib module version

[Oleksiy Molchanov (omolchanov)]

Newton is not affected.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/mitaka
Review: https://review.openstack.org/355877

[Nikita Koshikov (nkoshikov)]

Oleksiy, it would be simple for mitaka to just adapt our murano manifest, as it's already done for other services(glance/nova/neutron etc). Why murano is different ?

Here is 2 lines fix:
diff -u db.pp.orig db.pp
--- db.pp.orig 2016-08-16 07:50:36.000000000 -0700
+++ db.pp 2016-08-16 07:50:51.000000000 -0700
@@ -2,7 +2,6 @@

   notice('MODULAR: murano/db.pp')

- $node_name = hiera('node_name')
   $murano_hash = hiera_hash('murano', {})
   $murano_enabled = pick($murano_hash['enabled'], false)
   $mysql_hash = hiera_hash('mysql', {})
@@ -22,7 +21,7 @@
   $db_root_user = pick($murano_hash['root_user'], $mysql_root_user)
   $db_root_password = pick($murano_hash['root_password'], $mysql_root_password)

- $allowed_hosts = [ $node_name, 'localhost', '127.0.0.1', '%' ]
+ $allowed_hosts = [ 'localhost', '127.0.0.1', '%' ]

   validate_string($mysql_root_user)

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/355877
Committed: https://git.openstack.org/cgit/openstack/fuel-library/commit/?id=f3ace65e20da325bbe26c17dc7f6fe487e4ade7b
Submitter: Jenkins
Branch: stable/mitaka

commit f3ace65e20da325bbe26c17dc7f6fe487e4ade7b
Author: Oleksiy Molchanov <email address hidden>
Date: Tue Aug 16 14:57:42 2016 +0300

    Remove node_name from allowed_hosts for Murano

    Remove node_name from allowed_hosts for murano/db task as
    we already have '%'

    Change-Id: Ic2a66707847fcb84cb0029818b5375ee04fb15af
    Closes-Bug: 1612979

[TatyanaGladysheva (tgladysheva)]

Verified on 9.1 snapshot #211.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/newton
Review: https://review.openstack.org/421372

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/421417

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/421372
Committed: https://git.openstack.org/cgit/openstack/fuel-library/commit/?id=31a6715b42dd54e5fcef1e78e04c55281e925dad
Submitter: Jenkins
Branch: stable/newton

commit 31a6715b42dd54e5fcef1e78e04c55281e925dad
Author: Oleksiy Molchanov <email address hidden>
Date: Tue Aug 16 14:57:42 2016 +0300

    [sync/mitaka] Remove node_name from allowed_hosts for Murano

    Remove node_name from allowed_hosts for murano/db task as
    we already have '%'

    Change-Id: Ic2a66707847fcb84cb0029818b5375ee04fb15af
    Closes-Bug: 1612979

[OpenStack Infra (hudson-openstack)]

Change abandoned by Andreas Jaeger (<email address hidden>) on branch: master
Review: https://review.opendev.org/421417
Reason: This repo is retired now, no further work will get merged.