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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • None
    • sqlserver
    • None
    • Modules
    • Customer Feedback
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Zendesk Support