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

Invalid parameter provider on Mysql_user[user@localhost] in mysql::db

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: mysql
    • Labels:
      None
    • Template:

      Description

      When following the provided instructions for creating a database,

      mysql::db { 'mydb':
        user     => 'myuser',
        password => 'mypass',
        host     => 'localhost',
        grant    => ['SELECT', 'UPDATE'],
      }
      

      the configured node(s) fail to compile their catalog with the following error:

      Invalid parameter provider on Mysql_user[myuser@localhost]
      

      mysql/manifests/db.pp line 38 shows:

        $user_resource = {
          ensure        => $ensure,
          password_hash => mysql_password($password),
          provider      => 'mysql',
        }
        ensure_resource('mysql_user', "${user}@${host}", $user_resource)
      

      Removing this provider line from db.pp allows the catalog to compile successfully and creates the database, user, and grants as expected.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            RyanB Ryan Bethke
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Zendesk Support