Module works great! Thx! I made some slight mods to it for my environment but works great.
On Wed, May 19, 2010 at 11:44 AM, Ken <k...@bob.sh> wrote: > > I found a github reference to a package that might do it ( > http://github.com/camptocamp/puppet-mysql) but I can't understand > > what it is, how it works, or even what to do with it. > > Hmm. How familiar are you with puppet modules? Not quite clear how > detailed we need to be here :-). Here is a doc that outlines them: > http://docs.puppetlabs.com/guides/modules.html > > Ordinarily you would drop this code into your 'module path' (by > default this is often /etc/puppet/modules). This would make it > available then for use in other code/manifests. > > Assuming you are already okay with these aspects of puppet - here is a > sample manifest on how to use it for 1 system. I have a fork of that > code (its been around - I'm not even clear who wrote it first - could > have been David Schmidt: http://git.black.co.at/?p=module-mysql;a=summary) > so it may not work exactly the same :-). > > mysql_database { > "drupal": > ensure => present; > "bugzilla": > ensure => present; > "wpmu": > ensure => present; > } > mysql_user { > "dru...@localhost": > password_hash => mysql_password("foo"); > "bugzi...@localhost": > password_hash => mysql_password("foo"); > "w...@localhost": > password_hash => mysql_password("foo"); > } > mysql_grant { > "dru...@localhost/drupal": > privileges => [ > "select_priv", "insert_priv", > "update_priv", "delete_priv", > "create_priv", "drop_priv", > "index_priv", "alter_priv", > ], > require => Mysql_user["dru...@localhost"]; > "bugzi...@localhost/bugzilla": > privileges => [ > "select_priv", "insert_priv", > "update_priv", "delete_priv", > "create_priv", "drop_priv", > "index_priv", "alter_priv", > ], > require => Mysql_user["bugzi...@localhost"]; > "w...@localhost/wpmu": > privileges => [ > "select_priv", "insert_priv", > "update_priv", "delete_priv", > "create_priv", "drop_priv", > "index_priv", "alter_priv", > ], > require => Mysql_user["w...@localhost"]; > } > > This would in effect: > > * create 3 databases - drupal, bugzilla, wpmu > * create 3 users - drupal, bugzilla, wpmu > * assign grant access for the users to the db's of the same name > > ken. > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To post to this group, send email to puppet-us...@googlegroups.com. > To unsubscribe from this group, send email to > puppet-users+unsubscr...@googlegroups.com<puppet-users%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-us...@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.