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

puppetlabs/sqlserver: jruby exception for "templates/create/user/permission.sql.erb"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sqlserver
    • Labels:
      None
    • Template:
      MODULES Bug Template
    • Team:
      Modules
    • Method Found:
      Customer Feedback
    • QA Risk Assessment:
      Needs Assessment

      Description

      Basic Info

      MSSQL manifest to create/manage database `MQSQL 2017` using module "puppetlabs/sqlserver - Ver 2.5.0" is not working with `Win Agent node`.

      Module Version:  2.5.0. 
      Puppet Version: PE 2019.1.1
      OS Name/Version:
      Win Server 2016 ( agent)
      RHEL 7.3 ( master)

      Describe your issue in as much detail as possible...

      Customer is getting an error message when running mssql manifest to create/manage MQSQL 2017 using module "puppetlabs/sqlserver"

      ```
      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, Failed to parse template sqlserver/create/user/permission.sql.erb:

      Filepath: org/jruby/RubyString.java

      Line: 1829

      Detail: can't modify frozen String

      (file: /etc/puppetlabs/code/environments/production/modules/sqlserver/manifests/user/permissions.pp, line: 51, column: 19) (file: /etc/puppetlabs/code/environments/production/site/mssql/manifests/init.pp, line: 223)
      ```

      Steps to reproduce:

      • Manifest file for Master node:

        ```
        node d9zptv23hgj08r7.delivery.puppetlabs.net
        Unknown macro: { sqlserver_instance Unknown macro}
        sqlserver::config
        Unknown macro: { 'MSSQLSERVER'}
        sqlserver::database
        Unknown macro: { 'testdb'}
        sqlserver::login
        Unknown macro: { 'vagrant'}
        sqlserver::user
        Unknown macro: { 'testdb-vagrant'}
        sqlserver::user::permissions
        Unknown macro: { 'SELECT-testdb-vagrant'}
        }
        ```

        Error message:
        ```
        2019-09-15T21:12:15.707-07:00 ERROR [qtp1159967607-83] [puppetserver] Puppet Evaluation Error: Error while evaluating a Resource Statement, Evaluation Error: Error while evaluating a Function Call, Failed to parse template sqlserver/create/user/permission.sql.erb:
        Filepath: org/jruby/RubyString.java
        Line: 1829
        Detail: can't modify frozen String
        (file: /etc/puppetlabs/code/environments/production/modules/sqlserver/manifests/user/permissions.pp, line: 51, column: 19) (file: /etc/puppetlabs/code/environments/production/manifests/site.pp, line: 49) on node d9zptv23hgj08r7.delivery.puppetlabs.net
        ```

       

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              william.hurt William Hurt
              Reporter:
              maheswaran Maheswaran Shanmugam
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Zendesk Support