summaryrefslogtreecommitdiff
path: root/templates/virtual/database/mysql_virtual_alias_domain_maps.cf.erb
diff options
context:
space:
mode:
Diffstat (limited to 'templates/virtual/database/mysql_virtual_alias_domain_maps.cf.erb')
-rw-r--r--templates/virtual/database/mysql_virtual_alias_domain_maps.cf.erb5
1 files changed, 5 insertions, 0 deletions
diff --git a/templates/virtual/database/mysql_virtual_alias_domain_maps.cf.erb b/templates/virtual/database/mysql_virtual_alias_domain_maps.cf.erb
new file mode 100644
index 0000000..1edf8e3
--- /dev/null
+++ b/templates/virtual/database/mysql_virtual_alias_domain_maps.cf.erb
@@ -0,0 +1,5 @@
+user = <%= scope.lookupvar('mail::virtual::database_user') %>
+password = <%= scope.lookupvar('mail::virtual::database_password') %>
+hosts = <%= scope.lookupvar('mail::virtual::database_host') %>
+dbname = <%= scope.lookupvar('mail::virtual::database_name') %>
+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 = 1 AND alias_domain.active='1'