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

mysql : mysql_user empty password is not idempotent

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: mysql
    • Labels:
      None
    • Environment:

      puppetlabs-mysql 5.3.0 Puppet 5.3.3 on RHEL 7.

    • Template:
      MODULES Bug Template
    • Epic Link:
    • Team:
      Modules
    • Method Found:
      Needs Assessment
    • QA Risk Assessment:
      Needs Assessment

      Description

      Leaving the password undefined in mysql::db results in Puppet constantly wanting to set the password as an empty string.

      Example code:

       

      mysql_user { 'webapp_test@%':
        ensure => 'present',
        password_hash => mysql_password(undef),
      }

       

      Example output:

       

      [root@dbsys01 ~]# puppet apply test.pp 
      Notice: Compiled catalog for dbsys01.DOMAIN in environment production in 0.06 seconds
      Notice: /Stage[main]/Main/Mysql_user[webapp_test@%]/ensure: created
      Notice: Applied catalog in 0.46 seconds
       
      [root@dbsys01 ~]# puppet apply test.pp 
      Notice: Compiled catalog for dbsys01.DOMAIN in environment production in 0.06 seconds
      Notice: /Stage[main]/Main/Mysql_user[webapp_test@%]/password_hash: defined 'password_hash' as ''
      Notice: Applied catalog in 0.45 seconds

       

      Resource from "puppet resource mysql_user":

      mysql_user { 'webapp_test@%':
        ensure                   => 'present',
        max_connections_per_hour => '0',
        max_queries_per_hour     => '0',
        max_updates_per_hour     => '0',
        max_user_connections     => '0',
        tls_options              => ['NONE'],
      }
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            treydock Trey Dockendorf
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Zendesk Support