1 files changed, 31 insertions, 0 deletions
diff --git a/manifests/puppetmaster/hasdb/mysql.pp b/manifests/puppetmaster/hasdb/mysql.pp
new file mode 100644
index 0000000..51fd776
--- /dev/null
+++ b/manifests/puppetmaster/hasdb/mysql.pp
@@ -0,0 +1,31 @@
+# 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",
+    }
+}