Crash when using puppet-mysql 2.2

Bug #1308884 reported by Mark T. Voelker
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Cisco Openstack
Fix Released
High
Mark T. Voelker
puppet-ceilometer
Fix Released
Undecided
Mark T. Voelker

Bug Description

When using puppetlabs-mysql 2.2 with the ceilometer module, I'm seeing a crash due to missing information in one of the calls to the mysql module that sets up grants on the database:

Error: Validation of Mysql_grant[ceilometer@%/ceilometer] failed: table parameter is required. at /usr/share/puppet/modules/ceilometer/manifests/db/mysql/host_access.pp:29
Wrapped exception:
table parameter is required.

The fix is to change:

https://github.com/stackforge/puppet-ceilometer/blob/master/manifests/db/mysql/host_access.pp#L25-L29

From:

    mysql_grant { "${user}@${name}/${database}":
      privileges => 'all',
      provider => 'mysql',
      require => Mysql_user["${user}@${name}"]
    }

To:

    mysql_grant { "${user}@${name}/${database}":
      privileges => 'all',
      provider => 'mysql',
      table => "${database}.*",
      user => "${user}@${name}",
      require => Mysql_user["${user}@${name}"]
    }

Changed in puppet-ceilometer:
status: New → In Progress
assignee: nobody → Mark T. Voelker (mvoelker)
Revision history for this message
Openstack Gerrit (openstack-gerrit) wrote : Fix proposed to puppet-ceilometer (master)

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

Revision history for this message
Openstack Gerrit (openstack-gerrit) wrote : Fix merged to puppet-ceilometer (master)

Reviewed: https://review.openstack.org/88185
Committed: https://git.openstack.org/cgit/stackforge/puppet-ceilometer/commit/?id=f444fc8937a6bc05d0257c1a935e742491e94b02
Submitter: Jenkins
Branch: master

commit f444fc8937a6bc05d0257c1a935e742491e94b02
Author: Mark T. Voelker <email address hidden>
Date: Thu Apr 17 03:16:00 2014 -0400

    Add table to mysql_grant call

    When using puppetlabs-mysql 2.2 with the ceilometer module, an
    error occurs due to a call to mysql_grant not specifying a table.
    This patch corrects the error by rectifying the mysql_grant call.

    Change-Id: I0619446907c5fb51dcdb6e5717faeb61442c699b
    Closes-Bug: #1308884

Changed in puppet-ceilometer:
status: In Progress → Fix Committed
Changed in openstack-cisco:
status: New → Fix Committed
milestone: none → i.0
assignee: nobody → Mark T. Voelker (mvoelker)
importance: Undecided → High
Changed in openstack-cisco:
status: Fix Committed → Fix Released
Mathieu Gagné (mgagne)
Changed in puppet-ceilometer:
milestone: none → 4.0.0
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.