templates/default/sql/db_virtual_alias_domain_maps.cf.erb
# Generated by Chef
user = <%= @user %>
password = <%= @password %>
hosts = <%= @host %>
dbname = <%= @dbname %>
query = SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = '%d' and alias.address = CONCAT('%u', '@', alias_domain.target_domain) AND alias.active = true AND alias_domain.active = true