David, Are you using PuppetDB? There was a thread on this list recently about the same topic, and there was some example SQL that could be used in the short-term. We have a few open tickets around coming up with better solutions for this and we expect to be addressing them Very Soon Now. If you are using PuppetDB and you are interested in links (to either the tickets or the previous thread) let me know and I'll dig them up.
Thanks! Chris On Thursday, January 31, 2013 10:26:18 AM UTC-8, David Kerr wrote: > > My environment heavily depends on exported resources to detect our mongo > instances and to populate our haproxies. > > When we bring up and down nodes in AWS "puppet node clean" isn't cleaning > up the exported resources so we get ghost > machines loaded into those config files. > > Up until today I've attempted to limp along by doing: > puppet node clean > sudo puppet cert clean > delete from catalog_resources where title like '%<hostname>%' > delete from resource_params where value like '%<hostname>%' > > That's been "pretty good", but today I ran into a problem where even that > didn't work. > > I'm comfortable working in the DB, but what's tough is trying to match the > hashed ID's across tables (the data model doesn't make it exactly clear > what's going on) > > If someone's already tackled this beast and has a script that does it > right, that would be fantastic. > I also understand that this is solved in 3.1, but I'm not too keen on > upgrading to an RC just to > get exported resources working correctly. > > If someone has insight into the data model and can help me fill the gaps > that would be wonderful > > Thanks. > -- 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+unsubscr...@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
