Today I started installing a reverse proxy at $WORK. I choose to follow this way, and all my DNS data is stored in my CMDB. Once again, the solution came from #puppet ! You can embed some “pure” ruby code in ERB templates. And, yes, you can query your database !
<% dbh = DBI.connect("DBI:Mysql:yourbase:mysql.mycorp.com", "you", "XXXX") query = dbh.prepare("your fancy query") query.execute while row = query.fetch do todisplay=some_funny_things() %> <%= todisplay %> <% end %>
I use this technique to generate the dnsmasq data file. Just use the subscribe function and all is done !