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

sqlserver module, documentation: Advanced Example using the hostname fact has issues

    Details

    • QA Risk Assessment:
      Needs Assessment

      Description

      Ticket raised on behalf of PE customer using our sqlserver module.

      The customer had an issue when they followed the modules advanced example: https://forge.puppet.com/puppetlabs/sqlserver#advanced-example

      Like the example, the customer tried to use the hostname fact when assigning a user to a role.

      However, this didn’t work and the customer had to specifically use the Uppercase domain shortname rather than the hostname fact as below:

       

      $short_domain_name = 'MYCOMPANY'
      sqlserver::config { $instancename: 
      admin_login_type => 'WINDOWS_LOGIN'
      sqlserver::login{ "${short_domain_name}\\${puppet_mgt_account}"
      instance => $instancename, 
      login_type => 'WINDOWS_LOGIN'
      require => Sqlserver::Config[$instancename], 
      sqlserver::role { 'serveradmin'
      ensure => present, 
      instance => $instancename, 
      type => 'SERVER'
      members => ["${short_domain_name}\\${puppet_mgt_account}", $facts['id']], 
      require => Sqlserver::Login["${short_domain_name}\\${puppet_mgt_account}"], 
      }
      

       

       

      The customer feels that this needs to be documented or there needs to be an engineering effort to account for this.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                william.hurt William Hurt
                Reporter:
                patrick.grant Patrick Grant
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Zendesk Support