5

Puppet: how to use data from a MySQL table in Puppet 3.0 templates?

view full story
linux-howto

http://serverfault.com – I have some data whose source-of-truth is in a MySQL database, size is expected to max out at the some-thousands-rows range (in a worst-case scenario) and I'd like to use puppet to configure files on some servers with that data (mostly iterating through those rows in a template). I'm currently using Puppet 3.0.x, and I cannot change the fact that MySQL will be the authoritative source for that data. Please note, data comes from external sources and not from puppet or from the managed nodes. What possible approaches are there? Which one would you recommend? Would External Node Classifiers be (HowTos)

taskli's picture
Submitted by taskli on 11/27/2012 – Made popular on 11/27/2012

Stories similar to Puppet: how to use data from a MySQL table in Puppet 3.0 templates?

Puppet – Open source data centre automation and configuration management framework ERB – Powerful templating system for Ruby Puppet Recipes – Recipes for configuring Puppet Puppet Dashboard – Web interface and reporting tool for Puppet

Prefix: I searched this out, but the fact that there are any number of things that can cause this problem, I have been unable to find a solution to this particular case.

I have a puppet master (3.0.2-1; RHEL6) and the /etc/puppet/manifests/site.pp file contains the following:

import 'nodes/nodes.pp' $puppetserver = 'puppet.example.dom'

Naturally, the server domain is not what is in use, but ha

I'm running puppet 2.7.9 on a Debian Squeeze system.

I am learning puppet and using this tool install puppet clients on nodes.

puppet node install --login=root --keyfile=~/.ssh/id_rsa --install-script puppet-enterprise --installer-payload ~/puppet/puppet-enterprise-2.7.0-ubuntu-12.04-amd64.tar.gz --installer-answers ~/puppet/installer.answers --puppetagent-certname puppet.node01.example.com 192.168.1.100

Everything seems to work ok.

Puppet agent freeze on Ubuntu 30 weeks 3 days ago

I have 40 Ubuntu 12.04 servers. These servers are managed with puppet. Sometimes I have problem with puppet agent. puppet agent spawn child process (sh) and this process fails. Sh is zombie process. Puppet doesn't work, I must restart puppet agent to make it works.

I use puppet to manage files, packages and services. Problematic agent didn't make any change before fails, server is up to date.

I am new to Puppet and I'm trying to get Puppet to configure my EC2 instances after they're started from a Cloud Formation Template in AWS. The problem is that all the nodes that get started from the Cloud Formation Template all have the same name (the name from the AMI that the new nodes derive from).

I would love to find a way to have puppet rename the nodes when the nodes start up.

Cannot use puppet on mac osx 10.8, i can find it in /usr/bin/lib but display that when i launch it :

/usr/bin/puppet:3:in `require': no such file to load -- puppet/util/command_line (LoadError) from /usr/bin/puppet:3

Any idea ?

Edit : I want to use puppet in Vagrant VM to do provisioning is it the good way ?

Puppet Labs, provider of open source systems management solutions, announced the release of Puppet Enterprise, the first commercially supported version of Puppet.

I want to have puppet run a specific command before performing any type of change. I am aware of the prerun_command option in the main puppet.conf, but this is not what I'm looking for. I want the command to only run if something is about to change, not on every puppet run.

Here's the scenario. Let's say I have a bunch of web servers behind a load balancer.