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

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

    XMLWordPrintable

Details

    • New Feature
    • Status: Accepted
    • Normal
    • Resolution: Unresolved
    • None
    • None
    • postgresql
    • CentOS 7 with Software Collection PostgreSQL 9.5

    • 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

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

            Dates

              Created:
              Updated:

              Zendesk Support