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

puppetlabs-postgresql : Notice appears every puppet run on grant revoke (ensure: absent).

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: postgresql
    • Labels:
      None
    • Environment:
      • PE 2016.4.11
      • CentOS 7.5
      • Postgres 9.6

       

    • Template:
      MODULES Bug Template
    • Team:
      Modules
    • Method Found:
      Needs Assessment
    • QA Risk Assessment:
      Needs Assessment

      Description

      We're using the postgres module to grant and revoke permissions.

      Granting permissions run fine, notice once if the grant doesn't exist. But when revoking permissions the revoke is executed every puppet run, even if the grant already has been revoked.

      Config: 
      ensure: absent
      db: "%{::project}"
      role: xxxx
      privilege: CREATE
      object_type: SCHEMA
      object_name: public
      Notice: /Stage[main]/Postgresql_wrapper::Config/Postgresql::Server::Grant[Revoke blah blah]/Postgresql_psql[grant:Revoke blah blah]/command: command changed 'notrun' to 'REVOKE CREATE ON SCHEMA "public" FROM "xxxx"'

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            xirixiz Bram
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Zendesk Support