Re: [Puppet Users] Re: use puppet to manage user accounts on mysql

2011-07-11 Thread Gabriel Filion
On 11-07-11 04:43 PM, newguy wrote: > I made a directory in modules named mysql and put the rise up module > in there and I included this module in the nodes.pp that sounds about right. You should be able to create mysql users by adding the first part into the desired nodes (think of it as a res

[Puppet Users] Re: use puppet to manage user accounts on mysql

2011-07-11 Thread newguy
Hey Guys Thanks for this help but I am stuck at a point which might sound lame but is creating problem, I got the above stated mysql puppet riseup module in my module path but I fail to understand where should I write this: mysql_user { "username@host": ensure => present, password

[Puppet Users] Re: use puppet to manage user accounts on mysql

2011-07-11 Thread ew
++1 On Jul 10, 7:13 pm, Nigel Kersten wrote: > This looks like a good opportunity for the various mysql module authors to > all get together and produce one single awesome module :) > > On Sun, Jul 10, 2011 at 3:49 AM, Andrew Thompson wrote: > > > > > > > Take a look at example42's mysql module.

Re: [Puppet Users] Re: use puppet to manage user accounts on mysql

2011-07-10 Thread Nigel Kersten
This looks like a good opportunity for the various mysql module authors to all get together and produce one single awesome module :) On Sun, Jul 10, 2011 at 3:49 AM, Andrew Thompson wrote: > Take a look at example42's mysql module. I use it to change the root > password and create users for eac

Re: [Puppet Users] Re: use puppet to manage user accounts on mysql

2011-07-10 Thread Andrew Thompson
Take a look at example42's mysql module. I use it to change the root password and create users for each of my applications. Look at this specifically: https://github.com/example42/puppet-modules/blob/master/mysql/manifests/grant.pp There is also a "query" define so you can run any query that is po

Re: [Puppet Users] Re: use puppet to manage user accounts on mysql

2011-07-10 Thread Nigel Kersten
On Sun, Jul 10, 2011 at 3:27 AM, newguy wrote: > Hey > I will try to write again what I wanted to say in the first message: > Is it possible through puppet that I install mysql and define what > would be mysql username, password for that client and also I want to > disable root user through puppe

[Puppet Users] Re: use puppet to manage user accounts on mysql

2011-07-10 Thread newguy
Hey I will try to write again what I wanted to say in the first message: Is it possible through puppet that I install mysql and define what would be mysql username, password for that client and also I want to disable root user through puppet, can this be achieved. Thanks On Jul 9, 10:54 pm, Gabr