diff options
author | Silvio Rhatto <rhatto@riseup.net> | 2013-04-12 17:12:53 -0300 |
---|---|---|
committer | Silvio Rhatto <rhatto@riseup.net> | 2013-04-12 17:12:53 -0300 |
commit | 1be2228d5650b42d77774992ebaa3ccbe822ce35 (patch) | |
tree | 6336b151e1d756450c8114f39706222187f9af1b /manifests/instance.pp | |
download | puppet-database-1be2228d5650b42d77774992ebaa3ccbe822ce35.tar.gz puppet-database-1be2228d5650b42d77774992ebaa3ccbe822ce35.tar.bz2 |
Initial import
Diffstat (limited to 'manifests/instance.pp')
-rw-r--r-- | manifests/instance.pp | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/manifests/instance.pp b/manifests/instance.pp new file mode 100644 index 0000000..2523e28 --- /dev/null +++ b/manifests/instance.pp @@ -0,0 +1,26 @@ +# Database definitions +define database::instance( + $password, + $ensure = 'present', + $privileges = "all" +) { + include mysql::server + + mysql_database { "${name}": + ensure => $ensure, + require => Service['mysql'], + } + + mysql_user { "${name}@%": + ensure => $ensure, + password_hash => mysql_password($password), + require => Mysql_database["${name}"], + } + + if $ensure == 'present' { + mysql_grant { "${name}@%/${name}": + privileges => $privileges, + require => Mysql_user["${name}@%"], + } + } +} |