Stuart Cracraft
2013-Dec-04 21:33 UTC
[Puppet Users] external node classifier with a back-end
Hi everybody! Anyone have a back-ended external node classifier to a Postgres database they could throw my way? Stuart -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/7781bed3-7e5a-46e2-8949-e00bfac0fbd0%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Dan White
2013-Dec-04 22:03 UTC
Re: [Puppet Users] external node classifier with a back-end
Isn''t that what PuppetDB is ? “Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us.” Bill Waterson (Calvin & Hobbes) ----- Original Message ----- From: "Stuart Cracraft" <smcracraft@gmail.com> To: puppet-users@googlegroups.com Sent: Wednesday, December 4, 2013 4:33:51 PM Subject: [Puppet Users] external node classifier with a back-end Hi everybody! Anyone have a back-ended external node classifier to a Postgres database they could throw my way? Stuart -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/7781bed3-7e5a-46e2-8949-e00bfac0fbd0%40googlegroups.com . For more options, visit https://groups.google.com/groups/opt_out . -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/549109965.4863727.1386194590631.JavaMail.root%40sz0126a.westchester.pa.mail.comcast.net. For more options, visit https://groups.google.com/groups/opt_out.
Stuart Cracraft
2013-Dec-04 22:10 UTC
Re: [Puppet Users] external node classifier with a back-end
Hi Ygor/Dan, Postgres has better DR. We like Postgres. Stuart On Wednesday, December 4, 2013 2:03:10 PM UTC-8, Ygor wrote:> Isn''t that what PuppetDB is ? > > “Sometimes I think the surest sign that intelligent life exists elsewhere > in the universe is that none of it has tried to contact us.” > Bill Waterson (Calvin & Hobbes) > > ------------------------------ > *From: *"Stuart Cracraft" <smcra...@gmail.com <javascript:>> > *To: *puppet...@googlegroups.com <javascript:> > *Sent: *Wednesday, December 4, 2013 4:33:51 PM > *Subject: *[Puppet Users] external node classifier with a back-end > > > Hi everybody! > > Anyone have a back-ended external node classifier to a Postgres database > they could throw my way? > > Stuart > > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to puppet-users...@googlegroups.com <javascript:>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/7781bed3-7e5a-46e2-8949-e00bfac0fbd0%40googlegroups.com > . > For more options, visit https://groups.google.com/groups/opt_out. >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/c642f1be-1121-4ab9-b56a-29b54809140f%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Ken Barber
2013-Dec-05 01:52 UTC
Re: [Puppet Users] external node classifier with a back-end
>>> Anyone have a back-ended external node classifier to a Postgres database >>> they could throw my way? >> >> Isn''t that what PuppetDB is ? > > Postgres has better DR. > > We like Postgres.PuppetDB is not an ENC, also FWIW and to be clear it uses PostgreSQL. ken. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/CAE4bNTmVDJW6Sq9SmaH1H-VrwobbYBw6NUc6RJJtsdhYt8tazw%40mail.gmail.com. For more options, visit https://groups.google.com/groups/opt_out.
Dan White
2013-Dec-05 03:38 UTC
Re: [Puppet Users] external node classifier with a back-end
Thanks for that clarification. I was fairly certain it uses PostgreSQL On Dec 4, 2013, at 8:52 PM, Ken Barber <ken@puppetlabs.com> wrote:>>>> Anyone have a back-ended external node classifier to a Postgres database >>>> they could throw my way? >>> >>> Isn''t that what PuppetDB is ? >> >> Postgres has better DR. >> >> We like Postgres. > > PuppetDB is not an ENC, also FWIW and to be clear it uses PostgreSQL. > > ken.-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/786A6AFC-48CE-4B72-A429-CA1B49202B3C%40comcast.net. For more options, visit https://groups.google.com/groups/opt_out.
Stuart Cracraft
2013-Dec-05 04:06 UTC
Re: [Puppet Users] external node classifier with a back-end
And if you do not want to store secretive (complete) company data in PuppetDB but instead an alternative securable database, what then pray tell? -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/E22CF187-0DDD-409E-9784-4F9995215551%40me.com. For more options, visit https://groups.google.com/groups/opt_out.
On Wed, 2013-12-04 at 20:06 -0800, Stuart Cracraft wrote:> And if you do not want to store secretive (complete) company data in > PuppetDB but instead an alternative securable database, what then praytell?> >Your original question wasn''t about security at all. It was much more vague than that, so perhaps you could restate the question more clearly? Going back to your original post, the Puppet Dashboard and/or Foreman are excellent candidates as ENC''s that are backed by Postgresql. Both play nicely if you''re wanting the functionality of Puppetdb as well. However, if your query is about storing data securely, you''re looking at something else entirely such as hiera-gpg or hiera integrated with eyaml - although that''s not an ENC solution, the encryption might be more what you''re after. I''ve had good results using hiera-gpg to store passwords etc., and find editing yaml files and storing them in git a bunch easier than stuffing around in an ENC gui. Alternately if you''re wanting to use something for exported resources, how about encrypting that before exporting it so that what''s stored is secured? Just a thought. To restate previous clarifications - PuppetDB uses a Postgresql database to store data. There''s an api to access it, but it''s reasonably locked down. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/1386219051.6023.14.camel%40debian.my.home. For more options, visit https://groups.google.com/groups/opt_out.
Jason Antman
2013-Dec-05 12:16 UTC
Re: [Puppet Users] external node classifier with a back-end
PuppetDB isn''t an ENC. PuppetDB does, however, use Postgres (unless you use the embedded database, which you shouldn''t). Puppet Dashboard is an ENC, but ironically, uses MySQL not Postgres. Stuart, Starting *another* ENC thread a day later isn''t likely to get you many more responses than the two to your last question. I assumed, given your lack of response to my reply, that you''re not terribly interested in sharing what you need an ENC to do... As I mentioned, I''m working on getting a Python/Django (Postgres-backed) ENC ready for release... if you want to see the current code, that could be arranged, though it''s not really up to the "just run this puppet module and it installs the ENC" stage yet. -jantman On 12/04/2013 05:10 PM, Stuart Cracraft wrote:> Hi Ygor/Dan, > > Postgres has better DR. > > We like Postgres. > > Stuart > > On Wednesday, December 4, 2013 2:03:10 PM UTC-8, Ygor wrote: > > Isn''t that what PuppetDB is ? > > “Sometimes I think the surest sign that intelligent life exists > elsewhere in the universe is that none of it has tried to contact us.” > Bill Waterson (Calvin & Hobbes) > > ------------------------------------------------------------------------ > *From: *"Stuart Cracraft" <smcra...@gmail.com <javascript:>> > *To: *puppet...@googlegroups.com <javascript:> > *Sent: *Wednesday, December 4, 2013 4:33:51 PM > *Subject: *[Puppet Users] external node classifier with a back-end > > > Hi everybody! > > Anyone have a back-ended external node classifier to a Postgres > database > they could throw my way? > > Stuart > > > -- > You received this message because you are subscribed to the Google > Groups "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, > send an email to puppet-users...@googlegroups.com <javascript:>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/7781bed3-7e5a-46e2-8949-e00bfac0fbd0%40googlegroups.com > <https://groups.google.com/d/msgid/puppet-users/7781bed3-7e5a-46e2-8949-e00bfac0fbd0%40googlegroups.com>. > For more options, visit https://groups.google.com/groups/opt_out > <https://groups.google.com/groups/opt_out>. > > -- > You received this message because you are subscribed to the Google > Groups "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to puppet-users+unsubscribe@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/c642f1be-1121-4ab9-b56a-29b54809140f%40googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out.-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/52A06E8A.4040804%40jasonantman.com. For more options, visit https://groups.google.com/groups/opt_out.
Stuart Cracraft
2013-Dec-06 17:59 UTC
Re: [Puppet Users] external node classifier with a back-end
HI Jason, No I have no hesitations at all and yes, I would enjoy seeing your Postgres code and learning from it and can share back. So the thought here is to have all the configuration data, client data, node data, in a Postgres database (the one on the Puppet Master) and used downline by all the various Linux apps which need it, including Puppet. I take it (hopefully) this is not too unusual and bizarre in the world of Puppet. On Thursday, December 5, 2013 4:16:10 AM UTC-8, Jason Antman wrote:> PuppetDB isn''t an ENC. PuppetDB does, however, use Postgres (unless you > use the embedded database, which you shouldn''t). Puppet Dashboard is an > ENC, but ironically, uses MySQL not Postgres. > > Stuart, > > Starting *another* ENC thread a day later isn''t likely to get you many > more responses than the two to your last question. I assumed, given your > lack of response to my reply, that you''re not terribly interested in > sharing what you need an ENC to do... As I mentioned, I''m working on > getting a Python/Django (Postgres-backed) ENC ready for release... if you > want to see the current code, that could be arranged, though it''s not > really up to the "just run this puppet module and it installs the ENC" > stage yet. > > -jantman > > On 12/04/2013 05:10 PM, Stuart Cracraft wrote: > > Hi Ygor/Dan, > > Postgres has better DR. > > We like Postgres. > > Stuart > > On Wednesday, December 4, 2013 2:03:10 PM UTC-8, Ygor wrote: > >> Isn''t that what PuppetDB is ? >> >> �Sometimes I think the surest sign that intelligent life exists >> elsewhere in the universe is that none of it has tried to contact us.� >> Bill Waterson (Calvin & Hobbes) >> >> ------------------------------ >> *From: *"Stuart Cracraft" <smcra...@gmail.com> >> *To: *puppet...@googlegroups.com >> *Sent: *Wednesday, December 4, 2013 4:33:51 PM >> *Subject: *[Puppet Users] external node classifier with a back-end >> >> >> Hi everybody! >> >> Anyone have a back-ended external node classifier to a Postgres database >> they could throw my way? >> >> Stuart >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Puppet Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to puppet-users...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/puppet-users/7781bed3-7e5a-46e2-8949-e00bfac0fbd0%40googlegroups.com >> . >> For more options, visit https://groups.google.com/groups/opt_out. >> > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to puppet-users...@googlegroups.com <javascript:>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/c642f1be-1121-4ab9-b56a-29b54809140f%40googlegroups.com > . > For more options, visit https://groups.google.com/groups/opt_out. > > >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/1909c6a8-9dc8-48bf-a397-f975a82749ac%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Jason Antman
2013-Dec-07 15:22 UTC
Re: [Puppet Users] external node classifier with a back-end
So you''re looking to put Puppet data and "other data" for other applications in ONE database? That doesn''t sound terribly safe... How is this data getting into the database? What types of functionality do you need? Just something like Dashboard with nodes and groups that can have params and classes? Inheritance? Exclusions? If all you want is a database that stores classes/params for nodes, and uses them on a 1:1 basis, this is a trivial problem and is really just an issue of writing a tool to get data into the database. The "hard" part of an ENC is handling things like groups, multiple inheritance, overrides, exclusions, etc. I''m still not clear on the functionality and interface that you want for this, and I''m also unclear on the distinction between what you call "configuration data", "client data" and "node data". -Jason On 12/06/2013 12:59 PM, Stuart Cracraft wrote:> HI Jason, > > No I have no hesitations at all and yes, I would enjoy seeing your > Postgres code > and learning from it and can share back. > > So the thought here is to have all the configuration data, client > data, node data, in > a Postgres database (the one on the Puppet Master) and used downline > by all the various > Linux apps which need it, including Puppet. > > I take it (hopefully) this is not too unusual and bizarre in the world > of Puppet. > > > On Thursday, December 5, 2013 4:16:10 AM UTC-8, Jason Antman wrote: > > PuppetDB isn''t an ENC. PuppetDB does, however, use Postgres > (unless you use the embedded database, which you shouldn''t). > Puppet Dashboard is an ENC, but ironically, uses MySQL not Postgres. > > Stuart, > > Starting *another* ENC thread a day later isn''t likely to get you > many more responses than the two to your last question. I assumed, > given your lack of response to my reply, that you''re not terribly > interested in sharing what you need an ENC to do... As I > mentioned, I''m working on getting a Python/Django > (Postgres-backed) ENC ready for release... if you want to see the > current code, that could be arranged, though it''s not really up to > the "just run this puppet module and it installs the ENC" stage yet. > > -jantman > > On 12/04/2013 05:10 PM, Stuart Cracraft wrote: >> Hi Ygor/Dan, >> >> Postgres has better DR. >> >> We like Postgres. >> >> Stuart >> >> On Wednesday, December 4, 2013 2:03:10 PM UTC-8, Ygor wrote: >> >> Isn''t that what PuppetDB is ? >> >> �Sometimes I think the surest sign that intelligent life >> exists elsewhere in the universe is that none of it has tried >> to contact us.� >> Bill Waterson (Calvin & Hobbes) >> >> ------------------------------------------------------------------------ >> *From: *"Stuart Cracraft" <smcra...@gmail.com> >> *To: *puppet...@googlegroups.com >> *Sent: *Wednesday, December 4, 2013 4:33:51 PM >> *Subject: *[Puppet Users] external node classifier with a >> back-end >> >> >> Hi everybody! >> >> Anyone have a back-ended external node classifier to a >> Postgres database >> they could throw my way? >> >> Stuart >> >> >> -- >> You received this message because you are subscribed to the >> Google Groups "Puppet Users" group. >> To unsubscribe from this group and stop receiving emails from >> it, send an email to puppet-users...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/puppet-users/7781bed3-7e5a-46e2-8949-e00bfac0fbd0%40googlegroups.com >> <https://groups.google.com/d/msgid/puppet-users/7781bed3-7e5a-46e2-8949-e00bfac0fbd0%40googlegroups.com>. >> For more options, visit >> https://groups.google.com/groups/opt_out >> <https://groups.google.com/groups/opt_out>. >> >> -- >> You received this message because you are subscribed to the >> Google Groups "Puppet Users" group. >> To unsubscribe from this group and stop receiving emails from it, >> send an email to puppet-users...@googlegroups.com <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/puppet-users/c642f1be-1121-4ab9-b56a-29b54809140f%40googlegroups.com >> <https://groups.google.com/d/msgid/puppet-users/c642f1be-1121-4ab9-b56a-29b54809140f%40googlegroups.com>. >> For more options, visit https://groups.google.com/groups/opt_out >> <https://groups.google.com/groups/opt_out>. > > -- > You received this message because you are subscribed to the Google > Groups "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to puppet-users+unsubscribe@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/1909c6a8-9dc8-48bf-a397-f975a82749ac%40googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out.-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/52A33D1D.5000702%40jasonantman.com. For more options, visit https://groups.google.com/groups/opt_out.