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

postgresql : pass env values to validate_db_connection in postgresql::service

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Accepted
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: postgresql
    • Environment:

      CentOS 7 with Software Collection PostgreSQL 9.5

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

      Description

      Basic Info
      Module Version: 4.9.0
      Puppet Version: 4.10 (puppet-agent 1.10)
      OS Name/Version: CentOS/RedHat Enterprise Linux 7

      I've tried to install PuppetDB with PostgreSQL 9.5 from SoftwareCollections. This worked out mostly fine after i've figured out all postgresql::globals params.
      Example puppet manifest: https://gist.github.com/vinzent/448fa47032a6f050fb4c501cc741ccad#file-puppetdb-postgresql-9-5-example-pp

      The only missing failing class was postgresql::service with the Postgresql::Validate_db_connection['validate_service_is_running'] resource. It was missing the LD_LIBRARY_PATH environment variable.

      I've edited manifests/server/service.pp so it passes postgresql::server::default_connect_settings as connect_settings param to this resource.

      Proposed patch: https://gist.github.com/vinzent/448fa47032a6f050fb4c501cc741ccad#file-postgresql-service-validate_db_connection-patch

      Desired Behavior:
      Connection validation works

      Actual Behavior:
      Connection validation fails

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            Raffaello Thomas Mueller
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Zendesk Support