Ask Your Question

How to get puppet to read and write to RDBMs?

asked 2013-10-16 16:42:37 -0500

Red Cricket gravatar image

I have a situation where there is a manual process that I'd like to be able to automate with puppet. Currently the change of events is this:

  1. A user changes the IP address of WINS server in my DNS database.
  2. A user now needs to update a record in my DHCP database
  3. DHCP servers get updated information about change in the to the DHCP database

How could one use puppet to automate step 2? Can a puppet master detect a change to RDBM's table? And then make configuration changes to puppet agents based on this detected change?

Does ... (more)

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2013-10-16 18:19:07 -0500

Ancillas gravatar image

I think you'd want to write your own Puppet types to model your resources to detect changes and manage the state of them. Then, you could use PuppetDB and exported resources to trigger steps 2 and 3 respectively.

I suppose you could forego writing Puppet types and instead call batch scripts with an Exec, but then you'd have to script out a way for Puppet to detect that your DNS database had changed.

This is pretty high-level, but hopefully it points you in the right direction to continue researching.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower


Asked: 2013-10-16 16:42:37 -0500

Seen: 76 times

Last updated: Oct 16 '13