manifests/admin_user.pp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

# generate hashed password with:
# ruby -r'digest/sha1' -e 'puts "*" + Digest::SHA1.hexdigest(Digest::SHA1.digest(ARGV[0])).upcase' PASSWORD
define mysql::admin_user(
  $ensure = present,
  $host = '127.0.0.1',
  $password
){
  mysql_user{"${name}@${host}":
    ensure => $ensure,
    password_hash => $password ? {
      'trocla' => trocla("mysql_admin-user_${name}",'mysql'),
      default => $password,
    },
  }
  mysql_grant{"${name}@${host}":
    privileges => 'all',
    require => Mysql_user["${name}@${host}"],
  }
}