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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • None
    • None
    • mysql
    • None

    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

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

            Dates

              Created:
              Updated:
              Resolved:

              Zendesk Support