Uploaded image for project: 'Modules'
  1. Modules
  2. MODULES-7460

puppetlabs-postgresql : INSERT table_grant privilege is reported as Illegal value

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • None
    • None
    • postgresql
    • OS: Debian 9.4

      Puppet: 4.8.2

      puppetlabs-postgresql: 5.6.0

    • Needs Assessment
    • Needs Assessment

    Description

      I am granting the INSERT privilege to a specific user on a specific table using the following code:

              postgresql::server::table_grant { 'INSERT domains of powerdns':
                      privilege => 'INSERT',
                      table     => 'domains',
                      db        => 'powerdns',
                      role      => 'powerdns',
              }
      

      but unfortunately it does not work anymore as I get the following error message back from puppet:

      Error: Could not retrieve catalog from remote server: Error 500 on SERVER: Server Error: Evaluation Error: Error while evaluating a Resource Statement, Evaluation Error: Error while evaluating a Function Call, Illegal value for $privilege parameter at /etc/puppet/code/environments/production/modules/postgresql/manifests/server/grant.pp:257:20 at /etc/puppet/code/environments/production/modules/postgresql/manifests/server/table_grant.pp:15 on node mynode

      It worked fine with version 5.1.0 of this module but the upgrade to version 5.6.0 broke this.

      Thank you very much in advance for fixing this.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              hostingnuggets John Naggets
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Zendesk Support