summaryrefslogtreecommitdiff
path: root/manifests/master/hasdb/mysql.pp
blob: 5f4985a542aadd8b98fe2997c4b346ba7405bed3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
# don't use this define use the general interface
define puppet::master::hasdb::mysql (
  $dbname = 'puppet',
  $dbhost = 'localhost',
  $dbhostfqdn = $::fqdn,
  $dbuser = 'puppet',
  $dbpwd,
  $dbconnectinghost = 'localhost' )
{
  @@mysql_database { $dbname:
    tag => "mysql_${dbhostfqdn}",
  }

  @@mysql_user { "${dbuser}@${dbconnectinghost}":
    password_hash => mysql_password("$dbpwd"),
    require => Mysql_database[$dbname],
    tag => "mysql_${dbhostfqdn}",
  }

  @@mysql_grant { "${dbuser}@${dbconnectinghost}/${dbname}":
    privileges => all,
    require => Mysql_user["${dbuser}@${dbconnectinghost}"],
    tag => "mysql_${dbhostfqdn}",
  }

  if $puppet::master::manage_munin {
    munin::plugin::deploy { 'puppetresources':
      source => "puppet/munin/puppetresources.mysql",
      config => "env.mysqlopts --user=$dbuser --password=$dbpwd -h $dbhost\nenv.puppetdb $dbname",
    }
  }
}