I''m trying to administer the mysql database on some servers using puppet. When I''m done, I want: *) The DB to have a root password. *) I want to define a few databases, users and grants. Any advice what to use? I want to use the DavidSchmitt-mysql module, but I can''t figure out how to make that work with a password on the root user. Or am I missing something? My OS is Ubuntu if that makes a difference. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
On Fri, Dec 10, 2010 at 5:04 PM, Patrick <kc7zzv@gmail.com> wrote:> *) The DB to have a root password. >Use a preseed template. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
On Fri, Dec 10, 2010 at 6:34 AM, Patrick <kc7zzv@gmail.com> wrote:> I''m trying to administer the mysql database on some servers using puppet. > When I''m done, I want: > > *) The DB to have a root password. > *) I want to define a few databases, users and grants. > > Any advice what to use? >I''ve had good success with https://github.com/blt04/puppet-mysql. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
On Dec 10, 2010, at 5:47 AM, Adam Heinz wrote:> On Fri, Dec 10, 2010 at 6:34 AM, Patrick <kc7zzv@gmail.com> wrote: > I''m trying to administer the mysql database on some servers using puppet. When I''m done, I want: > > *) The DB to have a root password. > *) I want to define a few databases, users and grants. > > Any advice what to use? > > I''ve had good success with https://github.com/blt04/puppet-mysql.How do you set your root password? Preseeding? It looks like setting your (mysql) root password with that module isn''t feasible. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
There''s an exec in this that sets the root password (line 180). https://github.com/blt04/puppet-mysql/blob/master/manifests/classes/server.pp On Fri, Dec 10, 2010 at 3:35 PM, Patrick <kc7zzv@gmail.com> wrote:> > On Dec 10, 2010, at 5:47 AM, Adam Heinz wrote: > > On Fri, Dec 10, 2010 at 6:34 AM, Patrick <kc7zzv@gmail.com> wrote: >> >> I''m trying to administer the mysql database on some servers using puppet. >> When I''m done, I want: >> >> *) The DB to have a root password. >> *) I want to define a few databases, users and grants. >> >> Any advice what to use? > > I''ve had good success with https://github.com/blt04/puppet-mysql. > > How do you set your root password? Preseeding? It looks like setting your > (mysql) root password with that module isn''t feasible. > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to > puppet-users+unsubscribe@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-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Thanks. I didn''t see that. On Dec 10, 2010, at 12:45 PM, Justin Brehm wrote:> There''s an exec in this that sets the root password (line 180). > > https://github.com/blt04/puppet-mysql/blob/master/manifests/classes/server.pp > > > On Fri, Dec 10, 2010 at 3:35 PM, Patrick <kc7zzv@gmail.com> wrote: >> >> On Dec 10, 2010, at 5:47 AM, Adam Heinz wrote: >> >> On Fri, Dec 10, 2010 at 6:34 AM, Patrick <kc7zzv@gmail.com> wrote: >>> >>> I''m trying to administer the mysql database on some servers using puppet. >>> When I''m done, I want: >>> >>> *) The DB to have a root password. >>> *) I want to define a few databases, users and grants. >>> >>> Any advice what to use? >> >> I''ve had good success with https://github.com/blt04/puppet-mysql. >> >> How do you set your root password? Preseeding? It looks like setting your >> (mysql) root password with that module isn''t feasible. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Puppet Users" group. >> To post to this group, send email to puppet-users@googlegroups.com. >> To unsubscribe from this group, send email to >> puppet-users+unsubscribe@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-users@googlegroups.com. > To unsubscribe from this group, send email to puppet-users+unsubscribe@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-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.