summaryrefslogtreecommitdiff
path: root/manifests/puppetmaster/hasdb/mysql.pp
blob: 322bf69050c1bd400fefac562bfeab8c3738bceb (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
# don't use this define use the general interface
define puppet::puppetmaster::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}",
  }

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